The following tables show how SQL-92 functions are supported in HiveQL. Additional methods may be supported with Escapes.

Note:
Table 1. Set Functions Supported
Set Function Support in HiveQL
Count Supported
AVG Supported
MIN Supported
MAX Supported
SUM Supported
DISTINCT Supported
ALL Supported
Table 2. Numeric Functions Supported
Numeric Function Support in HiveQL
CHAR_LENGTH CHARACTER_LENGTH Not supported. Use LENGTH(string) instead.
Position...In Not supported
BIT_LENGTH(s) Not supported
OCTET_LENGTH(str) Not supported
EXTRACT...FROM Not supported
Table 3. String Functions Supported
String Function Support in HiveQL
Substring Supported
Convert … using Not supported
TRIM Supported
Leading Not supported. Use LTRIM.
Trailing Not supported. Use RTRIM.
Both Not supported (default behavior of TRIM)
Table 4. Date/Time Functions Supported
Date/Time Function Support in HiveQL
CURRENT_DATE( ) Not supported
CURRENT_TIME( ) Not supported
CURRENT_TIMESTAMP Not supported
Table 5. System Functions Supported
System Function Support in HiveQL
CASE ... END Supported
COALESCE Supported
NULLIF Not supported
CAST Supported