hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From na...@apache.org
Subject svn commit: r1465903 [13/13] - in /hive/trunk/ql/src/test: queries/clientpositive/ results/clientpositive/
Date Tue, 09 Apr 2013 06:33:23 GMT
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



Mime
View raw message