hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Harish Butani" <rhbut...@gmail.com>
Subject Review Request 14887: Subquery support: disallow nesting of SubQueries
Date Wed, 23 Oct 2013 20:46:02 GMT

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

Review request for hive and Ashutosh Chauhan.


Bugs: HIVE-5613
    https://issues.apache.org/jira/browse/HIVE-5613


Repository: hive-git


Description
-------

This is Restriction 9 from the SubQuery design doc:
We will not do algebraic transformations for these kinds of queries:

{noformat}
-query 1
select ...
from x
where  
    x.b in (select u 
            from y 
            where y.c = 10 and
                  exists (select m from z where z.A = x.C)
           )
- query 2
select ...
from x
where  
    x.b in (select u 
            from y 
            where y.c = 10 and
                  exists (select m from z where z.A = y.D)
{noformat}


Diffs
-----

  ql/src/java/org/apache/hadoop/hive/ql/parse/QB.java 50b5a77 
  ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java 6fc3cd5 
  ql/src/java/org/apache/hadoop/hive/ql/parse/SubQueryUtils.java 2d7775c 
  ql/src/test/queries/clientnegative/subquery_nested_subquery.q PRE-CREATION 
  ql/src/test/results/clientnegative/subquery_nested_subquery.q.out PRE-CREATION 

Diff: https://reviews.apache.org/r/14887/diff/


Testing
-------

tested subquery tests
added new subquery_nested_subquery.q negative test


Thanks,

Harish Butani


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message