hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vineet Garg (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (HIVE-16432) Improve plan for subquery with EXISTS
Date Wed, 12 Apr 2017 23:42:41 GMT

     [ https://issues.apache.org/jira/browse/HIVE-16432?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Vineet Garg reassigned HIVE-16432:
----------------------------------


> 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