Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-2451

Conditional function 'notnullvalue' doesn't work

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: Impala 2.2
    • Fix Version/s: Impala 2.2
    • Component/s: Docs
    • Labels:
      None

      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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                jrussell John Russell
                Reporter:
                murshyd Murshid Chalaev
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: