phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pham Phuong Tu <tuphamphu...@gmail.com>
Subject Phoenix wrong range query result
Date Wed, 02 Jul 2014 02:29:42 GMT
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*

Mime
View raw message