Issues with tVerticaOutputBulkExec/tVerticaBulkExec

[jerownimow]

Hi Folks,

I am trying to load huge data volume (500k to 1M+) on Vertica DB using tVerticaOutputBulkExec/tVerticaBulkExec to optimize the loading but I'm encountering the error/warning:
"No record was loaded into component tVerticaOutputBulkExec"

It is expected that the data should be loaded on DB since the file was already generated by tVerticaOutputBulk.

I tried the following checks:

1. Delimiter on tVerticaOutputBulk and tVerticaOutputBulkExec/tVerticaBulkExec are both ";".
2. Tried on both tVerticaOutputBulk->tVerticaOutputBulkExec and tVerticaOutputBulk->tVerticaBulkExec.

the above setup returns the same result.

I suspect that it is due to blank values on the .csv file generated by tVerticaOutputBulk due to some fields has null values.

Can you help me address this? I am thinking to use tMap before tVerticaOutputBulk to have the NULL values replaced by some numeric values when the file is generated but I'm encountering the error below:

"java.lang.IllegalArgumentException: java.lang.ClassCastException"

Talend Version used: Talend Real-time Big Data Platform 6.4.1
Vertica Version used: Vertica 7.1

[TRF]

Can you share your job design?

[jerownimow]

Here's what the job looks like: