hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lefty Leverenz (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-1180) Support Common Table Expressions (CTEs) in Hive
Date Fri, 07 Feb 2014 00:19:20 GMT

    [ https://issues.apache.org/jira/browse/HIVE-1180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13894022#comment-13894022
] 

Lefty Leverenz commented on HIVE-1180:
--------------------------------------

This needs to be documented in the wiki.  Is it only for SELECT statements?

Wikipedia says it's for SELECT, INSERT, UPDATE (not an issue here), or DELETE.  The PostgreSQL
doc just says SELECT.

If it's just SELECT, it can be a new section in the Select doc or a separate section linked
from Select like the Group By, Sort/Order/Cluster/Distribute, and Join docs.

Quick ref:

* [Language Manual:  Select |https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select]
* [Wikipedia:  Common table expression |http://en.wikipedia.org/wiki/Common_table_expressions#Common_table_expression]
* [PostgreSQL CTE readme |http://wiki.postgresql.org/wiki/CTEReadme]

> Support Common Table Expressions (CTEs) in Hive
> -----------------------------------------------
>
>                 Key: HIVE-1180
>                 URL: https://issues.apache.org/jira/browse/HIVE-1180
>             Project: Hive
>          Issue Type: Improvement
>          Components: Query Processor
>            Reporter: Jeff Hammerbacher
>            Assignee: Harish Butani
>             Fix For: 0.13.0
>
>         Attachments: HIVE-1180.1.patch, HIVE-1180.3.patch, HIVE-1180.6.patch
>
>
> I've seen some presentations from the PostgreSQL recently expounding the utility of CTEs
(http://en.wikipedia.org/wiki/Common_table_expressions). Should we try to support these in
Hive? I've never used them in practice, so curious to hear if the community would find them
useful.



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)

Mime
View raw message