The Vertica Database Forums

Hey,

Any one out there using Talend? I'm having a problem with the Vertica bulk load component when loading data into a table. The issues is that if the source data is null then the loaded data in the table contains an empty string '' whereas I would expect the values to be null. So when I query the table columns with the IS NULL predicate I get no rows, but when I use column = '' I get rows back.

Has anyone encountered this problem? Please let me know if you need any addition information. This has been driving me crazy!

Janice,

What value are you using for the "Null String" setting on the "Advanced settings" tab? The default is "Null". Try setting it it "" (That's a double quote followed by another double quote). That works for us