Hive
  1. Hive
  2. HIVE-474

Support for distinct selection on two or more columns

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.7.0
    • Component/s: Query Processor
    • Labels:
      None
    • Hadoop Flags:
      Reviewed

      Description

      The ability to select distinct several, individual columns as by example:

      select count(distinct user), count(distinct session) from actions;

      Currently returns the following failure:

      FAILED: Error in semantic analysis: line 2:7 DISTINCT on Different Columns not Supported user

      1. hive-474.0.4.2rc.patch
        258 kB
        Mafish
      2. patch-474.txt
        294 kB
        Amareshwari Sriramadasu
      3. patch-474-1.txt
        296 kB
        Amareshwari Sriramadasu
      4. patch-474-2.txt
        254 kB
        Amareshwari Sriramadasu
      5. patch-474-3.txt
        254 kB
        Amareshwari Sriramadasu

        Issue Links

          Activity

            People

            • Assignee:
              Amareshwari Sriramadasu
              Reporter:
              Alexis Rondeau
            • Votes:
              3 Vote for this issue
              Watchers:
              12 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development