Skip to main content

Ran out of WOS memory during LOAD

  • March 15, 2019
  • 2 replies
  • 8 views

ashishtomer

I am trying to insert the data via compressed .csv files in the Vertica. While doing so a lot of time I get this error:

ERROR 4512: Ran out of WOS memory during LOAD

What should I do to resolve this problem?

2 replies

chaima
Forum|alt.badge.img+2
  • Participating Frequently
  • March 15, 2019

Hello,
Try adding DIRECT option in your copy command.
Kind regards,


Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • March 15, 2019

@ashishtomer - Here is a helpful doc link per your issue and @chaima's recommendation!

"Choosing a Load Method":
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/BulkLoadCOPY/ChoosingALoadMethod.htm