Quilian commented on issue #8548:
URL: https://github.com/apache/seatunnel/issues/8548#issuecomment-2731894281
> I have submitted a PR to fix the geometry field type issue.But if you want
to sink to an external database, you need to use a function to convert wkb
binary data. You can refer to this configuration
>
> ```
> env {
> parallelism = 1
> job.mode = "STREAMING"
> checkpoint.interval = 20000
> job.retry.times = 0
> }
>
> source {
> MySQL-CDC {
> base-url = "jdbc:mysql://x.x.x.x:xxxx/data_src"
> username = "xxx"
> password = "xxx"
> table-names = ["data_src.test_blob"]
> startup.mode = "initial"
> schema-changes.enabled = true
> }
> }
>
> sink {
> Jdbc {
> source_table_name = "dbtest"
> url = "jdbc:mysql://x.x.x.x:xxxx/data_src"
> driver = "com.mysql.cj.jdbc.Driver"
> user = "root"
> password = "123456"
> batch_size = 500
> data_save_mode = DROP_DATA
> database = "data_src"
> generate_sink_sql = false
> query = "INSERT INTO `data_src`.`test_blob_copy1` (`id`, `gis`)
VALUES (?, ST_GeomFromWKB(?)) ON DUPLICATE KEY UPDATE `id`=VALUES(`id`),
`gis`=VALUES(`gis`)"
> table = "test_blob_copy1"
> }
> }
> ```
The programming technology is really amazing. Thank you for sharing.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
