Update/Insert Timestamp doesn't work with PostgreSQL SQL syntax. It throws exception as "org.postgresql.util.PSQLException: ERROR: value is not a timestamp: invalid value provided" That would be the ...
I'm trying to set up a realtime migration pipeline using Debezium + kafka-connect-jdbc sink connector. There is an issue in converting MySQL's DATETIME(6) column into PostgreSQL's TIMESTAMP type ...