| PREHOOK: query: drop table over10k_n17 |
| PREHOOK: type: DROPTABLE |
| POSTHOOK: query: drop table over10k_n17 |
| POSTHOOK: type: DROPTABLE |
| PREHOOK: query: create table over10k_n17( |
| 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_n17 |
| POSTHOOK: query: create table over10k_n17( |
| 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_n17 |
| PREHOOK: query: load data local inpath '../../data/files/over10k' into table over10k_n17 |
| PREHOOK: type: LOAD |
| #### A masked pattern was here #### |
| PREHOOK: Output: default@over10k_n17 |
| POSTHOOK: query: load data local inpath '../../data/files/over10k' into table over10k_n17 |
| POSTHOOK: type: LOAD |
| #### A masked pattern was here #### |
| POSTHOOK: Output: default@over10k_n17 |
| PREHOOK: query: select first_value(t) over ( partition by si order by i, b ) fv from over10k_n17 order by fv limit 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@over10k_n17 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select first_value(t) over ( partition by si order by i, b ) fv from over10k_n17 order by fv limit 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@over10k_n17 |
| #### A masked pattern was here #### |
| -2 |
| -2 |
| -2 |
| -2 |
| -2 |
| -2 |
| -2 |
| -2 |
| -2 |
| -2 |
| -2 |
| -2 |
| -2 |
| -2 |
| -2 |
| -2 |
| -2 |
| -2 |
| -2 |
| -2 |
| -2 |
| -2 |
| -2 |
| -2 |
| -2 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| -1 |
| PREHOOK: query: select last_value(i) over (partition by si, bo order by i, f desc range current row) lv from over10k_n17 order by lv limit 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@over10k_n17 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select last_value(i) over (partition by si, bo order by i, f desc range current row) lv from over10k_n17 order by lv limit 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@over10k_n17 |
| #### A masked pattern was here #### |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65536 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65537 |
| 65538 |
| 65538 |
| 65538 |
| 65538 |
| 65538 |
| 65538 |
| 65538 |
| 65538 |
| 65538 |
| 65538 |
| 65538 |
| 65538 |
| 65538 |
| 65538 |
| 65538 |
| 65538 |
| 65538 |
| 65538 |
| 65538 |
| 65538 |
| PREHOOK: query: select row_number() over (partition by si, bo order by i, f desc range between unbounded preceding and unbounded following) rn from over10k_n17 order by rn limit 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@over10k_n17 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select row_number() over (partition by si, bo order by i, f desc range between unbounded preceding and unbounded following) rn from over10k_n17 order by rn limit 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@over10k_n17 |
| #### A masked pattern was here #### |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| PREHOOK: query: select s, si, i, avg(i) over (partition by s range between unbounded preceding and current row) a from over10k_n17 order by s, si, i, a limit 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@over10k_n17 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select s, si, i, avg(i) over (partition by s range between unbounded preceding and current row) a from over10k_n17 order by s, si, i, a limit 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@over10k_n17 |
| #### A masked pattern was here #### |
| alice allen 400 65557 65640.125 |
| alice allen 451 65662 65640.125 |
| alice allen 462 65545 65640.125 |
| alice allen 472 65609 65640.125 |
| alice allen 484 65600 65640.125 |
| alice allen 501 65670 65640.125 |
| alice allen 501 65720 65640.125 |
| alice allen 509 65758 65640.125 |
| alice brown 302 65711 65696.71428571429 |
| alice brown 324 65569 65696.71428571429 |
| alice brown 332 65781 65696.71428571429 |
| alice brown 337 65707 65696.71428571429 |
| alice brown 346 65696 65696.71428571429 |
| alice brown 376 65708 65696.71428571429 |
| alice brown 381 65704 65696.71428571429 |
| alice brown 399 65779 65696.71428571429 |
| alice brown 409 65667 65696.71428571429 |
| alice brown 425 65570 65696.71428571429 |
| alice brown 452 65666 65696.71428571429 |
| alice brown 471 65733 65696.71428571429 |
| alice brown 492 65673 65696.71428571429 |
| alice brown 499 65790 65696.71428571429 |
| alice carson 268 65713 65645.4 |
| alice carson 316 65559 65645.4 |
| alice carson 318 65695 65645.4 |
| alice carson 376 65576 65645.4 |
| alice carson 380 65785 65645.4 |
| alice carson 390 65747 65645.4 |
| alice carson 404 65710 65645.4 |
| alice carson 427 65559 65645.4 |
| alice carson 473 65565 65645.4 |
| alice carson 508 65545 65645.4 |
| alice davidson 270 65563 65648.5 |
| alice davidson 272 65742 65648.5 |
| alice davidson 287 65747 65648.5 |
| alice davidson 298 65554 65648.5 |
| alice davidson 308 65560 65648.5 |
| alice davidson 321 65677 65648.5 |
| alice davidson 328 65547 65648.5 |
| alice davidson 384 65676 65648.5 |
| alice davidson 402 65544 65648.5 |
| alice davidson 408 65707 65648.5 |
| alice davidson 408 65791 65648.5 |
| alice davidson 423 65740 65648.5 |
| alice davidson 431 65677 65648.5 |
| alice davidson 437 65690 65648.5 |
| alice davidson 445 65590 65648.5 |
| alice davidson 448 65641 65648.5 |
| alice davidson 479 65631 65648.5 |
| alice davidson 487 65596 65648.5 |
| alice ellison 256 65744 65669.13333333333 |
| alice ellison 274 65537 65669.13333333333 |
| alice ellison 296 65741 65669.13333333333 |
| alice ellison 313 65612 65669.13333333333 |
| alice ellison 320 65745 65669.13333333333 |
| alice ellison 331 65557 65669.13333333333 |
| alice ellison 335 65730 65669.13333333333 |
| alice ellison 343 65787 65669.13333333333 |
| alice ellison 354 65698 65669.13333333333 |
| alice ellison 355 65699 65669.13333333333 |
| alice ellison 374 65677 65669.13333333333 |
| alice ellison 403 65544 65669.13333333333 |
| alice ellison 405 65713 65669.13333333333 |
| alice ellison 482 65681 65669.13333333333 |
| alice ellison 490 65572 65669.13333333333 |
| alice falkner 280 65597 65695.76470588235 |
| alice falkner 311 65715 65695.76470588235 |
| alice falkner 323 65669 65695.76470588235 |
| alice falkner 339 65785 65695.76470588235 |
| alice falkner 342 65752 65695.76470588235 |
| alice falkner 345 65773 65695.76470588235 |
| alice falkner 371 65710 65695.76470588235 |
| alice falkner 382 65622 65695.76470588235 |
| alice falkner 382 65690 65695.76470588235 |
| alice falkner 389 65699 65695.76470588235 |
| alice falkner 393 65611 65695.76470588235 |
| alice falkner 393 65685 65695.76470588235 |
| alice falkner 452 65596 65695.76470588235 |
| alice falkner 455 65718 65695.76470588235 |
| alice falkner 477 65722 65695.76470588235 |
| alice falkner 481 65709 65695.76470588235 |
| alice falkner 500 65775 65695.76470588235 |
| alice garcia 263 65630 65688.76923076923 |
| alice garcia 299 65623 65688.76923076923 |
| alice garcia 309 65746 65688.76923076923 |
| alice garcia 325 65573 65688.76923076923 |
| alice garcia 331 65734 65688.76923076923 |
| alice garcia 366 65744 65688.76923076923 |
| alice garcia 379 65746 65688.76923076923 |
| alice garcia 388 65675 65688.76923076923 |
| alice garcia 427 65674 65688.76923076923 |
| alice garcia 446 65613 65688.76923076923 |
| alice garcia 446 65759 65688.76923076923 |
| alice garcia 459 65712 65688.76923076923 |
| alice garcia 486 65725 65688.76923076923 |
| alice hernandez 270 65717 65678.38888888889 |
| alice hernandez 290 65685 65678.38888888889 |
| alice hernandez 296 65569 65678.38888888889 |
| alice hernandez 320 65700 65678.38888888889 |
| alice hernandez 323 65727 65678.38888888889 |
| PREHOOK: query: select s, si, i, avg(i) over (partition by s order by si, i range between unbounded preceding and current row) a from over10k_n17 order by s, si, i, a limit 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@over10k_n17 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select s, si, i, avg(i) over (partition by s order by si, i range between unbounded preceding and current row) a from over10k_n17 order by s, si, i, a limit 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@over10k_n17 |
| #### A masked pattern was here #### |
| alice allen 400 65557 65557.0 |
| alice allen 451 65662 65609.5 |
| alice allen 462 65545 65588.0 |
| alice allen 472 65609 65593.25 |
| alice allen 484 65600 65594.6 |
| alice allen 501 65670 65607.16666666667 |
| alice allen 501 65720 65623.28571428571 |
| alice allen 509 65758 65640.125 |
| alice brown 302 65711 65711.0 |
| alice brown 324 65569 65640.0 |
| alice brown 332 65781 65687.0 |
| alice brown 337 65707 65692.0 |
| alice brown 346 65696 65692.8 |
| alice brown 376 65708 65695.33333333333 |
| alice brown 381 65704 65696.57142857143 |
| alice brown 399 65779 65706.875 |
| alice brown 409 65667 65702.44444444444 |
| alice brown 425 65570 65689.2 |
| alice brown 452 65666 65687.09090909091 |
| alice brown 471 65733 65690.91666666667 |
| alice brown 492 65673 65689.53846153847 |
| alice brown 499 65790 65696.71428571429 |
| alice carson 268 65713 65713.0 |
| alice carson 316 65559 65636.0 |
| alice carson 318 65695 65655.66666666667 |
| alice carson 376 65576 65635.75 |
| alice carson 380 65785 65665.6 |
| alice carson 390 65747 65679.16666666667 |
| alice carson 404 65710 65683.57142857143 |
| alice carson 427 65559 65668.0 |
| alice carson 473 65565 65656.55555555556 |
| alice carson 508 65545 65645.4 |
| alice davidson 270 65563 65563.0 |
| alice davidson 272 65742 65652.5 |
| alice davidson 287 65747 65684.0 |
| alice davidson 298 65554 65651.5 |
| alice davidson 308 65560 65633.2 |
| alice davidson 321 65677 65640.5 |
| alice davidson 328 65547 65627.14285714286 |
| alice davidson 384 65676 65633.25 |
| alice davidson 402 65544 65623.33333333333 |
| alice davidson 408 65707 65631.7 |
| alice davidson 408 65791 65646.18181818182 |
| alice davidson 423 65740 65654.0 |
| alice davidson 431 65677 65655.76923076923 |
| alice davidson 437 65690 65658.21428571429 |
| alice davidson 445 65590 65653.66666666667 |
| alice davidson 448 65641 65652.875 |
| alice davidson 479 65631 65651.58823529411 |
| alice davidson 487 65596 65648.5 |
| alice ellison 256 65744 65744.0 |
| alice ellison 274 65537 65640.5 |
| alice ellison 296 65741 65674.0 |
| alice ellison 313 65612 65658.5 |
| alice ellison 320 65745 65675.8 |
| alice ellison 331 65557 65656.0 |
| alice ellison 335 65730 65666.57142857143 |
| alice ellison 343 65787 65681.625 |
| alice ellison 354 65698 65683.44444444444 |
| alice ellison 355 65699 65685.0 |
| alice ellison 374 65677 65684.27272727272 |
| alice ellison 403 65544 65672.58333333333 |
| alice ellison 405 65713 65675.69230769231 |
| alice ellison 482 65681 65676.07142857143 |
| alice ellison 490 65572 65669.13333333333 |
| alice falkner 280 65597 65597.0 |
| alice falkner 311 65715 65656.0 |
| alice falkner 323 65669 65660.33333333333 |
| alice falkner 339 65785 65691.5 |
| alice falkner 342 65752 65703.6 |
| alice falkner 345 65773 65715.16666666667 |
| alice falkner 371 65710 65714.42857142857 |
| alice falkner 382 65622 65702.875 |
| alice falkner 382 65690 65701.44444444444 |
| alice falkner 389 65699 65701.2 |
| alice falkner 393 65611 65693.0 |
| alice falkner 393 65685 65692.33333333333 |
| alice falkner 452 65596 65684.92307692308 |
| alice falkner 455 65718 65687.28571428571 |
| alice falkner 477 65722 65689.6 |
| alice falkner 481 65709 65690.8125 |
| alice falkner 500 65775 65695.76470588235 |
| alice garcia 263 65630 65630.0 |
| alice garcia 299 65623 65626.5 |
| alice garcia 309 65746 65666.33333333333 |
| alice garcia 325 65573 65643.0 |
| alice garcia 331 65734 65661.2 |
| alice garcia 366 65744 65675.0 |
| alice garcia 379 65746 65685.14285714286 |
| alice garcia 388 65675 65683.875 |
| alice garcia 427 65674 65682.77777777778 |
| alice garcia 446 65613 65675.8 |
| alice garcia 446 65759 65683.36363636363 |
| alice garcia 459 65712 65685.75 |
| alice garcia 486 65725 65688.76923076923 |
| alice hernandez 270 65717 65717.0 |
| alice hernandez 290 65685 65701.0 |
| alice hernandez 296 65569 65657.0 |
| alice hernandez 320 65700 65667.75 |
| alice hernandez 323 65727 65679.6 |
| PREHOOK: query: select s, si, i, min(i) over (partition by s order by si, i range between unbounded preceding and current row) m from over10k_n17 order by s, si, i, m limit 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@over10k_n17 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select s, si, i, min(i) over (partition by s order by si, i range between unbounded preceding and current row) m from over10k_n17 order by s, si, i, m limit 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@over10k_n17 |
| #### A masked pattern was here #### |
| alice allen 400 65557 65557 |
| alice allen 451 65662 65557 |
| alice allen 462 65545 65545 |
| alice allen 472 65609 65545 |
| alice allen 484 65600 65545 |
| alice allen 501 65670 65545 |
| alice allen 501 65720 65545 |
| alice allen 509 65758 65545 |
| alice brown 302 65711 65711 |
| alice brown 324 65569 65569 |
| alice brown 332 65781 65569 |
| alice brown 337 65707 65569 |
| alice brown 346 65696 65569 |
| alice brown 376 65708 65569 |
| alice brown 381 65704 65569 |
| alice brown 399 65779 65569 |
| alice brown 409 65667 65569 |
| alice brown 425 65570 65569 |
| alice brown 452 65666 65569 |
| alice brown 471 65733 65569 |
| alice brown 492 65673 65569 |
| alice brown 499 65790 65569 |
| alice carson 268 65713 65713 |
| alice carson 316 65559 65559 |
| alice carson 318 65695 65559 |
| alice carson 376 65576 65559 |
| alice carson 380 65785 65559 |
| alice carson 390 65747 65559 |
| alice carson 404 65710 65559 |
| alice carson 427 65559 65559 |
| alice carson 473 65565 65559 |
| alice carson 508 65545 65545 |
| alice davidson 270 65563 65563 |
| alice davidson 272 65742 65563 |
| alice davidson 287 65747 65563 |
| alice davidson 298 65554 65554 |
| alice davidson 308 65560 65554 |
| alice davidson 321 65677 65554 |
| alice davidson 328 65547 65547 |
| alice davidson 384 65676 65547 |
| alice davidson 402 65544 65544 |
| alice davidson 408 65707 65544 |
| alice davidson 408 65791 65544 |
| alice davidson 423 65740 65544 |
| alice davidson 431 65677 65544 |
| alice davidson 437 65690 65544 |
| alice davidson 445 65590 65544 |
| alice davidson 448 65641 65544 |
| alice davidson 479 65631 65544 |
| alice davidson 487 65596 65544 |
| alice ellison 256 65744 65744 |
| alice ellison 274 65537 65537 |
| alice ellison 296 65741 65537 |
| alice ellison 313 65612 65537 |
| alice ellison 320 65745 65537 |
| alice ellison 331 65557 65537 |
| alice ellison 335 65730 65537 |
| alice ellison 343 65787 65537 |
| alice ellison 354 65698 65537 |
| alice ellison 355 65699 65537 |
| alice ellison 374 65677 65537 |
| alice ellison 403 65544 65537 |
| alice ellison 405 65713 65537 |
| alice ellison 482 65681 65537 |
| alice ellison 490 65572 65537 |
| alice falkner 280 65597 65597 |
| alice falkner 311 65715 65597 |
| alice falkner 323 65669 65597 |
| alice falkner 339 65785 65597 |
| alice falkner 342 65752 65597 |
| alice falkner 345 65773 65597 |
| alice falkner 371 65710 65597 |
| alice falkner 382 65622 65597 |
| alice falkner 382 65690 65597 |
| alice falkner 389 65699 65597 |
| alice falkner 393 65611 65597 |
| alice falkner 393 65685 65597 |
| alice falkner 452 65596 65596 |
| alice falkner 455 65718 65596 |
| alice falkner 477 65722 65596 |
| alice falkner 481 65709 65596 |
| alice falkner 500 65775 65596 |
| alice garcia 263 65630 65630 |
| alice garcia 299 65623 65623 |
| alice garcia 309 65746 65623 |
| alice garcia 325 65573 65573 |
| alice garcia 331 65734 65573 |
| alice garcia 366 65744 65573 |
| alice garcia 379 65746 65573 |
| alice garcia 388 65675 65573 |
| alice garcia 427 65674 65573 |
| alice garcia 446 65613 65573 |
| alice garcia 446 65759 65573 |
| alice garcia 459 65712 65573 |
| alice garcia 486 65725 65573 |
| alice hernandez 270 65717 65717 |
| alice hernandez 290 65685 65685 |
| alice hernandez 296 65569 65569 |
| alice hernandez 320 65700 65569 |
| alice hernandez 323 65727 65569 |
| PREHOOK: query: select s, si, i, avg(i) over (partition by s order by si, i desc range between unbounded preceding and current row) a from over10k_n17 order by s, si, i, a limit 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@over10k_n17 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select s, si, i, avg(i) over (partition by s order by si, i desc range between unbounded preceding and current row) a from over10k_n17 order by s, si, i, a limit 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@over10k_n17 |
| #### A masked pattern was here #### |
| alice allen 400 65557 65557.0 |
| alice allen 451 65662 65609.5 |
| alice allen 462 65545 65588.0 |
| alice allen 472 65609 65593.25 |
| alice allen 484 65600 65594.6 |
| alice allen 501 65670 65623.28571428571 |
| alice allen 501 65720 65615.5 |
| alice allen 509 65758 65640.125 |
| alice brown 302 65711 65711.0 |
| alice brown 324 65569 65640.0 |
| alice brown 332 65781 65687.0 |
| alice brown 337 65707 65692.0 |
| alice brown 346 65696 65692.8 |
| alice brown 376 65708 65695.33333333333 |
| alice brown 381 65704 65696.57142857143 |
| alice brown 399 65779 65706.875 |
| alice brown 409 65667 65702.44444444444 |
| alice brown 425 65570 65689.2 |
| alice brown 452 65666 65687.09090909091 |
| alice brown 471 65733 65690.91666666667 |
| alice brown 492 65673 65689.53846153847 |
| alice brown 499 65790 65696.71428571429 |
| alice carson 268 65713 65713.0 |
| alice carson 316 65559 65636.0 |
| alice carson 318 65695 65655.66666666667 |
| alice carson 376 65576 65635.75 |
| alice carson 380 65785 65665.6 |
| alice carson 390 65747 65679.16666666667 |
| alice carson 404 65710 65683.57142857143 |
| alice carson 427 65559 65668.0 |
| alice carson 473 65565 65656.55555555556 |
| alice carson 508 65545 65645.4 |
| alice davidson 270 65563 65563.0 |
| alice davidson 272 65742 65652.5 |
| alice davidson 287 65747 65684.0 |
| alice davidson 298 65554 65651.5 |
| alice davidson 308 65560 65633.2 |
| alice davidson 321 65677 65640.5 |
| alice davidson 328 65547 65627.14285714286 |
| alice davidson 384 65676 65633.25 |
| alice davidson 402 65544 65623.33333333333 |
| alice davidson 408 65707 65646.18181818182 |
| alice davidson 408 65791 65640.1 |
| alice davidson 423 65740 65654.0 |
| alice davidson 431 65677 65655.76923076923 |
| alice davidson 437 65690 65658.21428571429 |
| alice davidson 445 65590 65653.66666666667 |
| alice davidson 448 65641 65652.875 |
| alice davidson 479 65631 65651.58823529411 |
| alice davidson 487 65596 65648.5 |
| alice ellison 256 65744 65744.0 |
| alice ellison 274 65537 65640.5 |
| alice ellison 296 65741 65674.0 |
| alice ellison 313 65612 65658.5 |
| alice ellison 320 65745 65675.8 |
| alice ellison 331 65557 65656.0 |
| alice ellison 335 65730 65666.57142857143 |
| alice ellison 343 65787 65681.625 |
| alice ellison 354 65698 65683.44444444444 |
| alice ellison 355 65699 65685.0 |
| alice ellison 374 65677 65684.27272727272 |
| alice ellison 403 65544 65672.58333333333 |
| alice ellison 405 65713 65675.69230769231 |
| alice ellison 482 65681 65676.07142857143 |
| alice ellison 490 65572 65669.13333333333 |
| alice falkner 280 65597 65597.0 |
| alice falkner 311 65715 65656.0 |
| alice falkner 323 65669 65660.33333333333 |
| alice falkner 339 65785 65691.5 |
| alice falkner 342 65752 65703.6 |
| alice falkner 345 65773 65715.16666666667 |
| alice falkner 371 65710 65714.42857142857 |
| alice falkner 382 65622 65701.44444444444 |
| alice falkner 382 65690 65711.375 |
| alice falkner 389 65699 65701.2 |
| alice falkner 393 65611 65692.33333333333 |
| alice falkner 393 65685 65699.72727272728 |
| alice falkner 452 65596 65684.92307692308 |
| alice falkner 455 65718 65687.28571428571 |
| alice falkner 477 65722 65689.6 |
| alice falkner 481 65709 65690.8125 |
| alice falkner 500 65775 65695.76470588235 |
| alice garcia 263 65630 65630.0 |
| alice garcia 299 65623 65626.5 |
| alice garcia 309 65746 65666.33333333333 |
| alice garcia 325 65573 65643.0 |
| alice garcia 331 65734 65661.2 |
| alice garcia 366 65744 65675.0 |
| alice garcia 379 65746 65685.14285714286 |
| alice garcia 388 65675 65683.875 |
| alice garcia 427 65674 65682.77777777778 |
| alice garcia 446 65613 65683.36363636363 |
| alice garcia 446 65759 65690.4 |
| alice garcia 459 65712 65685.75 |
| alice garcia 486 65725 65688.76923076923 |
| alice hernandez 270 65717 65717.0 |
| alice hernandez 290 65685 65701.0 |
| alice hernandez 296 65569 65657.0 |
| alice hernandez 320 65700 65667.75 |
| alice hernandez 323 65727 65679.6 |
| PREHOOK: query: select si, bo, i, f, max(i) over (partition by si, bo order by i, f desc range between unbounded preceding and current row) m from over10k_n17 order by si, bo, i, f, m limit 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@over10k_n17 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select si, bo, i, f, max(i) over (partition by si, bo order by i, f desc range between unbounded preceding and current row) m from over10k_n17 order by si, bo, i, f, m limit 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@over10k_n17 |
| #### A masked pattern was here #### |
| 256 false 65543 32.21 65543 |
| 256 false 65549 23.72 65549 |
| 256 false 65558 71.32 65558 |
| 256 false 65580 64.81 65580 |
| 256 false 65586 12.97 65586 |
| 256 false 65596 5.35 65596 |
| 256 false 65616 76.38 65616 |
| 256 false 65620 51.72 65620 |
| 256 false 65627 54.23 65627 |
| 256 false 65640 32.64 65640 |
| 256 false 65643 94.05 65643 |
| 256 false 65706 83.67 65706 |
| 256 false 65713 21.83 65713 |
| 256 false 65737 3.38 65737 |
| 256 false 65744 47.17 65744 |
| 256 false 65752 61.21 65752 |
| 256 false 65778 16.29 65778 |
| 256 true 65540 49.44 65540 |
| 256 true 65563 94.87 65563 |
| 256 true 65599 89.55 65599 |
| 256 true 65604 40.97 65604 |
| 256 true 65613 78.27 65613 |
| 256 true 65613 93.29 65613 |
| 256 true 65615 20.66 65615 |
| 256 true 65651 90.32 65651 |
| 256 true 65653 8.1 65653 |
| 256 true 65668 92.71 65668 |
| 256 true 65693 62.52 65693 |
| 256 true 65731 34.09 65731 |
| 256 true 65733 70.53 65733 |
| 256 true 65738 9.0 65738 |
| 256 true 65741 54.8 65741 |
| 256 true 65744 38.16 65744 |
| 256 true 65747 32.18 65747 |
| 256 true 65763 24.89 65763 |
| 256 true 65778 74.15 65778 |
| 256 true 65789 91.12 65789 |
| 257 false 65541 51.26 65541 |
| 257 false 65547 54.01 65547 |
| 257 false 65560 42.14 65560 |
| 257 false 65572 79.15 65572 |
| 257 false 65574 19.96 65574 |
| 257 false 65575 1.21 65575 |
| 257 false 65578 61.6 65578 |
| 257 false 65588 81.17 65588 |
| 257 false 65594 78.39 65594 |
| 257 false 65610 98.0 65610 |
| 257 false 65691 80.76 65691 |
| 257 false 65694 29.0 65694 |
| 257 false 65711 60.88 65711 |
| 257 false 65719 62.79 65719 |
| 257 false 65722 79.05 65722 |
| 257 false 65738 96.01 65738 |
| 257 false 65756 24.44 65756 |
| 257 false 65790 9.26 65790 |
| 257 true 65542 62.59 65542 |
| 257 true 65557 55.07 65557 |
| 257 true 65566 68.54 65566 |
| 257 true 65584 35.88 65584 |
| 257 true 65610 47.58 65610 |
| 257 true 65612 3.12 65612 |
| 257 true 65626 23.18 65626 |
| 257 true 65631 51.61 65631 |
| 257 true 65638 95.35 65638 |
| 257 true 65654 9.8 65654 |
| 257 true 65654 24.54 65654 |
| 257 true 65655 40.42 65655 |
| 257 true 65699 15.36 65699 |
| 257 true 65712 90.44 65712 |
| 257 true 65720 24.4 65720 |
| 257 true 65732 96.85 65732 |
| 257 true 65748 32.52 65748 |
| 257 true 65752 49.35 65752 |
| 257 true 65771 48.5 65771 |
| 257 true 65771 53.89 65771 |
| 257 true 65771 95.58 65771 |
| 257 true 65781 17.33 65781 |
| 258 false 65565 98.19 65565 |
| 258 false 65569 66.81 65569 |
| 258 false 65573 31.45 65573 |
| 258 false 65582 67.28 65582 |
| 258 false 65584 64.92 65584 |
| 258 false 65606 35.52 65606 |
| 258 false 65656 79.17 65656 |
| 258 false 65669 75.01 65669 |
| 258 false 65717 95.76 65717 |
| 258 false 65724 70.0 65724 |
| 258 false 65728 9.05 65728 |
| 258 false 65761 33.73 65761 |
| 258 false 65762 15.22 65762 |
| 258 false 65770 13.38 65770 |
| 258 false 65771 52.63 65771 |
| 258 false 65781 1.92 65781 |
| 258 true 65546 91.19 65546 |
| 258 true 65551 88.97 65551 |
| 258 true 65551 91.56 65551 |
| 258 true 65568 13.57 65568 |
| 258 true 65568 81.41 65568 |
| 258 true 65579 47.52 65579 |
| 258 true 65603 2.61 65603 |
| PREHOOK: query: select bo, rank() over (partition by i order by bo nulls first, b nulls last range between unbounded preceding and unbounded following) r from over10k_n17 order by bo, r limit 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@over10k_n17 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select bo, rank() over (partition by i order by bo nulls first, b nulls last range between unbounded preceding and unbounded following) r from over10k_n17 order by bo, r limit 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@over10k_n17 |
| #### A masked pattern was here #### |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| false 1 |
| PREHOOK: query: select CAST(s as CHAR(12)) s, rank() over (partition by i order by CAST(s as CHAR(12)) nulls last range between unbounded preceding and unbounded following) r from over10k_n17 order by s, r limit 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@over10k_n17 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select CAST(s as CHAR(12)) s, rank() over (partition by i order by CAST(s as CHAR(12)) nulls last range between unbounded preceding and unbounded following) r from over10k_n17 order by s, r limit 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@over10k_n17 |
| #### A masked pattern was here #### |
| alice allen 1 |
| alice allen 1 |
| alice allen 1 |
| alice allen 1 |
| alice allen 1 |
| alice allen 1 |
| alice allen 1 |
| alice allen 1 |
| alice brown 1 |
| alice brown 1 |
| alice brown 1 |
| alice brown 1 |
| alice brown 1 |
| alice brown 1 |
| alice brown 1 |
| alice brown 1 |
| alice brown 1 |
| alice brown 1 |
| alice brown 1 |
| alice brown 1 |
| alice brown 1 |
| alice brown 1 |
| alice carson 1 |
| alice carson 1 |
| alice carson 1 |
| alice carson 1 |
| alice carson 1 |
| alice carson 1 |
| alice carson 1 |
| alice carson 1 |
| alice carson 1 |
| alice carson 2 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 2 |
| alice davids 2 |
| alice elliso 1 |
| alice elliso 1 |
| alice elliso 1 |
| alice elliso 1 |
| alice elliso 1 |
| alice elliso 1 |
| alice elliso 1 |
| alice elliso 1 |
| alice elliso 1 |
| alice elliso 1 |
| alice elliso 1 |
| alice elliso 2 |
| alice elliso 2 |
| alice elliso 2 |
| alice elliso 3 |
| alice falkne 1 |
| alice falkne 1 |
| alice falkne 1 |
| alice falkne 1 |
| alice falkne 1 |
| alice falkne 1 |
| alice falkne 1 |
| alice falkne 1 |
| alice falkne 1 |
| alice falkne 1 |
| alice falkne 1 |
| alice falkne 1 |
| alice falkne 2 |
| alice falkne 2 |
| alice falkne 2 |
| alice falkne 2 |
| alice falkne 2 |
| alice garcia 1 |
| alice garcia 1 |
| alice garcia 1 |
| alice garcia 1 |
| alice garcia 1 |
| alice garcia 1 |
| alice garcia 1 |
| alice garcia 1 |
| alice garcia 1 |
| alice garcia 1 |
| alice garcia 1 |
| alice garcia 1 |
| alice garcia 2 |
| alice hernan 1 |
| alice hernan 1 |
| alice hernan 1 |
| alice hernan 1 |
| alice hernan 1 |
| PREHOOK: query: select CAST(s as VARCHAR(12)) s, rank() over (partition by i order by CAST(s as VARCHAR(12)) nulls last range between unbounded preceding and unbounded following) r from over10k_n17 order by s, r limit 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@over10k_n17 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select CAST(s as VARCHAR(12)) s, rank() over (partition by i order by CAST(s as VARCHAR(12)) nulls last range between unbounded preceding and unbounded following) r from over10k_n17 order by s, r limit 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@over10k_n17 |
| #### A masked pattern was here #### |
| alice allen 1 |
| alice allen 1 |
| alice allen 1 |
| alice allen 1 |
| alice allen 1 |
| alice allen 1 |
| alice allen 1 |
| alice allen 1 |
| alice brown 1 |
| alice brown 1 |
| alice brown 1 |
| alice brown 1 |
| alice brown 1 |
| alice brown 1 |
| alice brown 1 |
| alice brown 1 |
| alice brown 1 |
| alice brown 1 |
| alice brown 1 |
| alice brown 1 |
| alice brown 1 |
| alice brown 1 |
| alice carson 1 |
| alice carson 1 |
| alice carson 1 |
| alice carson 1 |
| alice carson 1 |
| alice carson 1 |
| alice carson 1 |
| alice carson 1 |
| alice carson 1 |
| alice carson 2 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 1 |
| alice davids 2 |
| alice davids 2 |
| alice elliso 1 |
| alice elliso 1 |
| alice elliso 1 |
| alice elliso 1 |
| alice elliso 1 |
| alice elliso 1 |
| alice elliso 1 |
| alice elliso 1 |
| alice elliso 1 |
| alice elliso 1 |
| alice elliso 1 |
| alice elliso 2 |
| alice elliso 2 |
| alice elliso 2 |
| alice elliso 3 |
| alice falkne 1 |
| alice falkne 1 |
| alice falkne 1 |
| alice falkne 1 |
| alice falkne 1 |
| alice falkne 1 |
| alice falkne 1 |
| alice falkne 1 |
| alice falkne 1 |
| alice falkne 1 |
| alice falkne 1 |
| alice falkne 1 |
| alice falkne 2 |
| alice falkne 2 |
| alice falkne 2 |
| alice falkne 2 |
| alice falkne 2 |
| alice garcia 1 |
| alice garcia 1 |
| alice garcia 1 |
| alice garcia 1 |
| alice garcia 1 |
| alice garcia 1 |
| alice garcia 1 |
| alice garcia 1 |
| alice garcia 1 |
| alice garcia 1 |
| alice garcia 1 |
| alice garcia 1 |
| alice garcia 2 |
| alice hernan 1 |
| alice hernan 1 |
| alice hernan 1 |
| alice hernan 1 |
| alice hernan 1 |
