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-16432) Improve plan for subquery with EXISTS
Date Wed, 12 Apr 2017 23:42:41 GMT
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)

Mime
View raw message