-----------------------------------------------------------
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
