mahesh kumar behera created HIVE-24013:
------------------------------------------
Summary: Move anti join conversion after join reordering rule
Key: HIVE-24013
URL: https://issues.apache.org/jira/browse/HIVE-24013
Project: Hive
Issue Type: Bug
Reporter: mahesh kumar behera
Assignee: mahesh kumar behera
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)
