DESCRIBE QUERY STATE [query_id | query_name[:query_version]];
Description
This command provides a snapshot of the source relations' position in a terminated created in the current .
See on how streaming queries operate in DeltaStream.
The query is visible only if the current role has USAGE privileges.
Arguments
query_id
This is the unique identifier of the query to describe. See to find out how to list all queries to which the user has access. The first column (ID) in the response corresponds with the query_id.
query_name
This is the name of the query to describe. See to find out how to list all queries to which the user has access. The column (Name) in the response corresponds with the query_name. The query_version property disambiguates between multiple queries with the same name.
query_version
This is the version of the query to describe. See to find out how to list all queries to which the user has access. The column (Version) in the response corresponds with the query_version. If query_name is provided without a query_version, the system uses the latest query_version.
Examples
State for an active query
The following example shows that an active query does not report any state information:
demodb.public/demostore# DESCRIBE QUERY STATE 24f5a97b-97e9-40eb-8dbf-431b96474972;
+----------------+-------------+-------+
| Relation Name | Store Type | Info |
+================+=============+=======+
+----------------+-------------+-------+
demodb.public/demostore# DESCRIBE QUERY STATE demoquery:1;
+----------------+-------------+-------+
| Relation Name | Store Type | Info |
+================+=============+=======+
+----------------+-------------+-------+
State for a terminated query
The following example shows that the described query was operating on a single source, demodb.public.pagevviews, in a store of type Kafka, and was at the offset 28899068 in partition 0 when the query was terminated:
demodb.public/demostore# DESCRIBE QUERY STATE 24f5a97b-97e9-40eb-8dbf-431b96474972;
+---------------------------+-------------+-----------------------------+
| Relation Name | Store Type | Info |
+===========================+=============+=============================+
| demodb.public.pagevviews | KAFKA | partition:0,offset:28899068 |
+---------------------------+-------------+-----------------------------+
demodb.public/demostore# DESCRIBE QUERY STATE demoquery:1;
+---------------------------+-------------+-----------------------------+
| Relation Name | Store Type | Info |
+===========================+=============+=============================+
| demodb.public.pagevviews | KAFKA | partition:0,offset:28899068 |
+---------------------------+-------------+-----------------------------+
