Issues with tVerticaOutputBulkExec/tVerticaBulkExec

jerownimow — Sat, 16 Nov 2024 07:38:16 GMT

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

Re: Issues with tVerticaOutputBulkExec/tVerticaBulkExec

TRF — Tue, 18 Sep 2018 12:53:54 GMT

Can you share your job design?

Re: Issues with tVerticaOutputBulkExec/tVerticaBulkExec

jerownimow — Wed, 19 Sep 2018 06:13:50 GMT

Here's what the job looks like:

topic Issues with tVerticaOutputBulkExec/tVerticaBulkExec in Talend Studio

Issues with tVerticaOutputBulkExec/tVerticaBulkExec

Re: Issues with tVerticaOutputBulkExec/tVerticaBulkExec

Re: Issues with tVerticaOutputBulkExec/tVerticaBulkExec