Kettle批量导数据到MySQL问题汇总

1. 与MySQL建立连接时，时区报错

Connection failed. Verify all connection parameters and confirm that the appropriate driver is installed.
The server time zone value '�й���׼ʱ��' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the 'serverTimezone' configuration property) to use a more specifc time zone value if you want to utilize time zone support.

解决方法一：在输出表的 “数据库连接”选项列表，增加配置时区命令参数

serverTimezone  GMT

解决方法二：在MySQL中的设定时区函数：

show variables like '% time_zone%';

set global time_zone = '+8:00';

2. 导入数据时系统报错 Error updating batch Table    'taobao1.user_behavior' doesn't exist

解决方法：检查数据库和kettle输入输出设置中的名称、用户名、表头字段是否一致