[IGNITE-23432] Provide System View for running queries

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Done
• Component/s: sql
• Labels: ignite-3
• Epic Link: Kill Queries
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Pavel Pereslegin
• Reporter: Maksim Zhuravkov
• Created: 15/Oct/24 06:20
• Updated: 25/Oct/24 12:25
• Resolved: 25/Oct/24 12:25

Description

Add a node system view SQL_QUERIES with a list of currently running SQL queries.

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)

Issue Links

• blocks: IGNITE-23489 Rest. Introduce new endpoints returning active transactions and running queries
• blocks: IGNITE-23464 Implement cancellation in JDBC
• links to: GitHub Pull Request #4591