Question: QUERY_EXCEEDED_COMPILER_LIMIT workaround / solution

[maxgruber19]

We have an internal customer sending very long sql queries to trino, which leads to the error below. Is there any possbility for us to increase that compiler limit? We both hope that we can solve that on trino side by configuration because shrinking the statement would be a very complex task

only related information / issue we found is trinodb/trino#23661 but that does not help us at all. the trino documentation does not show a property to set the limit from outside

TrinoUserError(type=USER_ERROR, name=QUERY_EXCEEDED_COMPILER_LIMIT, message="Query exceeded maximum filters. Please reduce the number of filters referenced and re-run the query."

[maltesander]

Hi Max,

i just found query-max-length, but nothing related to the filter limit.

I think you need to reduce the amount of filter statements or use intermediate tables that do parts of the filtering?

[maxgruber19]

Yeah I found that property as well but it's not matching our error. I guess the internal customer has to split his queries then... I'll forward the intermediate table suggestion