Support Questions
Find answers, ask questions, and share your expertise

Grouping sets size cannot be greater than 64

New Contributor

when I exec 'group by or distinct',I get a error 'Error: Error while compiling statement: FAILED: SemanticException [Error 10411]: Grouping sets size cannot be greater than 64 (state=42000,code=10411)'

4 REPLIES 4

New Contributor

@zszj999 where you able to solve this.We are facing the same issue.

Explorer

Reported as this Apache issue:

https://issues.apache.org/jira/browse/HIVE-21135

Fixed here but not backported as of HDP 3.1.0.0:

https://issues.apache.org/jira/browse/HIVE-21018

Explorer

It seems it is not included in HDP yet please use pig as alternative

The above was originally posted in the Community Help Track. On Tue May 28 23:19 UTC 2019, a member of the HCC moderation staff moved it to the Data Processing track. The Community Help Track is intended for questions about using the HCC site itself.

Bill Brooks, Community Moderator
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.