Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

HBase Hive Integration

HBase Hive Integration

New Contributor

Hi All,


I installed HDP 3.1 and try to implement the HBase and Hive Integration by following


I already did the hive.aux.jars.path configuration, but when trying to create a table via hive

CREATE EXTERNAL TABLE hbase_hive_table (key int, value string) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf1:val") TBLPROPERTIES ("" = "hbase_hive_table", "hbase.mapred.output.outputtable" = "hbase_hive_table");


It shows below error:

2019-10-21T10:26:46,452 INFO [HiveServer2-Background-Pool: Thread-78]: client.RpcRetryingCallerImpl (:()) - Call exception, tries=12, retries=16, started=68309 ms ago, cancelled=false, msg=org.apache.zookeeper.KeeperException$NoNodeException: KeeperErrorCode = NoNode for /hbase/meta-region-server, details=row 'hbase_hive_table' on table 'hbase:meta' at null


The job runs forever, is there any additional step for configuring the HBase and Hive Integration? Thanks in advance

Don't have an account?
Coming from Hortonworks? Activate your account here