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

Repeated key in GROUP BY is erroneously displayed when using DISTINCT

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.14.0
    • Component/s: None
    • Labels:
      None

      Description

      The following query was simplified for illustration purposes.

      This works correctly:

      select client_tid, "" as myvalue1, "" as myvalue2 from clients cluster by client_tid
      

      The intent here is to produce two empty columns in between data.

      The following query does not work:

      select distinct client_tid, "" as myvalue1, "" as myvalue2 from clients cluster by client_tid
      
      FAILED: Error in semantic analysis: Line 1:44 Repeated key in GROUP BY ""
      

      The key is not repeated since the aliases were given. Seems like Hive is ignoring the aliases when the "distinct" keyword is specified.

        Attachments

        1. HIVE-2597.4.patch.txt
          44 kB
          Navis
        2. HIVE-2597.3.patch.txt
          15 kB
          Navis
        3. HIVE-2597.D8967.2.patch
          37 kB
          Phabricator
        4. HIVE-2597.D8967.1.patch
          32 kB
          Phabricator

          Issue Links

            Activity

              People

              • Assignee:
                navis Navis
                Reporter:
                arov Alex Rovner
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: