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

insert into hive from hbase report error

New Contributor
in hive cmd:
create talbe a as select * from hbase.tb ; it run OK
but 
insert into a select * from hbase.tb; it report error:
org.apache.hadoop.hbase.client.RetriesExhaustedException: Can't get the location for replica 0
......
Caused by: java.io.IOException: org.apache.zookeeper.KeeperException$NoNodeException: KeeperErrorCode = NoNode for /hbase/meta-region-server



......
Caused by: java.io.IOException: org.apache.zookeeper.KeeperException$NoNodeException: KeeperErrorCode = NoNode for /hbase/meta-region-server

1 REPLY 1

Super Collaborator

Hello @jiaozz 

 

It's an Old Post, yet submitting a response to anyone encountering such issue. Yet, Kindly test the 2 approaches below:

(I) At Hive Session Level, Execute "ADD FILE <HBase Configuration File>"

(II) Add the HBase Config to "HIVE_AUX_JARS_PATH" Path at Hive Service Level. 

 

In short, the issue appears upon HBase Config being not correctly set, even though the 1st Create Table Hive SQL runs successfully yet fails upon any Table created referencing the Hive Table created in the 1st SQL. 

 

- Smarak