CSV vs ORC vs Parquet

adriantarauadriantarau Vertica Customer ✭
in General Discussion

Which format in Vertica is better for loading a lot of data (>100 billion rows per day, average file size ~20MB, 50-100 columns)?

Regardless of how long it takes the client to write the file, I'm interested in knowing the fastest way to get the data.

Tagged:

Answers

  • Vertica_CurtisVertica_Curtis Employee

    Parquet. It's easy to use, and faster than Orc. I'm not sure I've seen comparisons between Parquet and CSV, but it's easier to load Parquet generally.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...