Doubt related to INDEX in Hive

[Bhavesh Shah <bh...@gmail.com>]

Hello,
I am just started using Hive in Hive. I never used it before.
I just want to ask one thing related to this is that:  If I use INDEX in my
task then Does it be give any change in performance?
I mean that If I started using Hive then  what about the performance of
HIve?
Does it increase?


-- 
Thanks and Regards,
Bhavesh Shah

RE: Doubt related to INDEX in Hive

[binhnt22 <Bi...@viettel.com.vn>]

Index in Hive is nothing like index in RDBMS.

 

It's useful for summary sql like sum, count group by index columns.

 

Detail information you should read in
http://www.slideshare.net/NikhilDeshpande/indexed-hive

 

Best regards

Nguyen Thanh Binh (Mr)

Cell phone: (+84)98.226.0622

 

From: Bhavesh Shah [mailto:bhavesh25shah@gmail.com] 
Sent: Friday, April 13, 2012 1:22 PM
To: user@hive.apache.org; dev@hive.apache.org
Subject: Doubt related to INDEX in Hive

 

Hello,
I am just started using Hive in Hive. I never used it before.
I just want to ask one thing related to this is that:  If I use INDEX in my
task then Does it be give any change in performance?
I mean that If I started using Hive then  what about the performance of
HIve?
Does it increase?


-- 
Thanks and Regards,

Bhavesh Shah