AnsweredAssumed Answered

Couldn't get field info from [SELECT * FROM products LIMIT 0]

Question asked by Eric Rosales on Jun 22, 2018

Hi, I have pentaho CE 8.1 with MySQL...I'm doing the tutorial from "Pentaho Data Integration - Beginners' Guide", chap 9 populating a data base.

I have done all the previous exercises about reading databases, but in this particular excersises it's using a Database Lookup step.

At the moment of configuring the step and setting the fields to lookup, when clicking on "Get lookup fields" I've got the following error:

Couldn't get field info from [SELECT * FROM products LIMIT 0]

Error determining value metadata from SQL resultset metadata

Unknown system variable 'OPTION'

 

and asking for details I've got the log (attached)

 

I finished entering the transformation and run with the same result (error)

 

Any idea to solve it ? as I have not found the same problem

 

Thanks

Attachments

Outcomes