没有合适的资源?快使用搜索试试~ 我知道了~
首页Hive函数大全.pdf
Hive函数大全.pdf
需积分: 48 23 下载量 36 浏览量
更新于2023-10-23
评论 3
收藏 515KB PDF 举报
大佬总结的hive的各种常用函数语法格式及其用法,Hive内部提供了很多函数给开发者使用,包括数学函数,类型转换函数,条件函数,字符函数,聚合函数,表生成函数等等
资源详情
资源评论
资源推荐
Hive 函数大全 http://lxw1234.com
2
lxw 的大数据田地 http://lxw1234.com
目录
一、关系运算: ....................................................................................................................... 6
1. 等值比较: = .................................................................................................................. 6
2. 等值比较:<=> ............................................................................................................... 6
3. 不等值比较: <>和!= .................................................................................................... 6
4. 小于比较: < .................................................................................................................. 6
5. 小于等于比较: <= ........................................................................................................ 7
6. 大于比较: > .................................................................................................................. 7
7. 大于等于比较: >= ........................................................................................................ 7
8. 区间比较 ...................................................................................................................... 8
9. 空值判断: IS NULL ....................................................................................................... 8
10. 非空判断: IS NOT NULL ............................................................................................. 8
10. LIKE 比较: LIKE ............................................................................................................ 8
11. JAVA 的 LIKE 操作: RLIKE ............................................................................................ 9
12. REGEXP 操作: REGEXP ................................................................................................ 9
二、数学运算: ..................................................................................................................... 10
1. 加法操作: + ................................................................................................................ 10
2. 减法操作: - ................................................................................................................ 10
3. 乘法操作: * ................................................................................................................ 10
4. 除法操作: / ................................................................................................................ 11
5. 取余操作: % ............................................................................................................... 11
6. 位与操作: & ............................................................................................................... 11
7. 位或操作: | ................................................................................................................ 12
8. 位异或操作: ^ ............................................................................................................ 12
9.位取反操作: ~ ........................................................................................................... 12
三、逻辑运算: ..................................................................................................................... 13
1. 逻辑与操作: AND 、&& ........................................................................................... 13
2. 逻辑或操作: OR 、|| ............................................................................................... 13
3. 逻辑非操作: NOT、! ................................................................................................. 13
四、复合类型构造函数 ......................................................................................................... 14
1. map 结构 .................................................................................................................... 14
2. struct 结构 .................................................................................................................. 14
3. named_struct 结构 ..................................................................................................... 14
4. array 结构 ................................................................................................................... 14
5. create_union ............................................................................................................... 15
五、复合类型操作符 ............................................................................................................. 15
1. 获取 array 中的元素 ................................................................................................. 15
2. 获取 map 中的元素 .................................................................................................. 15
3. 获取 struct 中的元素 ................................................................................................ 16
六、数值计算函数 ................................................................................................................. 16
1. 取整函数: round ........................................................................................................ 16
2. 指定精度取整函数: round ........................................................................................ 16
3. 向下取整函数: floor .................................................................................................. 17
Hive 函数大全 http://lxw1234.com
3
lxw 的大数据田地 http://lxw1234.com
4. 向上取整函数: ceil .................................................................................................... 17
5. 向上取整函数: ceiling ............................................................................................... 17
6. 取随机数函数: rand .................................................................................................. 17
7. 自然指数函数: exp .................................................................................................... 18
8. 以 10 为底对数函数: log10 ....................................................................................... 18
9. 以 2 为底对数函数: log2 ........................................................................................... 19
10. 对数函数: log ........................................................................................................... 19
11. 幂运算函数: pow ..................................................................................................... 19
12. 幂运算函数: power ................................................................................................. 19
13. 开平方函数: sqrt ..................................................................................................... 20
14. 二进制函数: bin ....................................................................................................... 20
15. 十六进制函数: hex .................................................................................................. 20
16. 反转十六进制函数: unhex ...................................................................................... 20
17. 进制转换函数: conv ................................................................................................ 21
18. 绝对值函数: abs ...................................................................................................... 21
19. 正取余函数: pmod .................................................................................................. 21
20. 正弦函数: sin ........................................................................................................... 22
21. 反正弦函数: asin ..................................................................................................... 22
22. 余弦函数: cos .......................................................................................................... 22
23. 反余弦函数: acos .................................................................................................... 22
24. positive 函数: positive .............................................................................................. 23
25. negative 函数: negative ............................................................................................ 23
七、集合操作函数 ................................................................................................................. 23
1. map 类型大小:size ................................................................................................... 23
2. array 类型大小:size .................................................................................................. 23
3. 判断元素数组是否包含元素:array_contains ........................................................ 24
4. 获取 map 中所有 value 集合 .................................................................................... 24
5. 获取 map 中所有 key 集合 ....................................................................................... 24
6. 数组排序 .................................................................................................................... 24
八、类型转换函数 ................................................................................................................. 25
1. 二进制转换:binary ................................................................................................. 25
2. 基础类型之间强制转换:cast ................................................................................. 25
九、日期函数 ......................................................................................................................... 25
1. UNIX 时间戳转日期函数: from_unixtime .................................................................. 25
2. 获取当前 UNIX 时间戳函数: unix_timestamp ......................................................... 26
3. 日期转 UNIX 时间戳函数: unix_timestamp ............................................................. 26
4. 指定格式日期转 UNIX 时间戳函数: unix_timestamp.............................................. 26
5. 日期时间转日期函数: to_date ................................................................................. 26
6. 日期转年函数: year ................................................................................................... 27
7. 日期转月函数: month ............................................................................................... 27
8. 日期转天函数: day .................................................................................................... 27
9. 日期转小时函数: hour .............................................................................................. 28
10. 日期转分钟函数: minute ........................................................................................ 28
11. 日期转秒函数: second ............................................................................................ 28
Hive 函数大全 http://lxw1234.com
4
lxw 的大数据田地 http://lxw1234.com
12. 日期转周函数: weekofyear ..................................................................................... 28
13. 日期比较函数: datediff ........................................................................................... 29
14. 日期增加函数: date_add ........................................................................................ 29
15. 日期减少函数: date_sub ......................................................................................... 29
十、条件函数 ......................................................................................................................... 29
1. If 函数: if ..................................................................................................................... 29
2. 非空查找函数: COALESCE ......................................................................................... 30
3. 条件判断函数:CASE ............................................................................................... 30
4. 条件判断函数:CASE ............................................................................................... 30
十一、字符串函数 ................................................................................................................. 31
1. 字符 ascii 码函数:ascii ......................................................................................... 31
2. base64 字符串 ........................................................................................................ 31
3. 字符串连接函数:concat ......................................................................................... 31
4. 带分隔符字符串连接函数:concat_ws ................................................................ 31
5. 数组转换成字符串的函数:concat_ws ................................................................. 32
6. 小数位格式化成字符串函数:format_number ..................................................... 32
7. 字符串截取函数:substr,substring .......................................................................... 32
8. 字符串截取函数:substr,substring .......................................................................... 33
9. 字符串查找函数:instr ............................................................................................ 33
10. 字符串长度函数:length ....................................................................................... 33
11. 字符串查找函数:locate ........................................................................................ 33
12. 字符串格式化函数:printf ..................................................................................... 34
13. 字符串转换成 map 函数:str_to_map ................................................................. 34
14. base64 解码函数:unbase64(string str) .................................................................. 34
15. 字符串转大写函数:upper,ucase .......................................................................... 35
16. 字符串转小写函数:lower,lcase ............................................................................ 35
17. 去空格函数:trim ................................................................................................... 35
18. 左边去空格函数:ltrim .......................................................................................... 36
19. 右边去空格函数:rtrim ......................................................................................... 36
20. 正则表达式替换函数:regexp_replace ................................................................. 36
21. 正则表达式解析函数:regexp_extract .................................................................. 36
22. URL 解析函数:parse_url ........................................................................................ 37
23. json 解析函数:get_json_object ............................................................................. 37
24. 空格字符串函数:space ........................................................................................ 38
25. 重复字符串函数:repeat ....................................................................................... 38
26. 左补足函数:lpad ................................................................................................... 38
27. 右补足函数:rpad .................................................................................................. 39
28. 分割字符串函数: split ............................................................................................. 39
29. 集合查找函数: find_in_set...................................................................................... 39
30. 分词函数:sentences ..................................................................................... 39
31. 分词后统计一起出现频次最高的 TOP-K ............................................................... 40
32. 分词后统计与指定单词一起出现频次最高的 TOP-K ........................................... 40
十二、混合函数 ..................................................................................................................... 41
1. 调用 Java 函数:java_method .................................................................................. 41
Hive 函数大全 http://lxw1234.com
5
lxw 的大数据田地 http://lxw1234.com
2. 调用 Java 函数:reflect ............................................................................................ 41
3. 字符串的 hash 值:hash .......................................................................................... 41
十三、XPath 解析 XML 函数 ................................................................................................. 42
1. xpath............................................................................................................................ 42
2. xpath_string ................................................................................................................ 42
3. xpath_boolean ............................................................................................................ 42
4. xpath_short, xpath_int, xpath_long ............................................................................ 43
5. xpath_float, xpath_double, xpath_number ................................................................ 43
十四、汇总统计函数(UDAF) ............................................................................................ 44
1. 个数统计函数: count ................................................................................................ 44
2. 总和统计函数: sum ................................................................................................... 44
3. 平均值统计函数: avg ................................................................................................ 45
4. 最小值统计函数: min................................................................................................ 45
5. 最大值统计函数: max ............................................................................................... 45
6. 非空集合总体变量函数: var_pop ............................................................................ 45
7. 非空集合样本变量函数: var_samp .......................................................................... 46
8. 总体标准偏离函数: stddev_pop ............................................................................... 46
9. 样本标准偏离函数: stddev_samp ............................................................................ 46
10.中位数函数: percentile .......................................................................................... 46
11. 中位数函数: percentile ........................................................................................... 46
12. 近似中位数函数: percentile_approx ...................................................................... 47
13. 近似中位数函数: percentile_approx ...................................................................... 47
14. 直方图: histogram_numeric .................................................................................... 47
15. 集合去重数:collect_set ........................................................................................ 47
16. 集合不去重函数:collect_list ................................................................................ 48
十五、表格生成函数 Table-Generating Functions (UDTF) ................................................... 48
1. 数组拆分成多行:explode ....................................................................................... 48
2. Map 拆分成多行:explode........................................................................................ 49
剩余48页未读,继续阅读
Doctor_96
- 粉丝: 11
- 资源: 9
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- RTL8188FU-Linux-v5.7.4.2-36687.20200602.tar(20765).gz
- c++校园超市商品信息管理系统课程设计说明书(含源代码) (2).pdf
- 建筑供配电系统相关课件.pptx
- 企业管理规章制度及管理模式.doc
- vb打开摄像头.doc
- 云计算-可信计算中认证协议改进方案.pdf
- [详细完整版]单片机编程4.ppt
- c语言常用算法.pdf
- c++经典程序代码大全.pdf
- 单片机数字时钟资料.doc
- 11项目管理前沿1.0.pptx
- 基于ssm的“魅力”繁峙宣传网站的设计与实现论文.doc
- 智慧交通综合解决方案.pptx
- 建筑防潮设计-PowerPointPresentati.pptx
- SPC统计过程控制程序.pptx
- SPC统计方法基础知识.pptx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0