| PREHOOK: query: drop table over10k_n4 |
| PREHOOK: type: DROPTABLE |
| POSTHOOK: query: drop table over10k_n4 |
| POSTHOOK: type: DROPTABLE |
| PREHOOK: query: create table over10k_n4( |
| 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 |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@over10k_n4 |
| POSTHOOK: query: create table over10k_n4( |
| 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: database:default |
| POSTHOOK: Output: default@over10k_n4 |
| PREHOOK: query: load data local inpath '../../data/files/over10k' into table over10k_n4 |
| PREHOOK: type: LOAD |
| #### A masked pattern was here #### |
| PREHOOK: Output: default@over10k_n4 |
| POSTHOOK: query: load data local inpath '../../data/files/over10k' into table over10k_n4 |
| POSTHOOK: type: LOAD |
| #### A masked pattern was here #### |
| POSTHOOK: Output: default@over10k_n4 |
| PREHOOK: query: select s, min(i) over (partition by s) from over10k_n4 limit 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@over10k_n4 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select s, min(i) over (partition by s) from over10k_n4 limit 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@over10k_n4 |
| #### 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_n4 limit 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@over10k_n4 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select s, avg(f) over (partition by si order by s) from over10k_n4 limit 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@over10k_n4 |
| #### 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_n4 limit 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@over10k_n4 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select s, avg(i) over (partition by t, b order by s) from over10k_n4 limit 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@over10k_n4 |
| #### 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_n4 window w as (partition by f) limit 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@over10k_n4 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select max(i) over w from over10k_n4 window w as (partition by f) limit 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@over10k_n4 |
| #### 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_n4 limit 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@over10k_n4 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select s, avg(d) over (partition by t order by f) from over10k_n4 limit 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@over10k_n4 |
| #### 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 |
| PREHOOK: query: select key, max(value) over |
| (order by key rows between 10 preceding and 20 following) |
| from src1 where length(key) > 10 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src1 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select key, max(value) over |
| (order by key rows between 10 preceding and 20 following) |
| from src1 where length(key) > 10 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src1 |
| #### A masked pattern was here #### |