Hive - Function

List

SHOW FUNCTIONS;

+-------------------------+--+
|        tab_name         |
+-------------------------+--+
| !                       |
| !=                      |
| %                       |
| &                       |
| *                       |
| +                       |
| -                       |
| /                       |
| <                       |
| <=                      |
| <=>                     |
| <>                      |
| =                       |
| ==                      |
| >                       |
| >=                      |
| ^                       |
| abs                     |
| acos                    |
| add_months              |
| aes_decrypt             |
| aes_encrypt             |

Describe

DESCRIBE FUNCTION <function_name>;
DESCRIBE FUNCTION EXTENDED <function_name>;

Example:

DESCRIBE FUNCTION current_user;

+---------------------------------------------+--+
|                  tab_name                   |
+---------------------------------------------+--+
| current_user() - Returns current user name  |
+---------------------------------------------+--+

Example:

 select max(current_user()) from littleTable;

+-------+--+
|  _c0  |
+-------+--+
| nico  |
+-------+--+