Hive, mail # user - Has anybody used index on hive tables? how was the performance gain? and best way to do index?

Has anybody used index on hive tables? how was the performance gain? and best way to do index?

Echo Li 2013-03-19, 18:14

Good day,

I wonder how much hive index helps, I had a test before seems it take long
time to build index, hope to learn something from folks here that have good
experience on it.

thanks!
echo

Re: Has anybody used index on hive tables? how was the performance gain? and best way to do index?

Nitin Pawar 2013-03-19, 18:22

indexes are definitely a help if you have aggregation function in your
queries or group by's

sometimes if you have crossjoins it will be helpful as well
On Tue, Mar 19, 2013 at 11:44 PM, Echo Li <[EMAIL PROTECTED]> wrote:

> Good day,
>
> I wonder how much hive index helps, I had a test before seems it take long
> time to build index, hope to learn something from folks here that have good
> experience on it.
>
> thanks!
> echo
>

--
Nitin Pawar

Re: Has anybody used index on hive tables? how was the performance gain? and best way to do index?

Echo Li 2013-03-19, 18:47

Thanks Nitin! What about building index? my experience is that it take long
time to build index, is it that true or I just didn't do it right?

On Tue, Mar 19, 2013 at 11:22 AM, Nitin Pawar <[EMAIL PROTECTED]>wrote:

> indexes are definitely a help if you have aggregation function in your
> queries or group by's
>
> sometimes if you have crossjoins it will be helpful as well
>
>
> On Tue, Mar 19, 2013 at 11:44 PM, Echo Li <[EMAIL PROTECTED]> wrote:
>
>> Good day,
>>
>> I wonder how much hive index helps, I had a test before seems it take
>> long time to build index, hope to learn something from folks here that have
>> good experience on it.
>>
>> thanks!
>> echo
>>
>
>
>
> --
> Nitin Pawar
>