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

Reply via email to