Sorting, Partitoning

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
just4u_sharath
Premium Member
Premium Member
Posts: 236
Joined: Sun Apr 01, 2007 7:41 am
Location: Michigan

Sorting, Partitoning

Post by just4u_sharath »

If the job is flowing with hash partition, and in between if i insert a sort, will the hash partition will flow to the output stage of sort.
Does the sort stage retains the partition done before. Or else i have to partition again after a sort stage.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Your sort stage lets you choose how to handle partitioning - by default it will not repartition so you don't need to repartition after the sort.
Raghavendra
Participant
Posts: 147
Joined: Sat Apr 30, 2005 1:23 am
Location: Bangalore,India

Post by Raghavendra »

I will prefer to set the partition to same in the sort stage for this scenario.
Raghavendra
Dare to dream and care to achieve ...
Nripendra Chand
Premium Member
Premium Member
Posts: 196
Joined: Tue Nov 23, 2004 11:50 pm
Location: Sydney (Australia)

Post by Nripendra Chand »

same partitioning should be used if hash keys and sort keys are same.
-Nripendra Chand
Post Reply