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.
hive> 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.
Big Data and SQL 
2 comments