[jira] [Created] (PHOENIX-2062) Support COUNT DISTINCT with multiple arguments

[James Taylor (JIRA)]

James Taylor created PHOENIX-2062:
-------------------------------------

             Summary: Support COUNT DISTINCT with multiple arguments
                 Key: PHOENIX-2062
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2062
             Project: Phoenix
          Issue Type: Bug
            Reporter: James Taylor


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)




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)