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;

Hope you liked this post.

Please do subscribe to receive notifications on latest posts.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s