1 of 1 people found this helpful
It looks like your Exasol instance has some restrictions
regarding the allowable temp table space usage.
Since Exasol is essentially an In-Memory DBMS, such a limit is feasible.
Please get an advice from your Exasol DBA, if possible.
As a workaround I could suggest using a datasource filter
to limit the size of your dataset initially, Then you may test
your scenario with LOD calcs, and if no errors, go futher down
with datasource filters to get more rows (untill you've got an error again).
Hope this could help.
This is a pure EXASOL issue and definitely not a Tableau issue.
Briefly though, this situation arises where there is a cartesian join or a nested-loop join where there is no choice for the query engine but to create a big intermediate result set.
One thing worth checking is your join conditions - make sure all the joins are unique and you aren't missing a WHERE statement somewhere.
Otherwise you might want to raise this with your EXASOL support contact.
All the best,