org.apache.hadoop.hive.ql.exec.DDLTask. MetaException

[zoeminghong]

描述：

Hive on HBase 时创建表的时候，报如下错误

ERROR : FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Table default.t_student failed strict managed table checks due to the following reason: Table is marked as a managed table but is not transactional.)
INFO  : Completed executing command(queryId=hive_20190509143748_e915cb45-4846-4927-b5fd-8983507526fe); Time taken: 12.084 seconds
Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Table default.t_student failed strict managed table checks due to the following reason: Table is marked as a managed table but is not transactional.) (state=08S01,code=1)

方案：

是由于创建表的语句错误导致的。应该加上 external

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

参考文档：