--! qt:dataset:src

set hive.support.concurrency=true;
set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;


set hive.create.as.insert.only=false;
create table non_mm0 as select key from src limit 1;
create table mm0 tblproperties("transactional"="true", "transactional_properties"="insert_only")
 as select key from src limit 1;
create table acid0 (key string) stored as ORC  tblproperties("transactional"="true");


set hive.create.as.insert.only=true;
create table mm1 like non_mm0;
create table mm2 like mm0;
create table acid1_n0 like acid0;
create table mm3 as select key from src limit 1;
create table mm4 (key string);
create table acid2_n0 (key string) stored as ORC  tblproperties("transactional"="true");
create table non_mm1 tblproperties("transactional"="false")
 as select key from src limit 1;

set hive.create.as.insert.only=false;

desc formatted mm1;
desc formatted mm2;
desc formatted mm3;
desc formatted mm4;
desc formatted non_mm1;
desc formatted acid1_n0;
desc formatted acid2_n0;


drop table non_mm0;
drop table non_mm1;
drop table mm0;
drop table mm1;
drop table mm2;
drop table mm3;
drop table mm4;
drop table acid0;
drop table acid1_n0;
drop table acid2_n0;