HIVEql statement for listing all available functions

Question

At my work we are limited in which functions are available in our HIVEql environment. Is there a statement that can be run that will list all of the available functions? For example:

SELECT * FROM all_available_functions;

Answer 1

You can use SHOW FUNCTIONS command. It will list all Hive functions and operators.

hive>SHOW FUNCTIONS;
hive>DESCRIBE FUNCTION <function_name>;
hive>DESCRIBE FUNCTION EXTENDED <function_name>;