You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "mahesh kumar behera (Jira)" <ji...@apache.org> on 2022/01/21 02:14:00 UTC

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

     [ 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)