[IMPALA-2451] Conditional function 'notnullvalue' doesn't work

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: Impala 2.2
• Fix Version/s: Impala 2.2
• Component/s: Docs
• Target Version: Impala 2.2
• Assignee: John Russell
• Reporter: Murshid Chalaev
• Created: 30/Sep/15 13:47
• Updated: 23/May/17 22:28
• Resolved: 23/May/17 22:28

Description

Preconditions:
1. Impala 2.2 is running;
2. impala-shell is opened;

Steps to reproduce:
1. Enter in the command line:

select case when notnullvalue('true') then 'PASS' end;

(it's described in Cloudera documentation
http://www.cloudera.com/content/cloudera/en/documentation/core/latest/topics/impala_conditional_functions.html)

Actual result:

select case when notnullvalue('true') then 'PASS' end;
Query: select case when notnullvalue('true') then 'PASS' end
ERROR: AnalysisException: default.notnullvalue() unknown

Expected result:

case when notnullvalue('true') then 'pass' end

PASS

P.S.: Same conditional function 'nonnullvalue' works
https://issues.cloudera.org/browse/IMPALA-1662

Issue Links

• blocks: IMPALA-1662 Netezza compatibility functions: Logic