[
https://issues.apache.org/jira/browse/FLINK-6281?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16055876#comment-16055876
]
ASF GitHub Bot commented on FLINK-6281:
---------------------------------------
Github user fhueske commented on the issue:
https://github.com/apache/flink/pull/3712
Yes, I think that would work well. We could provide a builder for the table
source and forward calls to the `JDBCOutputFormatBuilder`.
Regarding the query template: we can also make it an optional parameter to
override the standard `INSERT INTO ... VALUES` template if set.
If you want the source to support upsert writes you might want to implement
the `UpsertStreamTableSink` rather than the `AppendStreamTableSink`. The
`UpsertStreamTableSink` supports append writes as well as updates and deletes
by exposing the unique key fields of a `Table`.
> Create TableSink for JDBC
> -------------------------
>
> Key: FLINK-6281
> URL: https://issues.apache.org/jira/browse/FLINK-6281
> Project: Flink
> Issue Type: Improvement
> Components: Table API & SQL
> Reporter: Haohui Mai
> Assignee: Haohui Mai
>
> It would be nice to integrate the table APIs with the JDBC connectors so that
> the rows in the tables can be directly pushed into JDBC.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
