[
https://issues.apache.org/jira/browse/HIVE-23992?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
mahesh kumar behera updated HIVE-23992:
---------------------------------------
Description: The current anti join conversion does not check for null
filters on right side of join if it's within OR conditions. Only those filters
separated by AND conditions are supported. For example queries like "select
t1.fld from tbl1 t1 left join tbl2 t2 on t1.fld = t2.fld where t2.fld is null
or t2.fld1 is null" are not converted to anti join. (was: 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.)
> Support null filter within or clause for Anti Join
> --------------------------------------------------
>
> Key: HIVE-23992
> URL: https://issues.apache.org/jira/browse/HIVE-23992
> Project: Hive
> Issue Type: Bug
> Reporter: mahesh kumar behera
> Assignee: mahesh kumar behera
> Priority: Major
>
> The current anti join conversion does not check for null filters on right
> side of join if it's within OR conditions. Only those filters separated by
> AND conditions are supported. For example queries like "select t1.fld from
> tbl1 t1 left join tbl2 t2 on t1.fld = t2.fld where t2.fld is null or t2.fld1
> is null" are not converted to anti join.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
