You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Jesus Camacho Rodriguez (Jira)" <ji...@apache.org> on 2021/03/09 04:36:00 UTC

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

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

Jesus Camacho Rodriguez resolved HIVE-16432.
--------------------------------------------
    Resolution: Duplicate

> Improve plan for subquery with EXISTS
> -------------------------------------
>
>                 Key: HIVE-16432
>                 URL: https://issues.apache.org/jira/browse/HIVE-16432
>             Project: Hive
>          Issue Type: Sub-task
>          Components: Logical Optimizer
>            Reporter: Vineet Garg
>            Assignee: Krisztian Kasa
>            Priority: Major
>
> 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
(v8.3.4#803005)