| 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; |