hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jie Li <>
Subject Re: Can a bucket be added to a partition?
Date Thu, 02 May 2013 04:38:59 GMT
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 <>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

View raw message