hive 删除原外部表，新建一样新表，同步原分区元数据的命令方法：msck repair table 表名

#删除已存在的表
drop table if exists user_data;
 
#新建表
create external table if not exists user_data(
user_id string,
name string,
age int
)PARTITIonED BY(ds string)
CLUSTERED BY (user_id) INTO 10 BUCKETS
ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.MultiDelimitSerDe' WITH SERDEPROPERTIES ('field.delim'='§')
STORED AS TEXTFILE TBLPROPERTIES ('serialization.encoding'='utf-8');
 

#同步旧表的分区数据
msck repair table user_data;
#这里table后面接旧表名称，要同步的