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: [email protected]
For additional commands, e-mail: [email protected]
