When you use SAS/ACCESS^® Interface to JDBC to work with Databricks tables, you might see errors that are similar to the following:

The errors occur after you try to use the SQL procedure or the APPEND procedure to update an existing Databricks table with code similar to the following:

PROC APPEND also generates the second error message above when you attempt to create a Databricks table with code similar to this: 

The only workaround is to drop the table and then re-create it in one step by using either a DATA step or PROC SQL. The following example shows a PROC SQL step that re-creates the table in one step:

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS/ACCESS Interface to Hadoop 9.46 is available at: