[ 
https://issues.apache.org/jira/browse/IGNITE-25454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Konstantin Orlov updated IGNITE-25454:
--------------------------------------
    Description: 
At the moment, printout of distribution in the EXPLAIN output contains table id 
and zone id:
{code:java}
          Exchange
              distribution: affinity[tableId=18, zoneId=18][0]
              est: (rows=1)
{code}
It would be better to resolve ids and indexes of columns into a names:
{code:java}
          Exchange
              distribution: table PUBLIC.MY_TABLE in zone MY_ZONE by [COL_1, 
COL_2]
              est: (rows=1)
{code}

  was:
At the moment, printout of distribution in the EXPLAIN output contains table id 
and zone id:
{code:java}
          Exchange
              distribution: affinity[tableId=18, zoneId=18][0]
              est: (rows=1)
{code}
It would be better to resolve ids and indexes of columns into a names:
{code:java}
          Exchange
              distribution:zone MY_ZONE by [COL_1, COL_2] of table 
PUBLIC.MY_TABLE 
              est: (rows=1)
{code}


> Sql. Improve printout of distribution in EXPLAIN output
> -------------------------------------------------------
>
>                 Key: IGNITE-25454
>                 URL: https://issues.apache.org/jira/browse/IGNITE-25454
>             Project: Ignite
>          Issue Type: Improvement
>          Components: sql ai3
>            Reporter: Konstantin Orlov
>            Assignee: Konstantin Orlov
>            Priority: Major
>              Labels: ignite-3
>
> At the moment, printout of distribution in the EXPLAIN output contains table 
> id and zone id:
> {code:java}
>           Exchange
>               distribution: affinity[tableId=18, zoneId=18][0]
>               est: (rows=1)
> {code}
> It would be better to resolve ids and indexes of columns into a names:
> {code:java}
>           Exchange
>               distribution: table PUBLIC.MY_TABLE in zone MY_ZONE by [COL_1, 
> COL_2]
>               est: (rows=1)
> {code}



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

Reply via email to