[
https://issues.apache.org/jira/browse/TAJO-837?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14033359#comment-14033359
]
Jihoon Son commented on TAJO-837:
---------------------------------
Even though index meta information is already stored in catalog, I think it
needs to be refactored to include the followings.
||Name||Type||Description||
|INDEX_ID|INT4|The unique id of each index|
|INDEX_NAME|TEXT|The name of index|
|TABLE_ID|INT4|Table id reference|
|DB_ID|INT4|Database id reference|
|METHOD|TEXT|Index method name|
|IS_UNIQUE|BOOL|If true, this is a unique index.|
|IS_CLUSTERED|BOOL|If true, this is a clustered index.|
|IS_ASCENDING|BOOL|If true, leaf entries are sorted in ascending order.|
|EXPR_NUM|INT4|Number of expression trees in the index|
|EXPRS|TEXT|A comma separated list of JSON strings of expression trees|
|EXPR_TYPES|TEXT|A comma separated list of types of expression trees|
|PRED|TEXT|Expression tree for partial index predicate. Null if not a partial
index|
If the discussion of index location in TAJO-835 is finished, the location
information can be added.
> Register index meta information at Catalog
> ------------------------------------------
>
> Key: TAJO-837
> URL: https://issues.apache.org/jira/browse/TAJO-837
> Project: Tajo
> Issue Type: Sub-task
> Components: catalog
> Reporter: Jihoon Son
> Assignee: Jihoon Son
> Priority: Minor
> Fix For: 0.9.0
>
>
> Index meta information should include the following things.
> * index name, location, target columns, null first, sort order
> * Histogram of target columns
--
This message was sent by Atlassian JIRA
(v6.2#6252)
