Hive
  1. Hive
  2. HIVE-287

support count(*) and count distinct on multiple columns

    Details

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

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

        Issue Links

          Activity

          Carl Steinbach made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Carl Steinbach made changes -
          Fix Version/s 0.7.0 [ 12315150 ]
          John Sichi made changes -
          Link This issue is related to HIVE-1459 [ HIVE-1459 ]
          John Sichi made changes -
          Status Patch Available [ 10002 ] Resolved [ 5 ]
          Hadoop Flags [Reviewed]
          Release Note This change deprecates the GenericUDAFResolver interface in favor of the new GenericUDAFResolver2.
          Resolution Fixed [ 1 ]
          John Sichi made changes -
          Fix Version/s 0.6.0 [ 12314524 ]
          Fix Version/s 0.7.0 [ 12315150 ]
          Affects Version/s 0.6.0 [ 12314524 ]
          John Sichi made changes -
          Summary count distinct on multiple columns does not work support count(*) and count distinct on multiple columns
          Description
          The following query does not work:


          select count(distinct col1, col2) from Tbl
          The following query does not work:


          select count(distinct col1, col2) from Tbl
          Arvind Prabhakar made changes -
          Attachment HIVE-287-6-trunk.patch [ 12449136 ]
          Attachment HIVE-287-6-branch-0.6.patch [ 12449137 ]
          Arvind Prabhakar made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Arvind Prabhakar made changes -
          Attachment HIVE-287-5-trunk.patch [ 12448842 ]
          Attachment HIVE-287-5-branch-0.6.patch [ 12448843 ]
          John Sichi made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Arvind Prabhakar made changes -
          Attachment HIVE-287-4.patch [ 12447653 ]
          Arvind Prabhakar made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Arvind Prabhakar made changes -
          Attachment HIVE-287-3.patch [ 12447240 ]
          John Sichi made changes -
          Fix Version/s 0.6.0 [ 12314524 ]
          Namit Jain made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Arvind Prabhakar made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Arvind Prabhakar made changes -
          Attachment HIVE-287-2.patch [ 12445524 ]
          Namit Jain made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Arvind Prabhakar made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Fix Version/s 0.6.0 [ 12314524 ]
          Arvind Prabhakar made changes -
          Attachment HIVE-287-1.patch [ 12445090 ]
          Arvind Prabhakar made changes -
          Assignee Arvind Prabhakar [ aprabhakar ]
          Raghotham Murthy made changes -
          Field Original Value New Value
          Summary [hive] distinct on multiple columns does not work count distinct on multiple columns does not work
          Description

          The following query does not work:


          select count(distinct col1, col2) from Tbl

          The following query does not work:


          select count(distinct col1, col2) from Tbl
          Namit Jain created issue -

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development