MySQL server not compatible with 'OPTION SQL_SELECT_LIMIT=DEFAULT'

Paul_Masurel
Paul_Masurel Registered Posts: 6 ✭✭✭✭✭
in Using Dataiku
When running a mysql query through JDBC driver I get the following error.



check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT'
Tagged:
· Share on Facebook

Answers

  • Clément_Stenac
    Clément_Stenac Dataiker, Dataiku DSS Core Designer, Registered, Moderator Posts: 754 Dataiker
    It seems that this issue could come from a too old MySQL JDBC driver jar. From what I can see, it seems that this issue was fixed in mysql-connector-java 5.1.22.

    Does upgrading fix the issue ?
    · Share on Facebook
  • Paul_Masurel
    Paul_Masurel Registered Posts: 6 ✭✭✭✭✭
    Yes! Thank you so much!
    · Share on Facebook
Bookmark this topic

Categories

Setup Info
    Tags
      Help me…