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

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

New Contributor

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

1 REPLY 1

Expert Contributor

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 

; ;