You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@phoenix.apache.org by Pham Phuong Tu <tu...@gmail.com> on 2014/07/02 04:29:42 UTC

Phoenix wrong range query result

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 TuBack-end & Big data developerSkype: phamphuongtu*

Re: Phoenix wrong range query result

Posted by Pham Phuong Tu <tu...@gmail.com>.

Here is JIRA issue of this problem:
https://issues.apache.org/jira/browse/PHOENIX-1057

Re: Phoenix wrong range query result

Posted by James Taylor <ja...@apache.org>.

Please file a JIRA and attach a reproducible test case.
Thanks,
James

On Wed, Jul 2, 2014 at 4:29 AM, Pham Phuong Tu <tu...@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