CREATE TABLE `detail_flow_test`(
`union_id` string COMMENT '设备唯一标识'
) COMMENT '站边表'
PARTITIONED BY (
`partition_date` string )
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
STORED AS INPUTFORMAT
'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
'hdfs://qunarcluster/user/traindev/tmp/detail_flow_test'
(2)新增字段:use mart_flow_test;
alter table detail_flow_test add columns(original_union_id string);
或者:alter table 表名 add columns (列名 STRING COMMENT 'Department name');
alter table detail_flow_test add columns (original_old string Comment '哈哈')
(3)修改注释:use original_union_id;