[
https://issues.apache.org/jira/browse/HIVE-1180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13887061#comment-13887061
]
Harish Butani commented on HIVE-1180:
-------------------------------------
Thanks Gunther.
- I will add the tests you suggest
- yes multiple ctes are allowed, can refer to each other as long there are no
cycles. There is a test for this.
- yes i agree CTE should be allowed with CTAS/create table, views. I thought
by adding CTE support to queryStatExpr this should happen. Will look into this.
- Will file a follow up jira to support sharing a plan across multiple
references to CTEs/views.
> 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
> Attachments: HIVE-1180.1.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)
