Page 1 of 1
Need idea on Hash Partitioning In Server Jobs
Posted: Sun Aug 28, 2005 10:17 pm
by sasi_kumarreddy
Give me an idea on Hash partition with an example :D :D
Posted: Mon Aug 29, 2005 12:49 am
by ray.wurlod
Please post on the appropriate forum, and supply a context for your question. Or do a search, either here or on Google, etc.
Posted: Tue Aug 30, 2005 4:20 am
by roy
Hi,
Can you please give more details?
(I assume you ment parallel job is this so?)
Posted: Tue Aug 30, 2005 10:07 am
by kumar_s
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
Posted: Tue Aug 30, 2005 4:08 pm
by ray.wurlod
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"?
Posted: Tue Aug 30, 2005 11:44 pm
by roy
Hi,
Seems I misunderstood and you need an Idea on partitioning of hash files in server jobs.
Are you refering to distributed hash files?