[
https://issues.apache.org/jira/browse/HIVE-784?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Phabricator updated HIVE-784:
-----------------------------
Attachment: D13443.1.patch
hbutani requested code review of "HIVE-784 [jira] Support uncorrelated
subqueries in the WHERE clause".
Reviewers: JIRA, ashutoshc
SubQuery: add tests for distinct
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.
TEST PLAN
EMPTY
REVISION DETAIL
https://reviews.facebook.net/D13443
AFFECTED FILES
ql/src/java/org/apache/hadoop/hive/ql/ErrorMsg.java
ql/src/java/org/apache/hadoop/hive/ql/exec/Utilities.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_in_groupby.q
ql/src/test/queries/clientnegative/subquery_in_select.q
ql/src/test/queries/clientnegative/subquery_windowing_corr.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_in_groupby.q.out
ql/src/test/results/clientnegative/subquery_in_select.q.out
ql/src/test/results/clientnegative/subquery_windowing_corr.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
MANAGE HERALD RULES
https://reviews.facebook.net/herald/view/differential/
WHY DID I GET THIS EMAIL?
https://reviews.facebook.net/herald/transcript/40029/
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, 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)
