hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vineet Garg (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-15721) Allow IN/NOT IN correlated subquery with aggregates
Date Wed, 25 Jan 2017 03:47:26 GMT
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)

Mime
View raw message