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? Jie On Tue, Apr 30, 2013 at 12:03 PM, Babe Ruth <gtevelde-h...@hotmail.com>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 >
