You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Vladimir Ozerov (JIRA)" <ji...@apache.org> on 2019/01/20 09:17:00 UTC

[jira] [Assigned] (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 ]

Vladimir Ozerov reassigned IGNITE-10347:
----------------------------------------

    Assignee: Vladimir Ozerov  (was: Yury Gerzhedovich)

> 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: Vladimir Ozerov
>            Priority: Major
>              Labels: iep-29, sql
>          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 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
> 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)