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;