| set hive.mapred.mode=nonstrict; |
| set hive.support.concurrency=true; |
| set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; |
| |
| create table T1_n111(key string, val string) stored as textfile; |
| |
| LOAD DATA LOCAL INPATH '../../data/files/T1.txt' INTO TABLE T1_n111; |
| |
| select * from T1_n111; |
| |
| create table T2_n67(key string, val string) partitioned by (pval string) stored as textfile; |
| |
| insert into table T2_n67 partition (pval = '1') select * from T1_n111; |
| |
| select * from T2_n67; |
| |
| insert overwrite table T2_n67 partition (pval = '1') select * from T1_n111; |
| |
| select * from T2_n67; |
| |
| drop table T1_n111; |
| drop table T2_n67; |