INCOMPATIBLE_DATA_FOR_TABLE error class

  • Article

SQLSTATE: KD000

Cannot write incompatible data for the table <tableName>:

AMBIGUOUS_COLUMN_NAME

Ambiguous column name in the input data <colName>.

CANNOT_FIND_DATA

Cannot find data for the output column <colName>.

CANNOT_SAFELY_CAST

Cannot safely cast <colName> <srcType> to <targetType>.

EXTRA_COLUMNS

Cannot write extra columns <extraColumns>.

EXTRA_STRUCT_FIELDS

Cannot write extra fields <extraFields> to the struct <colName>.

NULLABLE_ARRAY_ELEMENTS

Cannot write nullable elements to array of non-nulls: <colName>.

NULLABLE_COLUMN

Cannot write nullable values to non-null column <colName>.

NULLABLE_MAP_VALUES

Cannot write nullable values to map of non-nulls: <colName>.

STRUCT_MISSING_FIELDS

Struct <colName> missing fields: <missingFields>.

UNEXPECTED_COLUMN_NAME

Struct <colName> <order>-th field name does not match (may be out of order): expected <expected>, found <found>.