[HIVE-23928] Support conversion of not-exists to Anti join directly

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: pull-request-available
• Assignee: mahesh kumar behera
• Reporter: mahesh kumar behera
• Created: 24/Jul/20 10:57
• Updated: 09/Nov/20 00:42

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.

 

Issue Links

• is related to: HIVE-23716 Support Anti Join in Hive
• links to: GitHub Pull Request #1459