hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jesus Camacho Rodriguez (JIRA)" <>
Subject [jira] [Commented] (HIVE-8988) Support advanced aggregation in Hive to Calcite path
Date Fri, 12 Dec 2014 10:13:13 GMT


Jesus Camacho Rodriguez commented on HIVE-8988:

[~julianhyde], thanks for the comments.

I am a bit surprised that translating GROUPING__ID to Calcite's GROUP_ID function works. The
logic to expand it is in SqlToRelConverter, which Hive does not call (IIRC). How does it work?

It works because we never call the function. In fact, when we go back from Calcite to Hive,
the GROUP_ID call in the Calcite project operator is replaced by a pointer to the column containing
the GROUPING__ID that comes out of the Hive GroupBy operator.

> Support advanced aggregation in Hive to Calcite path 
> -----------------------------------------------------
>                 Key: HIVE-8988
>                 URL:
>             Project: Hive
>          Issue Type: Improvement
>    Affects Versions: 0.15.0
>            Reporter: Jesus Camacho Rodriguez
>            Assignee: Jesus Camacho Rodriguez
>              Labels: grouping, logical, optiq
>             Fix For: 0.15.0
>         Attachments: HIVE-8988.01.patch, HIVE-8988.patch
> To close the gap between Hive and Calcite, we need to support the translation of GroupingSets
into Calcite; currently this is not implemented.

This message was sent by Atlassian JIRA

View raw message