I have Hive over Hbase table and below select statement starts failing. It was working good yesterday on my test environment.

[#1]

I have Hive over Hbase table and below select statement starts failing. It was working good yesterday on my test environment. SELECT pnt_key,compo_key,insertdatetime,updatedatetime,pntname,class ,pntlms,nrpts,btffcp FROM plant_details; Caused by: java.net.SocketTimeoutException: callTimeout=60000, callDuration=70103: row '@'�c�' on table 'prj_checmical:plant_details' at region=prj_checmical:plant_details,@'\x83\x06c\xF3c\x90,1432318674860.5b866583bf009e70c119b7e556e93591., hostname=xx.xx.xx.com,60020,1434977080863, seqNum=263939 at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:156) at org.apache.hadoop.hbase.client.ResultBoundedCompletionService$QueueingFuture.run(ResultBoundedCompletionService.java:64) ... 3 more Caused by: org.apache.hadoop.hbase.NotServingRegionException: org.apache.hadoop.hbase.NotServingRegionException: Region prj_checmical:plant_details,@'\x83\x06c\xF3c\x90,1432318674860.5b866583bf009e70c119b7e556e93591. is not online on xx.xx.xx.com,60020,1435671636832 at org.apache.hadoop.hbase.regionserver.HRegionServer.getRegionByEncodedName(HRegionServer.java:2774) at org.apache.hadoop.hbase.regionserver.HRegionServer.getRegion(HRegionServer.java:4257) at org.apache.hadoop.hbase.regionserver.HRegionServer.scan(HRegionServer.java:3156) at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:29994) at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2078) at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:108) at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:114) at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:94) at java.lang.Thread.run(Thread.java:745) I am new to HBase please help...

[#2]

can you please check regionservers are up and running , and please go to the hbase ui and see whether the region that is holding the row is served by any region.

[#3 · Accepted solution]

It seems that HBASE is having some issue, therefore cannot retrieve the rows from HBASE as some region server are not responding/down can cause this issue. Restarting region servers can resolve this issue.

[#4]

Yes, i report this issue to admin and they are restarting!! let you know once issue is resolved

[#5]

Hi @Vijayant kumar,

It's saying the region is not served by server. Can you check whether the region in transition at master UI if yes we need to check why it's in transition from master and RS logs. It would be better to post the logs for more details.