Here is an answer I had given earlier on the mailing list. See if that helps.
----- Original Message -----
From: "Xun TANG" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Sent: Tuesday, July 10, 2012 10:08:22 PM
Subject: How to Decide How Many Buckets to Use?
We use Hive to store user click logs and dig out interesting trends, doing a lot of big table joins.
We mostly partition by date, and inside each partition data is bucketed by some hashed-id.
We are wondering how many buckets to use?
If I understand correctly, Hive DB stores each bucket in one file. One file could be break down to several buckets based on bucket size.
Is this one of the criteria to determine bucket size s.t. each file in one block? What else should be considered?
Is there a rule-of-thumb in selecting how many buckets to use? Any insight/comment welcome!