--! qt:dataset:src
--! qt:dataset:part
set hive.mapred.mode=nonstrict;

dfs ${system:test.dfs.mkdir} ${system:test.tmp.dir}/ex_table;

CREATE EXTERNAL TABLE ex_table ( key INT, value STRING)
    PARTITIONED BY (part STRING)
    STORED AS textfile
	LOCATION 'file:${system:test.tmp.dir}/ex_table';

INSERT OVERWRITE TABLE ex_table PARTITION (part='part1')
SELECT key, value FROM src WHERE key < 10;

SHOW PARTITIONS ex_table;
SELECT * from ex_table where part='part1' ORDER BY key;

dfs -ls ${system:test.tmp.dir}/ex_table/part=part1;
dfs -cat ${system:test.tmp.dir}/ex_table/part=part1/000000_0;

ANALYZE TABLE ex_table PARTITION (part='part1') COMPUTE STATISTICS FOR COLUMNS;
DESCRIBE FORMATTED ex_table;
DESCRIBE FORMATTED ex_table PARTITION (part='part1');
DESCRIBE FORMATTED ex_table PARTITION (part='part1') key;
DESCRIBE FORMATTED ex_table PARTITION (part='part1') value;

ALTER TABLE ex_table PARTITION (part='part1') RENAME TO PARTITION (part='part2');

SHOW PARTITIONS ex_table;
SELECT * from ex_table where part='part2' ORDER BY key;

dfs -ls ${system:test.tmp.dir}/ex_table/part=part1;
dfs -cat ${system:test.tmp.dir}/ex_table/part=part1/000000_0;

DESCRIBE FORMATTED ex_table;
DESCRIBE FORMATTED ex_table PARTITION (part='part2');
DESCRIBE FORMATTED ex_table PARTITION (part='part2') key;
DESCRIBE FORMATTED ex_table PARTITION (part='part2') value;