ql/src/test/queries/clientpositive/rename_column.q

CREATE TABLE kv_rename_test(a int, b int, c int);
DESCRIBE kv_rename_test;

ALTER TABLE kv_rename_test CHANGE a a STRING;
DESCRIBE kv_rename_test;
set hive.metastore.disallow.incompatible.col.type.changes=false;
ALTER TABLE kv_rename_test CHANGE a a1 INT;
DESCRIBE kv_rename_test;

EXPLAIN ALTER TABLE kv_rename_test CHANGE a1 a2 INT FIRST;
ALTER TABLE kv_rename_test CHANGE a1 a2 INT FIRST;
DESCRIBE kv_rename_test;

EXPLAIN ALTER TABLE kv_rename_test CHANGE a2 a INT AFTER b;
ALTER TABLE kv_rename_test CHANGE a2 a INT AFTER b;
DESCRIBE kv_rename_test;

ALTER TABLE kv_rename_test CHANGE a a1 INT COMMENT 'test comment1';
DESCRIBE kv_rename_test;

EXPLAIN ALTER TABLE kv_rename_test CHANGE a1 a2 INT COMMENT 'test comment2' FIRST;
ALTER TABLE kv_rename_test CHANGE a1 a2 INT COMMENT 'test comment2' FIRST;
DESCRIBE kv_rename_test;

ALTER TABLE kv_rename_test CHANGE COLUMN a2 a INT AFTER b;
DESCRIBE kv_rename_test;

DROP TABLE kv_rename_test;
SHOW TABLES LIKE "kv_rename_%";

-- Using non-default Database
CREATE DATABASE kv_rename_test_db;
USE kv_rename_test_db;

CREATE TABLE kv_rename_test(a int, b int, c int);
DESCRIBE kv_rename_test;

ALTER TABLE kv_rename_test CHANGE a a STRING;
DESCRIBE kv_rename_test;

ALTER TABLE kv_rename_test CHANGE a a1 INT;
DESCRIBE kv_rename_test;

ALTER TABLE kv_rename_test CHANGE a1 a2 INT FIRST;
DESCRIBE kv_rename_test;

ALTER TABLE kv_rename_test CHANGE a2 a INT AFTER b;
DESCRIBE kv_rename_test;

ALTER TABLE kv_rename_test CHANGE a a1 INT COMMENT 'test comment1';
DESCRIBE kv_rename_test;

ALTER TABLE kv_rename_test CHANGE a1 a2 INT COMMENT 'test comment2' FIRST;
DESCRIBE kv_rename_test;

ALTER TABLE kv_rename_test CHANGE COLUMN a2 a INT AFTER b;
DESCRIBE kv_rename_test;
reset hive.metastore.disallow.incompatible.col.type.changes;
DROP TABLE kv_rename_test;
SHOW TABLES LIKE "kv_rename_%";