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(4,2), bin binary) row format delimited fields terminated by '|' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@over10k 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(4,2), bin binary) row format delimited fields terminated by '|' POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@over10k PREHOOK: query: load data local inpath '../../data/files/over10k' into table over10k PREHOOK: type: LOAD #### A masked pattern was here #### PREHOOK: Output: default@over10k POSTHOOK: query: load data local inpath '../../data/files/over10k' into table over10k POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: default@over10k PREHOOK: query: select s, row_number() over (partition by d order by dec) from over10k limit 100 PREHOOK: type: QUERY PREHOOK: Input: default@over10k #### A masked pattern was here #### POSTHOOK: query: select s, row_number() over (partition by d order by dec) from over10k limit 100 POSTHOOK: type: QUERY POSTHOOK: Input: default@over10k #### A masked pattern was here #### calvin miller 1 yuri laertes 1 wendy quirinius 2 holly polk 3 nick steinbeck 1 tom young 1 priscilla quirinius 2 katie brown 3 xavier robinson 1 gabriella quirinius 2 katie falkner 3 ethan carson 1 victor johnson 2 zach white 1 jessica white 2 jessica king 3 victor davidson 1 quinn falkner 2 holly falkner 3 holly young 1 xavier steinbeck 1 nick robinson 2 irene king 1 quinn zipper 1 priscilla miller 1 yuri miller 2 wendy zipper 3 zach steinbeck 1 fred nixon 1 katie brown 1 nick davidson 1 gabriella davidson 1 zach carson 2 wendy king 1 tom xylophone 2 holly hernandez 3 jessica quirinius 4 gabriella brown 1 quinn johnson 2 yuri zipper 3 david robinson 1 mike nixon 2 rachel davidson 1 gabriella white 2 yuri garcia 1 yuri zipper 2 katie hernandez 1 alice king 2 jessica steinbeck 3 quinn davidson 1 katie ovid 2 priscilla young 3 quinn van buren 4 victor steinbeck 5 gabriella brown 1 zach laertes 1 jessica ichabod 2 ethan miller 1 irene carson 2 priscilla zipper 3 irene falkner 4 tom robinson 5 katie polk 1 xavier laertes 2 sarah davidson 3 nick white 4 nick polk 1 alice ichabod 2 luke brown 1 wendy allen 2 gabriella robinson 3 holly steinbeck 1 calvin ichabod 2 holly van buren 1 tom nixon 2 gabriella carson 3 mike brown 1 katie laertes 2 zach garcia 1 oscar nixon 2 tom polk 1 mike allen 1 alice johnson 1 yuri young 1 holly robinson 2 priscilla thompson 3 rachel carson 1 gabriella laertes 1 victor brown 2 holly allen 1 bob carson 2 rachel carson 1 fred nixon 2 priscilla brown 1 alice nixon 2 victor falkner 1 david garcia 1 holly hernandez 2 tom white 3 rachel ellison 1 PREHOOK: query: select i, lead(s) over (partition by bin order by d,i desc) from over10k limit 100 PREHOOK: type: QUERY PREHOOK: Input: default@over10k #### A masked pattern was here #### POSTHOOK: query: select i, lead(s) over (partition by bin order by d,i desc) from over10k limit 100 POSTHOOK: type: QUERY POSTHOOK: Input: default@over10k #### A masked pattern was here #### 65773 gabriella van buren 65727 quinn steinbeck 65649 katie laertes 65643 luke young 65712 xavier white 65554 oscar garcia 65715 katie ichabod 65737 mike garcia 65641 katie thompson 65674 zach falkner 65627 katie ovid 65628 irene davidson 65657 wendy van buren 65686 yuri ichabod 65594 ethan underhill 65615 zach young 65708 calvin falkner 65674 nick xylophone 65717 tom hernandez 65713 tom ichabod 65681 priscilla ichabod 65654 victor laertes 65580 victor van buren 65711 holly xylophone 65727 david garcia 65692 yuri ovid 65760 oscar xylophone 65545 luke falkner 65653 alice falkner 65773 jessica robinson 65756 fred davidson 65698 tom hernandez 65659 irene ellison 65662 holly robinson 65610 mike garcia 65537 yuri hernandez 65601 ulysses garcia 65545 mike brown 65538 ethan nixon 65551 yuri falkner 65709 rachel robinson 65774 yuri polk 65713 yuri nixon 65613 sarah thompson 65693 nick nixon 65650 ethan carson 65781 oscar king 65675 priscilla ichabod 65541 jessica thompson 65719 mike polk 65694 luke brown 65538 victor young 65746 oscar nixon 65564 tom zipper 65708 irene ellison 65696 alice davidson 65596 jessica garcia 65586 victor miller 65696 holly white 65600 david robinson 65785 jessica davidson 65606 ulysses brown 65734 ethan underhill 65546 ethan miller 65578 tom thompson 65776 holly steinbeck 65741 yuri underhill 65770 priscilla king 65562 bob white 65605 victor van buren 65764 bob allen 65725 david underhill 65700 holly king 65648 victor ovid 65733 priscilla xylophone 65682 katie miller 65694 victor xylophone 65553 mike steinbeck 65635 holly laertes 65537 katie steinbeck 65761 zach white 65747 ethan falkner 65601 ulysses king 65590 rachel davidson 65732 irene young 65642 bob thompson 65570 tom xylophone 65692 sarah davidson 65760 tom laertes 65784 yuri johnson 65630 zach laertes 65774 nick polk 65788 quinn xylophone 65595 yuri white 65765 xavier ellison 65541 jessica ichabod 65711 tom steinbeck 65536 alice hernandez 65545 tom zipper 65789 ulysses hernandez PREHOOK: query: select i, lag(dec) over (partition by i order by s,i,dec) from over10k limit 100 PREHOOK: type: QUERY PREHOOK: Input: default@over10k #### A masked pattern was here #### POSTHOOK: query: select i, lag(dec) over (partition by i order by s,i,dec) from over10k limit 100 POSTHOOK: type: QUERY POSTHOOK: Input: default@over10k #### A masked pattern was here #### 65536 NULL 65536 31.09 65536 1.33 65536 86.04 65536 52.78 65536 93.68 65536 98.42 65536 0.93 65536 83.48 65536 75.7 65536 88.04 65536 94.09 65536 33.45 65536 44.41 65536 22.15 65536 20.5 65536 58.86 65536 30.91 65536 74.47 65536 11.31 65536 59.67 65536 63.08 65536 5.53 65536 95.99 65536 59.58 65536 32.68 65536 16.85 65536 4.34 65536 28.49 65536 80.26 65536 35.07 65536 95.88 65536 30.6 65536 46.97 65536 58.8 65536 5.72 65536 29.27 65536 62.25 65536 45.25 65536 85.25 65536 30.25 65536 65.17 65536 1.05 65536 39.32 65536 32.03 65537 NULL 65537 14.48 65537 95.64 65537 4.49 65537 11.87 65537 89.52 65537 56.83 65537 99.34 65537 7.72 65537 94.52 65537 35.86 65537 47.75 65537 1.12 65537 52.9 65537 53.92 65537 43.45 65537 7.52 65537 91.35 65537 56.13 65537 51.91 65537 81.04 65537 19.44 65537 8.63 65537 29.01 65537 56.48 65537 83.21 65537 56.52 65537 36.6 65537 59.7 65537 80.14 65537 66.3 65537 94.87 65537 40.92 65537 25.2 65537 7.36 65538 NULL 65538 53.35 65538 54.64 65538 76.67 65538 15.17 65538 1.2 65538 13.71 65538 81.59 65538 43.33 65538 30.27 65538 8.91 65538 95.81 65538 92.44 65538 98.11 65538 18.02 65538 78.41 65538 35.14 65538 9.53 65538 48.61 65538 2.03 PREHOOK: query: select s, last_value(t) over (partition by d order by f) from over10k limit 100 PREHOOK: type: QUERY PREHOOK: Input: default@over10k #### A masked pattern was here #### POSTHOOK: query: select s, last_value(t) over (partition by d order by f) from over10k limit 100 POSTHOOK: type: QUERY POSTHOOK: Input: default@over10k #### A masked pattern was here #### calvin miller 99 holly polk 83 wendy quirinius -3 yuri laertes 115 nick steinbeck 21 tom young 34 katie brown 66 priscilla quirinius 67 gabriella quirinius 37 katie falkner 118 xavier robinson 47 ethan carson 105 victor johnson 19 jessica white 29 zach white 99 jessica king -3 victor davidson 83 holly falkner 110 quinn falkner 33 holly young 82 nick robinson 106 xavier steinbeck 8 irene king 66 quinn zipper 14 priscilla miller 61 yuri miller 7 wendy zipper 1 zach steinbeck 124 fred nixon 91 katie brown 104 nick davidson 74 gabriella davidson 112 zach carson 109 wendy king 78 jessica quirinius 22 holly hernandez 35 tom xylophone 30 quinn johnson 117 yuri zipper -1 gabriella brown 92 david robinson 103 mike nixon 96 gabriella white 6 rachel davidson 7 yuri garcia 121 yuri zipper 92 jessica steinbeck 86 katie hernandez 57 alice king 26 victor steinbeck 87 katie ovid 4 priscilla young 71 quinn van buren 18 quinn davidson 93 gabriella brown -3 zach laertes 124 jessica ichabod 86 irene falkner 49 ethan miller 72 irene carson 26 priscilla zipper 37 tom robinson 33 sarah davidson 86 katie polk 62 nick white 8 xavier laertes 17 alice ichabod 18 nick polk 52 luke brown 47 wendy allen 16 gabriella robinson 6 calvin ichabod -3 holly steinbeck 25 gabriella carson 39 holly van buren 19 tom nixon 45 katie laertes -1 mike brown 3 oscar nixon 65 zach garcia 29 tom polk 93 mike allen 115 alice johnson 17 holly robinson 43 yuri young 24 priscilla thompson 9 rachel carson 24 victor brown 34 gabriella laertes 18 bob carson 6 holly allen 63 fred nixon 111 rachel carson 89 alice nixon 48 priscilla brown 68 victor falkner 81 tom white 43 holly hernandez 4 david garcia 101 rachel ellison 51 PREHOOK: query: select s, first_value(s) over (partition by bo order by s) from over10k limit 100 PREHOOK: type: QUERY PREHOOK: Input: default@over10k #### A masked pattern was here #### POSTHOOK: query: select s, first_value(s) over (partition by bo order by s) from over10k limit 100 POSTHOOK: type: QUERY POSTHOOK: Input: default@over10k #### A masked pattern was here #### alice allen alice allen alice allen alice allen alice allen alice allen alice allen alice allen alice brown alice allen alice brown alice allen alice brown alice allen alice brown alice allen alice brown alice allen alice brown alice allen alice brown alice allen alice brown alice allen alice carson alice allen alice carson alice allen alice carson alice allen alice davidson alice allen alice davidson alice allen alice davidson alice allen alice davidson alice allen alice davidson alice allen alice davidson alice allen alice davidson alice allen alice davidson alice allen alice davidson alice allen alice davidson alice allen alice ellison alice allen alice ellison alice allen alice ellison alice allen alice ellison alice allen alice ellison alice allen alice ellison alice allen alice ellison alice allen alice ellison alice allen alice ellison alice allen alice falkner alice allen alice falkner alice allen alice falkner alice allen alice falkner alice allen alice falkner alice allen alice falkner alice allen alice garcia alice allen alice garcia alice allen alice garcia alice allen alice garcia alice allen alice garcia alice allen alice hernandez alice allen alice hernandez alice allen alice hernandez alice allen alice hernandez alice allen alice hernandez alice allen alice hernandez alice allen alice hernandez alice allen alice hernandez alice allen alice hernandez alice allen alice hernandez alice allen alice hernandez alice allen alice ichabod alice allen alice ichabod alice allen alice ichabod alice allen alice ichabod alice allen alice ichabod alice allen alice ichabod alice allen alice ichabod alice allen alice ichabod alice allen alice ichabod alice allen alice ichabod alice allen alice ichabod alice allen alice johnson alice allen alice johnson alice allen alice johnson alice allen alice johnson alice allen alice johnson alice allen alice johnson alice allen alice johnson alice allen alice johnson alice allen alice king alice allen alice king alice allen alice king alice allen alice king alice allen alice king alice allen alice king alice allen alice laertes alice allen alice laertes alice allen alice laertes alice allen alice laertes alice allen alice laertes alice allen alice laertes alice allen alice miller alice allen alice miller alice allen alice miller alice allen alice miller alice allen alice miller alice allen alice miller alice allen alice miller alice allen alice miller alice allen alice miller alice allen alice miller alice allen alice nixon alice allen alice nixon alice allen alice nixon alice allen PREHOOK: query: select t, s, i, last_value(i) over (partition by t order by s) from over10k where (s = 'oscar allen' or s = 'oscar carson') and t = 10 PREHOOK: type: QUERY PREHOOK: Input: default@over10k #### A masked pattern was here #### POSTHOOK: query: select t, s, i, last_value(i) over (partition by t order by s) from over10k where (s = 'oscar allen' or s = 'oscar carson') and t = 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@over10k #### A masked pattern was here #### 10 oscar allen 65662 65662 10 oscar carson 65549 65549 PREHOOK: query: drop table if exists wtest PREHOOK: type: DROPTABLE POSTHOOK: query: drop table if exists wtest POSTHOOK: type: DROPTABLE PREHOOK: query: create table wtest as select a, b from ( SELECT explode( map( 3, array(1,2,3,4,5), 1, array(int(null),int(null),int(null), int(null), int(null)), 2, array(1,null,2, null, 3) ) ) as (a,barr) FROM (select * from src limit 1) s ) s1 lateral view explode(barr) arr as b PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src PREHOOK: Output: database:default PREHOOK: Output: default@wtest POSTHOOK: query: create table wtest as select a, b from ( SELECT explode( map( 3, array(1,2,3,4,5), 1, array(int(null),int(null),int(null), int(null), int(null)), 2, array(1,null,2, null, 3) ) ) as (a,barr) FROM (select * from src limit 1) s ) s1 lateral view explode(barr) arr as b POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src POSTHOOK: Output: database:default POSTHOOK: Output: default@wtest PREHOOK: query: select a, b, first_value(b) over (partition by a order by b rows between 1 preceding and 1 following ) , first_value(b, true) over (partition by a order by b rows between 1 preceding and 1 following ) , first_value(b) over (partition by a order by b rows between unbounded preceding and 1 following ) , first_value(b, true) over (partition by a order by b rows between unbounded preceding and 1 following ) from wtest PREHOOK: type: QUERY PREHOOK: Input: default@wtest #### A masked pattern was here #### POSTHOOK: query: select a, b, first_value(b) over (partition by a order by b rows between 1 preceding and 1 following ) , first_value(b, true) over (partition by a order by b rows between 1 preceding and 1 following ) , first_value(b) over (partition by a order by b rows between unbounded preceding and 1 following ) , first_value(b, true) over (partition by a order by b rows between unbounded preceding and 1 following ) from wtest POSTHOOK: type: QUERY POSTHOOK: Input: default@wtest #### A masked pattern was here #### 1 NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL NULL 2 NULL NULL NULL NULL NULL 2 NULL NULL 1 NULL 1 2 1 NULL 1 NULL 1 2 2 1 1 NULL 1 2 3 2 2 NULL 1 3 1 1 1 1 1 3 2 1 1 1 1 3 3 2 2 1 1 3 4 3 3 1 1 3 5 4 4 1 1 PREHOOK: query: select a, b, first_value(b) over (partition by a order by b desc rows between 1 preceding and 1 following ) , first_value(b, true) over (partition by a order by b desc rows between 1 preceding and 1 following ) , first_value(b) over (partition by a order by b desc rows between unbounded preceding and 1 following ) , first_value(b, true) over (partition by a order by b desc rows between unbounded preceding and 1 following ) from wtest PREHOOK: type: QUERY PREHOOK: Input: default@wtest #### A masked pattern was here #### POSTHOOK: query: select a, b, first_value(b) over (partition by a order by b desc rows between 1 preceding and 1 following ) , first_value(b, true) over (partition by a order by b desc rows between 1 preceding and 1 following ) , first_value(b) over (partition by a order by b desc rows between unbounded preceding and 1 following ) , first_value(b, true) over (partition by a order by b desc rows between unbounded preceding and 1 following ) from wtest POSTHOOK: type: QUERY POSTHOOK: Input: default@wtest #### A masked pattern was here #### 1 NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL NULL 2 3 3 3 3 3 2 2 3 3 3 3 2 1 2 2 3 3 2 NULL 1 1 3 3 2 NULL NULL NULL 3 3 3 5 5 5 5 5 3 4 5 5 5 5 3 3 4 4 5 5 3 2 3 3 5 5 3 1 2 2 5 5 PREHOOK: query: select a, b, last_value(b) over (partition by a order by b rows between 1 preceding and 1 following ) , last_value(b, true) over (partition by a order by b rows between 1 preceding and 1 following ) , last_value(b) over (partition by a order by b rows between unbounded preceding and 1 following ) , last_value(b, true) over (partition by a order by b rows between unbounded preceding and 1 following ) from wtest PREHOOK: type: QUERY PREHOOK: Input: default@wtest #### A masked pattern was here #### POSTHOOK: query: select a, b, last_value(b) over (partition by a order by b rows between 1 preceding and 1 following ) , last_value(b, true) over (partition by a order by b rows between 1 preceding and 1 following ) , last_value(b) over (partition by a order by b rows between unbounded preceding and 1 following ) , last_value(b, true) over (partition by a order by b rows between unbounded preceding and 1 following ) from wtest POSTHOOK: type: QUERY POSTHOOK: Input: default@wtest #### A masked pattern was here #### 1 NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL NULL 2 NULL NULL NULL NULL NULL 2 NULL 1 1 1 1 2 1 2 2 2 2 2 2 3 3 3 3 2 3 3 3 3 3 3 1 2 2 2 2 3 2 3 3 3 3 3 3 4 4 4 4 3 4 5 5 5 5 3 5 5 5 5 5 PREHOOK: query: select a, b, last_value(b) over (partition by a order by b desc rows between 1 preceding and 1 following ) , last_value(b, true) over (partition by a order by b desc rows between 1 preceding and 1 following ) , last_value(b) over (partition by a order by b desc rows between unbounded preceding and 1 following ) , last_value(b, true) over (partition by a order by b desc rows between unbounded preceding and 1 following ) from wtest PREHOOK: type: QUERY PREHOOK: Input: default@wtest #### A masked pattern was here #### POSTHOOK: query: select a, b, last_value(b) over (partition by a order by b desc rows between 1 preceding and 1 following ) , last_value(b, true) over (partition by a order by b desc rows between 1 preceding and 1 following ) , last_value(b) over (partition by a order by b desc rows between unbounded preceding and 1 following ) , last_value(b, true) over (partition by a order by b desc rows between unbounded preceding and 1 following ) from wtest POSTHOOK: type: QUERY POSTHOOK: Input: default@wtest #### A masked pattern was here #### 1 NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL NULL 2 3 2 2 2 2 2 2 1 1 1 1 2 1 NULL 1 NULL 1 2 NULL NULL 1 NULL 1 2 NULL NULL NULL NULL 1 3 5 4 4 4 4 3 4 3 3 3 3 3 3 2 2 2 2 3 2 1 1 1 1 3 1 1 1 1 1