|
Set Function
|
Support in HiveQL
|
|
Count
|
Supported
|
|
AVG
|
Supported
|
|
MIN
|
Supported
|
|
MAX
|
Supported
|
|
SUM
|
Supported
|
|
DISTINCT
|
Supported
|
|
ALL
|
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
|
|
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)
|
|
Date/Time Function
|
Support in HiveQL
|
|
CURRENT_DATE( )
|
Not supported
|
|
CURRENT_TIME( )
|
Not supported
|
|
CURRENT_TIMESTAMP
|
Not supported. Use UNIX_TIMESTAMP().
|
|
System Function
|
Support in HiveQL
|
|
CASE ... END
|
Supported
|
|
COALESCE
|
Supported
|
|
NULLIF
|
Not supported
|
|
CAST
|
Supported
|