[ https://issues.apache.org/jira/browse/PHOENIX-5956?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
chenglei updated PHOENIX-5956: ------------------------------ Description: When LHS left semi join RHS through SortMergeJoin, if RHS is end and returns null, then the left semi join could end early, but for {{SortMergeJoinPlan.SemiAntiJoinIterator}} , it would continue until LHS is exhausted even if RHS returns null, which is unnecessary. > Optimize LeftSemiJoin For SortMergeJoin > ---------------------------------------- > > Key: PHOENIX-5956 > URL: https://issues.apache.org/jira/browse/PHOENIX-5956 > Project: Phoenix > Issue Type: Improvement > Affects Versions: 4.15.0 > Reporter: chenglei > Priority: Major > Fix For: 5.1.0, 4.16.0 > > > When LHS left semi join RHS through SortMergeJoin, if RHS is end and returns > null, then the left semi join could end early, but for > {{SortMergeJoinPlan.SemiAntiJoinIterator}} , it would continue until LHS is > exhausted even if RHS returns null, which is unnecessary. -- This message was sent by Atlassian Jira (v8.3.4#803005)