Kettle imestamp:unable to get timestamp from resultset at index 22

When doing ETL, connect MySQL to read the table containing timestamp type, the following error occurred:

By Google, it is said to be the problem of MySQL itself. The workaround is also simple, in the Spoon database connection, open the option to add a single line of command parameters:

zeroDateTimeBehavior=convertToNull

：

Problem solving.

Turn from:

"Pentaho Spoon (Kettle) appears timestamp:unable to get Timestamp from resultset at index 30 error resolution" Http://www.ywlib.com/archiv Es/61.html (from a smell study room)

Kettle imestamp:unable to get timestamp from resultset at index 22