I can't seem to create a base view from a query that uses a temp table.
From looking around online/on the forums, this seems like an intentional limitation due to the session-limited lifetime of temporary tables.
However, this seems like a bad limitation. Base views allow retention of complex queries written in the 'source' SQL of the data source.
In a lot of cases, these complex queries need to use temporary tables to solve performance issues, especially in cases where it's not possible or feasible to change the indexes of the data source tables. Of course temporary tables are session-limited, but the benefits are often significant and in some cases are the only ways for complex queries to be ported to Denodo.
Is there any way to create a base view from a query that uses temporary tables? It's critical for data transforming/logic that takes magnitudes longer on the original tables. Temp tables allow custom indexes to optimise the exact logic needed in these queries, and not being able to do that in Denodo will be a serious issue.
