Error while Creating an external table in hive to query hbase table

M129 — Tue, 21 Apr 2026 07:59:54 GMT

Creating an external table in hive to query hbase table in CDP 7

CREATE EXTERNAL TABLE emp(id INT, empno INT,ename STRING,designation STRING, manager INT, salary INT,deptno INT) STORED BY "org.apache.hadoop.hive.hbase.HBaseStorageHandler" WITH SERDEPROPERTIES ( "hbase.columns.mapping" =':key,cf:empno,cf:enmae,cf:designation,cf:manager,cf:salary,cf:deptno') TBLPROPERTIES("hbase.table.name" = "emp_data");

ERROR :

FAILED: Execution Error, return code 40000 from org.apache.hadoop.hive.ql.ddl.DDLTask. org/apache/hadoop/hbase/mapreduce/TableInputFormatBase
22/03/09 12:16:40 [HiveServer2-Background-Pool: Thread-25]: ERROR ql.Driver: FAILED: Execution Error, return code 40000 from org.apache.hadoop.hive.ql.ddl.DDLTask. org/apache/hadoop/hbase/mapreduce/TableInputFormatBase
OK

Re: Error while Creating an external table in hive to query hbase table

mszurap — Thu, 10 Mar 2022 08:42:11 GMT

Hi @M129 ,

the error message is not too descriptive. Can you please check the HiveMetaStore logs what is the complete error message - and reason for the failure?

Thanks

Miklos

question Error while Creating an external table in hive to query hbase table in Support Questions

Error while Creating an external table in hive to query hbase table

Re: Error while Creating an external table in hive to query hbase table