@orpha
To set a query timeout when using the Presto CLI, you can use the --query-timeout option. Here's how you can do it:
1
|
presto --server presto-server-url:port --catalog catalog_name --schema schema_name --query-timeout 30m |
In the above command, --query-timeout 30m sets the query timeout to 30 minutes. You can adjust the timeout value as needed. When the query time exceeds the specified timeout period, the query will be automatically cancelled.
Make sure to replace presto-server-url:port, catalog_name, and schema_name with your actual Presto server URL, port, catalog name, and schema name.