[PIG-1048] inner join using 'skewed' produces multiple rows for keys with single row in both input relations

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.6.0
• Assignee: Sriranjan Manjunath
• Reporter: Thejas Nair
• Created: 23/Oct/09 01:12
• Updated: 24/Mar/10 22:15
• Resolved: 30/Oct/09 22:49

Description

${code}
grunt> cat students.txt
asdfxc M 23 12.44
qwer F 21 14.44
uhsdf M 34 12.11
zxldf M 21 12.56
qwer F 23 145.5
oiue M 54 23.33

l1 = load 'students.txt';
l2 = load 'students.txt';
j = join l1 by $0, l2 by $0 ;
store j into 'tmp.txt'

grunt> cat tmp.txt
oiue M 54 23.33 oiue M 54 23.33
oiue M 54 23.33 oiue M 54 23.33
qwer F 21 14.44 qwer F 21 14.44
qwer F 21 14.44 qwer F 23 145.5
qwer F 23 145.5 qwer F 21 14.44
qwer F 23 145.5 qwer F 23 145.5
uhsdf M 34 12.11 uhsdf M 34 12.11
uhsdf M 34 12.11 uhsdf M 34 12.11
zxldf M 21 12.56 zxldf M 21 12.56
zxldf M 21 12.56 zxldf M 21 12.56
asdfxc M 23 12.44 asdfxc M 23 12.44
asdfxc M 23 12.44 asdfxc M 23 12.44$

${code}