DSXchange

Hi Friends,

i have two files
f1 have cust_id,Tran_id,sales_amount

f2 have cust_id,cust_name

i want o/p like cust_name, Total_sales_amount

I want only top 5 Total_sales_amount customers.


how can do this?

Join the two, sort the result by the amount descending and constrain the output to the first five records. Note you'll need to run sequentially or on one node for this to work properly.

if it run in 2node or 4node how will get top 5 sums

In the sort stage you need to perform a hash partioning properly

You'll get the Top 5 sums per node unless you throttle things down to sequential execution, hence my suggestion.

which key i want to hash partition.

The answer lies in this statement

Devendrudu wrote: I want only top 5 Total_sales_amount customers.