[
https://issues.apache.org/jira/browse/HIVE-5613?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13802261#comment-13802261
]
Harish Butani commented on HIVE-5613:
-------------------------------------
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}
> Subquery support: disallow nesting of SubQueries
> ------------------------------------------------
>
> Key: HIVE-5613
> URL: https://issues.apache.org/jira/browse/HIVE-5613
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Harish Butani
> Assignee: Harish Butani
>
--
This message was sent by Atlassian JIRA
(v6.1#6144)
