[PHOENIX-2062] Support COUNT DISTINCT with multiple arguments

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: gsoc2016
• Assignee: Haoran Zhang
• Reporter: James R. Taylor
• Created: 24/Jun/15 01:30
• Updated: 28/Apr/16 01:59

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)