[jira] [Created] (IMPALA-7741) Functions nvl2(), decode(), nullif() not listed in _impala_builtins

["Paul Rogers (JIRA)" <ji...@apache.org>]

Paul Rogers created IMPALA-7741:
-----------------------------------

             Summary: Functions nvl2(), decode(), nullif() not listed in _impala_builtins
                 Key: IMPALA-7741
                 URL: https://issues.apache.org/jira/browse/IMPALA-7741
             Project: IMPALA
          Issue Type: Improvement
    Affects Versions: Impala 3.0
            Reporter: Paul Rogers


The [docs|https://impala.apache.org/docs/build3x/html/topics/impala_show.html] for {{SHOW FUNCTIONS}} says that we can use the following to list all built-in functions:

{code:sql}
show functions in _impala_builtins like '*week*';
{code}

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:

{noformat}
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          |
+-------------+------------------------------+-------------+---------------+
{noformat}

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.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org