[DRILL-6589] Push transitive closure generated predicates past aggregates

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.13.0
• Fix Version/s: 1.15.0
• Labels: ready-to-commit
• Assignee: Gautam Parai
• Reporter: Gautam Parai
• Reviewer: Vitalii Diravka
• Created: 10/Jul/18 22:02
• Updated: 31/Jul/18 20:01
• Resolved: 31/Jul/18 20:01

Description

Here is a sample query that may benefit from this optimization:

SELECT * FROM T1 WHERE a1 = 5 AND a1 IN (SELECT a2 FROM T2); 

Here the transitive predicate a2 = 5 would be pushed past the aggregate due to this optimization.

Issue Links

• is part of: DRILL-6350 Umbrella jira which tracks issues connected to Transitive Closure Inference
• links to: GitHub Pull Request #1372