tVerticaOutputBulkExec: Length for type varchar must be at least 1

One Star

tVerticaOutputBulkExec: Length for type varchar must be at least 1

Talend Data Integration Version: 5.5.1
Vertica version v7.1.2-0
tMysqlInput -> tVerticaOutputBulkExec
CREATE TABLE users (   
  id int primary key,
  govid varchar(100),
  govid_type varchar(100)
);
Exception in component tVerticaOutputBulkExec_6_tVBE
java.sql.SQLDataException: (3853) ERROR: Length for type varchar must be at least 1
I cannot enter blank into a varchar column?
Moderator

Re: tVerticaOutputBulkExec: Length for type varchar must be at least 1

Hi davidjhp,
Does this issue repro on other Vertica version?
Please take a look at document about:TalendHelpCenterSmiley Frustratedupported systems%2C databases and business applications by Talend components
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.