IMPORT 0000-00-00 00:00:0000 from MySQL

[exa-John]

Background

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.

Prerequisites

The JDBC connection string parameter 'zeroDateTimeBehavior=convertToNull' allows importing this timestamps as NULL values.

How to add this parameter in the connection string:

'jdbc:mysql://localhost/your_db_name_here?zeroDateTimeBehavior=convertToNull'

Additional Notes

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.