Re: how to select without Mapreduce after index build?

2012-05-15 Thread shrikanth shankar
shankar [mailto:sshan...@qubole.com] > Sent: Saturday, May 12, 2012 12:05 PM > To: user@hive.apache.org > Subject: Re: how to select without Mapreduce after index build? > > My understanding is that the scan of the index is used to remove splits that > are known not to contain m

RE: how to select without Mapreduce after index build?

2012-05-11 Thread ransom.hezhiqiang
) Subject: 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

Re: how to select without Mapreduce after index build?

2012-05-11 Thread shrikanth shankar
AM > To: user@hive.apache.org > Cc: Zhaojun (Terry) > Subject: 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 >

RE: how to select without Mapreduce after index build?

2012-05-11 Thread ransom.hezhiqiang
. So why index exist? No Performance improvements . Best regards Ransom. From: Ashish Thusoo [mailto:athu...@qubole.com] Sent: Saturday, May 12, 2012 12:18 AM To: user@hive.apache.org Cc: Zhaojun (Terry) Subject: Re: how to select without Mapreduce after index build? Indexing in

Re: how to select without Mapreduce after index build?

2012-05-11 Thread Ashish Thusoo
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

how to select without Mapreduce after index build?

2012-05-10 Thread Hezhiqiang (Ransom)
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 .