[
https://issues.apache.org/jira/browse/HIVE-8988?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14243936#comment-14243936
]
Jesus Camacho Rodriguez commented on HIVE-8988:
-----------------------------------------------
[~julianhyde], thanks for the comments.
{quote}
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?
{quote}
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: https://issues.apache.org/jira/browse/HIVE-8988
> 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
>
>
> CLEAR LIBRARY CACHE
> 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
(v6.3.4#6332)
