RE: Bucketing in Hive

2016-01-26 Thread Mich Talebzadeh
of the recipient to ensure that this email is virus free, therefore neither Peridale Technology Ltd, its subsidiaries nor their employees accept any responsibility. From: Maciek [mailto:mac...@sonra.io] Sent: 26 January 2016 22:01 To: user Subject: Re: Bucketing in Hive These two serve

Re: Bucketing in Hive

2016-01-26 Thread Maciek
ommonly used among RDBMS . > > > > Excuse my ignorance, I am at loss to know why hash partitioning is called > bucketing in Hive? Someone may throw light on what are the main differences > if any. > > > > As I see it in RDBMS Partitioning has these benefits: > > > &

Bucketing in Hive

2016-01-26 Thread Mich Talebzadeh
among RDBMS . Excuse my ignorance, I am at loss to know why hash partitioning is called bucketing in Hive? Someone may throw light on what are the main differences if any. As I see it in RDBMS Partitioning has these benefits: 1.Availability -- each partition can reside on a different

Re: bucketing in hive

2011-12-17 Thread Raghunath, Ranjith
Thanks for the help with this. Thanks, Ranjith From: Bejoy Ks [mailto:bejoy...@yahoo.com] Sent: Friday, December 16, 2011 04:41 AM To: user@hive.apache.org Subject: Re: bucketing in hive Ranjith You can definitely change the number of buckets in a hive table even after its creation. You

Re: bucketing in hive

2011-12-16 Thread Bejoy Ks
a different number of buckets. Hope it helps!... Regards Bejoy.K.S From: "Raghunath, Ranjith" To: "'user@hive.apache.org'" ; "'bejoy...@yahoo.com'" Sent: Friday, December 16, 2011 10:48 AM Subject: Re:

Re: bucketing in hive

2011-12-15 Thread Raghunath, Ranjith
Thanks Bejoy. Appreciate the insight. Do you know of altering the number of buckets once a table has been set up? Thanks, Ranjith From: Bejoy Ks [mailto:bejoy...@yahoo.com] Sent: Thursday, December 15, 2011 06:13 AM To: user@hive.apache.org ; hive dev list Subject: Re: bucketing in hive Hi

Re: bucketing in hive

2011-12-15 Thread Bejoy Ks
Hi Ranjith     I'm not aware of any Dynamic Bucketing in hive where as there is definitely  Dynamic Partitions available. Your partitions/sub partitions would be generated on the fly/dynamically based on the value of a particular column .The records with same values for that column wou

bucketing in hive

2011-12-14 Thread Raghunath, Ranjith
Can one use bucketing in hive to emulate hash partitions on a database? Is there also a way to segment data into buckets dynamically based on values in the column. For example, Col1 Col2 Apple1 Orange 2 Apple2 Banana