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!
Bulk Load Component Loads '' Instead of NULL values
Moderator: NorbertKrupa
Bulk Load Component Loads '' Instead of NULL values
Everyday is an adventure!
-
JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Bulk Load Component Loads '' Instead of NULL values
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
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
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.