日常使用函数

字符切割：

KEYVALUE(ut.args,",","=","txcs_bizType";
SPLIT_PART(KEYVALUE(args,",","=","spm-pre"),'.', 1,2);
TO_CHAR((AVG(KEYVALUE(extra_info,";","=","page_stay_time")) ));

时间函数相关：

datediff(end_time,start_time,'ss');

bi_udf:sql_bi_get_date_2('${bizdate}',-90);

查询百分比排名，场景：
select *, percent_rank() over(partition by dept ORDER BY age DESC) as cnt from vito_test;
查询分区中大于等于当前行的数据的比例
select *, CUME_DIST() over(partition by dept ORDER BY age DESC) as cnt from vito_test;

sum over 窗口函数参考：

sum over()用法，以及与group by的区别-CSDN博客

窗口函数sum() over()不支持和group by同时使用?_sum()over()和group by可以一起使用吗-CSDN博客

rlike ,like ,not like参考：

Hive中rlike,like,not like，regexp区别与使用详解_hive rlike-CSDN博客

mySQl中行转列，列转行：

MySQL中的行转列和列转行 - 墨天轮