[
https://issues.apache.org/jira/browse/PHOENIX-2062?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor updated PHOENIX-2062:
----------------------------------
Labels: gsoc2016 (was: )
> 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
> Labels: gsoc2016
>
> 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)
