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

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


Copy link to this message
-
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/
-----------------------------------------------------------

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

+
Ashutosh Chauhan 2013-11-22, 19:02
+
Harish Butani 2013-11-23, 00:17
+
Harish Butani 2013-11-23, 00:14
+
Ashutosh Chauhan 2013-11-23, 00:54