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:bhavesh25s...@gmail.com] Sent: Friday, April 13, 2012 1:22 PM To: user@hive.apache.org; d...@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
