1.建表
CREATE TABLE IF NOT EXISTS all_type_table (
`c_in` INT,
`c_bi` BIGINT,
`c_st` STRING,
`c_do` DOUBLE,
`c_fl` FLOAT,
`c_de` DECIMAL(20,10),
`c_da` DATE,
`c_ts` TIMESTAMP,
`c_ba` BINARY,
`c_bl` BOOLEAN
)
COMMENT '类型遍历(去重、去空 )1'
PARTITIONED BY (
f1 STRING,
f2 STRING
);
2.修改表描述,字段描述
ALTER TABLE table_name SET TBLPROPERTIES('comment' = '表注释');
ALTER TABLE table_name CHANGE COLUMN column_name column_name_new STRING COMMENT '列注释!';