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

support count(*) and count distinct on multiple columns

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.6.0
    • Fix Version/s: 0.6.0
    • Component/s: Query Processor
    • Labels:
      None
    • Hadoop Flags:
      Reviewed
    • Release Note:
      This change deprecates the GenericUDAFResolver interface in favor of the new GenericUDAFResolver2.

      Description

      The following query does not work:

      select count(distinct col1, col2) from Tbl

        Attachments

        1. HIVE-287-1.patch
          34 kB
          Arvind Prabhakar
        2. HIVE-287-2.patch
          36 kB
          Arvind Prabhakar
        3. HIVE-287-3.patch
          34 kB
          Arvind Prabhakar
        4. HIVE-287-4.patch
          41 kB
          Arvind Prabhakar
        5. HIVE-287-5-trunk.patch
          53 kB
          Arvind Prabhakar
        6. HIVE-287-5-branch-0.6.patch
          53 kB
          Arvind Prabhakar
        7. HIVE-287-6-trunk.patch
          55 kB
          Arvind Prabhakar
        8. HIVE-287-6-branch-0.6.patch
          55 kB
          Arvind Prabhakar

          Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-1459 wildcards in UDF/UDAF should expand to all columns (rather than no columns)

          • Major - Major loss of function.
          • Open

            Activity

              People

              • Assignee:
                aprabhakar Arvind Prabhakar
                Reporter:
                namit Namit Jain
              • Votes:
                1 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: