Skip to main content

For using DIRECT load method with GZIP format, what size to consider

  • February 6, 2019
  • 2 replies
  • 12 views

sverma28

Hi I want to load data in VERTICA with COPY command for GZIP file format. The guide says we can use DIRECT method when the size is > 100MB. My question is when I am loading data in GZIP format, what size should I consider to use DIRECT or not? Is it the raw data size or compressed data size(size of gzip file)? A quick help on this will be appreciated

2 replies

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • February 6, 2019

You need to consider the RAW size as Vertica decompresses the GZIP data before loading it.


sverma28
  • Author
  • New Participant
  • February 6, 2019
Thanks for the quick response