The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
We have 3 nodes with the following RAM: Node 1 - 4GB Node 2 - 2GB Node 3 - 8GB These are in a cluster. I am trying to load data onto Vertica using both COPY & INSERT commands with DIRECT (command and hint as applicable) by connecting to the database from Node 1 We are facing the error ERROR 3587: Insufficient resources to execute plan on pool general [Request Too Large:Memory(KB) Exceeded: Requested = 687627, Free = 423576 (Limit = 423576, Used = 0)] Free = 423576 is just the RAM free space on Node 1. The RAM space available in the cluster is not being considered for loading the data. Could you please suggest how this can be resolved? Appreciate your quick help and response