| set hive.ddl.output.format=json; | |
| CREATE TABLE IF NOT EXISTS jsontable (key INT, value STRING) COMMENT 'json table' STORED AS TEXTFILE; | |
| SHOW TABLES LIKE 'jsontab%'; | |
| SHOW TABLE EXTENDED LIKE 'jsontab%'; | |
| ALTER TABLE jsontable SET TBLPROPERTIES ('id' = 'jsontable'); | |
| DESCRIBE jsontable; | |
| DESCRIBE extended jsontable; | |
| DROP TABLE jsontable; | |
| set hive.ddl.output.format=text; |