Hey, First UNION, then SORT.
Sincerely, Marek M. ________________________________________ From: Walter Chang [[email protected]] Sent: Monday, October 03, 2011 10:22 AM To: [email protected] Cc: [email protected] Subject: pig commands help Hi , assuming i have table with the following sample (two column separated by space): a 1,2,3 b 4,5,6 I would like to covert it to a 1 a 2 a 3 b 4 b 5 b 6 basically split the second column and use the elements to generate separate rows but keep the first column intact. What's the best way i should achieve this ? Thanks, Weide
