[
https://issues.apache.org/jira/browse/FLINK-33929?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17800917#comment-17800917
]
zhilinli edited comment on FLINK-33929 at 12/28/23 4:48 AM:
------------------------------------------------------------
{code:java}
CREATE TABLE MyUserTable (
id int,
name STRING,
age INT,
email STRING,
PRIMARY KEY (id) NOT ENFORCED
) WITH (
'connector' = 'jdbc',
'url' = 'jdbc:mysql://localhost:3306/test',
'table-name' = 'fake_source_sink',
'username'='root',
'password'='12345678',
'scan.partition.column'='name',
'scan.partition.num'='3',
'scan.partition.lower-bound'='0',
'scan.partition.upper-bound'='2'
); {code}
was (Author: JIRAUSER291519):
{code:java}
CREATE TABLE MyUserTable (
id int,
name STRING,
age INT,
email STRING,
PRIMARY KEY (id) NOT ENFORCED
) WITH (
'connector' = 'jdbc',
'url' = 'jdbc:mysql://localhost:3306/test',
'table-name' = 'fake_source_sink',
'username'='root',
'password'='12345678',
'scan.partition.column'='name',
'scan.partition.num'='3',
'scan.partition.lower-bound'='0',
'scan.partition.upper-bound'='2'
);{code}
> Support jdbc read shard Read string fields as shard keys
> --------------------------------------------------------
>
> Key: FLINK-33929
> URL: https://issues.apache.org/jira/browse/FLINK-33929
> Project: Flink
> Issue Type: New Feature
> Components: Connectors / JDBC, Table SQL / JDBC
> Reporter: zhilinli
> Priority: Major
> Attachments: WechatIMG59636.jpg
>
>
> Many table structures are very strange table primary keys are generated by
> the string uuid is exactly very scattered, resulting in the use of flink jdbc
> shards to read the primary key,I think flink is not only the best streaming
> computing engine but also has a greater advantage in data transfer
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
