แชร์ผ่าน


DELTA_CONCURRENT_DELETE_READ error condition

SQLSTATE: 2D521

Transaction conflict detected, a concurrent <operation> deleted data from table <tableName> (committed at version <version>) that this transaction read.

ALLOTTED_TIME_EXCEEDED

Row-level conflict resolution exceeded the allotted time. Please retry the operation. Refer to <docLink> for more information.

CHANGE_TYPE_COLUMN

The table contains a column named '_change_type' which conflicts with Change Data Feed (CDC) metadata columns, preventing row-level conflict detection. Please rename this column or disable CDC. Refer to <docLink> for more information.

EMPTY_READ_PREDICATES

This transaction did not include any filters and read the entire table, conflicting with the concurrent deletion. Add filters to your query to narrow the data scope and retry the operation. Refer to <docLink> for more information.

METADATA_CHANGE

The concurrent operation changed the table metadata (for example, schema or partitioning). Please retry the operation. Refer to <docLink> for more information.

PARTITIONED_TABLE_WITHOUT_MERGE_SOURCE

Row-level conflict detection could not be performed on this partitioned table. Please retry the operation. Refer to <docLink> for more information.

PREDICATES_NEED_REWRITE

The filter predicates used by this transaction could not be applied for row-level conflict detection. Please retry the operation. Refer to <docLink> for more information.

PROTOCOL_CHANGE

The concurrent operation upgraded the table protocol. Please retry the operation. Refer to <docLink> for more information.

ROW_LEVEL_CHANGES

The concurrent operation deleted rows that this transaction attempted to read. Please retry the operation. Refer to <docLink> for more information.

WHOLE_TABLE_READ

This transaction attempted to read the entire table, conflicting with the concurrent deletion. Add filters to your query to narrow the data scope and retry the operation. Refer to <docLink> for more information.

WHOLE_TABLE_REPLACE

The concurrent operation replaced all data in the table. Please retry the operation. Refer to <docLink> for more information.

WITHOUT_HINT

The concurrent operation deleted data that was read by this operation. Please retry the operation. Refer to <docLink> for more information.

WITH_PARTITION_HINT

The concurrent operation deleted data in the partition <partitionValues> that was read by this operation. Please retry the operation. Refer to <docLink> for more information.