[ https://issues.apache.org/jira/browse/HIVE-25864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
mahesh kumar behera resolved HIVE-25864. ---------------------------------------- Resolution: Fixed > Hive query optimisation creates wrong plan for predicate pushdown with > windowing function > ------------------------------------------------------------------------------------------ > > Key: HIVE-25864 > URL: https://issues.apache.org/jira/browse/HIVE-25864 > Project: Hive > Issue Type: Bug > Reporter: mahesh kumar behera > Assignee: mahesh kumar behera > Priority: Major > Labels: pull-request-available > Time Spent: 40m > Remaining Estimate: 0h > > 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. -- This message was sent by Atlassian Jira (v8.20.1#820001)