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

Switch to Threaded View
Hive >> mail # user >> How to Decide How Many Buckets to Use?

Copy link to this message
Re: How to Decide How Many Buckets to Use?
Hi Xun,
Here is an answer I had given earlier on the mailing list. See if that helps.

http://mail-archives.apache.org/mod_mbox/hive-user/201204.mbox/%[EMAIL PROTECTED]%3E


----- Original Message -----
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!