Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: dimension lookup error with mysql 5.6 (

  1. #1
    Join Date
    Apr 2012

    Default dimension lookup error with mysql 5.6 (

    Dear all,

    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.


  2. #2
    Join Date
    May 2012


    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

  3. #3


    I was wondering. Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2017 Pentaho Corporation. All Rights Reserved.