skip to main content
Supported SQL Functionality and Extensions for The Driver for Apache Hive : SQL Expressions : Functions
  
Functions
The following tables show how SQL-92 functions are supported in HiveQL. Additional methods may be supported with Escapes. See SQL Escape Sequences for JDBC for more information.
Table 4. Set Functions Supported
Set Function
Support in HiveQL
Count
Supported
AVG
Supported
MIN
Supported
MAX
Supported
SUM
Supported
DISTINCT
Supported
ALL
Supported
Table 5. 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
TIMEZONE_HOUR
Not supported
TIMEZONE_MINUTE
Not supported
Table 6. 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 7. Date/Time Functions Supported
Date/Time Function
Support in HiveQL
CURRENT_DATE( )
Not supported
CURRENT_TIME( )
Not supported
CURRENT_TIMESTAMP
Not supported
Table 8. System Functions Supported
System Function
Support in HiveQL
CASE ... END
Supported
COALESCE
Supported
NULLIF
Not supported
CAST
Supported