[Bug] how to sync data from mysql to paimon

[homesickjava]

Search before asking

• [X] I searched in the issues and found nothing similar.

Paimon version

05-SNAPSHOT

Compute Engine

flink

Minimal reproduce step

1. run paimon-flink-action.jar
2. use hive to query paimon table
3. could not get data from paimon table

I have 8898 rows of data in source mysql table

BUT there's no data sync into paimon table

What doesn't meet your expectations?

I want to get sync data from source mysql table

Anything else?

No response

Are you willing to submit a PR?

• [X] I'm willing to submit a PR!

[EMsnap]

I guess you need to provide more info on your job and make sure the configuration in mysqlcdc source and paimon sink are correct.

[homesickjava]

I have mysqlcdc depended jar in $FLINK_HOME/lib

and I use flink to run paimon-flink-action.jar to synchronizing datas , and my command is : ./flink run -Dclassloader.check-leaked-classloader=false paimon-flink-action-0.4-SNAPSHOT.jar mysql-sync-table --warehouse hdfs://pcosmo-gyos03:8020/user/root/warehouse --database paimon_db --table paimon_sync_machine_baseinfo --mysql-conf hostname=10.206.32.3 --mysql-conf port=9006 --mysql-conf username=root --mysql-conf password=123456 --mysql-conf database-name=paimontest --mysql-conf table-name='machine_baseinfo' --catalog-conf metastore=hive --catalog-conf uri=thrift://10.206.32.3:9083 --table-conf bucket=4 --table-conf changelog-producer=input --table-conf sink.parallelism=4

I use both hive and flink sql-client to query paimon data of paimon_sync_machine_baseinfo . however, I got empty set of the quering, how can I synchronizing the data from mysql to paimon ~~

[homesickjava]

it has data synchronizing info, however, when I use flink-sql to query, I could not get any records the script that I use: ./flink run -Dclassloader.check-leaked-classloader=false paimon-flink-action-0.4-SNAPSHOT.jar mysql-sync-table --warehouse hdfs://pcosmo-gyos03:8020/user/root/warehouse --database paimon_db --table sync_machine_baseinfo_addcolumn --mysql-conf hostname=10.206.32.3 --mysql-conf port=9006 --mysql-conf username=root --mysql-conf password=123456 --mysql-conf database-name=paimontest --mysql-conf table-name='machine_baseinfo'