#删除已存在的表
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 po_weibo_comment_data;