RESTART QUERY

Syntax

RESTART QUERY query_id;

Description

For a query that has failed, RESTART QUERY will restart the query specified by the query_id. Before restarting a query, the user should use DESCRIBE QUERY to check the logs and determine if it is worthwhile to restart the query, or if the the query will just fail again.

Arguments

query_id

This specifies the unique identifier of the query to restart. See LIST QUERIES to find out how to list all queries that the user has access to. The first column (ID) in the response corresponds with the query_id.

Examples

Restart a query

The following is an example of how to restart a query. The LIST QUERIES command is used to find the query_id.

demo_db.public/demostore# LIST QUERIES;
                   ID                  |  State  |                             DSQL                             |  Owner   |      Created at      |      Updated at
---------------------------------------+---------+--------------------------------------------------------------+----------+----------------------+-----------------------
  3d716a1a-1c38-4a18-9365-9def343731b8 | ERRORED | CREATE STREAM pageviews2 AS                                  | sysadmin | 2023-02-08T02:11:08Z | 2023-02-08T04:11:14Z
                                       |         | SELECT * FROM pageviews;

demo_db.public/demostore# RESTART QUERY 3d716a1a-1c38-4a18-9365-9def343731b8;