index 索引

1.创建表

drop table if exists kg_fk_user;
create table kg_fk_user(
id int,
name string
)
row format delimited
fields terminated by ","
stored as textfile;

2. 创建索引

create index user_index on table kg_fk_user(id)
as "org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler"
with deferred rebuild
in table kg_fk_user_index;

3. 显示索引

show formatted index on kg_fk_user;

4.重建索引

alter index user_index on kg_fk_user rebuild;

5.删除索引

drop index if exists user_index on  kg_fk_user