Listing All The Functions In Apache Hive & Impala

The purpose of this article is to let you know how to list all the available functions in Apache Hive and Apache Impala.

Once you are Hive prompt, use the below command.


show functions

Apache Impala:
By default, SHOW FUNCTIONS displays user-defined functions (UDFs) and SHOW AGGREGATE FUNCTIONS displays user-defined aggregate functions (UDAFs) associated with a particular database.  This is available in CDH 5.7 / Impala 2.5 and higher.

Hope you liked this post.

Please click on the follow button to receive updates on latest posts.


Leave a Reply

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

You are commenting using your 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