hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vineet Garg (JIRA)" <>
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
             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

View raw message