[
https://issues.apache.org/jira/browse/IGNITE-10347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yury Gerzhedovich updated IGNITE-10347:
---------------------------------------
Description:
Need to expose system SQL view to provide list of running queries. Proposed
name is *running_queries* with following columns: query_id, node_id, sql,
schema_name, duration.
Where,
query_id - cluster unique id of query
sql - sql command
cancelable - is is possible to cancel the query.
schema_name - SQL schema name
duration - time in ms from start of execution of query
The view should contains all kind of running queries from RunningQueryManager
on local node
was:
Need to expose system SQL view to provide list of running queries. Proposed
name is *running_queries* with following columns: query_id, node_id, sql,
schema_name, duration.
Where,
query_id - cluster unique id of query with format \{node_order_id}
{X} \{node_qry_cntr}
, both node_order_id and node_qry_cntr encoded to HEX. X - 'X' letter used as
separator.
node_id - id of node where query was started
sql - sql command
cancelable - is is possible to cancel the query.
schema_name - SQL schema name
duration - time in ms from start of execution of query
The view should contains all kind of running queries from RunningQueryManager
on local node
> Expose system SQL view for running queries
> ------------------------------------------
>
> Key: IGNITE-10347
> URL: https://issues.apache.org/jira/browse/IGNITE-10347
> Project: Ignite
> Issue Type: Task
> Reporter: Yury Gerzhedovich
> Assignee: Yury Gerzhedovich
> Priority: Major
> Labels: iep-29, sql
> Fix For: 2.8
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Need to expose system SQL view to provide list of running queries. Proposed
> name is *running_queries* with following columns: query_id, node_id, sql,
> schema_name, duration.
> Where,
> query_id - cluster unique id of query
> sql - sql command
> cancelable - is is possible to cancel the query.
> schema_name - SQL schema name
> duration - time in ms from start of execution of query
>
> The view should contains all kind of running queries from RunningQueryManager
> on local node
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
