List, Detail, Describe and Call Functions in Hive

In Apache Hive, there are hundreds of built-in functions, such as aggregate, statistical, date-time, string, type conversion, conditional, table creation, windowing, and more functions that we can’t remember all of the time. This article will teach you how to acquire a list of all available functions, describe them, retrieve information about them, and call them.

hive> SHOW FUNCTIONS
The above command will help in retrieving all the built-in functions available in Hive.

hive> DESCRIBE FUNCTION <function-name>
This will give a short description about the function. You can use “DESC” instead of “DESCRIBE”.

hive> DESCRIBE FUNCTION EXTENDED <function-name>
This will give the detailed description about the function.

hive> SELECT SUM(col1) FROM table1;
Simply provide the appropriate parameters to the function in the SELECT query. It could be a value or a particular column.

Hope you find this article helpful.

Please subscribe for more interesting updates.

One comment

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