You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2013/03/04 04:01:07 UTC
svn commit: r1452174 [5/5] - in /hive/branches/ptf-windowing/ql/src/test:
queries/clientpositive/ results/clientpositive/
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 ...]