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.
It's all about SQL Server, MySQL, Oracle SQL*Plus, PostgreSQL, NoSQL, Hbase, Apache Pig, Apache Hive, Sqoop, HDFS, MapReduce and MongoDB
Big Data and SQL 
2 comments