[
https://issues.apache.org/jira/browse/IGNITE-21353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pavel Pereslegin updated IGNITE-21353:
--------------------------------------
Ignite Flags: Docs Required (was: Docs Required,Release Notes Required)
> 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: Iurii Gerzhedovich
> Assignee: Maksim Zhuravkov
> Priority: Major
> Labels: ignite-3
> Fix For: 3.0.0-beta2
>
> Time Spent: 3h 10m
> Remaining Estimate: 0h
>
> 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 and add ability set collation for columns including into PK)
> CREATE TABLE ..... (..., PRIMARY KEY *[ USING SORTED | HASH ]* (column1,
> column2, ... column_n)) ...)
> as example full command: CREATE TABLE my (c1 INT, c2 INT, c3 INT, PRIMARY KEY
> *USING* {*}SORTED{*}{*}{{*}} (c2 ASC, c1 DESC NULL FIRST))
> Also let's set BTREE as default for PK without set concrete type.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
