HIve汇总

nvl(value,defauleval)

case when then else end----if(条件，true,false)

concat_ws(separator,str1,str2...)

collect_set()  collect_list()

explode(array/map)      split(str,regex)           lateral view

开窗

date_format(2022-10-3,'yyyy-MM')

lag/lead(col,n,default) over()---------------datediff(date,date)

from_unixtime(cast(payment*0.001 as bigint),'yyyy-MM')

date_sub(date,num)

--计算出时间相差的秒钟          "2022-03-09 00:00:00"可