phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Phoenix wrong range query result
Date Wed, 02 Jul 2014 07:52:29 GMT
Please file a JIRA and attach a reproducible test case.
Thanks,
James

On Wed, Jul 2, 2014 at 4:29 AM, Pham Phuong Tu <tuphamphuong@gmail.com> wrote:
> Hi guys,
>
> I have one big problem with Phoenix is some time, range query like: >, <,
> <=, >= return missing one or more result,
>
> E.g:
> SELECT count(1) AS total, hour_time FROM device2 where hour_time
>>=1403974800 and hour_time < 1404061199 GROUP BY hour_time ORDER BY
> hour_time
>
> The result of this query return missing value 1404000000 of hour_time, of
> course 1403974800 <= 1404000000 < 1404061199.
>
> This kind of bug resolved in a lot of topic, i don't understand why it still
> apper:
>
> http://mail-archives.apache.org/mod_mbox/phoenix-dev/201403.mbox/%3CJIRA.12700068.1394495218035.81228.1394954374732@arcas%3E
> https://groups.google.com/forum/#!topic/phoenix-hbase-user/mZxSFxpqjS4
> http://mail-archives.apache.org/mod_mbox/phoenix-user/201404.mbox/%3C1398727966.67421.YahooMailNeo@web165003.mail.bf1.yahoo.com%3E
>
> My system run Hbase 0.98 and Phoenix 4.0. Now i run Phoenix for production,
> please tell me how to fix this bug.
>
> --
> -----------------------------------------
>
> Pham Phuong Tu
> Back-end & Big data developer
> Skype: phamphuongtu

Mime
View raw message