[
https://issues.apache.org/jira/browse/HIVE-784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13786749#comment-13786749
]
Harish Butani commented on HIVE-784:
------------------------------------
Just uploaded a script with tpch queries Q4, Q15, Q16 and Q18 written using
SubQueries.
Validated results against what is in the Spec.
Script includes ddl at the bottom.
> Support uncorrelated subqueries in the WHERE clause
> ---------------------------------------------------
>
> Key: HIVE-784
> URL: https://issues.apache.org/jira/browse/HIVE-784
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Ning Zhang
> Assignee: Matthew Weaver
> Attachments: HIVE-784.1.patch.txt, HIVE-784.2.patch,
> SubQuerySpec.pdf, tpchQueriesUsingSubQueryClauses.sql
>
>
> Hive currently only support views in the FROM-clause, some Facebook use cases
> suggest that Hive should support subqueries such as those connected by
> IN/EXISTS in the WHERE-clause.
--
This message was sent by Atlassian JIRA
(v6.1#6144)
