mysql的一些整理

给一个表添加分区：

insert overwrite table reco.temp_lsj_missing_photo_4 partition(p_date='20200909')
select t1.user_id, t1.photo_list from reco.temp_lsj_current_missing_2 t1
where t1.p_date='20200909';

 

创建一个实时更新的分区表，并导入数据：

 

CREATE TABLE IF NOT EXISTS reco.special_user_photo_list (
user_id STRING COMMENT 'user_id',
photo_list STRING COMMENT 'photo_list, 以空格分隔'
) partitioned by (p_date string) stored AS parquet;
INSERT
overwrite TABLE reco.special_user_photo_list partition(p_date = '{{ ds_nodash }}')
SELECT user_id, photo_list
FROM   reco.temp_lsj_missing_photo_5
WHERE  p_date = '{{ ds_nodash }}';