ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yury Gerzhedovich (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (IGNITE-10347) Expose system SQL view for running queries
Date Tue, 20 Nov 2018 15:16:00 GMT

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

Mime
View raw message