[
https://issues.apache.org/jira/browse/IGNITE-23432?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pavel Pereslegin updated IGNITE-23432:
--------------------------------------
Description:
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}
was:
Add a *node* system view *SQL_QUERIES* with a list of currently running SQL
queries.
{code:sql}
INITIATOR_NODE_ID 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
ORIGINAL_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}
> 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)
