摘要：删除分区： ALTER TABLE table_name DROP PARTITION (partition_name='20220101'); 阅读全文

摘要：（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') 阅读全文

摘要：select date_flag,category_flag,field,LAG(filed, 1) OVER (PARTITION BY category_flag ORDER BY date_flag) --同组前一个,LEAD(filed, 1) OVER (PARTITION BY cate 阅读全文

摘要：select year_flag,month_flag,field,SUM(field) OVER (PARTITION BY year_flag ORDER BY month_flag)from table ; 阅读全文

摘要：(1) INSERT INTOINSERT INTO tableVALUES ('aaa' , 111),('bbb' , 222); (2) insert overwrite insert overwrite table table(partition = '202301')select fiel 阅读全文