phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dumindu Buddhika (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-2063) Row value constructor doesn't work when used in COUNT DISTINCT
Date Tue, 07 Jul 2015 01:59:04 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-2063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14616055#comment-14616055
] 

Dumindu Buddhika commented on PHOENIX-2063:
-------------------------------------------

It seems that reset() gets called once at each ResultSet.next() call . For this query it gets
called only once as ResulSet.next() is called only once to get the result. That may be the
reason for not resetting at each row for the COUNT DISTINCT?

> Row value constructor doesn't work when used in COUNT DISTINCT
> --------------------------------------------------------------
>
>                 Key: PHOENIX-2063
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2063
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: James Taylor
>            Assignee: Dumindu Buddhika
>         Attachments: PHOENIX-2063-v1.patch
>
>
> As a workaround for PHOENIX-2062, I tried the following query:
> {code}
> SELECT COUNT(DISTINCT (a.col1, b.col2)) ...
> {code}
> However, this always returns 1 as the COUNT DISTINCT which is wrong.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message