[
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)
