How to set max_execution_time
Written by
Updated at December 17, 2025
Case description
In Managed Service for ClickHouse®, the default max_execution_time value is 60. You need to change this value.
Solution
Recreate the external table by adding to LOCATION (pxf:connection_string) ON ALL &query_timeout=3600 to get pxf:connection_string&query_timeout=3600.
After that, run your query. Its execution timeout should increase.
For more information, see this guide on the official VMware website.