Error: F_JD1202: DBMS Error (35) Error From Server

Issue

While trying to create a burst table, the following error appears:

F_JD1202: DBMS error [(35) Error from server: error code: '0' 
error message: 'org.apache.hive.service.cli.HiveSQLException: 
Error running query: [DELTA_METADATA_ABSENT]
com.databricks.sql.transaction.tahoe.DeltaIllegalStateException:
Couldn't find Metadata while committing the first version of the 
Delta table.

Environment

• DSS 6
• Target: Databricks

Resolution

To resolve this issue, you need to manually clean up the burst table folder so that we can recreate the burst table. Do the following:

1. In Databricks, run the following command to find the burst table's folder location:

    show table extended <em>schema</em>.<em>target_tablename</em>
   

2. Make a note of the burst table folder's location. If the command output is long, you may need to scroll down to find it.
3. Delete the burst table folder.
4. Start the Integrate job from the Jobs screen.