Skip to main content

Ran out of WOS memory during LOAD

  • Mar 15, 2019 6:41 AM UTC
  • 2 replies
  • 20 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
    • chaima
    • Participating Frequently
    • Mar 15, 2019 12:43 PM UTC

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

    Jim_Knicely
    Forum|alt.badge.img+2
    • Jim_Knicely
    • Participating Frequently
    • Mar 15, 2019 2:26 PM UTC

    @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

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement