Page 1 of 1
difference between parttion key and sorting key
Posted: Fri Jul 28, 2006 2:21 am
by GSSaru
Hi
can any body tell me ,what is difference between patitioning key and sorting key...
thanks
saru
Posted: Fri Jul 28, 2006 2:31 am
by pigpen
Partition key is the columns used to disperse data in different location. Sorting key is the columns used for sorting order.
Posted: Fri Jul 28, 2006 2:32 am
by loveojha2
can any body tell me ,what is difference between patitioning key and sorting key...
Where, which stage?
Posted: Fri Jul 28, 2006 2:43 am
by kumar_s
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.