Updating query rewrite timeout for Query Optimizer

The default query rewrite timeout for Query Optimizer is 60 seconds. You can change this value using the PATCH API after activating Query Optimizer.

Procedure

Run the following PATCH API command to update the query rewrite timeout:

curl --request PATCH \
  --url https://<CPD-URL>/lakehouse/api/v3/<INSTANCE_ID>/prestissimo_engines/<ENGINE_ID> \
  --header 'Authinstanceid: <INSTANCE_ID>' \
  --header 'Authorization: Bearer <BEARER_TOKEN>' \
  --header 'content-type: application/json' \
 --data '{
    "display_name": "prestissimo-small",
    "description": "",
    "properties": {
        "configuration": {
            "coordinator": {
                "query.max-history": "2000"
            },
            "worker": {
            }
        },
        "jvm": {
            "coordinator": {
            }
        },
        "catalog": {
            "hive_data": {
                "coordinator": {
                },
                "worker": {}
            }
        },
        "velox": {
        },
        "log_config": {
            "coordinator": {
            },
            "worker": {}
        },
        "optimizer_properties": {
            "optplus.query-timeout-seconds":"3000"

        },
        "global": {}
    },
    "restart_type": "force",
    "tags": []
}'

Parameters:

CPD-URL: The watsonx.data console URL.
INSTANCE_ID: The instance identifier.
ENGINE_ID: The Presto engine identifier.
BEARER_TOKEN: The bearer token for authorization.

Update the value of optplus.query-timeout-seconds to the desired timeout in seconds.

Note: The default timeout is 60 seconds. Set a higher value for complex queries that require more processing time.