kettle报错问题汇总

1. kettle报错:Unable to get fields into from previous steps because of an error

Couldn't get field info from [SELECT * FROM WEIBO_BLOGGER t]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1

环境：kettle 7.1 /MySQL 5.6.20
解决办法：将以下三个jar包（没测试具体是哪个）放到kettle安装路径的lib文件夹下，重启kettle即可。

2. kettle报错:The last packet successfully received from the server was 2 milliseconds ago.
   

环境：kettle 7.1 /MySQL 5.7.17
解决办法：将 mysql-connector-java-5.1.15-bin.jar 放到kettle安装路径的lib文件夹下，重启kettle即可。

3.kettle报错:Unexpected batch update error committing the database connection.

解决办法：表输出中 ，取消批量插入。一步步测试。
引起该报错的可能：字段类型不一致，字段长度不一致，目标表有主键但是数据重复等等数据问题。