Skip to main content

MULTI_STATEMENT_TRANSACTION_NOT_SUPPORTED error condition

SQLSTATE: 0A000

Failed to execute the statement.

COMMAND

Command <command> is not supported in a multi-statement transaction. Only SELECT / INSERT / MERGE / UPDATE / DELETE are supported.

WRITE_DELTA_TABLE_NON_UC_CATALOG

Table <tableName> is not a UC-managed table. Only UC-managed tables can be written in a multi-statement transaction. Please migrate the table to Unity Catalog and retry the query or command.

WRITE_DELTA_TABLE_NO_UC_COORDINATED_COMMITS

Table <tableName> does not have Unity Catalog coordinated commits enabled, which is required for tables written in a multi-statement transaction. Please enable Unity Catalog coordinated commits for this table and retry the query or command.

WRITE_NON_DELTA_TABLE

The written table is not a Delta table. Only Delta tables can be written in a multi-statement transaction.

WRITE_NON_DELTA_TABLE_WITH_NAME

Table <tableName> is not a Delta table. Only Delta tables can be written in a multi-statement transaction.