Bulk Load Component Loads '' Instead of NULL values

Moderator: NorbertKrupa

Post Reply
User avatar
janice
Intermediate
Intermediate
Posts: 51
Joined: Wed May 30, 2012 1:14 pm

Bulk Load Component Loads '' Instead of NULL values

Post by janice » Thu Mar 06, 2014 5:00 pm

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!
Everyday is an adventure!

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Bulk Load Component Loads '' Instead of NULL values

Post by JimKnicely » Thu Mar 06, 2014 8:59 pm

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 :)
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Talend”