Can I use FILLER with fcsvparser ?

shayz

Hi,
I'm trying to use fcsvparser with Filler to copy data from csv to an actual table in vertica (not flex).
Can it be done?
Keep on getting errors.
Thanks

Jim_Knicely

Hi,

No. The FILLER parameter is ignored for the FCSVPARSER. In fact all of the COPY parameters are ignored (i.e. NULLS AS, REJECTED DATA, etc.).
Note that when you use the default type (RFC4180), parameters for FCSVPARSER are fixed and cannot be changed. If you switch to "Traditional" you can specify the parameter values such as delimiter or record terminator.

See:
https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/FlexTables/FCSVPARSERreference.htm