apache / seatunnel

SeaTunnel is a next-generation super high-performance, distributed, massive data integration tool.
https://seatunnel.apache.org/
Apache License 2.0
8.03k stars 1.82k forks source link

Support RowKind(DELETE/UPDATE_AFTER) data row in JDBC sink not working. #4573

Open sangeetha1706 opened 1 year ago

sangeetha1706 commented 1 year ago

Search before asking

What happened

when im inserting or updating or deleting anything RowKind=INSERT/UPDATE/DELETE not writing the CDC change in console.

SeaTunnel Version

apache-seatunnel-incubating-2.3.1

SeaTunnel Config

env {
   job.mode = "STREAMING"
}
source {
  MySQL-CDC {
    result_table_name = "SINK_USER"
    parallelism = 1
    server-id = 5656
    snapshot.fetch.size = 3
    username = ""
    password = ""
    table-names = ["TEST.SOURCE_USER"]
    base-url = "jdbc:mysql://10.0.14.66:3306/TEST"
}
}
sink {
Console
{
source_table_name="SOURCE_USER"
}
}
sink{
jdbc {
        url = "jdbc:mysql://10.0.14.66:3306/TEST"
        driver = "com.mysql.cj.jdbc.Driver"
        user = ""
         password = ""
        database = "TEST"
        primary_keys = ["ID"]
        table = SINK_USER

}
}

Running Command

./bin/seatunnel.sh --config ./config/MYSQL-CDC.conf -e local

Error Exception

.

Flink or Spark Version

No response

Java or Scala Version

No response

Screenshots

No response

Are you willing to submit PR?

Code of Conduct

github-actions[bot] commented 1 year ago

This issue has been automatically marked as stale because it has not had recent activity for 30 days. It will be closed in next 7 days if no further activity occurs.