We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Performance Delimiter Vs. Fcsvparser — Vertica Forum

Performance Delimiter Vs. Fcsvparser

 

Hi 

 

I would like to know, why would fcsvparser taking more time to complete compared to delimiter as below:

 

dbadmin=> copy fs.columnar_tbl1 from '/home/shared/300MB.csv' delimiter ',' skip 1;
Rows Loaded
-------------
261607
(1 row)

Time: First fetch (1 row): 26819.648 ms.

 

dbadmin=> copy fs.columnar_tbl2 from '/home/shared/300MB.csv' parser fcsvparser();
Rows Loaded
-------------
261607
(1 row)

Time: First fetch (1 row): 58866.387 ms.

 

 

 

Many Thanks

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file