Details
-
Feature Request
-
Resolution: Unresolved
-
Major
-
None
-
None
-
False
-
None
-
False
-
0
-
0%
Description
In case MySQL has a 0000-00-00 value, here there is an hardcoded value:
Is it possible to give a JDBC like strategy? such as:
- zeroDateTimeBehavior=ROUND
- zeroDateTimeBehavior=CONVERT_TO_NULL (and automatically make the field null)
https://www.ibm.com/support/pages/jdbc-connector-mysql-sqlexception-abouttimestamp
or apply any other kind of transformation?
In my case I've decided to make the sink nullable, but for legacy reasons, the MySQL source cannot be made null.
I've 1000s of tables, so a more automated intervention would be great.