hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ricardo Resende Specian (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-21135) Grouping sets size can not be greater than 64 compile error
Date Wed, 05 Jun 2019 12:14:00 GMT

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

Mime
View raw message