08-07-2020 07:23 PM - edited 30-07-2020 07:55 PM
IMPORT of a timestamp column fails, because 0000-00-00 00:00:0000, which is a valid timestamp in MySQL, is invalid as a timestamp in EXASolution.
The JDBC connection string parameter 'zeroDateTimeBehavior=convertToNull' allows importing this timestamps as NULL values.
'jdbc:mysql://localhost/your_db_name_here?zeroDateTimeBehavior=convertToNull'
See http://dev.mysql.com/doc/connector-j/en/connector-j-reference-configuration-properties.html for further details on this parameter.
NOTE: As of version 6.1, you need the system privilege IMPORT to perform an IMPORT statement.
Then it's time to become part of a unique family! Discover helpful tips and support other Community members with your knowledge.
Sign In