[HIVE-25864] Hive query optimisation creates wrong plan for predicate pushdown with windowing function

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Labels: pull-request-available
• Assignee: mahesh kumar behera
• Reporter: mahesh kumar behera
• Created: 12/Jan/22 10:51
• Updated: 21/Jan/22 02:13
• Resolved: 21/Jan/22 02:13

Description

In case of a query with windowing function, the deterministic predicates are pushed down below the window function. Before pushing down, the predicate is converted to refer the project operator values. But the same conversion is done again while creating the project and thus causing wrong plan generation.

Issue Links

• links to: GitHub Pull Request #2943