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