Page MenuHomePhabricator
Paste P5383

(An Untitled Masterwork)
ActivePublic

Authored by EBernhardson on May 4 2017, 9:28 PM.
Tags
None
Referenced Files
F7915570:
May 4 2017, 9:28 PM
Subscribers
None
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=<number>
In order to limit the maximum number of reducers:
set hive.exec.reducers.max=<number>
In order to set a constant number of reducers:
set mapreduce.job.reduces=<number>
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)>