hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject svn commit: r1452174 [5/5] - in /hive/branches/ptf-windowing/ql/src/test: queries/clientpositive/ results/clientpositive/
Date Mon, 04 Mar 2013 03:01:07 GMT
Copied: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/windowing.q.out (from r1452169, hive/branches/ptf-windowing/ql/src/test/results/clientpositive/ptf_general_queries.q.out)
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/windowing.q.out?p2=hive/branches/ptf-windowing/ql/src/test/results/clientpositive/windowing.q.out&p1=hive/branches/ptf-windowing/ql/src/test/results/clientpositive/ptf_general_queries.q.out&r1=1452169&r2=1452174&rev=1452174&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/ptf_general_queries.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/windowing.q.out Mon Mar  4 03:01:06 2013
@@ -2,10 +2,6 @@ PREHOOK: query: DROP TABLE part
 PREHOOK: type: DROPTABLE
 POSTHOOK: query: DROP TABLE part
 POSTHOOK: type: DROPTABLE
-PREHOOK: query: DROP TABLE flights_tiny
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE flights_tiny
-POSTHOOK: type: DROPTABLE
 PREHOOK: query: -- data setup
 CREATE TABLE part( 
     p_partkey INT,
@@ -39,84 +35,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: create table flights_tiny ( 
-ORIGIN_CITY_NAME string, 
-DEST_CITY_NAME string, 
-YEAR int, 
-MONTH int, 
-DAY_OF_MONTH int, 
-ARR_DELAY float, 
-FL_NUM string 
-)
-PREHOOK: type: CREATETABLE
-POSTHOOK: query: create table flights_tiny ( 
-ORIGIN_CITY_NAME string, 
-DEST_CITY_NAME string, 
-YEAR int, 
-MONTH int, 
-DAY_OF_MONTH int, 
-ARR_DELAY float, 
-FL_NUM string 
-)
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: default@flights_tiny
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/flights_tiny.txt' OVERWRITE INTO TABLE flights_tiny
-PREHOOK: type: LOAD
-PREHOOK: Output: default@flights_tiny
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/flights_tiny.txt' OVERWRITE INTO TABLE flights_tiny
-POSTHOOK: type: LOAD
-POSTHOOK: Output: default@flights_tiny
-PREHOOK: query: --1. test1
-select p_mfgr, p_name, p_size,
-rank() as r,
-dense_rank() as dr,
-sum(p_retailprice) as s1 over (partition by p_mfgr order by p_name rows between unbounded preceding and current row)
-from noop(on part 
-  partition by p_mfgr
-  order by p_name
-  )
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: --1. test1
-select p_mfgr, p_name, p_size,
-rank() as r,
-dense_rank() as dr,
-sum(p_retailprice) as s1 over (partition by p_mfgr order by p_name rows between unbounded preceding and current row)
-from noop(on part 
-  partition by p_mfgr
-  order by p_name
-  )
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part
-#### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	2	1	1	1173.15
-Manufacturer#1	almond antique burnished rose metallic	2	1	1	2346.3
-Manufacturer#1	almond antique chartreuse lavender yellow	34	3	2	4100.06
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	3	5702.650000000001
-Manufacturer#1	almond aquamarine burnished black steel	28	5	4	7117.070000000001
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	5	8749.730000000001
-Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	1690.68
-Manufacturer#2	almond antique violet turquoise frosted	40	2	2	3491.38
-Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	5523.360000000001
-Manufacturer#2	almond aquamarine rose maroon antique	25	4	4	7222.02
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	5	5	8923.62
-Manufacturer#3	almond antique chartreuse khaki white	17	1	1	1671.68
-Manufacturer#3	almond antique forest lavender goldenrod	14	2	2	2861.95
-Manufacturer#3	almond antique metallic orange dim	19	3	3	4272.34
-Manufacturer#3	almond antique misty red olive	1	4	4	6195.32
-Manufacturer#3	almond antique olive coral navajo	45	5	5	7532.61
-Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	1620.67
-Manufacturer#4	almond antique violet mint lemon	39	2	2	2996.09
-Manufacturer#4	almond aquamarine floral ivory bisque	27	3	3	4202.35
-Manufacturer#4	almond aquamarine yellow dodger mint	7	4	4	6047.27
-Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	7337.620000000001
-Manufacturer#5	almond antique blue firebrick mint	31	1	1	1789.69
-Manufacturer#5	almond antique medium spring khaki	6	2	2	3401.3500000000004
-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. test1NoPTF
+PREHOOK: query: -- 1. testWindowing
 select p_mfgr, p_name, p_size,
 rank() as r,
 dense_rank() as dr,
@@ -127,7 +46,7 @@ sort by p_name
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: -- 2. test1NoPTF
+POSTHOOK: query: -- 1. testWindowing
 select p_mfgr, p_name, p_size,
 rank() as r,
 dense_rank() as dr,
@@ -164,247 +83,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: --3. testLeadLag
-select p_mfgr, p_name,
-rank() as r,
-dense_rank() as dr,
-p_retailprice, sum(p_retailprice) as s1 over (partition by p_mfgr order by p_name rows between unbounded preceding and current row),
-p_size, p_size - lag(p_size,1) as deltaSz
-from noop(on part
-partition by p_mfgr
-order by p_name 
-)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: --3. testLeadLag
-select p_mfgr, p_name,
-rank() as r,
-dense_rank() as dr,
-p_retailprice, sum(p_retailprice) as s1 over (partition by p_mfgr order by p_name rows between unbounded preceding and current row),
-p_size, p_size - lag(p_size,1) as deltaSz
-from noop(on part
-partition by p_mfgr
-order by p_name 
-)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part
-#### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	1	1	1173.15	1173.15	2	0
-Manufacturer#1	almond antique burnished rose metallic	1	1	1173.15	2346.3	2	0
-Manufacturer#1	almond antique chartreuse lavender yellow	3	2	1753.76	4100.06	34	32
-Manufacturer#1	almond antique salmon chartreuse burlywood	4	3	1602.59	5702.650000000001	6	-28
-Manufacturer#1	almond aquamarine burnished black steel	5	4	1414.42	7117.070000000001	28	22
-Manufacturer#1	almond aquamarine pink moccasin thistle	6	5	1632.66	8749.730000000001	42	14
-Manufacturer#2	almond antique violet chocolate turquoise	1	1	1690.68	1690.68	14	0
-Manufacturer#2	almond antique violet turquoise frosted	2	2	1800.7	3491.38	40	26
-Manufacturer#2	almond aquamarine midnight light salmon	3	3	2031.98	5523.360000000001	2	-38
-Manufacturer#2	almond aquamarine rose maroon antique	4	4	1698.66	7222.02	25	23
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	5	5	1701.6	8923.62	18	-7
-Manufacturer#3	almond antique chartreuse khaki white	1	1	1671.68	1671.68	17	0
-Manufacturer#3	almond antique forest lavender goldenrod	2	2	1190.27	2861.95	14	-3
-Manufacturer#3	almond antique metallic orange dim	3	3	1410.39	4272.34	19	5
-Manufacturer#3	almond antique misty red olive	4	4	1922.98	6195.32	1	-18
-Manufacturer#3	almond antique olive coral navajo	5	5	1337.29	7532.61	45	44
-Manufacturer#4	almond antique gainsboro frosted violet	1	1	1620.67	1620.67	10	0
-Manufacturer#4	almond antique violet mint lemon	2	2	1375.42	2996.09	39	29
-Manufacturer#4	almond aquamarine floral ivory bisque	3	3	1206.26	4202.35	27	-12
-Manufacturer#4	almond aquamarine yellow dodger mint	4	4	1844.92	6047.27	7	-20
-Manufacturer#4	almond azure aquamarine papaya violet	5	5	1290.35	7337.620000000001	12	5
-Manufacturer#5	almond antique blue firebrick mint	1	1	1789.69	1789.69	31	0
-Manufacturer#5	almond antique medium spring khaki	2	2	1611.66	3401.3500000000004	6	-25
-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: -- 4. testLeadLagNoPTF
-select p_mfgr, p_name,
-rank() as r,
-dense_rank() as dr,
-p_retailprice, sum(p_retailprice) as s1 over (rows between unbounded preceding and current row),
-p_size, p_size - lag(p_size,1) as deltaSz
-from part
-distribute by p_mfgr
-sort by p_name
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 4. testLeadLagNoPTF
-select p_mfgr, p_name,
-rank() as r,
-dense_rank() as dr,
-p_retailprice, sum(p_retailprice) as s1 over (rows between unbounded preceding and current row),
-p_size, p_size - lag(p_size,1) as deltaSz
-from part
-distribute by p_mfgr
-sort by p_name
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part
-#### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	1	1	1173.15	1173.15	2	0
-Manufacturer#1	almond antique burnished rose metallic	1	1	1173.15	2346.3	2	0
-Manufacturer#1	almond antique chartreuse lavender yellow	3	2	1753.76	4100.06	34	32
-Manufacturer#1	almond antique salmon chartreuse burlywood	4	3	1602.59	5702.650000000001	6	-28
-Manufacturer#1	almond aquamarine burnished black steel	5	4	1414.42	7117.070000000001	28	22
-Manufacturer#1	almond aquamarine pink moccasin thistle	6	5	1632.66	8749.730000000001	42	14
-Manufacturer#2	almond antique violet chocolate turquoise	1	1	1690.68	1690.68	14	0
-Manufacturer#2	almond antique violet turquoise frosted	2	2	1800.7	3491.38	40	26
-Manufacturer#2	almond aquamarine midnight light salmon	3	3	2031.98	5523.360000000001	2	-38
-Manufacturer#2	almond aquamarine rose maroon antique	4	4	1698.66	7222.02	25	23
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	5	5	1701.6	8923.62	18	-7
-Manufacturer#3	almond antique chartreuse khaki white	1	1	1671.68	1671.68	17	0
-Manufacturer#3	almond antique forest lavender goldenrod	2	2	1190.27	2861.95	14	-3
-Manufacturer#3	almond antique metallic orange dim	3	3	1410.39	4272.34	19	5
-Manufacturer#3	almond antique misty red olive	4	4	1922.98	6195.32	1	-18
-Manufacturer#3	almond antique olive coral navajo	5	5	1337.29	7532.61	45	44
-Manufacturer#4	almond antique gainsboro frosted violet	1	1	1620.67	1620.67	10	0
-Manufacturer#4	almond antique violet mint lemon	2	2	1375.42	2996.09	39	29
-Manufacturer#4	almond aquamarine floral ivory bisque	3	3	1206.26	4202.35	27	-12
-Manufacturer#4	almond aquamarine yellow dodger mint	4	4	1844.92	6047.27	7	-20
-Manufacturer#4	almond azure aquamarine papaya violet	5	5	1290.35	7337.620000000001	12	5
-Manufacturer#5	almond antique blue firebrick mint	1	1	1789.69	1789.69	31	0
-Manufacturer#5	almond antique medium spring khaki	2	2	1611.66	3401.3500000000004	6	-25
-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: -- 5. testLeadLagNoPTFNoWindowing
-select p_mfgr, p_name, p_size
-from part
-distribute by p_mfgr
-sort by p_name
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 5. testLeadLagNoPTFNoWindowing
-select p_mfgr, p_name, p_size
-from part
-distribute by p_mfgr
-sort by p_name
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part
-#### A masked pattern was here ####
-Manufacturer#5	almond antique blue firebrick mint	31
-Manufacturer#1	almond antique burnished rose metallic	2
-Manufacturer#1	almond antique burnished rose metallic	2
-Manufacturer#3	almond antique chartreuse khaki white	17
-Manufacturer#1	almond antique chartreuse lavender yellow	34
-Manufacturer#3	almond antique forest lavender goldenrod	14
-Manufacturer#4	almond antique gainsboro frosted violet	10
-Manufacturer#5	almond antique medium spring khaki	6
-Manufacturer#3	almond antique metallic orange dim	19
-Manufacturer#3	almond antique misty red olive	1
-Manufacturer#3	almond antique olive coral navajo	45
-Manufacturer#1	almond antique salmon chartreuse burlywood	6
-Manufacturer#5	almond antique sky peru orange	2
-Manufacturer#2	almond antique violet chocolate turquoise	14
-Manufacturer#4	almond antique violet mint lemon	39
-Manufacturer#2	almond antique violet turquoise frosted	40
-Manufacturer#1	almond aquamarine burnished black steel	28
-Manufacturer#5	almond aquamarine dodger light gainsboro	46
-Manufacturer#4	almond aquamarine floral ivory bisque	27
-Manufacturer#2	almond aquamarine midnight light salmon	2
-Manufacturer#1	almond aquamarine pink moccasin thistle	42
-Manufacturer#2	almond aquamarine rose maroon antique	25
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18
-Manufacturer#4	almond aquamarine yellow dodger mint	7
-Manufacturer#4	almond azure aquamarine papaya violet	12
-Manufacturer#5	almond azure blanched chiffon midnight	23
-PREHOOK: query: -- 6. testJoinWithLeadLag
-select p1.p_mfgr, p1.p_name,
-p1.p_size, p1.p_size - lag(p1.p_size,1) as deltaSz
-from part p1 join part p2 on p1.p_partkey = p2.p_partkey
-distribute by p1.p_mfgr
-sort by p1.p_name
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 6. testJoinWithLeadLag
-select p1.p_mfgr, p1.p_name,
-p1.p_size, p1.p_size - lag(p1.p_size,1) as deltaSz
-from part p1 join part p2 on p1.p_partkey = p2.p_partkey
-distribute by p1.p_mfgr
-sort by p1.p_name
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part
-#### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	2	0
-Manufacturer#1	almond antique burnished rose metallic	2	0
-Manufacturer#1	almond antique burnished rose metallic	2	0
-Manufacturer#1	almond antique burnished rose metallic	2	0
-Manufacturer#1	almond antique chartreuse lavender yellow	34	32
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	-28
-Manufacturer#1	almond aquamarine burnished black steel	28	22
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	14
-Manufacturer#2	almond antique violet chocolate turquoise	14	0
-Manufacturer#2	almond antique violet turquoise frosted	40	26
-Manufacturer#2	almond aquamarine midnight light salmon	2	-38
-Manufacturer#2	almond aquamarine rose maroon antique	25	23
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	-7
-Manufacturer#3	almond antique chartreuse khaki white	17	0
-Manufacturer#3	almond antique forest lavender goldenrod	14	-3
-Manufacturer#3	almond antique metallic orange dim	19	5
-Manufacturer#3	almond antique misty red olive	1	-18
-Manufacturer#3	almond antique olive coral navajo	45	44
-Manufacturer#4	almond antique gainsboro frosted violet	10	0
-Manufacturer#4	almond antique violet mint lemon	39	29
-Manufacturer#4	almond aquamarine floral ivory bisque	27	-12
-Manufacturer#4	almond aquamarine yellow dodger mint	7	-20
-Manufacturer#4	almond azure aquamarine papaya violet	12	5
-Manufacturer#5	almond antique blue firebrick mint	31	0
-Manufacturer#5	almond antique medium spring khaki	6	-25
-Manufacturer#5	almond antique sky peru orange	2	-4
-Manufacturer#5	almond aquamarine dodger light gainsboro	46	44
-Manufacturer#5	almond azure blanched chiffon midnight	23	-23
-PREHOOK: query: -- 7. testJoinWithNoop
-select p_mfgr, p_name,
-p_size, p_size - lag(p_size,1) as deltaSz
-from noop (on (select p1.* from part p1 join part p2 on p1.p_partkey = p2.p_partkey) j
-distribute by j.p_mfgr
-sort by j.p_name)
-distribute by p_mfgr
-sort by p_name
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 7. testJoinWithNoop
-select p_mfgr, p_name,
-p_size, p_size - lag(p_size,1) as deltaSz
-from noop (on (select p1.* from part p1 join part p2 on p1.p_partkey = p2.p_partkey) j
-distribute by j.p_mfgr
-sort by j.p_name)
-distribute by p_mfgr
-sort by p_name
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part
-#### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	2	0
-Manufacturer#1	almond antique burnished rose metallic	2	0
-Manufacturer#1	almond antique burnished rose metallic	2	0
-Manufacturer#1	almond antique burnished rose metallic	2	0
-Manufacturer#1	almond antique chartreuse lavender yellow	34	32
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	-28
-Manufacturer#1	almond aquamarine burnished black steel	28	22
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	14
-Manufacturer#2	almond antique violet chocolate turquoise	14	0
-Manufacturer#2	almond antique violet turquoise frosted	40	26
-Manufacturer#2	almond aquamarine midnight light salmon	2	-38
-Manufacturer#2	almond aquamarine rose maroon antique	25	23
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	-7
-Manufacturer#3	almond antique chartreuse khaki white	17	0
-Manufacturer#3	almond antique forest lavender goldenrod	14	-3
-Manufacturer#3	almond antique metallic orange dim	19	5
-Manufacturer#3	almond antique misty red olive	1	-18
-Manufacturer#3	almond antique olive coral navajo	45	44
-Manufacturer#4	almond antique gainsboro frosted violet	10	0
-Manufacturer#4	almond antique violet mint lemon	39	29
-Manufacturer#4	almond aquamarine floral ivory bisque	27	-12
-Manufacturer#4	almond aquamarine yellow dodger mint	7	-20
-Manufacturer#4	almond azure aquamarine papaya violet	12	5
-Manufacturer#5	almond antique blue firebrick mint	31	0
-Manufacturer#5	almond antique medium spring khaki	6	-25
-Manufacturer#5	almond antique sky peru orange	2	-4
-Manufacturer#5	almond aquamarine dodger light gainsboro	46	44
-Manufacturer#5	almond azure blanched chiffon midnight	23	-23
-PREHOOK: query: -- 8. testGroupByWithSWQ
+PREHOOK: query: -- 2. testGroupByWithPartitioning
 select p_mfgr, p_name, p_size, min(p_retailprice),
 rank() as r,
 dense_rank() as dr,
@@ -416,7 +95,7 @@ sort by p_name
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: -- 8. testGroupByWithSWQ
+POSTHOOK: query: -- 2. testGroupByWithPartitioning
 select p_mfgr, p_name, p_size, min(p_retailprice),
 rank() as r,
 dense_rank() as dr,
@@ -453,7 +132,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: -- 9. testGroupByHavingWithSWQ
+PREHOOK: query: -- 3. testGroupByHavingWithSWQ
 select p_mfgr, p_name, p_size, min(p_retailprice),
 rank() as r,
 dense_rank() as dr,
@@ -466,7 +145,7 @@ sort by p_name
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: -- 9. testGroupByHavingWithSWQ
+POSTHOOK: query: -- 3. testGroupByHavingWithSWQ
 select p_mfgr, p_name, p_size, min(p_retailprice),
 rank() as r,
 dense_rank() as dr,
@@ -504,213 +183,8 @@ 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: -- 10. testOnlyPTF
-select p_mfgr, p_name, p_size
-from noop(on part
-partition by p_mfgr
-order by p_name)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 10. testOnlyPTF
-select p_mfgr, p_name, p_size
-from noop(on part
-partition by p_mfgr
-order by p_name)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part
-#### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	2
-Manufacturer#1	almond antique burnished rose metallic	2
-Manufacturer#1	almond antique chartreuse lavender yellow	34
-Manufacturer#1	almond antique salmon chartreuse burlywood	6
-Manufacturer#1	almond aquamarine burnished black steel	28
-Manufacturer#1	almond aquamarine pink moccasin thistle	42
-Manufacturer#2	almond antique violet chocolate turquoise	14
-Manufacturer#2	almond antique violet turquoise frosted	40
-Manufacturer#2	almond aquamarine midnight light salmon	2
-Manufacturer#2	almond aquamarine rose maroon antique	25
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18
-Manufacturer#3	almond antique chartreuse khaki white	17
-Manufacturer#3	almond antique forest lavender goldenrod	14
-Manufacturer#3	almond antique metallic orange dim	19
-Manufacturer#3	almond antique misty red olive	1
-Manufacturer#3	almond antique olive coral navajo	45
-Manufacturer#4	almond antique gainsboro frosted violet	10
-Manufacturer#4	almond antique violet mint lemon	39
-Manufacturer#4	almond aquamarine floral ivory bisque	27
-Manufacturer#4	almond aquamarine yellow dodger mint	7
-Manufacturer#4	almond azure aquamarine papaya violet	12
-Manufacturer#5	almond antique blue firebrick mint	31
-Manufacturer#5	almond antique medium spring khaki	6
-Manufacturer#5	almond antique sky peru orange	2
-Manufacturer#5	almond aquamarine dodger light gainsboro	46
-Manufacturer#5	almond azure blanched chiffon midnight	23
-PREHOOK: query: -- 11. testAlias
-select p_mfgr, p_name, p_size,
-rank() as r,
-dense_rank() as dr,
-sum(p_retailprice) as s1 over (partition by p_mfgr order by p_name rows between unbounded preceding and current row)
-from noop(on part 
-  partition by p_mfgr
-  order by p_name
-  ) abc
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 11. testAlias
-select p_mfgr, p_name, p_size,
-rank() as r,
-dense_rank() as dr,
-sum(p_retailprice) as s1 over (partition by p_mfgr order by p_name rows between unbounded preceding and current row)
-from noop(on part 
-  partition by p_mfgr
-  order by p_name
-  ) abc
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part
-#### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	2	1	1	1173.15
-Manufacturer#1	almond antique burnished rose metallic	2	1	1	2346.3
-Manufacturer#1	almond antique chartreuse lavender yellow	34	3	2	4100.06
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	3	5702.650000000001
-Manufacturer#1	almond aquamarine burnished black steel	28	5	4	7117.070000000001
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	5	8749.730000000001
-Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	1690.68
-Manufacturer#2	almond antique violet turquoise frosted	40	2	2	3491.38
-Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	5523.360000000001
-Manufacturer#2	almond aquamarine rose maroon antique	25	4	4	7222.02
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	5	5	8923.62
-Manufacturer#3	almond antique chartreuse khaki white	17	1	1	1671.68
-Manufacturer#3	almond antique forest lavender goldenrod	14	2	2	2861.95
-Manufacturer#3	almond antique metallic orange dim	19	3	3	4272.34
-Manufacturer#3	almond antique misty red olive	1	4	4	6195.32
-Manufacturer#3	almond antique olive coral navajo	45	5	5	7532.61
-Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	1620.67
-Manufacturer#4	almond antique violet mint lemon	39	2	2	2996.09
-Manufacturer#4	almond aquamarine floral ivory bisque	27	3	3	4202.35
-Manufacturer#4	almond aquamarine yellow dodger mint	7	4	4	6047.27
-Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	7337.620000000001
-Manufacturer#5	almond antique blue firebrick mint	31	1	1	1789.69
-Manufacturer#5	almond antique medium spring khaki	6	2	2	3401.3500000000004
-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: -- 12. testSWQAndPTFAndWhere
-select p_mfgr, p_name, p_size, 
-rank() as r, 
-dense_rank() as dr, 
-p_size, p_size - lag(p_size,1) as deltaSz 
-from noop(on part 
-          partition by p_mfgr 
-          order by p_name 
-          ) 
-having p_size > 0 
-distribute by p_mfgr 
-sort by p_name
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 12. testSWQAndPTFAndWhere
-select p_mfgr, p_name, p_size, 
-rank() as r, 
-dense_rank() as dr, 
-p_size, p_size - lag(p_size,1) as deltaSz 
-from noop(on part 
-          partition by p_mfgr 
-          order by p_name 
-          ) 
-having p_size > 0 
-distribute by p_mfgr 
-sort by p_name
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part
-#### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	2	1	1	2	0
-Manufacturer#1	almond antique burnished rose metallic	2	1	1	2	0
-Manufacturer#1	almond antique chartreuse lavender yellow	34	3	2	34	32
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	3	6	-28
-Manufacturer#1	almond aquamarine burnished black steel	28	5	4	28	22
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	5	42	14
-Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	14	0
-Manufacturer#2	almond antique violet turquoise frosted	40	2	2	40	26
-Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	2	-38
-Manufacturer#2	almond aquamarine rose maroon antique	25	4	4	25	23
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	5	5	18	-7
-Manufacturer#3	almond antique chartreuse khaki white	17	1	1	17	0
-Manufacturer#3	almond antique forest lavender goldenrod	14	2	2	14	-3
-Manufacturer#3	almond antique metallic orange dim	19	3	3	19	5
-Manufacturer#3	almond antique misty red olive	1	4	4	1	-18
-Manufacturer#3	almond antique olive coral navajo	45	5	5	45	44
-Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	10	0
-Manufacturer#4	almond antique violet mint lemon	39	2	2	39	29
-Manufacturer#4	almond aquamarine floral ivory bisque	27	3	3	27	-12
-Manufacturer#4	almond aquamarine yellow dodger mint	7	4	4	7	-20
-Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	12	5
-Manufacturer#5	almond antique blue firebrick mint	31	1	1	31	0
-Manufacturer#5	almond antique medium spring khaki	6	2	2	6	-25
-Manufacturer#5	almond antique sky peru orange	2	3	3	2	-4
-Manufacturer#5	almond aquamarine dodger light gainsboro	46	4	4	46	44
-Manufacturer#5	almond azure blanched chiffon midnight	23	5	5	23	-23
-PREHOOK: query: -- 13. testSWQAndPTFAndGBy
-select p_mfgr, p_name, p_size, 
-rank() as r, 
-dense_rank() as dr, 
-p_size, p_size - lag(p_size,1) as deltaSz 
-from noop(on part 
-          partition by p_mfgr 
-          order by p_name 
-          ) 
-group by p_mfgr, p_name, p_size  
-distribute by p_mfgr 
-sort by p_name
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 13. testSWQAndPTFAndGBy
-select p_mfgr, p_name, p_size, 
-rank() as r, 
-dense_rank() as dr, 
-p_size, p_size - lag(p_size,1) as deltaSz 
-from noop(on part 
-          partition by p_mfgr 
-          order by p_name 
-          ) 
-group by p_mfgr, p_name, p_size  
-distribute by p_mfgr 
-sort by p_name
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part
-#### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	2	1	1	2	0
-Manufacturer#1	almond antique chartreuse lavender yellow	34	2	2	34	32
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	3	3	6	-28
-Manufacturer#1	almond aquamarine burnished black steel	28	4	4	28	22
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	5	5	42	14
-Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	14	0
-Manufacturer#2	almond antique violet turquoise frosted	40	2	2	40	26
-Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	2	-38
-Manufacturer#2	almond aquamarine rose maroon antique	25	4	4	25	23
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	5	5	18	-7
-Manufacturer#3	almond antique chartreuse khaki white	17	1	1	17	0
-Manufacturer#3	almond antique forest lavender goldenrod	14	2	2	14	-3
-Manufacturer#3	almond antique metallic orange dim	19	3	3	19	5
-Manufacturer#3	almond antique misty red olive	1	4	4	1	-18
-Manufacturer#3	almond antique olive coral navajo	45	5	5	45	44
-Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	10	0
-Manufacturer#4	almond antique violet mint lemon	39	2	2	39	29
-Manufacturer#4	almond aquamarine floral ivory bisque	27	3	3	27	-12
-Manufacturer#4	almond aquamarine yellow dodger mint	7	4	4	7	-20
-Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	12	5
-Manufacturer#5	almond antique blue firebrick mint	31	1	1	31	0
-Manufacturer#5	almond antique medium spring khaki	6	2	2	6	-25
-Manufacturer#5	almond antique sky peru orange	2	3	3	2	-4
-Manufacturer#5	almond aquamarine dodger light gainsboro	46	4	4	46	44
-Manufacturer#5	almond azure blanched chiffon midnight	23	5	5	23	-23
-PREHOOK: query: -- 14. testCountNoWindowing
+PREHOOK: query: -- 4. testCount
 select p_mfgr, p_name, 
-rank() as r, 
-dense_rank() as dr, 
 count(p_size) as cd 
 from part 
 distribute by p_mfgr 
@@ -718,10 +192,8 @@ sort by p_name
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: -- 14. testCountNoWindowing
+POSTHOOK: query: -- 4. testCount
 select p_mfgr, p_name, 
-rank() as r, 
-dense_rank() as dr, 
 count(p_size) as cd 
 from part 
 distribute by p_mfgr 
@@ -729,33 +201,33 @@ sort by p_name
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	1	1	6
-Manufacturer#1	almond antique burnished rose metallic	1	1	6
-Manufacturer#1	almond antique chartreuse lavender yellow	3	2	6
-Manufacturer#1	almond antique salmon chartreuse burlywood	4	3	6
-Manufacturer#1	almond aquamarine burnished black steel	5	4	6
-Manufacturer#1	almond aquamarine pink moccasin thistle	6	5	6
-Manufacturer#2	almond antique violet chocolate turquoise	1	1	5
-Manufacturer#2	almond antique violet turquoise frosted	2	2	5
-Manufacturer#2	almond aquamarine midnight light salmon	3	3	5
-Manufacturer#2	almond aquamarine rose maroon antique	4	4	5
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	5	5	5
-Manufacturer#3	almond antique chartreuse khaki white	1	1	5
-Manufacturer#3	almond antique forest lavender goldenrod	2	2	5
-Manufacturer#3	almond antique metallic orange dim	3	3	5
-Manufacturer#3	almond antique misty red olive	4	4	5
-Manufacturer#3	almond antique olive coral navajo	5	5	5
-Manufacturer#4	almond antique gainsboro frosted violet	1	1	5
-Manufacturer#4	almond antique violet mint lemon	2	2	5
-Manufacturer#4	almond aquamarine floral ivory bisque	3	3	5
-Manufacturer#4	almond aquamarine yellow dodger mint	4	4	5
-Manufacturer#4	almond azure aquamarine papaya violet	5	5	5
-Manufacturer#5	almond antique blue firebrick mint	1	1	5
-Manufacturer#5	almond antique medium spring khaki	2	2	5
-Manufacturer#5	almond antique sky peru orange	3	3	5
-Manufacturer#5	almond aquamarine dodger light gainsboro	4	4	5
-Manufacturer#5	almond azure blanched chiffon midnight	5	5	5
-PREHOOK: query: -- 15. testCountWithWindowing
+Manufacturer#1	almond antique burnished rose metallic	6
+Manufacturer#1	almond antique burnished rose metallic	6
+Manufacturer#1	almond antique chartreuse lavender yellow	6
+Manufacturer#1	almond antique salmon chartreuse burlywood	6
+Manufacturer#1	almond aquamarine burnished black steel	6
+Manufacturer#1	almond aquamarine pink moccasin thistle	6
+Manufacturer#2	almond antique violet chocolate turquoise	5
+Manufacturer#2	almond antique violet turquoise frosted	5
+Manufacturer#2	almond aquamarine midnight light salmon	5
+Manufacturer#2	almond aquamarine rose maroon antique	5
+Manufacturer#2	almond aquamarine sandy cyan gainsboro	5
+Manufacturer#3	almond antique chartreuse khaki white	5
+Manufacturer#3	almond antique forest lavender goldenrod	5
+Manufacturer#3	almond antique metallic orange dim	5
+Manufacturer#3	almond antique misty red olive	5
+Manufacturer#3	almond antique olive coral navajo	5
+Manufacturer#4	almond antique gainsboro frosted violet	5
+Manufacturer#4	almond antique violet mint lemon	5
+Manufacturer#4	almond aquamarine floral ivory bisque	5
+Manufacturer#4	almond aquamarine yellow dodger mint	5
+Manufacturer#4	almond azure aquamarine papaya violet	5
+Manufacturer#5	almond antique blue firebrick mint	5
+Manufacturer#5	almond antique medium spring khaki	5
+Manufacturer#5	almond antique sky peru orange	5
+Manufacturer#5	almond aquamarine dodger light gainsboro	5
+Manufacturer#5	almond azure blanched chiffon midnight	5
+PREHOOK: query: -- 5. testCountWithWindowingUDAF
 select p_mfgr, p_name, 
 rank() as r, 
 dense_rank() as dr, 
@@ -768,7 +240,7 @@ sort by p_name
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: -- 15. testCountWithWindowing
+POSTHOOK: query: -- 5. testCountWithWindowingUDAF
 select p_mfgr, p_name, 
 rank() as r, 
 dense_rank() as dr, 
@@ -807,7 +279,7 @@ Manufacturer#5	almond antique medium spr
 Manufacturer#5	almond antique sky peru orange	3	3	5	1788.73	5190.08	2	-4
 Manufacturer#5	almond aquamarine dodger light gainsboro	4	4	5	1018.1	6208.18	46	44
 Manufacturer#5	almond azure blanched chiffon midnight	5	5	5	1464.48	7672.66	23	-23
-PREHOOK: query: -- 16. testCountInSubQ
+PREHOOK: query: -- 6. testCountInSubQ
 select sub1.r, sub1.dr, sub1.cd, sub1.s1, sub1.deltaSz 
 from (select p_mfgr, p_name, 
 rank() as r, 
@@ -822,7 +294,7 @@ sort by p_name
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: -- 16. testCountInSubQ
+POSTHOOK: query: -- 6. testCountInSubQ
 select sub1.r, sub1.dr, sub1.cd, sub1.s1, sub1.deltaSz 
 from (select p_mfgr, p_name, 
 rank() as r, 
@@ -863,104 +335,12 @@ POSTHOOK: Input: default@part
 3	3	5	5190.08	-4
 4	4	5	6208.18	44
 5	5	5	7672.66	-23
-PREHOOK: query: -- 17. testJoin
-select abc.* 
-from noop(on part 
-partition by p_mfgr 
-order by p_name 
-) abc join part p1 on abc.p_partkey = p1.p_partkey
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 17. testJoin
-select abc.* 
-from noop(on part 
-partition by p_mfgr 
-order by p_name 
-) abc join part p1 on abc.p_partkey = p1.p_partkey
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part
-#### A masked pattern was here ####
-15103	almond aquamarine dodger light gainsboro	Manufacturer#5	Brand#53	ECONOMY BURNISHED STEEL	46	LG PACK	1018.1	packages hinder carefu
-17273	almond antique forest lavender goldenrod	Manufacturer#3	Brand#35	PROMO ANODIZED TIN	14	JUMBO CASE	1190.27	along the
-17927	almond aquamarine yellow dodger mint	Manufacturer#4	Brand#41	ECONOMY BRUSHED COPPER	7	SM PKG	1844.92	ites. eve
-33357	almond azure aquamarine papaya violet	Manufacturer#4	Brand#41	STANDARD ANODIZED TIN	12	WRAP CASE	1290.35	reful
-40982	almond antique misty red olive	Manufacturer#3	Brand#32	ECONOMY PLATED COPPER	1	LG PKG	1922.98	c foxes can s
-42669	almond antique medium spring khaki	Manufacturer#5	Brand#51	STANDARD BURNISHED TIN	6	MED CAN	1611.66	sits haggl
-45261	almond aquamarine floral ivory bisque	Manufacturer#4	Brand#42	SMALL PLATED STEEL	27	WRAP CASE	1206.26	careful
-48427	almond antique violet mint lemon	Manufacturer#4	Brand#42	PROMO POLISHED STEEL	39	SM CASE	1375.42	hely ironic i
-49671	almond antique gainsboro frosted violet	Manufacturer#4	Brand#41	SMALL BRUSHED BRASS	10	SM BOX	1620.67	ccounts run quick
-65667	almond aquamarine pink moccasin thistle	Manufacturer#1	Brand#12	LARGE BURNISHED STEEL	42	JUMBO CASE	1632.66	e across the expr
-78486	almond azure blanched chiffon midnight	Manufacturer#5	Brand#52	LARGE BRUSHED BRASS	23	MED BAG	1464.48	hely blith
-85768	almond antique chartreuse lavender yellow	Manufacturer#1	Brand#12	LARGE BRUSHED STEEL	34	SM BAG	1753.76	refull
-86428	almond aquamarine burnished black steel	Manufacturer#1	Brand#12	STANDARD ANODIZED STEEL	28	WRAP BAG	1414.42	arefully 
-90681	almond antique chartreuse khaki white	Manufacturer#3	Brand#31	MEDIUM BURNISHED TIN	17	SM CASE	1671.68	are slyly after the sl
-105685	almond antique violet chocolate turquoise	Manufacturer#2	Brand#22	MEDIUM ANODIZED COPPER	14	MED CAN	1690.68	ly pending requ
-110592	almond antique salmon chartreuse burlywood	Manufacturer#1	Brand#15	PROMO BURNISHED NICKEL	6	JUMBO PKG	1602.59	 to the furiously
-112398	almond antique metallic orange dim	Manufacturer#3	Brand#32	MEDIUM BURNISHED BRASS	19	JUMBO JAR	1410.39	ole car
-121152	almond antique burnished rose metallic	Manufacturer#1	Brand#14	PROMO PLATED TIN	2	JUMBO BOX	1173.15	e pinto beans h
-121152	almond antique burnished rose metallic	Manufacturer#1	Brand#14	PROMO PLATED TIN	2	JUMBO BOX	1173.15	e pinto beans h
-121152	almond antique burnished rose metallic	Manufacturer#1	Brand#14	PROMO PLATED TIN	2	JUMBO BOX	1173.15	e pinto beans h
-121152	almond antique burnished rose metallic	Manufacturer#1	Brand#14	PROMO PLATED TIN	2	JUMBO BOX	1173.15	e pinto beans h
-132666	almond aquamarine rose maroon antique	Manufacturer#2	Brand#24	SMALL POLISHED NICKEL	25	MED BOX	1698.66	even 
-144293	almond antique olive coral navajo	Manufacturer#3	Brand#34	STANDARD POLISHED STEEL	45	JUMBO CAN	1337.29	ag furiously about 
-146985	almond aquamarine midnight light salmon	Manufacturer#2	Brand#23	MEDIUM BURNISHED COPPER	2	SM CASE	2031.98	s cajole caref
-155733	almond antique sky peru orange	Manufacturer#5	Brand#53	SMALL PLATED BRASS	2	WRAP DRUM	1788.73	furiously. bra
-191709	almond antique violet turquoise frosted	Manufacturer#2	Brand#22	ECONOMY POLISHED STEEL	40	MED BOX	1800.7	 haggle
-192697	almond antique blue firebrick mint	Manufacturer#5	Brand#52	MEDIUM BURNISHED TIN	31	LG DRUM	1789.69	ickly ir
-195606	almond aquamarine sandy cyan gainsboro	Manufacturer#2	Brand#25	STANDARD PLATED TIN	18	SM PKG	1701.6	ic de
-PREHOOK: query: -- 18. testJoinRight
-select abc.* 
-from part p1 join noop(on part 
-partition by p_mfgr 
-order by p_name 
-) abc on abc.p_partkey = p1.p_partkey
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 18. testJoinRight
-select abc.* 
-from part p1 join noop(on part 
-partition by p_mfgr 
-order by p_name 
-) abc on abc.p_partkey = p1.p_partkey
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part
-#### A masked pattern was here ####
-15103	almond aquamarine dodger light gainsboro	Manufacturer#5	Brand#53	ECONOMY BURNISHED STEEL	46	LG PACK	1018.1	packages hinder carefu
-17273	almond antique forest lavender goldenrod	Manufacturer#3	Brand#35	PROMO ANODIZED TIN	14	JUMBO CASE	1190.27	along the
-17927	almond aquamarine yellow dodger mint	Manufacturer#4	Brand#41	ECONOMY BRUSHED COPPER	7	SM PKG	1844.92	ites. eve
-33357	almond azure aquamarine papaya violet	Manufacturer#4	Brand#41	STANDARD ANODIZED TIN	12	WRAP CASE	1290.35	reful
-40982	almond antique misty red olive	Manufacturer#3	Brand#32	ECONOMY PLATED COPPER	1	LG PKG	1922.98	c foxes can s
-42669	almond antique medium spring khaki	Manufacturer#5	Brand#51	STANDARD BURNISHED TIN	6	MED CAN	1611.66	sits haggl
-45261	almond aquamarine floral ivory bisque	Manufacturer#4	Brand#42	SMALL PLATED STEEL	27	WRAP CASE	1206.26	careful
-48427	almond antique violet mint lemon	Manufacturer#4	Brand#42	PROMO POLISHED STEEL	39	SM CASE	1375.42	hely ironic i
-49671	almond antique gainsboro frosted violet	Manufacturer#4	Brand#41	SMALL BRUSHED BRASS	10	SM BOX	1620.67	ccounts run quick
-65667	almond aquamarine pink moccasin thistle	Manufacturer#1	Brand#12	LARGE BURNISHED STEEL	42	JUMBO CASE	1632.66	e across the expr
-78486	almond azure blanched chiffon midnight	Manufacturer#5	Brand#52	LARGE BRUSHED BRASS	23	MED BAG	1464.48	hely blith
-85768	almond antique chartreuse lavender yellow	Manufacturer#1	Brand#12	LARGE BRUSHED STEEL	34	SM BAG	1753.76	refull
-86428	almond aquamarine burnished black steel	Manufacturer#1	Brand#12	STANDARD ANODIZED STEEL	28	WRAP BAG	1414.42	arefully 
-90681	almond antique chartreuse khaki white	Manufacturer#3	Brand#31	MEDIUM BURNISHED TIN	17	SM CASE	1671.68	are slyly after the sl
-105685	almond antique violet chocolate turquoise	Manufacturer#2	Brand#22	MEDIUM ANODIZED COPPER	14	MED CAN	1690.68	ly pending requ
-110592	almond antique salmon chartreuse burlywood	Manufacturer#1	Brand#15	PROMO BURNISHED NICKEL	6	JUMBO PKG	1602.59	 to the furiously
-112398	almond antique metallic orange dim	Manufacturer#3	Brand#32	MEDIUM BURNISHED BRASS	19	JUMBO JAR	1410.39	ole car
-121152	almond antique burnished rose metallic	Manufacturer#1	Brand#14	PROMO PLATED TIN	2	JUMBO BOX	1173.15	e pinto beans h
-121152	almond antique burnished rose metallic	Manufacturer#1	Brand#14	PROMO PLATED TIN	2	JUMBO BOX	1173.15	e pinto beans h
-121152	almond antique burnished rose metallic	Manufacturer#1	Brand#14	PROMO PLATED TIN	2	JUMBO BOX	1173.15	e pinto beans h
-121152	almond antique burnished rose metallic	Manufacturer#1	Brand#14	PROMO PLATED TIN	2	JUMBO BOX	1173.15	e pinto beans h
-132666	almond aquamarine rose maroon antique	Manufacturer#2	Brand#24	SMALL POLISHED NICKEL	25	MED BOX	1698.66	even 
-144293	almond antique olive coral navajo	Manufacturer#3	Brand#34	STANDARD POLISHED STEEL	45	JUMBO CAN	1337.29	ag furiously about 
-146985	almond aquamarine midnight light salmon	Manufacturer#2	Brand#23	MEDIUM BURNISHED COPPER	2	SM CASE	2031.98	s cajole caref
-155733	almond antique sky peru orange	Manufacturer#5	Brand#53	SMALL PLATED BRASS	2	WRAP DRUM	1788.73	furiously. bra
-191709	almond antique violet turquoise frosted	Manufacturer#2	Brand#22	ECONOMY POLISHED STEEL	40	MED BOX	1800.7	 haggle
-192697	almond antique blue firebrick mint	Manufacturer#5	Brand#52	MEDIUM BURNISHED TIN	31	LG DRUM	1789.69	ickly ir
-195606	almond aquamarine sandy cyan gainsboro	Manufacturer#2	Brand#25	STANDARD PLATED TIN	18	SM PKG	1701.6	ic de
-PREHOOK: query: -- 19. testJoinWithWindowing
-select abc.p_mfgr, abc.p_name, 
-rank() as r, 
-dense_rank() as dr, 
-abc.p_retailprice, sum(abc.p_retailprice) as s1 over (rows between unbounded preceding and current row), 
-abc.p_size, abc.p_size - lag(abc.p_size,1) as deltaSz 
+PREHOOK: query: -- 7. testJoinWithWindowingAndPTF
+select abc.p_mfgr, abc.p_name, 
+rank() as r, 
+dense_rank() as dr, 
+abc.p_retailprice, sum(abc.p_retailprice) as s1 over (rows between unbounded preceding and current row), 
+abc.p_size, abc.p_size - lag(abc.p_size,1) as deltaSz 
 from noop(on part 
 partition by p_mfgr 
 order by p_name 
@@ -970,7 +350,7 @@ sort by abc.p_name
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: -- 19. testJoinWithWindowing
+POSTHOOK: query: -- 7. testJoinWithWindowingAndPTF
 select abc.p_mfgr, abc.p_name, 
 rank() as r, 
 dense_rank() as dr, 
@@ -1013,7 +393,7 @@ 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: -- 20. testMixedCaseAlias
+PREHOOK: query: -- 8. testMixedCaseAlias
 select p_mfgr, p_name, p_size, rank() as R
 from part 
 distribute by p_mfgr 
@@ -1021,7 +401,7 @@ sort by p_name, p_size desc
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: -- 20. testMixedCaseAlias
+POSTHOOK: query: -- 8. testMixedCaseAlias
 select p_mfgr, p_name, p_size, rank() as R
 from part 
 distribute by p_mfgr 
@@ -1055,99 +435,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: -- 21. testNoopWithMap
-select p_mfgr, p_name, p_size, 
-rank() as r over (partition by p_mfgr order by p_name, p_size desc)
-from noopwithmap(on part
-partition by p_mfgr
-order by p_name, p_size desc)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 21. testNoopWithMap
-select p_mfgr, p_name, p_size, 
-rank() as r over (partition by p_mfgr order by p_name, p_size desc)
-from noopwithmap(on part
-partition by p_mfgr
-order by p_name, p_size desc)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part
-#### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	2	1
-Manufacturer#1	almond antique burnished rose metallic	2	1
-Manufacturer#1	almond antique chartreuse lavender yellow	34	3
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	4
-Manufacturer#1	almond aquamarine burnished black steel	28	5
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	6
-Manufacturer#2	almond antique violet chocolate turquoise	14	1
-Manufacturer#2	almond antique violet turquoise frosted	40	2
-Manufacturer#2	almond aquamarine midnight light salmon	2	3
-Manufacturer#2	almond aquamarine rose maroon antique	25	4
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	5
-Manufacturer#3	almond antique chartreuse khaki white	17	1
-Manufacturer#3	almond antique forest lavender goldenrod	14	2
-Manufacturer#3	almond antique metallic orange dim	19	3
-Manufacturer#3	almond antique misty red olive	1	4
-Manufacturer#3	almond antique olive coral navajo	45	5
-Manufacturer#4	almond antique gainsboro frosted violet	10	1
-Manufacturer#4	almond antique violet mint lemon	39	2
-Manufacturer#4	almond aquamarine floral ivory bisque	27	3
-Manufacturer#4	almond aquamarine yellow dodger mint	7	4
-Manufacturer#4	almond azure aquamarine papaya violet	12	5
-Manufacturer#5	almond antique blue firebrick mint	31	1
-Manufacturer#5	almond antique medium spring khaki	6	2
-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: -- 22. testNoopWithMapWithWindowing 
-select p_mfgr, p_name, p_size,
-rank() as r,
-dense_rank() as dr,
-sum(p_retailprice) as s1 over (partition by p_mfgr order by p_name rows between unbounded preceding and current row)
-from noopwithmap(on part 
-  partition by p_mfgr
-  order by p_name)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 22. testNoopWithMapWithWindowing 
-select p_mfgr, p_name, p_size,
-rank() as r,
-dense_rank() as dr,
-sum(p_retailprice) as s1 over (partition by p_mfgr order by p_name rows between unbounded preceding and current row)
-from noopwithmap(on part 
-  partition by p_mfgr
-  order by p_name)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part
-#### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	2	1	1	1173.15
-Manufacturer#1	almond antique burnished rose metallic	2	1	1	2346.3
-Manufacturer#1	almond antique chartreuse lavender yellow	34	3	2	4100.06
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	3	5702.650000000001
-Manufacturer#1	almond aquamarine burnished black steel	28	5	4	7117.070000000001
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	5	8749.730000000001
-Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	1690.68
-Manufacturer#2	almond antique violet turquoise frosted	40	2	2	3491.38
-Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	5523.360000000001
-Manufacturer#2	almond aquamarine rose maroon antique	25	4	4	7222.02
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	5	5	8923.62
-Manufacturer#3	almond antique chartreuse khaki white	17	1	1	1671.68
-Manufacturer#3	almond antique forest lavender goldenrod	14	2	2	2861.95
-Manufacturer#3	almond antique metallic orange dim	19	3	3	4272.34
-Manufacturer#3	almond antique misty red olive	1	4	4	6195.32
-Manufacturer#3	almond antique olive coral navajo	45	5	5	7532.61
-Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	1620.67
-Manufacturer#4	almond antique violet mint lemon	39	2	2	2996.09
-Manufacturer#4	almond aquamarine floral ivory bisque	27	3	3	4202.35
-Manufacturer#4	almond aquamarine yellow dodger mint	7	4	4	6047.27
-Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	7337.620000000001
-Manufacturer#5	almond antique blue firebrick mint	31	1	1	1789.69
-Manufacturer#5	almond antique medium spring khaki	6	2	2	3401.3500000000004
-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: -- 23. testHavingWithWindowingNoGBY
+PREHOOK: query: -- 9. testHavingWithWindowingNoGBY
 select p_mfgr, p_name, p_size, 
 rank() as r, 
 dense_rank() as dr, 
@@ -1159,7 +447,7 @@ sort by p_name
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: -- 23. testHavingWithWindowingNoGBY
+POSTHOOK: query: -- 9. testHavingWithWindowingNoGBY
 select p_mfgr, p_name, p_size, 
 rank() as r, 
 dense_rank() as dr, 
@@ -1192,7 +480,7 @@ Manufacturer#5	almond antique blue fireb
 Manufacturer#5	almond antique medium spring khaki	6	2	2	3401.3500000000004
 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: -- 24. testHavingWithWindowingCondRankNoGBY
+PREHOOK: query: -- 10. testHavingWithWindowingCondRankNoGBY
 select p_mfgr, p_name, p_size, 
 rank() as r, 
 dense_rank() as dr, 
@@ -1204,7 +492,7 @@ sort by p_name
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: -- 24. testHavingWithWindowingCondRankNoGBY
+POSTHOOK: query: -- 10. testHavingWithWindowingCondRankNoGBY
 select p_mfgr, p_name, p_size, 
 rank() as r, 
 dense_rank() as dr, 
@@ -1231,46 +519,7 @@ Manufacturer#4	almond aquamarine floral 
 Manufacturer#5	almond antique blue firebrick mint	31	1	1	1789.69
 Manufacturer#5	almond antique medium spring khaki	6	2	2	3401.3500000000004
 Manufacturer#5	almond antique sky peru orange	2	3	3	5190.08
-PREHOOK: query: -- 25. testHavingWithWindowingPTFNoGBY
-select p_mfgr, p_name, p_size,
-rank() as r,
-dense_rank() as dr,
-sum(p_retailprice) as s1 over (partition by p_mfgr order by p_name rows between unbounded preceding and current row)
-from noop(on part
-partition by p_mfgr
-order by p_name)
-having rank() < 4
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 25. testHavingWithWindowingPTFNoGBY
-select p_mfgr, p_name, p_size,
-rank() as r,
-dense_rank() as dr,
-sum(p_retailprice) as s1 over (partition by p_mfgr order by p_name rows between unbounded preceding and current row)
-from noop(on part
-partition by p_mfgr
-order by p_name)
-having rank() < 4
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part
-#### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	2	1	1	1173.15
-Manufacturer#1	almond antique burnished rose metallic	2	1	1	2346.3
-Manufacturer#1	almond antique chartreuse lavender yellow	34	3	2	4100.06
-Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	1690.68
-Manufacturer#2	almond antique violet turquoise frosted	40	2	2	3491.38
-Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	5523.360000000001
-Manufacturer#3	almond antique chartreuse khaki white	17	1	1	1671.68
-Manufacturer#3	almond antique forest lavender goldenrod	14	2	2	2861.95
-Manufacturer#3	almond antique metallic orange dim	19	3	3	4272.34
-Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	1620.67
-Manufacturer#4	almond antique violet mint lemon	39	2	2	2996.09
-Manufacturer#4	almond aquamarine floral ivory bisque	27	3	3	4202.35
-Manufacturer#5	almond antique blue firebrick mint	31	1	1	1789.69
-Manufacturer#5	almond antique medium spring khaki	6	2	2	3401.3500000000004
-Manufacturer#5	almond antique sky peru orange	2	3	3	5190.08
-PREHOOK: query: -- 26. testFirstLast   
+PREHOOK: query: -- 11. testFirstLast   
 select  p_mfgr,p_name, p_size, 
 sum(p_size) as s2 over (rows between current row and current row), 
 first_value(p_size) as f over w1 , 
@@ -1282,7 +531,7 @@ window w1 as (rows between 2 preceding a
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: -- 26. testFirstLast   
+POSTHOOK: query: -- 11. testFirstLast   
 select  p_mfgr,p_name, p_size, 
 sum(p_size) as s2 over (rows between current row and current row), 
 first_value(p_size) as f over w1 , 
@@ -1320,7 +569,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: -- 27. testFirstLastWithWhere
+PREHOOK: query: -- 12. testFirstLastWithWhere
 select  p_mfgr,p_name, p_size, 
 rank() as r, 
 sum(p_size) as s2 over (rows between current row and current row), 
@@ -1334,7 +583,7 @@ window w1 as (rows between 2 preceding a
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: -- 27. testFirstLastWithWhere
+POSTHOOK: query: -- 12. testFirstLastWithWhere
 select  p_mfgr,p_name, p_size, 
 rank() as r, 
 sum(p_size) as s2 over (rows between current row and current row), 
@@ -1353,53 +602,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: -- 28. testSumDelta
-select  p_mfgr,p_name, p_size,   
-sum(p_size - lag(p_size,1)) as deltaSum over w1
-from part 
-distribute by p_mfgr 
-sort by p_mfgr 
-window w1 as (rows between 2 preceding and 2 following)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 28. testSumDelta
-select  p_mfgr,p_name, p_size,   
-sum(p_size - lag(p_size,1)) as deltaSum over w1
-from part 
-distribute by p_mfgr 
-sort by p_mfgr 
-window w1 as (rows between 2 preceding and 2 following)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part
-#### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	2	0
-Manufacturer#1	almond antique chartreuse lavender yellow	34	4
-Manufacturer#1	almond antique burnished rose metallic	2	26
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	8
-Manufacturer#1	almond aquamarine burnished black steel	28	40
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	36
-Manufacturer#2	almond antique violet chocolate turquoise	14	-12
-Manufacturer#2	almond antique violet turquoise frosted	40	11
-Manufacturer#2	almond aquamarine midnight light salmon	2	4
-Manufacturer#2	almond aquamarine rose maroon antique	25	-22
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	16
-Manufacturer#3	almond antique metallic orange dim	19	-5
-Manufacturer#3	almond antique chartreuse khaki white	17	-18
-Manufacturer#3	almond antique forest lavender goldenrod	14	26
-Manufacturer#3	almond antique misty red olive	1	28
-Manufacturer#3	almond antique olive coral navajo	45	31
-Manufacturer#4	almond antique gainsboro frosted violet	10	17
-Manufacturer#4	almond antique violet mint lemon	39	-3
-Manufacturer#4	almond aquamarine floral ivory bisque	27	2
-Manufacturer#4	almond aquamarine yellow dodger mint	7	-27
-Manufacturer#4	almond azure aquamarine papaya violet	12	-15
-Manufacturer#5	almond antique blue firebrick mint	31	-29
-Manufacturer#5	almond antique medium spring khaki	6	15
-Manufacturer#5	almond antique sky peru orange	2	-8
-Manufacturer#5	almond aquamarine dodger light gainsboro	46	17
-Manufacturer#5	almond azure blanched chiffon midnight	23	21
-PREHOOK: query: -- 29. testSumWindow
+PREHOOK: query: -- 13. testSumWindow
 select  p_mfgr,p_name, p_size,  
 sum(p_size) as s1 over w1, 
 sum(p_size) as s2 over (rows between current row and current row) 
@@ -1410,7 +613,7 @@ window w1 as (rows between 2 preceding a
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: -- 29. testSumWindow
+POSTHOOK: query: -- 13. testSumWindow
 select  p_mfgr,p_name, p_size,  
 sum(p_size) as s1 over w1, 
 sum(p_size) as s2 over (rows between current row and current row) 
@@ -1447,7 +650,7 @@ 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: -- 30. testNoSortClause
+PREHOOK: query: -- 14. testNoSortClause
 select  p_mfgr,p_name, p_size, 
 rank() as r, dense_rank() as dr 
 from part 
@@ -1456,7 +659,7 @@ window w1 as (rows between 2 preceding a
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: -- 30. testNoSortClause
+POSTHOOK: query: -- 14. testNoSortClause
 select  p_mfgr,p_name, p_size, 
 rank() as r, dense_rank() as dr 
 from part 
@@ -1491,7 +694,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: -- 31. testExpressions
+PREHOOK: query: -- 15. testExpressions
 select  p_mfgr,p_name, p_size,  
 rank() as r,  
 dense_rank() as dr, 
@@ -1512,7 +715,7 @@ window w1 as (rows between 2 preceding a
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: -- 31. testExpressions
+POSTHOOK: query: -- 15. testExpressions
 select  p_mfgr,p_name, p_size,  
 rank() as r,  
 dense_rank() as dr, 
@@ -1554,7 +757,7 @@ Manufacturer#5	almond antique blue fireb
 Manufacturer#5	almond antique medium spring khaki	6	2	2	0.4	0.25	1	5	21.6	16.206171663906314	1	23	31
 Manufacturer#5	almond aquamarine dodger light gainsboro	46	4	4	0.8	0.75	2	5	21.6	16.206171663906314	1	23	6
 Manufacturer#5	almond azure blanched chiffon midnight	23	5	5	1.0	1.0	3	5	21.6	16.206171663906314	1	23	2
-PREHOOK: query: -- 32. testMultipleWindows
+PREHOOK: query: -- 16. testMultipleWindows
 select  p_mfgr,p_name, p_size,  
   rank() as r, dense_rank() as dr, 
 cume_dist() as cud, 
@@ -1569,7 +772,7 @@ window w1 as (rows between 2 preceding a
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: -- 32. testMultipleWindows
+POSTHOOK: query: -- 16. testMultipleWindows
 select  p_mfgr,p_name, p_size,  
   rank() as r, dense_rank() as dr, 
 cume_dist() as cud, 
@@ -1605,113 +808,7 @@ Manufacturer#5	almond antique blue fireb
 Manufacturer#5	almond antique medium spring khaki	6	2	2	0.4	37	37	31
 Manufacturer#5	almond aquamarine dodger light gainsboro	46	4	4	0.8	85	46	6
 Manufacturer#5	almond azure blanched chiffon midnight	23	5	5	1.0	108	69	2
-PREHOOK: query: -- 33. testFunctionChain
-select p_mfgr, p_name, p_size, 
-rank() as r, 
-dense_rank() as dr, 
-sum(p_retailprice) as s1 over (partition by p_mfgr order by p_name rows between unbounded preceding and current row) 
-from noop(on noopwithmap(on noop(on part 
-partition by p_mfgr 
-order by p_mfgr, p_name
-)))
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 33. testFunctionChain
-select p_mfgr, p_name, p_size, 
-rank() as r, 
-dense_rank() as dr, 
-sum(p_retailprice) as s1 over (partition by p_mfgr order by p_name rows between unbounded preceding and current row) 
-from noop(on noopwithmap(on noop(on part 
-partition by p_mfgr 
-order by p_mfgr, p_name
-)))
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part
-#### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	2	1	1	1173.15
-Manufacturer#1	almond antique burnished rose metallic	2	1	1	2346.3
-Manufacturer#1	almond antique chartreuse lavender yellow	34	3	2	4100.06
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	3	5702.650000000001
-Manufacturer#1	almond aquamarine burnished black steel	28	5	4	7117.070000000001
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	5	8749.730000000001
-Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	1690.68
-Manufacturer#2	almond antique violet turquoise frosted	40	2	2	3491.38
-Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	5523.360000000001
-Manufacturer#2	almond aquamarine rose maroon antique	25	4	4	7222.02
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	5	5	8923.62
-Manufacturer#3	almond antique chartreuse khaki white	17	1	1	1671.68
-Manufacturer#3	almond antique forest lavender goldenrod	14	2	2	2861.95
-Manufacturer#3	almond antique metallic orange dim	19	3	3	4272.34
-Manufacturer#3	almond antique misty red olive	1	4	4	6195.32
-Manufacturer#3	almond antique olive coral navajo	45	5	5	7532.61
-Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	1620.67
-Manufacturer#4	almond antique violet mint lemon	39	2	2	2996.09
-Manufacturer#4	almond aquamarine floral ivory bisque	27	3	3	4202.35
-Manufacturer#4	almond aquamarine yellow dodger mint	7	4	4	6047.27
-Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	7337.620000000001
-Manufacturer#5	almond antique blue firebrick mint	31	1	1	1789.69
-Manufacturer#5	almond antique medium spring khaki	6	2	2	3401.3500000000004
-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: -- 34. testPTFAndWindowingInSubQ
-select p_mfgr, p_name, 
-sub1.cd, sub1.s1 
-from (select p_mfgr, p_name, 
-count(p_size) as cd, 
-p_retailprice, 
-sum(p_retailprice) as s1 over w1 
-from noop(on part 
-partition by p_mfgr 
-order by p_name) 
-window w1 as (partition by p_mfgr order by p_name rows between 2 preceding and 2 following) 
-) sub1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 34. testPTFAndWindowingInSubQ
-select p_mfgr, p_name, 
-sub1.cd, sub1.s1 
-from (select p_mfgr, p_name, 
-count(p_size) as cd, 
-p_retailprice, 
-sum(p_retailprice) as s1 over w1 
-from noop(on part 
-partition by p_mfgr 
-order by p_name) 
-window w1 as (partition by p_mfgr order by p_name rows between 2 preceding and 2 following) 
-) sub1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part
-#### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	6	4100.06
-Manufacturer#1	almond antique burnished rose metallic	6	5702.650000000001
-Manufacturer#1	almond antique chartreuse lavender yellow	6	7117.070000000001
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	7576.58
-Manufacturer#1	almond aquamarine burnished black steel	6	6403.43
-Manufacturer#1	almond aquamarine pink moccasin thistle	6	4649.67
-Manufacturer#2	almond antique violet chocolate turquoise	5	5523.360000000001
-Manufacturer#2	almond antique violet turquoise frosted	5	7222.02
-Manufacturer#2	almond aquamarine midnight light salmon	5	8923.62
-Manufacturer#2	almond aquamarine rose maroon antique	5	7232.9400000000005
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	5	5432.24
-Manufacturer#3	almond antique chartreuse khaki white	5	4272.34
-Manufacturer#3	almond antique forest lavender goldenrod	5	6195.32
-Manufacturer#3	almond antique metallic orange dim	5	7532.61
-Manufacturer#3	almond antique misty red olive	5	5860.929999999999
-Manufacturer#3	almond antique olive coral navajo	5	4670.66
-Manufacturer#4	almond antique gainsboro frosted violet	5	4202.35
-Manufacturer#4	almond antique violet mint lemon	5	6047.27
-Manufacturer#4	almond aquamarine floral ivory bisque	5	7337.620000000001
-Manufacturer#4	almond aquamarine yellow dodger mint	5	5716.950000000001
-Manufacturer#4	almond azure aquamarine papaya violet	5	4341.530000000001
-Manufacturer#5	almond antique blue firebrick mint	5	5190.08
-Manufacturer#5	almond antique medium spring khaki	5	6208.18
-Manufacturer#5	almond antique sky peru orange	5	7672.66
-Manufacturer#5	almond aquamarine dodger light gainsboro	5	5882.970000000001
-Manufacturer#5	almond azure blanched chiffon midnight	5	4271.3099999999995
-PREHOOK: query: -- 35. testCountStar
+PREHOOK: query: -- 17. testCountStar
 select  p_mfgr,p_name, p_size,
 count(*) as c, 
 count(p_size) as ca, 
@@ -1724,7 +821,7 @@ window w1 as (rows between 2 preceding a
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: -- 35. testCountStar
+POSTHOOK: query: -- 17. testCountStar
 select  p_mfgr,p_name, p_size,
 count(*) as c, 
 count(p_size) as ca, 
@@ -1758,135 +855,29 @@ Manufacturer#5	almond antique blue fireb
 Manufacturer#5	almond antique medium spring khaki	6	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: -- 36. testJoinWithWindowingWithCount
-select abc.p_mfgr, abc.p_name, 
-rank() as r, 
-dense_rank() as dr, 
-count(abc.p_name) as cd, 
-abc.p_retailprice, sum(abc.p_retailprice) as s1 over (rows between unbounded preceding and current row), 
-abc.p_size, abc.p_size - lag(abc.p_size,1) as deltaSz 
-from noop(on part 
-partition by p_mfgr 
-order by p_name 
-) abc join part p1 on abc.p_partkey = p1.p_partkey 
-distribute by abc.p_mfgr 
-sort by abc.p_name
+PREHOOK: query: -- 18. testUDAFs
+select  p_mfgr,p_name, p_size, 
+sum(p_retailprice) as s over w1, 
+min(p_retailprice) as mi over w1,
+max(p_retailprice) as ma over w1,
+avg(p_retailprice) as ag over w1
+from part
+distribute by p_mfgr
+sort by p_mfgr, p_name
+window w1 as (rows between 2 preceding and 2 following)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: -- 36. testJoinWithWindowingWithCount
-select abc.p_mfgr, abc.p_name, 
-rank() as r, 
-dense_rank() as dr, 
-count(abc.p_name) as cd, 
-abc.p_retailprice, sum(abc.p_retailprice) as s1 over (rows between unbounded preceding and current row), 
-abc.p_size, abc.p_size - lag(abc.p_size,1) as deltaSz 
-from noop(on part 
-partition by p_mfgr 
-order by p_name 
-) abc join part p1 on abc.p_partkey = p1.p_partkey 
-distribute by abc.p_mfgr 
-sort by abc.p_name
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part
-#### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	1	1	8	1173.15	1173.15	2	0
-Manufacturer#1	almond antique burnished rose metallic	1	1	8	1173.15	2346.3	2	0
-Manufacturer#1	almond antique burnished rose metallic	1	1	8	1173.15	3519.4500000000003	2	0
-Manufacturer#1	almond antique burnished rose metallic	1	1	8	1173.15	4692.6	2	0
-Manufacturer#1	almond antique chartreuse lavender yellow	5	2	8	1753.76	6446.360000000001	34	32
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	3	8	1602.59	8048.950000000001	6	-28
-Manufacturer#1	almond aquamarine burnished black steel	7	4	8	1414.42	9463.37	28	22
-Manufacturer#1	almond aquamarine pink moccasin thistle	8	5	8	1632.66	11096.03	42	14
-Manufacturer#2	almond antique violet chocolate turquoise	1	1	5	1690.68	1690.68	14	0
-Manufacturer#2	almond antique violet turquoise frosted	2	2	5	1800.7	3491.38	40	26
-Manufacturer#2	almond aquamarine midnight light salmon	3	3	5	2031.98	5523.360000000001	2	-38
-Manufacturer#2	almond aquamarine rose maroon antique	4	4	5	1698.66	7222.02	25	23
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	5	5	5	1701.6	8923.62	18	-7
-Manufacturer#3	almond antique chartreuse khaki white	1	1	5	1671.68	1671.68	17	0
-Manufacturer#3	almond antique forest lavender goldenrod	2	2	5	1190.27	2861.95	14	-3
-Manufacturer#3	almond antique metallic orange dim	3	3	5	1410.39	4272.34	19	5
-Manufacturer#3	almond antique misty red olive	4	4	5	1922.98	6195.32	1	-18
-Manufacturer#3	almond antique olive coral navajo	5	5	5	1337.29	7532.61	45	44
-Manufacturer#4	almond antique gainsboro frosted violet	1	1	5	1620.67	1620.67	10	0
-Manufacturer#4	almond antique violet mint lemon	2	2	5	1375.42	2996.09	39	29
-Manufacturer#4	almond aquamarine floral ivory bisque	3	3	5	1206.26	4202.35	27	-12
-Manufacturer#4	almond aquamarine yellow dodger mint	4	4	5	1844.92	6047.27	7	-20
-Manufacturer#4	almond azure aquamarine papaya violet	5	5	5	1290.35	7337.620000000001	12	5
-Manufacturer#5	almond antique blue firebrick mint	1	1	5	1789.69	1789.69	31	0
-Manufacturer#5	almond antique medium spring khaki	2	2	5	1611.66	3401.3500000000004	6	-25
-Manufacturer#5	almond antique sky peru orange	3	3	5	1788.73	5190.08	2	-4
-Manufacturer#5	almond aquamarine dodger light gainsboro	4	4	5	1018.1	6208.18	46	44
-Manufacturer#5	almond azure blanched chiffon midnight	5	5	5	1464.48	7672.66	23	-23
-PREHOOK: query: -- 37. testSumDelta
-select  p_mfgr,p_name, p_size,   
-sum(p_size - lag(p_size,1)) as deltaSum 
-from part 
-distribute by p_mfgr 
-sort by p_mfgr 
-window w1 as (rows between 2 preceding and 2 following)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 37. testSumDelta
-select  p_mfgr,p_name, p_size,   
-sum(p_size - lag(p_size,1)) as deltaSum 
-from part 
-distribute by p_mfgr 
-sort by p_mfgr 
-window w1 as (rows between 2 preceding and 2 following)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part
-#### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	2	40
-Manufacturer#1	almond antique chartreuse lavender yellow	34	40
-Manufacturer#1	almond antique burnished rose metallic	2	40
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	40
-Manufacturer#1	almond aquamarine burnished black steel	28	40
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	40
-Manufacturer#2	almond antique violet chocolate turquoise	14	4
-Manufacturer#2	almond antique violet turquoise frosted	40	4
-Manufacturer#2	almond aquamarine midnight light salmon	2	4
-Manufacturer#2	almond aquamarine rose maroon antique	25	4
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	4
-Manufacturer#3	almond antique metallic orange dim	19	26
-Manufacturer#3	almond antique chartreuse khaki white	17	26
-Manufacturer#3	almond antique forest lavender goldenrod	14	26
-Manufacturer#3	almond antique misty red olive	1	26
-Manufacturer#3	almond antique olive coral navajo	45	26
-Manufacturer#4	almond antique gainsboro frosted violet	10	2
-Manufacturer#4	almond antique violet mint lemon	39	2
-Manufacturer#4	almond aquamarine floral ivory bisque	27	2
-Manufacturer#4	almond aquamarine yellow dodger mint	7	2
-Manufacturer#4	almond azure aquamarine papaya violet	12	2
-Manufacturer#5	almond antique blue firebrick mint	31	-8
-Manufacturer#5	almond antique medium spring khaki	6	-8
-Manufacturer#5	almond antique sky peru orange	2	-8
-Manufacturer#5	almond aquamarine dodger light gainsboro	46	-8
-Manufacturer#5	almond azure blanched chiffon midnight	23	-8
-PREHOOK: query: -- 38. testUDAFs
-select  p_mfgr,p_name, p_size, 
-sum(p_retailprice) as s over w1, 
-min(p_retailprice) as mi over w1,
-max(p_retailprice) as ma over w1,
-avg(p_retailprice) as ag over w1
-from part
-distribute by p_mfgr
-sort by p_mfgr, p_name
-window w1 as (rows between 2 preceding and 2 following)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 38. testUDAFs
-select  p_mfgr,p_name, p_size, 
-sum(p_retailprice) as s over w1, 
-min(p_retailprice) as mi over w1,
-max(p_retailprice) as ma over w1,
-avg(p_retailprice) as ag over w1
-from part
-distribute by p_mfgr
-sort by p_mfgr, p_name
-window w1 as (rows between 2 preceding and 2 following)
+POSTHOOK: query: -- 18. testUDAFs
+select  p_mfgr,p_name, p_size, 
+sum(p_retailprice) as s over w1, 
+min(p_retailprice) as mi over w1,
+max(p_retailprice) as ma over w1,
+avg(p_retailprice) as ag over w1
+from part
+distribute by p_mfgr
+sort by p_mfgr, p_name
+window w1 as (rows between 2 preceding and 2 following)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
@@ -1916,7 +907,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: -- 39. testUDAFsWithPTFWithGBY
+PREHOOK: query: -- 19. testUDAFsWithGBY
 select  p_mfgr,p_name, p_size, p_retailprice, 
 sum(p_retailprice) as s over w1, 
 min(p_retailprice) as mi ,
@@ -1930,7 +921,7 @@ window w1 as (rows between 2 preceding a
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: -- 39. testUDAFsWithPTFWithGBY
+POSTHOOK: query: -- 19. testUDAFsWithGBY
 select  p_mfgr,p_name, p_size, p_retailprice, 
 sum(p_retailprice) as s over w1, 
 min(p_retailprice) as mi ,
@@ -1969,7 +960,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: -- 40. testSTATs
+PREHOOK: query: -- 20. testSTATs
 select  p_mfgr,p_name, p_size, 
 stddev(p_retailprice) as sdev over w1, 
 stddev_pop(p_retailprice) as sdev_pop over w1, 
@@ -1984,7 +975,7 @@ window w1 as (rows between 2 preceding a
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: -- 40. testSTATs
+POSTHOOK: query: -- 20. testSTATs
 select  p_mfgr,p_name, p_size, 
 stddev(p_retailprice) as sdev over w1, 
 stddev_pop(p_retailprice) as sdev_pop over w1, 
@@ -2025,7 +1016,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: -- 41. testDISTs
+PREHOOK: query: -- 21. testDISTs
 select  p_mfgr,p_name, p_size, 
 histogram_numeric(p_retailprice, 5) as hist over w1, 
 percentile(p_partkey, 0.5) as per over w1,
@@ -2037,7 +1028,7 @@ window w1 as (rows between 2 preceding a
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: -- 41. testDISTs
+POSTHOOK: query: -- 21. testDISTs
 select  p_mfgr,p_name, p_size, 
 histogram_numeric(p_retailprice, 5) as hist over w1, 
 percentile(p_partkey, 0.5) as per over w1,
@@ -2075,98 +1066,7 @@ 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: -- 42. testDistinctInSelectWithPTF
-select DISTINCT p_mfgr, p_name, p_size 
-from noop(on part 
-partition by p_mfgr 
-order by p_name)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 42. testDistinctInSelectWithPTF
-select DISTINCT p_mfgr, p_name, p_size 
-from noop(on part 
-partition by p_mfgr 
-order by p_name)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part
-#### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	2
-Manufacturer#1	almond antique chartreuse lavender yellow	34
-Manufacturer#1	almond antique salmon chartreuse burlywood	6
-Manufacturer#1	almond aquamarine burnished black steel	28
-Manufacturer#1	almond aquamarine pink moccasin thistle	42
-Manufacturer#2	almond antique violet chocolate turquoise	14
-Manufacturer#2	almond antique violet turquoise frosted	40
-Manufacturer#2	almond aquamarine midnight light salmon	2
-Manufacturer#2	almond aquamarine rose maroon antique	25
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18
-Manufacturer#3	almond antique chartreuse khaki white	17
-Manufacturer#3	almond antique forest lavender goldenrod	14
-Manufacturer#3	almond antique metallic orange dim	19
-Manufacturer#3	almond antique misty red olive	1
-Manufacturer#3	almond antique olive coral navajo	45
-Manufacturer#4	almond antique gainsboro frosted violet	10
-Manufacturer#4	almond antique violet mint lemon	39
-Manufacturer#4	almond aquamarine floral ivory bisque	27
-Manufacturer#4	almond aquamarine yellow dodger mint	7
-Manufacturer#4	almond azure aquamarine papaya violet	12
-Manufacturer#5	almond antique blue firebrick mint	31
-Manufacturer#5	almond antique medium spring khaki	6
-Manufacturer#5	almond antique sky peru orange	2
-Manufacturer#5	almond aquamarine dodger light gainsboro	46
-Manufacturer#5	almond azure blanched chiffon midnight	23
-PREHOOK: query: -- 43. testUDAFsNoWindowingNoPTFNoGBY
-select p_mfgr,p_name, p_retailprice,  
-sum(p_retailprice) as s,
-min(p_retailprice) as mi,
-max(p_retailprice) as ma,
-avg(p_retailprice) as av 
-from part 
-distribute by p_mfgr 
-sort by p_mfgr, p_name
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 43. testUDAFsNoWindowingNoPTFNoGBY
-select p_mfgr,p_name, p_retailprice,  
-sum(p_retailprice) as s,
-min(p_retailprice) as mi,
-max(p_retailprice) as ma,
-avg(p_retailprice) as av 
-from part 
-distribute by p_mfgr 
-sort by p_mfgr, p_name
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part
-#### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	1173.15	8749.730000000001	1173.15	1753.76	1458.2883333333336
-Manufacturer#1	almond antique burnished rose metallic	1173.15	8749.730000000001	1173.15	1753.76	1458.2883333333336
-Manufacturer#1	almond antique chartreuse lavender yellow	1753.76	8749.730000000001	1173.15	1753.76	1458.2883333333336
-Manufacturer#1	almond antique salmon chartreuse burlywood	1602.59	8749.730000000001	1173.15	1753.76	1458.2883333333336
-Manufacturer#1	almond aquamarine burnished black steel	1414.42	8749.730000000001	1173.15	1753.76	1458.2883333333336
-Manufacturer#1	almond aquamarine pink moccasin thistle	1632.66	8749.730000000001	1173.15	1753.76	1458.2883333333336
-Manufacturer#2	almond antique violet chocolate turquoise	1690.68	8923.62	1690.68	2031.98	1784.7240000000002
-Manufacturer#2	almond antique violet turquoise frosted	1800.7	8923.62	1690.68	2031.98	1784.7240000000002
-Manufacturer#2	almond aquamarine midnight light salmon	2031.98	8923.62	1690.68	2031.98	1784.7240000000002
-Manufacturer#2	almond aquamarine rose maroon antique	1698.66	8923.62	1690.68	2031.98	1784.7240000000002
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	1701.6	8923.62	1690.68	2031.98	1784.7240000000002
-Manufacturer#3	almond antique chartreuse khaki white	1671.68	7532.61	1190.27	1922.98	1506.522
-Manufacturer#3	almond antique forest lavender goldenrod	1190.27	7532.61	1190.27	1922.98	1506.522
-Manufacturer#3	almond antique metallic orange dim	1410.39	7532.61	1190.27	1922.98	1506.522
-Manufacturer#3	almond antique misty red olive	1922.98	7532.61	1190.27	1922.98	1506.522
-Manufacturer#3	almond antique olive coral navajo	1337.29	7532.61	1190.27	1922.98	1506.522
-Manufacturer#4	almond antique gainsboro frosted violet	1620.67	7337.620000000001	1206.26	1844.92	1467.5240000000001
-Manufacturer#4	almond antique violet mint lemon	1375.42	7337.620000000001	1206.26	1844.92	1467.5240000000001
-Manufacturer#4	almond aquamarine floral ivory bisque	1206.26	7337.620000000001	1206.26	1844.92	1467.5240000000001
-Manufacturer#4	almond aquamarine yellow dodger mint	1844.92	7337.620000000001	1206.26	1844.92	1467.5240000000001
-Manufacturer#4	almond azure aquamarine papaya violet	1290.35	7337.620000000001	1206.26	1844.92	1467.5240000000001
-Manufacturer#5	almond antique blue firebrick mint	1789.69	7672.66	1018.1	1789.69	1534.532
-Manufacturer#5	almond antique medium spring khaki	1611.66	7672.66	1018.1	1789.69	1534.532
-Manufacturer#5	almond antique sky peru orange	1788.73	7672.66	1018.1	1789.69	1534.532
-Manufacturer#5	almond aquamarine dodger light gainsboro	1018.1	7672.66	1018.1	1789.69	1534.532
-Manufacturer#5	almond azure blanched chiffon midnight	1464.48	7672.66	1018.1	1789.69	1534.532
-PREHOOK: query: -- 44. testViewAsTableInputWithWindowing
+PREHOOK: query: -- 22. testViewAsTableInputWithWindowing
 create view IF NOT EXISTS mfgr_price_view as 
 select p_mfgr, p_brand, 
 sum(p_retailprice) as s 
@@ -2174,7 +1074,7 @@ from part 
 group by p_mfgr, p_brand
 PREHOOK: type: CREATEVIEW
 #### A masked pattern was here ####
-POSTHOOK: query: -- 44. testViewAsTableInputWithWindowing
+POSTHOOK: query: -- 22. testViewAsTableInputWithWindowing
 create view IF NOT EXISTS mfgr_price_view as 
 select p_mfgr, p_brand, 
 sum(p_retailprice) as s 
@@ -2219,45 +1119,7 @@ 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: -- 45. testViewAsTableInputToPTF
-select p_mfgr, p_brand, s, 
-sum(s) as s1 over w1 
-from noop(on mfgr_price_view 
-partition by p_mfgr 
-order by p_mfgr)  
-window w1 as ( partition by p_mfgr order by p_brand rows between 2 preceding and current row)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@mfgr_price_view
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 45. testViewAsTableInputToPTF
-select p_mfgr, p_brand, s, 
-sum(s) as s1 over w1 
-from noop(on mfgr_price_view 
-partition by p_mfgr 
-order by p_mfgr)  
-window w1 as ( partition by p_mfgr order by p_brand rows between 2 preceding and current row)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@mfgr_price_view
-POSTHOOK: Input: default@part
-#### A masked pattern was here ####
-Manufacturer#1	Brand#12	4800.84	4800.84
-Manufacturer#1	Brand#14	2346.3	7147.14
-Manufacturer#1	Brand#15	1602.59	8749.73
-Manufacturer#2	Brand#22	3491.38	3491.38
-Manufacturer#2	Brand#23	2031.98	5523.360000000001
-Manufacturer#2	Brand#24	1698.66	7222.02
-Manufacturer#2	Brand#25	1701.6	5432.24
-Manufacturer#3	Brand#31	1671.68	1671.68
-Manufacturer#3	Brand#32	3333.37	5005.05
-Manufacturer#3	Brand#34	1337.29	6342.34
-Manufacturer#3	Brand#35	1190.27	5860.93
-Manufacturer#4	Brand#41	4755.9400000000005	4755.9400000000005
-Manufacturer#4	Brand#42	2581.6800000000003	7337.620000000001
-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: -- 46. testCreateViewWithWindowingQuery
+PREHOOK: query: -- 23. testCreateViewWithWindowingQuery
 create view IF NOT EXISTS mfgr_brand_price_view as 
 select p_mfgr, p_brand, 
 sum(p_retailprice) as s over w1 
@@ -2267,7 +1129,7 @@ sort by p_mfgr 
 window w1 as (rows between 2 preceding and current row)
 PREHOOK: type: CREATEVIEW
 #### A masked pattern was here ####
-POSTHOOK: query: -- 46. testCreateViewWithWindowingQuery
+POSTHOOK: query: -- 23. testCreateViewWithWindowingQuery
 create view IF NOT EXISTS mfgr_brand_price_view as 
 select p_mfgr, p_brand, 
 sum(p_retailprice) as s over w1 
@@ -2314,7 +1176,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: -- 47. testLateralViews
+PREHOOK: query: -- 24. testLateralViews
 select p_mfgr, p_name, 
 lv_col, p_size, sum(p_size) as s over w1  
 from (select p_mfgr, p_name, p_size, array(1,2,3) arr from part) p 
@@ -2325,7 +1187,7 @@ window w1 as (rows between 2 preceding a
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: -- 47. testLateralViews
+POSTHOOK: query: -- 24. testLateralViews
 select p_mfgr, p_name, 
 lv_col, p_size, sum(p_size) as s over w1  
 from (select p_mfgr, p_name, p_size, array(1,2,3) arr from part) p 
@@ -2414,18 +1276,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: -- 48. testConstExprInSelect
-select 'tst1' as key, count(1) as value from part
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 48. testConstExprInSelect
-select 'tst1' as key, count(1) as value from part
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part
-#### A masked pattern was here ####
-tst1	26
-PREHOOK: query: -- 49. testMultipleInserts3SWQs
+PREHOOK: query: -- 25. testMultipleInserts3SWQs
 CREATE TABLE part_1( 
 p_mfgr STRING, 
 p_name STRING, 
@@ -2434,7 +1285,7 @@ r INT, 
 dr INT, 
 s DOUBLE)
 PREHOOK: type: CREATETABLE
-POSTHOOK: query: -- 49. testMultipleInserts3SWQs
+POSTHOOK: query: -- 25. testMultipleInserts3SWQs
 CREATE TABLE part_1( 
 p_mfgr STRING, 
 p_name STRING, 
@@ -2726,7 +1577,7 @@ Manufacturer#5	almond antique blue fireb
 Manufacturer#5	almond antique medium spring khaki	6	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: -- 50. testGroupByHavingWithSWQAndAlias
+PREHOOK: query: -- 26. testGroupByHavingWithSWQAndAlias
 select p_mfgr, p_name, p_size, min(p_retailprice) as mi,
 rank() as r,
 dense_rank() as dr,
@@ -2739,7 +1590,7 @@ sort by p_name
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: -- 50. testGroupByHavingWithSWQAndAlias
+POSTHOOK: query: -- 26. testGroupByHavingWithSWQAndAlias
 select p_mfgr, p_name, p_size, min(p_retailprice) as mi,
 rank() as r,
 dense_rank() as dr,
@@ -2798,7 +1649,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: -- 51. testMultipleRangeWindows
+PREHOOK: query: -- 27. testMultipleRangeWindows
 select  p_mfgr,p_name, p_size, 
 sum(p_size) as s2 over (range between p_size 10 less and current row), 
 sum(p_size) as s1 over (range between current row and p_size 10 more ) 
@@ -2809,7 +1660,7 @@ window w1 as (rows between 2 preceding a
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: -- 51. testMultipleRangeWindows
+POSTHOOK: query: -- 27. testMultipleRangeWindows
 select  p_mfgr,p_name, p_size, 
 sum(p_size) as s2 over (range between p_size 10 less and current row), 
 sum(p_size) as s1 over (range between current row and p_size 10 more ) 
@@ -2867,25 +1718,20 @@ 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: -- 52. testMultipleInserts2SWQsWithPTF
-CREATE TABLE part_4( 
-p_mfgr STRING, 
-p_name STRING, 
-p_size INT, 
-r INT, 
-dr INT, 
-s DOUBLE)
-PREHOOK: type: CREATETABLE
-POSTHOOK: query: -- 52. testMultipleInserts2SWQsWithPTF
-CREATE TABLE part_4( 
-p_mfgr STRING, 
-p_name STRING, 
-p_size INT, 
-r INT, 
-dr INT, 
-s DOUBLE)
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: default@part_4
+PREHOOK: query: -- 28. testPartOrderInUDAFInvoke
+select p_mfgr, p_name, p_size,
+sum(p_size) as s over (partition by p_mfgr  order by p_name  rows between 2 preceding and 2 following)
+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,
+sum(p_size) as s over (partition by p_mfgr  order by p_name  rows between 2 preceding and 2 following)
+from part
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@part
+#### A masked pattern was here ####
 POSTHOOK: Lineage: part_1.dr SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]

[... 1816 lines stripped ...]


Mime
View raw message