[
https://issues.apache.org/jira/browse/HIVE-24986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17316386#comment-17316386
]
Zoltan Haindrich commented on HIVE-24986:
-----------------------------------------
rollup/cube support feature was implemented back in HIVE-3433 ; but there were
some conditionals added to protect against the grouping column appearing in
aggregates
After I've removed the checks it worked without issues - I was looking around
what could have been the cause...but I'm not sure.
I think in recent years we fixed some issues around empty row rollup/etc and
probably other corner cases - so I guess we can now just allow it.
> Support aggregates on columns present in rollups
> ------------------------------------------------
>
> Key: HIVE-24986
> URL: https://issues.apache.org/jira/browse/HIVE-24986
> Project: Hive
> Issue Type: Improvement
> Reporter: Zoltan Haindrich
> Assignee: Zoltan Haindrich
> Priority: Major
>
> {code}
> SELECT key, value, count(key) FROM src GROUP BY key, value with rollup;
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
