Liam created FLINK-27463: ---------------------------- Summary: The JDBC connector should support option for ‘upsert’ or ‘insert’ Key: FLINK-27463 URL: https://issues.apache.org/jira/browse/FLINK-27463 Project: Flink Issue Type: Improvement Components: Connectors / JDBC Affects Versions: 1.14.4 Reporter: Liam
If set a primary key to the table, then the connector will use the upsert query to sink data. However, the upsert query is not always expected. Because some of the databases don't support upsert well, like Click House. (even though some databases are not supporting officially, I believe many users are extending the dialect by themself) So I suggest adding an option like 'sink.append-only' to make the data populated by insert query. If we can reach a consensus, I can implement it. -- This message was sent by Atlassian Jira (v8.20.7#820007)