Reading a Databricks table might fail with "ERROR: The data type 'string collate UTF8_LCASE_RTRIM' for column 'SRC_SYS_CD' is unsupported."


When you try to read a Databricks table using the SPARK engine, the following error might occur:

The data type 'string collate UTF8_LCASE_RTRIM' for column 'SRC_SYS_CD' is unsupported.

Although SAS does not use the "collate UTF8_LCASE_RTRIM" portion of the data type definition, the string data type itself is supported.