支持的条件函数列表:
CASE 标准通用的函数
COALESCE 标准通用函数
DECODE oracle和impala专用函数
IF impala和mysql的函数
IFNULL impala和mysql的函数
ISFALSE
ISNOTFALSE
ISNOTTRUE
ISNULL
ISTRUE
NONNULLVALUE
NULLIF impala和oracle的函数
NULLIFZERO
NULLVALUE
NVL impala和oracle的函数
NVL2 impala和oracle的函数
ZEROIFNULL
可以看到impala为了和MySQL和oracle兼容直接使用了和他们名称一样的函数。
1.条件判断
2.NULL处理
3.TRUE FALSE 处理
4.NULL ZERO处理
参考:
http://impala.apache.org/docs/build/html/topics/impala_conditional_functions.html
https://docs.cloudera.com/documentation/enterprise/latest/topics/impala_conditional_functions.html
oracle相关函数:
nullif
https://docs.oracle.com/cd/E11882_01/server.112/e41084/functions116.htm#SQLRF00681
nvl
https://docs.oracle.com/cd/E11882_01/server.112/e41084/functions119.htm#SQLRF00684
nvl2
https://docs.oracle.com/cd/E11882_01/server.112/e41084/functions120.htm#SQLRF00685
COALESCE
https://docs.oracle.com/cd/E11882_01/server.112/e41084/functions030.htm#SQLRF00617
decode
https://docs.oracle.com/cd/E11882_01/server.112/e41084/functions049.htm#SQLRF00631
MySQL的流程控制函数:
CASE Case operator
IF() If/else construct
IFNULL() Null if/else construct
NULLIF() Return NULL if expr1 = expr2
https://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html
https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html#function_coalesce
参考:
https://blog.csdn.net/pan_junbiao/article/details/85928004