[jira] [Updated] (IGNITE-21353) Sql. Support for choosing the primary key index type.

["Yury Gerzhedovich (Jira)" <ji...@apache.org>]

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

Yury Gerzhedovich updated IGNITE-21353:
---------------------------------------
    Labels: ignite-3  (was: )

> Sql. Support for choosing the primary key index type.
> -----------------------------------------------------
>
>                 Key: IGNITE-21353
>                 URL: https://issues.apache.org/jira/browse/IGNITE-21353
>             Project: Ignite
>          Issue Type: Improvement
>          Components: sql
>            Reporter: Yury Gerzhedovich
>            Priority: Major
>              Labels: ignite-3
>
> As of now we support choosing type just for secondary indexes, like a 
> _CREATE INDEX  idx_name ON table *USING TREE* (column_name)_
> But for PK we always create under the hood HASH index.
> Let's introduce ability to choose type for PK by the analogy with a secondary indexes;
> it should be add an optional parameter *USING type* for PRIMARY KEY definition
> CREATE TABLE ..... PRIMARY KEY *[ USING BTREE | HASH ]* (column1, column2, ... column_n)...
> Also let's set BTREE as default for PK without set concrete type.



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