[
https://issues.apache.org/jira/browse/IGNITE-21120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Puchkovskiy updated IGNITE-21120:
---------------------------------------
Description:
The view should be called 'indexes'. It will only display the indexes which are
currently alive (that is, REGISTERED, BUILDING or AVAILABLE).
The view should contain the following columns:
# index_id (INT)
# index_name (VARCHAR)
# table_id (INT)
# table_name (VARCHAR) [at the moment of the query to the view is executed]
# schema_id (INT)
# schema_name (VARCHAR)
# type (VARCHAR, allowed values are 'hash' or 'sorted')
# unique (BOOLEAN)
# columns (VARCHAR) (for a hash index, just a list of column names separated
with commas [like 'first_name, last_name']; for a sorted index, a list of
column names with their collations, like 'first_name ASC, last_name DESC')
# status (VARCHAR)
was:
The view should be called 'indexes'. It will only display the indexes which are
currently AVAILABLE.
The view should contain the following columns:
# index_id (INT)
# index_name (VARCHAR)
# table_id (INT)
# table_name (VARCHAR) [at the moment of the query to the view is executed]
# schema_id (INT)
# schema_name (VARCHAR)
# type (VARCHAR, allowed values are 'hash' or 'sorted')
# unique (BOOLEAN)
# columns (VARCHAR) (for a hash index, just a list of column names separated
with commas [like 'first_name, last_name']; for a sorted index, a list of
column names with their collations, like 'first_name ASC, last_name DESC')
This has to be refined.
> Add a system view to list available indexes
> -------------------------------------------
>
> Key: IGNITE-21120
> URL: https://issues.apache.org/jira/browse/IGNITE-21120
> Project: Ignite
> Issue Type: Improvement
> Reporter: Roman Puchkovskiy
> Assignee: Philipp Shergalis
> Priority: Major
> Labels: ignite-3
> Fix For: 3.0.0-beta2
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> The view should be called 'indexes'. It will only display the indexes which
> are currently alive (that is, REGISTERED, BUILDING or AVAILABLE).
> The view should contain the following columns:
> # index_id (INT)
> # index_name (VARCHAR)
> # table_id (INT)
> # table_name (VARCHAR) [at the moment of the query to the view is executed]
> # schema_id (INT)
> # schema_name (VARCHAR)
> # type (VARCHAR, allowed values are 'hash' or 'sorted')
> # unique (BOOLEAN)
> # columns (VARCHAR) (for a hash index, just a list of column names separated
> with commas [like 'first_name, last_name']; for a sorted index, a list of
> column names with their collations, like 'first_name ASC, last_name DESC')
> # status (VARCHAR)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
