Skip to main content
Question

Can I use FILLER with fcsvparser ?

  • December 23, 2019
  • 1 reply
  • 8 views
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

    1 reply

    Jim_Knicely
    Forum|alt.badge.img+2
    • Jim_Knicely
    • Participating Frequently
    • December 23, 2019

    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

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement