Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # dev >> Review Request 15718: HIVE-5614: Subquery support: allow subquery expressions in having clause


Copy link to this message
-
Re: Review Request 15718: HIVE-5614: Subquery support: allow subquery expressions in having clause

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/15718/#review29328
-----------------------------------------------------------

Ship it!
Ship It!

- Ashutosh Chauhan
On Nov. 23, 2013, 12:14 a.m., Harish Butani wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/15718/
> -----------------------------------------------------------
>
> (Updated Nov. 23, 2013, 12:14 a.m.)
>
>
> Review request for hive and Ashutosh Chauhan.
>
>
> Bugs: HIVE-5614
>     https://issues.apache.org/jira/browse/HIVE-5614
>
>
> Repository: hive-git
>
>
> Description
> -------
>
> support for subquery predicates in having clause. SubTask of HIVE-784
>
>
> Diffs
> -----
>
>   ql/src/java/org/apache/hadoop/hive/ql/parse/QB.java fa111cc
>   ql/src/java/org/apache/hadoop/hive/ql/parse/QBSubQuery.java 3e8215d
>   ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java 7979873
>   ql/src/test/queries/clientpositive/subquery_exists_having.q PRE-CREATION
>   ql/src/test/queries/clientpositive/subquery_in_having.q PRE-CREATION
>   ql/src/test/queries/clientpositive/subquery_notexists_having.q PRE-CREATION
>   ql/src/test/queries/clientpositive/subquery_notin_having.q PRE-CREATION
>   ql/src/test/results/clientpositive/subquery_exists_having.q.out PRE-CREATION
>   ql/src/test/results/clientpositive/subquery_in_having.q.out PRE-CREATION
>   ql/src/test/results/clientpositive/subquery_multiinsert.q.out 8dfb485
>   ql/src/test/results/clientpositive/subquery_notexists_having.q.out PRE-CREATION
>   ql/src/test/results/clientpositive/subquery_notin_having.q.out PRE-CREATION
>
> Diff: https://reviews.apache.org/r/15718/diff/
>
>
> Testing
> -------
>
> added new tests: subquery_in_having.q, subquery_notin_having.q, subquery_exists_having.q, subquery_notexists_having.q
>
>
> Thanks,
>
> Harish Butani
>
>