[jira] [Resolved] (IMPALA-2451) Conditional function 'notnullvalue' doesn't work

["John Russell (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-2451?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

John Russell resolved IMPALA-2451.
----------------------------------
       Resolution: Fixed
    Fix Version/s: Impala 2.2

This has been fixed for some time. Closing the JIRA.

> Conditional function 'notnullvalue' doesn't work
> ------------------------------------------------
>
>                 Key: IMPALA-2451
>                 URL: https://issues.apache.org/jira/browse/IMPALA-2451
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Docs
>    Affects Versions: Impala 2.2
>            Reporter: Murshid Chalaev
>            Assignee: John Russell
>            Priority: Minor
>             Fix For: Impala 2.2
>
>
> *Preconditions:*
> 1. Impala 2.2 is running;
> 2. impala-shell is opened;
> *Steps to reproduce:*
> 1. Enter in the command line:
> {code:java}
> select case when notnullvalue('true') then 'PASS' end;
> {code}
> (it's described in Cloudera documentation 
> http://www.cloudera.com/content/cloudera/en/documentation/core/latest/topics/impala_conditional_functions.html)
> *Actual result:*
> {code:java}
> select case when notnullvalue('true') then 'PASS' end;
> Query: select case when notnullvalue('true') then 'PASS' end
> ERROR: AnalysisException: default.notnullvalue() unknown
> {code}
> *Expected result:*
> | case when notnullvalue('true') then 'pass' end |
> | PASS |
> *P.S.:* Same conditional function 'nonnullvalue' works
> https://issues.cloudera.org/browse/IMPALA-1662



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)