Hive
  1. Hive
  2. HIVE-2597

Repeated key in GROUP BY is erroneously displayed when using DISTINCT

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major 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.

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

        Issue Links

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development