James Taylor created PHOENIX-2039:
-------------------------------------
Summary: 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
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)
