set hive.ddl.output.format=json;

CREATE TABLE IF NOT EXISTS jsontable_n0 (key INT, value STRING) COMMENT 'json table' STORED AS TEXTFILE;

ALTER TABLE jsontable_n0 ADD COLUMNS (name STRING COMMENT 'a new column'); 

ALTER TABLE jsontable_n0 RENAME TO jsontable2;

SHOW TABLE EXTENDED LIKE jsontable2;

DROP TABLE jsontable2;

set hive.ddl.output.format=text;