[jira] [Updated] (HIVE-23928) Support conversion of not-exists to Anti join directly
[ https://issues.apache.org/jira/browse/HIVE-23928?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated HIVE-23928: -- Labels: pull-request-available (was: ) > Support conversion of not-exists to Anti join directly > -- > > Key: HIVE-23928 > URL: https://issues.apache.org/jira/browse/HIVE-23928 > Project: Hive > Issue Type: Bug >Reporter: mahesh kumar behera >Assignee: mahesh kumar behera >Priority: Major > Labels: pull-request-available > Time Spent: 10m > Remaining Estimate: 0h > > 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. > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (HIVE-23928) Support conversion of not-exists to Anti join directly
[ https://issues.apache.org/jira/browse/HIVE-23928?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] mahesh kumar behera updated HIVE-23928: --- Description: 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. was: Support HiveJoinProjectTransposeRule for Anti Join > Support conversion of not-exists to Anti join directly > -- > > Key: HIVE-23928 > URL: https://issues.apache.org/jira/browse/HIVE-23928 > Project: Hive > Issue Type: Bug >Reporter: mahesh kumar behera >Assignee: mahesh kumar behera >Priority: Major > > 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. > -- This message was sent by Atlassian Jira (v8.3.4#803005)
