Need idea on Hash Partitioning In Server Jobs

sasi_kumarreddy · Post by **sasi_kumarreddy** » Sun Aug 28, 2005 10:17 pm

Give me an idea on Hash partition with an example :D :D

ray.wurlod · Post by **ray.wurlod** » Mon Aug 29, 2005 12:49 am

Please post on the appropriate forum, and supply a context for your question. Or do a search, either here or on Google, etc.

roy · Post by **roy** » Tue Aug 30, 2005 4:20 am

Hi,
Can you please give more details?
(I assume you ment parallel job is this so?)

kumar_s · Post by **kumar_s** » Tue Aug 30, 2005 10:07 am

Hi,
If you need information regarding partition out guide gives more information.
If this partition is selected for a key, hashing algorigthm is aplied over that particular column. (You can find hasing algorighm in net.
one sample link...
http://www.partow.net/programming/hashf ... sOfHashing)
The record set are seperated based on the result of the hashing and sent to individual partition. so a bunch of record with a same type flows in to a partiton. So it is recomended to use this partition at place where join/merge or key based operatin.

regards
kumar

ray.wurlod · Post by **ray.wurlod** » Tue Aug 30, 2005 4:08 pm

Hash partitioning (or a hybrid, such as range-hash partitioning) is found in some database products. It is this you are asking about, or DataStage parallel jobs?

What do you understand by the term "hashing"?

roy · Post by **roy** » Tue Aug 30, 2005 11:44 pm

Hi,
Seems I misunderstood and you need an Idea on partitioning of hash files in server jobs.
Are you refering to distributed hash files?