[ 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)