You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2013/03/28 22:53:40 UTC
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...
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