skip to main content
SQL Functionality for the Driver for Apache Hive : SQL Expressions : Functions
  

Try DataDirect Drivers Now

Functions

The driver supports a number of functions that you can use in expressions, as listed in the following tables.
Table 10. Set Functions Supported
Set Function
Support in HiveQL
Count
Supported
AVG
Supported
MIN
Supported
MAX
Supported
SUM
Supported
DISTINCT
Supported
ALL
Supported
Table 11. 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 12. 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 13. Date/Time Functions Supported
Date/Time Function
Support in HiveQL
CURRENT_DATE( )
Not supported
CURRENT_TIME( )
Not supported
CURRENT_TIMESTAMP
Not supported. Use UNIX_TIMESTAMP().
Table 14. System Functions Supported
System Function
Support in HiveQL
CASE ... END
Supported.
COALESCE
Supported.
NULLIF
Not supported.
CAST
Supported.