Details
-
Sub-task
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
Description
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.
Attachments
Attachments
Issue Links
- relates to
-
HIVE-15544 Support scalar subqueries
- Closed
- links to