About

(Function | Operator | Map | Mapping | Transformation | Method | Rule | Task | Subroutine) in Hive.

Type

Management

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  |
+-------+--+

Documentation / Reference