本文共 1661 字，大约阅读时间需要 5 分钟。
创建索引
hive> create index [index_studentid] on table st(studentid)
as 'org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler'
with deferred rebuild
IN TABLE index_table_st;
OK Time taken: 12.219 seconds
org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler ：创建索引需要的实现类
index_studentid:索引名称
st:表名
index_table_st:创建索引后的表名
查看索引表（index_table_st）没有数据
hive> select*from index_table_st;
OK Time taken: 0.295 seconds加载索引数据
hive> alter index index_studentid on st rebuild;
MapReduce Jobs Launched: Stage-Stage-1: Map: 1 Reduce: 1 Cumulative CPU: 4.68 sec HDFS Read: 10282 HDFS Write: 537 SUCCESS Total MapReduce CPU Time Spent: 4 seconds 680 msec OK Time taken: 280.693 seconds
查询索引表中数据
hive> select*from index_table_st;
OK
1 hdfs://hadoop-node4.com:8020/opt/hive/warehouse/st/sutdent.txt [0]
2 hdfs://hadoop-node4.com:8020/opt/hive/warehouse/st/sutdent.txt [28]
3 hdfs://hadoop-node4.com:8020/opt/hive/warehouse/st/sutdent.txt [56]
4 hdfs://hadoop-node4.com:8020/opt/hive/warehouse/st/sutdent.txt [85]
5 hdfs://hadoop-node4.com:8020/opt/hive/warehouse/st/sutdent.txt [113]
6 hdfs://hadoop-node4.com:8020/opt/hive/warehouse/st/sutdent.txt [143]
Time taken: 2.055 seconds, Fetched: 6 row(s)
查看hdfs://hadoop-node4.com:8020/opt/hive/warehouse/st/sutdent.txt
[root@node4 node4]# hdfs dfs -text /opt/hive/warehouse/st/sutdent.txt; 001 0
BeiJing xinlang@.com 002 1
ShangHaixinlang@.com 003 0
ShegZhen xinlang@.com 004 1
NanJing xinlang@.com 005 0
GuangDong xinlang@.com 006 1
HaiNan xinlang@.com
删除索引
DROP INDEX index_studentid on st;
查看索引hive> SHOW INDEX on st;
OK index_studentid st studentid index_table_st compact Time taken: 0.487 seconds, Fetched: 1 row(s)转载地址：http://nrjxi.baihongyu.com/