Can we sort the data with two key columns.

G SHIVARANJANI · Post by **G SHIVARANJANI** » Wed Jul 11, 2007 12:32 am

Hi,

Cans we sort or join the data taking two columns as key columns in Join stage and sort stage.

if yes what should be the property set.

thanks,

Maveric · Post by **Maveric** » Wed Jul 11, 2007 12:44 am

Yes. You will have to specify two join keys i.e give two "Key" properties and specify the two field names. Similarly for Sort. Specify both the keys in the "Key" property. Note that the key order specified in sort and join should be the same or you might get a warning.

mansoor_nb · Post by **mansoor_nb** » Wed Jul 11, 2007 12:48 am

yes you can sort or join the data using two columns. If the data to be joined between the two links then it should be hashed and sorted on the key columns and then the join should be made on the key columns and the partition type should be SAME.

kumar_j · Post by **kumar_j** » Wed Jul 11, 2007 4:33 am

U can

ray.wurlod · Post by **ray.wurlod** » Wed Jul 11, 2007 9:53 am

... but does U want to?