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

Support for distinct selection on two or more columns

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 0.7.0
    • Query Processor
    • None
    • 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

      Attachments

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

        Issue Links

          is blocked by

          New Feature - A new feature of the product, which has yet to be developed. HIVE-537 Hive TypeInfo/ObjectInspector to support union (besides struct, array, and map)

          • Major - Major loss of function.
          • Closed
          is related to

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-2416 Multiple distinct function to support hive.groupby.skewindata optimization

          • Major - Major loss of function.
          • Open

          Activity

            People

              amareshwari Amareshwari Sriramadasu
              akaalias Alexis Rondeau
              Votes:
              3 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: