Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Grouping sets size cannot be greater than 64

avatar
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

avatar
Explorer

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

avatar
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

avatar
Explorer

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

avatar

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.