Vineet Garg created HIVE-15721:
----------------------------------
Summary: Allow IN/NOT IN correlated subquery with aggregates
Key: HIVE-15721
URL: https://issues.apache.org/jira/browse/HIVE-15721
Project: Hive
Issue Type: Sub-task
Components: Query Planning
Reporter: Vineet Garg
Assignee: Vineet Garg
With HIVE-15544 IN/NOT IN correlated subqueries with aggregates were disabled
since re-writting them into JOIN could have produced wrong result.
Wrong results would occur if subquery produces zero row, since aggregate always
produce result lower such query into LEFT JOIN or SEMI JOIN would not take
these case into consideration.
We propose to allow such queries with an added run time check which will throw
an error/exception if subquery produces zero row.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
