[jira] [Commented] (HIVE-1180) Support Common Table Expressions (CTEs) in Hive

["Craig Condit (JIRA)" <ji...@apache.org>]

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

Craig Condit commented on HIVE-1180:
------------------------------------

Just wanted to say thanks for all the work on this. This has allowed us to do complex joins on HBase tables without having the query optimizer mess with the filter expression pushed down to HBase (thereby destroying the STARTROW/ENDROW optimizations). 

Using CTE's is so far the only way we have been able to do this effectively.

Will we be able to rely on this behavior in future versions (forcing CTE queries to be executed unmodified)?



> 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.2#6252)