Pular para o conteúdo principal

APPLY_CHANGES_FROM_SNAPSHOT_ERROR error condition

SQLSTATE: 22000

An error occurred during the AUTO CDC FROM SNAPSHOT operation.

DUPLICATE_KEY_VIOLATION​

Found <count> rows for key '<key>' in <provenance> table for flow '<flowName>'. Expected at most 1 row per key.

DYNAMIC_SNAPSHOT_VERSION​

Snapshot version should be independently evaluable from the table.

FIRST_SNAPSHOT_EMPTY​

AUTO CDC FROM SNAPSHOT get None returned from the lambda function as the first snapshot source to be processed. Please make sure at least one valid snapshot source available for processing.

INTEROP_CONTINUOUS_NOT_SUPPORTED​

Target <target> is written by both apply_changes_from_snapshot and apply_changes in a continuous pipeline. This combination is currently supported only for triggered pipelines.

INTEROP_EXPECTATIONS_NOT_SUPPORTED​

Target <target> is written by both apply_changes_from_snapshot and apply_changes, but snapshot flow <flowName> defines expectations. Remove the expectations from the snapshot flow before sharing the target.

INTEROP_IGNORE_NULL_UNSUPPORTED​

Target <target> is written by both an apply_changes_from_snapshot flow and the apply_changes flow <flowName>, which sets ignoreNull=true. Set ignoreNull=false on every apply_changes flow that shares a table with apply_changes_from_snapshot.

INTEROP_KEYS_MISMATCH​

Target <target> is written by an apply_changes_from_snapshot flow with keys <snapshotKeys> and the apply_changes flow <flowName> with keys <autoCdcKeys>. Use the same keys for every flow that writes this table.

INTEROP_SCD_TYPE_NOT_SUPPORTED​

Target <target> is written by both an apply_changes_from_snapshot flow and an apply_changes flow, which is only supported for SCD Type 1. One of the flows uses SCD type '<scdType>'. Use SCD Type 1 for every flow that writes this table.

INTEROP_SEQUENCING_TYPE_MISMATCH​

Target <target> is written by an apply_changes_from_snapshot flow with snapshot version type <acfsType> and an apply_changes flow with sequence-by type <autoCdcType>. Use the same type for both.

INTEROP_SYSTEM_COLUMN_CONFLICT​

Cannot add an apply_changes flow to target <target> because the existing apply_changes_from_snapshot table contains user columns reserved by apply_changes: <columns>. Rename or remove the conflicting columns before adding apply_changes.

INVALID_SNAPSHOT_VERSION​

AUTO CDC query requires specification of both snapshot and its version. If no snapshot version is expected, please put null as the place-holder as the second value of the returned tuple.

INVALID_SNAPSHOT_VERSION_TYPE​

Snapshot version type is not supported.

INVALID_TUPLE_NULL_SNAPSHOT_VERSION​

Invalid snapshot version found for AUTO CDC FROM SNAPSHOT query to target table '<target>'. Snapshot version returned was None but AUTO CDC FROM SNAPSHOT requires a valid non-null snapshot version for each snapshot DataFrame.

MISSING_AUTOCDC_SYSTEM_COLUMNS​

Target table is missing required AutoCDC-compatible system columns: <missing>. The table may need to be recreated with the correct schema.

NULL_SNAPSHOT_VERSION​

None snapshot version found.

OUT_OF_ORDER_SNAPSHOT_VERSION​

Snapshot need to be processed in-order: the snapshot version <currentVersion> is not larger than the latest processed version <previousVersion>.

SCD_TYPE_2_NOT_SUPPORTED​

ACFSUnifiedTableProcessor only supports SCD Type 1. SCD Type 2 is not supported for unified table writes.

SCD_TYPE_2_SYSTEM_GENERATED_COLUMNS_NOT_SUPPORTED​

SCD Type 2 tables targeted by both AUTO CDC and AUTO CDC FROM SNAPSHOT flows cannot use Delta generated or identity columns with the current configuration. Unsupported columns: <columns>.

SCD_TYPE_2_TRACKED_COLUMNS_NOT_SUPPORTED​

SCD Type 2 tables targeted by both AUTO CDC and AUTO CDC FROM SNAPSHOT flows do not support track_history_column_list or track_history_except_column_list. Remove these options to track changes for all columns.

SNAPSHOT_VERSION_NOT_SORTABLE​

Snapshot version need to be sortable.

SQL_QUERY_SOURCE_NOT_SUPPORTED​

AUTO CDC ... FROM SNAPSHOT with a SQL query snapshot source is not supported.

VERSION_QUERY_REQUIRES_QUERY_SOURCE​

AUTO CDC ... FROM SNAPSHOT requires a query snapshot source when a VERSION query is specified.