Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-2062

Support COUNT DISTINCT with multiple arguments

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      I have a situation where I want to count the distinct combination of a couple of columns.

      When I try the following:-

      select count(distinct a.col1, b.col2)
      from table tab1 a
      inner join tab2 b on b.joincol = a.joincol
      where a.col3 = ‘some condition’
      and b.col4 = ‘some other condition';

      I get the following error:-

      Error: ERROR 605 (42P00): Syntax error. Unknown function: "DISTINCT_COUNT". (state=42P00,code=605)

      Attachments

        Activity

          People

            RCheungIT Haoran Zhang
            jamestaylor James R. Taylor
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated: