phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-2039) ROUND over numeric in GROUP BY always returns null
Date Tue, 05 Jan 2016 13:17:40 GMT

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

Hudson commented on PHOENIX-2039:
---------------------------------

FAILURE: Integrated in Phoenix-master #1048 (See [https://builds.apache.org/job/Phoenix-master/1048/])
PHOENIX-2039 ROUND over numeric in GROUP BY always returns null (ramkrishna: rev ab8fa5ef436588d8f285f6e8c4bf8e79edbd71ed)
* phoenix-core/src/it/java/org/apache/phoenix/end2end/RoundFloorCeilFunctionsEnd2EndIT.java


> ROUND over numeric in GROUP BY always returns null
> --------------------------------------------------
>
>                 Key: PHOENIX-2039
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2039
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: James Taylor
>            Assignee: ramkrishna.s.vasudevan
>              Labels: newbie
>             Fix For: 4.7.0
>
>         Attachments: PHOENIX-2039.patch
>
>
> Here's an easy way to reproduce:
> {code}
> create table round_test(k bigint primary key);
> upsert into round_test values(1380603308885);
> select round(k/1000000,0) from round_test;
> +----------------------------------------+
> |             (K / 1000000)              |
> +----------------------------------------+
> | 1380603                                |
> +----------------------------------------+
> select round(k/1000000,0) x from round_test group by x;
> +----------------------------------------+
> |                   X                    |
> +----------------------------------------+
> | null                                   |
> +----------------------------------------+
> {code}
> Here's a work around:
> {code}
> select round(cast(k as date),'MINUTE',30) x from round_test group by x;
> +-------------------------+
> |            X            |
> +-------------------------+
> | 2013-10-01 05:00:00.000 |
> +-------------------------+
> select cast(round(cast(k as date),'MINUTE',30) as bigint) x 
> from round_test group by x;
> +------------------------------------------+
> |                    X                     |
> +------------------------------------------+
> | 1380603600000                            |
> +------------------------------------------+
> {code}



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

Mime
View raw message