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/04/12 23:42:41 UTC

[jira] [Created] (HIVE-16432) Improve plan for subquery with EXISTS

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)