set hive.mapred.mode=nonstrict;
set hive.support.concurrency=true;
set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
set hive.exec.dynamic.partition=true;

create table T1_n163(key string, val string) stored as textfile;

LOAD DATA LOCAL INPATH '../../data/files/T1.txt' INTO TABLE T1_n163;

select * from T1_n163;

create table T2_n95(key string) partitioned by (val string) stored as textfile;

insert overwrite table T2_n95 partition (val) select key, val from T1_n163;

select * from T2_n95;

drop table T1_n163;
drop table T2_n95;