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

GROUPING__ID is wrong

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      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

              People

              • Assignee:
                Unassigned
                Reporter:
                davies Davies Liu
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: