[
https://issues.apache.org/jira/browse/IGNITE-23432?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maksim Zhuravkov updated IGNITE-23432:
--------------------------------------
Description:
Add a *node* system view *SQL_QUERIES* with a list of currently running SQL
queries.
{noformat}
SQL_QUERIES -- node system view
INITIATOR_NODE_ID VARCHAR
PHASE VARCHAR -- i.e. INITIALIZATION | OPTIMIZATION | EXECUTION |
etc
QUERY_ID VARCHAR
PARENT_QUERY_ID VARCHAR -- reference to a script
ORIGINAL_SQL VARCHAR
START_TIME TIMESTAMP WITH LOCAL TIME ZONE
SCHEMA_NAME VARCHAR
TX_ID VARCHAR
{noformat}
was:
Add a *node* system view *SQL_QUERIES* with a list of currently running SQL
queries.
{noformat}
SQL_QUERIES -- node system view
INITIATOR_NODE_ID VARCHAR
PHASE VARCHAR -- i.e. INITIALIZATION | OPTIMIZATION | EXECUTION |
etc
USERNAME VARCHAR -- GG9 only
QUERY_ID VARCHAR
PARENT_QUERY_ID VARCHAR -- reference to a script
ORIGINAL_SQL VARCHAR
START_TIME TIMESTAMP WITH LOCAL TIME ZONE
SCHEMA_NAME VARCHAR
TX_ID VARCHAR
{noformat}
> 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
> Priority: Major
> Labels: ignite-3
>
> Add a *node* system view *SQL_QUERIES* with a list of currently running SQL
> queries.
> {noformat}
> SQL_QUERIES -- node system view
> INITIATOR_NODE_ID VARCHAR
> PHASE VARCHAR -- i.e. INITIALIZATION | OPTIMIZATION | EXECUTION
> | etc
> QUERY_ID VARCHAR
> PARENT_QUERY_ID VARCHAR -- reference to a script
> ORIGINAL_SQL VARCHAR
> START_TIME TIMESTAMP WITH LOCAL TIME ZONE
> SCHEMA_NAME VARCHAR
> TX_ID VARCHAR
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
