[CALCITE-3890] Derive IS NOT NULL filter for the inputs of inner join

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.31.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Chunwei Lei
• Reporter: Chunwei Lei
• Created: 01/Apr/20 04:09
• Updated: 03/Aug/22 16:21
• Resolved: 20/May/22 11:52

Description

We can infer IS NOT NULL predicate from join which implies some columns may not be null. For instance, 

 

select * from a join b on a.id = b.id;

we can infer a.id is not null/b.id is not null and push down them into the child node of the join. Then it becomes

select * from (select* from a where id is null) t1 join (select * from b where id is not null) on t1.id = t2.id;

 

 

Issue Links

• relates to: HIVE-26427 Unify JoinDeriveIsNotNullFilterRule with HiveJoinAddNotNullRule
• links to: GitHub Pull Request #2800