[ https://issues.apache.org/jira/browse/PHOENIX-2064?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dumindu Buddhika updated PHOENIX-2064: -------------------------------------- Attachment: PHOENIX-2064-v3.patch Oops.. The return statement. Sorry for the mistake. Thanks for the help. Here is the patch > ARRAY constructor doesn't work when used in COUNT DISTINCT > ---------------------------------------------------------- > > Key: PHOENIX-2064 > URL: https://issues.apache.org/jira/browse/PHOENIX-2064 > Project: Phoenix > Issue Type: Bug > Reporter: James Taylor > Assignee: Dumindu Buddhika > Attachments: PHOENIX-2064-v2.patch, PHOENIX-2064-v3.patch, > PHOENIX-2064.patch > > > As a workaround for PHOENIX-2062, I tried the following query: > {code} > SELECT COUNT(DISTINCT ARRAY[a.col1, b.col2]) ... > {code} > However, this always returns the full number of rows which is wrong. -- This message was sent by Atlassian JIRA (v6.3.4#6332)