Skip to main content

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

  • Feb 6, 2019 7:24 AM UTC
  • 2 replies
  • 18 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
  • Feb 6, 2019 11:27 AM UTC

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


sverma28
  • Author
  • New Participant
  • Feb 6, 2019 11:36 AM UTC
Thanks for the quick response