[IMPALA-8611] Runtime filters cannot be pushed through subquery with analytic

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: Impala 3.2.0
• Component/s: Frontend
• Labels: perf performance
• Target Version: Product Backlog
• Epic Color: ghx-label-8
• Assignee: Unassigned
• Reporter: Dima Fadeyev
• Created: 01/Jun/19 23:12
• Updated: 12/Feb/20 23:39

Description

When an analytical function is present in a query I don't see runtime filters being generated. Please, consider an example from the attached file.

It is valid to push the filter through the analytic when it is filtering columns that are in the "PARTITION BY" expression, since the filters would eliminate whole partitions of the analytic and therefore not affect results.