[
https://issues.apache.org/jira/browse/HIVE-23991?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
mahesh kumar behera updated HIVE-23991:
---------------------------------------
Description: The current anti join conversion does not support join
condition which is always true. The queries like select * from tbl t1 where not
exists (select 1 from t2) is not converted to anti join. (was: The current
anti join conversion does not support direct conversion of not-exists to anti
join. The not exists sub query is converted first to left out join and then its
converted to anti join. This may cause some of the optimization rule to be
skipped.
)
> Support isAlwaysTrue for Anti Join
> ----------------------------------
>
> Key: HIVE-23991
> URL: https://issues.apache.org/jira/browse/HIVE-23991
> Project: Hive
> Issue Type: Bug
> Reporter: mahesh kumar behera
> Assignee: mahesh kumar behera
> Priority: Major
>
> The current anti join conversion does not support join condition which is
> always true. The queries like select * from tbl t1 where not exists (select 1
> from t2) is not converted to anti join.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
