You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Shu Li Zheng (Jira)" <ji...@apache.org> on 2020/01/14 04:43:00 UTC
[jira] [Comment Edited] (FLINK-15579) Can not use jdbc connector on
Blink batch mode
[ https://issues.apache.org/jira/browse/FLINK-15579?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17014848#comment-17014848 ]
Shu Li Zheng edited comment on FLINK-15579 at 1/14/20 4:42 AM:
---------------------------------------------------------------
[~ykt836] Could you assign this bug to me? I would like to fix it.
was (Author: eric.zheng):
[~ykt836]Could you assign this bug to me? I would like to fix it.
> Can not use jdbc connector on Blink batch mode
> -----------------------------------------------
>
> Key: FLINK-15579
> URL: https://issues.apache.org/jira/browse/FLINK-15579
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / Planner
> Reporter: Shu Li Zheng
> Priority: Major
>
> Because JDBCTableSourceSinkFactory.createStreamTableSink() create JDBCUpsertTableSink. But BatchExecSink can not work with UpsertStreamTableSink.
> {code:scala}
> override protected def translateToPlanInternal(
> planner: BatchPlanner): Transformation[Any] = {
> val resultTransformation = sink match {
> case _: RetractStreamTableSink[T] | _: UpsertStreamTableSink[T] =>
> throw new TableException("RetractStreamTableSink and UpsertStreamTableSink is not" +
> " supported in Batch environment.")
> {code}
> DDL like:
> CREATE TABLE USER_RESULT(
> NAME VARCHAR,
> CITY VARCHAR,
> SCORE BIGINT
> ) WITH (
> 'connector.type' = 'jdbc',
> 'connector.url' = '',
> 'connector.table' = '',
> 'connector.driver' = 'com.mysql.cj.jdbc.Driver',
> 'connector.username' = 'root',
> 'connector.password' = '',
> 'connector.write.flush.interval' = '1s')
--
This message was sent by Atlassian Jira
(v8.3.4#803005)