| set hive.support.concurrency=true; |
| set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; |
| |
| CREATE TABLE alter_table_location2 (id int, name string, dept string) |
| PARTITIONED BY (year int) |
| STORED AS ORC |
| LOCATION 'pfile://${system:test.tmp.dir}/alter_table_location2' |
| TBLPROPERTIES ("transactional"="true"); |
| ; |
| |
| INSERT INTO alter_table_location2 PARTITION (year=2016) VALUES (8,'Henry','CSE'); |
| ALTER TABLE alter_table_location2 ADD PARTITION (year=2017); |
| |
| ALTER TABLE alter_table_location2 SET LOCATION 'hdfs:///tmp/alter_table_location2'; |
| |
| INSERT INTO alter_table_location2 PARTITION (year=2016) VALUES (9,'Horace','CSE'); |
| INSERT INTO alter_table_location2 PARTITION (year=2017) VALUES (10,'Harris','CSE'); |
| INSERT INTO alter_table_location2 PARTITION (year=2018) VALUES (11,'Humphrey','CSE'); |
| |
| SELECT * from alter_table_location2 order by id; |
| |