RE: Bucketing- Identify Number of Buckets

2015-09-06 Thread Mich Talebzadeh
gmail.com] Sent: 06 September 2015 21:22 To: user@hive.apache.org Subject: Re: Bucketing- Identify Number of Buckets Details of Hive Version: I am using Hive -14.0 with Tez as execution engine. Thanks, Saurabh Sent from my iPhone, please avoid typos. > On 07-Sep-20

Re: Bucketing- Identify Number of Buckets

2015-09-06 Thread Db-Blog
Details of Hive Version: I am using Hive -14.0 with Tez as execution engine. Thanks, Saurabh Sent from my iPhone, please avoid typos. > On 07-Sep-2015, at 1:51 am, Db-Blog wrote: > > Hi, > > I need to join two big tables in hive. The join key is the grain of both

Bucketing- Identify Number of Buckets

2015-09-06 Thread Db-Blog
Hi, I need to join two big tables in hive. The join key is the grain of both these tables, hence clustering and sorting on the same will provide significant performance optimisation while joining. However, i am not sure how to calculate the exact number of buckets while creating these