原文地址：http://www.folkstalk.com/2011/11/conditional-functions-in-hive.html

CONDITIONAL FUNCTIONS IN HIVE

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

CASE Statement

The syntax for the case statement is:
CASE? [ expression ]
? WHEN condition1 THEN result1
? WHEN condition2 THEN result2
? ...
? WHEN conditionn THEN resultn
? ELSE result
END Here expression is optional. It is the value that you are comparing to the list of conditions. (ie: condition1, condition2, ... conditionn).

All the conditions must be of same datatype. Conditions are evaluated in the order listed. Once a condition is found to be true, the case statement will return the result and not evaluate the conditions any further.

All the results must be of same datatype. This is the value returned once a condition is found to be true.

IF no condition is found to be true, then the case statement will return the value in the ELSE clause. If the ELSE clause is omitted and no condition is found to be true, then the case statement will return NULL

Example:?

CASE Fruit
? WHEN 'APPLE' THEN 'The owner is APPLE'
? WHEN 'ORANGE' THEN 'The owner is ORANGE'
? ELSE 'It is another Fruit'
END The other form of CASE is

CASE?
? WHEN Fruit = 'APPLE' THEN 'The owner is APPLE'
? WHEN Fruit = 'ORANGE' THEN 'The owner is ORANGE'
? ELSE 'It is another Fruit'
END
創作挑戰賽新人創作獎勵來咯，堅持創作打卡瓜分現金大獎

總結

以上是生活随笔為你收集整理的hive 的条件判断（if、coalesce、case）的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。