[jira] [Commented] (IGNITE-23432) Provide System View for running queries

["Pavel Pereslegin (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IGNITE-23432?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17892070#comment-17892070 ] 

Pavel Pereslegin commented on IGNITE-23432:
-------------------------------------------

[~korlov], [~jooger] do a review of the proposed patch, please.

> Provide System View for running queries
> ---------------------------------------
>
>                 Key: IGNITE-23432
>                 URL: https://issues.apache.org/jira/browse/IGNITE-23432
>             Project: Ignite
>          Issue Type: Improvement
>          Components: sql
>            Reporter: Maksim Zhuravkov
>            Assignee: Pavel Pereslegin
>            Priority: Major
>              Labels: ignite-3
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> Add a *node* system view *SQL_QUERIES* with a list of currently running SQL queries.
> {code:sql}
> INITIATOR_NODE    VARCHAR
> PHASE             VARCHAR -- i.e. INITIALIZATION | OPTIMIZATION | EXECUTION | etc
> TYPE              VARCHAR -- DDL, DML, QUERY, SCRIPT
> ID                VARCHAR -- Query ID
> PARENT_ID         VARCHAR -- reference to a script
> SQL               VARCHAR
> START_TIME        TIMESTAMP WITH LOCAL TIME ZONE
> SCHEMA_NAME       VARCHAR
> TX_ID             VARCHAR
> STATEMENT_NUM     INT -- Statement number in script (NULL if not applicable)
> {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)