Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> how to select without Mapreduce after index build?


Copy link to this message
-
Re: how to select without Mapreduce after index build?
Indexing in Hive works through map/reduce. There are no active components
in Hive (such as the region servers in Hbase), so the way the index is
basically used is by running the map/reduce job on the table that holds the
index data to get all the relevant offsets into the main table and then
using those offsets to figure out which blocks to read from the main table.
So you will not see map/reduce go away even when you are running queries on
tables with indexes on them.

Ashish

On Thu, May 10, 2012 at 11:32 PM, Hezhiqiang (Ransom) <
[EMAIL PROTECTED]> wrote:

>  I think if I  create index for one table****
>
> When I excute “select c1,c2 from tab where index_col=1”, should not start
> mapreduce****
>
> But it was start .****
>
> So how to use a index without mapreduce?****
>
> Compact  index and bitmap index all was tested , all need mapreduce . ****
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB