hive (wmf)> select wiki_db, min(count), max(count), avg(count) from (select wiki_db, event_date, count(1) as count from (select wiki_db, substr(event_timestamp, 1, 8) as event_date from mediawiki_history where snapshot='2017 -04' and cast(substr(event_timestamp, 1, 8) as int) > 20170000) x group by wiki_db, event_date) y group by wiki_db; Query ID = ebernhardson_20170504212525_47844c90-642f-451c-89b9-09b41f9fb5a3 Total jobs = 1 Launching Job 1 out of 1 Number of reduce tasks not specified. Estimated from input data size: 718 In order to change the average load for a reducer (in bytes): set hive.exec.reducers.bytes.per.reducer= In order to limit the maximum number of reducers: set hive.exec.reducers.max= In order to set a constant number of reducers: set mapreduce.job.reduces= Starting Job = job_1492691387549_49519, Tracking URL = http://analytics1001.eqiad.wmnet:8088/proxy/application_1492691387549_49519/ Kill Command = /usr/lib/hadoop/bin/hadoop job -kill job_1492691387549_49519 Hadoop job information for Stage-1: number of mappers: 591; number of reducers: 718 2017-05-04 21:25:49,824 Stage-1 map = 0%, reduce = 0% 2017-05-04 21:26:03,807 Stage-1 map = 1%, reduce = 0%, Cumulative CPU 32.92 sec 2017-05-04 21:26:05,041 Stage-1 map = 6%, reduce = 0%, Cumulative CPU 398.16 sec 2017-05-04 21:26:06,145 Stage-1 map = 10%, reduce = 0%, Cumulative CPU 727.38 sec 2017-05-04 21:26:07,268 Stage-1 map = 15%, reduce = 0%, Cumulative CPU 1055.2 sec 2017-05-04 21:26:08,356 Stage-1 map = 20%, reduce = 0%, Cumulative CPU 1622.83 sec 2017-05-04 21:26:09,444 Stage-1 map = 25%, reduce = 0%, Cumulative CPU 2058.57 sec 2017-05-04 21:26:10,568 Stage-1 map = 30%, reduce = 0%, Cumulative CPU 2423.34 sec 2017-05-04 21:26:11,634 Stage-1 map = 34%, reduce = 0%, Cumulative CPU 2820.52 sec 2017-05-04 21:26:12,730 Stage-1 map = 39%, reduce = 0%, Cumulative CPU 3282.15 sec 2017-05-04 21:26:13,799 Stage-1 map = 45%, reduce = 0%, Cumulative CPU 3791.67 sec 2017-05-04 21:26:14,897 Stage-1 map = 50%, reduce = 0%, Cumulative CPU 4206.87 sec 2017-05-04 21:26:15,994 Stage-1 map = 56%, reduce = 0%, Cumulative CPU 4702.1 sec 2017-05-04 21:26:17,059 Stage-1 map = 62%, reduce = 0%, Cumulative CPU 5204.33 sec 2017-05-04 21:26:18,158 Stage-1 map = 70%, reduce = 0%, Cumulative CPU 5897.32 sec 2017-05-04 21:26:19,226 Stage-1 map = 77%, reduce = 0%, Cumulative CPU 6424.83 sec 2017-05-04 21:26:20,288 Stage-1 map = 80%, reduce = 0%, Cumulative CPU 6730.05 sec 2017-05-04 21:26:21,350 Stage-1 map = 84%, reduce = 0%, Cumulative CPU 7110.39 sec 2017-05-04 21:26:22,424 Stage-1 map = 89%, reduce = 0%, Cumulative CPU 7597.19 sec 2017-05-04 21:26:23,494 Stage-1 map = 92%, reduce = 0%, Cumulative CPU 7905.86 sec 2017-05-04 21:26:24,571 Stage-1 map = 96%, reduce = 0%, Cumulative CPU 8187.11 sec 2017-05-04 21:26:25,634 Stage-1 map = 97%, reduce = 1%, Cumulative CPU 8312.31 sec 2017-05-04 21:26:26,692 Stage-1 map = 97%, reduce = 3%, Cumulative CPU 8403.97 sec 2017-05-04 21:26:27,751 Stage-1 map = 98%, reduce = 5%, Cumulative CPU 8511.13 sec 2017-05-04 21:26:28,814 Stage-1 map = 98%, reduce = 7%, Cumulative CPU 8598.83 sec 2017-05-04 21:26:29,876 Stage-1 map = 99%, reduce = 8%, Cumulative CPU 8715.59 sec 2017-05-04 21:26:30,944 Stage-1 map = 99%, reduce = 10%, Cumulative CPU 8813.17 sec 2017-05-04 21:26:32,009 Stage-1 map = 99%, reduce = 11%, Cumulative CPU 8856.93 sec 2017-05-04 21:26:33,070 Stage-1 map = 99%, reduce = 12%, Cumulative CPU 8908.5 sec 2017-05-04 21:26:34,129 Stage-1 map = 100%, reduce = 13%, Cumulative CPU 8966.14 sec 2017-05-04 21:26:35,212 Stage-1 map = 100%, reduce = 16%, Cumulative CPU 9034.63 sec 2017-05-04 21:26:36,288 Stage-1 map = 100%, reduce = 31%, Cumulative CPU 9381.3 sec 2017-05-04 21:26:37,348 Stage-1 map = 100%, reduce = 44%, Cumulative CPU 9741.49 sec 2017-05-04 21:26:38,421 Stage-1 map = 100%, reduce = 56%, Cumulative CPU 10189.08 sec 2017-05-04 21:26:41,625 Stage-1 map = 100%, reduce = 57%, Cumulative CPU 10204.17 sec 2017-05-04 21:26:43,789 Stage-1 map = 100%, reduce = 59%, Cumulative CPU 10252.06 sec 2017-05-04 21:26:44,874 Stage-1 map = 100%, reduce = 64%, Cumulative CPU 10381.93 sec 2017-05-04 21:26:45,937 Stage-1 map = 100%, reduce = 74%, Cumulative CPU 10652.41 sec 2017-05-04 21:26:47,003 Stage-1 map = 100%, reduce = 87%, Cumulative CPU 11008.65 sec 2017-05-04 21:26:48,060 Stage-1 map = 100%, reduce = 94%, Cumulative CPU 11206.41 sec 2017-05-04 21:26:49,117 Stage-1 map = 100%, reduce = 99%, Cumulative CPU 11348.44 sec 2017-05-04 21:26:51,232 Stage-1 map = 100%, reduce = 100%, Cumulative CPU 11359.73 sec MapReduce Total cumulative CPU time: 0 days 3 hours 9 minutes 19 seconds 730 msec Ended Job = job_1492691387549_49519 MapReduce Jobs Launched: Stage-Stage-1: Map: 591 Reduce: 718 Cumulative CPU: 11359.73 sec HDFS Read: 14605428617 HDFS Write: 24074 SUCCESS Total MapReduce CPU Time Spent: 0 days 3 hours 9 minutes 19 seconds 730 msec OK wiki_db _c1 _c2 _c3 dewikisource 1 1830 362.655737704918 stqwiki 1 130 5.798245614035087 uzwikiquote 1 11 1.962962962962963 bnwiki 64 12932 1889.1967213114754 brwikimedia 1 56 4.452830188679245 huwiktionary 5 2870 598.297520661157 frwikinews 1 1351 200.0655737704918 wowiktionary 1 1209 17.21276595744681 eswikibooks 10 528 125.50819672131148 nlwikibooks 1 281 38.59016393442623 tawikisource 1 1048 54.957264957264954 lgwiki 1 196 24.723214285714285 novwiki 1 216 5.26605504587156 fiwikisource 1 31 7.8 lbewiki 1 25 6.264957264957265 liwikibooks 1 9 1.5757575757575757 yiwiktionary 1 175 6.908333333333333 bswikinews 1 192 7.186046511627907 liwiktionary 1 683 114.25641025641026 kiwiki 1 10 2.3095238095238093 chwiki 1 30 4.189655172413793 mkwiktionary 1 3299 47.27272727272727 testwikidatawiki 1 3787 658.9090909090909 fiwikimedia 1 5 1.5208333333333333 kaawiki 1 93 5.683760683760684 orwiktionary 1 1273 34.609756097560975 pnbwiktionary 1 938 31.20689655172414 tgwikibooks 1 92 12.294117647058824 azwiktionary 1 22715 521.0983606557377 brwikiquote 1 6 1.8928571428571428 guwiki 2 1807 151.02459016393442 brwiktionary 1 439 89.29752066115702 ptwiktionary 3 24289 1042.483606557377 yowiki 1 70 10.809917355371901 cywikiquote 1 40 2.7142857142857144 donatewiki 1 70 10.764705882352942 skwikibooks 1 85 4.157894736842105 pawikibooks 1 83 4.205882352941177 dewikiversity 5 720 173.2622950819672 thwiktionary 3 70249 1914.2540983606557 tumwiki 1 11 2.0952380952380953 votewiki 2 102 32.75 guwiktionary 1 749 14.691176470588236 vowiktionary 1 17954 172.91304347826087 sawikisource 1 1376 110.95833333333333 fiwikiquote 4 430 58.91803278688525 mkwikimedia 1 4 1.2916666666666667 angwiktionary 1 1351 18.548076923076923 iowiktionary 2 41136 2257.0165289256197 nahwiki 1 602 69.22950819672131 skwikisource 1 8 2.1129032258064515 fawikisource 3 198 24.78688524590164 orwiki 7 395 95.97540983606558 pdcwiki 2 47 8.98360655737705 vepwiki 5 312 56.63636363636363 pamwiki 1 217 10.96694214876033 itwikiquote 61 659 251.49180327868854 foundationwiki 1 82 10.65979381443299 lawiktionary 1 14136 202.21311475409837 hrwikisource 1 129 5.378640776699029 vlswiki 2 113 18.852459016393443 itwikisource 1 8441 681.360655737705 hakwiki 1 252 24.785123966942148 astwiktionary 1 11500 149.46610169491527 arwiktionary 2 47475 465.4016393442623 knwikisource 1 262 65.71304347826087 zh_min_nanwiktionary 1 16307 204.1946902654867 plwiktionary 1 150839 5615.098360655737 zhwikisource 13 3431 614.7459016393443 kawiki 6 3025 788.655737704918 svwikivoyage 1 50 4.206896551724138 euwiki 4 21169 1753.450819672131 jawikiquote 1 85 6.934426229508197 wowiki 1 223 9.4070796460177 kowikinews 1 79 7.4375 tyvwiki 1 559 16.523364485981308 tywiki 1 92 3.4130434782608696 kkwikibooks 1 31 4.75 tawikiquote 1 63 4.277777777777778 cywikibooks 1 14 1.9375 shwiktionary 1 532 91.66666666666667 ptwikiversity 2 201 34.83606557377049 specieswiki 20 61375 4410.040983606557 simplewiktionary 4 14650 259.0327868852459 iewiki 1 93 10.991735537190083 fowiki 2 136 23.793388429752067 cywiki 2 12914 3323.6721311475408 ndswiki 7 235 66.92622950819673 trwikisource 1 81 14.289256198347108 hywiktionary 3 4607 737.8852459016393 fiwikibooks 1 468 33.1578947368421 kawiktionary 1 235 25.843478260869563 mrwiki 12 11457 510.26229508196724 cbk_zamwiki 1 30 5.176991150442478 kkwiktionary 1 4709 61.176991150442475 zawiki 1 25 3.2211538461538463 itwikibooks 5 121 42.90983606557377 mrwiktionary 1 856 16.397260273972602 ltwiki 4 1437 534.172131147541 svwikiversity 1 80 5.097560975609756 pmswiki 4 147 33.62809917355372 elwikivoyage 1 23 3.9504950495049505 mediawikiwiki 2821 17560 12545.483606557376 swwiki 3 520 103.65573770491804 enwikibooks 53 1777 523.7622950819672 huwikiquote 1 21 3.7094017094017095 myvwiki 2 1153 59.31147540983606 kvwiki 1 131 18.3781512605042 srwikiquote 1 12 1.921875 iawiki 13 1802 201.52459016393442 cuwiki 1 20 5.352941176470588 frwikiquote 8 188 47.5655737704918 nowikisource 1 149 8.345238095238095 lawikiquote 1 43 3.086206896551724 zhwikiquote 7 109 23.87704918032787 kshwiki 1 40 5.6722689075630255 mkwikibooks 1 8 1.775 euwiktionary 2 31229 874.175 jawikibooks 9 241 36.36065573770492 mnwiki 19 480 142.04098360655738 swwiktionary 1 125 20.823529411764707 bgwikisource 1 270 27.191011235955056 roa_rupwiktionary 1 925 15.3125 tawikibooks 1 20 2.761904761904762 dawikisource 1 101 20.261682242990656 pflwiki 1 101 5.212389380530974 viwiktionary 3 1355 202.18852459016392 srwikisource 1 81 12.0 lezwiki 1 271 51.557377049180324 zh_min_nanwiki 2 6154 1107.1065573770493 aywiki 1 125 17.283333333333335 jawiktionary 10 1127 308.0245901639344 frwikisource 4 6143 2684.6311475409834 sswiki 1 125 4.989473684210527 arcwiki 1 448 10.22689075630252 idwikisource 1 110 4.413461538461538 crhwiki 2 185 20.647540983606557 ptwikivoyage 1 138 26.93388429752066 bat_smgwiki 1 549 23.371900826446282 plwikinews 1 75 8.5 mtwiktionary 1 767 20.47422680412371 lijwiki 1 194 13.892561983471074 nlwiktionary 1 52400 3141.901639344262 rswikimedia 1 325 15.36734693877551 bswiki 1 1072 347.9836065573771 mhrwiki 1 955 124.65833333333333 enwikivoyage 9 2941 754.5983606557377 xmfwiki 1 523 54.557377049180324 sahwiki 2 128 39.22950819672131 bnwiktionary 1 975 14.530434782608696 dawikiquote 1 70 4.954545454545454 etwikimedia 1 15 1.925 urwikiquote 1 66 3.911111111111111 gawiki 10 359 85.72727272727273 huwikibooks 1 651 113.3360655737705 csbwiki 1 471 17.237704918032787 rwwiktionary 1 310 6.951612903225806 kbdwiki 1 129 8.439252336448599 srwikibooks 1 18 2.65 vewiki 1 69 3.6265060240963853 roa_rupwiki 1 150 5.831858407079646 sowiki 4 276 46.19672131147541 warwiki 10 468 51.81818181818182 frwikibooks 8 563 122.40983606557377 knwiki 4 1367 194.827868852459 lawikibooks 1 7 1.697674418604651 fowiktionary 1 708 13.065934065934066 zhwikibooks 5 403 54.549180327868854 cawikisource 1 201 10.654545454545454 alswiki 5 1440 265.0983606557377 tetwiki 1 62 3.980392156862745 fywiktionary 1 8867 98.98245614035088 ugwiki 1 301 22.66115702479339 hiwiktionary 1 2751 87.68852459016394 eowikinews 3 218 95.40517241379311 iawiktionary 1 944 15.259615384615385 eewiki 1 105 5.35042735042735 bowiki 1 232 13.09016393442623 tiwiki 1 19 3.1067961165048543 glwikisource 1 91 11.420289855072463 etwikiquote 1 78 3.753846153846154 hewikinews 1 60 3.287671232876712 ltwiktionary 1 1376 216.04918032786884 mlwiktionary 2 13154 168.75423728813558 skwiki 1 1933 746.4959349593496 fiwikiversity 1 180 10.207317073170731 nnwiktionary 1 237 22.916666666666668 htwiki 1 1156 28.295081967213115 anwiktionary 1 1951 28.92156862745098 kabwiki 1 36 7.34453781512605 tawikinews 1 378 8.036144578313253 mrwikiquote 1 11 1.9090909090909092 rmwiki 1 200 12.51639344262295 cswikiversity 1 283 33.79338842975206 enwikiversity 26 1672 389.4836065573771 fawikiquote 2 855 175.4016393442623 gvwiki 1 123 8.082644628099173 angwiki 5 59 23.4672131147541 gotwiki 1 41 4.364406779661017 kowikiquote 1 27 2.6296296296296298 thwikiquote 1 392 21.822916666666668 dawikibooks 1 390 14.647058823529411 eowiktionary 1 20276 2220.289256198347 sqwiktionary 1 11291 115.96610169491525 tewiki 12 1667 453.655737704918 urwikibooks 1 12 1.7666666666666666 lmowiki 11 1957 88.15702479338843 tiwiktionary 1 305 9.047619047619047 nywiki 1 20 3.5294117647058822 commonswiki 513 265539 151434.22950819673 tswiktionary 1 101 3.6666666666666665 azwikiquote 1 410 67.1 slwikiquote 1 31 4.635416666666667 ukwiktionary 2 389 39.73770491803279 amwiki 3 84 23.5 hawiktionary 1 167 4.196969696969697 sgwiki 1 10 2.3373493975903616 slwikisource 1 169 29.024590163934427 etwikisource 1 204 43.983333333333334 svwikisource 1 1097 48.74590163934426 wikimania2015wiki 1 4 1.3421052631578947 ladwiki 1 572 99.09016393442623 cewiki 2 1630 295.11475409836066 vecwikisource 1 133 19.195121951219512 oswiki 2 247 29.487603305785125 cdowiki 1 78 9.327731092436975 etwikibooks 1 84 4.962264150943396 lvwiktionary 1 131 22.05128205128205 mnwiktionary 1 8975 93.95081967213115 bgwikiquote 1 17 3.36697247706422 tawiki 31 10705 1144.2377049180327 jbowiki 1 36 4.864406779661017 kowikisource 1 253 42.66393442622951 cswikinews 1 121 39.68032786885246 afwiktionary 1 9032 103.06140350877193 xalwiki 1 756 22.054054054054053 ruewiki 2 100 24.570247933884296 scwiki 1 630 19.524590163934427 wuuwiki 4 126 23.065573770491802 nowikinews 1 55 3.0384615384615383 fiwikinews 1 10 1.7681159420289856 mrwikibooks 1 10 1.7037037037037037 siwiktionary 1 576 12.4 srnwiki 1 60 4.455357142857143 simplewiki 66 2292 1367.1065573770493 fawikibooks 3 220 50.58196721311475 sswiktionary 1 216 6.224489795918367 fiwiktionary 11 7162 784.5537190082645 kowikibooks 1 89 7.08256880733945 thwikibooks 1 1111 48.03333333333333 tkwiktionary 1 1843 25.816091954022987 wowikiquote 1 12 1.84 bswikiquote 1 64 6.8173076923076925 tewikiquote 1 39 4.170731707317073 gnwiki 1 239 7.369747899159663 svwikinews 1 16 2.2058823529411766 bdwikimedia 1 55 5.1571428571428575 zeawiki 1 103 6.775862068965517 chrwiktionary 1 187071 1825.22131147541 elwikisource 3 4048 78.17213114754098 azwikibooks 1 30 5.669724770642202 slwikibooks 1 167 4.1940298507462686 iewiktionary 1 790 13.10752688172043 furwiki 1 219 7.097345132743363 klwiktionary 1 1022 16.45977011494253 nds_nlwiki 1 30 7.926229508196721 hsbwiki 2 466 52.950413223140494 loginwiki 140 13810 11752.341463414634 piwiki 1 23 2.2916666666666665 jamwiki 1 44 5.917355371900826 mswiki 16 1950 728.6803278688525 lnwiktionary 1 517 10.516129032258064 map_bmswiki 1 46 5.017699115044247 ttwikibooks 1 11 1.8125 barwiki 19 734 131.52459016393442 fiu_vrowiki 1 112 6.260869565217392 liwikisource 1 12 2.875 bgwikibooks 1 10 1.8717948717948718 elwikiversity 1 43 6.5 suwikiquote 1 323 18.944444444444443 cowiktionary 1 8555 105.53636363636363 mkwikisource 1 14 2.290909090909091 sqwikinews 1 7 1.5714285714285714 rmywiki 1 139 4.754385964912281 hywikiquote 1 288 132.40495867768595 eowikiquote 1 39 4.659090909090909 kwwiki 1 158 6.570247933884297 cywiktionary 1 15115 165.8803418803419 cvwiki 2 2272 246.74590163934425 fywikibooks 1 8 1.9230769230769231 skwiktionary 1 15311 207.2704918032787 azwikisource 1 165 20.26890756302521 brwikisource 1 283 39.83185840707964 mxwikimedia 1 16 2.950617283950617 ptwikisource 4 220 26.049180327868854 eswiktionary 13 44439 2422.6803278688526 suwiktionary 1 289 8.543859649122806 bewikisource 1 89 15.077669902912621 mlwikiquote 1 133 4.40625 enwiki 1 237724 186497.1869918699 bswikibooks 1 80 3.3636363636363638 tewikibooks 1 11 1.7333333333333334 hewiktionary 4 4233 103.60655737704919 enwikisource 37 4860 2317.7950819672133 itwiktionary 20 1830 432.8099173553719 thwikisource 1 498 38.66386554621849 azwiki 16 5507 1320.8852459016393 jvwiktionary 1 39 9.321100917431192 knwiktionary 1 396 69.23140495867769 siwikibooks 1 31 2.9875 roa_tarawiki 1 24 3.625 stwiki 1 107 5.134020618556701 zhwiktionary 10 279924 4562.737704918033 kswiki 1 18 2.588888888888889 crwiki 1 70 5.598290598290598 itwikinews 2 153 30.09917355371901 ocwikibooks 1 7 1.5806451612903225 mdfwiki 1 453 14.930693069306932 pawiki 6 806 211.3360655737705 kuwikiquote 1 9 2.1914893617021276 mkwiki 2 821 380.07377049180326 ukwikivoyage 1 33 4.175257731958763 arwikinews 2 184 38.31147540983606 tnwiki 1 38 4.961165048543689 ocwiki 2 1012 162.86885245901638 outreachwiki 4 988 80.10655737704919 ruwiktionary 7 63854 4173.418032786885 avwiki 1 236 10.669491525423728 hywikibooks 1 8 2.197674418604651 smwiktionary 1 7479 90.25 eowikibooks 1 19 2.925925925925926 tewiktionary 1 40942 393.1932773109244 elwikiquote 1 43 2.7628865979381443 ckbwiki 1 3571 192.54098360655738 newiki 4 372 152.0737704918033 hywiki 2 9798 2209.1393442622953 ugwiktionary 1 1347 19.475728155339805 arwikimedia 1 6 1.7285714285714286 frpwiki 1 119 9.408333333333333 frwikiversity 1 829 238.48360655737704 mlwikibooks 1 91 4.037735849056604 afwikiquote 1 12 1.816326530612245 wawiktionary 1 5743 100.57758620689656 mgwiki 2 1312 48.63636363636363 elwikinews 1 196 7.450980392156863 ptwikiquote 1 72 20.098360655737704 incubatorwiki 5 3750 1149.6967213114754 ruwikiversity 2 167 35.66393442622951 hywikisource 2 933 128.98360655737704 krcwiki 1 27 3.3454545454545452 liwiki 2 257 27.934426229508198 iswiki 5 279 123.27868852459017 nahwiktionary 1 3752 49.293577981651374 tpiwiktionary 1 152 4.28169014084507 tcywiki 1 428 19.25 slwiki 2 23080 990.516393442623 nawiki 1 55 4.047169811320755 kkwiki 34 3749 378.1885245901639 arwikiquote 1 663 44.85245901639344 aywiktionary 1 848 14.967391304347826 pswiktionary 1 189 12.9 kowikiversity 1 257 16.835051546391753 kuwikibooks 1 23 3.25 rnwiki 1 13 2.316326530612245 cswiktionary 2 37747 903.0983606557377 quwiktionary 1 280 6.136363636363637 pnbwiki 1 19204 329.3114754098361 sowiktionary 1 1509 22.383838383838384 tgwiktionary 1 19352 373.5206611570248 glwikiquote 1 11 2.1296296296296298 koiwiki 1 45 3.78 iowiki 2 305 78.38524590163935 elwikibooks 1 78 7.224299065420561 fywiki 3 1334 271.3114754098361 newikibooks 1 33 2.8 anwiki 4 586 55.84426229508197 shwiki 17 3751 373.27868852459017 kgwiki 1 22 3.3008849557522124 wikimania2016wiki 1 99 6.317757009345795 afwikibooks 1 7 1.8372093023255813 ptwikibooks 2 458 67.01639344262296 iswikisource 1 8 1.8070175438596492 mywiktionary 1 34986 877.9915966386554 plwikivoyage 1 66 17.860655737704917 bhwiki 3 2635 118.13934426229508 newwiki 1 47 7.5041322314049586 euwikiquote 1 104 4.729166666666667 nnwikiquote 1 7 1.7027027027027026 ganwiki 1 51 9.926229508196721 nvwiki 1 639 82.47107438016529 eswikivoyage 2 150 27.60655737704918 lawiki 4 20253 596.8196721311475 ikwiki 1 65 4.171428571428572 ndswiktionary 1 4967 60.19827586206897 bswiktionary 1 5926 74.09649122807018 arwikibooks 3 554 50.131147540983605 sdwiki 7 1204 120.6694214876033 hewikivoyage 2 3358 106.00819672131148 sawikiquote 1 7 1.6829268292682926 rowikinews 1 20 3.7719298245614037 rowiktionary 1 934 181.94262295081967 sgwiktionary 1 154 5.82 bnwikisource 7 6901 814.2644628099174 hewikiquote 1 68 18.57377049180328 gvwiktionary 1 445 8.597701149425287 sourceswiki 33 1000 202.71311475409837 dkwikimedia 1 13 2.2413793103448274 bgwikinews 1 8 1.6923076923076923 glwikibooks 1 12 1.981818181818182 gomwiki 1 527 30.683333333333334 yiwiki 1 297 49.17213114754098 chywiki 1 12 2.957894736842105 scnwiki 3 583 18.231404958677686 cowikimedia 1 28 2.484848484848485 igwiki 1 128 7.165217391304348 uawikimedia 1 97 20.69747899159664 afwiki 7 731 261.25409836065575 lbwiktionary 1 88 18.08108108108108 mtwiki 1 63 10.172131147540984 szlwiki 1 43 13.933884297520661 emlwiki 2 118 33.78688524590164 zh_classicalwiki 7 705 127.11475409836065 hiwiki 48 9911 2231.565573770492 testwiki 4 991 71.78688524590164 ruwikivoyage 7 577 85.80327868852459 pihwiki 1 50 4.907407407407407 twwiki 1 33 3.55045871559633 fawikinews 1 34 6.033707865168539 guwikiquote 1 10 3.3714285714285714 mgwikibooks 1 6 1.8148148148148149 lvwiki 15 3652 558.5245901639345 pagwiki 1 224 4.75 zh_yuewiki 17 1076 317.04918032786884 euwikibooks 1 50 3.630434782608696 udmwiki 1 165 14.487394957983193 kawikiquote 1 13 2.3373493975903616 vowiki 1 409 14.03305785123967 dewiktionary 5 6867 2132.72131147541 acewiki 1 287 18.975409836065573 nnwiki 5 955 376.172131147541 svwiktionary 2 27850 1347.655737704918 viwikivoyage 1 103 5.847619047619047 bjnwiki 1 175 13.141666666666667 hifwiki 3 86 21.860655737704917 vecwiktionary 1 1634 25.292035398230087 sawikibooks 1 38 4.714285714285714 tawiktionary 1 121535 1100.704918032787 abwiki 1 347 13.03448275862069 ltgwiki 1 22 3.0776699029126213 gnwiktionary 1 292 6.857142857142857 srwikinews 1 372 7.369565217391305 gawiktionary 1 2307 30.086206896551722 hewikibooks 2 401 21.33606557377049 cebwiki 2 62087 29578.122950819674 uzwiktionary 1 1039 103.95867768595042 viwikiquote 1 149 11.771186440677965 cawikimedia 1 1092 27.41 trwikimedia 1 22 4.08256880733945 tswiki 1 15 2.839622641509434 ukwikisource 3 630 156.5327868852459 be_x_oldwiki 2 537 197.65573770491804 kywiktionary 1 8533 243.94871794871796 nlwikivoyage 2 96 17.165289256198346 ltwikiquote 1 43 12.09433962264151 bewikimedia 1 173 7.594059405940594 plwikimedia 1 83 21.59504132231405 huwikisource 1 298 6.67741935483871 suwiki 2 3269 227.04098360655738 mswiktionary 1 2494 40.02803738317757 omwiktionary 1 326 7.383561643835616 yiwikisource 1 19 2.32 rwwiki 1 45 3.6363636363636362 mlwiki 26 1066 532.8770491803278 cawikiquote 2 416 79.52066115702479 jvwiki 5 5081 152.70491803278688 kywikiquote 1 10 2.0789473684210527 trwikiquote 3 698 57.02459016393443 hawiki 1 26 5.419642857142857 cawikinews 1 299 101.18181818181819 diqwiki 4 777 128.55737704918033 rowikiquote 1 13 2.604651162790698 towiki 1 758 11.063157894736841 jbowiktionary 1 745 11.67816091954023 mznwiki 2 83 11.926229508196721 sawiktionary 1 6155 158.33035714285714 kawikibooks 1 17 2.7432432432432434 lnwiki 1 115 6.672413793103448 orwikisource 1 270 32.59166666666667 bewikiquote 1 82 11.122222222222222 svwikiquote 1 12 3.2523364485981308 plwikiquote 2 337 65.38524590163935 betawikiversity 6 1089 107.04098360655738 fawiktionary 1 400 79.70491803278688 glkwiki 1 80 14.125 extwiki 1 87 7.691666666666666 eswikiversity 7 199 34.032786885245905 sqwiki 5 7306 441.7950819672131 urwiktionary 1 1155 15.730337078651685 azbwiki 7 933 236.65573770491804 dewikinews 1 260 129.52459016393442 hrwiktionary 1 460 91.0909090909091 cowiki 1 283 13.868852459016393 minwiki 1 55 8.369747899159664 viwikibooks 1 673 82.19827586206897 guwikisource 1 361 43.5655737704918 kmwikibooks 1 80 4.571428571428571 zuwiktionary 1 536 10.91891891891892 wawiki 2 128 21.385245901639344 tkwiki 1 1451 30.360655737704917 ltwikibooks 1 21 2.044776119402985 quwiki 1 143 23.959016393442624 sahwikisource 1 13 1.8918918918918919 arzwiki 10 664 170.68852459016392 rowikivoyage 1 209 13.617283950617283 aswiki 6 615 44.97540983606557 amwiktionary 1 463 13.055555555555555 lrcwiki 1 539 101.41322314049587 bewiktionary 1 3478 51.1965811965812 lawikisource 1 156 23.0327868852459 smwiki 1 114 4.947368421052632 ukwikiquote 1 152 18.583333333333332 hsbwiktionary 1 976 15.618421052631579 klwiki 1 14 3.272727272727273 tpiwiki 1 32 4.107142857142857 dvwiktionary 1 223 5.346666666666667 cawikibooks 1 86 13.160714285714286 kywikibooks 1 9 1.7027027027027026 trwikibooks 1 297 13.524590163934427 maiwiki 2 695 102.77049180327869 arwikisource 8 341 57.97540983606557 astwiki 4 517 136.27868852459017 zh_min_nanwikisource 1 32 3.217391304347826 dewikiquote 3 326 31.983606557377048 plwikisource 3 2767 1379.1475409836066 rowikibooks 1 187 6.892156862745098 trwiktionary 18 4350 655.0413223140496 iswikiquote 1 7 2.096774193548387 bmwiki 1 70 4.625 cywikisource 1 14 2.076923076923077 bewikibooks 1 333 19.954545454545453 svwikibooks 1 31 4.779816513761468 tgwiki 8 8867 259.1639344262295 ilowiki 1 1988 115.075 plwikibooks 2 372 29.598360655737704 dsbwiki 1 30 5.983050847457627 eswikisource 10 1803 202.40983606557376 siwiki 3 1230 92.39344262295081 kswiktionary 1 130 4.6 pswiki 4 233 61.631147540983605 hewikisource 1 905 204.69672131147541 hrwiki 5 1223 588.6639344262295 sewikimedia 1 248 31.092436974789916 wikimania2017wiki 5 2734 373.5327868852459 newiktionary 1 3015 48.83076923076923 ruwikinews 4 668 207.69672131147541 dewikivoyage 3 563 256.2049180327869 papwiki 1 193 8.560344827586206 nowiktionary 7 714 184.8595041322314 biwiki 1 209 15.347826086956522 idwikiquote 1 14 3.888888888888889 ukwikinews 1 33 4.683168316831683 bpywiki 1 31 6.066666666666666 lbwiki 12 1479 167.52892561983472 mrwikisource 1 179 8.638297872340425 mwlwiki 1 647 17.63063063063063 ukwikibooks 1 185 12.330097087378642 dawiki 11 6547 2033.9918032786886 itwikiversity 5 1296 128.36885245901638 akwiki 1 192 5.781818181818182 dawiktionary 5 1252 173.875 uzwiki 4 181 81.34426229508196 bugwiki 1 85 4.763636363636364 sewiki 1 41 7.991803278688525 srwiktionary 1 613 201.7704918032787 mywiki 14 795 225.70491803278688 ttwiktionary 1 78 8.383838383838384 hiwikiquote 1 23 5.013698630136986 ruwikimedia 10 220 56.377049180327866 ruwikisource 3 8920 1147.0983606557377 dewikibooks 2 331 113.57377049180327 iswikibooks 1 85 9.419354838709678 tewikisource 1 495 48.05785123966942 idwiktionary 1 687 104.8688524590164 dzwiki 1 8 2.3980582524271843 bewiki 3 64973 2412.3524590163934 nowikimedia 1 904 31.725490196078432 kuwiktionary 1 14205 621.4297520661157 pcdwiki 1 30 7.697478991596639 scnwiktionary 1 318 27.3135593220339 scowiki 20 1933 433.90983606557376 viwikisource 1 47 6.276785714285714 sqwikiquote 1 43 3.610169491525424 jawikisource 5 170 47.42622950819672 sawiki 1 2831 115.5327868852459 test2wiki 3 1305 88.50819672131148 etwiki 3 1485 862.5819672131148 jawikiversity 1 97 5.108910891089109 ruwikiquote 7 210 74.76229508196721 pawiktionary 1 1457 68.46067415730337 pntwiki 1 17 3.118181818181818 bnwikibooks 1 246 9.854700854700855 fawikivoyage 2 94 24.098360655737704 jawikinews 1 568 12.0 omwiki 1 40 4.262135922330097 cawiktionary 9 3720 747.3388429752066 glwiki 1 6790 1581.3688524590164 idwikibooks 1 49 8.272727272727273 nlwikisource 1 63 10.830508474576272 dvwiki 1 43 6.1735537190082646 bawiki 5 3098 429.42622950819674 bclwiki 1 312 14.694214876033058 csbwiktionary 1 1486 20.310679611650485 nowikiquote 1 57 3.276315789473684 bxrwiki 1 179 11.156521739130435 stwiktionary 1 523 10.484848484848484 cvwikibooks 1 7 1.606060606060606 fjwiktionary 1 951 93.70434782608696 gagwiki 1 67 5.579831932773109 tlwiktionary 1 398 61.64102564102564 cswikiquote 1 52 12.09016393442623 itwikivoyage 1 2325 175.44262295081967 kywiki 4 5714 186.01639344262296 cswikisource 3 1471 81.95901639344262 glwiktionary 1 626 150.4297520661157 xhwiki 1 82 5.116071428571429 urwiki 9 43446 1846.516393442623 iswiktionary 1 16098 188.25 zhwikivoyage 2 157 38.81967213114754 tlwikibooks 1 60 11.770642201834862 hiwikibooks 1 172 11.561983471074381 fowikisource 1 28 2.5428571428571427 kmwiktionary 1 5941 77.27586206896552 ttwiki 1 1065 160.74590163934425 zhwikinews 7 424 25.885245901639344 nsowiki 1 743 24.78125 arwikiversity 1 154 22.295081967213115 kwwiktionary 1 421 8.45 lowiktionary 1 46579 479.15384615384613 mgwiktionary 7 307319 6354.760330578512 nlwikimedia 1 36 7.854700854700854 sqwikibooks 1 45 3.036144578313253 chrwiki 1 30 4.884955752212389 kuwiki 9 345 85.58677685950413 ptwikinews 3 1178 191.53719008264463 fjwiki 1 135 8.020833333333334 hrwikiquote 1 56 4.041666666666667 ltwikisource 1 17 2.693877551020408 adywiki 1 252 5.838983050847458 mlwikisource 1 495 21.265486725663717 ruwikibooks 9 91 30.770491803278688 elwiki 10 2996 1882.827868852459 slwiktionary 1 5893 68.94067796610169 bswikisource 1 14 2.2448979591836733 etwiktionary 5 1124 207.6611570247934 iawikibooks 1 56 5.67741935483871 vecwiki 2 56 13.450819672131148 lowiki 1 582 36.99166666666667 nowikibooks 1 65 2.6164383561643834 tnwiktionary 1 117 5.122448979591836 eswikiquote 7 149 60.39344262295082 gdwiktionary 1 1326 19.11340206185567 nlwikiquote 1 127 18.112068965517242 gdwiki 5 154 38.231404958677686 rowikisource 1 78 10.358333333333333 cswikibooks 1 36 7.336206896551724 eswikinews 11 1874 172.62809917355372 liwikiquote 1 10 2.1194029850746268 srwiki 2 52871 3518.3278688524592 eowikisource 1 41 2.9404761904761907 iuwiktionary 1 245 6.144927536231884 nrmwiki 1 68 5.061946902654867 mswikibooks 1 7 1.826086956521739 ffwiki 1 29 5.556603773584905 trwikinews 1 474 95.36363636363636 zuwiki 1 112 8.457627118644067 frrwiki 2 312 51.66115702479339 kowiktionary 1 2174 424.26229508196724 miwiki 1 20 4.356521739130435 nycwikimedia 1 5 1.4210526315789473 miwiktionary 1 780 15.067415730337078 brwiki 13 507 152.1487603305785 nawiktionary 1 516 9.270588235294118 knwikiquote 1 7 1.8732394366197183 tlwiki 4 910 213.5 ocwiktionary 8 583 180.95833333333334 iuwiki 1 44 4.882352941176471 mrjwiki 1 67 3.75 frwikivoyage 3 3028 138.4262295081967 hawwiki 1 58 4.7368421052631575 skwikiquote 1 32 2.7872340425531914 snwiki 1 377 16.6864406779661 enwikinews 13 1074 445.655737704918 hrwikibooks 1 86 10.047058823529412 kmwiki 4 483 60.0655737704918 sdwiktionary 1 912 21.1 aswikisource 1 171 17.19607843137255 slwikiversity 1 97 17.413793103448278 elwiktionary 1 7286 637.639344262295 napwiki 1 171 13.885245901639344 Time taken: 74.167 seconds, Fetched: 699 row(s) hive (wmf)>