Display Built-in Functions in Impala

As noted in a previous post, SHOW FUNCTIONS by default displays user-defined functions (UDFs) and SHOW AGGREGATE FUNCTIONS displays user-defined aggregate functions (UDAFs) connected with a certain database. This is accessible in CDH 5.7 / Impala 2.5 and higher. If you wish to see a list of all the built-in functions, switch to the “_impala builtins” database and run the command below.

USE _impala_builtins;
SHOW FUNCTIONS;

Hope you liked this post.

Please do subscribe to receive notifications on latest posts.