You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Ricardo Resende Specian (JIRA)" <ji...@apache.org> on 2019/06/05 12:14:00 UTC
[jira] [Commented] (HIVE-21135) Grouping sets size can not be
greater than 64 compile error
[ 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)