How many levels of nested SUPERS can Starburst support? Is there a maximum limit?
I’m assuming by SUPERS you are talking about ‘nested queries’ (i.e. subqueries)…
I don’t think there is a configurable amount, but you have two other limiting factors. A generous 1MB default (configurable up to 1GB) for query.max-length, but the default value of 150 query.max-stage-count will probably end up limiting how many subselects you can do since most will require a stage to read the data.
now that I see Querying a Struct, I guess you meant structural types such as ROW and MAP?
yes that is correct row
After consulting the Starburst engineering team it seems the general Trino answer is “There are no built-in system limits. Depending on rest of the query shape more or less may be possible. The overall limits depend on JVM limits around code-generation.”
Thank you apprciate you chekcing