S03017
Error Code
S03017
Error Message
Failed to append data to column <xxx> with error: Incompatible type.
Expected: <Type1>, Actual: <Type2>. RefId:S03017
Probable Causes
This error occurs when attempting to write data of Type2 to a column of Type1 of a stream table, where Type1 and Type2 are incompatible types. Specifically,
- When appending data to a stream table (with
append!
orinsert into
), its schema does not match the table schema. - When calling
enableTableShareAndPersistence
, a table with the same name already exists in the persistence directory, and the table schema does not match that specified in the function.
Solutions
- For the first case, check and modify the schema of data to be appended.
- For the second case, check and modify the schema of table specified
in
enableTableShareAndPersistence
, or clean up the persisted files before enabling persistence.