Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Error (Sort Buffer failed)

When i executed transformations pdi, vertica returns this error:
**2019/09/02 12:16:16 - Table output.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
2019/09/02 12:16:16 - Table output.0 - Error inserting/updating row
2019/09/02 12:16:16 - Table output.0 - [Vertica]VJDBC ERROR: Malloc of 399458304 bytes for Sort Buffer failed
It's necessary up the pool parameters in vertica?



  • Jim_KnicelyJim_Knicely Administrator
    edited September 2019

    Check out the "Vertica Integration with Pentaho Data Integration (PDI): Tips and Techniques" guide here:

    In particular, if you are doing a large data load:

    1. When using the Standard Output Table component, add the DirectBatchInsert parameter to the connection and set it to true
    2. To specify that the Vertica Bulk Loader write data directly to the ROS, select Insert direct to ROS.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.