[
https://issues.apache.org/jira/browse/FLINK-17459?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17100533#comment-17100533
]
ranqiqiang commented on FLINK-17459:
------------------------------------
Thanks [~jark]:
I get it . If want to do sink like :
{code:java}
insert
...
on duplicate key update
id = if( values(modiy_time) >= modiy_time, values(id),id)
name = if( values(modiy_time) >= modiy_time, values(name),name)
..
modiy_time = if( values(modiy_time) >= modiy_time,
values(modiy_time),modiy_time)
{code}
The modiy_time just like version field !
> JDBCAppendTableSink not support flush by flushIntervalMills
> --------------------------------------------------------------
>
> Key: FLINK-17459
> URL: https://issues.apache.org/jira/browse/FLINK-17459
> Project: Flink
> Issue Type: Improvement
> Components: Connectors / JDBC
> Affects Versions: 1.10.0
> Reporter: ranqiqiang
> Priority: Major
>
> {{JDBCAppendTableSink just support append by
> "JDBCAppendTableSinkBuilder#batchSize",}}{{not support like
> "JDBCUpsertTableSink#flushIntervalMills"}}
>
> {{If batchSize=5000 , my data rows=5000*N+1 ,then last one record could not
> be append !!}}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
