The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
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
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