Getting error [Vertica][VJDBC](2052) ERROR: COPY: Row size nnnnnnnn is too large for bulk load

Hi, wonder if this problem occurs outside of JDBC?  Does issue occur when run direct via vsql?
Also, is there a column that is defined too small for the values that is being loaded?

Hi Wayne,

After working through some things here's how we resolved the issue. I am documenting it for future reference if other folks face the same issue. Some of it comes down to being a newbie.

1) SELECT SET_CONFIG_PARAMETER ('StandardConformingStrings' ,'0');
2) Restart Vetica instance so setting takes effect.
3) We were extracting data to a flat file, comma separated. We used double quotes for the quoted strings - this NEEDS to be \" (backslash,double quote)

ref - https://my.vertica.com/docs/4.1/HTML/Master/14677.htm

The bulk loader seemed to work OK once we made these changes.

Hopefully this will save some frustration for others.

Thanks.

Thanks for providing the solution and glad to hear it's working now. Just curious what was the default value for StandardConformingStrings before setting to '0'.

Hi Nimmi,

The value for the  StandardConformingStrings before we reset it was -1. This seems to be the default.

Thanks,