PREHOOK: query: drop table over10k PREHOOK: type: DROPTABLE POSTHOOK: query: drop table over10k POSTHOOK: type: DROPTABLE PREHOOK: query: create table over10k( t tinyint, si smallint, i int, b bigint, f float, d double, bo boolean, s string, ts timestamp, dec decimal, bin binary) row format delimited fields terminated by '|' PREHOOK: type: CREATETABLE POSTHOOK: query: create table over10k( t tinyint, si smallint, i int, b bigint, f float, d double, bo boolean, s string, ts timestamp, dec decimal, bin binary) row format delimited fields terminated by '|' POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@over10k PREHOOK: query: load data local inpath '../data/files/over10k' into table over10k PREHOOK: type: LOAD PREHOOK: Output: default@over10k POSTHOOK: query: load data local inpath '../data/files/over10k' into table over10k POSTHOOK: type: LOAD POSTHOOK: Output: default@over10k PREHOOK: query: select s, min(i) over (partition by s) from over10k limit 100 PREHOOK: type: QUERY PREHOOK: Input: default@over10k #### A masked pattern was here #### POSTHOOK: query: select s, min(i) over (partition by s) from over10k limit 100 POSTHOOK: type: QUERY POSTHOOK: Input: default@over10k #### A masked pattern was here #### alice allen 65545 alice allen 65545 alice allen 65545 alice allen 65545 alice allen 65545 alice allen 65545 alice allen 65545 alice allen 65545 alice brown 65569 alice brown 65569 alice brown 65569 alice brown 65569 alice brown 65569 alice brown 65569 alice brown 65569 alice brown 65569 alice brown 65569 alice brown 65569 alice brown 65569 alice brown 65569 alice brown 65569 alice brown 65569 alice carson 65545 alice carson 65545 alice carson 65545 alice carson 65545 alice carson 65545 alice carson 65545 alice carson 65545 alice carson 65545 alice carson 65545 alice carson 65545 alice davidson 65544 alice davidson 65544 alice davidson 65544 alice davidson 65544 alice davidson 65544 alice davidson 65544 alice davidson 65544 alice davidson 65544 alice davidson 65544 alice davidson 65544 alice davidson 65544 alice davidson 65544 alice davidson 65544 alice davidson 65544 alice davidson 65544 alice davidson 65544 alice davidson 65544 alice davidson 65544 alice ellison 65537 alice ellison 65537 alice ellison 65537 alice ellison 65537 alice ellison 65537 alice ellison 65537 alice ellison 65537 alice ellison 65537 alice ellison 65537 alice ellison 65537 alice ellison 65537 alice ellison 65537 alice ellison 65537 alice ellison 65537 alice ellison 65537 alice falkner 65596 alice falkner 65596 alice falkner 65596 alice falkner 65596 alice falkner 65596 alice falkner 65596 alice falkner 65596 alice falkner 65596 alice falkner 65596 alice falkner 65596 alice falkner 65596 alice falkner 65596 alice falkner 65596 alice falkner 65596 alice falkner 65596 alice falkner 65596 alice falkner 65596 alice garcia 65573 alice garcia 65573 alice garcia 65573 alice garcia 65573 alice garcia 65573 alice garcia 65573 alice garcia 65573 alice garcia 65573 alice garcia 65573 alice garcia 65573 alice garcia 65573 alice garcia 65573 alice garcia 65573 alice hernandez 65543 alice hernandez 65543 alice hernandez 65543 alice hernandez 65543 alice hernandez 65543 PREHOOK: query: select s, avg(f) over (partition by si order by s) 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 si order by s) from over10k limit 100 POSTHOOK: type: QUERY POSTHOOK: Input: default@over10k #### A masked pattern was here #### alice ellison 38.15999984741211 alice ovid 57.26999855041504 alice robinson 61.9533322652181 calvin johnson 48.489999294281006 calvin young 57.602000045776364 david davidson 60.36000029246012 ethan falkner 53.59000028882708 ethan thompson 50.917500138282776 fred hernandez 45.63555569118924 fred quirinius 45.169000244140626 gabriella falkner 44.16181841763583 holly xylophone 42.55583349863688 irene polk 46.413846236008865 nick zipper 49.762142998831614 oscar steinbeck 50.098000081380206 quinn hernandez 52.19624996185303 quinn quirinius 51.01882351146025 rachel ellison 48.684444427490234 rachel ovid 47.271052611501595 sarah brown 49.46350011825562 sarah white 48.66238103594099 tom allen 48.59454545107755 ulysses white 48.839565194171406 ulysses young 47.483333349227905 victor davidson 45.79800001144409 victor hernandez 46.39076920656058 victor johnson 45.437777748814334 victor robinson 46.12964274202074 victor thompson 47.65344815418638 wendy garcia 47.7129998366038 wendy nixon 49.234193478861165 xavier ovid 49.311874970793724 xavier quirinius 50.531212185368396 xavier van buren 51.34705878706539 zach nixon 50.55771423067365 zach underhill 50.889999959203934 zach white 51.42081073812536 alice underhill 17.329999923706055 alice xylophone 57.66499996185303 david brown 65.36333401997884 ethan king 68.81000089645386 ethan polk 73.13600120544433 ethan underhill 76.83833408355713 fred brown 79.57714380536761 fred zipper 72.68500089645386 gabriella ellison 68.5955564710829 holly robinson 69.57500076293945 holly white 67.0809097290039 irene young 63.535833994547524 jessica laertes 62.61846219576322 katie garcia 59.8014292035784 katie ichabod 59.41533381144206 luke falkner 57.51437544822693 luke quirinius 56.508823843563306 mike underhill 54.72500027550591 nick davidson 54.44210544385408 nick quirinius 55.77850008010864 nick zipper 57.73428571791876 oscar laertes 55.53090910478072 oscar thompson 53.169130449709684 oscar young 53.24833333492279 priscilla laertes 53.86000003814697 priscilla miller 52.379230792705826 priscilla thompson 50.80222225189209 rachel robinson 51.162142923900056 sarah hernandez 49.505517301888304 ulysses young 48.93933340708415 victor xylophone 49.34774195763372 wendy brown 49.7678125500679 xavier brown 49.81303030071837 yuri brown 49.74735299278708 yuri nixon 49.86571431841169 zach hernandez 49.37763158898605 zach hernandez 49.37763158898605 zach hernandez 49.37763158898605 zach underhill 50.13846162649301 zach zipper 51.274500131607056 alice nixon 31.255000591278076 alice nixon 31.255000591278076 bob falkner 51.356666247049965 calvin davidson 39.96249973773956 calvin johnson 32.491999769210814 calvin steinbeck 29.613333185513813 david garcia 34.99428541319711 fred king 40.516249507665634 gabriella young 39.50888853602939 holly johnson 40.59399974346161 irene quirinius 43.26727249405601 jessica falkner 42.47249974807104 jessica ichabod 42.86076903343201 jessica laertes 44.109285541943144 katie allen 47.71466666857402 luke ovid 50.293125078082085 mike underhill 50.38294123200809 nick falkner 52.106666922569275 nick king 54.01842131112751 nick xylophone 54.5635001540184 oscar van buren 55.146666697093416 priscilla underhill 56.049545580690555 priscilla zipper 55.24625018239021 PREHOOK: query: select s, avg(i) over (partition by t, b order by s) from over10k limit 100 PREHOOK: type: QUERY PREHOOK: Input: default@over10k #### A masked pattern was here #### POSTHOOK: query: select s, avg(i) over (partition by t, b order by s) from over10k limit 100 POSTHOOK: type: QUERY POSTHOOK: Input: default@over10k #### A masked pattern was here #### oscar miller 65773.0 bob underhill 65735.0 tom polk 65743.5 wendy robinson 65622.0 alice king 65570.0 ethan steinbeck 65720.0 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 65751.0 irene young 65715.0 sarah miller 65680.33333333333 nick nixon 65696.0 tom steinbeck 65608.0 calvin white 65548.0 oscar johnson 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 priscilla quirinius 65646.0 ulysses carson 65714.5 victor thompson 65728.33333333333 ulysses ellison 65640.0 bob johnson 65731.0 quinn ellison 65736.0 bob polk 65776.0 victor xylophone 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 nick robinson 65566.0 sarah robinson 65605.0 tom hernandez 65575.0 alice xylophone 65661.0 sarah xylophone 65618.0 priscilla laertes 65696.0 holly polk 65710.0 katie ichabod 65577.0 holly underhill 65553.0 alice davidson 65676.0 ethan underhill 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 victor robinson 65571.0 wendy quirinius 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 bob van buren 65582.0 katie ovid 65613.0 fred king 65712.0 yuri hernandez 65657.5 nick falkner 65604.0 david laertes 65612.0 sarah steinbeck 65655.0 alice carson 65565.0 katie thompson 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 #### A masked pattern was here #### POSTHOOK: query: select max(i) over w from over10k window w as (partition by f) limit 100 POSTHOOK: type: QUERY POSTHOOK: Input: default@over10k #### A masked pattern was here #### 65774 65774 65786 65786 65786 65738 65738 65695 65584 65774 65774 65743 65743 65743 65654 65654 65750 65743 65722 65722 65712 65696 65696 65763 65763 65733 65733 65764 65718 65604 65754 65754 65683 65683 65683 65776 65776 65776 65744 65744 65595 65738 65670 65658 65777 65777 65704 65710 65710 65612 65600 65600 65600 65780 65780 65752 65752 65752 65580 65787 65787 65787 65618 65778 65592 65733 65645 65788 65617 65736 65782 65676 65676 65676 65648 65782 65782 65782 65782 65604 65756 65751 65546 65771 65756 65756 65756 65791 65555 65646 65726 65726 65540 65759 65573 65630 65545 65785 65590 65740 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) from over10k limit 100 POSTHOOK: type: QUERY POSTHOOK: Input: default@over10k #### A masked pattern was here #### 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