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

Extend grouping set limits from int to long

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 3.0.0
    • 3.0.0
    • None
    • None

    Description

      Grouping sets is broken for >32 columns because of usage of Int for bitmap (also GROUPING_ID virtual column). This assumption breaks grouping sets/rollups/cube when number of participating aggregation columns is >32. The easier fix would be extend it to Long for now. The correct fix would be to use BitSets everywhere but that would require GROUPINGID column type to binary which will make predicates on GROUPING_ID difficult to deal with.

      Attachments

        1. HIVE-18359.1.patch
          82 kB
          Prasanth Jayachandran
        2. HIVE-18359.2.patch
          3.31 MB
          Prasanth Jayachandran
        3. HIVE-18359.3.patch
          3.37 MB
          Prasanth Jayachandran
        4. HIVE-18359.4.patch
          3.39 MB
          Prasanth Jayachandran
        5. HIVE-18359.5.patch
          3.41 MB
          Prasanth Jayachandran
        6. HIVE-18359.6.patch
          3.41 MB
          Prasanth Jayachandran
        7. HIVE-18359.7.patch
          1.86 MB
          Prasanth Jayachandran
        8. HIVE-18359.8.patch
          1.84 MB
          Prasanth Jayachandran
        9. HIVE-18359.9.patch
          1.84 MB
          Prasanth Jayachandran
        10. HIVE-18359.10.patch
          1.85 MB
          Prasanth Jayachandran
        11. HIVE-18359.11.patch
          1.86 MB
          Prasanth Jayachandran
        12. HIVE-18359.11.patch
          1.86 MB
          Prasanth Jayachandran
        13. HIVE-18359.12.patch
          1.87 MB
          Prasanth Jayachandran

        Issue Links

          Activity

            People

              prasanth_j Prasanth Jayachandran
              prasanth_j Prasanth Jayachandran
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: