AnsweredAssumed Answered

Show MySql Query Error

Question asked by Roberto D'Orazio on Jun 20, 2018
Latest reply on Jun 21, 2018 by Chris Eicher

Hi All,

I'm trying to insert CSV rows into MySql DB, the CSV has more than 300 fields for row, in some case the insert go on error and I cannot find the error queries or the mysql error returned to understand what the issue is.

My Actual Configuration is

Pentaho Data-Integration 8.0

Red Hat 6.5 Server

Text-File-Input to read CSV File -> Select-Values -> Table-Output

Select Values and Table Output handler errors on Write To log file where I found all fields in error in json format.


I googled and searched here, I tried several log levels but without success...

Is there a way to log or write the SQL insert query or the MySql error returned?


Thanks in advance