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/26 21:16:13 UTC
svn commit: r1476348 [27/29] - in /hive/branches/vectorization: ./ beeline/
beeline/src/java/org/apache/hive/beeline/ beeline/src/test/org/
beeline/src/test/org/apache/ beeline/src/test/org/apache/hive/
beeline/src/test/org/apache/hive/beeline/ beeline...
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/windowing_expressions.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/windowing_expressions.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/windowing_expressions.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/windowing_expressions.q.out Fri Apr 26 19:14:49 2013
@@ -77,7 +77,7 @@ POSTHOOK: query: load data local inpath
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)
+round(sum(p_retailprice),2) = round(sum(lag(p_retailprice,1,0.0)) + 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)
@@ -86,7 +86,7 @@ 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)
+round(sum(p_retailprice),2) = round(sum(lag(p_retailprice,1,0.0)) + 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)
@@ -162,119 +162,119 @@ Manufacturer#5 1464.48 23 2 2482.58 2477
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: query: select s, si, f, si - lead(f, 3) over (partition by t order by bo,s,si,f 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: query: select s, si, f, si - lead(f, 3) over (partition by t order by bo,s,si,f 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
+alice allen 400 76.31 337.23
+alice davidson 384 71.97 357.79
+alice king 455 2.48 395.93
+alice king 458 62.77 384.16998
+alice xylophone 485 26.21 464.05
+bob falkner 260 59.07 242.4
+bob ichabod 454 73.83 381.7
+bob polk 264 20.95 257.17
+bob underhill 454 17.6 424.94
+bob underhill 465 72.3 453.17
+bob van buren 433 6.83 398.4
+calvin ichabod 431 29.06 334.22
+david garcia 485 11.83 421.51
+ethan steinbeck 298 34.6 288.14
+fred ellison 376 96.78 330.76
+holly steinbeck 384 63.49 293.7
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
+irene ellison 458 45.24 365.29
+irene underhill 307 90.3 244.19
+jessica johnson 494 48.09 490.18
+jessica king 459 92.71 452.2
+jessica white 284 62.81 209.08
+luke garcia 311 3.82 267.27
+luke young 451 6.8 429.0
+mike king 275 74.92 211.81
+oscar garcia 362 43.73 340.66
+priscilla laertes 316 22.0 296.06
+priscilla quirinius 423 63.19 362.72
+priscilla zipper 485 21.34 400.61
+quinn ellison 266 19.94 209.95
+quinn polk 507 60.28 447.66
+sarah robinson 320 84.39 309.74
+tom polk 346 56.05 320.33
+ulysses ellison 381 59.34 358.66
+ulysses quirinius 303 10.26 259.6
+ulysses robinson 313 25.67 269.31
+ulysses steinbeck 333 22.34 270.61
+victor allen 337 43.4 311.5
+victor hernandez 447 43.69 375.22
+victor xylophone 438 62.39 424.33
+wendy quirinius 279 25.5 250.25
+wendy robinson 275 71.78 262.88
+wendy xylophone 314 13.67 295.73
+xavier garcia 493 28.75 474.56
+zach thompson 386 12.12 377.63
+zach young 286 18.27 263.65
+alice falkner 280 18.44 227.7
+bob ellison 339 8.37 300.95
+bob johnson 374 22.35 326.49
+calvin white 280 52.3 198.32
+david carson 270 38.05 255.77
+david falkner 469 47.51 388.35
+david hernandez 408 81.68 339.27
+ethan underhill 339 14.23 256.26
+gabriella brown 498 80.65 413.25
+holly nixon 505 68.73 440.71
+holly polk 268 82.74 182.04001
+holly thompson 387 84.75 298.22
+irene young 458 64.29 401.8
+jessica miller 299 85.96 243.41
+katie ichabod 469 88.78 385.61
+luke ichabod 289 56.2 286.74
+luke king 337 55.59 274.88
+mike allen 465 83.39 383.03
+mike polk 500 2.26 427.74
+mike white 454 62.12 430.78
+mike xylophone 448 81.97 447.17
+nick nixon 335 72.26 240.78
+nick robinson 350 23.22 294.59
+oscar davidson 432 0.83 420.93
+oscar johnson 315 94.22 233.05
+oscar johnson 469 55.41 468.44
+oscar miller 324 11.07 265.19
+rachel davidson 507 81.95 468.78
+rachel thompson 344 0.56 246.12
+sarah miller 386 58.81 304.36
+sarah xylophone 275 38.22 177.48999
+sarah zipper 376 97.88 294.61
+tom hernandez 467 81.64 459.9
+tom hernandez 477 97.51 415.19
+tom steinbeck 414 81.39 361.87
+ulysses carson 343 7.1 314.22
+victor robinson 415 61.81 349.5
+victor thompson 344 52.13 NULL
+xavier ovid 280 28.78 NULL
+yuri xylophone 430 65.5 NULL
+alice underhill 389 26.68 368.06
+alice underhill 446 6.49 444.21
+bob ovid 331 67.12 236.43
+bob van buren 406 20.94 383.32
+david falkner 406 1.79 374.34
+david miller 450 94.57 380.13
+ethan allen 380 22.68 375.6
+ethan king 395 31.66 361.51
+ethan nixon 475 69.87 431.39
+ethan polk 283 4.4 243.82
+fred allen 331 33.49 281.68
+fred king 511 43.61 457.22
+fred polk 261 39.18 248.73
+fred young 303 49.32 221.51001
+PREHOOK: query: select s, i, i - lead(i, 3, 0) over (partition by si order by i,s) 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: query: select s, i, i - lead(i, 3, 0) over (partition by si order by i,s) from over10k limit 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@over10k
#### A masked pattern was here ####
@@ -288,8 +288,8 @@ 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
+nick zipper 65613 -3
+xavier van buren 65613 -7
victor johnson 65615 -12
alice ovid 65616 -24
xavier ovid 65620 -23
@@ -307,8 +307,8 @@ zach white 65733 -8
fred hernandez 65737 -7
rachel ellison 65738 -6
oscar steinbeck 65741 -6
-tom allen 65744 -8
-alice ellison 65744 -19
+alice ellison 65744 -8
+tom allen 65744 -19
quinn quirinius 65747 -31
victor hernandez 65752 -26
holly xylophone 65763 -26
@@ -328,14 +328,14 @@ victor xylophone 65578 -16
gabriella ellison 65584 -26
nick quirinius 65588 -22
holly robinson 65594 -18
-yuri brown 65610 -16
-alice xylophone 65610 -21
+alice xylophone 65610 -16
+yuri brown 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
+irene young 65654 -37
+priscilla thompson 65654 -40
luke quirinius 65655 -44
david brown 65691 -20
luke falkner 65694 -18
@@ -351,16 +351,16 @@ ulysses young 65748 -23
nick davidson 65752 -19
fred zipper 65756 -15
yuri nixon 65771 -10
-zach zipper 65771 -19
-zach hernandez 65771 65771
+zach hernandez 65771 -19
+zach zipper 65771 65771
alice underhill 65781 65781
oscar laertes 65790 65790
sarah zipper 65546 -19
-luke ovid 65551 -17
bob falkner 65551 -17
+luke ovid 65551 -17
katie allen 65565 -4
-zach steinbeck 65568 -5
-nick falkner 65568 -11
+nick falkner 65568 -5
+zach steinbeck 65568 -11
oscar van buren 65569 -13
gabriella young 65573 -11
jessica ichabod 65579 -24
@@ -373,16 +373,16 @@ jessica laertes 65617 -62
fred king 65656 -61
priscilla underhill 65669 -48
priscilla zipper 65679 -45
-sarah polk 65717 -11
-nick king 65717 -17
+nick king 65717 -11
+sarah polk 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: query: select s, si, d, si - lag(d, 3) over (partition by b order by si,s,d) 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: query: select s, si, d, si - lag(d, 3) over (partition by b order by si,s,d) from over10k limit 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@over10k
#### A masked pattern was here ####
@@ -420,18 +420,18 @@ 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
+gabriella steinbeck 467 9.35 418.97
+tom hernandez 467 29.36 419.96
irene polk 485 14.26 437.52
-mike xylophone 494 36.92 464.64
-calvin allen 499 39.99 489.65
+mike xylophone 494 36.92 484.65
+calvin allen 499 39.99 469.64
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
+ulysses garcia 263 31.85 NULL
+mike steinbeck 266 48.57 235.13
+rachel young 275 14.75 245.54
+tom king 278 31.11 246.15
oscar robinson 283 30.35 234.43
zach allen 284 1.88 269.25
bob king 308 27.61 276.89
@@ -455,11 +455,11 @@ 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
+ethan ovid 293 2.08 246.13
+luke falkner 293 40.67 251.96
irene nixon 321 24.35 309.56
-mike van buren 327 2.58 286.33
-ulysses robinson 329 26.64 326.92
+mike van buren 327 2.58 324.92
+ulysses robinson 329 26.64 288.33
quinn laertes 332 10.71 307.65
tom polk 346 34.03 343.42
jessica johnson 352 45.71 325.36
@@ -674,12 +674,12 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table t2 (a1 int, b1 string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@t2
-PREHOOK: query: from (select sum(i) over (), s from over10k) tt insert overwrite table t1 select * insert overwrite table t2 select *
+PREHOOK: query: from (select sum(i) over (partition by ts order by i), s from over10k) tt insert overwrite table t1 select * insert overwrite table t2 select *
PREHOOK: type: QUERY
PREHOOK: Input: default@over10k
PREHOOK: Output: default@t1
PREHOOK: Output: default@t2
-POSTHOOK: query: from (select sum(i) over (), s from over10k) tt insert overwrite table t1 select * insert overwrite table t2 select *
+POSTHOOK: query: from (select sum(i) over (partition by ts order by i), s from over10k) tt insert overwrite table t1 select * insert overwrite table t2 select *
POSTHOOK: type: QUERY
POSTHOOK: Input: default@over10k
POSTHOOK: Output: default@t1
@@ -700,9 +700,9 @@ POSTHOOK: Lineage: t1.a1 SCRIPT [(over10
POSTHOOK: Lineage: t1.b1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: t2.a1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: t2.b1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-656584379 bob davidson
-656584379 alice zipper
-656584379 katie davidson
+65542 rachel thompson
+131088 oscar brown
+262258 wendy steinbeck
PREHOOK: query: select * from t2 limit 3
PREHOOK: type: QUERY
PREHOOK: Input: default@t2
@@ -715,6 +715,37 @@ POSTHOOK: Lineage: t1.a1 SCRIPT [(over10
POSTHOOK: Lineage: t1.b1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: t2.a1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: t2.b1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-656584379 bob davidson
-656584379 alice zipper
-656584379 katie davidson
+65542 rachel thompson
+131088 oscar brown
+262258 wendy steinbeck
+PREHOOK: query: select p_mfgr, p_retailprice, p_size,
+round(sum(p_retailprice),2) + 50.0 = round(sum(lag(p_retailprice,1,50.0)) + last_value(p_retailprice),2)
+ over(distribute by p_mfgr sort by p_retailprice)
+from part
+limit 11
+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) + 50.0 = round(sum(lag(p_retailprice,1,50.0)) + last_value(p_retailprice),2)
+ over(distribute by p_mfgr sort by p_retailprice)
+from part
+limit 11
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@part
+#### A masked pattern was here ####
+POSTHOOK: Lineage: t1.a1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: t1.b1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: t2.a1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: t2.b1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+Manufacturer#1 1173.15 2 true
+Manufacturer#1 1173.15 2 true
+Manufacturer#1 1414.42 28 true
+Manufacturer#1 1602.59 6 true
+Manufacturer#1 1632.66 42 true
+Manufacturer#1 1753.76 34 true
+Manufacturer#2 1690.68 14 true
+Manufacturer#2 1698.66 25 true
+Manufacturer#2 1701.6 18 true
+Manufacturer#2 1800.7 40 true
+Manufacturer#2 2031.98 2 true
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/windowing_multipartitioning.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/windowing_multipartitioning.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/windowing_multipartitioning.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/windowing_multipartitioning.q.out Fri Apr 26 19:14:49 2013
@@ -271,44 +271,44 @@ 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: query: select s, sum(f) over (partition by i), row_number() over (order by f) from over10k where s = 'tom allen' or s = 'bob steinbeck'
PREHOOK: type: QUERY
PREHOOK: Input: default@over10k
#### A masked pattern was here ####
-POSTHOOK: query: select s, sum(f) over (partition by i), row_number() over () from over10k where s = 'tom allen' or s = 'bob steinbeck'
+POSTHOOK: query: select s, sum(f) over (partition by i), row_number() over (order by f) from over10k where s = 'tom allen' or s = 'bob steinbeck'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@over10k
#### A masked pattern was here ####
-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
+tom allen 2.8499999046325684 1
+bob steinbeck 9.699999809265137 2
+tom allen 11.069999694824219 3
+tom allen 11.300000190734863 4
+tom allen 54.00000190734863 5
+tom allen 15.84000015258789 6
+tom allen 19.459999084472656 7
+tom allen 26.239999771118164 8
+bob steinbeck 26.290000915527344 9
+bob steinbeck 27.959999084472656 10
+bob steinbeck 28.479999542236328 11
+bob steinbeck 36.209999084472656 12
+bob steinbeck 38.33000183105469 13
+tom allen 38.93000030517578 14
+tom allen 54.00000190734863 15
+tom allen 40.5099983215332 16
+tom allen 47.16999816894531 17
+bob steinbeck 47.810001373291016 18
+tom allen 50.630001068115234 19
+tom allen 52.779998779296875 20
+tom allen 55.38999938964844 21
+tom allen 77.77999877929688 22
+bob steinbeck 80.7300033569336 23
+tom allen 81.8499984741211 24
+bob steinbeck 82.19000244140625 25
+tom allen 83.47000122070312 26
+bob steinbeck 83.52999877929688 27
+bob steinbeck 83.52999877929688 28
+tom allen 89.88999938964844 29
+tom allen 95.41000366210938 30
PREHOOK: query: select s, rank() over w1,
rank() over w2
from over10k
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/windowing_navfn.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/windowing_navfn.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/windowing_navfn.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/windowing_navfn.q.out Fri Apr 26 19:14:49 2013
@@ -147,119 +147,119 @@ 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: query: select i, lead(s) over (partition by bin order by d,i desc) from over10k limit 100
PREHOOK: type: QUERY
PREHOOK: Input: default@over10k
#### A masked pattern was here ####
-POSTHOOK: query: select i, lead(s) over (partition by bin order by d desc) from over10k limit 100
+POSTHOOK: query: select i, lead(s) over (partition by bin order by d,i desc) from over10k limit 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@over10k
#### A masked pattern was here ####
-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
+65773 gabriella van buren
+65727 quinn steinbeck
+65649 katie laertes
+65643 luke young
+65712 xavier white
+65554 oscar garcia
+65715 katie ichabod
+65737 mike garcia
+65641 katie thompson
+65674 zach falkner
+65627 katie ovid
+65628 irene davidson
+65657 wendy van buren
+65686 yuri ichabod
+65594 ethan underhill
+65615 zach young
+65708 calvin falkner
+65674 nick xylophone
+65717 tom hernandez
+65713 tom ichabod
+65681 priscilla ichabod
+65654 victor laertes
+65580 victor van buren
+65711 holly xylophone
+65727 david garcia
+65692 yuri ovid
+65760 oscar xylophone
+65545 luke falkner
+65653 alice falkner
+65773 jessica robinson
+65756 fred davidson
+65698 tom hernandez
+65659 irene ellison
+65662 holly robinson
+65610 mike garcia
+65537 yuri hernandez
+65601 ulysses garcia
+65545 mike brown
+65538 ethan nixon
+65551 yuri falkner
+65709 rachel robinson
+65774 yuri polk
+65713 yuri nixon
+65613 sarah thompson
+65693 nick nixon
+65650 ethan carson
+65781 oscar king
+65675 priscilla ichabod
+65541 jessica thompson
+65719 mike polk
+65694 luke brown
+65538 victor young
+65746 oscar nixon
+65564 tom zipper
+65708 irene ellison
+65696 alice davidson
+65596 jessica garcia
+65586 victor miller
+65696 holly white
+65600 david robinson
+65785 jessica davidson
+65606 ulysses brown
+65734 ethan underhill
+65546 ethan miller
+65578 tom thompson
+65776 holly steinbeck
+65741 yuri underhill
+65770 priscilla king
+65562 bob white
+65605 victor van buren
+65764 bob allen
+65725 david underhill
+65700 holly king
+65648 victor ovid
+65733 priscilla xylophone
+65682 katie miller
+65694 victor xylophone
+65553 mike steinbeck
+65635 holly laertes
+65537 katie steinbeck
+65761 zach white
+65747 ethan falkner
+65601 ulysses king
+65590 rachel davidson
+65732 irene young
+65642 bob thompson
+65570 tom xylophone
+65692 sarah davidson
+65760 tom laertes
+65784 yuri johnson
+65630 zach laertes
+65774 nick polk
+65788 quinn xylophone
+65595 yuri white
+65765 xavier ellison
+65541 jessica ichabod
+65711 tom steinbeck
+65536 alice hernandez
+65545 tom zipper
+65789 ulysses hernandez
+PREHOOK: query: select i, lag(dec) over (partition by i order by s,i,dec) from over10k limit 100
PREHOOK: type: QUERY
PREHOOK: Input: default@over10k
#### A masked pattern was here ####
-POSTHOOK: query: select i, lag(dec) over (partition by i order by s) from over10k limit 100
+POSTHOOK: query: select i, lag(dec) over (partition by i order by s,i,dec) from over10k limit 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@over10k
#### A masked pattern was here ####
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/windowing_ntile.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/windowing_ntile.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/windowing_ntile.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/windowing_ntile.q.out Fri Apr 26 19:14:49 2013
@@ -39,240 +39,240 @@ 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: query: select i, ntile(10) over (partition by s order by i) 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: query: select i, ntile(10) over (partition by s order by i) from over10k limit 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@over10k
#### A masked pattern was here ####
-65600 1
-65758 2
-65609 3
-65557 4
+65545 1
+65557 2
+65600 3
+65609 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
+65720 7
+65758 8
+65569 1
+65570 1
+65666 2
+65667 2
+65673 3
+65696 3
+65704 4
+65707 4
+65708 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
+65733 7
+65779 8
+65781 9
+65790 10
+65545 1
+65559 2
+65559 3
+65565 4
+65576 5
+65695 6
+65710 7
+65713 8
+65747 9
+65785 10
+65544 1
65547 1
-65677 1
-65676 2
-65596 2
-65791 3
-65707 3
-65690 4
-65563 4
-65560 5
+65554 2
+65560 2
+65563 3
+65590 3
+65596 4
+65631 4
65641 5
-65544 6
+65676 5
+65677 6
65677 6
-65590 7
-65747 7
+65690 7
+65707 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
+65742 8
+65747 9
+65791 10
+65537 1
+65544 1
+65557 2
+65572 2
+65612 3
+65677 3
+65681 4
+65698 4
+65699 5
+65713 5
+65730 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
+65744 8
+65745 9
+65787 10
+65596 1
+65597 1
+65611 2
+65622 2
+65669 3
+65685 3
+65690 4
+65699 4
65709 5
-65718 5
-65622 6
-65775 6
-65690 7
-65685 7
-65596 8
-65710 9
+65710 5
+65715 6
+65718 6
+65722 7
+65752 7
+65773 8
+65775 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
+65573 1
+65613 1
+65623 2
+65630 2
+65674 3
+65675 3
+65712 4
+65725 5
+65734 6
+65744 7
+65746 8
65746 9
-65734 10
+65759 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
+65545 1
+65569 2
+65603 2
+65633 3
+PREHOOK: query: select s, ntile(100) 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 s, ntile(100) over (partition by i) from over10k limit 100
+POSTHOOK: query: select s, ntile(100) over (partition by i order by s) from over10k limit 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@over10k
#### A masked pattern was here ####
-rachel ichabod 1
+alice 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
+bob robinson 3
+calvin thompson 4
+david johnson 5
+david laertes 6
+david nixon 7
+david nixon 8
+ethan johnson 9
+ethan ovid 10
+ethan underhill 11
+fred miller 12
+fred miller 13
+gabriella garcia 14
+gabriella underhill 15
+holly white 16
+irene johnson 17
+katie ellison 18
+luke allen 19
+mike quirinius 20
+mike white 21
+nick davidson 22
+oscar allen 23
+oscar garcia 24
+oscar ichabod 25
+oscar ovid 26
+oscar steinbeck 27
+priscilla garcia 28
+priscilla white 29
+priscilla xylophone 30
+priscilla young 31
+rachel brown 32
+rachel ichabod 33
+rachel xylophone 34
+sarah thompson 35
+sarah thompson 36
+tom johnson 37
+tom steinbeck 38
+ulysses polk 39
+victor johnson 40
+wendy polk 41
+xavier davidson 42
+yuri ellison 43
+zach allen 44
+zach hernandez 45
+alice ellison 1
+bob carson 2
+calvin brown 3
+david xylophone 4
+ethan white 5
+fred johnson 6
+fred van buren 7
+gabriella ichabod 8
+holly laertes 9
+holly quirinius 10
+jessica hernandez 11
+katie robinson 12
+katie thompson 13
+luke nixon 14
+mike garcia 15
+mike hernandez 16
+nick carson 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
+oscar carson 19
+oscar robinson 20
+priscilla white 21
+sarah falkner 22
+sarah ichabod 23
+ulysses falkner 24
+victor xylophone 25
+wendy garcia 26
+wendy van buren 27
+xavier underhill 28
+yuri garcia 29
+yuri quirinius 30
+yuri white 31
+zach falkner 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
+zach nixon 34
+zach ovid 35
+alice ichabod 1
+alice king 2
+alice robinson 3
+calvin allen 4
+gabriella johnson 5
+gabriella nixon 6
+holly falkner 7
+holly hernandez 8
+holly thompson 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
+luke brown 11
+luke davidson 12
+luke white 13
+mike brown 14
+nick quirinius 15
+oscar white 16
+priscilla xylophone 17
+quinn garcia 18
+quinn laertes 19
+rachel young 20
+PREHOOK: query: select f, ntile(4) 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 f, ntile(4) over (partition by d) from over10k limit 100
+POSTHOOK: query: select f, ntile(4) over (partition by d order by f) 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
+5.29 1
+25.5 2
37.59 3
79.24 1
-60.0 1
-48.5 2
+48.5 1
+60.0 2
77.84 3
-51.57 1
-14.36 2
+14.36 1
+51.57 2
87.91 3
40.91 1
59.09 2
@@ -280,65 +280,65 @@ POSTHOOK: Input: default@over10k
46.55 2
92.71 3
59.72 1
-98.89 2
-97.35 3
+97.35 2
+98.89 3
19.11 1
-35.21 1
-13.33 2
+13.33 1
+35.21 2
30.47 1
90.04 1
-77.44 1
-15.36 2
-60.76 3
+15.36 1
+60.76 2
+77.44 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
+3.94 1
+66.95 2
+18.65 1
+41.66 2
48.52 3
-18.65 4
-70.77 1
-84.83 2
-50.15 3
+75.93 4
+50.15 1
+70.77 2
+84.83 3
64.79 1
88.94 2
-96.71 1
-1.42 2
-94.14 1
-9.88 2
+1.42 1
+96.71 2
+9.88 1
+94.14 2
25.69 1
67.56 2
85.72 3
-82.8 1
+30.0 1
40.0 1
-95.11 2
-61.73 3
-30.0 4
+61.73 2
+82.8 3
+95.11 4
80.65 1
-96.54 1
-7.96 2
-61.07 1
+7.96 1
+96.54 2
20.74 1
-89.36 2
-49.61 3
-69.97 4
-61.71 1
+49.61 1
+61.07 2
+69.97 3
+89.36 4
+2.66 1
38.69 2
-2.66 3
-58.25 4
+58.25 3
+61.71 4
32.69 1
98.29 2
-25.63 1
-0.62 2
+0.62 1
+25.63 2
90.1 3
-69.42 1
-29.06 2
-85.03 1
-38.09 2
-68.81 3
+29.06 1
+69.42 2
+38.09 1
+68.81 2
+85.03 3
75.75 1
88.22 2
24.02 1
@@ -346,100 +346,100 @@ POSTHOOK: Input: default@over10k
76.99 1
96.45 1
1.09 1
-57.61 1
-84.92 2
-26.21 3
+26.21 1
+57.61 2
+84.92 3
80.99 1
39.16 1
39.82 2
-44.57 1
-24.15 2
+24.15 1
+44.57 2
38.05 1
81.55 2
-74.45 1
-49.13 2
+49.13 1
+74.45 2
42.49 1
-67.28 1
+37.63 1
49.09 2
-37.63 3
+67.28 3
10.6 1
-PREHOOK: query: select d, ntile(1000) over (partition by dec) from over10k limit 100
+PREHOOK: query: select d, ntile(1000) over (partition by dec order by d) 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: query: select d, ntile(1000) over (partition by dec order by d) from over10k limit 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@over10k
#### A masked pattern was here ####
-41.04 1
-9.71 2
+9.71 1
+41.04 2
43.7 1
-33.72 1
-1.42 2
+1.42 1
+33.72 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
+11.27 1
+32.62 2
40.35 3
41.23 1
39.43 1
21.2 1
40.64 1
-43.97 1
-12.07 2
+12.07 1
+43.97 2
27.64 1
-4.1 1
-0.7 2
+0.7 1
+4.1 2
33.38 1
-33.65 1
-18.69 2
+18.69 1
+33.65 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
+11.38 1
+43.34 2
+15.95 1
+23.27 2
+38.18 3
20.76 1
5.63 1
13.64 1
34.33 2
43.48 3
-46.79 1
-44.21 2
+44.21 1
+46.79 2
6.52 1
3.59 1
40.26 2
-25.9 1
-16.31 2
+16.31 1
+25.9 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
+5.37 1
+39.25 2
+7.25 1
+7.64 2
16.09 3
49.82 1
16.08 1
4.6 1
14.12 1
-28.42 1
-27.58 2
+27.58 1
+28.42 2
45.53 3
48.56 4
36.7 1
32.68 1
-40.09 1
-3.17 2
-24.84 3
+3.17 1
+24.84 2
+40.09 3
26.36 1
33.49 1
24.76 1
@@ -460,14 +460,14 @@ POSTHOOK: Input: default@over10k
37.82 1
15.27 1
15.22 1
-40.54 1
-11.43 2
-22.64 1
-4.81 2
+11.43 1
+40.54 2
+4.81 1
+22.64 2
14.18 1
44.83 1
5.15 1
-7.52 1
-2.78 2
-3.7 3
+2.78 1
+3.7 2
+7.52 3
45.55 4
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/windowing_rank.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/windowing_rank.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/windowing_rank.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/windowing_rank.q.out Fri Apr 26 19:14:49 2013
@@ -147,222 +147,222 @@ 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: query: select s, dense_rank() over (partition by ts order by i,s 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: query: select s, dense_rank() over (partition by ts order by i,s 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
+rachel thompson 1
+oscar brown 2
+wendy steinbeck 3
+victor van buren 4
+fred zipper 5
+priscilla zipper 6
+katie white 7
+fred nixon 8
+gabriella van buren 9
+luke zipper 10
+victor ellison 11
+david falkner 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
+calvin laertes 14
+yuri allen 15
+calvin brown 16
+tom johnson 17
+jessica laertes 18
+sarah falkner 19
+gabriella xylophone 20
+mike laertes 21
+bob ovid 22
+rachel garcia 23
+katie king 24
+calvin steinbeck 25
+jessica polk 26
+xavier davidson 1
+ethan ovid 2
+calvin white 3
+katie zipper 4
+quinn allen 5
+victor underhill 6
+ulysses xylophone 7
+priscilla zipper 8
+quinn ovid 9
+katie xylophone 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
+yuri brown 12
+oscar van buren 13
+alice miller 14
+luke thompson 15
+gabriella steinbeck 16
+priscilla brown 17
+gabriella underhill 18
+jessica robinson 19
+luke steinbeck 20
+nick ellison 21
+oscar davidson 22
+wendy johnson 23
+ulysses johnson 24
+jessica nixon 25
+fred king 26
+jessica brown 27
+ethan young 28
+xavier johnson 29
+gabriella johnson 30
+calvin nixon 31
+bob king 32
+calvin carson 33
+zach young 34
+yuri hernandez 35
+sarah van buren 36
+holly falkner 37
+jessica brown 38
+rachel ovid 39
+katie davidson 40
+bob falkner 41
+rachel young 42
+irene brown 43
+fred polk 44
+priscilla hernandez 45
+wendy thompson 46
+rachel robinson 47
+luke xylophone 48
+luke king 49
+holly thompson 50
+yuri garcia 1
+nick king 2
+calvin white 3
+rachel polk 4
+rachel davidson 5
+victor hernandez 6
+wendy miller 7
+wendy brown 8
+priscilla thompson 9
+holly nixon 10
+victor hernandez 11
+priscilla polk 12
+ethan nixon 13
+alice underhill 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
+tom hernandez 16
+sarah falkner 17
+wendy underhill 18
+rachel ichabod 19
+jessica johnson 20
+rachel ellison 21
+wendy falkner 22
+holly allen 23
+ulysses carson 24
+PREHOOK: query: select s, cume_dist() over (partition by bo order by b,s) 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: query: select s, cume_dist() over (partition by bo order by b,s) from over10k limit 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@over10k
#### A masked pattern was here ####
-holly allen 0.004625905068382945
-wendy falkner 0.004625905068382945
-david ovid 0.004625905068382945
-victor garcia 0.004625905068382945
-katie xylophone 0.004625905068382945
-ulysses xylophone 0.004625905068382945
-nick steinbeck 0.004625905068382945
-ethan ellison 0.004625905068382945
-nick quirinius 0.004625905068382945
-irene garcia 0.004625905068382945
-mike xylophone 0.004625905068382945
-victor xylophone 0.004625905068382945
-jessica steinbeck 0.004625905068382945
-irene van buren 0.004625905068382945
-quinn steinbeck 0.004625905068382945
-calvin allen 0.004625905068382945
-david zipper 0.004625905068382945
-sarah miller 0.004625905068382945
-ulysses nixon 0.004625905068382945
-ulysses ichabod 0.004625905068382945
+calvin allen 2.0112630732099757E-4
+david ovid 4.0225261464199515E-4
+david zipper 6.033789219629927E-4
+ethan ellison 8.045052292839903E-4
+holly allen 0.001005631536604988
+irene garcia 0.0012067578439259854
+irene van buren 0.0014078841512469831
+jessica steinbeck 0.0016090104585679806
+katie xylophone 0.0018101367658889783
+mike xylophone 0.002011263073209976
+nick quirinius 0.0022123893805309734
+nick steinbeck 0.002413515687851971
+quinn steinbeck 0.002614641995172969
+rachel thompson 0.0028157683024939663
+sarah miller 0.0030168946098149637
+tom hernandez 0.003218020917135961
+ulysses ichabod 0.003419147224456959
+ulysses nixon 0.0036202735317779565
+ulysses xylophone 0.003821399839098954
+victor garcia 0.004022526146419952
+victor xylophone 0.004223652453740949
+wendy falkner 0.004424778761061947
yuri nixon 0.004625905068382945
-tom hernandez 0.004625905068382945
-rachel thompson 0.004625905068382945
-katie xylophone 0.007441673370876911
-oscar quirinius 0.007441673370876911
-rachel davidson 0.007441673370876911
-sarah van buren 0.007441673370876911
-ulysses allen 0.007441673370876911
-bob king 0.007441673370876911
-bob johnson 0.007441673370876911
-calvin van buren 0.007441673370876911
-tom king 0.007441673370876911
+bob johnson 0.004827031375703942
+bob king 0.00502815768302494
+calvin van buren 0.005229283990345938
+gabriella robinson 0.005430410297666935
+katie xylophone 0.0056315366049879325
+mike steinbeck 0.00583266291230893
+oscar quirinius 0.006033789219629927
+rachel davidson 0.006234915526950925
+sarah van buren 0.006436041834271922
+tom king 0.00663716814159292
+ulysses allen 0.006838294448913918
+wendy ellison 0.007039420756234915
+zach allen 0.007240547063555913
zach young 0.007441673370876911
-zach allen 0.007441673370876911
-mike steinbeck 0.007441673370876911
-wendy ellison 0.007441673370876911
-gabriella robinson 0.007441673370876911
+alice falkner 0.007642799678197908
+bob ovid 0.007843925985518906
+bob underhill 0.008045052292839904
+ethan ovid 0.008246178600160902
+gabriella davidson 0.008447304907481898
+gabriella garcia 0.008648431214802896
+irene nixon 0.008849557522123894
+jessica brown 0.009050683829444892
+jessica miller 0.00925181013676589
+jessica quirinius 0.009452936444086887
+luke falkner 0.009654062751407884
+luke robinson 0.009855189058728881
+mike steinbeck 0.01005631536604988
+mike van buren 0.010257441673370877
+priscilla hernandez 0.010458567980691875
+tom polk 0.010659694288012871
+ulysses king 0.01086082059533387
+ulysses robinson 0.011061946902654867
xavier davidson 0.011263073209975865
-jessica miller 0.011263073209975865
-mike steinbeck 0.011263073209975865
-alice falkner 0.011263073209975865
-irene nixon 0.011263073209975865
-jessica brown 0.011263073209975865
-ethan ovid 0.011263073209975865
-ulysses king 0.011263073209975865
-gabriella davidson 0.011263073209975865
-jessica quirinius 0.011263073209975865
-luke falkner 0.011263073209975865
-luke robinson 0.011263073209975865
-priscilla hernandez 0.011263073209975865
-mike van buren 0.011263073209975865
-ulysses robinson 0.011263073209975865
-bob underhill 0.011263073209975865
-bob ovid 0.011263073209975865
-tom polk 0.011263073209975865
-gabriella garcia 0.011263073209975865
-wendy allen 0.015084473049074818
-victor robinson 0.015084473049074818
-calvin nixon 0.015084473049074818
-wendy nixon 0.015084473049074818
-mike falkner 0.015084473049074818
-nick falkner 0.015084473049074818
-priscilla nixon 0.015084473049074818
-david davidson 0.015084473049074818
-bob underhill 0.015084473049074818
-oscar laertes 0.015084473049074818
-oscar miller 0.015084473049074818
-priscilla xylophone 0.015084473049074818
-jessica robinson 0.015084473049074818
-quinn miller 0.015084473049074818
+alice hernandez 0.011464199517296863
+bob underhill 0.01166532582461786
+calvin nixon 0.011866452131938857
+david davidson 0.012067578439259855
+holly falkner 0.012268704746580853
+irene laertes 0.01246983105390185
+jessica robinson 0.012670957361222849
+mike falkner 0.012872083668543845
+nick falkner 0.013073209975864843
+oscar laertes 0.01327433628318584
+oscar miller 0.013475462590506838
+oscar thompson 0.013676588897827836
+priscilla nixon 0.013877715205148834
+priscilla xylophone 0.01407884151246983
+quinn miller 0.014279967819790828
+victor robinson 0.014481094127111826
+wendy allen 0.014682220434432824
+wendy nixon 0.014883346741753822
yuri ellison 0.015084473049074818
-holly falkner 0.015084473049074818
-oscar thompson 0.015084473049074818
-irene laertes 0.015084473049074818
-alice hernandez 0.015084473049074818
-luke johnson 0.01830249396621078
-fred carson 0.01830249396621078
-nick allen 0.01830249396621078
-nick ellison 0.01830249396621078
-priscilla laertes 0.01830249396621078
-priscilla underhill 0.01830249396621078
-calvin nixon 0.01830249396621078
-oscar king 0.01830249396621078
-katie polk 0.01830249396621078
-irene king 0.01830249396621078
-jessica davidson 0.01830249396621078
-victor steinbeck 0.01830249396621078
-priscilla young 0.01830249396621078
-katie polk 0.01830249396621078
-holly davidson 0.01830249396621078
+calvin nixon 0.015285599356395816
+fred carson 0.015486725663716814
+holly davidson 0.015687851971037812
+irene king 0.01588897827835881
+jessica davidson 0.016090104585679808
+katie polk 0.016492357200321803
+katie polk 0.016492357200321803
+luke johnson 0.0166934835076428
+nick allen 0.016894609814963796
+nick ellison 0.017095736122284794
+oscar king 0.01729686242960579
+priscilla laertes 0.01749798873692679
+priscilla underhill 0.017699115044247787
+priscilla young 0.017900241351568785
+victor steinbeck 0.018101367658889783
wendy miller 0.01830249396621078
-zach johnson 0.02252614641995173
-mike falkner 0.02252614641995173
-victor zipper 0.02252614641995173
-wendy king 0.02252614641995173
-fred ellison 0.02252614641995173
-mike hernandez 0.02252614641995173
-xavier allen 0.02252614641995173
-zach zipper 0.02252614641995173
-ethan laertes 0.02252614641995173
+calvin carson 0.01850362027353178
+ethan hernandez 0.018704746580852777
+ethan laertes 0.01910699919549477
+ethan laertes 0.01910699919549477
+ethan white 0.019308125502815767
+fred ellison 0.019509251810136765
+gabriella hernandez 0.019710378117457763
+gabriella ovid 0.01991150442477876
+gabriella steinbeck 0.02011263073209976
PREHOOK: query: select s, percent_rank() over (partition by dec order by f) from over10k limit 100
PREHOOK: type: QUERY
PREHOOK: Input: default@over10k
@@ -476,7 +476,7 @@ PREHOOK: query: -- If following tests fa
select ts, dec, rnk
from
(select ts, dec,
- rank() over (partition by ts) as rnk
+ rank() over (partition by ts order by dec) as rnk
from
(select other.ts, other.dec
from over10k other
@@ -492,7 +492,7 @@ POSTHOOK: query: -- If following tests f
select ts, dec, rnk
from
(select ts, dec,
- rank() over (partition by ts) as rnk
+ rank() over (partition by ts order by dec) as rnk
from
(select other.ts, other.dec
from over10k other
@@ -503,16 +503,16 @@ 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
+2013-03-01 09:11:58.70307 0.5 1
+2013-03-01 09:11:58.70307 0.5 1
+2013-03-01 09:11:58.70307 0.5 1
+2013-03-01 09:11:58.70307 0.5 1
+2013-03-01 09:11:58.70307 0.5 1
+2013-03-01 09:11:58.70307 0.5 1
+2013-03-01 09:11:58.70307 0.5 1
+2013-03-01 09:11:58.70307 0.5 1
+2013-03-01 09:11:58.70307 0.5 1
+2013-03-01 09:11:58.70307 0.5 1
PREHOOK: query: select ts, dec, rnk
from
(select ts, dec,
@@ -554,7 +554,7 @@ POSTHOOK: Input: default@over10k
PREHOOK: query: select ts, dec, rnk
from
(select ts, dec,
- rank() over (partition by ts) as rnk
+ rank() over (partition by ts order by dec) as rnk
from
(select other.ts, other.dec
from over10k other
@@ -569,7 +569,7 @@ PREHOOK: Input: default@over10k
POSTHOOK: query: select ts, dec, rnk
from
(select ts, dec,
- rank() over (partition by ts) as rnk
+ rank() over (partition by ts order by dec) as rnk
from
(select other.ts, other.dec
from over10k other
@@ -581,13 +581,13 @@ 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
+2013-03-01 09:11:58.70307 37.3 1
+2013-03-01 09:11:58.70307 37.3 1
+2013-03-01 09:11:58.70307 37.3 1
+2013-03-01 09:11:58.70307 37.3 1
+2013-03-01 09:11:58.70307 37.3 1
+2013-03-01 09:11:58.70307 37.3 1
+2013-03-01 09:11:58.70307 37.3 1
+2013-03-01 09:11:58.70307 37.3 1
+2013-03-01 09:11:58.70307 37.3 1
+2013-03-01 09:11:58.70307 37.3 1
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/windowing_udaf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/windowing_udaf.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/windowing_udaf.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/windowing_udaf.q.out Fri Apr 26 19:14:49 2013
@@ -147,128 +147,128 @@ 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: query: select s, avg(f) over (partition by si order by s) 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: query: select s, avg(f) over (partition by si order by s) 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
+alice ellison 38.15999984741211
+alice ovid 57.26999855041504
+alice robinson 61.9533322652181
+calvin johnson 48.489999294281006
+calvin young 57.602000045776364
+david davidson 60.36000029246012
+ethan falkner 53.59000028882708
+ethan thompson 50.917500138282776
+fred hernandez 45.63555569118924
+fred quirinius 45.169000244140626
+gabriella falkner 44.16181841763583
+holly xylophone 42.55583349863688
+irene polk 46.413846236008865
+nick zipper 49.762142998831614
+oscar steinbeck 50.098000081380206
+quinn hernandez 52.19624996185303
+quinn quirinius 51.01882351146025
+rachel ellison 48.684444427490234
+rachel ovid 47.271052611501595
+sarah brown 49.46350011825562
+sarah white 48.66238103594099
+tom allen 48.59454545107755
+ulysses white 48.839565194171406
+ulysses young 47.483333349227905
+victor davidson 45.79800001144409
+victor hernandez 46.39076920656058
+victor johnson 45.437777748814334
+victor robinson 46.12964274202074
+victor thompson 47.65344815418638
+wendy garcia 47.7129998366038
+wendy nixon 49.234193478861165
+xavier ovid 49.311874970793724
+xavier quirinius 50.531212185368396
+xavier van buren 51.34705878706539
+zach nixon 50.55771423067365
+zach underhill 50.889999959203934
+zach white 51.42081073812536
+alice underhill 17.329999923706055
+alice xylophone 57.66499996185303
+david brown 65.36333401997884
+ethan king 68.81000089645386
+ethan polk 73.13600120544433
+ethan underhill 76.83833408355713
+fred brown 79.57714380536761
+fred zipper 72.68500089645386
+gabriella ellison 68.5955564710829
+holly robinson 69.57500076293945
+holly white 67.0809097290039
+irene young 63.535833994547524
+jessica laertes 62.61846219576322
+katie garcia 59.8014292035784
+katie ichabod 59.41533381144206
+luke falkner 57.51437544822693
+luke quirinius 56.508823843563306
+mike underhill 54.72500027550591
+nick davidson 54.44210544385408
+nick quirinius 55.77850008010864
+nick zipper 57.73428571791876
+oscar laertes 55.53090910478072
+oscar thompson 53.169130449709684
+oscar young 53.24833333492279
+priscilla laertes 53.86000003814697
+priscilla miller 52.379230792705826
+priscilla thompson 50.80222225189209
+rachel robinson 51.162142923900056
+sarah hernandez 49.505517301888304
+ulysses young 48.93933340708415
+victor xylophone 49.34774195763372
+wendy brown 49.7678125500679
+xavier brown 49.81303030071837
+yuri brown 49.74735299278708
+yuri nixon 49.86571431841169
+zach hernandez 49.37763158898605
+zach hernandez 49.37763158898605
+zach hernandez 49.37763158898605
+zach underhill 50.13846162649301
+zach zipper 51.274500131607056
+alice nixon 31.255000591278076
+alice nixon 31.255000591278076
+bob falkner 51.356666247049965
+calvin davidson 39.96249973773956
+calvin johnson 32.491999769210814
+calvin steinbeck 29.613333185513813
+david garcia 34.99428541319711
+fred king 40.516249507665634
+gabriella young 39.50888853602939
+holly johnson 40.59399974346161
+irene quirinius 43.26727249405601
+jessica falkner 42.47249974807104
+jessica ichabod 42.86076903343201
+jessica laertes 44.109285541943144
+katie allen 47.71466666857402
+luke ovid 50.293125078082085
+mike underhill 50.38294123200809
+nick falkner 52.106666922569275
+nick king 54.01842131112751
+nick xylophone 54.5635001540184
+oscar van buren 55.146666697093416
+priscilla underhill 56.049545580690555
+priscilla zipper 55.24625018239021
+PREHOOK: query: select s, avg(i) over (partition by t, b order by s) from over10k 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: query: select s, avg(i) over (partition by t, b order by s) from over10k limit 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@over10k
#### A masked pattern was here ####
oscar miller 65773.0
-bob underhill 65743.5
+bob underhill 65735.0
tom polk 65743.5
wendy robinson 65622.0
alice king 65570.0
-ethan steinbeck 65695.5
+ethan steinbeck 65720.0
quinn polk 65695.5
bob ellison 65671.0
mike xylophone 65610.0
@@ -279,13 +279,13 @@ xavier ovid 65769.0
oscar garcia 65712.0
sarah zipper 65766.0
wendy xylophone 65670.0
-gabriella brown 65680.33333333333
+gabriella brown 65751.0
+irene young 65715.0
sarah miller 65680.33333333333
-irene young 65680.33333333333
nick nixon 65696.0
tom steinbeck 65608.0
+calvin white 65548.0
oscar johnson 65650.0
-calvin white 65650.0
holly thompson 65550.0
david falkner 65698.0
ulysses steinbeck 65562.0
@@ -293,31 +293,31 @@ victor allen 65658.0
rachel thompson 65733.0
jessica johnson 65589.0
alice falkner 65597.0
-ulysses carson 65728.33333333333
-priscilla quirinius 65728.33333333333
+priscilla quirinius 65646.0
+ulysses carson 65714.5
victor thompson 65728.33333333333
ulysses ellison 65640.0
bob johnson 65731.0
quinn ellison 65736.0
+bob polk 65776.0
victor xylophone 65697.0
-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
+nick robinson 65566.0
sarah robinson 65605.0
-nick robinson 65605.0
tom hernandez 65575.0
-alice xylophone 65618.0
+alice xylophone 65661.0
sarah xylophone 65618.0
priscilla laertes 65696.0
holly polk 65710.0
katie ichabod 65577.0
holly underhill 65553.0
+alice davidson 65676.0
ethan underhill 65706.5
-alice davidson 65706.5
bob van buren 65654.0
jessica king 65644.0
mike allen 65551.0
@@ -343,8 +343,8 @@ mike king 65543.0
rachel davidson 65728.0
luke ichabod 65757.0
luke young 65696.0
+victor robinson 65571.0
wendy quirinius 65616.0
-victor robinson 65616.0
jessica miller 65763.0
bob ichabod 65733.0
bob falkner 65595.0
@@ -353,15 +353,15 @@ zach zipper 65588.0
alice underhill 65790.0
alice xylophone 65715.0
ethan nixon 65782.0
+bob van buren 65582.0
katie ovid 65613.0
-bob van buren 65613.0
+fred king 65712.0
yuri hernandez 65657.5
-fred king 65657.5
nick falkner 65604.0
+david laertes 65612.0
sarah steinbeck 65655.0
-david laertes 65655.0
+alice carson 65565.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