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