Error - tVerticaOutputBulkExec component - MySQL 2 Vertica migration

One Star

Re: Error - tVerticaOutputBulkExec component - MySQL 2 Vertica migration

I am trying to use tVerticaOutputBulkExec component. It is throwing the error "No record was loaded into component tVerticaOutputBulkExec". tVerticaOutput component is working properly. I am using Talend 5.4 and for date format, I handled it separately.
Any lights on the error?
Five Stars

Re: Error - tVerticaOutputBulkExec component - MySQL 2 Vertica migration

Hi Folks,

 

Is there already a light on this? I'm encountering the same problem. Seems that there were no rows loaded when there are fields that has blanks or null values.

 

In this way, we can add a tmap to transform those fields, but I'm not getting the correct syntax, I tried to add the below logic, but I'm encountering a java.lang.IllegalArgumentException: java.lang.ClassCastException.

 

(row2.moneyback_credit==null)||("".equals(row2.moneyback_credit))?1:row2.moneyback_credit 

 

Datatype of this field is decimal. Can you share with me your inputs?

 

Thank you.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.