You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by na...@apache.org on 2013/04/09 08:33:23 UTC
svn commit: r1465903 [13/13] - in /hive/trunk/ql/src/test:
queries/clientpositive/ results/clientpositive/
Modified: hive/trunk/ql/src/test/results/clientpositive/windowing.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/windowing.q.out?rev=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/windowing.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/windowing.q.out Tue Apr 9 06:33:16 2013
@@ -2,8 +2,7 @@ PREHOOK: query: DROP TABLE part
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE part
POSTHOOK: type: DROPTABLE
-PREHOOK: query: -- data setup
-CREATE TABLE part(
+PREHOOK: query: CREATE TABLE part(
p_partkey INT,
p_name STRING,
p_mfgr STRING,
@@ -15,8 +14,7 @@ CREATE TABLE part(
p_comment STRING
)
PREHOOK: type: CREATETABLE
-POSTHOOK: query: -- data setup
-CREATE TABLE part(
+POSTHOOK: query: CREATE TABLE part(
p_partkey INT,
p_name STRING,
p_mfgr STRING,
@@ -35,8 +33,7 @@ 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. testWindowing
-select p_mfgr, p_name, p_size,
+PREHOOK: query: select p_mfgr, p_name, p_size,
rank() over(distribute by p_mfgr sort by p_name) as r,
dense_rank() over(distribute by p_mfgr sort by p_name) as dr,
sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row) as s1
@@ -44,8 +41,7 @@ from part
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 1. testWindowing
-select p_mfgr, p_name, p_size,
+POSTHOOK: query: select p_mfgr, p_name, p_size,
rank() over(distribute by p_mfgr sort by p_name) as r,
dense_rank() over(distribute by p_mfgr sort by p_name) as dr,
sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row) as s1
@@ -79,8 +75,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 3 3 5190.08
Manufacturer#5 almond aquamarine dodger light gainsboro 46 4 4 6208.18
Manufacturer#5 almond azure blanched chiffon midnight 23 5 5 7672.66
-PREHOOK: query: -- 2. testGroupByWithPartitioning
-select p_mfgr, p_name, p_size,
+PREHOOK: query: select p_mfgr, p_name, p_size,
min(p_retailprice),
rank() over(distribute by p_mfgr sort by p_name)as r,
dense_rank() over(distribute by p_mfgr sort by p_name) as dr,
@@ -90,8 +85,7 @@ group by p_mfgr, p_name, p_size
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 2. testGroupByWithPartitioning
-select p_mfgr, p_name, p_size,
+POSTHOOK: query: select p_mfgr, p_name, p_size,
min(p_retailprice),
rank() over(distribute by p_mfgr sort by p_name)as r,
dense_rank() over(distribute by p_mfgr sort by p_name) as dr,
@@ -126,8 +120,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 1788.73 3 3 2 -4
Manufacturer#5 almond aquamarine dodger light gainsboro 46 1018.1 4 4 46 44
Manufacturer#5 almond azure blanched chiffon midnight 23 1464.48 5 5 23 -23
-PREHOOK: query: -- 3. testGroupByHavingWithSWQ
-select p_mfgr, p_name, p_size, min(p_retailprice),
+PREHOOK: query: select p_mfgr, p_name, p_size, min(p_retailprice),
rank() over(distribute by p_mfgr sort by p_name) as r,
dense_rank() over(distribute by p_mfgr sort by p_name) as dr,
p_size, p_size - lag(p_size,1,p_size) over(distribute by p_mfgr sort by p_name) as deltaSz
@@ -137,8 +130,7 @@ having p_size > 0
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 3. testGroupByHavingWithSWQ
-select p_mfgr, p_name, p_size, min(p_retailprice),
+POSTHOOK: query: select p_mfgr, p_name, p_size, min(p_retailprice),
rank() over(distribute by p_mfgr sort by p_name) as r,
dense_rank() over(distribute by p_mfgr sort by p_name) as dr,
p_size, p_size - lag(p_size,1,p_size) over(distribute by p_mfgr sort by p_name) as deltaSz
@@ -173,15 +165,13 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 1788.73 3 3 2 -4
Manufacturer#5 almond aquamarine dodger light gainsboro 46 1018.1 4 4 46 44
Manufacturer#5 almond azure blanched chiffon midnight 23 1464.48 5 5 23 -23
-PREHOOK: query: -- 4. testCount
-select p_mfgr, p_name,
+PREHOOK: query: select p_mfgr, p_name,
count(p_size) over(distribute by p_mfgr sort by p_name) as cd
from part
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 4. testCount
-select p_mfgr, p_name,
+POSTHOOK: query: select p_mfgr, p_name,
count(p_size) over(distribute by p_mfgr sort by p_name) as cd
from part
POSTHOOK: type: QUERY
@@ -213,8 +203,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 3
Manufacturer#5 almond aquamarine dodger light gainsboro 4
Manufacturer#5 almond azure blanched chiffon midnight 5
-PREHOOK: query: -- 5. testCountWithWindowingUDAF
-select p_mfgr, p_name,
+PREHOOK: query: select p_mfgr, p_name,
rank() over(distribute by p_mfgr sort by p_name) as r,
dense_rank() over(distribute by p_mfgr sort by p_name) as dr,
count(p_size) over(distribute by p_mfgr sort by p_name) as cd,
@@ -224,8 +213,7 @@ from part
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 5. testCountWithWindowingUDAF
-select p_mfgr, p_name,
+POSTHOOK: query: select p_mfgr, p_name,
rank() over(distribute by p_mfgr sort by p_name) as r,
dense_rank() over(distribute by p_mfgr sort by p_name) as dr,
count(p_size) over(distribute by p_mfgr sort by p_name) as cd,
@@ -261,8 +249,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 3 3 3 1788.73 5190.08 2 -4
Manufacturer#5 almond aquamarine dodger light gainsboro 4 4 4 1018.1 6208.18 46 44
Manufacturer#5 almond azure blanched chiffon midnight 5 5 5 1464.48 7672.66 23 -23
-PREHOOK: query: -- 6. testCountInSubQ
-select sub1.r, sub1.dr, sub1.cd, sub1.s1, sub1.deltaSz
+PREHOOK: query: select sub1.r, sub1.dr, sub1.cd, sub1.s1, sub1.deltaSz
from (select p_mfgr, p_name,
rank() over(distribute by p_mfgr sort by p_name) as r,
dense_rank() over(distribute by p_mfgr sort by p_name) as dr,
@@ -274,8 +261,7 @@ from part
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 6. testCountInSubQ
-select sub1.r, sub1.dr, sub1.cd, sub1.s1, sub1.deltaSz
+POSTHOOK: query: select sub1.r, sub1.dr, sub1.cd, sub1.s1, sub1.deltaSz
from (select p_mfgr, p_name,
rank() over(distribute by p_mfgr sort by p_name) as r,
dense_rank() over(distribute by p_mfgr sort by p_name) as dr,
@@ -313,8 +299,7 @@ POSTHOOK: Input: default@part
3 3 3 5190.08 -4
4 4 4 6208.18 44
5 5 5 7672.66 -23
-PREHOOK: query: -- 7. testJoinWithWindowingAndPTF
-select abc.p_mfgr, abc.p_name,
+PREHOOK: query: select abc.p_mfgr, abc.p_name,
rank() over(distribute by abc.p_mfgr sort by abc.p_name) as r,
dense_rank() over(distribute by abc.p_mfgr sort by abc.p_name) as dr,
abc.p_retailprice, sum(abc.p_retailprice) over (distribute by abc.p_mfgr sort by abc.p_name rows between unbounded preceding and current row) as s1,
@@ -326,8 +311,7 @@ order by p_name
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 7. testJoinWithWindowingAndPTF
-select abc.p_mfgr, abc.p_name,
+POSTHOOK: query: select abc.p_mfgr, abc.p_name,
rank() over(distribute by abc.p_mfgr sort by abc.p_name) as r,
dense_rank() over(distribute by abc.p_mfgr sort by abc.p_name) as dr,
abc.p_retailprice, sum(abc.p_retailprice) over (distribute by abc.p_mfgr sort by abc.p_name rows between unbounded preceding and current row) as s1,
@@ -367,15 +351,13 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 3 3 1788.73 5190.08 2 -4
Manufacturer#5 almond aquamarine dodger light gainsboro 4 4 1018.1 6208.18 46 44
Manufacturer#5 almond azure blanched chiffon midnight 5 5 1464.48 7672.66 23 -23
-PREHOOK: query: -- 8. testMixedCaseAlias
-select p_mfgr, p_name, p_size,
+PREHOOK: query: select p_mfgr, p_name, p_size,
rank() over(distribute by p_mfgr sort by p_name, p_size desc) as R
from part
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 8. testMixedCaseAlias
-select p_mfgr, p_name, p_size,
+POSTHOOK: query: select p_mfgr, p_name, p_size,
rank() over(distribute by p_mfgr sort by p_name, p_size desc) as R
from part
POSTHOOK: type: QUERY
@@ -407,8 +389,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 3
Manufacturer#5 almond aquamarine dodger light gainsboro 46 4
Manufacturer#5 almond azure blanched chiffon midnight 23 5
-PREHOOK: query: -- 9. testHavingWithWindowingNoGBY
-select p_mfgr, p_name, p_size,
+PREHOOK: query: select p_mfgr, p_name, p_size,
rank() over(distribute by p_mfgr sort by p_name) as r,
dense_rank() over(distribute by p_mfgr sort by p_name) as dr,
sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row) as s1
@@ -416,8 +397,7 @@ from part
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 9. testHavingWithWindowingNoGBY
-select p_mfgr, p_name, p_size,
+POSTHOOK: query: select p_mfgr, p_name, p_size,
rank() over(distribute by p_mfgr sort by p_name) as r,
dense_rank() over(distribute by p_mfgr sort by p_name) as dr,
sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row) as s1
@@ -451,8 +431,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 3 3 5190.08
Manufacturer#5 almond aquamarine dodger light gainsboro 46 4 4 6208.18
Manufacturer#5 almond azure blanched chiffon midnight 23 5 5 7672.66
-PREHOOK: query: -- 10. testHavingWithWindowingCondRankNoGBY
-select p_mfgr, p_name, p_size,
+PREHOOK: query: select p_mfgr, p_name, p_size,
rank() over(distribute by p_mfgr sort by p_name) as r,
dense_rank() over(distribute by p_mfgr sort by p_name) as dr,
sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row) as s1
@@ -460,8 +439,7 @@ from part
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 10. testHavingWithWindowingCondRankNoGBY
-select p_mfgr, p_name, p_size,
+POSTHOOK: query: select p_mfgr, p_name, p_size,
rank() over(distribute by p_mfgr sort by p_name) as r,
dense_rank() over(distribute by p_mfgr sort by p_name) as dr,
sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row) as s1
@@ -495,8 +473,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 3 3 5190.08
Manufacturer#5 almond aquamarine dodger light gainsboro 46 4 4 6208.18
Manufacturer#5 almond azure blanched chiffon midnight 23 5 5 7672.66
-PREHOOK: query: -- 11. testFirstLast
-select p_mfgr,p_name, p_size,
+PREHOOK: query: select p_mfgr,p_name, p_size,
sum(p_size) over (distribute by p_mfgr sort by p_mfgr rows between current row and current row) as s2,
first_value(p_size) over w1 as f,
last_value(p_size, false) over w1 as l
@@ -505,8 +482,7 @@ window w1 as (distribute by p_mfgr sort
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 11. testFirstLast
-select p_mfgr,p_name, p_size,
+POSTHOOK: query: select p_mfgr,p_name, p_size,
sum(p_size) over (distribute by p_mfgr sort by p_mfgr rows between current row and current row) as s2,
first_value(p_size) over w1 as f,
last_value(p_size, false) over w1 as l
@@ -541,8 +517,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 2 31 23
Manufacturer#5 almond aquamarine dodger light gainsboro 46 46 6 23
Manufacturer#5 almond azure blanched chiffon midnight 23 23 2 23
-PREHOOK: query: -- 12. testFirstLastWithWhere
-select p_mfgr,p_name, p_size,
+PREHOOK: query: select p_mfgr,p_name, p_size,
rank() over(distribute by p_mfgr sort by p_mfgr) as r,
sum(p_size) over (distribute by p_mfgr sort by p_mfgr rows between current row and current row) as s2,
first_value(p_size) over w1 as f,
@@ -553,8 +528,7 @@ window w1 as (distribute by p_mfgr sort
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 12. testFirstLastWithWhere
-select p_mfgr,p_name, p_size,
+POSTHOOK: query: select p_mfgr,p_name, p_size,
rank() over(distribute by p_mfgr sort by p_mfgr) as r,
sum(p_size) over (distribute by p_mfgr sort by p_mfgr rows between current row and current row) as s2,
first_value(p_size) over w1 as f,
@@ -570,8 +544,7 @@ Manufacturer#3 almond antique forest lav
Manufacturer#3 almond antique metallic orange dim 19 1 19 17 45
Manufacturer#3 almond antique misty red olive 1 1 1 14 45
Manufacturer#3 almond antique olive coral navajo 45 1 45 19 45
-PREHOOK: query: -- 13. testSumWindow
-select p_mfgr,p_name, p_size,
+PREHOOK: query: select p_mfgr,p_name, p_size,
sum(p_size) over w1 as s1,
sum(p_size) over (distribute by p_mfgr sort by p_mfgr rows between current row and current row) as s2
from part
@@ -579,8 +552,7 @@ window w1 as (distribute by p_mfgr sort
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 13. testSumWindow
-select p_mfgr,p_name, p_size,
+POSTHOOK: query: select p_mfgr,p_name, p_size,
sum(p_size) over w1 as s1,
sum(p_size) over (distribute by p_mfgr sort by p_mfgr rows between current row and current row) as s2
from part
@@ -614,16 +586,14 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 108 2
Manufacturer#5 almond aquamarine dodger light gainsboro 46 77 46
Manufacturer#5 almond azure blanched chiffon midnight 23 71 23
-PREHOOK: query: -- 14. testNoSortClause
-select p_mfgr,p_name, p_size,
+PREHOOK: query: select p_mfgr,p_name, p_size,
rank() over(distribute by p_mfgr) as r, dense_rank() over(distribute by p_mfgr) as dr
from part
window w1 as (distribute by p_mfgr rows between 2 preceding and 2 following)
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 14. testNoSortClause
-select p_mfgr,p_name, p_size,
+POSTHOOK: query: select p_mfgr,p_name, p_size,
rank() over(distribute by p_mfgr) as r, dense_rank() over(distribute by p_mfgr) as dr
from part
window w1 as (distribute by p_mfgr rows between 2 preceding and 2 following)
@@ -656,8 +626,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 1 1
Manufacturer#5 almond aquamarine dodger light gainsboro 46 1 1
Manufacturer#5 almond azure blanched chiffon midnight 23 1 1
-PREHOOK: query: -- 15. testExpressions
-select p_mfgr,p_name, p_size,
+PREHOOK: query: select p_mfgr,p_name, p_size,
rank() over(distribute by p_mfgr sort by p_mfgr) as r,
dense_rank() over(distribute by p_mfgr sort by p_mfgr) as dr,
cume_dist() over(distribute by p_mfgr sort by p_mfgr) as cud,
@@ -674,8 +643,7 @@ window w1 as (distribute by p_mfgr sort
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 15. testExpressions
-select p_mfgr,p_name, p_size,
+POSTHOOK: query: select p_mfgr,p_name, p_size,
rank() over(distribute by p_mfgr sort by p_mfgr) as r,
dense_rank() over(distribute by p_mfgr sort by p_mfgr) as dr,
cume_dist() over(distribute by p_mfgr sort by p_mfgr) as cud,
@@ -718,8 +686,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 1 1 1.0 0.0 2 5 21.6 16.206171663906314 1 23 31
Manufacturer#5 almond aquamarine dodger light gainsboro 46 1 1 1.0 0.0 2 5 21.6 16.206171663906314 1 23 6
Manufacturer#5 almond azure blanched chiffon midnight 23 1 1 1.0 0.0 3 5 21.6 16.206171663906314 1 23 2
-PREHOOK: query: -- 16. testMultipleWindows
-select p_mfgr,p_name, p_size,
+PREHOOK: query: select p_mfgr,p_name, p_size,
rank() over(distribute by p_mfgr sort by p_mfgr) as r,
dense_rank() over(distribute by p_mfgr sort by p_mfgr) as dr,
cume_dist() over(distribute by p_mfgr sort by p_mfgr) as cud,
@@ -731,8 +698,7 @@ window w1 as (distribute by p_mfgr sort
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 16. testMultipleWindows
-select p_mfgr,p_name, p_size,
+POSTHOOK: query: select p_mfgr,p_name, p_size,
rank() over(distribute by p_mfgr sort by p_mfgr) as r,
dense_rank() over(distribute by p_mfgr sort by p_mfgr) as dr,
cume_dist() over(distribute by p_mfgr sort by p_mfgr) as cud,
@@ -770,8 +736,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond azure blanched chiffon midnight 23 1 1 1.0 108 23 2
Manufacturer#5 almond antique blue firebrick mint 31 1 1 1.0 31 31 31
Manufacturer#5 almond aquamarine dodger light gainsboro 46 1 1 1.0 85 46 6
-PREHOOK: query: -- 17. testCountStar
-select p_mfgr,p_name, p_size,
+PREHOOK: query: select p_mfgr,p_name, p_size,
count(*) over(distribute by p_mfgr sort by p_mfgr ) as c,
count(p_size) over(distribute by p_mfgr sort by p_mfgr) as ca,
first_value(p_size) over w1 as fvW1
@@ -780,8 +745,7 @@ window w1 as (distribute by p_mfgr sort
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 17. testCountStar
-select p_mfgr,p_name, p_size,
+POSTHOOK: query: select p_mfgr,p_name, p_size,
count(*) over(distribute by p_mfgr sort by p_mfgr ) as c,
count(p_size) over(distribute by p_mfgr sort by p_mfgr) as ca,
first_value(p_size) over w1 as fvW1
@@ -816,8 +780,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 5 5 31
Manufacturer#5 almond aquamarine dodger light gainsboro 46 5 5 6
Manufacturer#5 almond azure blanched chiffon midnight 23 5 5 2
-PREHOOK: query: -- 18. testUDAFs
-select p_mfgr,p_name, p_size,
+PREHOOK: query: select p_mfgr,p_name, p_size,
sum(p_retailprice) over w1 as s,
min(p_retailprice) over w1 as mi,
max(p_retailprice) over w1 as ma,
@@ -827,8 +790,7 @@ window w1 as (distribute by p_mfgr sort
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 18. testUDAFs
-select p_mfgr,p_name, p_size,
+POSTHOOK: query: select p_mfgr,p_name, p_size,
sum(p_retailprice) over w1 as s,
min(p_retailprice) over w1 as mi,
max(p_retailprice) over w1 as ma,
@@ -864,8 +826,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 7672.66 1018.1 1789.69 1534.532
Manufacturer#5 almond aquamarine dodger light gainsboro 46 5882.970000000001 1018.1 1788.73 1470.7425000000003
Manufacturer#5 almond azure blanched chiffon midnight 23 4271.3099999999995 1018.1 1788.73 1423.7699999999998
-PREHOOK: query: -- 19. testUDAFsWithGBY
-select p_mfgr,p_name, p_size, p_retailprice,
+PREHOOK: query: select p_mfgr,p_name, p_size, p_retailprice,
sum(p_retailprice) over w1 as s,
min(p_retailprice) as mi ,
max(p_retailprice) as ma ,
@@ -876,8 +837,7 @@ window w1 as (distribute by p_mfgr sort
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 19. testUDAFsWithGBY
-select p_mfgr,p_name, p_size, p_retailprice,
+POSTHOOK: query: select p_mfgr,p_name, p_size, p_retailprice,
sum(p_retailprice) over w1 as s,
min(p_retailprice) as mi ,
max(p_retailprice) as ma ,
@@ -913,8 +873,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 1788.73 7672.66 1788.73 1788.73 1534.532
Manufacturer#5 almond aquamarine dodger light gainsboro 46 1018.1 5882.970000000001 1018.1 1018.1 1470.7425000000003
Manufacturer#5 almond azure blanched chiffon midnight 23 1464.48 4271.3099999999995 1464.48 1464.48 1423.7699999999998
-PREHOOK: query: -- 20. testSTATs
-select p_mfgr,p_name, p_size,
+PREHOOK: query: select p_mfgr,p_name, p_size,
stddev(p_retailprice) over w1 as sdev,
stddev_pop(p_retailprice) over w1 as sdev_pop,
collect_set(p_size) over w1 as uniq_size,
@@ -926,8 +885,7 @@ window w1 as (distribute by p_mfgr sort
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 20. testSTATs
-select p_mfgr,p_name, p_size,
+POSTHOOK: query: select p_mfgr,p_name, p_size,
stddev(p_retailprice) over w1 as sdev,
stddev_pop(p_retailprice) over w1 as sdev_pop,
collect_set(p_size) over w1 as uniq_size,
@@ -965,8 +923,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 285.40506298242155 285.40506298242155 [2,23,6,46,31] 81456.04997600002 -0.712858514567818 -3297.2011999999986
Manufacturer#5 almond aquamarine dodger light gainsboro 46 285.43749038756283 285.43749038756283 [2,23,6,46] 81474.56091875004 -0.984128787153391 -4871.028125000002
Manufacturer#5 almond azure blanched chiffon midnight 23 315.9225931564038 315.9225931564038 [2,23,46] 99807.08486666664 -0.9978877469246936 -5664.856666666666
-PREHOOK: query: -- 21. testDISTs
-select p_mfgr,p_name, p_size,
+PREHOOK: query: select p_mfgr,p_name, p_size,
histogram_numeric(p_retailprice, 5) over w1 as hist,
percentile(p_partkey, 0.5) over w1 as per,
row_number() over(distribute by p_mfgr sort by p_mfgr) as rn
@@ -975,8 +932,7 @@ window w1 as (distribute by p_mfgr sort
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 21. testDISTs
-select p_mfgr,p_name, p_size,
+POSTHOOK: query: select p_mfgr,p_name, p_size,
histogram_numeric(p_retailprice, 5) over w1 as hist,
percentile(p_partkey, 0.5) over w1 as per,
row_number() over(distribute by p_mfgr sort by p_mfgr) as rn
@@ -1011,15 +967,13 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 [{"x":1018.1,"y":1.0},{"x":1464.48,"y":1.0},{"x":1611.66,"y":1.0},{"x":1788.73,"y":1.0},{"x":1789.69,"y":1.0}] 78486.0 3
Manufacturer#5 almond aquamarine dodger light gainsboro 46 [{"x":1018.1,"y":1.0},{"x":1464.48,"y":1.0},{"x":1611.66,"y":1.0},{"x":1788.73,"y":1.0}] 60577.5 4
Manufacturer#5 almond azure blanched chiffon midnight 23 [{"x":1018.1,"y":1.0},{"x":1464.48,"y":1.0},{"x":1788.73,"y":1.0}] 78486.0 5
-PREHOOK: query: -- 22. testViewAsTableInputWithWindowing
-create view IF NOT EXISTS mfgr_price_view as
+PREHOOK: query: create view IF NOT EXISTS mfgr_price_view as
select p_mfgr, p_brand,
sum(p_retailprice) as s
from part
group by p_mfgr, p_brand
PREHOOK: type: CREATEVIEW
-POSTHOOK: query: -- 22. testViewAsTableInputWithWindowing
-create view IF NOT EXISTS mfgr_price_view as
+POSTHOOK: query: create view IF NOT EXISTS mfgr_price_view as
select p_mfgr, p_brand,
sum(p_retailprice) as s
from part
@@ -1058,15 +1012,13 @@ Manufacturer#4 Brand#42 2581.68000000000
Manufacturer#5 Brand#51 1611.66 1611.66
Manufacturer#5 Brand#52 3254.17 4865.83
Manufacturer#5 Brand#53 2806.83 7672.66
-PREHOOK: query: -- 23. testCreateViewWithWindowingQuery
-create view IF NOT EXISTS mfgr_brand_price_view as
+PREHOOK: query: create view IF NOT EXISTS mfgr_brand_price_view as
select p_mfgr, p_brand,
sum(p_retailprice) over w1 as s
from part
window w1 as (distribute by p_mfgr sort by p_mfgr rows between 2 preceding and current row)
PREHOOK: type: CREATEVIEW
-POSTHOOK: query: -- 23. testCreateViewWithWindowingQuery
-create view IF NOT EXISTS mfgr_brand_price_view as
+POSTHOOK: query: create view IF NOT EXISTS mfgr_brand_price_view as
select p_mfgr, p_brand,
sum(p_retailprice) over w1 as s
from part
@@ -1109,8 +1061,7 @@ Manufacturer#5 Brand#51 3401.35000000000
Manufacturer#5 Brand#53 5190.08
Manufacturer#5 Brand#53 4418.490000000001
Manufacturer#5 Brand#52 4271.3099999999995
-PREHOOK: query: -- 24. testLateralViews
-select p_mfgr, p_name,
+PREHOOK: query: select p_mfgr, p_name,
lv_col, p_size, sum(p_size) over w1 as s
from (select p_mfgr, p_name, p_size, array(1,2,3) arr from part) p
lateral view explode(arr) part_lv as lv_col
@@ -1118,8 +1069,7 @@ window w1 as (distribute by p_mfgr sort
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 24. testLateralViews
-select p_mfgr, p_name,
+POSTHOOK: query: select p_mfgr, p_name,
lv_col, p_size, sum(p_size) over w1 as s
from (select p_mfgr, p_name, p_size, array(1,2,3) arr from part) p
lateral view explode(arr) part_lv as lv_col
@@ -1205,8 +1155,7 @@ Manufacturer#5 almond aquamarine dodger
Manufacturer#5 almond azure blanched chiffon midnight 1 23 115
Manufacturer#5 almond azure blanched chiffon midnight 2 23 92
Manufacturer#5 almond azure blanched chiffon midnight 3 23 69
-PREHOOK: query: -- 25. testMultipleInserts3SWQs
-CREATE TABLE part_1(
+PREHOOK: query: CREATE TABLE part_1(
p_mfgr STRING,
p_name STRING,
p_size INT,
@@ -1214,8 +1163,7 @@ r INT,
dr INT,
s DOUBLE)
PREHOOK: type: CREATETABLE
-POSTHOOK: query: -- 25. testMultipleInserts3SWQs
-CREATE TABLE part_1(
+POSTHOOK: query: CREATE TABLE part_1(
p_mfgr STRING,
p_name STRING,
p_size INT,
@@ -1502,8 +1450,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 5 5 31
Manufacturer#5 almond aquamarine dodger light gainsboro 46 5 5 6
Manufacturer#5 almond azure blanched chiffon midnight 23 5 5 2
-PREHOOK: query: -- 26. testGroupByHavingWithSWQAndAlias
-select p_mfgr, p_name, p_size, min(p_retailprice) as mi,
+PREHOOK: query: select p_mfgr, p_name, p_size, min(p_retailprice) as mi,
rank() over(distribute by p_mfgr sort by p_name) as r,
dense_rank() over(distribute by p_mfgr sort by p_name) as dr,
p_size, p_size - lag(p_size,1,p_size) over(distribute by p_mfgr sort by p_name) as deltaSz
@@ -1513,8 +1460,7 @@ having p_size > 0
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 26. testGroupByHavingWithSWQAndAlias
-select p_mfgr, p_name, p_size, min(p_retailprice) as mi,
+POSTHOOK: query: select p_mfgr, p_name, p_size, min(p_retailprice) as mi,
rank() over(distribute by p_mfgr sort by p_name) as r,
dense_rank() over(distribute by p_mfgr sort by p_name) as dr,
p_size, p_size - lag(p_size,1,p_size) over(distribute by p_mfgr sort by p_name) as deltaSz
@@ -1570,8 +1516,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 1788.73 3 3 2 -4
Manufacturer#5 almond aquamarine dodger light gainsboro 46 1018.1 4 4 46 44
Manufacturer#5 almond azure blanched chiffon midnight 23 1464.48 5 5 23 -23
-PREHOOK: query: -- 27. testMultipleRangeWindows
-select p_mfgr,p_name, p_size,
+PREHOOK: query: select p_mfgr,p_name, p_size,
sum(p_size) over (distribute by p_mfgr sort by p_size range between 10 preceding and current row) as s2,
sum(p_size) over (distribute by p_mfgr sort by p_size range between current row and 10 following ) as s1
from part
@@ -1579,8 +1524,7 @@ window w1 as (rows between 2 preceding a
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 27. testMultipleRangeWindows
-select p_mfgr,p_name, p_size,
+POSTHOOK: query: select p_mfgr,p_name, p_size,
sum(p_size) over (distribute by p_mfgr sort by p_size range between 10 preceding and current row) as s2,
sum(p_size) over (distribute by p_mfgr sort by p_size range between current row and 10 following ) as s1
from part
@@ -1635,15 +1579,13 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond azure blanched chiffon midnight 23 23 54
Manufacturer#5 almond antique blue firebrick mint 31 54 31
Manufacturer#5 almond aquamarine dodger light gainsboro 46 46 46
-PREHOOK: query: -- 28. testPartOrderInUDAFInvoke
-select p_mfgr, p_name, p_size,
+PREHOOK: query: select p_mfgr, p_name, p_size,
sum(p_size) over (partition by p_mfgr order by p_name rows between 2 preceding and 2 following) as s
from part
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 28. testPartOrderInUDAFInvoke
-select p_mfgr, p_name, p_size,
+POSTHOOK: query: select p_mfgr, p_name, p_size,
sum(p_size) over (partition by p_mfgr order by p_name rows between 2 preceding and 2 following) as s
from part
POSTHOOK: type: QUERY
@@ -1696,16 +1638,14 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 108
Manufacturer#5 almond aquamarine dodger light gainsboro 46 77
Manufacturer#5 almond azure blanched chiffon midnight 23 71
-PREHOOK: query: -- 29. testPartOrderInWdwDef
-select p_mfgr, p_name, p_size,
+PREHOOK: query: select p_mfgr, p_name, p_size,
sum(p_size) over w1 as s
from part
window w1 as (partition by p_mfgr order by p_name rows between 2 preceding and 2 following)
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 29. testPartOrderInWdwDef
-select p_mfgr, p_name, p_size,
+POSTHOOK: query: select p_mfgr, p_name, p_size,
sum(p_size) over w1 as s
from part
window w1 as (partition by p_mfgr order by p_name rows between 2 preceding and 2 following)
@@ -1759,8 +1699,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 108
Manufacturer#5 almond aquamarine dodger light gainsboro 46 77
Manufacturer#5 almond azure blanched chiffon midnight 23 71
-PREHOOK: query: -- 30. testDefaultPartitioningSpecRules
-select p_mfgr, p_name, p_size,
+PREHOOK: query: select p_mfgr, p_name, p_size,
sum(p_size) over w1 as s,
sum(p_size) over w2 as s2
from part
@@ -1769,8 +1708,7 @@ window w1 as (distribute by p_mfgr sort
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 30. testDefaultPartitioningSpecRules
-select p_mfgr, p_name, p_size,
+POSTHOOK: query: select p_mfgr, p_name, p_size,
sum(p_size) over w1 as s,
sum(p_size) over w2 as s2
from part
@@ -1826,8 +1764,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 108 39
Manufacturer#5 almond aquamarine dodger light gainsboro 46 77 85
Manufacturer#5 almond azure blanched chiffon midnight 23 71 108
-PREHOOK: query: -- 31. testWindowCrossReference
-select p_mfgr, p_name, p_size,
+PREHOOK: query: select p_mfgr, p_name, p_size,
sum(p_size) over w1 as s1,
sum(p_size) over w2 as s2
from part
@@ -1836,8 +1773,7 @@ window w1 as (partition by p_mfgr order
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 31. testWindowCrossReference
-select p_mfgr, p_name, p_size,
+POSTHOOK: query: select p_mfgr, p_name, p_size,
sum(p_size) over w1 as s1,
sum(p_size) over w2 as s2
from part
@@ -1893,8 +1829,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 108 108
Manufacturer#5 almond aquamarine dodger light gainsboro 46 77 77
Manufacturer#5 almond azure blanched chiffon midnight 23 71 71
-PREHOOK: query: -- 32. testWindowInheritance
-select p_mfgr, p_name, p_size,
+PREHOOK: query: select p_mfgr, p_name, p_size,
sum(p_size) over w1 as s1,
sum(p_size) over w2 as s2
from part
@@ -1903,8 +1838,7 @@ window w1 as (partition by p_mfgr order
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 32. testWindowInheritance
-select p_mfgr, p_name, p_size,
+POSTHOOK: query: select p_mfgr, p_name, p_size,
sum(p_size) over w1 as s1,
sum(p_size) over w2 as s2
from part
@@ -1960,8 +1894,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 108 39
Manufacturer#5 almond aquamarine dodger light gainsboro 46 77 85
Manufacturer#5 almond azure blanched chiffon midnight 23 71 108
-PREHOOK: query: -- 33. testWindowForwardReference
-select p_mfgr, p_name, p_size,
+PREHOOK: query: select p_mfgr, p_name, p_size,
sum(p_size) over w1 as s1,
sum(p_size) over w2 as s2,
sum(p_size) over w3 as s3
@@ -1972,8 +1905,7 @@ window w1 as (distribute by p_mfgr sort
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 33. testWindowForwardReference
-select p_mfgr, p_name, p_size,
+POSTHOOK: query: select p_mfgr, p_name, p_size,
sum(p_size) over w1 as s1,
sum(p_size) over w2 as s2,
sum(p_size) over w3 as s3
@@ -2031,8 +1963,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 108 39 39
Manufacturer#5 almond aquamarine dodger light gainsboro 46 77 85 85
Manufacturer#5 almond azure blanched chiffon midnight 23 71 108 108
-PREHOOK: query: -- 34. testWindowDefinitionPropagation
-select p_mfgr, p_name, p_size,
+PREHOOK: query: select p_mfgr, p_name, p_size,
sum(p_size) over w1 as s1,
sum(p_size) over w2 as s2,
sum(p_size) over (w3 rows between 2 preceding and 2 following) as s3
@@ -2043,8 +1974,7 @@ window w1 as (distribute by p_mfgr sort
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 34. testWindowDefinitionPropagation
-select p_mfgr, p_name, p_size,
+POSTHOOK: query: select p_mfgr, p_name, p_size,
sum(p_size) over w1 as s1,
sum(p_size) over w2 as s2,
sum(p_size) over (w3 rows between 2 preceding and 2 following) as s3
@@ -2102,16 +2032,14 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 108 39 108
Manufacturer#5 almond aquamarine dodger light gainsboro 46 77 85 77
Manufacturer#5 almond azure blanched chiffon midnight 23 71 108 71
-PREHOOK: query: -- 35. testDistinctWithWindowing
-select DISTINCT p_mfgr, p_name, p_size,
+PREHOOK: query: select DISTINCT p_mfgr, p_name, p_size,
sum(p_size) over w1 as s
from part
window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following)
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 35. testDistinctWithWindowing
-select DISTINCT p_mfgr, p_name, p_size,
+POSTHOOK: query: select DISTINCT p_mfgr, p_name, p_size,
sum(p_size) over w1 as s
from part
window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following)
@@ -2164,15 +2092,13 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 108
Manufacturer#5 almond aquamarine dodger light gainsboro 46 77
Manufacturer#5 almond azure blanched chiffon midnight 23 71
-PREHOOK: query: -- 36. testRankWithPartitioning
-select p_mfgr, p_name, p_size,
+PREHOOK: query: select p_mfgr, p_name, p_size,
rank() over (partition by p_mfgr order by p_name ) as r
from part
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 36. testRankWithPartitioning
-select p_mfgr, p_name, p_size,
+POSTHOOK: query: select p_mfgr, p_name, p_size,
rank() over (partition by p_mfgr order by p_name ) as r
from part
POSTHOOK: type: QUERY
@@ -2225,8 +2151,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 3
Manufacturer#5 almond aquamarine dodger light gainsboro 46 4
Manufacturer#5 almond azure blanched chiffon midnight 23 5
-PREHOOK: query: -- 37. testPartitioningVariousForms
-select p_mfgr, p_name, p_size,
+PREHOOK: query: select p_mfgr, p_name, p_size,
sum(p_retailprice) over (partition by p_mfgr order by p_mfgr) as s1,
min(p_retailprice) over (partition by p_mfgr) as s2,
max(p_retailprice) over (distribute by p_mfgr sort by p_mfgr) as s3,
@@ -2236,8 +2161,7 @@ from part
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 37. testPartitioningVariousForms
-select p_mfgr, p_name, p_size,
+POSTHOOK: query: select p_mfgr, p_name, p_size,
sum(p_retailprice) over (partition by p_mfgr order by p_mfgr) as s1,
min(p_retailprice) over (partition by p_mfgr) as s2,
max(p_retailprice) over (distribute by p_mfgr sort by p_mfgr) as s3,
@@ -2294,8 +2218,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 7672.66 1018.1 1789.69 1534.532 5
Manufacturer#5 almond aquamarine dodger light gainsboro 46 7672.66 1018.1 1789.69 1534.532 5
Manufacturer#5 almond azure blanched chiffon midnight 23 7672.66 1018.1 1789.69 1534.532 5
-PREHOOK: query: -- 38. testPartitioningVariousForms2
-select p_mfgr, p_name, p_size,
+PREHOOK: query: select p_mfgr, p_name, p_size,
sum(p_retailprice) over (partition by p_mfgr, p_name order by p_mfgr, p_name rows between unbounded preceding and current row) as s1,
min(p_retailprice) over (distribute by p_mfgr, p_name sort by p_mfgr, p_name rows between unbounded preceding and current row) as s2,
max(p_retailprice) over (partition by p_mfgr, p_name order by p_name) as s3
@@ -2303,8 +2226,7 @@ from part
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 38. testPartitioningVariousForms2
-select p_mfgr, p_name, p_size,
+POSTHOOK: query: select p_mfgr, p_name, p_size,
sum(p_retailprice) over (partition by p_mfgr, p_name order by p_mfgr, p_name rows between unbounded preceding and current row) as s1,
min(p_retailprice) over (distribute by p_mfgr, p_name sort by p_mfgr, p_name rows between unbounded preceding and current row) as s2,
max(p_retailprice) over (partition by p_mfgr, p_name order by p_name) as s3
@@ -2359,15 +2281,13 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 1788.73 1788.73 1788.73
Manufacturer#5 almond aquamarine dodger light gainsboro 46 1018.1 1018.1 1018.1
Manufacturer#5 almond azure blanched chiffon midnight 23 1464.48 1464.48 1464.48
-PREHOOK: query: -- 39. testUDFOnOrderCols
-select p_mfgr, p_type, substr(p_type, 2) as short_ptype,
+PREHOOK: query: select p_mfgr, p_type, substr(p_type, 2) as short_ptype,
rank() over (partition by p_mfgr order by substr(p_type, 2)) as r
from part
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 39. testUDFOnOrderCols
-select p_mfgr, p_type, substr(p_type, 2) as short_ptype,
+POSTHOOK: query: select p_mfgr, p_type, substr(p_type, 2) as short_ptype,
rank() over (partition by p_mfgr order by substr(p_type, 2)) as r
from part
POSTHOOK: type: QUERY
@@ -2420,15 +2340,13 @@ Manufacturer#5 ECONOMY BURNISHED STEEL C
Manufacturer#5 MEDIUM BURNISHED TIN EDIUM BURNISHED TIN 3
Manufacturer#5 SMALL PLATED BRASS MALL PLATED BRASS 4
Manufacturer#5 STANDARD BURNISHED TIN TANDARD BURNISHED TIN 5
-PREHOOK: query: -- 40. testNoBetweenForRows
-select p_mfgr, p_name, p_size,
+PREHOOK: query: select p_mfgr, p_name, p_size,
sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows unbounded preceding) as s1
from part
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 40. testNoBetweenForRows
-select p_mfgr, p_name, p_size,
+POSTHOOK: query: select p_mfgr, p_name, p_size,
sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows unbounded preceding) as s1
from part
POSTHOOK: type: QUERY
@@ -2481,15 +2399,13 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 5190.08
Manufacturer#5 almond aquamarine dodger light gainsboro 46 6208.18
Manufacturer#5 almond azure blanched chiffon midnight 23 7672.66
-PREHOOK: query: -- 41. testNoBetweenForRange
-select p_mfgr, p_name, p_size,
+PREHOOK: query: select p_mfgr, p_name, p_size,
sum(p_retailprice) over (distribute by p_mfgr sort by p_size range unbounded preceding) as s1
from part
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 41. testNoBetweenForRange
-select p_mfgr, p_name, p_size,
+POSTHOOK: query: select p_mfgr, p_name, p_size,
sum(p_retailprice) over (distribute by p_mfgr sort by p_size range unbounded preceding) as s1
from part
POSTHOOK: type: QUERY
@@ -2542,15 +2458,13 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond azure blanched chiffon midnight 23 4864.870000000001
Manufacturer#5 almond antique blue firebrick mint 31 6654.560000000001
Manufacturer#5 almond aquamarine dodger light gainsboro 46 7672.660000000002
-PREHOOK: query: -- 42. testUnboundedFollowingForRows
-select p_mfgr, p_name, p_size,
+PREHOOK: query: select p_mfgr, p_name, p_size,
sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between current row and unbounded following) as s1
from part
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 42. testUnboundedFollowingForRows
-select p_mfgr, p_name, p_size,
+POSTHOOK: query: select p_mfgr, p_name, p_size,
sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between current row and unbounded following) as s1
from part
POSTHOOK: type: QUERY
@@ -2603,15 +2517,13 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 4271.3099999999995
Manufacturer#5 almond aquamarine dodger light gainsboro 46 2482.58
Manufacturer#5 almond azure blanched chiffon midnight 23 1464.48
-PREHOOK: query: -- 43. testUnboundedFollowingForRange
-select p_mfgr, p_name, p_size,
+PREHOOK: query: select p_mfgr, p_name, p_size,
sum(p_retailprice) over (distribute by p_mfgr sort by p_size range between current row and unbounded following) as s1
from part
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 43. testUnboundedFollowingForRange
-select p_mfgr, p_name, p_size,
+POSTHOOK: query: select p_mfgr, p_name, p_size,
sum(p_retailprice) over (distribute by p_mfgr sort by p_size range between current row and unbounded following) as s1
from part
POSTHOOK: type: QUERY
@@ -2664,16 +2576,14 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond azure blanched chiffon midnight 23 4272.27
Manufacturer#5 almond antique blue firebrick mint 31 2807.79
Manufacturer#5 almond aquamarine dodger light gainsboro 46 1018.1
-PREHOOK: query: -- 44. testOverNoPartitionSingleAggregate
-select p_name, p_retailprice,
+PREHOOK: query: select p_name, p_retailprice,
avg(p_retailprice) over()
from part
order by p_name
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 44. testOverNoPartitionSingleAggregate
-select p_name, p_retailprice,
+POSTHOOK: query: select p_name, p_retailprice,
avg(p_retailprice) over()
from part
order by p_name
Modified: 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=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/windowing_columnPruning.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/windowing_columnPruning.q.out Tue Apr 9 06:33:16 2013
@@ -2,8 +2,7 @@ PREHOOK: query: DROP TABLE part
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE part
POSTHOOK: type: DROPTABLE
-PREHOOK: query: -- data setup
-CREATE TABLE part(
+PREHOOK: query: CREATE TABLE part(
p_partkey INT,
p_name STRING,
p_mfgr STRING,
@@ -15,8 +14,7 @@ CREATE TABLE part(
p_comment STRING
)
PREHOOK: type: CREATETABLE
-POSTHOOK: query: -- data setup
-CREATE TABLE part(
+POSTHOOK: query: CREATE TABLE part(
p_partkey INT,
p_name STRING,
p_mfgr STRING,
@@ -35,15 +33,13 @@ 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,
+PREHOOK: query: 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,
+POSTHOOK: query: 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
@@ -75,15 +71,13 @@ POSTHOOK: Input: default@part
2 5190.08
46 6208.18
23 7672.66
-PREHOOK: query: -- 2. testWindowPartitionColsNotInSelect
-select p_size,
+PREHOOK: query: 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,
+POSTHOOK: query: 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
@@ -115,15 +109,13 @@ POSTHOOK: Input: default@part
2 5190.08
46 6208.18
23 7672.66
-PREHOOK: query: -- 3. testHavingColNotInSelect
-select p_mfgr,
+PREHOOK: query: 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,
+POSTHOOK: query: 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
Modified: 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=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/windowing_expressions.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/windowing_expressions.q.out Tue Apr 9 06:33:16 2013
@@ -2,8 +2,7 @@ PREHOOK: query: DROP TABLE part
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE part
POSTHOOK: type: DROPTABLE
-PREHOOK: query: -- data setup
-CREATE TABLE part(
+PREHOOK: query: CREATE TABLE part(
p_partkey INT,
p_name STRING,
p_mfgr STRING,
@@ -15,8 +14,7 @@ CREATE TABLE part(
p_comment STRING
)
PREHOOK: type: CREATETABLE
-POSTHOOK: query: -- data setup
-CREATE TABLE part(
+POSTHOOK: query: CREATE TABLE part(
p_partkey INT,
p_name STRING,
p_mfgr STRING,
@@ -662,11 +660,9 @@ Manufacturer#5 1241.29
Manufacturer#5 1424.0900000000001
Manufacturer#5 1515.25
Manufacturer#5 1534.532
-PREHOOK: query: -- multi table insert test
-create table t1 (a1 int, b1 string)
+PREHOOK: query: create table t1 (a1 int, b1 string)
PREHOOK: type: CREATETABLE
-POSTHOOK: query: -- multi table insert test
-create table t1 (a1 int, b1 string)
+POSTHOOK: query: create table t1 (a1 int, b1 string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@t1
PREHOOK: query: create table t2 (a1 int, b1 string)
Modified: 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=1465903&r1=1465902&r2=1465903&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/windowing_rank.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/windowing_rank.q.out Tue Apr 9 06:33:16 2013
@@ -471,9 +471,7 @@ 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
+PREHOOK: query: select ts, dec, rnk
from
(select ts, dec,
rank() over (partition by ts) as rnk
@@ -487,9 +485,7 @@ 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
+POSTHOOK: query: select ts, dec, rnk
from
(select ts, dec,
rank() over (partition by ts) as rnk