Hi folks ! I'm using <Debezium CDC>, and when I ex...
# troubleshooting
i
Hi folks ! I'm using Debezium CDC, and when I execute the Flink job I see the following message:
Caused by: java.lang.IllegalStateException: Append only writer can not accept row with RowKind UPDATE_BEFORE
any idea about it?
Thanks !!
d
Well the error indicates your flink job is trying to write a row of ROW_KIND update before. So you have a few options 1) Filter out such rows
Copy code
SELECT * FROM your_table WHERE _row_type NOT IN ('update_before')
2. Configure Debezium not to emit such rows
3. Modify your sink to accept such rows which it currently does not. This could be complex and have some side effects.
i
ok, ok, thanks for your quick answer. I see, sorry but what imply not emit this rows?
d
I am not aware of any configuration in Debezium to not emit these rows. I think it has to be filtered out on Flink side:
Copy code
tableEnv.toRetractStream(table, Row.class)
    .filter(row -> row.f0() == RowKind.INSERT || row.f0() == RowKind.UPDATE_AFTER)
    // Continue with your processing...
i
ok, thanks so much Draco !