我通过
CREATE INDEX ind_test_id_bit on table test(id) AS 'BITMAP' WITH DEFERRED REBUILD;
alter index ind_test_id_bit on test rebuild;
在test表建立了一个id列的索引，但是
explain select count(1) from test where id = 38188211;
看执行计划中并没有体现出引用了索引的相关部分
explain内容：
hive> explain select count(1) from test where id = 38188211;
OK
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
STAGE PLANS:
Stage: Stage-1
Tez
Edges:
Reducer 2 <- Map 1 (SIMPLE_EDGE)
DagName: hive_20160108102929_fe47fb95-3ebc-4b31-a7c7-c50dd60b5198:25
Vertices:
Map 1
Map Operator Tree:
TableScan
alias: test
filterExpr: (id = 38188211) (type: boolean)
Statistics: Num rows: 483 Data size: 11052 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (id = 38188211) (type: boolean)
Statistics: Num rows: 241 Data size: 5514 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: 1 (type: int)
outputColumnNames: _col0
Statistics: Num rows: 241 Data size: 5514 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count(_col0)
mode: hash
outputColumnNames: _col0
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
sort order:
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: bigint)
Reducer 2
Reduce Operator Tree:
Group By Operator
aggregations: count(VALUE._col0)
mode: mergepartial
outputColumnNames: _col0
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: bigint)
outputColumnNames: _col0
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Stage: Stage-0
Fetch Operator
limit: -1
Processor Tree:
ListSink
Time taken: 0.115 seconds, Fetched: 58 row(s)
