"Pivoting" node on large dataset

KNIME Analytics Platform
1

Hi,

I use KNIME on laptop with 2GB RAM. All nodes works well, except on "Pivoting" on large datasets (now I use dataset with 3 columns and 9 000 000 rows). This node crashes with Java heap error. At knime.ini I changesettings to:

-Xmx1024m 

-XX:MaxPermSize=1024m

Can I change any other settings in this case?

Thank you for the answers.

2

I don't think, it helps to increase the MaxPermSize in this case. You probably do better increasing the Xmx -- if possible. However, we are currently rewriting this node focusing on memory problems and functionality, such as multiple column selection for pivot/group columns and providing more aggregation methods (similar to the GroupBy node).

3