If your application allows it, you should restart your HBase to recompute the stats.
Alicia On Mon, Jul 18, 2016 at 1:11 PM, Michal Medvecky <[email protected]> wrote: > Hello, > > I have ~1B table and trying to select some columns. I get this exception: > > 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.TableOutputFormat.print(TableOutputFormat.java:33) > 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) > > I tried DELETE FROM SYSTEM.STATS WHERE PHYSICAL_NAME='MEDIA'; > > but did not help. > > Any suggestions? > > I'm using 4.6.0 on HBase 1.1. > > Thank you, > > Michal >
