[
https://issues.apache.org/jira/browse/PHOENIX-2062?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15199843#comment-15199843
]
Pranavan commented on PHOENIX-2062:
-----------------------------------
Hi!!
I am Pranavan from University of Moratuwa, Sri Lanka. I am interswted in doing
this project. Can someone give further input in this issue?
> 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)
