The driver supports a number of functions that you can use in expressions, as listed in the following tables.

Table 1. Set Functions Supported
Set Function Support in Spark SQL
Count Supported
AVG Supported
MIN Supported
MAX Supported
SUM Supported
DISTINCT Supported
ALL Supported
Table 2. Numeric Functions Supported
Numeric Function Support in Spark 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
TIMEZONE_HOUR Not supported
TIMEZONE_MINUTE Not supported
Table 3. String Functions Supported
String Function Support in Spark 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 4. Date/Time Functions Supported
Date/Time Function Support in Spark SQL
CURRENT_DATE( ) Not supported
CURRENT_TIME( ) Not supported
CURRENT_TIMESTAMP Not supported. Use UNIX_TIMESTAMP().
Table 5. System Functions Supported
System Function Support in Spark SQL
CASE ... END Supported.
COALESCE Supported.
NULLIF Not supported.
CAST Supported.