Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Here's what the job looks like: