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

Extend grouping set limits from int to long

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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.10.patch
          1.85 MB
          Prasanth Jayachandran
        3. HIVE-18359.11.patch
          1.86 MB
          Prasanth Jayachandran
        4. HIVE-18359.11.patch
          1.86 MB
          Prasanth Jayachandran
        5. HIVE-18359.12.patch
          1.87 MB
          Prasanth Jayachandran
        6. HIVE-18359.2.patch
          3.31 MB
          Prasanth Jayachandran
        7. HIVE-18359.3.patch
          3.37 MB
          Prasanth Jayachandran
        8. HIVE-18359.4.patch
          3.39 MB
          Prasanth Jayachandran
        9. HIVE-18359.5.patch
          3.41 MB
          Prasanth Jayachandran
        10. HIVE-18359.6.patch
          3.41 MB
          Prasanth Jayachandran
        11. HIVE-18359.7.patch
          1.86 MB
          Prasanth Jayachandran
        12. HIVE-18359.8.patch
          1.84 MB
          Prasanth Jayachandran
        13. HIVE-18359.9.patch
          1.84 MB
          Prasanth Jayachandran

        Issue Links

        is blocked by

        Bug - A problem which impairs or prevents the functions of the product. HIVE-18523 Fix summary row in case there are no inputs

        • Major - Major loss of function.
        • Closed
        links to

        Web Link RB

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment