flink-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (FLINK-6281) Create TableSink for JDBC
Date Tue, 20 Jun 2017 14:51:00 GMT

    [ 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:

    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

View raw message