hi i am running a single node hortonworks HDP2.1
i have 150Million rows in a table, while indexing the table on a column, it
is giving the error
0: jdbc:phoenix:localhost:/hbase-unsecure> CREATE INDEX INDEX_MONTHS ON
MONTHS_DATA (VCOUNT);
Error: (state=08000,code=101)
i increased the phoenix keepalive and querytimeout to 1hr
anypointers how to overcome this issue?
in regionserver logs i see this exception,
org.apache.hadoop.hbase.NotServingRegionException:
INDEX_MONTHS,\x80\x00\x80\x00\x00\x00\x00\x0F\xB1\x0D03/3,1407840676629.0158a3bd2e191361e2950ae3eb0
a9016. is closing
at
org.apache.hadoop.hbase.regionserver.HRegion.startRegionOperation(HRegion.java:5742)
at
org.apache.hadoop.hbase.regionserver.HRegion.startRegionOperation(HRegion.java:5706)
at
org.apache.hadoop.hbase.regionserver.HRegion.getRowLock(HRegion.java:3438)
at
org.apache.hadoop.hbase.regionserver.HRegion.doMiniBatchMutation(HRegion.java:2323)
at
org.apache.hadoop.hbase.regionserver.HRegion.batchMutate(HRegion.java:2190)
at
org.apache.hadoop.hbase.regionserver.HRegion.batchMutate(HRegion.java:2142)
at
org.apache.hadoop.hbase.regionserver.HRegion.batchMutate(HRegion.java:2146)
at
org.apache.hadoop.hbase.regionserver.HRegionServer.doBatchOp(HRegionServer.java:4240)
at
org.apache.hadoop.hbase.regionserver.HRegionServer.doNonAtomicRegionMutation(HRegionServer.java:3463)
at
org.apache.hadoop.hbase.regionserver.HRegionServer.multi(HRegionServer.java:3367)
at
org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:28867)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2008)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:92)
at
org.apache.hadoop.hbase.ipc.SimpleRpcScheduler.consumerLoop(SimpleRpcScheduler.java:160)
at
org.apache.hadoop.hbase.ipc.SimpleRpcScheduler.access$000(SimpleRpcScheduler.java:38)
at
org.apache.hadoop.hbase.ipc.SimpleRpcScheduler$1.run(SimpleRpcScheduler.java:110)
at java.lang.Thread.run(Thread.java:744)
thanks,
yeshwanth