hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject svn commit: r1462322 [4/4] - in /hive/branches/ptf-windowing/ql/src: java/org/apache/hadoop/hive/ql/parse/ java/org/apache/hadoop/hive/ql/plan/ java/org/apache/hadoop/hive/ql/udf/ptf/ test/queries/clientnegative/ test/queries/clientpositive/ test/resul...
Date Thu, 28 Mar 2013 21:53:40 GMT
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/windowing_udaf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/windowing_udaf.q.out?rev=1462322&r1=1462321&r2=1462322&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/windowing_udaf.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/windowing_udaf.q.out Thu
Mar 28 21:53:39 2013
@@ -155,106 +155,106 @@ POSTHOOK: query: select s, avg(f) over (
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 #### A masked pattern was here ####
-quinn quirinius	51.42081073812536
-zach underhill	51.42081073812536
-fred hernandez	51.42081073812536
-rachel ellison	51.42081073812536
-xavier van buren	51.42081073812536
-david davidson	51.42081073812536
-ethan falkner	51.42081073812536
-wendy nixon	51.42081073812536
-alice ovid	51.42081073812536
-xavier ovid	51.42081073812536
+fred quirinius	40.970001220703125
+ulysses white	47.60000038146973
+alice ellison	44.45333353678385
+sarah white	41.5
+victor thompson	44.07000001271566
+calvin johnson	44.07000001271566
+nick zipper	51.10142871311733
+victor johnson	47.296250104904175
+calvin young	49.61400032043457
+zach nixon	49.61400032043457
+xavier quirinius	54.20833365122477
+victor robinson	54.20833365122477
+victor hernandez	54.74692329993615
+tom allen	54.20571436200823
+sarah brown	56.666666920979814
+irene polk	58.91937518119812
+holly xylophone	56.917647193459906
+rachel ovid	54.96833345625136
+wendy garcia	54.67736846522281
+oscar steinbeck	54.6835000038147
+zach white	54.382272633639246
+ethan thompson	54.382272633639246
+quinn hernandez	55.655652004739515
+fred hernandez	53.47749984264374
+wendy nixon	55.13319995880127
+david davidson	55.86461540368887
+rachel ellison	54.12888890725595
+gabriella falkner	53.41321430887495
+ethan falkner	52.01862072122508
+alice ovid	52.830666605631514
+zach underhill	53.1432257621519
+alice robinson	53.058787837173
+quinn quirinius	53.058787837173
+ulysses young	51.977352927712836
+xavier van buren	52.72857131958008
+xavier ovid	52.70055548350016
 victor davidson	51.42081073812536
-ulysses young	51.42081073812536
-gabriella falkner	51.42081073812536
-alice robinson	51.42081073812536
-fred quirinius	51.42081073812536
-ulysses white	51.42081073812536
-alice ellison	51.42081073812536
-sarah white	51.42081073812536
-calvin johnson	51.42081073812536
-victor thompson	51.42081073812536
-nick zipper	51.42081073812536
-victor johnson	51.42081073812536
-calvin young	51.42081073812536
-zach nixon	51.42081073812536
-victor robinson	51.42081073812536
-xavier quirinius	51.42081073812536
-victor hernandez	51.42081073812536
-tom allen	51.42081073812536
-sarah brown	51.42081073812536
-irene polk	51.42081073812536
-holly xylophone	51.42081073812536
-rachel ovid	51.42081073812536
-wendy garcia	51.42081073812536
-oscar steinbeck	51.42081073812536
-zach white	51.42081073812536
-ethan thompson	51.42081073812536
-quinn hernandez	51.42081073812536
-luke quirinius	51.274500131607056
-luke falkner	51.274500131607056
-ulysses young	51.274500131607056
-fred brown	51.274500131607056
-ethan underhill	51.274500131607056
-holly robinson	51.274500131607056
+jessica laertes	51.61000061035156
+yuri nixon	52.75
+ethan king	61.550000508626304
+sarah hernandez	46.9425003528595
+alice underhill	41.020000267028806
+alice xylophone	50.516666889190674
+victor xylophone	52.099999972752165
+yuri brown	51.53500020503998
+oscar young	51.92777792612711
+nick quirinius	57.051818414167926
+zach underhill	57.051818414167926
+gabriella ellison	55.287500301996864
+holly white	54.27615407797006
+zach hernandez	54.87000022615705
+xavier brown	54.62933343251546
+irene young	52.748750150203705
+katie garcia	51.00941192402559
+oscar laertes	48.69000016318427
+katie ichabod	48.97000006625527
+nick davidson	48.98899998664856
+priscilla miller	47.38761901855469
+rachel robinson	48.00090911171653
+fred brown	50.08826098234757
+wendy brown	49.570400161743166
+fred zipper	49.570400161743166
+holly robinson	51.34037053143537
+priscilla laertes	51.34037053143537
+nick zipper	52.96571438653128
+ethan polk	54.25793121600973
+priscilla thompson	52.37741947174072
+luke quirinius	52.37741947174072
+oscar thompson	50.77843761444092
+ulysses young	50.225151639996156
+ethan underhill	51.552353017470416
+luke falkner	50.90800007411412
+zach zipper	52.148889011806915
+david brown	52.92216233949404
+zach hernandez	52.05473699067768
+mike underhill	51.34564116062262
 zach hernandez	51.274500131607056
-priscilla laertes	51.274500131607056
-fred zipper	51.274500131607056
-zach zipper	51.274500131607056
-rachel robinson	51.274500131607056
-zach hernandez	51.274500131607056
-priscilla thompson	51.274500131607056
-david brown	51.274500131607056
-ethan polk	51.274500131607056
-nick zipper	51.274500131607056
-mike underhill	51.274500131607056
-oscar thompson	51.274500131607056
-priscilla miller	51.274500131607056
-wendy brown	51.274500131607056
-jessica laertes	51.274500131607056
-yuri nixon	51.274500131607056
-ethan king	51.274500131607056
-sarah hernandez	51.274500131607056
-alice underhill	51.274500131607056
-alice xylophone	51.274500131607056
-victor xylophone	51.274500131607056
-yuri brown	51.274500131607056
-oscar young	51.274500131607056
-zach underhill	51.274500131607056
-nick quirinius	51.274500131607056
-gabriella ellison	51.274500131607056
-holly white	51.274500131607056
-zach hernandez	51.274500131607056
-xavier brown	51.274500131607056
-irene young	51.274500131607056
-katie garcia	51.274500131607056
-oscar laertes	51.274500131607056
-katie ichabod	51.274500131607056
-nick davidson	51.274500131607056
-mike underhill	52.23272767572692
-nick xylophone	52.23272767572692
-irene quirinius	52.23272767572692
-wendy king	52.23272767572692
-yuri johnson	52.23272767572692
-nick falkner	52.23272767572692
-katie allen	52.23272767572692
-jessica falkner	52.23272767572692
-zach steinbeck	52.23272767572692
-holly johnson	52.23272767572692
-fred king	52.23272767572692
-sarah polk	52.23272767572692
-alice nixon	52.23272767572692
-david garcia	52.23272767572692
-priscilla zipper	52.23272767572692
-tom laertes	52.23272767572692
-oscar van buren	52.23272767572692
-jessica ichabod	52.23272767572692
-priscilla underhill	52.23272767572692
-bob falkner	52.23272767572692
-xavier zipper	52.23272767572692
-zach zipper	52.23272767572692
-jessica laertes	52.23272767572692
+tom laertes	9.050000190734863
+oscar van buren	37.92999887466431
+priscilla underhill	49.59750008583069
+jessica ichabod	49.59750008583069
+bob falkner	54.244999726613365
+xavier zipper	54.244999726613365
+zach zipper	54.014285632542204
+jessica laertes	54.80499994754791
+calvin davidson	45.944000005722046
+calvin steinbeck	45.944000005722046
+gabriella young	44.62636371092363
+luke ovid	48.321666836738586
+nick king	54.24857177053179
+sarah zipper	54.24857177053179
+alice nixon	53.90733372370402
+ulysses laertes	50.65812536329031
+priscilla zipper	51.28058867594775
+calvin johnson	48.576667077011535
+katie allen	51.187895254084935
+zach steinbeck	49.3070004761219
+priscilla zipper	48.46285759267353
+mike underhill	48.61545496095311
+irene quirinius	49.54521778873775
 PREHOOK: query: select s, avg(i) over (partition by t, b) from over10k limit 100
 PREHOOK: type: QUERY
 PREHOOK: Input: default@over10k
@@ -263,106 +263,106 @@ POSTHOOK: query: select s, avg(i) over (
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 #### A masked pattern was here ####
-bob steinbeck	65666.04761904762
-victor xylophone	65666.04761904762
-ethan garcia	65666.04761904762
-jessica ellison	65666.04761904762
-ulysses ichabod	65666.04761904762
-victor garcia	65666.04761904762
-ethan ellison	65666.04761904762
-ethan ichabod	65666.04761904762
-rachel thompson	65666.04761904762
-irene nixon	65666.04761904762
-david ovid	65666.04761904762
-tom hernandez	65666.04761904762
-quinn steinbeck	65666.04761904762
-alice zipper	65666.04761904762
-ulysses xylophone	65666.04761904762
-quinn miller	65666.04761904762
-gabriella steinbeck	65666.04761904762
-holly allen	65666.04761904762
-ulysses nixon	65666.04761904762
-irene polk	65666.04761904762
-yuri nixon	65666.04761904762
-katie white	65678.64285714286
-wendy ellison	65678.64285714286
-holly king	65678.64285714286
-oscar quirinius	65678.64285714286
-zach falkner	65678.64285714286
-ulysses allen	65678.64285714286
-rachel quirinius	65678.64285714286
-calvin van buren	65678.64285714286
-rachel young	65678.64285714286
-rachel davidson	65678.64285714286
-fred nixon	65678.64285714286
-zach allen	65678.64285714286
-sarah van buren	65678.64285714286
-fred brown	65678.64285714286
-ethan miller	65663.35294117648
-ulysses king	65663.35294117648
-mike van buren	65663.35294117648
-bob garcia	65663.35294117648
-jessica johnson	65663.35294117648
-gabriella davidson	65663.35294117648
-xavier davidson	65663.35294117648
-gabriella van buren	65663.35294117648
-bob ovid	65663.35294117648
-xavier falkner	65663.35294117648
-jessica miller	65663.35294117648
-jessica quirinius	65663.35294117648
-holly nixon	65663.35294117648
-luke falkner	65663.35294117648
-xavier brown	65663.35294117648
-wendy nixon	65663.35294117648
-alice falkner	65663.35294117648
-zach quirinius	65659.8
-quinn white	65659.8
-mike falkner	65659.8
-gabriella king	65659.8
-mike underhill	65659.8
-luke robinson	65659.8
-gabriella thompson	65659.8
-katie laertes	65659.8
-bob zipper	65659.8
-holly falkner	65659.8
-david davidson	65659.8
-calvin ellison	65659.8
-alice hernandez	65659.8
-calvin xylophone	65659.8
-victor robinson	65659.8
-yuri garcia	65648.22222222222
-alice falkner	65648.22222222222
-irene ichabod	65648.22222222222
-calvin nixon	65648.22222222222
-fred carson	65648.22222222222
-zach white	65648.22222222222
-jessica davidson	65648.22222222222
-priscilla young	65648.22222222222
-calvin van buren	65648.22222222222
-holly miller	65648.22222222222
-nick ellison	65648.22222222222
-victor steinbeck	65648.22222222222
-holly davidson	65648.22222222222
-holly falkner	65648.22222222222
-priscilla underhill	65648.22222222222
-katie polk	65648.22222222222
-priscilla laertes	65648.22222222222
-calvin van buren	65648.22222222222
-gabriella steinbeck	65651.29411764706
-xavier allen	65651.29411764706
-ethan laertes	65651.29411764706
-jessica king	65651.29411764706
-ulysses underhill	65651.29411764706
-ethan laertes	65651.29411764706
-gabriella hernandez	65651.29411764706
-ethan white	65651.29411764706
-zach johnson	65651.29411764706
-wendy king	65651.29411764706
-victor davidson	65651.29411764706
-quinn quirinius	65651.29411764706
-luke robinson	65651.29411764706
-nick ichabod	65651.29411764706
-ethan thompson	65651.29411764706
+oscar miller	65773.0
+bob underhill	65743.5
+tom polk	65743.5
+wendy robinson	65622.0
+alice king	65570.0
+ethan steinbeck	65695.5
+quinn polk	65695.5
+bob ellison	65671.0
+mike xylophone	65610.0
+alice king	65563.0
+ulysses robinson	65540.0
+victor hernandez	65755.0
+xavier ovid	65769.0
+oscar garcia	65712.0
+sarah zipper	65766.0
+wendy xylophone	65670.0
+gabriella brown	65680.33333333333
+sarah miller	65680.33333333333
+irene young	65680.33333333333
+nick nixon	65696.0
+tom steinbeck	65608.0
+oscar johnson	65650.0
+calvin white	65650.0
+holly thompson	65550.0
+david falkner	65698.0
+ulysses steinbeck	65562.0
+victor allen	65658.0
+rachel thompson	65733.0
+jessica johnson	65589.0
+alice falkner	65597.0
+ulysses carson	65728.33333333333
+priscilla quirinius	65728.33333333333
+victor thompson	65728.33333333333
+ulysses ellison	65640.0
+bob johnson	65731.0
+quinn ellison	65736.0
+victor xylophone	65697.0
+bob polk	65697.0
+jessica white	65566.0
+holly nixon	65565.0
+oscar johnson	65671.0
+irene ellison	65696.0
+priscilla zipper	65669.0
+fred ellison	65548.0
+sarah robinson	65605.0
+nick robinson	65605.0
+tom hernandez	65575.0
+alice xylophone	65618.0
+sarah xylophone	65618.0
+priscilla laertes	65696.0
+holly polk	65710.0
+katie ichabod	65577.0
+holly underhill	65553.0
+ethan underhill	65706.5
+alice davidson	65706.5
+bob van buren	65654.0
+jessica king	65644.0
+mike allen	65551.0
+luke garcia	65569.0
+tom hernandez	65785.0
+mike white	65705.0
+yuri xylophone	65667.0
+holly steinbeck	65613.0
+ulysses quirinius	65617.0
+mike polk	65704.0
+bob underhill	65627.0
+xavier garcia	65662.0
+david garcia	65684.0
+oscar davidson	65646.0
+zach young	65573.0
+zach thompson	65716.0
+calvin ichabod	65635.0
+alice allen	65557.0
+david hernandez	65667.0
+david carson	65702.0
+luke king	65629.0
+mike king	65543.0
+rachel davidson	65728.0
+luke ichabod	65757.0
+luke young	65696.0
+wendy quirinius	65616.0
+victor robinson	65616.0
+jessica miller	65763.0
+bob ichabod	65733.0
+bob falkner	65595.0
+irene underhill	65634.0
+zach zipper	65588.0
+alice underhill	65790.0
+alice xylophone	65715.0
+ethan nixon	65782.0
+katie ovid	65613.0
+bob van buren	65613.0
+yuri hernandez	65657.5
+fred king	65657.5
+nick falkner	65604.0
+sarah steinbeck	65655.0
+david laertes	65655.0
+katie thompson	65582.5
+alice carson	65582.5
+oscar van buren	65595.0
 PREHOOK: query: select max(i) over w from over10k window w as (partition by f) limit 100
 PREHOOK: type: QUERY
 PREHOOK: Input: default@over10k
@@ -471,111 +471,111 @@ POSTHOOK: Input: default@over10k
 65785
 65590
 65740
-PREHOOK: query: select s, avg(d) over (partition by t order by f, b) from over10k limit 100
+PREHOOK: query: select s, avg(d) over (partition by t order by f) from over10k limit 100
 PREHOOK: type: QUERY
 PREHOOK: Input: default@over10k
 #### A masked pattern was here ####
-POSTHOOK: query: select s, avg(d) over (partition by t order by f, b) from over10k limit
100
+POSTHOOK: query: select s, avg(d) over (partition by t order by f) from over10k limit 100
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 #### A masked pattern was here ####
-yuri thompson	25.370202101859327
-bob ichabod	25.370202101859327
-luke king	25.370202101859327
-fred zipper	25.370202101859327
-quinn miller	25.370202101859327
-calvin thompson	25.370202101859327
-holly thompson	25.370202101859327
-nick zipper	25.370202101859327
-victor robinson	25.370202101859327
-zach ovid	25.370202101859327
-ulysses zipper	25.370202101859327
-luke falkner	25.370202101859327
-gabriella robinson	25.370202101859327
-alice robinson	25.370202101859327
-priscilla xylophone	25.370202101859327
-mike underhill	25.370202101859327
-victor van buren	25.370202101859327
-mike steinbeck	25.370202101859327
-yuri davidson	25.370202101859327
-wendy miller	25.370202101859327
-holly allen	25.370202101859327
-quinn brown	25.370202101859327
-calvin ovid	25.370202101859327
-nick miller	25.370202101859327
-mike allen	25.370202101859327
-yuri van buren	25.370202101859327
-zach miller	25.370202101859327
-victor xylophone	25.370202101859327
-rachel ichabod	25.370202101859327
-luke laertes	25.370202101859327
-david hernandez	25.370202101859327
-wendy ichabod	25.370202101859327
-mike brown	25.370202101859327
-yuri brown	25.370202101859327
-bob zipper	25.370202101859327
-sarah robinson	25.370202101859327
-victor hernandez	25.370202101859327
-ulysses johnson	25.370202101859327
-jessica ovid	25.370202101859327
-bob king	25.370202101859327
-irene falkner	25.370202101859327
-holly robinson	25.370202101859327
-yuri white	25.370202101859327
-ethan steinbeck	25.370202101859327
-holly white	25.370202101859327
-nick xylophone	25.370202101859327
-tom thompson	25.370202101859327
-fred van buren	25.370202101859327
-xavier davidson	25.370202101859327
-fred van buren	25.370202101859327
-rachel garcia	25.370202101859327
-oscar young	25.370202101859327
-bob van buren	25.370202101859327
-zach ellison	25.370202101859327
-ulysses laertes	25.370202101859327
-oscar davidson	25.370202101859327
-zach underhill	25.370202101859327
-quinn ovid	25.370202101859327
-oscar thompson	25.370202101859327
-holly quirinius	25.370202101859327
-zach allen	25.370202101859327
-david young	25.370202101859327
-alice garcia	25.370202101859327
-luke ovid	25.370202101859327
-oscar ovid	25.370202101859327
-holly ichabod	25.370202101859327
-jessica robinson	25.370202101859327
-nick van buren	25.370202101859327
-yuri ichabod	25.370202101859327
-irene ichabod	25.370202101859327
-luke quirinius	25.370202101859327
-gabriella davidson	25.370202101859327
-yuri laertes	25.370202101859327
-gabriella hernandez	25.370202101859327
-jessica quirinius	25.370202101859327
-bob xylophone	25.370202101859327
-luke ellison	25.370202101859327
-wendy garcia	25.370202101859327
-calvin laertes	25.370202101859327
-jessica ovid	25.370202101859327
-tom falkner	25.370202101859327
-oscar carson	25.370202101859327
-calvin ichabod	25.370202101859327
-calvin hernandez	25.370202101859327
-victor davidson	25.370202101859327
-bob robinson	25.370202101859327
-irene miller	25.370202101859327
-tom garcia	25.370202101859327
-tom robinson	25.370202101859327
-holly van buren	25.370202101859327
-nick hernandez	25.370202101859327
-priscilla van buren	25.370202101859327
-quinn brown	25.370202101859327
-david ichabod	25.370202101859327
-wendy ovid	25.370202101859327
-ulysses ovid	25.370202101859327
-wendy ichabod	25.370202101859327
-sarah nixon	25.370202101859327
-nick polk	25.370202101859327
-alice brown	25.370202101859327
+rachel thompson	11.96
+oscar davidson	19.57
+mike polk	22.643333333333334
+alice king	24.672500000000003
+luke garcia	26.828000000000003
+luke young	29.035
+bob van buren	25.648571428571433
+ulysses carson	24.712500000000002
+bob ellison	23.742222222222225
+holly underhill	24.645000000000003
+ulysses quirinius	22.532727272727275
+oscar miller	22.8175
+david garcia	21.680769230769233
+zach thompson	20.301428571428573
+wendy xylophone	21.272000000000002
+ethan underhill	21.608750000000004
+bob underhill	22.438823529411767
+zach young	22.509444444444444
+alice falkner	23.94578947368421
+quinn ellison	23.249000000000002
+bob polk	22.426190476190477
+priscilla zipper	22.000909090909094
+priscilla laertes	22.931739130434785
+ulysses steinbeck	23.458750000000006
+bob johnson	23.428800000000006
+nick robinson	22.78461538461539
+wendy quirinius	21.941481481481485
+ulysses robinson	22.58214285714286
+alice xylophone	22.361724137931038
+xavier garcia	22.62333333333334
+xavier ovid	23.0241935483871
+calvin ichabod	22.315312500000005
+ethan steinbeck	22.842121212121217
+david carson	22.20176470588236
+sarah xylophone	21.63685714285715
+victor allen	21.37055555555556
+victor hernandez	21.334324324324328
+oscar garcia	22.05552631578948
+irene ellison	21.707692307692312
+david falkner	22.395500000000006
+jessica johnson	22.20048780487805
+victor thompson	22.123095238095242
+calvin white	22.377441860465122
+oscar johnson	22.59863636363637
+luke king	22.241777777777784
+tom polk	22.498043478260875
+luke ichabod	22.960638297872347
+sarah miller	22.94958333333334
+bob falkner	22.61897959183674
+ulysses ellison	22.326000000000008
+quinn polk	22.701960784313734
+victor robinson	22.73153846153847
+mike white	22.57283018867925
+victor xylophone	22.240370370370375
+alice king	22.59054545454546
+jessica white	22.885357142857146
+priscilla quirinius	23.08105263157895
+holly steinbeck	23.473620689655174
+irene young	23.81813559322034
+yuri xylophone	24.0955
+holly nixon	23.776721311475413
+wendy robinson	23.53016129032258
+alice davidson	23.656984126984128
+nick nixon	23.438281250000003
+bob underhill	23.425076923076926
+bob ichabod	23.349242424242426
+mike king	23.258805970149258
+alice allen	23.349705882352943
+gabriella brown	23.015362318840584
+tom steinbeck	23.387857142857143
+tom hernandez	23.389859154929578
+david hernandez	23.7025
+rachel davidson	24.02356164383562
+mike xylophone	24.119324324324328
+holly polk	23.964133333333336
+mike allen	24.262500000000003
+sarah robinson	24.570779220779226
+holly thompson	24.5474358974359
+jessica miller	24.368987341772154
+katie ichabod	24.476375000000004
+irene underhill	24.525308641975315
+jessica king	24.227195121951222
+oscar johnson	24.24807228915663
+fred ellison	24.47404761904762
+tom hernandez	24.313647058823534
+sarah zipper	24.095813953488374
+ulysses polk	20.12
+nick falkner	33.435
+david falkner	33.43
+wendy ellison	32.5325
+ethan polk	29.6
+tom ichabod	26.988333333333333
+ethan quirinius	25.58857142857143
+alice underhill	23.74125
+mike laertes	22.99888888888889
+zach zipper	20.915
+zach zipper	19.822727272727274
+ulysses king	18.273333333333333
+bob king	17.664615384615384
+luke carson	18.02785714285714

Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/windowing_windowspec.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/windowing_windowspec.q.out?rev=1462322&r1=1462321&r2=1462322&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/windowing_windowspec.q.out
(original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/windowing_windowspec.q.out
Thu Mar 28 21:53:39 2013
@@ -263,106 +263,106 @@ POSTHOOK: query: select s, sum(f) over (
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 #### A masked pattern was here ####
-rachel quirinius	19895.99000313878
-priscilla hernandez	19883.550003558397
-gabriella king	19831.46000340581
-oscar thompson	19779.580002337694
-nick ellison	19738.240002185106
-katie brown	19638.900005847216
-quinn ovid	19561.12000706792
-zach ovid	19498.090008288622
-holly steinbeck	19402.14001134038
-irene falkner	19306.63000920415
-quinn steinbeck	19236.860012561083
-alice garcia	19212.15001347661
-yuri brown	19117.04001286626
-luke young	19099.460012942553
-ethan steinbeck	19061.670012027025
-ulysses hernandez	19027.070013552904
-katie zipper	18943.790014773607
-gabriella white	18906.470015078783
-jessica quirinius	18851.030016452074
-irene brown	18828.090015918016
-bob carson	18792.770016223192
-rachel white	18791.980016201735
-wendy garcia	18700.720014065504
-wendy falkner	18643.470014065504
-tom johnson	18566.110013455153
-quinn johnson	18492.620015591383
-oscar carson	18480.520015209913
-xavier carson	18388.19001337886
-gabriella white	18314.930011242628
-wendy nixon	18284.79001185298
-quinn king	18264.710011929274
-nick van buren	18174.030011624098
-david laertes	18151.870011776686
-david carson	18126.39001223445
-luke hernandez	18028.2500128448
-katie johnson	17984.930013149977
-alice carson	17902.41001650691
-sarah quirinius	17814.630017727613
-calvin ovid	17741.390019863844
-luke young	17695.81001803279
-fred underhill	17638.680016964674
-oscar falkner	17628.5000166595
-fred young	17593.740018337965
-luke nixon	17587.980018109083
-victor miller	17542.490016430616
-mike xylophone	17449.81001612544
-priscilla quirinius	17368.540019482374
-nick ellison	17325.53002116084
-mike hernandez	17314.910021275282
-david miller	17303.820021122694
-rachel king	17234.930021733046
-fred polk	17175.480020970106
-zach van buren	17168.220020741224
-rachel polk	17118.910019367933
-holly ichabod	17089.90001913905
-oscar ichabod	17006.630022495985
-fred polk	16914.780024021864
-jessica robinson	16861.52002570033
-oscar robinson	16850.200026005507
-gabriella johnson	16788.57002493739
-tom allen	16758.86002585292
-rachel allen	16718.350027531385
-sarah falkner	16643.900030583143
-jessica nixon	16603.360029667616
-alice thompson	16595.270029515028
-zach laertes	16497.760027378798
-wendy ichabod	16457.2300285995
-zach allen	16456.640028625727
-jessica allen	16454.520028740168
-sarah thompson	16404.060029655695
-luke laertes	16385.800029426813
-zach polk	16314.160030037165
-victor hernandez	16228.610026985407
-sarah falkner	16154.09003034234
-sarah ovid	16114.79003110528
-xavier carson	16045.060027748346
-holly steinbeck	15960.410026222467
-luke hernandez	15936.680026680231
-ethan brown	15924.840026527643
-david quirinius	15878.480025917292
-gabriella young	15847.92002645135
-sarah quirinius	15763.410024315119
-ethan hernandez	15690.980024009943
-calvin white	15641.200025230646
-sarah ovid	15605.27002492547
-yuri garcia	15551.240026146173
-jessica zipper	15527.97002568841
-holly thompson	15506.450025230646
-ethan nixon	15421.700025230646
-wendy johnson	15383.750024467707
-gabriella zipper	15299.770021110773
-mike laertes	15263.51002278924
-victor miller	15221.910024315119
-jessica davidson	15143.360021263361
-priscilla zipper	15087.350022941828
-katie white	15013.830026298761
-rachel underhill	14974.350026756525
-holly king	14910.660028129816
-priscilla robinson	14855.270028740168
-gabriella king	14834.600028663874
+sarah falkner	1276.850001335144
+mike laertes	1236.3100004196167
+katie white	1194.7100019454956
+priscilla zipper	1194.7100019454956
+fred zipper	1081.7100057601929
+yuri allen	997.0000066757202
+fred nixon	982.220006942749
+wendy steinbeck	953.5300064086914
+nick carson	888.5700073242188
+calvin laertes	797.2100067138672
+jessica polk	766.0400066375732
+calvin brown	671.0000057220459
+david falkner	660.1100053787231
+calvin steinbeck	621.760006904602
+katie king	583.1500062942505
+jessica laertes	490.19000720977783
+rachel thompson	475.6500072479248
+gabriella van buren	475.6500072479248
+victor ellison	309.64000511169434
+gabriella xylophone	263.56000328063965
+oscar brown	260.3900032043457
+luke zipper	231.1700038909912
+tom johnson	176.81000328063965
+rachel garcia	158.96000289916992
+victor van buren	102.02000427246094
+bob ovid	20.610000610351562
+priscilla hernandez	2368.430002987385
+quinn ovid	2316.340002834797
+yuri brown	2253.3100040555
+katie zipper	2235.730004131794
+irene brown	2198.4100044369698
+nick ellison	2163.0900047421455
+jessica robinson	2152.4700048565865
+fred polk	2152.4700048565865
+gabriella johnson	2087.890006840229
+wendy johnson	2058.1800077557564
+jessica brown	1974.2000043988228
+katie xylophone	1895.150001347065
+priscilla zipper	1809.5999982953072
+luke thompson	1762.7599981427193
+rachel ovid	1733.689998447895
+holly thompson	1729.9599984288216
+xavier davidson	1729.9599984288216
+ethan young	1671.4599993824959
+ulysses xylophone	1583.52999907732
+wendy thompson	1568.829999268055
+katie davidson	1553.869999229908
+victor underhill	1472.4599955677986
+calvin carson	1407.9099925160408
+rachel ovid	1331.7799952626228
+zach young	1275.3299944996834
+rachel robinson	1231.0299952626228
+calvin nixon	1210.019995033741
+yuri hernandez	1210.019995033741
+quinn allen	1121.3799956440926
+luke xylophone	1089.439995110035
+ulysses johnson	1032.6799967885017
+jessica nixon	948.4699977040291
+luke steinbeck	868.0399973988533
+rachel young	773.7700007557869
+gabriella steinbeck	724.8800013661385
+oscar davidson	686.3800013661385
+alice miller	685.5500013828278
+bob king	640.8900015354156
+fred king	628.0600016117096
+xavier johnson	628.0600016117096
+gabriella underhill	543.2200031280518
+ethan ovid	454.290002822876
+luke king	435.19000244140625
+jessica brown	366.5699996948242
+bob falkner	334.7299995422363
+oscar van buren	334.7299995422363
+sarah van buren	173.4000015258789
+calvin white	119.31000137329102
+priscilla brown	69.03000259399414
+holly falkner	26.950000762939453
+bob carson	1607.950005441904
+oscar carson	1607.1600054204464
+rachel polk	1514.8300035893917
+sarah falkner	1485.8200033605099
+yuri garcia	1446.5200041234493
+ethan nixon	1423.2500036656857
+victor hernandez	1385.3000029027462
+nick king	1385.3000029027462
+quinn van buren	1385.3000029027462
+victor hernandez	1193.4799989163876
+rachel ichabod	1168.349999755621
+holly allen	1115.910001128912
+priscilla garcia	1115.5500011146069
+rachel davidson	1035.5300044715405
+priscilla thompson	954.2400035560131
+wendy brown	900.140005081892
+alice underhill	811.3100032508373
+holly nixon	785.4000034034252
+jessica thompson	754.9300040900707
+rachel ichabod	698.2300033271313
+wendy falkner	697.7500033378601
+wendy miller	635.6600031852722
+wendy underhill	634.3900032043457
+calvin white	609.0500030517578
 PREHOOK: query: select s, avg(f) over (partition by bin order by s rows between current row
and 5 following) from over10k limit 100
 PREHOOK: type: QUERY
 PREHOOK: Input: default@over10k
@@ -479,214 +479,106 @@ POSTHOOK: query: select s, avg(d) over (
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 #### A masked pattern was here ####
-xavier falkner	23.721666666666664
-david steinbeck	21.97285714285714
-quinn king	23.287499999999998
-tom white	22.472222222222218
-sarah laertes	24.195999999999998
-yuri thompson	23.22181818181818
-gabriella ellison	24.956363636363633
-priscilla white	24.75272727272727
-luke underhill	25.51181818181818
-alice johnson	27.738181818181815
-zach white	28.035454545454545
-quinn nixon	27.28727272727273
-holly johnson	27.58
-zach robinson	27.06090909090909
-xavier polk	27.38
-ulysses falkner	28.222727272727276
-ethan brown	30.021818181818183
-gabriella van buren	28.11
-oscar thompson	31.786363636363635
-irene garcia	30.502727272727274
-holly white	31.639090909090907
-rachel xylophone	32.94272727272727
-irene falkner	33.62454545454545
-ethan steinbeck	34.75181818181818
-tom garcia	36.39090909090909
-fred ichabod	35.152727272727276
-fred zipper	34.806363636363635
-oscar young	35.21
-ulysses underhill	36.36909090909091
-david thompson	36.90090909090909
-zach young	34.775454545454544
-luke ovid	33.24363636363637
-zach zipper	32.74363636363637
-holly hernandez	32.13363636363636
-ulysses ichabod	31.74272727272728
-tom thompson	29.270000000000007
-zach hernandez	32.37727272727273
-ethan carson	29.71272727272727
-gabriella van buren	27.472727272727273
-luke steinbeck	27.20818181818182
-katie laertes	25.99272727272727
-katie king	28.726363636363633
-wendy robinson	29.79909090909091
-rachel miller	27.967272727272725
-irene ichabod	28.66
-jessica ichabod	30.66909090909091
-bob miller	30.35181818181818
-victor young	28.001818181818184
-wendy xylophone	27.936363636363637
-irene polk	30.44727272727273
-xavier xylophone	27.463636363636365
-luke falkner	25.963636363636365
-ethan young	25.215454545454545
-xavier johnson	22.612727272727277
-rachel polk	23.093636363636367
-priscilla van buren	22.483636363636364
-xavier carson	20.85636363636364
-irene steinbeck	22.520909090909093
-xavier xylophone	23.456363636363633
-gabriella ichabod	23.886363636363637
-irene falkner	24.53818181818182
-oscar miller	26.708181818181814
-sarah laertes	26.28181818181819
-victor xylophone	25.453636363636363
-xavier hernandez	25.03454545454546
-priscilla white	24.753636363636364
-bob ichabod	23.797272727272727
-sarah robinson	22.730909090909094
-yuri robinson	22.976363636363637
-fred van buren	22.486363636363635
-quinn quirinius	21.721818181818183
-yuri ellison	19.60181818181818
-rachel thompson	17.292727272727273
-jessica ellison	16.670909090909092
-tom garcia	17.825454545454548
-calvin davidson	17.35727272727273
-irene carson	19.302727272727275
-tom underhill	17.35363636363636
-xavier miller	19.368181818181817
-nick davidson	18.11727272727273
-nick hernandez	18.843636363636367
-gabriella falkner	19.87818181818182
-yuri king	19.399090909090912
-fred allen	20.424545454545456
-ulysses miller	23.327272727272728
-gabriella king	21.463636363636365
-yuri davidson	21.87636363636364
-katie ichabod	21.414545454545454
-gabriella allen	23.37909090909091
-calvin white	20.86272727272727
-oscar nixon	22.824545454545454
-yuri white	20.997272727272726
-victor zipper	20.130000000000003
-victor underhill	22.741818181818182
-tom ovid	22.217272727272732
-ethan nixon	22.959090909090914
-alice ichabod	21.748181818181816
-sarah garcia	20.924545454545452
-oscar van buren	19.526363636363637
-david davidson	18.033636363636365
-PREHOOK: query: select s, avg(f) over (partition by bo order by bin range between unbounded
preceding and current row) from over10k limit 100
-PREHOOK: type: QUERY
-PREHOOK: Input: default@over10k
-#### A masked pattern was here ####
-POSTHOOK: query: select s, avg(f) over (partition by bo order by bin range between unbounded
preceding and current row) from over10k limit 100
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@over10k
-#### A masked pattern was here ####
-tom johnson	43.56999969482422
-alice king	47.89999961853027
-tom zipper	51.31000010172526
-priscilla nixon	54.22749996185303
-irene van buren	54.380000305175784
-nick polk	53.56000010172526
-quinn johnson	52.8957143511091
-tom carson	46.89500004053116
-victor xylophone	49.746666431427
-holly king	53.62700009346008
-ethan underhill	53.98181815580888
-ethan king	56.079166769981384
-bob quirinius	58.5646154330327
-ulysses quirinius	61.08999991416931
-zach ovid	62.223333009084065
-fred laertes	60.793124705553055
-ulysses davidson	59.30411734300501
-nick laertes	56.52166639433967
-alice king	57.1163155154178
-xavier johnson	56.84699971675873
-yuri thompson	54.827618757883705
-ulysses hernandez	52.89954517104409
-yuri steinbeck	51.14217362196549
-sarah thompson	52.13833318154017
-priscilla hernandez	52.1251999092102
-holly underhill	50.365384523685165
-david young	48.93592585457696
-alice steinbeck	48.244285634585786
-fred davidson	49.266896527389
-luke white	48.0383333047231
-jessica nixon	46.71322577999484
-katie polk	47.53406257927418
-irene garcia	46.71818191354925
-alice ovid	47.51264725011938
-alice davidson	48.149428844451904
-victor young	48.188055846426224
-holly brown	48.00729758030659
-yuri polk	47.9731581462057
-bob davidson	47.0905130704244
-zach polk	47.895750319957735
-katie falkner	47.69170759945381
-ulysses garcia	48.67238116264343
-victor young	49.57000012730443
-jessica thompson	48.981818318367004
-nick king	49.86155568228828
-oscar garcia	49.328913180724435
-victor laertes	48.399787365122044
-victor laertes	49.081250141064324
-katie ellison	49.732040979424305
-quinn carson	50.48520014762878
-luke xylophone	50.40235305299946
-sarah ellison	50.68942322180821
-victor robinson	51.309811457148136
-ulysses falkner	51.273889002976595
-rachel falkner	51.28527286702936
-xavier ichabod	50.76125014679773
-katie thompson	50.748245766288356
-bob nixon	50.91913807803187
-xavier ichabod	50.48966116016194
-oscar robinson	51.15100011030833
-yuri falkner	50.42934437267116
-gabriella laertes	49.97870978232353
-sarah quirinius	50.27127000263759
-yuri ovid	50.749687649309635
-katie white	50.512769354306734
-bob allen	50.84106073235021
-david young	50.31701504294552
-katie miller	50.21544129007003
-ethan thompson	50.72550741140393
-zach davidson	50.56057159560067
-david falkner	50.74788749721688
-katie van buren	50.59027796983719
-ethan ellison	50.28904129054448
-holly carson	50.15135152275498
-sarah hernandez	50.007333482106525
-mike hernandez	50.08868433927235
-irene van buren	49.86142870048424
-tom hernandez	49.6783334842095
-katie ovid	50.234303927119775
-luke polk	50.00587511658669
-sarah davidson	49.74111121966515
-gabriella miller	49.21402449724151
-sarah young	49.63867479347321
-sarah young	49.75500009173439
-zach thompson	49.22647067799288
-mike garcia	48.723837298016214
-quinn ovid	48.88827593573208
-ethan underhill	48.66681825030934
-luke carson	48.25955063037658
-victor ovid	48.45844455295139
-holly steinbeck	48.020769339341385
-sarah thompson	48.42826100017714
-bob carson	48.67752701749084
-ethan carson	48.80180865145744
-tom zipper	48.69989486493562
-xavier white	49.22479175527891
-ethan brown	48.79061864577618
-quinn robinson	49.0937755983703
-ulysses quirinius	48.92131322321266
-mike garcia	48.698300099372865
+alice allen	26.85166666666667
+priscilla zipper	26.47857142857143
+oscar miller	29.321250000000003
+jessica johnson	31.596666666666668
+rachel davidson	30.332
+mike xylophone	30.16
+victor robinson	30.48909090909091
+david falkner	30.072727272727274
+alice falkner	31.735454545454548
+victor thompson	34.666363636363634
+irene underhill	30.888181818181817
+calvin white	28.08545454545454
+wendy robinson	30.245454545454546
+luke ichabod	30.201818181818183
+mike allen	26.28818181818182
+sarah zipper	24.572727272727274
+gabriella brown	23.074545454545458
+sarah robinson	21.203636363636367
+oscar garcia	20.433636363636367
+bob falkner	16.83454545454546
+jessica king	14.047272727272725
+rachel thompson	16.774545454545454
+holly polk	20.42727272727273
+wendy quirinius	17.714545454545455
+holly nixon	13.49909090909091
+bob ellison	17.05818181818182
+ulysses steinbeck	21.513636363636365
+yuri xylophone	24.372727272727275
+ulysses carson	27.01090909090909
+zach thompson	27.95909090909091
+david hernandez	31.309090909090912
+tom steinbeck	34.02454545454546
+priscilla laertes	32.46454545454546
+alice king	32.71636363636364
+jessica miller	31.975454545454546
+quinn polk	34.85454545454546
+holly steinbeck	34.307272727272725
+bob ichabod	32.709999999999994
+fred ellison	31.74272727272727
+quinn ellison	31.06363636363636
+priscilla quirinius	31.685454545454547
+ulysses robinson	27.94363636363636
+alice davidson	24.37
+holly underhill	24.76
+tom polk	21.314545454545456
+mike king	23.95909090909091
+calvin ichabod	21.58909090909091
+luke king	20.710000000000004
+bob johnson	20.000000000000004
+bob van buren	20.19
+jessica white	19.713636363636365
+ulysses ellison	18.872727272727275
+xavier garcia	18.97
+zach young	21.62272727272727
+wendy xylophone	21.697272727272725
+mike polk	24.85545454545455
+david garcia	23.35363636363636
+ulysses quirinius	24.449999999999992
+bob underhill	23.74272727272727
+tom hernandez	22.682727272727274
+luke young	22.7
+bob underhill	20.69
+victor hernandez	22.755454545454544
+sarah miller	25.623636363636365
+victor allen	24.8
+xavier ovid	22.758181818181818
+nick robinson	19.535454545454545
+alice king	19.842727272727274
+katie ichabod	19.493636363636366
+ethan underhill	17.997272727272726
+david carson	17.12272727272727
+victor xylophone	16.85545454545455
+oscar johnson	17.233636363636364
+alice xylophone	15.209090909090913
+bob polk	13.514545454545454
+sarah xylophone	15.072727272727274
+oscar johnson	15.853636363636365
+tom hernandez	19.042727272727276
+irene ellison	19.905454545454543
+mike white	20.50181818181818
+irene young	22.430000000000003
+nick nixon	24.43
+ethan steinbeck	23.576666666666668
+luke garcia	25.168750000000003
+holly thompson	27.551428571428573
+oscar davidson	29.75666666666667
+zach johnson	28.561666666666667
+alice nixon	25.732857142857142
+sarah van buren	23.74
+rachel thompson	24.32222222222222
+jessica white	26.415999999999997
+rachel polk	26.687272727272724
+fred ichabod	27.236363636363635
+irene ichabod	24.90909090909091
+fred polk	25.44181818181818
+quinn carson	23.25909090909091
+sarah allen	22.62727272727273
+jessica steinbeck	24.30636363636364
+ethan nixon	25.035454545454545
+jessica zipper	25.474545454545456
 PREHOOK: query: select s, sum(i) over() from over10k limit 100
 PREHOOK: type: QUERY
 PREHOOK: Input: default@over10k
@@ -803,67 +695,67 @@ POSTHOOK: query: select f, sum(f) over (
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 #### A masked pattern was here ####
-0.01	0.009999999776482582
 0.01	0.019999999552965164
-0.02	0.03999999910593033
-0.02	0.05999999865889549
+0.01	0.019999999552965164
+0.02	0.07999999821186066
 0.02	0.07999999821186066
-0.03	0.1099999975413084
+0.02	0.07999999821186066
+0.03	0.13999999687075615
 0.03	0.13999999687075615
 0.04	0.17999999597668648
 0.05	0.22999999672174454
-0.07	0.29999999701976776
 0.07	0.369999997317791
-0.08	0.44999999552965164
-0.08	0.5299999937415123
+0.07	0.369999997317791
+0.08	0.609999991953373
+0.08	0.609999991953373
 0.08	0.609999991953373
-0.09	0.6999999955296516
+0.09	0.7899999991059303
 0.09	0.7899999991059303
 0.1	0.8900000005960464
 0.11	1.0
-0.12	1.119999997317791
+0.12	1.239999994635582
 0.12	1.239999994635582
 0.13	1.3699999898672104
-0.14	1.5099999904632568
 0.14	1.6499999910593033
-0.15	1.7999999970197678
+0.14	1.6499999910593033
+0.15	1.9500000029802322
 0.15	1.9500000029802322
-0.16	2.1099999994039536
+0.16	2.269999995827675
 0.16	2.269999995827675
 0.17	2.439999997615814
 0.18	2.6200000047683716
 0.19	2.810000002384186
-0.2	3.010000005364418
 0.2	3.2100000083446503
-0.23	3.4400000125169754
-0.23	3.6700000166893005
+0.2	3.2100000083446503
+0.23	3.9000000208616257
 0.23	3.9000000208616257
-0.27	4.170000031590462
-0.27	4.440000042319298
+0.23	3.9000000208616257
+0.27	4.710000053048134
+0.27	4.710000053048134
 0.27	4.710000053048134
-0.28	4.990000054240227
+0.28	5.27000005543232
 0.28	5.27000005543232
 0.29	5.560000047087669
 0.31	5.870000049471855
 0.32	6.190000042319298
 0.35	6.540000036358833
-0.36	6.900000050663948
+0.36	7.260000064969063
 0.36	7.260000064969063
 0.37	7.630000069737434
-0.39	8.02000005543232
+0.39	8.410000041127205
 0.39	8.410000041127205
 0.42	8.830000028014183
-0.43	9.26000003516674
-0.43	9.690000042319298
 0.43	10.120000049471855
-0.44	10.56000004708767
+0.43	10.120000049471855
+0.43	10.120000049471855
+0.44	11.000000044703484
 0.44	11.000000044703484
 0.48	11.480000033974648
-0.5	11.980000033974648
+0.5	12.480000033974648
 0.5	12.480000033974648
 0.51	12.990000024437904
-0.52	13.510000005364418
-0.52	14.029999986290932
+0.52	14.549999967217445
+0.52	14.549999967217445
 0.52	14.549999967217445
 0.53	15.079999938607216
 0.54	15.619999960064888
@@ -874,26 +766,26 @@ POSTHOOK: Input: default@over10k
 0.59	18.4699999243021
 0.6	19.06999994814396
 0.61	19.679999962449074
-0.62	20.299999967217445
-0.62	20.919999971985817
+0.62	21.53999997675419
+0.62	21.53999997675419
 0.62	21.53999997675419
 0.67	22.20999999344349
-0.68	22.890000000596046
 0.68	23.570000007748604
-0.69	24.260000005364418
+0.68	23.570000007748604
+0.69	24.950000002980232
 0.69	24.950000002980232
 0.71	25.65999998152256
 0.75	26.40999998152256
 0.76	27.169999971985817
 0.77	27.93999995291233
 0.78	28.7199999243021
-0.79	29.509999945759773
-0.79	30.299999967217445
+0.79	31.089999988675117
+0.79	31.089999988675117
 0.79	31.089999988675117
 0.8	31.890000000596046
 0.82	32.70999999344349
 0.83	33.53999997675419
-0.84	34.379999950528145
+0.84	35.2199999243021
 0.84	35.2199999243021
 0.85	36.06999994814396
 0.87	36.93999995291233



Mime
View raw message