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

[#1]

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

[#2]

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