lijinxiu123的博客

1、日期转周函数:weekofyear语法: weekofyear (string date)返回值: int说明:返回日期在当前的周数。举例：hive> select weekofyear('2011-12-08 10:03:01') from lxw_dual;2、LATERAL VIEW explode() 的用法参考链接：https:

hive字符串分割函数split(str, regex) - Splits str around occurances that match regexTime taken: 0.769 seconds, Fetched: 1 row(s)返回值为一个数组a.基本用法：例1：split('a,b,c,d',',')得到的结果：["a","b","c","d"] b.截取字符串中的某个值：当然，我们...