[jira] [Created] (FLINK-12956) Add a upsert table sink for JDBC

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (FLINK-12956) Add a upsert table sink for JDBC

Shang Yuanchun (Jira)
Jingsong Lee created FLINK-12956:
------------------------------------

             Summary: Add a upsert table sink for JDBC
                 Key: FLINK-12956
                 URL: https://issues.apache.org/jira/browse/FLINK-12956
             Project: Flink
          Issue Type: New Feature
          Components: Connectors / JDBC
            Reporter: Jingsong Lee
            Assignee: Jingsong Lee


Now we just support append JDBC sink, this is very limited. Consider a simple wordCount, we need insert/update the sink with primary keys.

So we need to support upsert JDBC sink.

1.Introduce a AbstractJdbcOutputFormat to extract some common method from JDBCOutputFormat. Introduce a UpsertJDBCOutputFormat which extends AbstractJdbcOutputFormat.

2.Introduce UpsertJdbcTableSink.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)