You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2016/04/28 03:59:13 UTC

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

     [ https://issues.apache.org/jira/browse/PHOENIX-2062?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

James Taylor updated PHOENIX-2062:
----------------------------------
    Assignee: Haoran Zhang

> 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
>            Assignee: Haoran Zhang
>              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)