hi, i have created a table hive_hbase_visitor2 in hive, and created an index on the table,but when i execute the query plan about *select ** from hive_hbase_visitor2 where name='knlf', the description of index was not found, did the index not succeed?
*create index hive_hbase_visitor2_index on table hive_hbase_visitor2(name) as 'org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler' WITH DEFERRED REBUILD in table hive_index_table;* *alter index hive_hbase_visitor2_index on hive_hbase_visitor2 rebuild;* *hive> explain select * from hive_hbase_visitor2 where name='knlf';* *OK* *STAGE DEPENDENCIES:* * Stage-1 is a root stage* * Stage-0 depends on stages: Stage-1* *STAGE PLANS:* * Stage: Stage-1* * Map Reduce* * Map Operator Tree:* * TableScan* * alias: hive_hbase_visitor2* * Statistics: Num rows: 33082940 Data size: 661658800 Basic stats: COMPLETE Column stats: NONE* * Filter Operator* * predicate: (name = 'knlf') (type: boolean)* * Statistics: Num rows: 16541470 Data size: 330829400 Basic stats: COMPLETE Column stats: NONE* * Select Operator* * expressions: id (type: string), 'knlf' (type: string), age (type: int), sex (type: string)* * outputColumnNames: _col0, _col1, _col2, _col3* * Statistics: Num rows: 16541470 Data size: 330829400 Basic stats: COMPLETE Column stats: NONE* * File Output Operator* * compressed: false* * Statistics: Num rows: 16541470 Data size: 330829400 Basic stats: COMPLETE Column stats: NONE* * table:* * input format: org.apache.hadoop.mapred.TextInputFormat* * output format: org.apache.hadoop.hive.ql.io <http://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.173 seconds, Fetched: 32 row(s)*
