gistfile1.txt

goal is (text,id,user.screen_name)

REGISTER '/Users/nkodner/Downloads/cdh3/elephant-bird/build/elephant-bird-2.2.4-SNAPSHOT.jar';
REGISTER '/Users/nkodner/Downloads/cdh3/pig-0.8.1-cdh3u4/contrib/piggybank/java/lib/json-simple-1.1.jar';
REGISTER '/Users/nkodner/Downloads/cdh3/pig-0.8.1-cdh3u4/build/ivy/lib/Pig/guava-r06.jar';
raw = LOAD '/Users/nkodner/tweetsxxxxxx' using com.twitter.elephantbird.pig.load.JsonLoader();
lmtd = limit raw 100;                                                                                    
cc = foreach lmtd generate (chararray)$0#'text' as text,(long)$0#'id' as id,com.twitter.elephantbird.pig.piggybank.JsonStringToMap($0#'user') as user; 
dd = foreach cc generate text,id,user#'screen_name' as name:chararray;

dump dd;

...

(@_paolacisneros jujuju ?,190494621871243265,JR_petro)
(@sauli24 im at work. Sorry,190494911064313858,ramoniee)
(@Artiee_x looool trust mee!,190494911030763521,SemsColeWorld)
(@Katriin_Styles SUPER !!!!!,190494621598617600,Official1DEst)
(@MoraLove09 lmfao u stupid!,190494621925785602,reshae_thediva)
(@one_name_ eu to zuando KKK,190494185365835776,GiihMS)
(@xLiiKEABOSSx @agedouma1 xd,190494911076896768,Tieboow)
(que lindo faltar al colegio,190495196545417216,NATIBRISKI)
(wat my breath smell like???,190494185470705665,iam_mr_wrong32)
(#Touro Palavra do dia: TEMPO,190495200643268608,Ofuxico_New)
(@edwinboy444 hihix das waar$,190494185386815488,xxxdaniii)
(I can't take this anymore?,190494621921583104,MurasakiPau)
(s? uma coisa pra ti "MORRE",190494911219511296,pqsamy)
(@hzm_official ?????,190494185407778817,surudokunarukun)
(@romigutierrezda me too . ?,190494621745426432,sergioponceve)
(@shauna__nicole yesss! ?,190494185370038272,kayferth)
(The Wanted - Glad You Came :),190494621925785601,1D_AreMyWorld_)
(Boooouh, il fait moche dehors.,190494621816729601,whoAmandine_)
(I miss @NickJonas so much. :-(,190494621959323648,ThePromQueen_)