flink-cdc icon indicating copy to clipboard operation
flink-cdc copied to clipboard

is there some flag that help me get the primary key in output

Open foobarrer opened this issue 2 years ago • 2 comments

I use flink cdc in copy the mysql data from one to another, what I want is tell me which column is the primary key in the output. So I can use the primary key to update and delete the data。

foobarrer avatar Jun 06 '22 01:06 foobarrer

I want to get the primary key from playload too....

Kyofin avatar Jul 01 '22 10:07 Kyofin

I really appreciate it if someone can tell me wether there is a primary key flagin the future or there will not have a primary key flag. I'm waiting for a certain answer, no matter whether it's true or false. thanks a lot

foobarrer avatar Sep 22 '22 02:09 foobarrer

This information should be known before the job starts. And we do not need to pass it when reading data. If it is DataStream job, you may be able to pass it after the deserialization. But we can not do it in flink sql.

ruanhang1993 avatar Jun 30 '23 07:06 ruanhang1993

Closing this issue because it was created before version 2.3.0 (2022-11-10). Please try the latest version of Flink CDC to see if the issue has been resolved. If the issue is still valid, kindly report it on Apache Jira under project Flink with component tag Flink CDC. Thank you!

PatrickRen avatar Feb 28 '24 15:02 PatrickRen