Re: question on HIVE-5891

I haven't found a workaround yet. On Thu, Nov 13, 2014 at 11:25 AM, Stéphane Verlet wrote: > Chen > > Did you find a workarround ? Anybody else have a suggestion ? > > Thank you > > Stephane > > On Mon, Aug 4, 2014 at 9:00 AM, Chen Song wrote: > >> I am using cdh5 distribution and It doesn't lo

Can CLUSTERED BY/SORTED BY speed up processing aggregations or inter-row calculations?

Can Hive optimizer take advantage of tables CLUSTERED BY … SORTED BY … when performing aggregations or analytic functions (window aggregations)? If so, how? more details at SO: optimize Hive table storage for subsequent Aggregations and/or Window Analytic Functions

What is the difference in explain output between Bucket Map Join and normal Map Join?

Hi All, I am testing the different explain plan output and found it hard to find the difference between Bucket Map Join(non sort merged) and normal Map Join. The tested hive version is 0.13. To enable Bucket Map Join, there are 2 conditions: 1. set hive.optimize.bucketmapjoin = true; 2. If the ta

[Blog] Hive Partitioning

Hi, This is a blog on Hive partitioning. http://unmeshasreeveni.blogspot.in/2014/11/hive-partitioning.html Hope it helps someone. -- *Thanks & Regards * *Unmesha Sreeveni U.B* *Hadoop, Bigdata Developer* *Centre for Cyber Security | Amrita Vishwa Vidyapeetham* http://www.unmeshasreeveni.blog

[Blog] Updating Partition Table using INSERT In HIVE

Hi This is a blog on Hive updating for older version (hive -0.12.0) http://unmeshasreeveni.blogspot.in/2014/11/updating-partition-table-using-insert.html Hope it helps someone. -- *Thanks & Regards * *Unmesha Sreeveni U.B* *Hadoop, Bigdata Developer* *Centre for Cyber Security | Amrita Vishw