Options
Can I use FILLER with fcsvparser ?
shayz
Vertica Customer
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
0
shayz
Vertica Customer
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
Answers
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