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/%[email protected]%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*
