[ https://issues.apache.org/jira/browse/IGNITE-24304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Iurii Gerzhedovich updated IGNITE-24304: ---------------------------------------- Description: Index system view stores index columns as a string, which makes in difficult to work with and requires manual parsing (e.g. IgniteCatalog provides index information - https://issues.apache.org/jira/browse/IGNITE-24294 ), it would be better to introduce a separate system view for index columns (or extend table columns view to include index columns). System view name: * index_columns System view columns: * schema_id * schema_name * table_id * table_name * index_id * index_name * column_name * column_ordinal - a position in an index definition * collation (desc, asc, null first, null last, etc, see IgniteCatalog SortOrder) (must be null for hash indices) was: Index system view stores index columns as a string, which makes in difficult to work with and requires manual parsing (e.g. IgniteCatalog provides index information - https://issues.apache.org/jira/browse/IGNITE-24294 ), it would be better to introduce a separate system view for index columns (or extend table columns view to include index columns). System view name: * index_columns System view columns: * schema_id * schema_name * table_id * table_name * index_id * index_name * column_ordinal - a position in an index definition * collation (desc, asc, null first, null last, etc, see IgniteCatalog SortOrder) (must be null for hash indices) > Sql. System views. Introduce a system view for index columns > ------------------------------------------------------------ > > Key: IGNITE-24304 > URL: https://issues.apache.org/jira/browse/IGNITE-24304 > Project: Ignite > Issue Type: Improvement > Components: sql > Reporter: Maksim Zhuravkov > Priority: Major > Labels: ignite-3 > > Index system view stores index columns as a string, which makes in difficult > to work with and requires manual parsing (e.g. IgniteCatalog provides index > information - https://issues.apache.org/jira/browse/IGNITE-24294 ), it would > be better to introduce a separate system view for index columns (or extend > table columns view to include index columns). > System view name: > * index_columns > System view columns: > * schema_id > * schema_name > * table_id > * table_name > * index_id > * index_name > * column_name > * column_ordinal - a position in an index definition > * collation (desc, asc, null first, null last, etc, see IgniteCatalog > SortOrder) (must be null for hash indices) -- This message was sent by Atlassian Jira (v8.20.10#820010)