MaYingColdPlay的博客

无

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

1.聚合 2.展开 3.排列 row number https://zhuanlan.zhihu.com/p/92654574 select *, 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' )