You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Ignite TC Bot (Jira)" <ji...@apache.org> on 2025/11/20 05:56:00 UTC
[jira] [Commented] (IGNITE-26598) Add INITIATOR_ID field to SQL_QUERIES_HISTORY system view
[ https://issues.apache.org/jira/browse/IGNITE-26598?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18039540#comment-18039540 ]
Ignite TC Bot commented on IGNITE-26598:
----------------------------------------
{panel:title=Branch: [pull/12518/head] Base: [master] : No blockers found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/12518/head] Base: [master] : New Tests (5)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Calcite SQL{color} [[tests 1|https://ci2.ignite.apache.org/viewLog.html?buildId=8713908]]
* {color:#013220}IgniteCalciteTestSuite: SqlDiagnosticIntegrationTest.testSqlFieldsQueryWithInitiatorId - PASSED{color}
{color:#00008b}Queries 3{color} [[tests 2|https://ci2.ignite.apache.org/viewLog.html?buildId=8713535]]
* {color:#013220}IgniteBinaryCacheQueryTestSuite3: SqlQueryHistoryFromClientSelfTest.testSqlFieldsQueryHistoryWithInitiatorId - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite3: SqlQueryHistorySelfTest.testSqlFieldsQueryHistoryWithInitiatorId - PASSED{color}
{color:#00008b}Queries 3 (lazy=true){color} [[tests 2|https://ci2.ignite.apache.org/viewLog.html?buildId=8713536]]
* {color:#013220}IgniteBinaryCacheQueryLazyTestSuite3: SqlQueryHistorySelfTest.testSqlFieldsQueryHistoryWithInitiatorId - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryLazyTestSuite3: SqlQueryHistoryFromClientSelfTest.testSqlFieldsQueryHistoryWithInitiatorId - PASSED{color}
{panel}
[TeamCity *--> Run :: All* Results|https://ci2.ignite.apache.org/viewLog.html?buildId=8713572&buildTypeId=IgniteTests24Java8_RunAll]
> Add INITIATOR_ID field to SQL_QUERIES_HISTORY system view
> ---------------------------------------------------------
>
> Key: IGNITE-26598
> URL: https://issues.apache.org/jira/browse/IGNITE-26598
> Project: Ignite
> Issue Type: Task
> Reporter: Oleg Valuyskiy
> Assignee: Oleg Valuyskiy
> Priority: Minor
> Labels: ise
> Time Spent: 10m
> Remaining Estimate: 0h
>
> The {{SqlFieldsQuery}} API allows attaching custom user-defined information via the {{setQueryInitiatorId}} method. This value is already available in the {{SQL_QUERIES}} system view, enabling identification of the originator for currently running queries.
> However, the {{SQL_QUERIES_HISTORY}} system view does not expose this field. This task is to extend the schema of {{SQL_QUERIES_HISTORY}} by adding an {{INITIATOR_ID}} column:
> * The value should reflect the last {{queryInitiatorId}} provided for the given query.
> * The field must *not* be part of the query’s key.
> * If {{setQueryInitiatorId}} was not used, the column should contain its default value.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)