RE: A question on joins

2013-06-19 Thread Sameer Tilak
ialized 2013-06-19 07:57:04,602 [main] INFO org.apache.hadoop.mapreduce.lib.input.FileInputFormat - Total input paths to process : 1 2013-06-19 07:57:04,602 [main] INFO org.apache.pig.backend.hadoop.executionengine.util.MapRedUtil - Total input paths to process : 1 > From: ssti...@live.com > To: user@pig.apache.org &

Re: A question on joins

2013-06-19 Thread Barclay Dunn
it turns out that "output" is a reserved word in Pig. if you change your alias to "thingy" your script will work. Barclay Dunn On 6/19/13 3:10 AM, Sameer Tilak wrote: Dear Pig users, I am trying to do simple joins by following an example on a Blog. Your help will be great. UserDetails.txt

A question on joins

2013-06-19 Thread Sameer Tilak
Dear Pig users, I am trying to do simple joins by following an example on a Blog. Your help will be great. UserDetails.txt 123456, Jim 456123, Tom 789123, Harry 789456, Richa DeliveryDetails.txt 123456, 001 456123, 002 789123, 003 789456, 004 DeliveryStatusCodes.txt 001, Delivered 002, Pending