alter table table_name set TBLPROPERTIES('EXTERNAL'='FALSE');
alter table yum_area_ods.ods_full_city_mapping add columns(taco_city_code string comment 'taco城市code') cascade;
alter table yum_area_ods.ods_full_city_mapping SET SERDEPROPERTIES('serialization.null.format' = '\\N');
msck repair table table_name;
alter table sds.dws_sds_reweight_appeal_count change column appeal_count appeal_count int;
删除重建表步骤:
alter table table_name set TBLPROPERTIES('EXTERNAL'='FALSE');
drop table table_name;
CREATE EXTERNAL TABLE if not exist
查看表分区字段类型:
desc table_name partition(inc_day = 20220228)
查看表分区路径:
desc formatted sds.sds_dws_dist_grow_rank_mi partition(inc_month=202202);