hi guys need help ! i was getting this exception while doing a select. hbase 1.1 with phoenix 4.6.
* SELECT * FROM EVENTS_PROD WHERE id = 100 AND ts IS NOT NULL AND ts BETWEEN 1462492800000 AND 1462536000000 ORDER BY ts DESC;* *------* *7 days retention* *150 regions* *got this error suddenly - no code changes.* *one solution is to truncate SYSTEM_STATS ? should i try it* *------* *java.lang.RuntimeException: org.apache.phoenix.schema.StaleRegionBoundaryCacheException: ERROR 1108 (XCL08): Cache of region boundaries are out of date.* *at sqlline.IncrementalRows.hasNext(IncrementalRows.java:73)* *at sqlline.SeparatedValuesOutputFormat.print(SeparatedValuesOutputFormat.java:31)* *at sqlline.SqlLine.print(SqlLine.java:1653)* *at sqlline.Commands.execute(Commands.java:833)* *at sqlline.Commands.sql(Commands.java:732)* *at sqlline.SqlLine.dispatch(SqlLine.java:808)* *at sqlline.SqlLine.begin(SqlLine.java:681)* *at sqlline.SqlLine.start(SqlLine.java:398)* *at sqlline.SqlLine.main(SqlLine.java:292)* -- with regards, ch Vishnu mash213.wordpress.com doodle-vishnu.blogspot.in
