[HIVE-21135] Grouping sets size can not be greater than 64 compile error

• Type: Bug
• Status: Open
• Priority: Blocker
• Resolution: Unresolved
• Affects Version/s: 3.1.0
• Component/s: Hive

Environment

HDP 3.1 ,Ubuntu environment ,mysql metastore

• Assignee: Unassigned Assign to me
• Reporter: Nagaraju Anthati
• Due: 22/Jan/19
• Created: 18/Jan/19 15:01
• Updated: 05/Jun/19 12:13

Description

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 

 

 

Issue Links

• duplicates: HIVE-21018 Grouping/distinct on more than 64 columns should be possible