Hive对表建立索引
1.首先创建表
create table user(
id int,
name string,
address string
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS TEXTFILE;
2.创建索引
create index user_index on table user(id)
as'org.apache.hadoop.hive.ql.index.compact.CompactIndexHan.
转载
2020-11-05 10:15:51 ·
3239 阅读 ·
0 评论