| |
| set hive.support.concurrency=true; |
| set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; |
| |
| set metastore.strict.managed.tables=true; |
| set hive.default.fileformat=textfile; |
| set hive.default.fileformat.managed=orc; |
| |
| set metastore.create.as.acid=true; |
| set hive.create.as.insert.only=false; |
| |
| drop table if exists smt2_tab1; |
| drop table if exists smt2_tab2; |
| drop table if exists smt2_tab3; |
| drop table if exists smt2_tab4; |
| drop table if exists smt2_tab5; |
| drop table if exists smt2_tab6; |
| |
| create external table smt2_tab1 (c1 string, c2 string); |
| show create table smt2_tab1; |
| |
| create table smt2_tab2 (c1 string, c2 string); |
| show create table smt2_tab2; |
| |
| create table smt2_tab3 (c1 string, c2 string) stored as orc; |
| show create table smt2_tab3; |
| |
| set metastore.create.as.acid=false; |
| set hive.create.as.insert.only=true; |
| |
| create external table smt2_tab4 (c1 string, c2 string) stored as orc; |
| show create table smt2_tab4; |
| |
| create table smt2_tab5 (c1 string, c2 string); |
| show create table smt2_tab5; |
| |
| create table smt2_tab6 (c1 string, c2 string) stored as textfile; |
| show create table smt2_tab6; |
| |
| drop table if exists smt2_tab1; |
| drop table if exists smt2_tab2; |
| drop table if exists smt2_tab3; |
| drop table if exists smt2_tab4; |
| drop table if exists smt2_tab5; |
| drop table if exists smt2_tab6; |
| |