金仓数据库创建hash索引

[kingbase@host1 KingbaseES]$ ksql test system
Password for user system:
ksql (V8.0)
Type "help" for help.
创建测试表
test=# create table tab2 (id int);
CREATE TABLE
插入数据
test=# insert into tab2 values (generate_series(1,100));
INSERT 0 100
创建索引
test=# create index tab2_index on tab2 using hash (id);
CREATE INDEX
test=# \d tab2
                Table "public.tab2"
 Column |  Type   | Collation | Nullable | Default
--------+---------+-----------+----------+---------
 id     | integer |           |          |
Indexes:
    "tab2_index" hash (id)