MaYingColdPlay的博客

无

select t1.*,sign_combination,split(sign_combination,':')[0] as sign_spu_id,split(sign_combination,':')[1] as sign_spu_id_scorefrom (SELECT spu_id,spu_name,split(sign_combination_list,"\\;") as sign_combination_list1from table) t1 LATERAL VIEW exp.

1.聚合2.展开3.排列 row numberhttps://zhuanlan.zhihu.com/p/92654574select *, row_number() over (partition by uuid order by uuid_spu_cate_search_weight desc) as ranking from table1 WHERE dt='20201230' limit 1000...

alter table XXX add columns(XXX String comment 'XXX')