You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2013/04/02 16:16:37 UTC
svn commit: r1463556 [14/15] - in /hive/trunk:
common/src/java/org/apache/hadoop/hive/conf/ data/files/ ql/if/
ql/src/gen/thrift/gen-cpp/
ql/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/ql/plan/api/
ql/src/gen/thrift/gen-php/ ql/src/gen/thrift/ge...
Added: hive/trunk/ql/src/test/results/clientpositive/windowing_columnPruning.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/windowing_columnPruning.q.out?rev=1463556&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/windowing_columnPruning.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/windowing_columnPruning.q.out Tue Apr 2 14:16:34 2013
@@ -0,0 +1,157 @@
+PREHOOK: query: DROP TABLE part
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: DROP TABLE part
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: -- data setup
+CREATE TABLE part(
+ p_partkey INT,
+ p_name STRING,
+ p_mfgr STRING,
+ p_brand STRING,
+ p_type STRING,
+ p_size INT,
+ p_container STRING,
+ p_retailprice DOUBLE,
+ p_comment STRING
+)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: -- data setup
+CREATE TABLE part(
+ p_partkey INT,
+ p_name STRING,
+ p_mfgr STRING,
+ p_brand STRING,
+ p_type STRING,
+ p_size INT,
+ p_container STRING,
+ p_retailprice DOUBLE,
+ p_comment STRING
+)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@part
+PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table part
+PREHOOK: type: LOAD
+PREHOOK: Output: default@part
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table part
+POSTHOOK: type: LOAD
+POSTHOOK: Output: default@part
+PREHOOK: query: -- 1. testQueryLevelPartitionColsNotInSelect
+select p_size,
+sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row) as s1
+from part
+PREHOOK: type: QUERY
+PREHOOK: Input: default@part
+#### A masked pattern was here ####
+POSTHOOK: query: -- 1. testQueryLevelPartitionColsNotInSelect
+select p_size,
+sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row) as s1
+from part
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@part
+#### A masked pattern was here ####
+2 1173.15
+2 2346.3
+34 4100.06
+6 5702.650000000001
+28 7117.070000000001
+42 8749.730000000001
+14 1690.68
+40 3491.38
+2 5523.360000000001
+25 7222.02
+18 8923.62
+17 1671.68
+14 2861.95
+19 4272.34
+1 6195.32
+45 7532.61
+10 1620.67
+39 2996.09
+27 4202.35
+7 6047.27
+12 7337.620000000001
+31 1789.69
+6 3401.3500000000004
+2 5190.08
+46 6208.18
+23 7672.66
+PREHOOK: query: -- 2. testWindowPartitionColsNotInSelect
+select p_size,
+sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row) as s1
+from part
+PREHOOK: type: QUERY
+PREHOOK: Input: default@part
+#### A masked pattern was here ####
+POSTHOOK: query: -- 2. testWindowPartitionColsNotInSelect
+select p_size,
+sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row) as s1
+from part
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@part
+#### A masked pattern was here ####
+2 1173.15
+2 2346.3
+34 4100.06
+6 5702.650000000001
+28 7117.070000000001
+42 8749.730000000001
+14 1690.68
+40 3491.38
+2 5523.360000000001
+25 7222.02
+18 8923.62
+17 1671.68
+14 2861.95
+19 4272.34
+1 6195.32
+45 7532.61
+10 1620.67
+39 2996.09
+27 4202.35
+7 6047.27
+12 7337.620000000001
+31 1789.69
+6 3401.3500000000004
+2 5190.08
+46 6208.18
+23 7672.66
+PREHOOK: query: -- 3. testHavingColNotInSelect
+select p_mfgr,
+sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row) as s1
+from part
+PREHOOK: type: QUERY
+PREHOOK: Input: default@part
+#### A masked pattern was here ####
+POSTHOOK: query: -- 3. testHavingColNotInSelect
+select p_mfgr,
+sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row) as s1
+from part
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@part
+#### A masked pattern was here ####
+Manufacturer#1 1173.15
+Manufacturer#1 2346.3
+Manufacturer#1 4100.06
+Manufacturer#1 5702.650000000001
+Manufacturer#1 7117.070000000001
+Manufacturer#1 8749.730000000001
+Manufacturer#2 1690.68
+Manufacturer#2 3491.38
+Manufacturer#2 5523.360000000001
+Manufacturer#2 7222.02
+Manufacturer#2 8923.62
+Manufacturer#3 1671.68
+Manufacturer#3 2861.95
+Manufacturer#3 4272.34
+Manufacturer#3 6195.32
+Manufacturer#3 7532.61
+Manufacturer#4 1620.67
+Manufacturer#4 2996.09
+Manufacturer#4 4202.35
+Manufacturer#4 6047.27
+Manufacturer#4 7337.620000000001
+Manufacturer#5 1789.69
+Manufacturer#5 3401.3500000000004
+Manufacturer#5 5190.08
+Manufacturer#5 6208.18
+Manufacturer#5 7672.66
Added: hive/trunk/ql/src/test/results/clientpositive/windowing_expressions.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/windowing_expressions.q.out?rev=1463556&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/windowing_expressions.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/windowing_expressions.q.out Tue Apr 2 14:16:34 2013
@@ -0,0 +1,664 @@
+PREHOOK: query: DROP TABLE part
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: DROP TABLE part
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: -- data setup
+CREATE TABLE part(
+ p_partkey INT,
+ p_name STRING,
+ p_mfgr STRING,
+ p_brand STRING,
+ p_type STRING,
+ p_size INT,
+ p_container STRING,
+ p_retailprice DOUBLE,
+ p_comment STRING
+)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: -- data setup
+CREATE TABLE part(
+ p_partkey INT,
+ p_name STRING,
+ p_mfgr STRING,
+ p_brand STRING,
+ p_type STRING,
+ p_size INT,
+ p_container STRING,
+ p_retailprice DOUBLE,
+ p_comment STRING
+)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@part
+PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table part
+PREHOOK: type: LOAD
+PREHOOK: Output: default@part
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table part
+POSTHOOK: type: LOAD
+POSTHOOK: Output: default@part
+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 p_mfgr, p_retailprice, p_size,
+round(sum(p_retailprice),2) = round((sum(lag(p_retailprice,1)) - first_value(p_retailprice)) + last_value(p_retailprice),2)
+ over(distribute by p_mfgr sort by p_retailprice),
+max(p_retailprice) - min(p_retailprice) = last_value(p_retailprice) - first_value(p_retailprice)
+ over(distribute by p_mfgr sort by p_retailprice)
+from part
+PREHOOK: type: QUERY
+PREHOOK: Input: default@part
+#### A masked pattern was here ####
+POSTHOOK: query: select p_mfgr, p_retailprice, p_size,
+round(sum(p_retailprice),2) = round((sum(lag(p_retailprice,1)) - first_value(p_retailprice)) + last_value(p_retailprice),2)
+ over(distribute by p_mfgr sort by p_retailprice),
+max(p_retailprice) - min(p_retailprice) = last_value(p_retailprice) - first_value(p_retailprice)
+ over(distribute by p_mfgr sort by p_retailprice)
+from part
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@part
+#### A masked pattern was here ####
+Manufacturer#1 1173.15 2 true true
+Manufacturer#1 1173.15 2 true true
+Manufacturer#1 1414.42 28 true true
+Manufacturer#1 1602.59 6 true true
+Manufacturer#1 1632.66 42 true true
+Manufacturer#1 1753.76 34 true true
+Manufacturer#2 1690.68 14 true true
+Manufacturer#2 1698.66 25 true true
+Manufacturer#2 1701.6 18 true true
+Manufacturer#2 1800.7 40 true true
+Manufacturer#2 2031.98 2 true true
+Manufacturer#3 1190.27 14 true true
+Manufacturer#3 1337.29 45 true true
+Manufacturer#3 1410.39 19 true true
+Manufacturer#3 1671.68 17 true true
+Manufacturer#3 1922.98 1 true true
+Manufacturer#4 1206.26 27 true true
+Manufacturer#4 1290.35 12 true true
+Manufacturer#4 1375.42 39 true true
+Manufacturer#4 1620.67 10 true true
+Manufacturer#4 1844.92 7 true true
+Manufacturer#5 1018.1 46 true true
+Manufacturer#5 1464.48 23 true true
+Manufacturer#5 1611.66 6 true true
+Manufacturer#5 1788.73 2 true true
+Manufacturer#5 1789.69 31 true true
+PREHOOK: query: select p_mfgr, p_retailprice, p_size,
+rank() over (distribute by p_mfgr sort by p_retailprice) as r,
+sum(p_retailprice) over (distribute by p_mfgr sort by p_retailprice rows between unbounded preceding and current row) as s2,
+sum(p_retailprice) - 5 over (distribute by p_mfgr sort by p_retailprice rows between unbounded preceding and current row) as s1
+from part
+PREHOOK: type: QUERY
+PREHOOK: Input: default@part
+#### A masked pattern was here ####
+POSTHOOK: query: select p_mfgr, p_retailprice, p_size,
+rank() over (distribute by p_mfgr sort by p_retailprice) as r,
+sum(p_retailprice) over (distribute by p_mfgr sort by p_retailprice rows between unbounded preceding and current row) as s2,
+sum(p_retailprice) - 5 over (distribute by p_mfgr sort by p_retailprice rows between unbounded preceding and current row) as s1
+from part
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@part
+#### A masked pattern was here ####
+Manufacturer#1 1173.15 2 1 1173.15 1168.15
+Manufacturer#1 1173.15 2 1 2346.3 2341.3
+Manufacturer#1 1414.42 28 3 3760.7200000000003 3755.7200000000003
+Manufacturer#1 1602.59 6 4 5363.31 5358.31
+Manufacturer#1 1632.66 42 5 6995.97 6990.97
+Manufacturer#1 1753.76 34 6 8749.73 8744.73
+Manufacturer#2 1690.68 14 1 1690.68 1685.68
+Manufacturer#2 1698.66 25 2 3389.34 3384.34
+Manufacturer#2 1701.6 18 3 5090.9400000000005 5085.9400000000005
+Manufacturer#2 1800.7 40 4 6891.64 6886.64
+Manufacturer#2 2031.98 2 5 8923.62 8918.62
+Manufacturer#3 1190.27 14 1 1190.27 1185.27
+Manufacturer#3 1337.29 45 2 2527.56 2522.56
+Manufacturer#3 1410.39 19 3 3937.95 3932.95
+Manufacturer#3 1671.68 17 4 5609.63 5604.63
+Manufacturer#3 1922.98 1 5 7532.610000000001 7527.610000000001
+Manufacturer#4 1206.26 27 1 1206.26 1201.26
+Manufacturer#4 1290.35 12 2 2496.6099999999997 2491.6099999999997
+Manufacturer#4 1375.42 39 3 3872.0299999999997 3867.0299999999997
+Manufacturer#4 1620.67 10 4 5492.7 5487.7
+Manufacturer#4 1844.92 7 5 7337.62 7332.62
+Manufacturer#5 1018.1 46 1 1018.1 1013.1
+Manufacturer#5 1464.48 23 2 2482.58 2477.58
+Manufacturer#5 1611.66 6 3 4094.24 4089.24
+Manufacturer#5 1788.73 2 4 5882.969999999999 5877.969999999999
+Manufacturer#5 1789.69 31 5 7672.66 7667.66
+PREHOOK: query: select s, si, f, si - lead(f, 3) over (partition by t order by bo desc) from over10k limit 100
+PREHOOK: type: QUERY
+PREHOOK: Input: default@over10k
+#### A masked pattern was here ####
+POSTHOOK: query: select s, si, f, si - lead(f, 3) over (partition by t order by bo desc) from over10k limit 100
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@over10k
+#### A masked pattern was here ####
+david hernandez 408 81.68 352.41
+mike allen 465 83.39 441.78
+sarah miller 386 58.81 297.22
+luke king 337 55.59 256.35
+nick robinson 350 23.22 349.17
+katie ichabod 469 88.78 400.27
+gabriella brown 498 80.65 415.26
+oscar davidson 432 0.83 350.05
+holly nixon 505 68.73 502.74
+holly polk 268 82.74 202.5
+rachel davidson 507 81.95 498.63
+mike polk 500 2.26 443.8
+yuri xylophone 430 65.5 357.74
+bob ellison 339 8.37 254.25
+luke ichabod 289 56.2 203.04001
+nick nixon 335 72.26 282.7
+holly thompson 387 84.75 331.59
+jessica miller 299 85.96 298.44
+calvin white 280 52.3 232.49
+oscar johnson 469 55.41 406.88
+rachel thompson 344 0.56 279.71
+david falkner 469 47.51 374.78
+mike white 454 62.12 431.65
+irene young 458 64.29 396.19
+oscar johnson 315 94.22 300.77
+bob johnson 374 22.35 345.22
+victor robinson 415 61.81 333.03
+ethan underhill 339 14.23 257.36
+xavier ovid 280 28.78 198.61
+mike xylophone 448 81.97 429.56
+tom hernandez 467 81.64 428.95
+tom steinbeck 414 81.39 316.12
+alice falkner 280 18.44 182.48999
+david carson 270 38.05 217.87
+sarah zipper 376 97.88 368.9
+tom hernandez 477 97.51 438.78
+victor thompson 344 52.13 332.93
+ulysses carson 343 7.1 282.72
+sarah xylophone 275 38.22 268.2
+oscar miller 324 11.07 251.7
+quinn polk 507 60.28 463.6
+luke young 451 6.8 422.25
+bob underhill 465 72.3 452.88
+victor allen 337 43.4 330.17
+xavier garcia 493 28.75 396.22
+zach thompson 386 12.12 293.29
+bob van buren 433 6.83 423.14
+fred ellison 376 96.78 304.03
+jessica king 459 92.71 399.93
+holly underhill 318 9.86 269.91
+alice davidson 384 71.97 340.31
+bob falkner 260 59.07 237.66
+jessica johnson 494 48.09 468.5
+victor hernandez 447 43.69 427.06
+ulysses steinbeck 333 22.34 273.66
+wendy quirinius 279 25.5 257.0
+quinn ellison 266 19.94 181.61
+ulysses ellison 381 59.34 377.18
+priscilla laertes 316 22.0 244.22
+sarah robinson 320 84.39 298.66
+luke garcia 311 3.82 290.05
+wendy robinson 275 71.78 231.27
+priscilla zipper 485 21.34 422.19
+bob polk 264 20.95 187.69
+oscar garcia 362 43.73 351.74
+jessica white 284 62.81 238.76
+alice allen 400 76.31 370.94
+ulysses quirinius 303 10.26 268.4
+irene ellison 458 45.24 394.51
+calvin ichabod 431 29.06 356.08002
+ethan steinbeck 298 34.6 234.81
+holly steinbeck 384 63.49 365.73
+mike king 275 74.92 261.33
+priscilla quirinius 423 63.19 360.61
+zach young 286 18.27 223.23
+wendy xylophone 314 13.67 223.7
+victor xylophone 438 62.39 420.4
+alice king 458 62.77 455.52
+irene underhill 307 90.3 295.17
+bob underhill 454 17.6 427.79
+alice king 455 2.48 381.16998
+david garcia 485 11.83 428.95
+alice xylophone 485 26.21 459.33
+bob ichabod 454 73.83 NULL
+tom polk 346 56.05 NULL
+ulysses robinson 313 25.67 NULL
+nick laertes 502 48.26 462.38
+oscar zipper 445 35.62 420.6
+nick falkner 384 1.65 378.41
+irene ichabod 409 39.62 321.22
+wendy ichabod 387 24.4 310.48
+ethan quirinius 503 5.59 431.97
+alice carson 473 87.78 455.91
+quinn laertes 340 76.52 295.12
+tom xylophone 352 71.03 295.24
+tom ellison 420 17.09 346.94
+fred ichabod 371 44.88 298.41
+luke xylophone 395 56.76 319.22
+quinn hernandez 456 73.06 439.65
+ethan falkner 261 72.59 212.26
+PREHOOK: query: select s, i, i - lead(i, 3, 0) over (partition by si order by i) from over10k limit 100
+PREHOOK: type: QUERY
+PREHOOK: Input: default@over10k
+#### A masked pattern was here ####
+POSTHOOK: query: select s, i, i - lead(i, 3, 0) over (partition by si order by i) from over10k limit 100
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@over10k
+#### A masked pattern was here ####
+wendy garcia 65540 -18
+ethan thompson 65543 -20
+zach nixon 65549 -31
+alice robinson 65558 -28
+wendy nixon 65563 -33
+victor robinson 65580 -19
+ethan falkner 65586 -18
+victor davidson 65596 -17
+xavier quirinius 65599 -14
+fred quirinius 65604 -11
+xavier van buren 65613 -3
+nick zipper 65613 -7
+victor johnson 65615 -12
+alice ovid 65616 -24
+xavier ovid 65620 -23
+ulysses white 65627 -24
+sarah white 65640 -13
+calvin young 65643 -25
+victor thompson 65651 -42
+calvin johnson 65653 -53
+irene polk 65668 -45
+zach underhill 65693 -38
+quinn hernandez 65706 -27
+rachel ovid 65713 -24
+gabriella falkner 65731 -7
+zach white 65733 -8
+fred hernandez 65737 -7
+rachel ellison 65738 -6
+oscar steinbeck 65741 -6
+tom allen 65744 -8
+alice ellison 65744 -19
+quinn quirinius 65747 -31
+victor hernandez 65752 -26
+holly xylophone 65763 -26
+david davidson 65778 65778
+ulysses young 65778 65778
+sarah brown 65789 65789
+xavier brown 65541 -16
+zach hernandez 65542 -18
+katie ichabod 65547 -19
+oscar young 65557 -15
+holly white 65560 -14
+priscilla laertes 65566 -9
+ethan king 65572 -6
+zach hernandez 65574 -10
+oscar thompson 65575 -13
+victor xylophone 65578 -16
+gabriella ellison 65584 -26
+nick quirinius 65588 -22
+holly robinson 65594 -18
+yuri brown 65610 -16
+alice xylophone 65610 -21
+sarah hernandez 65612 -26
+katie garcia 65626 -28
+jessica laertes 65631 -23
+ethan underhill 65638 -17
+priscilla thompson 65654 -37
+irene young 65654 -40
+luke quirinius 65655 -44
+david brown 65691 -20
+luke falkner 65694 -18
+priscilla miller 65699 -20
+rachel robinson 65711 -9
+ethan polk 65712 -10
+wendy brown 65719 -13
+mike underhill 65720 -18
+zach underhill 65722 -26
+nick zipper 65732 -20
+fred brown 65738 -18
+ulysses young 65748 -23
+nick davidson 65752 -19
+fred zipper 65756 -15
+yuri nixon 65771 -10
+zach zipper 65771 -19
+zach hernandez 65771 65771
+alice underhill 65781 65781
+oscar laertes 65790 65790
+sarah zipper 65546 -19
+luke ovid 65551 -17
+bob falkner 65551 -17
+katie allen 65565 -4
+zach steinbeck 65568 -5
+nick falkner 65568 -11
+oscar van buren 65569 -13
+gabriella young 65573 -11
+jessica ichabod 65579 -24
+david garcia 65582 -24
+nick xylophone 65584 -27
+calvin johnson 65603 -14
+xavier zipper 65606 -50
+alice nixon 65611 -58
+jessica laertes 65617 -62
+fred king 65656 -61
+priscilla underhill 65669 -48
+priscilla zipper 65679 -45
+sarah polk 65717 -11
+nick king 65717 -17
+irene quirinius 65724 -28
+tom laertes 65728 -25
+yuri johnson 65734 -27
+PREHOOK: query: select s, si, d, si - lag(d, 3) over (partition by b order by si) from over10k limit 100
+PREHOOK: type: QUERY
+PREHOOK: Input: default@over10k
+#### A masked pattern was here ####
+POSTHOOK: query: select s, si, d, si - lag(d, 3) over (partition by b order by si) from over10k limit 100
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@over10k
+#### A masked pattern was here ####
+jessica ellison 262 30.41 NULL
+david young 266 45.12 NULL
+jessica steinbeck 274 2.15 NULL
+david zipper 275 43.45 244.59
+zach nixon 283 15.95 237.88
+holly allen 285 24.37 282.85
+irene garcia 292 33.54 248.55
+ulysses xylophone 292 44.66 276.05
+irene van buren 309 35.81 284.63
+sarah miller 312 6.65 278.46
+victor garcia 312 39.14 267.34000000000003
+ethan ichabod 319 29.4 283.19
+wendy falkner 322 10.02 315.35
+oscar miller 324 25.95 284.86
+david ovid 332 28.34 302.6
+alice zipper 333 3.38 322.98
+yuri nixon 333 8.28 307.05
+ulysses nixon 335 18.48 306.66
+david ovid 336 9.36 332.62
+calvin falkner 337 17.63 328.72
+katie quirinius 349 11.3 330.52
+quinn miller 351 22.46 341.64
+victor xylophone 357 38.58 339.37
+ethan garcia 368 9.2 356.7
+nick steinbeck 395 37.54 372.54
+ulysses ichabod 415 47.61 376.42
+rachel thompson 416 37.99 406.8
+calvin young 418 47.22 380.46
+katie xylophone 425 32.59 377.39
+nick quirinius 429 19.63 391.01
+ethan ellison 453 47.92 405.78
+irene nixon 454 48.03 421.40999999999997
+bob steinbeck 462 47.04 442.37
+luke robinson 462 47.48 414.08
+tom hernandez 467 29.36 418.97
+gabriella steinbeck 467 9.35 419.96
+irene polk 485 14.26 437.52
+mike xylophone 494 36.92 464.64
+calvin allen 499 39.99 489.65
+quinn steinbeck 503 16.62 488.74
+ulysses garcia 263 31.85 NULL
+calvin thompson 263 30.87 NULL
+rachel quirinius 263 29.46 NULL
+mike steinbeck 266 48.57 234.15
+rachel young 275 14.75 244.13
+tom king 278 31.11 248.54
+oscar robinson 283 30.35 234.43
+zach allen 284 1.88 269.25
+bob king 308 27.61 276.89
+ulysses allen 310 22.77 279.65
+fred nixon 317 0.48 315.12
+gabriella robinson 321 0.33 293.39
+bob johnson 325 9.61 302.23
+rachel davidson 335 2.34 334.52
+fred brown 337 5.8 336.67
+wendy ellison 350 20.25 340.39
+zach falkner 391 13.67 388.66
+katie xylophone 410 39.09 404.2
+holly king 413 3.56 392.75
+sarah van buren 417 7.81 403.33
+calvin van buren 430 36.01 390.90999999999997
+katie white 434 33.56 430.44
+oscar quirinius 454 7.03 446.19
+zach young 505 18.19 468.99
+gabriella robinson 506 12.8 472.44
+sarah xylophone 507 16.09 499.97
+rachel thompson 267 46.87 NULL
+gabriella van buren 271 41.04 NULL
+mike steinbeck 284 11.44 NULL
+luke falkner 293 40.67 246.13
+ethan ovid 293 2.08 251.96
+irene nixon 321 24.35 309.56
+mike van buren 327 2.58 286.33
+ulysses robinson 329 26.64 326.92
+quinn laertes 332 10.71 307.65
+tom polk 346 34.03 343.42
+jessica johnson 352 45.71 325.36
+xavier davidson 354 33.9 343.29
+wendy nixon 364 29.42 329.97
+jessica quirinius 375 47.33 329.29
+xavier brown 376 26.17 342.1
+gabriella davidson 383 18.87 353.58
+jessica brown 388 34.09 340.67
+gabriella garcia 391 32.44 364.83
+ethan miller 396 49.07 377.13
+bob garcia 416 7.82 381.90999999999997
+priscilla hernandez 416 29.94 383.56
+holly nixon 419 17.81 369.93
+nick underhill 429 39.54 421.18
+xavier falkner 434 0.88 404.06
+luke robinson 461 44.02 443.19
+bob underhill 465 22.58 425.46
+ulysses king 483 37.98 482.12
+jessica miller 486 26.14 441.98
+bob ovid 493 9.7 470.42
+alice falkner 500 37.85 462.02
+quinn xylophone 267 49.8 NULL
+gabriella thompson 268 17.15 NULL
+calvin xylophone 275 49.32 NULL
+gabriella zipper 279 30.41 229.2
+PREHOOK: query: select s, lag(s, 3, 'fred') over (partition by f order by b) from over10k limit 100
+PREHOOK: type: QUERY
+PREHOOK: Input: default@over10k
+#### A masked pattern was here ####
+POSTHOOK: query: select s, lag(s, 3, 'fred') over (partition by f order by b) from over10k limit 100
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@over10k
+#### A masked pattern was here ####
+yuri thompson fred
+bob ichabod fred
+luke king fred
+luke steinbeck fred
+fred zipper fred
+quinn miller fred
+calvin van buren fred
+holly steinbeck fred
+david davidson fred
+calvin thompson fred
+calvin quirinius fred
+david ovid fred
+holly thompson fred
+nick zipper fred
+victor steinbeck fred
+victor robinson fred
+zach ovid fred
+ulysses zipper fred
+luke falkner fred
+irene thompson fred
+yuri johnson fred
+ulysses falkner fred
+gabriella robinson fred
+alice robinson fred
+priscilla xylophone fred
+david laertes fred
+mike underhill fred
+victor van buren fred
+holly falkner fred
+priscilla falkner fred
+ethan ovid fred
+luke zipper fred
+mike steinbeck fred
+calvin white fred
+alice quirinius fred
+irene miller fred
+wendy polk fred
+nick young fred
+yuri davidson fred
+ethan ellison fred
+zach hernandez fred
+wendy miller fred
+katie underhill fred
+irene zipper fred
+holly allen fred
+quinn brown fred
+calvin ovid fred
+zach robinson fred
+nick miller fred
+mike allen fred
+yuri van buren fred
+priscilla young fred
+zach miller fred
+victor xylophone fred
+sarah falkner fred
+rachel ichabod fred
+alice robinson fred
+calvin ovid fred
+calvin ovid fred
+luke laertes fred
+david hernandez fred
+alice ovid fred
+luke quirinius fred
+oscar white fred
+zach falkner fred
+rachel thompson fred
+priscilla king fred
+xavier polk fred
+wendy ichabod fred
+rachel ovid fred
+wendy allen fred
+luke brown fred
+mike brown fred
+oscar ichabod fred
+xavier garcia fred
+yuri brown fred
+bob xylophone fred
+luke davidson fred
+ethan quirinius fred
+zach davidson fred
+irene miller fred
+wendy king fred
+bob zipper fred
+sarah thompson fred
+bob carson fred
+bob laertes fred
+xavier allen fred
+sarah robinson fred
+david king fred
+oscar davidson fred
+victor hernandez fred
+wendy polk fred
+david ellison fred
+ulysses johnson fred
+jessica ovid fred
+bob king fred
+ulysses garcia fred
+irene falkner fred
+holly robinson fred
+yuri white fred
+PREHOOK: query: select p_mfgr, avg(p_retailprice) over(partition by p_mfgr, p_type order by p_mfgr) from part
+PREHOOK: type: QUERY
+PREHOOK: Input: default@part
+#### A masked pattern was here ####
+POSTHOOK: query: select p_mfgr, avg(p_retailprice) over(partition by p_mfgr, p_type order by p_mfgr) from part
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@part
+#### A masked pattern was here ####
+Manufacturer#1 1753.76
+Manufacturer#1 1632.66
+Manufacturer#1 1602.59
+Manufacturer#1 1173.15
+Manufacturer#1 1173.15
+Manufacturer#1 1414.42
+Manufacturer#2 1800.7
+Manufacturer#2 1690.68
+Manufacturer#2 2031.98
+Manufacturer#2 1698.66
+Manufacturer#2 1701.6
+Manufacturer#3 1922.98
+Manufacturer#3 1410.39
+Manufacturer#3 1671.68
+Manufacturer#3 1190.27
+Manufacturer#3 1337.29
+Manufacturer#4 1844.92
+Manufacturer#4 1375.42
+Manufacturer#4 1620.67
+Manufacturer#4 1206.26
+Manufacturer#4 1290.35
+Manufacturer#5 1018.1
+Manufacturer#5 1464.48
+Manufacturer#5 1789.69
+Manufacturer#5 1788.73
+Manufacturer#5 1611.66
+PREHOOK: query: select p_mfgr, avg(p_retailprice) over(partition by p_mfgr order by p_type,p_mfgr rows between unbounded preceding and current row) from part
+PREHOOK: type: QUERY
+PREHOOK: Input: default@part
+#### A masked pattern was here ####
+POSTHOOK: query: select p_mfgr, avg(p_retailprice) over(partition by p_mfgr order by p_type,p_mfgr rows between unbounded preceding and current row) from part
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@part
+#### A masked pattern was here ####
+Manufacturer#1 1753.76
+Manufacturer#1 1693.21
+Manufacturer#1 1663.0033333333333
+Manufacturer#1 1540.54
+Manufacturer#1 1467.062
+Manufacturer#1 1458.2883333333332
+Manufacturer#2 1800.7
+Manufacturer#2 1745.69
+Manufacturer#2 1841.1200000000001
+Manufacturer#2 1805.505
+Manufacturer#2 1784.7240000000002
+Manufacturer#3 1922.98
+Manufacturer#3 1666.685
+Manufacturer#3 1668.3500000000001
+Manufacturer#3 1548.83
+Manufacturer#3 1506.522
+Manufacturer#4 1844.92
+Manufacturer#4 1610.17
+Manufacturer#4 1613.67
+Manufacturer#4 1511.8175
+Manufacturer#4 1467.5240000000001
+Manufacturer#5 1018.1
+Manufacturer#5 1241.29
+Manufacturer#5 1424.0900000000001
+Manufacturer#5 1515.25
+Manufacturer#5 1534.532
Added: hive/trunk/ql/src/test/results/clientpositive/windowing_multipartitioning.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/windowing_multipartitioning.q.out?rev=1463556&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/windowing_multipartitioning.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/windowing_multipartitioning.q.out Tue Apr 2 14:16:34 2013
@@ -0,0 +1,361 @@
+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 () 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 () from over10k where s = 'tom allen' or s = 'bob steinbeck'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@over10k
+#### A masked pattern was here ####
+bob steinbeck 47.810001373291016 1
+tom allen 11.069999694824219 2
+tom allen 54.00000190734863 3
+tom allen 54.00000190734863 4
+tom allen 26.239999771118164 5
+bob steinbeck 28.479999542236328 6
+tom allen 81.8499984741211 7
+tom allen 15.84000015258789 8
+bob steinbeck 83.52999877929688 9
+bob steinbeck 38.33000183105469 10
+bob steinbeck 83.52999877929688 11
+bob steinbeck 80.7300033569336 12
+bob steinbeck 9.699999809265137 13
+tom allen 89.88999938964844 14
+bob steinbeck 26.290000915527344 15
+bob steinbeck 36.209999084472656 16
+tom allen 52.779998779296875 17
+tom allen 11.300000190734863 18
+tom allen 77.77999877929688 19
+tom allen 40.5099983215332 20
+bob steinbeck 82.19000244140625 21
+tom allen 83.47000122070312 22
+tom allen 38.93000030517578 23
+tom allen 47.16999816894531 24
+tom allen 19.459999084472656 25
+tom allen 50.630001068115234 26
+bob steinbeck 27.959999084472656 27
+tom allen 2.8499999046325684 28
+tom allen 95.41000366210938 29
+tom allen 55.38999938964844 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
Added: hive/trunk/ql/src/test/results/clientpositive/windowing_navfn.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/windowing_navfn.q.out?rev=1463556&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/windowing_navfn.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/windowing_navfn.q.out Tue Apr 2 14:16:34 2013
@@ -0,0 +1,581 @@
+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, 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 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 desc) from over10k limit 100
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@over10k
+#### A masked pattern was here ####
+65551 sarah steinbeck
+65575 holly underhill
+65779 yuri thompson
+65603 irene brown
+65700 alice ovid
+65761 zach polk
+65662 bob king
+65646 irene garcia
+65683 sarah underhill
+65732 bob underhill
+65683 david robinson
+65680 irene nixon
+65771 david young
+65698 ulysses johnson
+65776 priscilla nixon
+65677 jessica thompson
+65575 jessica ovid
+65546 irene zipper
+65689 nick king
+65732 katie laertes
+65559 bob quirinius
+65572 alice davidson
+65690 bob zipper
+65659 yuri ellison
+65536 ulysses garcia
+65762 mike hernandez
+65537 david laertes
+65720 tom johnson
+65536 wendy brown
+65728 alice steinbeck
+65599 ethan brown
+65598 gabriella zipper
+65738 oscar king
+65550 katie falkner
+65621 sarah hernandez
+65540 mike allen
+65646 sarah thompson
+65716 fred laertes
+65603 ulysses underhill
+65745 zach davidson
+65791 katie garcia
+65661 quinn carson
+65644 katie laertes
+65745 mike garcia
+65669 bob carson
+65775 irene van buren
+65589 sarah young
+65758 quinn nixon
+65677 wendy ichabod
+65725 ethan thompson
+65768 sarah king
+65784 irene polk
+65670 holly king
+65759 irene young
+65679 nick laertes
+65740 wendy nixon
+65746 holly van buren
+65572 xavier johnson
+65607 irene van buren
+65671 alice king
+65538 katie van buren
+65649 tom quirinius
+65540 quinn white
+65660 zach ellison
+65692 alice quirinius
+65577 ethan hernandez
+65553 calvin robinson
+65758 mike garcia
+65692 ethan nixon
+65766 mike ichabod
+65571 irene johnson
+65568 yuri xylophone
+65667 nick ellison
+65691 ethan brown
+65791 quinn ovid
+65573 zach thompson
+65551 alice garcia
+65759 ulysses king
+65732 gabriella laertes
+65609 bob garcia
+65585 priscilla robinson
+65640 xavier ellison
+65647 fred zipper
+65735 quinn polk
+65625 victor robinson
+65746 bob steinbeck
+65617 katie allen
+65658 quinn davidson
+65659 victor allen
+65707 alice falkner
+65775 zach nixon
+65752 tom polk
+65700 nick brown
+65587 bob van buren
+65661 katie polk
+65680 rachel polk
+65634 rachel king
+65756 xavier ichabod
+65783 luke garcia
+65650 tom carson
+PREHOOK: query: select i, lag(dec) over (partition by i order by s) 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) 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
Added: hive/trunk/ql/src/test/results/clientpositive/windowing_ntile.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/windowing_ntile.q.out?rev=1463556&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/windowing_ntile.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/windowing_ntile.q.out Tue Apr 2 14:16:34 2013
@@ -0,0 +1,473 @@
+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 i, ntile(10) over (partition by s) from over10k limit 100
+PREHOOK: type: QUERY
+PREHOOK: Input: default@over10k
+#### A masked pattern was here ####
+POSTHOOK: query: select i, ntile(10) over (partition by s) from over10k limit 100
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@over10k
+#### A masked pattern was here ####
+65600 1
+65758 2
+65609 3
+65557 4
+65662 5
+65670 6
+65545 7
+65720 8
+65790 1
+65781 1
+65570 2
+65708 2
+65704 3
+65707 3
+65779 4
+65667 4
+65673 5
+65711 6
+65569 7
+65666 8
+65733 9
+65696 10
+65785 1
+65710 2
+65747 3
+65713 4
+65559 5
+65559 6
+65545 7
+65565 8
+65695 9
+65576 10
+65547 1
+65677 1
+65676 2
+65596 2
+65791 3
+65707 3
+65690 4
+65563 4
+65560 5
+65641 5
+65544 6
+65677 6
+65590 7
+65747 7
+65740 8
+65554 8
+65631 9
+65742 10
+65730 1
+65612 1
+65745 2
+65677 2
+65699 3
+65713 3
+65544 4
+65537 4
+65557 5
+65698 5
+65787 6
+65741 7
+65572 8
+65681 9
+65744 10
+65773 1
+65611 1
+65669 2
+65699 2
+65752 3
+65722 3
+65597 4
+65715 4
+65709 5
+65718 5
+65622 6
+65775 6
+65690 7
+65685 7
+65596 8
+65710 9
+65785 10
+65623 1
+65746 1
+65725 2
+65712 2
+65759 3
+65613 3
+65744 4
+65573 5
+65630 6
+65674 7
+65675 8
+65746 9
+65734 10
+65543 1
+65685 1
+65684 2
+65691 2
+65737 3
+PREHOOK: query: select s, ntile(100) over (partition by i) from over10k limit 100
+PREHOOK: type: QUERY
+PREHOOK: Input: default@over10k
+#### A masked pattern was here ####
+POSTHOOK: query: select s, ntile(100) over (partition by i) from over10k limit 100
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@over10k
+#### A masked pattern was here ####
+rachel ichabod 1
+alice robinson 2
+priscilla young 3
+david laertes 4
+david nixon 5
+wendy polk 6
+alice ichabod 7
+holly white 8
+xavier davidson 9
+oscar ovid 10
+sarah thompson 11
+ethan johnson 12
+tom steinbeck 13
+katie ellison 14
+gabriella garcia 15
+luke allen 16
+zach hernandez 17
+nick davidson 18
+zach allen 19
+sarah thompson 20
+david johnson 21
+bob robinson 22
+ethan ovid 23
+calvin thompson 24
+rachel brown 25
+rachel xylophone 26
+tom johnson 27
+ulysses polk 28
+oscar allen 29
+irene johnson 30
+oscar ichabod 31
+yuri ellison 32
+fred miller 33
+mike white 34
+david nixon 35
+priscilla white 36
+oscar garcia 37
+fred miller 38
+victor johnson 39
+oscar steinbeck 40
+priscilla garcia 41
+gabriella underhill 42
+priscilla xylophone 43
+mike quirinius 44
+ethan underhill 45
+oscar carson 1
+nick carson 2
+katie thompson 3
+victor xylophone 4
+xavier underhill 5
+zach nixon 6
+bob carson 7
+yuri garcia 8
+fred van buren 9
+sarah ichabod 10
+oscar robinson 11
+david xylophone 12
+wendy garcia 13
+mike garcia 14
+ulysses falkner 15
+sarah falkner 16
+mike hernandez 17
+fred johnson 18
+katie robinson 19
+holly quirinius 20
+luke nixon 21
+alice ellison 22
+yuri quirinius 23
+zach falkner 24
+zach ovid 25
+gabriella ichabod 26
+priscilla white 27
+ethan white 28
+calvin brown 29
+jessica hernandez 30
+wendy van buren 31
+holly laertes 32
+zach ichabod 33
+nick davidson 34
+yuri white 35
+victor garcia 1
+sarah ichabod 2
+mike brown 3
+holly thompson 4
+alice king 5
+quinn garcia 6
+holly hernandez 7
+gabriella nixon 8
+zach van buren 9
+katie nixon 10
+luke davidson 11
+rachel young 12
+alice robinson 13
+oscar white 14
+holly falkner 15
+tom polk 16
+quinn laertes 17
+calvin allen 18
+luke brown 19
+xavier davidson 20
+PREHOOK: query: select f, ntile(4) over (partition by d) from over10k limit 100
+PREHOOK: type: QUERY
+PREHOOK: Input: default@over10k
+#### A masked pattern was here ####
+POSTHOOK: query: select f, ntile(4) over (partition by d) from over10k limit 100
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@over10k
+#### A masked pattern was here ####
+8.39 1
+25.5 1
+5.29 2
+37.59 3
+79.24 1
+60.0 1
+48.5 2
+77.84 3
+51.57 1
+14.36 2
+87.91 3
+40.91 1
+59.09 2
+31.46 1
+46.55 2
+92.71 3
+59.72 1
+98.89 2
+97.35 3
+19.11 1
+35.21 1
+13.33 2
+30.47 1
+90.04 1
+77.44 1
+15.36 2
+60.76 3
+9.07 1
+50.08 1
+13.3 1
+87.05 1
+66.95 1
+3.94 2
+41.66 1
+75.93 2
+48.52 3
+18.65 4
+70.77 1
+84.83 2
+50.15 3
+64.79 1
+88.94 2
+96.71 1
+1.42 2
+94.14 1
+9.88 2
+25.69 1
+67.56 2
+85.72 3
+82.8 1
+40.0 1
+95.11 2
+61.73 3
+30.0 4
+80.65 1
+96.54 1
+7.96 2
+61.07 1
+20.74 1
+89.36 2
+49.61 3
+69.97 4
+61.71 1
+38.69 2
+2.66 3
+58.25 4
+32.69 1
+98.29 2
+25.63 1
+0.62 2
+90.1 3
+69.42 1
+29.06 2
+85.03 1
+38.09 2
+68.81 3
+75.75 1
+88.22 2
+24.02 1
+77.6 2
+76.99 1
+96.45 1
+1.09 1
+57.61 1
+84.92 2
+26.21 3
+80.99 1
+39.16 1
+39.82 2
+44.57 1
+24.15 2
+38.05 1
+81.55 2
+74.45 1
+49.13 2
+42.49 1
+67.28 1
+49.09 2
+37.63 3
+10.6 1
+PREHOOK: query: select d, ntile(1000) over (partition by dec) from over10k limit 100
+PREHOOK: type: QUERY
+PREHOOK: Input: default@over10k
+#### A masked pattern was here ####
+POSTHOOK: query: select d, ntile(1000) over (partition by dec) from over10k limit 100
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@over10k
+#### A masked pattern was here ####
+41.04 1
+9.71 2
+43.7 1
+33.72 1
+1.42 2
+4.83 1
+12.49 1
+6.26 1
+14.11 2
+41.76 3
+6.55 1
+32.62 1
+11.27 2
+40.35 3
+41.23 1
+39.43 1
+21.2 1
+40.64 1
+43.97 1
+12.07 2
+27.64 1
+4.1 1
+0.7 2
+33.38 1
+33.65 1
+18.69 2
+2.2 1
+0.38 1
+15.83 1
+43.34 1
+11.38 2
+23.27 1
+38.18 2
+15.95 3
+20.76 1
+5.63 1
+13.64 1
+34.33 2
+43.48 3
+46.79 1
+44.21 2
+6.52 1
+3.59 1
+40.26 2
+25.9 1
+16.31 2
+46.21 3
+45.08 1
+7.91 1
+24.37 2
+37.13 1
+39.25 1
+5.37 2
+7.64 1
+7.25 2
+16.09 3
+49.82 1
+16.08 1
+4.6 1
+14.12 1
+28.42 1
+27.58 2
+45.53 3
+48.56 4
+36.7 1
+32.68 1
+40.09 1
+3.17 2
+24.84 3
+26.36 1
+33.49 1
+24.76 1
+26.72 1
+13.95 1
+22.1 1
+18.94 1
+15.41 1
+10.76 1
+21.78 1
+39.02 2
+19.4 1
+25.37 1
+3.08 1
+6.32 1
+33.75 1
+49.49 1
+37.82 1
+15.27 1
+15.22 1
+40.54 1
+11.43 2
+22.64 1
+4.81 2
+14.18 1
+44.83 1
+5.15 1
+7.52 1
+2.78 2
+3.7 3
+45.55 4
Added: hive/trunk/ql/src/test/results/clientpositive/windowing_rank.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/windowing_rank.q.out?rev=1463556&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/windowing_rank.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/windowing_rank.q.out Tue Apr 2 14:16:34 2013
@@ -0,0 +1,593 @@
+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 f order by t) from over10k limit 100
+PREHOOK: type: QUERY
+PREHOOK: Input: default@over10k
+#### A masked pattern was here ####
+POSTHOOK: query: select s, rank() over (partition by f order by t) from over10k limit 100
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@over10k
+#### A masked pattern was here ####
+bob ichabod 1
+yuri thompson 2
+luke steinbeck 1
+fred zipper 2
+luke king 3
+calvin van buren 1
+quinn miller 2
+holly steinbeck 1
+david davidson 1
+calvin quirinius 1
+calvin thompson 2
+david ovid 1
+nick zipper 2
+holly thompson 3
+victor steinbeck 1
+victor robinson 2
+zach ovid 1
+ulysses zipper 1
+irene thompson 1
+luke falkner 2
+yuri johnson 1
+ulysses falkner 1
+gabriella robinson 2
+alice robinson 1
+priscilla xylophone 2
+david laertes 1
+mike underhill 2
+victor van buren 1
+holly falkner 1
+priscilla falkner 1
+luke zipper 1
+ethan ovid 2
+alice quirinius 1
+calvin white 2
+mike steinbeck 3
+nick young 1
+wendy polk 2
+irene miller 3
+ethan ellison 1
+yuri davidson 2
+zach hernandez 1
+wendy miller 1
+katie underhill 1
+irene zipper 1
+holly allen 1
+quinn brown 2
+calvin ovid 1
+zach robinson 1
+nick miller 2
+mike allen 1
+priscilla young 1
+yuri van buren 2
+zach miller 3
+sarah falkner 1
+victor xylophone 2
+rachel ichabod 1
+calvin ovid 1
+alice robinson 2
+calvin ovid 1
+alice ovid 1
+david hernandez 2
+luke laertes 3
+luke quirinius 1
+oscar white 1
+zach falkner 1
+rachel thompson 1
+priscilla king 1
+xavier polk 1
+wendy ichabod 1
+rachel ovid 1
+wendy allen 1
+luke brown 1
+oscar ichabod 2
+mike brown 3
+xavier garcia 1
+bob xylophone 1
+yuri brown 2
+ethan quirinius 1
+luke davidson 2
+zach davidson 1
+irene miller 1
+wendy king 1
+bob zipper 1
+sarah thompson 1
+bob laertes 1
+xavier allen 2
+bob carson 3
+sarah robinson 1
+david king 1
+oscar davidson 1
+wendy polk 1
+victor hernandez 2
+david ellison 1
+ulysses johnson 1
+jessica ovid 1
+bob king 1
+ulysses garcia 1
+irene falkner 1
+holly robinson 1
+yuri white 1
+PREHOOK: query: select s, dense_rank() over (partition by ts order by i desc) from over10k limit 100
+PREHOOK: type: QUERY
+PREHOOK: Input: default@over10k
+#### A masked pattern was here ####
+POSTHOOK: query: select s, dense_rank() over (partition by ts order by i desc) from over10k limit 100
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@over10k
+#### A masked pattern was here ####
+jessica polk 1
+calvin steinbeck 2
+katie king 3
+rachel garcia 3
+bob ovid 4
+mike laertes 5
+gabriella xylophone 6
+sarah falkner 7
+jessica laertes 8
+tom johnson 9
+calvin brown 10
+yuri allen 11
+calvin laertes 12
+nick carson 13
+david falkner 14
+victor ellison 15
+luke zipper 16
+gabriella van buren 17
+fred nixon 18
+priscilla zipper 19
+katie white 19
+fred zipper 20
+wendy steinbeck 21
+victor van buren 21
+oscar brown 22
+rachel thompson 23
+luke king 1
+holly thompson 1
+luke xylophone 2
+rachel robinson 3
+wendy thompson 4
+priscilla hernandez 5
+fred polk 6
+irene brown 7
+rachel young 8
+bob falkner 9
+katie davidson 10
+rachel ovid 11
+jessica brown 12
+holly falkner 13
+sarah van buren 14
+yuri hernandez 15
+zach young 16
+calvin carson 17
+bob king 18
+calvin nixon 19
+gabriella johnson 20
+xavier johnson 20
+ethan young 21
+jessica brown 22
+jessica nixon 23
+fred king 23
+ulysses johnson 23
+wendy johnson 24
+oscar davidson 25
+nick ellison 26
+luke steinbeck 27
+jessica robinson 28
+priscilla brown 29
+gabriella underhill 29
+gabriella steinbeck 30
+luke thompson 31
+alice miller 32
+oscar van buren 32
+yuri brown 33
+rachel ovid 34
+katie xylophone 35
+quinn ovid 36
+priscilla zipper 37
+victor underhill 38
+ulysses xylophone 38
+quinn allen 39
+katie zipper 40
+calvin white 41
+ethan ovid 42
+xavier davidson 43
+oscar carson 1
+priscilla garcia 2
+priscilla hernandez 3
+bob carson 4
+quinn van buren 5
+rachel ichabod 6
+ethan ichabod 6
+jessica ovid 7
+ulysses carson 7
+holly allen 8
+wendy falkner 8
+rachel ellison 9
+jessica johnson 10
+rachel ichabod 11
+wendy underhill 12
+sarah falkner 13
+tom hernandez 14
+jessica thompson 15
+alice underhill 16
+ethan nixon 16
+priscilla polk 17
+victor hernandez 18
+holly nixon 19
+priscilla thompson 20
+PREHOOK: query: select s, cume_dist() over (partition by bo order by b) from over10k limit 100
+PREHOOK: type: QUERY
+PREHOOK: Input: default@over10k
+#### A masked pattern was here ####
+POSTHOOK: query: select s, cume_dist() over (partition by bo order by b) from over10k limit 100
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@over10k
+#### A masked pattern was here ####
+holly allen 2.0112630732099757E-4
+wendy falkner 2.0112630732099757E-4
+david ovid 2.0112630732099757E-4
+victor garcia 2.0112630732099757E-4
+katie xylophone 2.0112630732099757E-4
+ulysses xylophone 2.0112630732099757E-4
+nick steinbeck 2.0112630732099757E-4
+ethan ellison 2.0112630732099757E-4
+nick quirinius 2.0112630732099757E-4
+irene garcia 2.0112630732099757E-4
+mike xylophone 2.0112630732099757E-4
+victor xylophone 2.0112630732099757E-4
+jessica steinbeck 2.0112630732099757E-4
+irene van buren 2.0112630732099757E-4
+quinn steinbeck 2.0112630732099757E-4
+calvin allen 2.0112630732099757E-4
+david zipper 2.0112630732099757E-4
+sarah miller 2.0112630732099757E-4
+ulysses nixon 2.0112630732099757E-4
+ulysses ichabod 2.0112630732099757E-4
+yuri nixon 2.0112630732099757E-4
+tom hernandez 2.0112630732099757E-4
+rachel thompson 2.0112630732099757E-4
+katie xylophone 0.004827031375703942
+oscar quirinius 0.004827031375703942
+rachel davidson 0.004827031375703942
+sarah van buren 0.004827031375703942
+ulysses allen 0.004827031375703942
+bob king 0.004827031375703942
+bob johnson 0.004827031375703942
+calvin van buren 0.004827031375703942
+tom king 0.004827031375703942
+zach young 0.004827031375703942
+zach allen 0.004827031375703942
+mike steinbeck 0.004827031375703942
+wendy ellison 0.004827031375703942
+gabriella robinson 0.004827031375703942
+xavier davidson 0.007642799678197908
+jessica miller 0.007642799678197908
+mike steinbeck 0.007642799678197908
+alice falkner 0.007642799678197908
+irene nixon 0.007642799678197908
+jessica brown 0.007642799678197908
+ethan ovid 0.007642799678197908
+ulysses king 0.007642799678197908
+gabriella davidson 0.007642799678197908
+jessica quirinius 0.007642799678197908
+luke falkner 0.007642799678197908
+luke robinson 0.007642799678197908
+priscilla hernandez 0.007642799678197908
+mike van buren 0.007642799678197908
+ulysses robinson 0.007642799678197908
+bob underhill 0.007642799678197908
+bob ovid 0.007642799678197908
+tom polk 0.007642799678197908
+gabriella garcia 0.007642799678197908
+wendy allen 0.011464199517296863
+victor robinson 0.011464199517296863
+calvin nixon 0.011464199517296863
+wendy nixon 0.011464199517296863
+mike falkner 0.011464199517296863
+nick falkner 0.011464199517296863
+priscilla nixon 0.011464199517296863
+david davidson 0.011464199517296863
+bob underhill 0.011464199517296863
+oscar laertes 0.011464199517296863
+oscar miller 0.011464199517296863
+priscilla xylophone 0.011464199517296863
+jessica robinson 0.011464199517296863
+quinn miller 0.011464199517296863
+yuri ellison 0.011464199517296863
+holly falkner 0.011464199517296863
+oscar thompson 0.011464199517296863
+irene laertes 0.011464199517296863
+alice hernandez 0.011464199517296863
+luke johnson 0.015285599356395816
+fred carson 0.015285599356395816
+nick allen 0.015285599356395816
+nick ellison 0.015285599356395816
+priscilla laertes 0.015285599356395816
+priscilla underhill 0.015285599356395816
+calvin nixon 0.015285599356395816
+oscar king 0.015285599356395816
+katie polk 0.015285599356395816
+irene king 0.015285599356395816
+jessica davidson 0.015285599356395816
+victor steinbeck 0.015285599356395816
+priscilla young 0.015285599356395816
+katie polk 0.015285599356395816
+holly davidson 0.015285599356395816
+wendy miller 0.015285599356395816
+zach johnson 0.01850362027353178
+mike falkner 0.01850362027353178
+victor zipper 0.01850362027353178
+wendy king 0.01850362027353178
+fred ellison 0.01850362027353178
+mike hernandez 0.01850362027353178
+xavier allen 0.01850362027353178
+zach zipper 0.01850362027353178
+ethan laertes 0.01850362027353178
+PREHOOK: query: select s, percent_rank() over (partition by dec order by f) from over10k limit 100
+PREHOOK: type: QUERY
+PREHOOK: Input: default@over10k
+#### A masked pattern was here ####
+POSTHOOK: query: select s, percent_rank() over (partition by dec order by f) from over10k limit 100
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@over10k
+#### A masked pattern was here ####
+wendy king 0.0
+calvin robinson 1.0
+mike steinbeck 0.0
+calvin hernandez 0.0
+sarah king 1.0
+yuri ellison 0.0
+victor king 0.0
+alice ovid 0.0
+ethan steinbeck 0.5
+mike steinbeck 1.0
+gabriella young 0.0
+jessica johnson 0.0
+holly king 0.5
+tom young 1.0
+victor falkner 0.0
+ethan polk 0.0
+oscar miller 0.0
+ethan quirinius 0.0
+fred hernandez 0.0
+david steinbeck 1.0
+wendy xylophone 0.0
+luke laertes 0.0
+alice quirinius 1.0
+calvin ovid 0.0
+holly allen 0.0
+tom brown 1.0
+wendy ovid 0.0
+mike brown 0.0
+alice polk 0.0
+alice zipper 0.0
+sarah quirinius 1.0
+luke underhill 0.0
+victor white 0.5
+holly xylophone 1.0
+oscar quirinius 0.0
+ethan davidson 0.0
+ethan allen 0.0
+wendy underhill 0.5
+irene xylophone 1.0
+ulysses steinbeck 0.0
+mike hernandez 1.0
+irene brown 0.0
+priscilla brown 0.0
+calvin johnson 1.0
+sarah xylophone 0.0
+yuri underhill 0.5
+ethan nixon 1.0
+calvin hernandez 0.0
+yuri underhill 0.0
+holly allen 1.0
+victor laertes 0.0
+ethan underhill 0.0
+irene steinbeck 1.0
+mike van buren 0.0
+xavier allen 0.5
+sarah xylophone 1.0
+luke van buren 0.0
+gabriella xylophone 0.0
+gabriella ellison 0.0
+luke falkner 0.0
+priscilla garcia 0.0
+ethan quirinius 0.3333333333333333
+alice xylophone 0.6666666666666666
+ethan underhill 1.0
+tom white 0.0
+alice johnson 0.0
+priscilla zipper 0.0
+tom laertes 0.5
+zach laertes 1.0
+xavier miller 0.0
+yuri ovid 0.0
+david steinbeck 0.0
+wendy underhill 0.0
+priscilla xylophone 0.0
+nick hernandez 0.0
+luke steinbeck 0.0
+oscar davidson 0.0
+sarah allen 0.0
+katie steinbeck 0.0
+oscar ovid 1.0
+yuri ellison 0.0
+rachel quirinius 0.0
+irene van buren 0.0
+victor ichabod 0.0
+quinn miller 0.0
+luke allen 0.0
+xavier laertes 0.0
+wendy miller 0.0
+victor brown 0.0
+tom thompson 0.0
+david brown 1.0
+zach quirinius 0.0
+oscar king 1.0
+david nixon 0.0
+ethan white 0.0
+ethan polk 0.0
+ulysses steinbeck 0.0
+victor van buren 0.3333333333333333
+sarah carson 0.6666666666666666
+priscilla nixon 1.0
+PREHOOK: query: -- If following tests fail, look for the comments in class PTFPPD::process()
+
+select ts, dec, rnk
+from
+ (select ts, dec,
+ rank() over (partition by ts) as rnk
+ from
+ (select other.ts, other.dec
+ from over10k other
+ join over10k on (other.b = over10k.b)
+ ) joined
+ ) ranked
+where rnk = 1 limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@over10k
+#### A masked pattern was here ####
+POSTHOOK: query: -- If following tests fail, look for the comments in class PTFPPD::process()
+
+select ts, dec, rnk
+from
+ (select ts, dec,
+ rank() over (partition by ts) as rnk
+ from
+ (select other.ts, other.dec
+ from over10k other
+ join over10k on (other.b = over10k.b)
+ ) joined
+ ) ranked
+where rnk = 1 limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@over10k
+#### A masked pattern was here ####
+2013-03-01 09:11:58.70307 34.22 1
+2013-03-01 09:11:58.70307 34.22 1
+2013-03-01 09:11:58.70307 34.22 1
+2013-03-01 09:11:58.70307 34.22 1
+2013-03-01 09:11:58.70307 34.22 1
+2013-03-01 09:11:58.70307 34.22 1
+2013-03-01 09:11:58.70307 34.22 1
+2013-03-01 09:11:58.70307 34.22 1
+2013-03-01 09:11:58.70307 34.22 1
+2013-03-01 09:11:58.70307 34.22 1
+PREHOOK: query: select ts, dec, rnk
+from
+ (select ts, dec,
+ rank() over (partition by ts) as rnk
+ from
+ (select other.ts, other.dec
+ from over10k other
+ join over10k on (other.b = over10k.b)
+ ) joined
+ ) ranked
+where dec = 89.5 limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@over10k
+#### A masked pattern was here ####
+POSTHOOK: query: select ts, dec, rnk
+from
+ (select ts, dec,
+ rank() over (partition by ts) as rnk
+ from
+ (select other.ts, other.dec
+ from over10k other
+ join over10k on (other.b = over10k.b)
+ ) joined
+ ) ranked
+where dec = 89.5 limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@over10k
+#### A masked pattern was here ####
+2013-03-01 09:11:58.703124 89.5 1
+2013-03-01 09:11:58.703124 89.5 1
+2013-03-01 09:11:58.703124 89.5 1
+2013-03-01 09:11:58.703124 89.5 1
+2013-03-01 09:11:58.703124 89.5 1
+2013-03-01 09:11:58.703124 89.5 1
+2013-03-01 09:11:58.703124 89.5 1
+2013-03-01 09:11:58.703124 89.5 1
+2013-03-01 09:11:58.703124 89.5 1
+2013-03-01 09:11:58.703124 89.5 1
+PREHOOK: query: select ts, dec, rnk
+from
+ (select ts, dec,
+ rank() over (partition by ts) as rnk
+ from
+ (select other.ts, other.dec
+ from over10k other
+ join over10k on (other.b = over10k.b)
+ where other.t < 10
+ ) joined
+ ) ranked
+where rnk = 1 limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@over10k
+#### A masked pattern was here ####
+POSTHOOK: query: select ts, dec, rnk
+from
+ (select ts, dec,
+ rank() over (partition by ts) as rnk
+ from
+ (select other.ts, other.dec
+ from over10k other
+ join over10k on (other.b = over10k.b)
+ where other.t < 10
+ ) joined
+ ) ranked
+where rnk = 1 limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@over10k
+#### A masked pattern was here ####
+2013-03-01 09:11:58.70307 53.25 1
+2013-03-01 09:11:58.70307 53.25 1
+2013-03-01 09:11:58.70307 53.25 1
+2013-03-01 09:11:58.70307 53.25 1
+2013-03-01 09:11:58.70307 53.25 1
+2013-03-01 09:11:58.70307 53.25 1
+2013-03-01 09:11:58.70307 53.25 1
+2013-03-01 09:11:58.70307 53.25 1
+2013-03-01 09:11:58.70307 53.25 1
+2013-03-01 09:11:58.70307 79.99 1
Added: hive/trunk/ql/src/test/results/clientpositive/windowing_udaf.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/windowing_udaf.q.out?rev=1463556&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/windowing_udaf.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/windowing_udaf.q.out Tue Apr 2 14:16:34 2013
@@ -0,0 +1,581 @@
+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 t) 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 t) from over10k limit 100
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@over10k
+#### A masked pattern was here ####
+fred quirinius 40.970001220703125
+ulysses white 47.60000038146973
+alice ellison 44.45333353678385
+sarah white 41.5
+victor thompson 44.07000001271566
+calvin johnson 44.07000001271566
+nick zipper 51.10142871311733
+victor johnson 47.296250104904175
+calvin young 49.61400032043457
+zach nixon 49.61400032043457
+xavier quirinius 54.20833365122477
+victor robinson 54.20833365122477
+victor hernandez 54.74692329993615
+tom allen 54.20571436200823
+sarah brown 56.666666920979814
+irene polk 58.91937518119812
+holly xylophone 56.917647193459906
+rachel ovid 54.96833345625136
+wendy garcia 54.67736846522281
+oscar steinbeck 54.6835000038147
+zach white 54.382272633639246
+ethan thompson 54.382272633639246
+quinn hernandez 55.655652004739515
+fred hernandez 53.47749984264374
+wendy nixon 55.13319995880127
+david davidson 55.86461540368887
+rachel ellison 54.12888890725595
+gabriella falkner 53.41321430887495
+ethan falkner 52.01862072122508
+alice ovid 52.830666605631514
+zach underhill 53.1432257621519
+alice robinson 53.058787837173
+quinn quirinius 53.058787837173
+ulysses young 51.977352927712836
+xavier van buren 52.72857131958008
+xavier ovid 52.70055548350016
+victor davidson 51.42081073812536
+jessica laertes 51.61000061035156
+yuri nixon 52.75
+ethan king 61.550000508626304
+sarah hernandez 46.9425003528595
+alice underhill 41.020000267028806
+alice xylophone 50.516666889190674
+victor xylophone 52.099999972752165
+yuri brown 51.53500020503998
+oscar young 51.92777792612711
+nick quirinius 57.051818414167926
+zach underhill 57.051818414167926
+gabriella ellison 55.287500301996864
+holly white 54.27615407797006
+zach hernandez 54.87000022615705
+xavier brown 54.62933343251546
+irene young 52.748750150203705
+katie garcia 51.00941192402559
+oscar laertes 48.69000016318427
+katie ichabod 48.97000006625527
+nick davidson 48.98899998664856
+priscilla miller 47.38761901855469
+rachel robinson 48.00090911171653
+fred brown 50.08826098234757
+wendy brown 49.570400161743166
+fred zipper 49.570400161743166
+holly robinson 51.34037053143537
+priscilla laertes 51.34037053143537
+nick zipper 52.96571438653128
+ethan polk 54.25793121600973
+priscilla thompson 52.37741947174072
+luke quirinius 52.37741947174072
+oscar thompson 50.77843761444092
+ulysses young 50.225151639996156
+ethan underhill 51.552353017470416
+luke falkner 50.90800007411412
+zach zipper 52.148889011806915
+david brown 52.92216233949404
+zach hernandez 52.05473699067768
+mike underhill 51.34564116062262
+zach hernandez 51.274500131607056
+tom laertes 9.050000190734863
+oscar van buren 37.92999887466431
+priscilla underhill 49.59750008583069
+jessica ichabod 49.59750008583069
+bob falkner 54.244999726613365
+xavier zipper 54.244999726613365
+zach zipper 54.014285632542204
+jessica laertes 54.80499994754791
+calvin davidson 45.944000005722046
+calvin steinbeck 45.944000005722046
+gabriella young 44.62636371092363
+luke ovid 48.321666836738586
+nick king 54.24857177053179
+sarah zipper 54.24857177053179
+alice nixon 53.90733372370402
+ulysses laertes 50.65812536329031
+priscilla zipper 51.28058867594775
+calvin johnson 48.576667077011535
+katie allen 51.187895254084935
+zach steinbeck 49.3070004761219
+priscilla zipper 48.46285759267353
+mike underhill 48.61545496095311
+irene quirinius 49.54521778873775
+PREHOOK: query: select s, avg(i) over (partition by t, b) 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) from over10k limit 100
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@over10k
+#### A masked pattern was here ####
+oscar miller 65773.0
+bob underhill 65743.5
+tom polk 65743.5
+wendy robinson 65622.0
+alice king 65570.0
+ethan steinbeck 65695.5
+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 65680.33333333333
+sarah miller 65680.33333333333
+irene young 65680.33333333333
+nick nixon 65696.0
+tom steinbeck 65608.0
+oscar johnson 65650.0
+calvin white 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
+ulysses carson 65728.33333333333
+priscilla quirinius 65728.33333333333
+victor thompson 65728.33333333333
+ulysses ellison 65640.0
+bob johnson 65731.0
+quinn ellison 65736.0
+victor xylophone 65697.0
+bob polk 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
+sarah robinson 65605.0
+nick robinson 65605.0
+tom hernandez 65575.0
+alice xylophone 65618.0
+sarah xylophone 65618.0
+priscilla laertes 65696.0
+holly polk 65710.0
+katie ichabod 65577.0
+holly underhill 65553.0
+ethan underhill 65706.5
+alice davidson 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
+wendy quirinius 65616.0
+victor robinson 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
+katie ovid 65613.0
+bob van buren 65613.0
+yuri hernandez 65657.5
+fred king 65657.5
+nick falkner 65604.0
+sarah steinbeck 65655.0
+david laertes 65655.0
+katie thompson 65582.5
+alice carson 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