Question: how nvl works in hive?
Answer: You can use OR, IN, REGEXP in the CASE expressions. ... You can use OR, IN, REGEXP in the CASE expressions. NVL(arg1, arg2) This function will test if expression is null, it'll return expression if result is not null otherwise second argument is returned.