Error loading TSV file into Vertica Flex("String of 2 octets is too long for type Varchar(1)" )
I'm trying to load some TSV data into Vertica. It has maybe 2000 columns, and the column names are up to 300 characters(3rd party marketing data).
When I try to load into Vertica Flex though, I get the following error:
Error: [Vertica][VJDBC](4800) ERROR: String of 2 octets is too long for type Varchar(1)
The commands I put in to create the table and load data:
CREATE FLEX TABLE ad.ptv_job_title()
copy ad.ptv_job_title from local '/Users/al/Documents/jobtitle.txt' parser fdelimitedparser (delimiter
I've been blocked on this for days, any help would be awesome.