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