Vineet Garg created HIVE-16432:
----------------------------------
Summary: Improve plan for subquery with EXISTS
Key: HIVE-16432
URL: https://issues.apache.org/jira/browse/HIVE-16432
Project: Hive
Issue Type: Sub-task
Reporter: Vineet Garg
Assignee: Vineet Garg
If an EXISTS/NOT EXISTS subquery contains an aggregate (with no group by or
windowing) it is guaranteed to produce at least one row. Since such subquery in
WHERE clause tests for existence of row it could be replaced by true during
compile time.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
