[
https://issues.apache.org/jira/browse/HIVE-784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13806284#comment-13806284
]
Hudson commented on HIVE-784:
-----------------------------
SUCCESS: Integrated in Hive-trunk-hadoop1-ptest #215 (See
[https://builds.apache.org/job/Hive-trunk-hadoop1-ptest/215/])
HIVE-784 : Support uncorrelated subqueries in the WHERE clause (Harish Butani
via Ashutosh Chauhan) (hashutosh:
http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1535040)
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/ErrorMsg.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/HiveParser.g
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/IdentifiersParser.g
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/QBSubQuery.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/SubQueryUtils.java
*
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java
* /hive/trunk/ql/src/test/queries/clientnegative/subquery_exists_implicit_gby.q
* /hive/trunk/ql/src/test/queries/clientnegative/subquery_in_groupby.q
* /hive/trunk/ql/src/test/queries/clientnegative/subquery_in_select.q
*
/hive/trunk/ql/src/test/queries/clientnegative/subquery_multiple_cols_in_select.q
*
/hive/trunk/ql/src/test/queries/clientnegative/subquery_notexists_implicit_gby.q
* /hive/trunk/ql/src/test/queries/clientnegative/subquery_subquery_chain.q
* /hive/trunk/ql/src/test/queries/clientnegative/subquery_windowing_corr.q
* /hive/trunk/ql/src/test/queries/clientnegative/subquery_with_or_cond.q
* /hive/trunk/ql/src/test/queries/clientpositive/subquery_exists.q
* /hive/trunk/ql/src/test/queries/clientpositive/subquery_in.q
* /hive/trunk/ql/src/test/queries/clientpositive/subquery_multiinsert.q
* /hive/trunk/ql/src/test/queries/clientpositive/subquery_notexists.q
* /hive/trunk/ql/src/test/queries/clientpositive/subquery_notin.q
*
/hive/trunk/ql/src/test/results/clientnegative/subquery_exists_implicit_gby.q.out
* /hive/trunk/ql/src/test/results/clientnegative/subquery_in_groupby.q.out
* /hive/trunk/ql/src/test/results/clientnegative/subquery_in_select.q.out
*
/hive/trunk/ql/src/test/results/clientnegative/subquery_multiple_cols_in_select.q.out
*
/hive/trunk/ql/src/test/results/clientnegative/subquery_notexists_implicit_gby.q.out
* /hive/trunk/ql/src/test/results/clientnegative/subquery_subquery_chain.q.out
* /hive/trunk/ql/src/test/results/clientnegative/subquery_windowing_corr.q.out
* /hive/trunk/ql/src/test/results/clientnegative/subquery_with_or_cond.q.out
* /hive/trunk/ql/src/test/results/clientpositive/subquery_exists.q.out
* /hive/trunk/ql/src/test/results/clientpositive/subquery_in.q.out
* /hive/trunk/ql/src/test/results/clientpositive/subquery_multiinsert.q.out
* /hive/trunk/ql/src/test/results/clientpositive/subquery_notexists.q.out
* /hive/trunk/ql/src/test/results/clientpositive/subquery_notin.q.out
> 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
> Fix For: 0.13.0
>
> 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)
