Hive 中函数总结
2024-10-20 11:56:32
Hive supports three types of conditional functions. These functions are listed below:
IF( Test Condition, True Value, False Value )
The IF condition evaluates the “Test Condition” and if the “Test Condition” is true, then it returns the “True Value”. Otherwise, it returns the False Value.
Example: IF(1=1, 'working', 'not working') returns 'working'
COALESCE( value1,value2,... )
The COALESCE function returns the fist not NULL value from the list of values. If all the values in the list are NULL, then it returns NULL.
Example: COALESCE(NULL,NULL,5,NULL,4) returns 5
最新文章
- linux中ls命令
- Apache Spark源码走读之16 -- spark repl实现详解
- SQL Server ->;>; 分区表上创建唯一分区索引
- URAL1133. Fibonacci Sequence(二分)
- Linux的网卡由eth0变成了eth1,如何修复?
- !!!全球最流行开源硬件平台!不知道就OUT了!
- Dockerfile与Docker构建流程解读
- Redis 安装(一)
- DAY5-小别-2018-1-15
- Ceph rdb
- 【转】Install Win32 OpenSSH (test release)
- JS Replace 全部替换字符的用法小结
- HTML 选择目录
- mac navicate 2013 - Lost connection to MySQL server at 'reading initial communication packet
- nginx 学习资料
- alv界面透视功能
- js解码编码decodeURI与decodeURIComponent区别
- java实现返回一个字符串所有排列
- 基于python 3.5 所做的找出来一个字符串中最长不重复子串算法
- CUBA Platform —— 开源的、可靠的企业级应用开发利器