hive修改列名（原）

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;