Hi All,
I 've the data in following way
field 5 is time difference in seconds.
I've sorted and hash partioned the output with fields 2,3,4,5 and would be as below
x1, a,b,c, 10
x2, a,b,c,10
x3, a,b,c,30
x4, a,b,c,40
x5, a1,b1,c1,5
x6,a1,b1,c1,10
x6,a1,b1,c1,15
From the above output I need get the following records with minimum time time difference and key fields being 2,3,4.
x1, a,b,c, 10
x5, a1,b1,c1,5
How do I acheive this? Any thoughts greatly appreciated.
Thanks in advance.
In the Sort output I need get record with minimum time diff
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
Re: In the Sort output I need get record with minimum time
Remove duplicate stage, duplicate to retain = first
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore