Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
Description
Repro steps
set hive.support.concurrency=true; set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; create table test_mm(age int, name string) partitioned by(dept string) stored as orc tblproperties('transactional'='true', 'transactional_properties'='default'); create external table test_external like test_mm LOCATION '${system:test.tmp.dir}/create_like_mm_to_external';
Fails with below exception
Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:default.test_external cannot be declared transactional because it's an external table) (state=08S01,code=1)
Attachments
Issue Links
- links to