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

Functions nvl2(), decode(), nullif() not listed in _impala_builtins

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • Impala 3.0
    • None
    • Catalog
    • None
    • ghx-label-4

    Description

      The docs for SHOW FUNCTIONS says that we can use the following to list all built-in functions:

      show functions in _impala_builtins like '*week*';
      

      However several Impala functions are removed early in the FE planning process and thus do not appear in the FE's function table in ScalarBuiltins: nvl2(), decode(), and nullif(). For example:

      show functions in _impala_builtins like '*decode**'
      +-------------+------------------------------+-------------+---------------+
      | return type | signature                    | binary type | is persistent |
      +-------------+------------------------------+-------------+---------------+
      | STRING      | base64decode(STRING)         | BUILTIN     | true          |
      | STRING      | madlib_decode_vector(STRING) | BUILTIN     | true          |
      +-------------+------------------------------+-------------+---------------+
      

      However, since these three are perfectly valid functions, would have expected them to appear in the table. How they are processed internally is an implementation detail unimportant to the end user.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              Paul.Rogers Paul Rogers
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: