GitHub user bamaer added a comment to the discussion: [Bug]: Java heap Space issue
What is the file size of your CSV files? The blocking transforms require all of your data to be buffered in memory before you can write it out to your Excel sheets. You have 32GB of memory in your machine, but Hop only grabs 2GB by default. Try changing the `-Xmx` parameter in `hop-gui.bat`, set it to for example 8GB. If that doesn't work, splitting up your pipeline to load on CSV file into one Excel sheet at a time will eliminate the need for the blocking transforms. You could do this in a single pipeline with a parameter with CSV file to read, there probably isn't any need to create multiple pipelines. You would need 4 different runs instead of a single one, but won't necessarily had a huge impact on your total throughput time. GitHub link: https://github.com/apache/hop/discussions/5827#discussioncomment-14683938 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
