hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From min zou <zoumin1...@gmail.com>
Subject Re: hive query plain has not index description
Date Fri, 20 Jan 2017 03:39:11 GMT
it's fixed, as the params were not work.

2017-01-19 17:34 GMT+08:00 min zou <zoumin1217@gmail.com>:

> 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)*
>

Mime
View raw message