skip to main content
SQL Functionality for the Impala Wire Protocol Driver : SQL Expressions : Functions
  
Functions
The following tables show how SQL-92 functions are supported in the Impala Query Language. Additional methods may be supported with ODBC Escapes. See Scalar Functions for more information.
Table 47. Set Functions Supported
Set Function
Support in Impala SQL
Count
Supported
AVG
Supported
MIN
Supported
MAX
Supported
SUM
Supported
DISTINCT
Supported
ALL
Supported
Table 48. Numeric Functions Supported
Numeric Function
Support in Impala SQL
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 TIMEZONE_HOUR FROM
Not supported
EXTRACT TIMEZONE_MINUTE FROM
Not supported
Table 49. String Functions Supported
String Function
Support in Impala SQL
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 50. Date/Time Functions Supported
Date/Time Function
Support in Impala SQL
CURRENT_DATE( )
Not supported1
CURRENT_TIME( )
Not supported2
CURRENT_TIMESTAMP
Not supported. Use UNIX_TIMESTAMP()3.
1 Supported by ODBC Escapes

2 Supported by ODBC Escapes

3 Supported by ODBC Escapes

Table 51. System Functions Supported
System Function
Support in Impala SQL
CASE ... END
Supported.
COALESCE
Supported.
NULLIF
Not supported.1
CAST
Supported.
1 Supported by ODBC Escapes