You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Vineet Garg (JIRA)" <ji...@apache.org> on 2017/01/25 03:47:26 UTC

[jira] [Created] (HIVE-15721) Allow IN/NOT IN correlated subquery with aggregates

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)