You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org> on 2019/03/12 23:27:00 UTC

[jira] [Commented] (HIVE-21434) Extend HiveAggregatePullUpConstantsRule to remove all grouping columns if possible

    [ https://issues.apache.org/jira/browse/HIVE-21434?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16791091#comment-16791091 ] 

Jesus Camacho Rodriguez commented on HIVE-21434:
------------------------------------------------

Initial patch to trigger ptest.

> Extend HiveAggregatePullUpConstantsRule to remove all grouping columns if possible
> ----------------------------------------------------------------------------------
>
>                 Key: HIVE-21434
>                 URL: https://issues.apache.org/jira/browse/HIVE-21434
>             Project: Hive
>          Issue Type: Improvement
>          Components: CBO
>            Reporter: Jesus Camacho Rodriguez
>            Assignee: Jesus Camacho Rodriguez
>            Priority: Major
>         Attachments: HIVE-21434.patch
>
>
> Currently there is a limitation in the rule implementation.
> {code}
> ...
>       // No room for optimization since we cannot convert from non-empty
>       // GROUP BY list to the empty one.
> ...
> {code}
> The rule extension should try to overcome the limitation by implementing this specific case calculating count(\*) on Aggregate and applying Filter on top of it.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)