Support Questions
Find answers, ask questions, and share your expertise

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

Solved Go to solution

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

New Contributor

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...

1 ACCEPTED SOLUTION

Accepted Solutions

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

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.

View solution in original post

4 REPLIES 4

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

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.

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

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.

View solution in original post

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

New Contributor

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

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

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.