hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-784) Support uncorrelated subqueries in the WHERE clause
Date Wed, 23 Oct 2013 22:58:51 GMT

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

Hudson commented on HIVE-784:
-----------------------------

FAILURE: Integrated in Hive-trunk-hadoop2 #519 (See [https://builds.apache.org/job/Hive-trunk-hadoop2/519/])
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)

Mime
View raw message