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.
