the max level of WITH RECURSIVE is about 150000? how to increase it? about hyper-api-samples HOT 3 CLOSED

Unfortunately, there is nothing you can do from the outside. This is not an intentional limit. Hyper is simply running out of memory here. This is something we need to fix internally in our source code. Thanks for bringing it up!

I will update this thread as soon as we shipped a fix

from hyper-api-samples.

I just merged a fix to our main branch which should fix this. The fix should ship in the upcoming November release.

You should now be able to get around 5000x more tuples through the Iteration operator, i.e. around 750M tuples instead of 150k (ballbark estimates might be even more or slightly less).

from hyper-api-samples.

tested. very nice, thank you

D:\>pip install tableauhyperapi --upgrade
D:\>pip list |find "hyper"
tableauhyperapi         0.0.18161
D:\>python temp.py
0.15800905227661133 :  150000

D:\>python temp.py
0.7790446281433105 :  1500000

D:\>python temp.py
6.97939920425415 :  15000000

from hyper-api-samples.