BASE64 | Supported | |
BIT_LENGTH | Supported | |
ELT | Supported | |
INSTR | Supported | |
LCASE | Supported | |
LEN | Supported | |
LENGTH | Supported | |
LOWER | Supported | |
LTRIM | Supported | |
OCTET_LENGTH | Supported | |
REGEXP_COUNT | Supported | |
REGEXP_SUBSTR | Supported | |
REPEAT | Supported | |
REPLACE | Supported | |
RIGHT | Supported | |
RTRIM | Supported | |
SOUNDEX | Supported | |
SPACE | Supported | |
SPLIT_PART | Supported | |
TO_BINARY | Supported | |
UCASE | Supported | |
UNBASE64 | Supported | |
UPPER | Supported | |
ASCII | With limitations | ascii(2) is not supported. |
BTRIM | With limitations | btrim(encode(' SparkSQL ', 'utf-8')) raises an error, where Spark returns 'SparkSQL'. |
CHAR_LENGTH | With limitations | char_length(x'537061726b2053514c') is not supported. |
CHARACTER_LENGTH | With limitations | character_length(x'537061726b2053514c') is not supported. |
CONCAT_WS | With limitations | concat_ws('s') raises an error, where Spark returns ''. |
ENDSWITH | With limitations | endswith(x'537061726b2053514c', x'537061726b') is not supported. |
LEFT | With limitations | left(encode('Spark SQL', 'utf-8'), 3) raises an error, where Spark returns '\x537061'. |
LOCATE | With limitations | locate('bar', 'foobarbar', 5) is not supported. |
LPAD | With limitations | hex(lpad(unhex('aabb'), 5)) is not supported. |
POSITION | With limitations | position('bar', 'foobarbar', 5) is not supported. |
REGEXP_EXTRACT | With limitations | The group-index argument is not supported: regexp_extract(s, pattern) returns the whole match. |
REGEXP_EXTRACT_ALL | With limitations | The group-index argument is not supported: regexp_extract_all(s, pattern) returns the whole matches. |
REGEXP_REPLACE | With limitations | A position other than 1, or a replacement that is not a constant, is not supported. |
RPAD | With limitations | hex(rpad(unhex('aabb'), 5)) is not supported. |
SPLIT | With limitations | split('oneAtwoBthreeC', '[ABC]') is not supported. |
STARTSWITH | With limitations | startswith(x'537061726b2053514c', x'537061726b') is not supported. |
SUBSTR | With limitations | substr('Spark SQL', -3) returns 'Spark SQL', where Spark returns 'SQL'. |
SUBSTRING | With limitations | substring('Spark SQL', -3) returns 'Spark SQL', where Spark returns 'SQL'. |
TO_CHAR | With limitations | to_char(454, '999') is not supported. |
TRIM | With limitations | trim(BOTH FROM s), trim(LEADING FROM s), and trim(TRAILING FROM s) without a trim string are not supported. |
CHAR, CHR, COLLATE, COLLATION, CONTAINS, DECODE, ENCODE, FIND_IN_SET, FORMAT_NUMBER, FORMAT_STRING, INITCAP, IS_VALID_UTF8, LEVENSHTEIN, LUHN_CHECK, MAKE_VALID_UTF8, MASK, OVERLAY, PRINTF, QUOTE, RANDSTR, REGEXP_INSTR, SENTENCES, SUBSTRING_INDEX, TO_NUMBER, TO_VARCHAR, TRANSLATE, TRY_TO_BINARY, TRY_TO_NUMBER, TRY_VALIDATE_UTF8, VALIDATE_UTF8 | Not supported | |
