hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject svn commit: r1452174 [3/5] - in /hive/branches/ptf-windowing/ql/src/test: queries/clientpositive/ results/clientpositive/
Date Mon, 04 Mar 2013 03:01:07 GMT
Modified: 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/ptf_general_queries.q.out?rev=1452174&r1=1452173&r2=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/ptf_general_queries.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,234 +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
-select p_mfgr, p_name, p_size,
-rank() as r,
-dense_rank() as dr,
-sum(p_retailprice) as s1 over (rows between unbounded preceding and current row)
-from part
-distribute by p_mfgr
-sort by p_name
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 2. test1NoPTF
-select p_mfgr, p_name, p_size,
-rank() as r,
-dense_rank() as dr,
-sum(p_retailprice) as s1 over (rows between unbounded preceding and current row)
-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	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: --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
+PREHOOK: query: -- 1. testNoPTFNoWindowing
 select p_mfgr, p_name, p_size
 from part
 distribute by p_mfgr
@@ -274,7 +43,7 @@ sort by p_name
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: -- 5. testLeadLagNoPTFNoWindowing
+POSTHOOK: query: -- 1. testNoPTFNoWindowing
 select p_mfgr, p_name, p_size
 from part
 distribute by p_mfgr
@@ -308,4434 +77,64 @@ Manufacturer#2	almond aquamarine sandy c
 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
-select p_mfgr, p_name, p_size, min(p_retailprice),
-rank() as r,
-dense_rank() as dr,
-p_size, p_size - lag(p_size,1) as deltaSz
-from part
-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: -- 8. testGroupByWithSWQ
-select p_mfgr, p_name, p_size, min(p_retailprice),
-rank() as r,
-dense_rank() as dr,
-p_size, p_size - lag(p_size,1) as deltaSz
-from part
-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	1173.15	1	1	2	0
-Manufacturer#1	almond antique chartreuse lavender yellow	34	1753.76	2	2	34	32
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	1602.59	3	3	6	-28
-Manufacturer#1	almond aquamarine burnished black steel	28	1414.42	4	4	28	22
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	1632.66	5	5	42	14
-Manufacturer#2	almond antique violet chocolate turquoise	14	1690.68	1	1	14	0
-Manufacturer#2	almond antique violet turquoise frosted	40	1800.7	2	2	40	26
-Manufacturer#2	almond aquamarine midnight light salmon	2	2031.98	3	3	2	-38
-Manufacturer#2	almond aquamarine rose maroon antique	25	1698.66	4	4	25	23
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	1701.6	5	5	18	-7
-Manufacturer#3	almond antique chartreuse khaki white	17	1671.68	1	1	17	0
-Manufacturer#3	almond antique forest lavender goldenrod	14	1190.27	2	2	14	-3
-Manufacturer#3	almond antique metallic orange dim	19	1410.39	3	3	19	5
-Manufacturer#3	almond antique misty red olive	1	1922.98	4	4	1	-18
-Manufacturer#3	almond antique olive coral navajo	45	1337.29	5	5	45	44
-Manufacturer#4	almond antique gainsboro frosted violet	10	1620.67	1	1	10	0
-Manufacturer#4	almond antique violet mint lemon	39	1375.42	2	2	39	29
-Manufacturer#4	almond aquamarine floral ivory bisque	27	1206.26	3	3	27	-12
-Manufacturer#4	almond aquamarine yellow dodger mint	7	1844.92	4	4	7	-20
-Manufacturer#4	almond azure aquamarine papaya violet	12	1290.35	5	5	12	5
-Manufacturer#5	almond antique blue firebrick mint	31	1789.69	1	1	31	0
-Manufacturer#5	almond antique medium spring khaki	6	1611.66	2	2	6	-25
-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
-select p_mfgr, p_name, p_size, min(p_retailprice),
-rank() as r,
-dense_rank() as dr,
-p_size, p_size - lag(p_size,1) as deltaSz
-from part
-group by p_mfgr, p_name, p_size
-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: -- 9. testGroupByHavingWithSWQ
-select p_mfgr, p_name, p_size, min(p_retailprice),
-rank() as r,
-dense_rank() as dr,
-p_size, p_size - lag(p_size,1) as deltaSz
-from part
-group by p_mfgr, p_name, p_size
-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	1173.15	1	1	2	0
-Manufacturer#1	almond antique chartreuse lavender yellow	34	1753.76	2	2	34	32
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	1602.59	3	3	6	-28
-Manufacturer#1	almond aquamarine burnished black steel	28	1414.42	4	4	28	22
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	1632.66	5	5	42	14
-Manufacturer#2	almond antique violet chocolate turquoise	14	1690.68	1	1	14	0
-Manufacturer#2	almond antique violet turquoise frosted	40	1800.7	2	2	40	26
-Manufacturer#2	almond aquamarine midnight light salmon	2	2031.98	3	3	2	-38
-Manufacturer#2	almond aquamarine rose maroon antique	25	1698.66	4	4	25	23
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	1701.6	5	5	18	-7
-Manufacturer#3	almond antique chartreuse khaki white	17	1671.68	1	1	17	0
-Manufacturer#3	almond antique forest lavender goldenrod	14	1190.27	2	2	14	-3
-Manufacturer#3	almond antique metallic orange dim	19	1410.39	3	3	19	5
-Manufacturer#3	almond antique misty red olive	1	1922.98	4	4	1	-18
-Manufacturer#3	almond antique olive coral navajo	45	1337.29	5	5	45	44
-Manufacturer#4	almond antique gainsboro frosted violet	10	1620.67	1	1	10	0
-Manufacturer#4	almond antique violet mint lemon	39	1375.42	2	2	39	29
-Manufacturer#4	almond aquamarine floral ivory bisque	27	1206.26	3	3	27	-12
-Manufacturer#4	almond aquamarine yellow dodger mint	7	1844.92	4	4	7	-20
-Manufacturer#4	almond azure aquamarine papaya violet	12	1290.35	5	5	12	5
-Manufacturer#5	almond antique blue firebrick mint	31	1789.69	1	1	31	0
-Manufacturer#5	almond antique medium spring khaki	6	1611.66	2	2	6	-25
-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
-select p_mfgr, p_name, 
-rank() as r, 
-dense_rank() as dr, 
-count(p_size) as cd 
-from part 
-distribute by p_mfgr 
-sort by p_name
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 14. testCountNoWindowing
-select p_mfgr, p_name, 
-rank() as r, 
-dense_rank() as dr, 
-count(p_size) as cd 
-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	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
-select p_mfgr, p_name, 
-rank() as r, 
-dense_rank() as dr, 
-count(p_size) as cd, 
-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: -- 15. testCountWithWindowing
-select p_mfgr, p_name, 
-rank() as r, 
-dense_rank() as dr, 
-count(p_size) as cd, 
-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	6	1173.15	1173.15	2	0
-Manufacturer#1	almond antique burnished rose metallic	1	1	6	1173.15	2346.3	2	0
-Manufacturer#1	almond antique chartreuse lavender yellow	3	2	6	1753.76	4100.06	34	32
-Manufacturer#1	almond antique salmon chartreuse burlywood	4	3	6	1602.59	5702.650000000001	6	-28
-Manufacturer#1	almond aquamarine burnished black steel	5	4	6	1414.42	7117.070000000001	28	22
-Manufacturer#1	almond aquamarine pink moccasin thistle	6	5	6	1632.66	8749.730000000001	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: -- 16. testCountInSubQ
-select sub1.r, sub1.dr, sub1.cd, sub1.s1, sub1.deltaSz 
-from (select p_mfgr, p_name, 
-rank() as r, 
-dense_rank() as dr, 
-count(p_size) as cd, 
-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
-) sub1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 16. testCountInSubQ
-select sub1.r, sub1.dr, sub1.cd, sub1.s1, sub1.deltaSz 
-from (select p_mfgr, p_name, 
-rank() as r, 
-dense_rank() as dr, 
-count(p_size) as cd, 
-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
-) sub1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part
-#### A masked pattern was here ####
-1	1	6	1173.15	0
-1	1	6	2346.3	0
-3	2	6	4100.06	32
-4	3	6	5702.650000000001	-28
-5	4	6	7117.070000000001	22
-6	5	6	8749.730000000001	14
-1	1	5	1690.68	0
-2	2	5	3491.38	26
-3	3	5	5523.360000000001	-38
-4	4	5	7222.02	23
-5	5	5	8923.62	-7
-1	1	5	1671.68	0
-2	2	5	2861.95	-3
-3	3	5	4272.34	5
-4	4	5	6195.32	-18
-5	5	5	7532.61	44
-1	1	5	1620.67	0
-2	2	5	2996.09	29
-3	3	5	4202.35	-12
-4	4	5	6047.27	-20
-5	5	5	7337.620000000001	5
-1	1	5	1789.69	0
-2	2	5	3401.3500000000004	-25
-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 
-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: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: 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 
-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	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 burnished rose metallic	1	1	1173.15	3519.4500000000003	2	0
-Manufacturer#1	almond antique burnished rose metallic	1	1	1173.15	4692.6	2	0
-Manufacturer#1	almond antique chartreuse lavender yellow	5	2	1753.76	6446.360000000001	34	32
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	3	1602.59	8048.950000000001	6	-28
-Manufacturer#1	almond aquamarine burnished black steel	7	4	1414.42	9463.37	28	22
-Manufacturer#1	almond aquamarine pink moccasin thistle	8	5	1632.66	11096.03	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: -- 20. testMixedCaseAlias
-select p_mfgr, p_name, p_size, rank() as R
+PREHOOK: query: -- 2. 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_name, p_size desc
+sort by p_mfgr, p_name
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: -- 20. testMixedCaseAlias
-select p_mfgr, p_name, p_size, rank() as R
+POSTHOOK: query: -- 2. 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_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: -- 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)
+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	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)
+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: -- 3. 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: -- 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
-select p_mfgr, p_name, p_size, 
-rank() as r, 
-dense_rank() as dr, 
-sum(p_retailprice) as s1 over (rows between unbounded preceding and current row) 
-from part 
-having p_size > 5 
-distribute by p_mfgr 
-sort by p_name
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 23. testHavingWithWindowingNoGBY
-select p_mfgr, p_name, p_size, 
-rank() as r, 
-dense_rank() as dr, 
-sum(p_retailprice) as s1 over (rows between unbounded preceding and current row) 
-from part 
-having p_size > 5 
-distribute by p_mfgr 
-sort by p_name
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part
-#### A masked pattern was here ####
-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 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 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 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
-select p_mfgr, p_name, p_size, 
-rank() as r, 
-dense_rank() as dr, 
-sum(p_retailprice) as s1 over (rows between unbounded preceding and current row) 
-from part 
-having rank() < 4 
-distribute by p_mfgr 
-sort by p_name
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part
-#### A masked pattern was here ####
-POSTHOOK: query: -- 24. testHavingWithWindowingCondRankNoGBY
-select p_mfgr, p_name, p_size, 
-rank() as r, 
-dense_rank() as dr, 
-sum(p_retailprice) as s1 over (rows between unbounded preceding and current row) 
-from part 
-having rank() < 4 
-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	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: -- 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   
-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 , 
-last_value(p_size, false) as l 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: -- 26. 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 , 
-last_value(p_size, false) as l 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	2	2	2
-Manufacturer#1	almond antique chartreuse lavender yellow	34	34	2	6
-Manufacturer#1	almond antique burnished rose metallic	2	2	2	28
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	6	34	42
-Manufacturer#1	almond aquamarine burnished black steel	28	28	2	42
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	42	6	42
-Manufacturer#2	almond antique violet chocolate turquoise	14	14	14	2
-Manufacturer#2	almond antique violet turquoise frosted	40	40	14	25
-Manufacturer#2	almond aquamarine midnight light salmon	2	2	14	18
-Manufacturer#2	almond aquamarine rose maroon antique	25	25	40	18
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	18	2	18
-Manufacturer#3	almond antique metallic orange dim	19	19	19	14
-Manufacturer#3	almond antique chartreuse khaki white	17	17	19	1
-Manufacturer#3	almond antique forest lavender goldenrod	14	14	19	45
-Manufacturer#3	almond antique misty red olive	1	1	17	45
-Manufacturer#3	almond antique olive coral navajo	45	45	14	45
-Manufacturer#4	almond antique gainsboro frosted violet	10	10	10	27
-Manufacturer#4	almond antique violet mint lemon	39	39	10	7
-Manufacturer#4	almond aquamarine floral ivory bisque	27	27	10	12
-Manufacturer#4	almond aquamarine yellow dodger mint	7	7	39	12
-Manufacturer#4	almond azure aquamarine papaya violet	12	12	27	12
-Manufacturer#5	almond antique blue firebrick mint	31	31	31	2
-Manufacturer#5	almond antique medium spring khaki	6	6	31	46
-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
-select  p_mfgr,p_name, p_size, 
-rank() as r, 
-sum(p_size) as s2 over (rows between current row and current row), 
-first_value(p_size) as f over w1,  
-last_value(p_size, false) as l over w1 
-from part 
-where p_mfgr = 'Manufacturer#3' 
-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: -- 27. testFirstLastWithWhere
-select  p_mfgr,p_name, p_size, 
-rank() as r, 
-sum(p_size) as s2 over (rows between current row and current row), 
-first_value(p_size) as f over w1,  
-last_value(p_size, false) as l over w1 
-from part 
-where p_mfgr = 'Manufacturer#3' 
-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#3	almond antique chartreuse khaki white	17	1	17	17	19
-Manufacturer#3	almond antique forest lavender goldenrod	14	1	14	17	1
-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
-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) 
-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: -- 29. 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) 
-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	38	2
-Manufacturer#1	almond antique chartreuse lavender yellow	34	44	34
-Manufacturer#1	almond antique burnished rose metallic	2	72	2
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	112	6
-Manufacturer#1	almond aquamarine burnished black steel	28	78	28
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	76	42
-Manufacturer#2	almond antique violet chocolate turquoise	14	56	14
-Manufacturer#2	almond antique violet turquoise frosted	40	81	40
-Manufacturer#2	almond aquamarine midnight light salmon	2	99	2
-Manufacturer#2	almond aquamarine rose maroon antique	25	85	25
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	45	18
-Manufacturer#3	almond antique metallic orange dim	19	50	19
-Manufacturer#3	almond antique chartreuse khaki white	17	51	17
-Manufacturer#3	almond antique forest lavender goldenrod	14	96	14
-Manufacturer#3	almond antique misty red olive	1	77	1
-Manufacturer#3	almond antique olive coral navajo	45	60	45
-Manufacturer#4	almond antique gainsboro frosted violet	10	76	10
-Manufacturer#4	almond antique violet mint lemon	39	83	39
-Manufacturer#4	almond aquamarine floral ivory bisque	27	95	27
-Manufacturer#4	almond aquamarine yellow dodger mint	7	85	7
-Manufacturer#4	almond azure aquamarine papaya violet	12	46	12
-Manufacturer#5	almond antique blue firebrick mint	31	39	31
-Manufacturer#5	almond antique medium spring khaki	6	85	6
-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
-select  p_mfgr,p_name, p_size, 
-rank() as r, dense_rank() as dr 
-from part 
-distribute 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: -- 30. testNoSortClause
-select  p_mfgr,p_name, p_size, 
-rank() as r, dense_rank() as dr 
-from part 
-distribute 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	1	1
-Manufacturer#1	almond antique chartreuse lavender yellow	34	1	1
-Manufacturer#1	almond antique burnished rose metallic	2	1	1
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	1	1
-Manufacturer#1	almond aquamarine burnished black steel	28	1	1
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	1	1
-Manufacturer#2	almond antique violet chocolate turquoise	14	1	1
-Manufacturer#2	almond antique violet turquoise frosted	40	1	1
-Manufacturer#2	almond aquamarine midnight light salmon	2	1	1
-Manufacturer#2	almond aquamarine rose maroon antique	25	1	1
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	1	1
-Manufacturer#3	almond antique metallic orange dim	19	1	1
-Manufacturer#3	almond antique chartreuse khaki white	17	1	1
-Manufacturer#3	almond antique forest lavender goldenrod	14	1	1
-Manufacturer#3	almond antique misty red olive	1	1	1
-Manufacturer#3	almond antique olive coral navajo	45	1	1
-Manufacturer#4	almond antique gainsboro frosted violet	10	1	1
-Manufacturer#4	almond antique violet mint lemon	39	1	1
-Manufacturer#4	almond aquamarine floral ivory bisque	27	1	1
-Manufacturer#4	almond aquamarine yellow dodger mint	7	1	1
-Manufacturer#4	almond azure aquamarine papaya violet	12	1	1
-Manufacturer#5	almond antique blue firebrick mint	31	1	1
-Manufacturer#5	almond antique medium spring khaki	6	1	1
-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
-select  p_mfgr,p_name, p_size,  
-rank() as r,  
-dense_rank() as dr, 
-cume_dist() as cud, 
-percent_rank() as pr, 
-ntile(3) as nt, 
-count(p_size) as ca, 
-avg(p_size) as avg, 
-stddev(p_size) as st, 
-first_value(p_size % 5) as fv, 
-last_value(p_size) as lv, 
-first_value(p_size, true) as fvW1 over w1 
-from part 
-having p_size > 5 
-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: -- 31. testExpressions
-select  p_mfgr,p_name, p_size,  
-rank() as r,  
-dense_rank() as dr, 
-cume_dist() as cud, 
-percent_rank() as pr, 
-ntile(3) as nt, 
-count(p_size) as ca, 
-avg(p_size) as avg, 
-stddev(p_size) as st, 
-first_value(p_size % 5) as fv, 
-last_value(p_size) as lv, 
-first_value(p_size, true) as fvW1 over w1 
-from part 
-having p_size > 5 
-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 ####
-Manufacturer#1	almond antique chartreuse lavender yellow	34	3	2	0.5	0.4	2	6	19.0	16.237815945091466	2	42	2
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	3	0.6666666666666666	0.6	2	6	19.0	16.237815945091466	2	42	2
-Manufacturer#1	almond aquamarine burnished black steel	28	5	4	0.8333333333333334	0.8	3	6	19.0	16.237815945091466	2	42	34
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	5	1.0	1.0	3	6	19.0	16.237815945091466	2	42	6
-Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	0.2	0.0	1	5	19.8	12.560254774486067	4	18	14
-Manufacturer#2	almond antique violet turquoise frosted	40	2	2	0.4	0.25	1	5	19.8	12.560254774486067	4	18	14
-Manufacturer#2	almond aquamarine rose maroon antique	25	4	4	0.8	0.75	2	5	19.8	12.560254774486067	4	18	40
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	5	5	1.0	1.0	3	5	19.8	12.560254774486067	4	18	2
-Manufacturer#3	almond antique chartreuse khaki white	17	1	1	0.2	0.0	1	5	19.2	14.344336861632886	2	45	17
-Manufacturer#3	almond antique forest lavender goldenrod	14	2	2	0.4	0.25	1	5	19.2	14.344336861632886	2	45	17
-Manufacturer#3	almond antique metallic orange dim	19	3	3	0.6	0.5	2	5	19.2	14.344336861632886	2	45	17
-Manufacturer#3	almond antique olive coral navajo	45	5	5	1.0	1.0	3	5	19.2	14.344336861632886	2	45	19
-Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	0.2	0.0	1	5	19.0	12.149074038789951	0	12	10
-Manufacturer#4	almond antique violet mint lemon	39	2	2	0.4	0.25	1	5	19.0	12.149074038789951	0	12	10
-Manufacturer#4	almond aquamarine floral ivory bisque	27	3	3	0.6	0.5	2	5	19.0	12.149074038789951	0	12	10
-Manufacturer#4	almond aquamarine yellow dodger mint	7	4	4	0.8	0.75	2	5	19.0	12.149074038789951	0	12	39
-Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	1.0	1.0	3	5	19.0	12.149074038789951	0	12	27
-Manufacturer#5	almond antique blue firebrick mint	31	1	1	0.2	0.0	1	5	21.6	16.206171663906314	1	23	31
-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
-select  p_mfgr,p_name, p_size,  
-  rank() as r, dense_rank() as dr, 
-cume_dist() as cud, 
-sum(p_size) as s1 over (rows between unbounded preceding and current row), 
-sum(p_size) as s2 over (range between p_size 5 less and current row), 
-first_value(p_size, true) as fv1 over w1 
-from part 
-having p_size > 5 
-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: -- 32. testMultipleWindows
-select  p_mfgr,p_name, p_size,  
-  rank() as r, dense_rank() as dr, 
-cume_dist() as cud, 
-sum(p_size) as s1 over (rows between unbounded preceding and current row), 
-sum(p_size) as s2 over (range between p_size 5 less and current row), 
-first_value(p_size, true) as fv1 over w1 
-from part 
-having p_size > 5 
-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 ####
-Manufacturer#1	almond antique chartreuse lavender yellow	34	3	2	0.5	38	34	2
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	3	0.6666666666666666	44	44	2
-Manufacturer#1	almond aquamarine burnished black steel	28	5	4	0.8333333333333334	72	28	34
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	5	1.0	114	42	6
-Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	0.2	14	14	14
-Manufacturer#2	almond antique violet turquoise frosted	40	2	2	0.4	54	40	14
-Manufacturer#2	almond aquamarine rose maroon antique	25	4	4	0.8	81	25	40
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	5	5	1.0	99	43	2
-Manufacturer#3	almond antique chartreuse khaki white	17	1	1	0.2	17	17	17
-Manufacturer#3	almond antique forest lavender goldenrod	14	2	2	0.4	31	31	17
-Manufacturer#3	almond antique metallic orange dim	19	3	3	0.6	50	19	17
-Manufacturer#3	almond antique olive coral navajo	45	5	5	1.0	96	45	19
-Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	0.2	10	10	10
-Manufacturer#4	almond antique violet mint lemon	39	2	2	0.4	49	39	10
-Manufacturer#4	almond aquamarine floral ivory bisque	27	3	3	0.6	76	66	10
-Manufacturer#4	almond aquamarine yellow dodger mint	7	4	4	0.8	83	83	39
-Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	1.0	95	12	27
-Manufacturer#5	almond antique blue firebrick mint	31	1	1	0.2	31	31	31
-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
-select  p_mfgr,p_name, p_size,
-count(*) as c, 
-count(p_size) as ca, 
-first_value(p_size, true) as fvW1 over w1 
-from part 
-having p_size > 5 
-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: -- 35. testCountStar
-select  p_mfgr,p_name, p_size,
-count(*) as c, 
-count(p_size) as ca, 
-first_value(p_size, true) as fvW1 over w1 
-from part 
-having p_size > 5 
-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 ####
-Manufacturer#1	almond antique chartreuse lavender yellow	34	6	6	2
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	6	6	2
-Manufacturer#1	almond aquamarine burnished black steel	28	6	6	34
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	6	6
-Manufacturer#2	almond antique violet chocolate turquoise	14	5	5	14
-Manufacturer#2	almond antique violet turquoise frosted	40	5	5	14
-Manufacturer#2	almond aquamarine rose maroon antique	25	5	5	40

[... 2998 lines stripped ...]


Mime
View raw message