You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Yury Gerzhedovich (JIRA)" <ji...@apache.org> on 2018/11/20 15:16:00 UTC
[jira] [Updated] (IGNITE-10347) Expose system SQL view for running
queries
[ 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, connection_id, duration.
Where,
query_id - cluster unique id of query.
node_id - id of node where query was started
sql - sql command
schema_name - SQL schema name
connection_id - unique connection id
duration - time in ms from start of execution of query
The view should contains all running queries on all nodes of grid include all kind of SQL queries (SLECT/DML/DDL, transactional, non transnational, local, distributed, .
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, connection_id, duration.
Where,
query_id - cluster unique id of query.
node_id - id of node where query was started
sql - sql command
schema_name - SQL schema name
connection_id - unique connection id
duration - time in ms from start of execution of query
The view should contains all running queries on grid.
> 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
>
> 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, connection_id, duration.
> Where,
> query_id - cluster unique id of query.
> node_id - id of node where query was started
> sql - sql command
> schema_name - SQL schema name
> connection_id - unique connection id
> duration - time in ms from start of execution of query
>
> The view should contains all running queries on all nodes of grid include all kind of SQL queries (SLECT/DML/DDL, transactional, non transnational, local, distributed, .
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)