In my analysis I've created a table with almost 2.5 billion rows. After the Cross join I want to convert the strings to numbers, use a math formula on each row and convert the data into a pivot table. I've run across a limitation of the amount of rows I can use for the String to number node and solved it by splitting the 2.5 billion rows into five different rows (it's now running). Is there an alternative way of solving this problem?
The error I've come across: Execute failed: Row count is greater than 2147483647. The current node cannot handle more than this number. Please ask the vendor to update the implementation.