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

Switch to Threaded View
Hive >> mail # user >> Can a bucket be added to a partition?

Copy link to this message
Re: Can a bucket be added to a partition?
I tried this interesting idea but also felt a little confusing.

I guess you'll need to change the table schema so that it has both buckets
and partitions.

And to take advantage of the buckets inside the partitions, for example
using the bucket map join, you'll need to specify one particular partition
of the table. Seems HIVE-3171 has fixed this problem, but I'm still not
very clear how two partitioned tables can be joined using bucket map join?
Do they need the same partition keys and bucket keys, and then Hive will do
partition-wise join as well as bucket-wise join?

On Tue, Apr 30, 2013 at 12:03 PM, Babe Ruth <[EMAIL PROTECTED]>wrote:

> Hello,
>  I have a table that is already created and is partitioned dynamically by
> day.     i would like all future partitions to be bucketed on two columns.
> Can I add a bucket to a partitions in an already existing table?
> Thanks,
> George