Bulk Load Component Loads '' Instead of NULL values
Posted: 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!
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!