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, rank() over (partition by s order by si), sum(b) over (partition by s order by si) from over10k limit 100 PREHOOK: type: QUERY PREHOOK: Input: default@over10k #### A masked pattern was here #### POSTHOOK: query: select s, rank() over (partition by s order by si), sum(b) over (partition by s order by si) from over10k limit 100 POSTHOOK: type: QUERY POSTHOOK: Input: default@over10k #### A masked pattern was here #### alice allen 1 4294967503 alice allen 2 8589934990 alice allen 3 12884902428 alice allen 4 17179869743 alice allen 5 21474837237 alice allen 6 30064772191 alice allen 6 30064772191 alice allen 8 34359739722 alice brown 1 4294967391 alice brown 2 8589934706 alice brown 3 12884902122 alice brown 4 17179869504 alice brown 5 21474836859 alice brown 6 25769804175 alice brown 7 30064771680 alice brown 8 34359739221 alice brown 9 38654706641 alice brown 10 42949674011 alice brown 11 47244641313 alice brown 12 51539608718 alice brown 13 55834576122 alice brown 14 60129543595 alice carson 1 4294967446 alice carson 2 8589934775 alice carson 3 12884902150 alice carson 4 17179869461 alice carson 5 21474836824 alice carson 6 25769804187 alice carson 7 30064771550 alice carson 8 34359738920 alice carson 9 38654706240 alice carson 10 42949673743 alice davidson 1 4294967453 alice davidson 2 8589934978 alice davidson 3 12884902338 alice davidson 4 17179869653 alice davidson 5 21474836975 alice davidson 6 25769804493 alice davidson 7 30064772010 alice davidson 8 34359739463 alice davidson 9 38654706943 alice davidson 10 47244641824 alice davidson 10 47244641824 alice davidson 12 51539609264 alice davidson 13 55834576590 alice davidson 14 60129544020 alice davidson 15 64424511548 alice davidson 16 68719479029 alice davidson 17 73014446462 alice davidson 18 77309413954 alice ellison 1 4294967496 alice ellison 2 8589934942 alice ellison 3 12884902454 alice ellison 4 17179869870 alice ellison 5 21474837181 alice ellison 6 25769804587 alice ellison 7 30064772066 alice ellison 8 34359739616 alice ellison 9 38654706933 alice ellison 10 42949674421 alice ellison 11 47244641904 alice ellison 12 51539609208 alice ellison 13 55834576596 alice ellison 14 60129544054 alice ellison 15 64424511508 alice falkner 1 4294967377 alice falkner 2 8589934805 alice falkner 3 12884902121 alice falkner 4 17179869431 alice falkner 5 21474836879 alice falkner 6 25769804283 alice falkner 7 30064771719 alice falkner 8 38654706491 alice falkner 8 38654706491 alice falkner 10 42949673903 alice falkner 11 51539608896 alice falkner 11 51539608896 alice falkner 13 55834576336 alice falkner 14 60129543752 alice falkner 15 64424511125 alice falkner 16 68719478658 alice falkner 17 73014445956 alice garcia 1 4294967303 alice garcia 2 8589934839 alice garcia 3 12884902276 alice garcia 4 17179869705 alice garcia 5 21474837050 alice garcia 6 25769804353 alice garcia 7 30064771681 alice garcia 8 34359739213 alice garcia 9 38654706564 alice garcia 10 47244641402 alice garcia 10 47244641402 alice garcia 12 51539608899 alice garcia 13 55834576425 alice hernandez 1 4294967345 alice hernandez 2 8589934782 alice hernandez 3 12884902197 alice hernandez 4 17179869695 alice hernandez 5 21474837123 PREHOOK: query: select s, rank() over (partition by s order by dec desc), sum(b) over (partition by s order by ts desc) from over10k where s = 'tom allen' or s = 'bob steinbeck' PREHOOK: type: QUERY PREHOOK: Input: default@over10k #### A masked pattern was here #### POSTHOOK: query: select s, rank() over (partition by s order by dec desc), sum(b) over (partition by s order by ts desc) from over10k where s = 'tom allen' or s = 'bob steinbeck' POSTHOOK: type: QUERY POSTHOOK: Input: default@over10k #### A masked pattern was here #### bob steinbeck 11 47244642041 bob steinbeck 1 47244642041 bob steinbeck 2 47244642041 bob steinbeck 7 47244642041 bob steinbeck 8 47244642041 bob steinbeck 9 47244642041 bob steinbeck 6 47244642041 bob steinbeck 10 47244642041 bob steinbeck 3 47244642041 bob steinbeck 4 47244642041 bob steinbeck 5 47244642041 tom allen 9 81604381169 tom allen 3 81604381169 tom allen 7 81604381169 tom allen 16 81604381169 tom allen 8 81604381169 tom allen 10 81604381169 tom allen 15 81604381169 tom allen 2 81604381169 tom allen 6 81604381169 tom allen 18 81604381169 tom allen 1 81604381169 tom allen 5 81604381169 tom allen 19 81604381169 tom allen 17 81604381169 tom allen 11 81604381169 tom allen 4 81604381169 tom allen 12 81604381169 tom allen 13 81604381169 tom allen 14 81604381169 PREHOOK: query: select s, sum(i) over (partition by s), sum(f) over (partition by si) from over10k where s = 'tom allen' or s = 'bob steinbeck' PREHOOK: type: QUERY PREHOOK: Input: default@over10k #### A masked pattern was here #### POSTHOOK: query: select s, sum(i) over (partition by s), sum(f) over (partition by si) from over10k where s = 'tom allen' or s = 'bob steinbeck' POSTHOOK: type: QUERY POSTHOOK: Input: default@over10k #### A masked pattern was here #### tom allen 1248023 47.16999816894531 tom allen 1248023 77.77999877929688 tom allen 1248023 11.069999694824219 bob steinbeck 722083 83.52999877929688 bob steinbeck 722083 38.33000183105469 bob steinbeck 722083 28.479999542236328 tom allen 1248023 2.8499999046325684 tom allen 1248023 19.459999084472656 bob steinbeck 722083 26.290000915527344 tom allen 1248023 26.239999771118164 bob steinbeck 722083 36.209999084472656 tom allen 1248023 95.41000366210938 tom allen 1248023 89.88999938964844 tom allen 1248023 14.510000228881836 bob steinbeck 722083 83.52999877929688 tom allen 1248023 38.93000030517578 tom allen 1248023 83.47000122070312 tom allen 1248023 81.8499984741211 bob steinbeck 722083 47.810001373291016 tom allen 1248023 15.84000015258789 tom allen 1248023 52.779998779296875 tom allen 1248023 39.4900016784668 bob steinbeck 722083 80.7300033569336 tom allen 1248023 11.300000190734863 tom allen 1248023 68.46999740600586 bob steinbeck 722083 68.46999740600586 bob steinbeck 722083 9.699999809265137 tom allen 1248023 55.38999938964844 bob steinbeck 722083 132.82000350952148 tom allen 1248023 132.82000350952148 PREHOOK: query: select s, rank() over (partition by s order by bo), rank() over (partition by si order by bin desc) from over10k where s = 'tom allen' or s = 'bob steinbeck' PREHOOK: type: QUERY PREHOOK: Input: default@over10k #### A masked pattern was here #### POSTHOOK: query: select s, rank() over (partition by s order by bo), rank() over (partition by si order by bin desc) from over10k where s = 'tom allen' or s = 'bob steinbeck' POSTHOOK: type: QUERY POSTHOOK: Input: default@over10k #### A masked pattern was here #### tom allen 1 1 tom allen 1 1 tom allen 7 1 bob steinbeck 1 1 bob steinbeck 5 1 bob steinbeck 5 1 tom allen 7 1 tom allen 1 1 bob steinbeck 5 1 tom allen 1 1 bob steinbeck 1 1 tom allen 7 1 tom allen 1 1 tom allen 7 1 bob steinbeck 5 1 tom allen 7 1 tom allen 7 1 tom allen 7 1 bob steinbeck 5 1 tom allen 7 1 tom allen 7 1 tom allen 7 1 bob steinbeck 5 1 tom allen 7 1 tom allen 7 1 bob steinbeck 1 2 bob steinbeck 5 1 tom allen 1 1 bob steinbeck 1 1 tom allen 7 2 PREHOOK: query: select s, sum(f) over (partition by i), row_number() over (order by f) from over10k where s = 'tom allen' or s = 'bob steinbeck' PREHOOK: type: QUERY PREHOOK: Input: default@over10k #### A masked pattern was here #### POSTHOOK: query: select s, sum(f) over (partition by i), row_number() over (order by f) from over10k where s = 'tom allen' or s = 'bob steinbeck' POSTHOOK: type: QUERY POSTHOOK: Input: default@over10k #### A masked pattern was here #### tom allen 2.8499999046325684 1 bob steinbeck 9.699999809265137 2 tom allen 11.069999694824219 3 tom allen 11.300000190734863 4 tom allen 54.00000190734863 5 tom allen 15.84000015258789 6 tom allen 19.459999084472656 7 tom allen 26.239999771118164 8 bob steinbeck 26.290000915527344 9 bob steinbeck 27.959999084472656 10 bob steinbeck 28.479999542236328 11 bob steinbeck 36.209999084472656 12 bob steinbeck 38.33000183105469 13 tom allen 38.93000030517578 14 tom allen 54.00000190734863 15 tom allen 40.5099983215332 16 tom allen 47.16999816894531 17 bob steinbeck 47.810001373291016 18 tom allen 50.630001068115234 19 tom allen 52.779998779296875 20 tom allen 55.38999938964844 21 tom allen 77.77999877929688 22 bob steinbeck 80.7300033569336 23 tom allen 81.8499984741211 24 bob steinbeck 82.19000244140625 25 tom allen 83.47000122070312 26 bob steinbeck 83.52999877929688 27 bob steinbeck 83.52999877929688 28 tom allen 89.88999938964844 29 tom allen 95.41000366210938 30 PREHOOK: query: select s, rank() over w1, rank() over w2 from over10k where s = 'tom allen' or s = 'bob steinbeck' window w1 as (partition by s order by dec), w2 as (partition by si order by f) PREHOOK: type: QUERY PREHOOK: Input: default@over10k #### A masked pattern was here #### POSTHOOK: query: select s, rank() over w1, rank() over w2 from over10k where s = 'tom allen' or s = 'bob steinbeck' window w1 as (partition by s order by dec), w2 as (partition by si order by f) POSTHOOK: type: QUERY POSTHOOK: Input: default@over10k #### A masked pattern was here #### tom allen 14 1 tom allen 17 1 tom allen 7 1 bob steinbeck 1 1 bob steinbeck 11 1 bob steinbeck 7 1 tom allen 12 1 tom allen 15 1 bob steinbeck 10 1 tom allen 13 1 bob steinbeck 5 1 tom allen 11 1 tom allen 2 1 tom allen 9 1 bob steinbeck 8 1 tom allen 3 1 tom allen 4 1 tom allen 8 1 bob steinbeck 3 1 tom allen 10 1 tom allen 18 1 tom allen 19 1 bob steinbeck 6 1 tom allen 5 1 bob steinbeck 9 1 tom allen 6 2 bob steinbeck 4 1 tom allen 16 1 tom allen 1 1 bob steinbeck 2 2