Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> 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
Copy link to this message
-
Re: Has anybody used index on hive tables? how was the performance gain? and best way to do index?
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
+
Echo Li 2013-03-19, 18:47