摘要: 删除分区: ALTER TABLE table_name DROP PARTITION (partition_name='20220101'); 阅读全文
posted @ 2022-02-25 10:24 冉溪 阅读(37) 评论(0) 推荐(0) 编辑
摘要: (1)concat_ws() select user ,concat_ws(';' , collect_set(cast(amt as string))) as amt from table group by user (2)concat() select concat('202211','04') 阅读全文
posted @ 2022-02-25 10:21 冉溪 阅读(265) 评论(0) 推荐(0) 编辑