difference between parttion key and sorting key

GSSaru · Post by **GSSaru** » Fri Jul 28, 2006 2:21 am

Hi

can any body tell me ,what is difference between patitioning key and sorting key...

thanks
saru

pigpen · Post by **pigpen** » Fri Jul 28, 2006 2:31 am

Partition key is the columns used to disperse data in different location. Sorting key is the columns used for sorting order.

loveojha2 · Post by **loveojha2** » Fri Jul 28, 2006 2:32 am

can any body tell me ,what is difference between patitioning key and sorting key...

Where, which stage?

kumar_s · Post by **kumar_s** » Fri Jul 28, 2006 2:43 am

Do you want to know what is the difference between partition and sort?
Patitioning key and sorting key can be explained by its name.
Many freshers assume that, by performing partition it does sorting as well.
Its not true.
The key based on which the records are distributed to the available nods are Patitioning key.
In most cases, you may end up in partition based on the sorting key specifed in the Sort stage or other stages.