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

Reply via email to