The following tutorial is about Apache Pig. This is a beginners tutorial which came as a part of self learning.
# Prequisite on Ubuntu:
1. hadoop-1.0.3
2. pig-0.12.0
3. DataSet: Sample youtube dataset (http://netsg.cs.sfu.ca/youtubedata/)
From https://pig.apache.org/:
“Apache Pig is a platform for analyzing large data sets that consists of a high-level language for expressing data analysis programs, coupled with infrastructure for evaluating these programs. The salient property of Pig programs is that their structure is amenable to substantial parallelization, which in turns enables them to handle very large data sets.”
1. Modes in Apache Pig:
a. Local Mode
– Require single machine;
– To start in local mode you need to specify -x flag (pig -x local).
– Suitable for learning and testing small dataset.
b. MapReduce Mode
– Default Mode (Not required to specify pig -x mapreduce)
– Require access to a Hadoop cluster and HDFS installation.
# Start the Pig in local mode:
hduser@localhost:~$ pig -x local
#Loading dataset into Pig:
grunt> youTube = LOAD ‘/home/hduser/pig_data/utube_mod1.csv’ USING PigStorage(‘,’) as (video_id,uploader,age,category,length,views,rate,ratings,comments);
Here, above the ‘youTube’ is a relation. The ‘PigStorage’ is one of the Load/Store utility. It parses input records based on a delimiter and the fields thereafter can be referenced positionally or via alias.
#describe: describe operator returns the schema for the above relation.
grunt> describe youTube;
youTube: {video_id: bytearray,uploader: bytearray,age: bytearray,category: bytearray,length: bytearray,views: bytearray,rate: bytearray,ratings: bytearray,comments: bytearray}
#dump: dump operator to run (execute) Pig Latin statements interactively and display the results to your screen. Generally dump operator is used for debugging purpose.
grunt> DUMP youTube;
2014-02-19 15:18:45,550 [main] INFO org.apache.pig.tools.pigstats.ScriptState - Pig features used in the script: UNKNOWN
2014-02-19 15:18:45,718 [main] INFO org.apache.pig.newplan.logical.optimizer.LogicalPlanOptimizer - {RULES_ENABLED=[AddForEach, ColumnMapKeyPrune, DuplicateForEachColumnRewrite, GroupByConstParallelSetter, ImplicitSplitInserter, LimitOptimizer, LoadTypeCastInserter, MergeFilter, MergeForEach, NewPartitionFilterOptimizer, PartitionFilterOptimizer, PushDownForEachFlatten, PushUpFilter, SplitFilter, StreamTypeCastInserter], RULES_DISABLED=[FilterLogicExpressionSimplifier]}
2014-02-19 15:18:46,091 [main] INFO org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MRCompiler - File concatenation threshold: 100 optimistic? false
2014-02-19 15:18:46,241 [main] INFO org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MultiQueryOptimizer - MR plan size before optimization: 1
2014-02-19 15:18:46,243 [main] INFO org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MultiQueryOptimizer - MR plan size after optimization: 1
2014-02-19 15:18:46,422 [main] INFO org.apache.pig.tools.pigstats.ScriptState - Pig script settings are added to the job
2014-02-19 15:18:46,567 [main] INFO org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.JobControlCompiler - mapred.job.reduce.markreset.buffer.percent is not set, set to default 0.3
2014-02-19 15:18:46,683 [main] INFO org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.JobControlCompiler - Setting up single store job
2014-02-19 15:18:46,691 [main] INFO org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.JobControlCompiler - Map only job, skipping reducer estimation
2014-02-19 15:18:46,819 [main] INFO org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MapReduceLauncher - 1 map-reduce job(s) waiting for submission.
........................
........................
2014-02-19 15:18:51,518 [Thread-4] INFO org.apache.hadoop.mapred.Task - Task 'attempt_local_0001_m_000000_0' done.
2014-02-19 15:18:51,953 [main] WARN org.apache.pig.tools.pigstats.PigStatsUtil - Failed to get RunningJob for job job_local_0001
2014-02-19 15:18:51,974 [main] INFO org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MapReduceLauncher - 100% complete
2014-02-19 15:18:51,974 [main] INFO org.apache.pig.tools.pigstats.SimplePigStats - Detected Local mode. Stats reported below may be incomplete
2014-02-19 15:18:52,002 [main] INFO org.apache.pig.tools.pigstats.SimplePigStats - Script Statistics:
HadoopVersion PigVersion UserId StartedAt FinishedAt Features
1.0.3 0.12.0 hduser 2014-02-19 15:18:46 2014-02-19 15:18:51 UNKNOWN
Success!
Job Stats (time in seconds):
JobId Alias Feature Outputs
job_local_0001 youTube MAP_ONLY file:/tmp/temp950919397/tmp-2040316079,
Input(s):
Successfully read records from: "/home/hduser/pig_data/utube_mod1.csv"
Output(s):
Successfully stored records in: "file:/tmp/temp950919397/tmp-2040316079"
Job DAG:
job_local_0001
2014-02-19 15:18:52,029 [main] INFO org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MapReduceLauncher - Success!
2014-02-19 15:18:52,043 [main] WARN org.apache.pig.data.SchemaTupleBackend - SchemaTupleBackend has already been initialized
2014-02-19 15:18:52,059 [main] INFO org.apache.hadoop.mapreduce.lib.input.FileInputFormat - Total input paths to process : 1
2014-02-19 15:18:52,062 [main] INFO org.apache.pig.backend.hadoop.executionengine.util.MapRedUtil - Total input paths to process : 1
(D6frFp-VwHs,yetube,821,Entertainment,30,554455,3.54,2813,422)
(0Lg4i2C6zws,TNAwrestling,821,Sports,573,191461,4.46,217,111)
(UJpgxqYGws4,jrc0803,820,Sports,55,160852,4.09,486,423)
(BAPwg5nCKxE,milanoss,820,Film & Animation,578,170536,4.06,82,91)
(vVJ06ixj19Q,PimpimusPrime,820,Film & Animation,29,95950,4.61,134,185)
(UbhEunreGwQ,milanoss,820,Film & Animation,525,113422,4.06,48,44)
(sR2n3_fg-bY,koushibom,821,News & Politics,94,70136,3.79,38,36)
(ZB-MtI2sgP4,hotelcalifornians,820,Autos & Vehicles,77,77178,4.13,142,148)
(n-cLsNrL6W8,ganggeneral,820,Music,200,72386,3.55,279,279)
(KsL1F4HFxv0,deej240z,821,Entertainment,17,39270,4.51,41,60)
..........
# List the youtube videos having ‘rate’ greater than 3:
grunt> rate_more_than_three = FILTER youTube BY (float) rate>3.0;
2014-02-19 15:31:22,714 [main] WARN org.apache.pig.PigServer – Encountered Warning IMPLICIT_CAST_TO_DOUBLE 1 time(s).
grunt> DUMP rate_more_than_three;
grunt> DUMP rate_more_than_three; ................ (D6frFp-VwHs,yetube,821,Entertainment,30,554455,3.54,2813,422) (0Lg4i2C6zws,TNAwrestling,821,Sports,573,191461,4.46,217,111) (UJpgxqYGws4,jrc0803,820,Sports,55,160852,4.09,486,423) (BAPwg5nCKxE,milanoss,820,Film & Animation,578,170536,4.06,82,91) (vVJ06ixj19Q,PimpimusPrime,820,Film & Animation,29,95950,4.61,134,185) (UbhEunreGwQ,milanoss,820,Film & Animation,525,113422,4.06,48,44) (sR2n3_fg-bY,koushibom,821,News & Politics,94,70136,3.79,38,36) (ZB-MtI2sgP4,hotelcalifornians,820,Autos & Vehicles,77,77178,4.13,142,148) ..........................
#Storing output to file:
grunt> store rate_more_than_three into '/home/hduser/rate_more_than_three'; .............. Success! Job Stats (time in seconds): JobId Alias Feature Outputs job_local_0003 rate_more_than_three,youTube MAP_ONLY /home/hduser/rate_more_than_three, Input(s): Successfully read records from: "/home/hduser/pig_data/utube_mod1.csv" Output(s): Successfully stored records in: "/home/hduser/rate_more_than_three"
#Youtube video length >=500 AND <=1000
grunt> length_between_500_1000 = FILTER youTube by length >=500 AND length <=1000;
0Lg4i2C6zws,TNAwrestling,821,Sports,573,191461,4.46,217,111) (BAPwg5nCKxE,milanoss,820,Film & Animation,578,170536,4.06,82,91) (UbhEunreGwQ,milanoss,820,Film & Animation,525,113422,4.06,48,44) (V__TtNHKXLU,Orkunyk,821,Film & Animation,599,27399,4.87,104,31) (_IDfKKWBEZk,pundital,820,News & Politics,573,40935,4.76,155,215) (hOgvS9c5Kz0,Orkunyk,821,Film & Animation,535,20141,5,74,16) (doKkOSMaTk4,berkeleyguy0,821,News & Politics,585,20025,4.85,229,315) (H23vitezN2E,vinnicamara,821,Entertainment,542,19689,4.7,74,85) (fCDZnp4Pv4g,SoftAnime,820,Film & Animation,544,18110,4.44,50,30) (koI4vN8Qosw,vinnicamara,821,Entertainment,533,17071,4.77,62,31) (KY7MdPMyuhA,chriseliterbd,820,Entertainment,558,14845,4.99,130,27) (RoFq0Be-6q0,DiziTube,821,Entertainment,596,10532,4.96,142,16) (frvIaUVPN6I,TNAwrestling,820,Sports,894,123172,4.5,159,69)
#ILLUSTRATE: The ILLUSTRATE operator is used to examine how data is transformed through provided Pig Latin statements. ILLUSTRATE allows you to test your programs on small datasets and get faster turnaround times.
grunt> illustrate length_between_500_1000;
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | youTube | video_id:bytearray | uploader:bytearray | age:bytearray | category:bytearray | length:bytearray | views:bytearray | rate:bytearray | ratings:bytearray | comments:bytearray | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | M2aZoFm4RVI | brettkeane | 821 | People & Blogs | 693 | 951 | 4.07 | 183 | 75 | | | 53JV_3QR8f4 | itslate2 | 820 | Entertainment | 369 | 9549 | 4.85 | 130 | 111 | | | hxHjWYA50Ds | Politicstv | 819 | News & Politics | 1204 | 36725 | 4.99 | 290 | 133 | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | length_between_500_1000 | video_id:bytearray | uploader:bytearray | age:bytearray | category:bytearray | length:bytearray | views:bytearray | rate:bytearray | ratings:bytearray | comments:bytearray | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | M2aZoFm4RVI | brettkeane | 821 | People & Blogs | 693 | 951 | 4.07 | 183 | 75 | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
#GROUP BY:
grunt> grouped_by_category = group youTube by category;
grunt> dump grouped_by_category
( UNA ,{(O7pBhfJnoYw,oodashi,0, UNA ,276,69303,4.06,52,36)})
(Music,{(Cvu373qjj7A,NeedToBe2007,820,Music,304,14330,4,21,21),(i5QF8-JmVm8,TIinstoresjuly3rd,820,Music,307,27636,4.71,163,134),(HXCWXLvJumo,TheKlasix,820,Music,164,20410,4.69,13,25),(jdkyugXj9Pg,brandt4797,820,Music,200,31671,4.54,172,141),(EKXR3zmpnvY,TIvsTIP,821,Music,32,11827,4.82,11,15),(gbDD5HLwifY,myhumpsfergie123456,819,Music,304,384435,3.6,1227,962),(pZnWxzFMCHg,AvrilLavigneSucks,819,Music,304,226893,4.51,579,465),(b2N27e79EdY,VeGaS1004,821,Music,564,7348,4.71,35,119),(uZtjiITa8FE,AllHipHopcom,820,Music,191,55069,3.34,119,127),(NnSk9zv6M6w,BuyCurtisJune26th,819,Music,189,88931,4.06,272,374),(lyfkVooQnmo,alanyukfoo,820,Music,197,11571,5,21,12),(h8y1qL_HLQE,Tam1r,820,Music,201,122334,4.68,344,324),(SKovbXL7xSI,edenmaze,821,Music,265,207,4.32,19,79),(T_SDHfswB30,davidchoimusic,821,Music,139,2694,4.77,192,105),(n-cLsNrL6W8,ganggeneral,820,Music,200,72386,3.55,279,279),(amH3qAu9RA4,blink182this,820,Music,135,17376,4.74,115,179),(X0E6Sf2vOwI,toprank144,821,Music,249,649,4.89,112,8),(oIfEw4e-0Yg,sleepingbeautywood,820,Music,223,57706,4.68,579,359),(IBM8VOpC6Mg,Brookers,820,Music,140,17018,4.31,548,348),(_7KUs1TBkCc,hollywoodrecords,820,Music,199,28640,4.55,65,31),(Gp8WFljRHsQ,ysabellabrave,821,Music,223,17005,4.58,697,344)})
(Comedy,{(RGc-F_0Y7tM,infrastructurdeep,820,Comedy,254,313693,4.38,1571,1626),(6l7P_dZQtac,jarts,820,Comedy,17,287000,4.67,466,304),(JqOeDW5wu_E,earthbrightfuture,819,Comedy,15,235198,3.59,343,572),(Ryeyee-4tw4,nalts,822,Comedy,316,222,4.66,148,133),(yDJAIT6Y5dI,correoyahoo,821,Comedy,34,33895,3.93,44,34),(Y69y0LSgMxk,mrpregnant,822,Comedy,183,1342,4.27,75,346),(8NPwJu42aUo,moonkeyz,819,Comedy,32,174327,1.99,1561,2243),(RzkEsSHOxQU,marcmaron101,820,Comedy,280,73232,4.52,607,101),(mY5qJHZCz2I,DraX360,818,Comedy,88,160177,4.79,358,174),(QBqkPAtKQN8,THANOS43,822,Comedy,246,681,4.62,8,81),(D3Lr70lwaVg,rawful,820,Comedy,25,13313,4.83,103,42),(AVnvjE9ixZs,potlot14,821,Comedy,583,1377,4.91,100,30),(HkRUHugg8vU,jrc0803,819,Comedy,107,131531,3.72,990,1148),(Y9NgXIkyiwk,AgentXPQ,822,Comedy,108,1802,4.73,139,95),(ZcTFgT3Ufw8,nalts,820,Comedy,229,14892,4.76,691,407),(H2XgxvuB2zY,brettkeane,822,Comedy,220,430,3.08,105,82),(bOYsI7f90R0,galipoka,821,Comedy,77,2389,4.54,161,160),(WFqqPK7kN0c,morbeck,821,Comedy,210,624,4.27,62,84),(lx9WAc29kHA,MasakoX,822,Comedy,251,3496,4.9,383,379),(Ub9JGlr9ok4,KnoxsKorner1,820,Comedy,379,1134,4.81,90,96),(2shafTX1KF8,TheRealParis,819,Comedy,135,19030,4.31,487,428),(cMKvJRRgAVY,MMASK,821,Comedy,110,566,4.94,100,6),(o7zDjdsOasg,brettkeane,821,Comedy,675,712,4.25,157,57),(5ml65ZRBVVc,selectscreen,821,Comedy,77,975,4.89,224,9),(P0TCzE4HTZQ,HappySlip,822,Comedy,150,8911,4.74,663,416),(Dni7fBgm_iA,swiftkaratechop,820,Comedy,170,1135,4.89,64,128),(rmeMGbJvu9E,JamesNintendoNerd,822,Comedy,54,6735,4.81,274,135),(Rl3rEL8AlbI,Brookers,820,Comedy,70,15119,4.05,465,347),(E22gUUTG2VI,MarkDayComedy,821,Comedy,246,6799,4.84,946,148),(N4yfFAIR9kc,beebee890,820,Comedy,22,8209,2.07,69,97),(jf8zyO8UrLc,khayav,821,Comedy,34,1121,4.63,87,115),(R1lyKwlvkns,freemovies125,820,Comedy,98,28624,4.54,82,20),(4kHKSZvJscE,lonelygirll15,822,Comedy,186,202,4.98,112,6),(i8K4WFTzjtE,potlot14,821,Comedy,474,1290,4.92,113,37),(0Cbzow5FsKQ,TheWoodcreekFaction,821,Comedy,106,1365,4.45,121,90),(XAs68-oHKhA,guywiththeglasses,821,Comedy,22,2518,4.56,151,145),(73om6gY8XSA,nogoodtv,820,Comedy,442,644674,2.55,793,311),(pZiQBoG8K8E,nalts,821,Comedy,210,56230,3.84,887,469)})
(Sports,{(UJpgxqYGws4,jrc0803,820,Sports,55,160852,4.09,486,423),(pzgEJh6stMA,NBA,821,Sports,118,34627,4.34,61,57),(dh7Xxxhhr_8,NBA,821,Sports,126,25750,4.56,62,53),(UoAXg2pOG5s,jukimol,820,Sports,230,9010,3.7,70,91),(kaAdnLOuoAY,europeansportservice,820,Sports,333,10301,4.8,25,13),(LBBPoyXEOhM,maxpower1453,821,Sports,54,8927,4.76,504,169),(0Lg4i2C6zws,TNAwrestling,821,Sports,573,191461,4.46,217,111),(s7ZMRZCW9Xc,HockeyPacific,820,Sports,44,49214,2.98,141,591),(BgtJwf4dK1A,empiricalred,815,Sports,600,27387,4.88,283,127),(foquonPZSN8,BgirL5,819,Sports,45,48810,3.23,183,1097),(frvIaUVPN6I,TNAwrestling,820,Sports,894,123172,4.5,159,69),(wWrEEKNjIAY,TNAwrestling,821,Sports,223,11547,4.54,59,42),(mjmbJm7idkI,NBA,821,Sports,24,21217,4.59,32,71),(CgLYZHN78Kk,ProductZero,820,Sports,17,73897,4.6,239,358),(yDbX8I202VU,medakaschool,820,Sports,74,529826,4.53,1347,1145)})
(Howto & DIY,{(0S1nAcs772s,hortononon,819,Howto & DIY,46,119519,1.72,756,617),(TWTyJOsMmio,pigslop,822,Howto & DIY,468,1010,0,0,171),(xGcNpfT2L0s,diethealth,820,Howto & DIY,221,115003,2.74,91,82),(80TAx2mCnNc,oodashi,818,Howto & DIY,481,68664,4.15,26,14),(05oT4ejpYGQ,FreePSP,820,Howto & DIY,36,3533,1.67,18,221),(2IAEu6GtDWM,mikeskehan,821,Howto & DIY,140,2858,3.01,142,473)})
(Entertainment,{(IEWBO8xZzpo,DiziTube,821,Entertainment,596,3953,4.94,87,9),(5OaFXetu46Q,NBC,821,Entertainment,266,2452,4.68,92,19),(Sc33LPbqdl8,R3NDI3R,821,Entertainment,337,1782,3.15,140,170),(o_sz0NvQfLc,jakedeherrera,821,Entertainment,111,1004,4.89,81,59),(UbD7MG_j_UI,warren25smash,822,Entertainment,178,2252,3.15,200,202),(ut-RQaJum1c,DoctorArzt,820,Entertainment,29,30109,4.95,38,47),(iXT2E9Ccc8A,kembrew,819,Entertainment,561,46150,4.88,329,143),(MHor7QwhLY0,leorai,821,Entertainment,40,25229,2.75,8,7),(JX7zrbrnaOI,NOWWUT,821,Entertainment,59,19791,3.31,32,69),(s7uXvqfQvNI,TygerClaw,821,Entertainment,152,39929,4.87,180,188),(kxvT_F8GYV4,DoctorArzt,820,Entertainment,29,18794,4.44,9,8),(_idZr95SEAM,lostpromos,820,Entertainment,30,20441,5,24,12),(FXZBLli0_sA,GayGod,820,Entertainment,205,28006,3.53,337,575),(fu_GNJwUnxM,DiziTube,821,Entertainment,393,15614,4.92,354,127),(sYv8vzKKDVs,GWrocks09,820,Entertainment,98,18912,4.87,63,125),(JNiGret7EW4,aat08,821,Entertainment,52,29449,2,50,52),(_Z1X9zpBe_A,DharmaSecrets,820,Entertainment,30,16757,4.81,16,12),(DHDCITa7RyA,GWrocks09,820,Entertainment,153,17171,4.36,36,140),(KsL1F4HFxv0,deej240z,821,Entertainment,17,39270,4.51,41,60),(TJolUxvL3sQ,chriseliterbd,820,Entertainment,369,18302,5,125,18),(tXinnBzRSzg,txvoodoo,820,Entertainment,22,13673,4.5,16,19),(A5d-7KFINqM,vinnicamara,821,Entertainment,459,19187,4.84,74,34),(yZDNwXle154,ootpmovievids,821,Entertainment,30,47213,4.81,58,29),(-4R-4Q7vppg,HockeyCrazyRrazy,820,Entertainment,156,13572,4.45,29,124),(eNQidcorW_g,chriseliterbd,820,Entertainment,424,18506,4.87,124,17),(DE2O9CtuU5o,sundancechannel,821,Entertainment,73,21788,4.41,73,124),(H23vitezN2E,vinnicamara,821,Entertainment,542,19689,4.7,74,85),(G3bz3ZVjcEU,TVGuy88,820,Entertainment,123,11920,3.55,31,185),(koI4vN8Qosw,vinnicamara,821,Entertainment,533,17071,4.77,62,31),(KY7MdPMyuhA,chriseliterbd,820,Entertainment,558,14845,4.99,130,27),(#NAME?,chriseliterbd,820,Entertainment,395,14772,5,118,20),(oJWaEPxfgW8,Danoramma,820,Entertainment,133,11404,3.97,32,152),(785FtaTTezo,daisytree1,821,Entertainment,64,24954,3.15,54,43),(RoFq0Be-6q0,DiziTube,821,Entertainment,596,10532,4.96,142,16),(MxR99EdoZmE,chriseliterbd,820,Entertainment,183,14263,4.97,86,13),(o57wrk4mKvM,DharmaSecrets,820,Entertainment,29,10448,4.6,10,34),(UaxZ63N0rRk,elfactorx,820,Entertainment,140,14235,4.79,14,16),(6J2mr5zKgsk,vinnicamara,821,Entertainment,422,10164,4.88,58,50),(tKKLUIOpvSE,CelebTV,820,Entertainment,45,197144,1.87,587,221),(bOfAPHJTagY,BANGOUTCLIQUECOM,819,Entertainment,17,164822,4.68,638,928),(kMg0gGaMe0Q,tibermedia,819,Entertainment,235,187497,4.73,402,323),(izk3aYS9FIA,truefaithisle,820,Entertainment,61,138296,4.31,552,490),(H85ZaC7utus,sierraforest,816,Entertainment,27,96953,4.44,39,29),(20M8Kf0wqZg,yummyum07,819,Entertainment,304,91578,4.1,224,134),(bWJshfx9bTw,blahinsider,819,Entertainment,138,88262,3.93,190,289),(HiHdJ426_2k,goaltaker1,820,Entertainment,236,84088,4.46,240,291),(eQUAAwNJtg0,YTwatchdog,820,Entertainment,162,2391,4.64,133,568),(D6frFp-VwHs,yetube,821,Entertainment,30,554455,3.54,2813,422),(UAJctmZaLgY,tibermedia,818,Entertainment,407,87416,4.6,113,100),(KuYiFwTsFiw,DiziTube,821,Entertainment,599,10153,4.91,232,15),(UoubyKe9Xa0,DiziTube,821,Entertainment,599,9466,4.96,213,54),(_h-DUe3o4j4,peron75,820,Entertainment,280,5721,4.8,228,192),(RJIxWE2qDsk,DiziTube,821,Entertainment,599,9032,4.96,201,21),(mEDsATTpgGk,DiziTube,821,Entertainment,598,8823,4.99,182,20),(IuGyQRdPP5c,DiziTube,821,Entertainment,594,10151,4.95,183,16),(ZOQU1YP4SsE,DiziTube,821,Entertainment,597,10008,4.92,180,14),(boSrjupyOlw,peron75,821,Entertainment,345,1836,4.87,159,85),(53JV_3QR8f4,itslate2,820,Entertainment,369,9549,4.85,130,111),(scm9nRm8tMY,DeltaDJ2006,821,Entertainment,79,260,5,120,0),(IXFjHlaz1J0,DiGiTiLsOuL,821,Entertainment,303,1937,4.84,128,119),(rlom5CERakI,chriseliterbd,820,Entertainment,272,11151,4.97,110,11),(GwtkWMZbQHk,hoiitsroi,821,Entertainment,192,5451,4.56,126,156),(IT1rSaGmUDQ,chriseliterbd,820,Entertainment,211,13355,4.96,103,28),(FMgKXKsZN90,WHATTHEBUCKSHOW,821,Entertainment,498,2571,4.78,110,99),(ShbEBBcvtBc,chriseliterbd,820,Entertainment,395,11941,4.91,101,7),(rayY8wvYD08,vinnicamara,821,Entertainment,584,9532,4.81,80,157)})
(People & Blogs,{(i18uFHYsUvo,brettkeane,820,People & Blogs,897,729,4.39,143,74),(icd4MgHPOno,brettkeane,821,People & Blogs,1141,827,4.28,149,72),(ZPoWU65NszY,billybigun64,821,People & Blogs,528,746,4.99,80,64),(#NAME?,nickynik,822,People & Blogs,394,397,4.84,186,102),(ZWFtVnqMFu8,Daxflame,821,People & Blogs,236,24769,3.44,882,1472),(caC_fGJT-SM,Blunty3000,821,People & Blogs,247,2664,3.97,152,143),(hEHMhMjlDek,ren4165,820,People & Blogs,183,410,4.56,9,86),(OHCcVlRsllc,smpfilms,821,People & Blogs,164,7430,4.29,219,342),(QW7pxFBBjaU,rickyste,820,People & Blogs,13,13375,4.59,403,620),(mkoh0eXnnf0,kicesie,821,People & Blogs,44,626,3.91,11,125),(C1vZzxyVhV8,Zipster08,821,People & Blogs,245,2072,4.64,163,132),(SD--8k_IsQo,SoldierInGodsArmy,821,People & Blogs,473,480,4.85,141,71),(NkqbDeuKXNk,goldengun85,821,People & Blogs,372,622,1.94,48,96),(#NAME?,blacktreemedia,821,People & Blogs,129,51705,4.62,99,173),(8TwvvOC8vdU,theboringdispatcher,821,People & Blogs,301,1201,4.28,68,80),(NUqEVO_C5ss,applemilk1988,820,People & Blogs,279,35025,4,430,823),(bp_TNrl8xc4,brettkeane,821,People & Blogs,364,464,4.49,99,37),(iaU9puwzMkE,hoiitsroi,821,People & Blogs,420,4726,4.72,127,230),(FiSddAJNIoc,brettkeane,821,People & Blogs,903,636,4.44,147,41),(P4im8gGPdGM,karpmax,821,People & Blogs,62,19973,4.18,11,15),(c5-TCNHSPkk,YourTubeNEWS,821,People & Blogs,341,687,3.11,114,77),(M2aZoFm4RVI,brettkeane,821,People & Blogs,693,951,4.07,183,75),(HAt8hmTNVbY,biostudentgirl,819,People & Blogs,160,124923,4.05,633,312),(O6_oXxTWHmo,mushcul,817,People & Blogs,83,52239,4.45,106,514),(CN-rHMWlB4w,soccerstar4ever,820,People & Blogs,192,45006,2.95,187,219),(c2wkbdBprDw,ashleytisdale,821,People & Blogs,44,24717,4.55,446,434),(6P1IR84LwI4,hydroax,820,People & Blogs,15,18533,1.8,5,4),(CySrshUMwIw,blacktreemedia,821,People & Blogs,242,78879,4.08,216,349),(IvpaBrX52pM,MissMalena13,821,People & Blogs,177,1707,4.95,387,21),(hoVr6iIKj_c,communitychannel,822,People & Blogs,206,7771,4.78,362,327),(7mMw9TdZLxI,khriskhaos2,821,People & Blogs,0,1043,0,0,114),(ilt0rxr5gQk,dramatubearchive,820,People & Blogs,110,3617,3.64,45,812),(T9FJIYBWdTQ,zakgeorge21,822,People & Blogs,638,590,4.75,83,107),(Gs87lI02tek,renetto,820,People & Blogs,646,8516,4.36,448,650),(TCMpVv87g6E,TheAmazingAtheist,821,People & Blogs,913,2805,3.79,486,168),(ezgk4QXwIhY,xgobobeanx,821,People & Blogs,112,1075,4.61,88,95),(E2YTdBsEnro,spricket24,821,People & Blogs,578,3676,4.59,261,228)})
(Pets & Animals,{(T7NpsCWvjzg,HellionExciter,821,Pets & Animals,289,1670,4.21,103,128),(s2ymS4fmjGQ,Padovarulezcom,821,Pets & Animals,88,10925,0,0,0)})
(Gadgets & Games,{(tOF8-Z7yQ_U,joystiq,820,Gadgets & Games,88,10991,4.47,30,25),(jDdtzpmVb1U,UrinatingTree,821,Gadgets & Games,424,1764,4.75,89,0),(s8hRgb0WTt4,ostekakepstsnet,821,Gadgets & Games,415,1135,4.84,108,39),(w867ePtiaZI,UrinatingTree,821,Gadgets & Games,546,1669,4.79,95,93),(xTkLDGtu36Q,Marriland,821,Gadgets & Games,348,2214,4.93,70,131),(Wq3laSZAT7U,spritefan2,821,Gadgets & Games,180,800,4.64,44,98),(R07C3wfft_4,HotPinkMidNite,820,Gadgets & Games,104,1278,4.92,84,83)})
(News & Politics,{(3UrumrPlFiU,cpotato2004,815,News & Politics,605,2931,3.98,62,409),(sR2n3_fg-bY,koushibom,821,News & Politics,94,70136,3.79,38,36),(xcQQ05XtAQ4,RonPaul2008dotcom,821,News & Politics,295,47309,4.89,1263,736),(CY86R1qjgDc,CBS,821,News & Politics,123,61187,3.8,122,12),(shoyObDet4Q,lbracci,820,News & Politics,1529,24533,4.24,38,67),(_IDfKKWBEZk,pundital,820,News & Politics,573,40935,4.76,155,215),(rF3NtEWj6ws,VoteRonPaul08,820,News & Politics,363,24460,4.9,343,292),(R0HEKTr6wrc,tpmtv,821,News & Politics,67,27474,4.61,84,90),(j_qUvgfzuPM,bgcaplay,820,News & Politics,312,14986,2.57,177,78),(ceIXPrfuGxg,puratrampa,820,News & Politics,110,16138,2.29,7,7),(doKkOSMaTk4,berkeleyguy0,821,News & Politics,585,20025,4.85,229,315),(T_VC8iH7lXQ,serkanserkanserkannn,821,News & Politics,40,13052,3.4,5,2),(YPbr5L4ByfE,koushibom,821,News & Politics,415,15045,3.33,3,11),(3FV7XU-TLMU,hillaryclintondotcom,820,News & Politics,53,277309,2.8,2038,50),(vJRDZE5xW2Y,ecogeeky,816,News & Politics,114,169722,4.71,17,15),(YkAPaEMwyKU,TRUEADONIS,819,News & Politics,292,166576,4.76,1423,1368),(Sy4Eugc0Xls,karlspackler,820,News & Politics,363,87170,4.89,1723,1408),(J8oO_OD3PtI,pumaman1,820,News & Politics,472,7942,4.86,326,177),(D6SfmXigHpE,suntereo,821,News & Politics,601,19941,4.87,285,284),(MvID-e_irz4,warren25smash,821,News & Politics,314,1743,4.52,220,166),(PvrrPCkHKLw,aravoth,821,News & Politics,237,8010,4.93,136,60),(LMO3Cg0frB8,brettkeane,821,News & Politics,808,474,4.2,117,47),(Q5VeaUW12pY,MiddleClassified,820,News & Politics,476,14571,4.98,412,179),(hxHjWYA50Ds,Politicstv,819,News & Politics,1204,36725,4.99,290,133),(DTHOgoGBUkw,michellemalkin,821,News & Politics,302,4655,4.14,74,187),(Y_r8mMCsSHA,onedeaddj,821,News & Politics,312,3663,1.79,136,177),(Yj1wext0CQc,ResurrectionOfCG,821,News & Politics,391,370,3.88,43,94),(AF_frpUoMIg,thereaganite84,820,News & Politics,31,289,5,10,85),(xP_2M5DDAuM,joshallem,820,News & Politics,583,495,0,0,83),(sk334TbliaY,GalacticCabaret,819,News & Politics,169,10138,4.91,141,645),(Hc1ohELwjWo,lzpoint1944,819,News & Politics,60,23672,2.85,177,463),(KNz0pta4PVU,VoteRonPaul08,819,News & Politics,301,24500,4.81,270,435)})
(Travel & Places,{(vPtsS4UTuis,sxephil,821,Travel & Places,260,12642,4.02,119,86)})
(Autos & Vehicles,{(ZB-MtI2sgP4,hotelcalifornians,820,Autos & Vehicles,77,77178,4.13,142,148),(DjPfzKbYDXw,lampesuda,818,Autos & Vehicles,48,83313,4.31,77,117),(9OLYrVcjmzM,casperjello,820,Autos & Vehicles,2,21754,4,37,25),(po15iWrv9zs,tellible,820,Autos & Vehicles,141,30703,4.17,100,621),(c0QQ3mqJEIk,jufanet,820,Autos & Vehicles,156,38698,3.66,110,485),(9GCUEamZRSs,casperjello,820,Autos & Vehicles,2,16866,4.11,27,23),(rCvifZybyLg,autoknipsfix,821,Autos & Vehicles,91,36347,4.2,84,82)})
(Film & Animation,{(#NAME?,ChappiRukia,821,Film & Animation,232,1487,4.87,163,96),(nlWOu9FHm-I,truefaithisle,820,Film & Animation,250,212185,4.62,1154,1713),(QdTZQkfkG0Q,animeswordns14s1,821,Film & Animation,252,18277,4.87,94,13),(fCDZnp4Pv4g,SoftAnime,820,Film & Animation,544,18110,4.44,50,30),(v74fPO89L0U,Orkunyk,821,Film & Animation,398,12588,4.93,55,12),(QsLKiPX9Kn4,Orkunyk,821,Film & Animation,389,13732,4.84,74,12),(6vzQ7fCTqzU,Orkunyk,821,Film & Animation,406,13990,4.92,49,8),(N0p17EQaUsA,Orkunyk,821,Film & Animation,457,20447,4.93,68,12),(QSeKvw7KnN4,Orkunyk,821,Film & Animation,159,14780,4.79,80,52),(vVJ06ixj19Q,PimpimusPrime,820,Film & Animation,29,95950,4.61,134,185),(D2FXCczEYCI,Orkunyk,821,Film & Animation,398,21848,4.91,66,16),(wBbQKSvQ5h4,Orkunyk,821,Film & Animation,380,16006,4.98,61,7),(_S2ODLHD_xk,Orkunyk,821,Film & Animation,359,22643,4.97,68,10),(BAPwg5nCKxE,milanoss,820,Film & Animation,578,170536,4.06,82,91),(MYSuY2UIj9U,Orkunyk,821,Film & Animation,419,16339,4.92,64,6),(CndugLgU02U,Orkunyk,821,Film & Animation,447,24484,4.85,86,14),(8OkkJEt52HM,bountyTR,821,Film & Animation,26,19644,4.86,7,13),(hOgvS9c5Kz0,Orkunyk,821,Film & Animation,535,20141,5,74,16),(V__TtNHKXLU,Orkunyk,821,Film & Animation,599,27399,4.87,104,31),(S84s5OQIKg8,macpulenta,819,Film & Animation,235,24248,4.89,432,164),(UbhEunreGwQ,milanoss,820,Film & Animation,525,113422,4.06,48,44),(XKwaYhOnwRg,cankiriklari,821,Film & Animation,600,4427,4.96,80,14),(UWLYfu04-RM,OneMJDN,821,Film & Animation,600,479,4.94,90,33),(Iy3MkWs1-PI,Samsunlu1,820,Film & Animation,618,4947,4.95,91,13),(PNQwOuTpgLM,Samsunlu1,820,Film & Animation,617,4005,4.9,97,11),(TIs5FiOG2ho,Samsunlu1,820,Film & Animation,615,4551,4.91,104,7)})
grunt>
amp_stack 