You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@ignite.apache.org by "Maksim Zhuravkov (Jira)" <ji...@apache.org> on 2024/10/15 06:21:00 UTC

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

Maksim Zhuravkov created IGNITE-23432:
-----------------------------------------

             Summary: 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


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}




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