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

GROUPING__ID is wrong

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsAdd voteVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    Description

      https://cwiki.apache.org/confluence/display/Hive/Enhanced+Aggregation,+Cube,+Grouping+and+Rollup

      Grouping__ID function

      This function returns a bitvector corresponding to whether each column is present or not. For each column, a value of "1" is produced for a row in
      the result set if that column has been aggregated in that row, otherwise the value is "0". This can be used to differentiate when there are nulls
      in the data.

      This does not match the example blow, in the first row, both key and value are aggregated, so GROUPING__ID should be 3 not, 0.

      Attachments

        Issue Links

        Activity

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

          People

            Unassigned Unassigned Assign to me
            davies Davies Liu

            Dates

              Created:
              Updated:

              Slack

                Issue deployment