Hi Marek, How did you input the data and what does your CREATE TABLE/VIEW statement look like? What version of Phoenix and HBase are you using?
Also, would you mind running the following query and letting us know the output? select to_char(hu_ts,'yyyy-MM-dd HH:mm:ss.SSS'),hu_ho_id,hu_stream_id,hu_usage from se_dwh.homes_usage_hour where hu_ho_id in (4720,6854); Thanks, James On Mon, Apr 6, 2015 at 10:34 AM, Gabriel Reid <[email protected]> wrote: > That certainly looks like a bug. Would it be possible to make a small > reproducible test case and if possible, log this in the Phoenix JIRA > (https://issues.apache.org/jira/browse/PHOENIX) ? > > - Gabriel > > On Mon, Apr 6, 2015 at 6:10 PM Marek Wiewiorka <[email protected]> > wrote: >> >> Hi All, >> I came across a weird situation while running a query with group by. >> I executed 2 queries: >> >> 1) >> select trunc(hu_ts,'DAY',1),hu_ho_id,hu_stream_id,sum(hu_usage) from >> se_dwh.homes_usage_hour where hu_ho_id in (4720,6854) group by >> trunc(hu_ts,'DAY',1),hu_ho_id ,hu_stream_id; >> >> | 2015-03-19 00:00:00.000 | 4720 | 0 >> | 0.45599999999999996 | >> | 2015-03-19 00:00:00.000 | 6854 | 0 >> | 2.167 | >> >> >> 2) >> >> select trunc(hu_ts,'DAY',1),hu_ho_id,hu_stream_id,sum(hu_usage) from >> se_dwh.homes_usage_hour where hu_ho_id in (4720) group by >> trunc(hu_ts,'DAY',1),hu_ho_id ,hu_stream_id; >> >> | 2015-03-19 00:00:00.000 | 4720 | 0 >> | 8.405999999999999 | >> >> >> The only difference is that in the first case I included 2 ids(4720,6854) >> and in the other one only 1 (4720). >> The result for hu_ho_id=4720 should be the same in both case but it isn't >> (0.45 vs 8.4). >> The second result(8.4) is correct. >> >> Am I doing something wrong? >> >> Regards, >> Marek >> >
