[
https://issues.apache.org/jira/browse/HIVE-784?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Phabricator updated HIVE-784:
-----------------------------
Attachment: D13443.2.patch
hbutani updated the revision "HIVE-784 [jira] Support uncorrelated subqueries
in the WHERE clause".
Reviewers: ashutoshc, JIRA
REVISION DETAIL
https://reviews.facebook.net/D13443
CHANGE SINCE LAST DIFF
https://reviews.facebook.net/D13443?vs=41457&id=41871#toc
AFFECTED FILES
ql/src/java/org/apache/hadoop/hive/ql/ErrorMsg.java
ql/src/java/org/apache/hadoop/hive/ql/parse/HiveParser.g
ql/src/java/org/apache/hadoop/hive/ql/parse/IdentifiersParser.g
ql/src/java/org/apache/hadoop/hive/ql/parse/QBSubQuery.java
ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
ql/src/java/org/apache/hadoop/hive/ql/parse/SubQueryUtils.java
ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java
ql/src/test/queries/clientnegative/subquery_exists_implicit_gby.q
ql/src/test/queries/clientnegative/subquery_in_groupby.q
ql/src/test/queries/clientnegative/subquery_in_select.q
ql/src/test/queries/clientnegative/subquery_multiple_cols_in_select.q
ql/src/test/queries/clientnegative/subquery_notexists_implicit_gby.q
ql/src/test/queries/clientnegative/subquery_subquery_chain.q
ql/src/test/queries/clientnegative/subquery_windowing_corr.q
ql/src/test/queries/clientnegative/subquery_with_or_cond.q
ql/src/test/queries/clientpositive/subquery_exists.q
ql/src/test/queries/clientpositive/subquery_in.q
ql/src/test/queries/clientpositive/subquery_multiinsert.q
ql/src/test/queries/clientpositive/subquery_notexists.q
ql/src/test/queries/clientpositive/subquery_notin.q
ql/src/test/results/clientnegative/subquery_exists_implicit_gby.q.out
ql/src/test/results/clientnegative/subquery_in_groupby.q.out
ql/src/test/results/clientnegative/subquery_in_select.q.out
ql/src/test/results/clientnegative/subquery_multiple_cols_in_select.q.out
ql/src/test/results/clientnegative/subquery_notexists_implicit_gby.q.out
ql/src/test/results/clientnegative/subquery_subquery_chain.q.out
ql/src/test/results/clientnegative/subquery_windowing_corr.q.out
ql/src/test/results/clientnegative/subquery_with_or_cond.q.out
ql/src/test/results/clientpositive/subquery_exists.q.out
ql/src/test/results/clientpositive/subquery_in.q.out
ql/src/test/results/clientpositive/subquery_multiinsert.q.out
ql/src/test/results/clientpositive/subquery_notexists.q.out
ql/src/test/results/clientpositive/subquery_notin.q.out
To: JIRA, ashutoshc, hbutani
> 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: Harish Butani
> Attachments: D13443.1.patch, D13443.2.patch, 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)
