Grouping sets size cannot be greater than 64

[#1]

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)'

[#2]

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

[#3]

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

[#4]

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

[#5]

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.