[ https://issues.apache.org/jira/browse/HIVE-21135?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16856649#comment-16856649 ]
Ricardo Resende Specian commented on HIVE-21135: ------------------------------------------------ Hi, I had the same problem when I was executing a union with more then 64 columns. > Grouping sets size can not be greater than 64 compile error > ----------------------------------------------------------- > > Key: HIVE-21135 > URL: https://issues.apache.org/jira/browse/HIVE-21135 > Project: Hive > Issue Type: Bug > Components: Hive > Affects Versions: 3.1.0 > Environment: HDP 3.1 ,Ubuntu environment ,mysql metastore > Reporter: Nagaraju Anthati > Priority: Blocker > > I am trying to get distinct records from an alias dataset , then the hive is > throwing compile error .The alias dataset has 8k columns , could not proceed > further , not sure if it is config related. > query : select distinct data.* from ( ......... some join....+8kcolumns in > the result set...........)data > > > error :compile error : Grouping sets size can not be grater than 64:27:x > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)