Set Function
|
Support in Impala SQL
|
Count
|
Supported
|
AVG
|
Supported
|
MIN
|
Supported
|
MAX
|
Supported
|
SUM
|
Supported
|
DISTINCT
|
Supported
|
ALL
|
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...FROM
|
Not 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)
|