dimension lookup error with mysql 5.6 (
I have a problem when I execute a step dimension lookup in a kettle transformation. It's give this error: '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=1' at line 1'.
I updated Mysql from version 5.0 to version 5.6. The transformation works good with mysql 5.0. I need the new version to have the possibility to make partitions.
Thank you for your help.
If case anyone is still wondering, the solution to this problem is to upgrade to MySQL connector 5.1.20 or above. Replace the current MySQL connector JAR in your kettle libext directory