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

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


Copy link to this message
-
Review Request 15584: Subquery support: allow subquery expressions in having clause

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

Review request for hive and Ashutosh Chauhan.
Bugs: hive-5614
    https://issues.apache.org/jira/browse/hive-5614
Repository: hive-git
Description
-------

Support subqueries in having clause.
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 d797407
  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/15584/diff/
Testing
-------

new tests for in, not in, exists, not exists
tested existing subquery tests
Thanks,

Harish Butani