Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-21135

Grouping sets size can not be greater than 64 compile error

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Blocker
    • Resolution: Unresolved
    • 3.1.0
    • None
    • Hive
    • None
    • HDP 3.1 ,Ubuntu environment ,mysql metastore

    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 

       

       

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              nagaiik@gmail.com Nagaraju Anthati
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated: