http://git-wip-us.apache.org/repos/asf/hive/blob/6f5c1135/ql/src/test/results/clientpositive/cbo_rp_windowing_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/cbo_rp_windowing_2.q.out b/ql/src/test/results/clientpositive/cbo_rp_windowing_2.q.out deleted file mode 100644 index db68276..0000000 --- a/ql/src/test/results/clientpositive/cbo_rp_windowing_2.q.out +++ /dev/null @@ -1,2339 +0,0 @@ -PREHOOK: query: -- SORT_QUERY_RESULTS - --- 1. testWindowing -select p_mfgr, p_name, p_size, -rank() over(distribute by p_mfgr sort by p_name) as r, -dense_rank() over(distribute by p_mfgr sort by p_name) as dr, -round(sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row),2) as s1 -from part -PREHOOK: type: QUERY -PREHOOK: Input: default@part -#### A masked pattern was here #### -POSTHOOK: query: -- SORT_QUERY_RESULTS - --- 1. testWindowing -select p_mfgr, p_name, p_size, -rank() over(distribute by p_mfgr sort by p_name) as r, -dense_rank() over(distribute by p_mfgr sort by p_name) as dr, -round(sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row),2) as s1 -from part -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.65 -Manufacturer#1 almond aquamarine burnished black steel 28 5 4 7117.07 -Manufacturer#1 almond aquamarine pink moccasin thistle 42 6 5 8749.73 -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.36 -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.62 -Manufacturer#5 almond antique blue firebrick mint 31 1 1 1789.69 -Manufacturer#5 almond antique medium spring khaki 6 2 2 3401.35 -Manufacturer#5 almond antique sky peru orange 2 3 3 5190.08 -Manufacturer#5 almond aquamarine dodger light gainsboro 46 4 4 6208.18 -Manufacturer#5 almond azure blanched chiffon midnight 23 5 5 7672.66 -PREHOOK: query: -- 2. testGroupByWithPartitioning -select p_mfgr, p_name, p_size, -min(p_retailprice), -rank() over(distribute by p_mfgr sort by p_name)as r, -dense_rank() over(distribute by p_mfgr sort by p_name) as dr, -p_size, p_size - lag(p_size,1,p_size) over(distribute by p_mfgr sort by p_name) as deltaSz -from part -group by p_mfgr, p_name, p_size -PREHOOK: type: QUERY -PREHOOK: Input: default@part -#### A masked pattern was here #### -POSTHOOK: query: -- 2. testGroupByWithPartitioning -select p_mfgr, p_name, p_size, -min(p_retailprice), -rank() over(distribute by p_mfgr sort by p_name)as r, -dense_rank() over(distribute by p_mfgr sort by p_name) as dr, -p_size, p_size - lag(p_size,1,p_size) over(distribute by p_mfgr sort by p_name) as deltaSz -from part -group by p_mfgr, p_name, p_size -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: -- 3. testGroupByHavingWithSWQ -select p_mfgr, p_name, p_size, min(p_retailprice), -rank() over(distribute by p_mfgr sort by p_name) as r, -dense_rank() over(distribute by p_mfgr sort by p_name) as dr, -p_size, p_size - lag(p_size,1,p_size) over(distribute by p_mfgr sort by p_name) as deltaSz -from part -group by p_mfgr, p_name, p_size -having p_size > 0 -PREHOOK: type: QUERY -PREHOOK: Input: default@part -#### A masked pattern was here #### -POSTHOOK: query: -- 3. testGroupByHavingWithSWQ -select p_mfgr, p_name, p_size, min(p_retailprice), -rank() over(distribute by p_mfgr sort by p_name) as r, -dense_rank() over(distribute by p_mfgr sort by p_name) as dr, -p_size, p_size - lag(p_size,1,p_size) over(distribute by p_mfgr sort by p_name) as deltaSz -from part -group by p_mfgr, p_name, p_size -having p_size > 0 -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: -- 4. testCount -select p_mfgr, p_name, -count(p_size) over(distribute by p_mfgr sort by p_name) as cd -from part -PREHOOK: type: QUERY -PREHOOK: Input: default@part -#### A masked pattern was here #### -POSTHOOK: query: -- 4. testCount -select p_mfgr, p_name, -count(p_size) over(distribute by p_mfgr sort by p_name) as cd -from part -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 3 -Manufacturer#1 almond antique salmon chartreuse burlywood 4 -Manufacturer#1 almond aquamarine burnished black steel 5 -Manufacturer#1 almond aquamarine pink moccasin thistle 6 -Manufacturer#2 almond antique violet chocolate turquoise 1 -Manufacturer#2 almond antique violet turquoise frosted 2 -Manufacturer#2 almond aquamarine midnight light salmon 3 -Manufacturer#2 almond aquamarine rose maroon antique 4 -Manufacturer#2 almond aquamarine sandy cyan gainsboro 5 -Manufacturer#3 almond antique chartreuse khaki white 1 -Manufacturer#3 almond antique forest lavender goldenrod 2 -Manufacturer#3 almond antique metallic orange dim 3 -Manufacturer#3 almond antique misty red olive 4 -Manufacturer#3 almond antique olive coral navajo 5 -Manufacturer#4 almond antique gainsboro frosted violet 1 -Manufacturer#4 almond antique violet mint lemon 2 -Manufacturer#4 almond aquamarine floral ivory bisque 3 -Manufacturer#4 almond aquamarine yellow dodger mint 4 -Manufacturer#4 almond azure aquamarine papaya violet 5 -Manufacturer#5 almond antique blue firebrick mint 1 -Manufacturer#5 almond antique medium spring khaki 2 -Manufacturer#5 almond antique sky peru orange 3 -Manufacturer#5 almond aquamarine dodger light gainsboro 4 -Manufacturer#5 almond azure blanched chiffon midnight 5 -PREHOOK: query: -- 5. testCountWithWindowingUDAF -select p_mfgr, p_name, -rank() over(distribute by p_mfgr sort by p_name) as r, -dense_rank() over(distribute by p_mfgr sort by p_name) as dr, -count(p_size) over(distribute by p_mfgr sort by p_name) as cd, -p_retailprice, round(sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row),2) as s1, -p_size, p_size - lag(p_size,1,p_size) over(distribute by p_mfgr sort by p_name) as deltaSz -from part -PREHOOK: type: QUERY -PREHOOK: Input: default@part -#### A masked pattern was here #### -POSTHOOK: query: -- 5. testCountWithWindowingUDAF -select p_mfgr, p_name, -rank() over(distribute by p_mfgr sort by p_name) as r, -dense_rank() over(distribute by p_mfgr sort by p_name) as dr, -count(p_size) over(distribute by p_mfgr sort by p_name) as cd, -p_retailprice, round(sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row),2) as s1, -p_size, p_size - lag(p_size,1,p_size) over(distribute by p_mfgr sort by p_name) as deltaSz -from part -POSTHOOK: type: QUERY -POSTHOOK: Input: default@part -#### A masked pattern was here #### -Manufacturer#1 almond antique burnished rose metallic 1 1 2 1173.15 1173.15 2 0 -Manufacturer#1 almond antique burnished rose metallic 1 1 2 1173.15 2346.3 2 0 -Manufacturer#1 almond antique chartreuse lavender yellow 3 2 3 1753.76 4100.06 34 32 -Manufacturer#1 almond antique salmon chartreuse burlywood 4 3 4 1602.59 5702.65 6 -28 -Manufacturer#1 almond aquamarine burnished black steel 5 4 5 1414.42 7117.07 28 22 -Manufacturer#1 almond aquamarine pink moccasin thistle 6 5 6 1632.66 8749.73 42 14 -Manufacturer#2 almond antique violet chocolate turquoise 1 1 1 1690.68 1690.68 14 0 -Manufacturer#2 almond antique violet turquoise frosted 2 2 2 1800.7 3491.38 40 26 -Manufacturer#2 almond aquamarine midnight light salmon 3 3 3 2031.98 5523.36 2 -38 -Manufacturer#2 almond aquamarine rose maroon antique 4 4 4 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 1 1671.68 1671.68 17 0 -Manufacturer#3 almond antique forest lavender goldenrod 2 2 2 1190.27 2861.95 14 -3 -Manufacturer#3 almond antique metallic orange dim 3 3 3 1410.39 4272.34 19 5 -Manufacturer#3 almond antique misty red olive 4 4 4 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 1 1620.67 1620.67 10 0 -Manufacturer#4 almond antique violet mint lemon 2 2 2 1375.42 2996.09 39 29 -Manufacturer#4 almond aquamarine floral ivory bisque 3 3 3 1206.26 4202.35 27 -12 -Manufacturer#4 almond aquamarine yellow dodger mint 4 4 4 1844.92 6047.27 7 -20 -Manufacturer#4 almond azure aquamarine papaya violet 5 5 5 1290.35 7337.62 12 5 -Manufacturer#5 almond antique blue firebrick mint 1 1 1 1789.69 1789.69 31 0 -Manufacturer#5 almond antique medium spring khaki 2 2 2 1611.66 3401.35 6 -25 -Manufacturer#5 almond antique sky peru orange 3 3 3 1788.73 5190.08 2 -4 -Manufacturer#5 almond aquamarine dodger light gainsboro 4 4 4 1018.1 6208.18 46 44 -Manufacturer#5 almond azure blanched chiffon midnight 5 5 5 1464.48 7672.66 23 -23 -PREHOOK: query: -- 6. testCountInSubQ -select sub1.r, sub1.dr, sub1.cd, sub1.s1, sub1.deltaSz -from (select p_mfgr, p_name, -rank() over(distribute by p_mfgr sort by p_name) as r, -dense_rank() over(distribute by p_mfgr sort by p_name) as dr, -count(p_size) over(distribute by p_mfgr sort by p_name) as cd, -p_retailprice, round(sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row),2) as s1, -p_size, p_size - lag(p_size,1,p_size) over(distribute by p_mfgr sort by p_name) as deltaSz -from part -) sub1 -PREHOOK: type: QUERY -PREHOOK: Input: default@part -#### A masked pattern was here #### -POSTHOOK: query: -- 6. testCountInSubQ -select sub1.r, sub1.dr, sub1.cd, sub1.s1, sub1.deltaSz -from (select p_mfgr, p_name, -rank() over(distribute by p_mfgr sort by p_name) as r, -dense_rank() over(distribute by p_mfgr sort by p_name) as dr, -count(p_size) over(distribute by p_mfgr sort by p_name) as cd, -p_retailprice, round(sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row),2) as s1, -p_size, p_size - lag(p_size,1,p_size) over(distribute by p_mfgr sort by p_name) as deltaSz -from part -) sub1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@part -#### A masked pattern was here #### -1 1 1 1620.67 0 -1 1 1 1671.68 0 -1 1 1 1690.68 0 -1 1 1 1789.69 0 -1 1 2 1173.15 0 -1 1 2 2346.3 0 -2 2 2 2861.95 -3 -2 2 2 2996.09 29 -2 2 2 3401.35 -25 -2 2 2 3491.38 26 -3 2 3 4100.06 32 -3 3 3 4202.35 -12 -3 3 3 4272.34 5 -3 3 3 5190.08 -4 -3 3 3 5523.36 -38 -4 3 4 5702.65 -28 -4 4 4 6047.27 -20 -4 4 4 6195.32 -18 -4 4 4 6208.18 44 -4 4 4 7222.02 23 -5 4 5 7117.07 22 -5 5 5 7337.62 5 -5 5 5 7532.61 44 -5 5 5 7672.66 -23 -5 5 5 8923.62 -7 -6 5 6 8749.73 14 -PREHOOK: query: -- 7. testJoinWithWindowingAndPTF -select abc.p_mfgr, abc.p_name, -rank() over(distribute by abc.p_mfgr sort by abc.p_name) as r, -dense_rank() over(distribute by abc.p_mfgr sort by abc.p_name) as dr, -abc.p_retailprice, round(sum(abc.p_retailprice) over (distribute by abc.p_mfgr sort by abc.p_name rows between unbounded preceding and current row),2) as s1, -abc.p_size, abc.p_size - lag(abc.p_size,1,abc.p_size) over(distribute by abc.p_mfgr sort by abc.p_name) 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 -PREHOOK: type: QUERY -PREHOOK: Input: default@part -#### A masked pattern was here #### -POSTHOOK: query: -- 7. testJoinWithWindowingAndPTF -select abc.p_mfgr, abc.p_name, -rank() over(distribute by abc.p_mfgr sort by abc.p_name) as r, -dense_rank() over(distribute by abc.p_mfgr sort by abc.p_name) as dr, -abc.p_retailprice, round(sum(abc.p_retailprice) over (distribute by abc.p_mfgr sort by abc.p_name rows between unbounded preceding and current row),2) as s1, -abc.p_size, abc.p_size - lag(abc.p_size,1,abc.p_size) over(distribute by abc.p_mfgr sort by abc.p_name) 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 -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.45 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.36 34 32 -Manufacturer#1 almond antique salmon chartreuse burlywood 6 3 1602.59 8048.95 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.36 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.62 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.35 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: -- 8. testMixedCaseAlias -select p_mfgr, p_name, p_size, -rank() over(distribute by p_mfgr sort by p_name, p_size desc) as R -from part -PREHOOK: type: QUERY -PREHOOK: Input: default@part -#### A masked pattern was here #### -POSTHOOK: query: -- 8. testMixedCaseAlias -select p_mfgr, p_name, p_size, -rank() over(distribute by p_mfgr sort by p_name, p_size desc) as R -from part -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: -- 9. testHavingWithWindowingNoGBY -select p_mfgr, p_name, p_size, -rank() over(distribute by p_mfgr sort by p_name) as r, -dense_rank() over(distribute by p_mfgr sort by p_name) as dr, -round(sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row),2) as s1 -from part -PREHOOK: type: QUERY -PREHOOK: Input: default@part -#### A masked pattern was here #### -POSTHOOK: query: -- 9. testHavingWithWindowingNoGBY -select p_mfgr, p_name, p_size, -rank() over(distribute by p_mfgr sort by p_name) as r, -dense_rank() over(distribute by p_mfgr sort by p_name) as dr, -round(sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row),2) as s1 -from part -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.65 -Manufacturer#1 almond aquamarine burnished black steel 28 5 4 7117.07 -Manufacturer#1 almond aquamarine pink moccasin thistle 42 6 5 8749.73 -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.36 -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.62 -Manufacturer#5 almond antique blue firebrick mint 31 1 1 1789.69 -Manufacturer#5 almond antique medium spring khaki 6 2 2 3401.35 -Manufacturer#5 almond antique sky peru orange 2 3 3 5190.08 -Manufacturer#5 almond aquamarine dodger light gainsboro 46 4 4 6208.18 -Manufacturer#5 almond azure blanched chiffon midnight 23 5 5 7672.66 -PREHOOK: query: -- 10. testHavingWithWindowingCondRankNoGBY -select p_mfgr, p_name, p_size, -rank() over(distribute by p_mfgr sort by p_name) as r, -dense_rank() over(distribute by p_mfgr sort by p_name) as dr, -round(sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row),2) as s1 -from part -PREHOOK: type: QUERY -PREHOOK: Input: default@part -#### A masked pattern was here #### -POSTHOOK: query: -- 10. testHavingWithWindowingCondRankNoGBY -select p_mfgr, p_name, p_size, -rank() over(distribute by p_mfgr sort by p_name) as r, -dense_rank() over(distribute by p_mfgr sort by p_name) as dr, -round(sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row),2) as s1 -from part -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.65 -Manufacturer#1 almond aquamarine burnished black steel 28 5 4 7117.07 -Manufacturer#1 almond aquamarine pink moccasin thistle 42 6 5 8749.73 -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.36 -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.62 -Manufacturer#5 almond antique blue firebrick mint 31 1 1 1789.69 -Manufacturer#5 almond antique medium spring khaki 6 2 2 3401.35 -Manufacturer#5 almond antique sky peru orange 2 3 3 5190.08 -Manufacturer#5 almond aquamarine dodger light gainsboro 46 4 4 6208.18 -Manufacturer#5 almond azure blanched chiffon midnight 23 5 5 7672.66 -PREHOOK: query: -- 11. testFirstLast -select p_mfgr,p_name, p_size, -sum(p_size) over (distribute by p_mfgr sort by p_name rows between current row and current row) as s2, -first_value(p_size) over w1 as f, -last_value(p_size, false) over w1 as l -from part -window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following) -PREHOOK: type: QUERY -PREHOOK: Input: default@part -#### A masked pattern was here #### -POSTHOOK: query: -- 11. testFirstLast -select p_mfgr,p_name, p_size, -sum(p_size) over (distribute by p_mfgr sort by p_name rows between current row and current row) as s2, -first_value(p_size) over w1 as f, -last_value(p_size, false) over w1 as l -from part -window w1 as (distribute by p_mfgr sort by p_name 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 34 -Manufacturer#1 almond antique burnished rose metallic 2 2 2 6 -Manufacturer#1 almond antique chartreuse lavender yellow 34 34 2 28 -Manufacturer#1 almond antique salmon chartreuse burlywood 6 6 2 42 -Manufacturer#1 almond aquamarine burnished black steel 28 28 34 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 chartreuse khaki white 17 17 17 19 -Manufacturer#3 almond antique forest lavender goldenrod 14 14 17 1 -Manufacturer#3 almond antique metallic orange dim 19 19 17 45 -Manufacturer#3 almond antique misty red olive 1 1 14 45 -Manufacturer#3 almond antique olive coral navajo 45 45 19 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: -- 12. testFirstLastWithWhere -select p_mfgr,p_name, p_size, -rank() over(distribute by p_mfgr sort by p_name) as r, -sum(p_size) over (distribute by p_mfgr sort by p_name rows between current row and current row) as s2, -first_value(p_size) over w1 as f, -last_value(p_size, false) over w1 as l -from part -where p_mfgr = 'Manufacturer#3' -window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following) -PREHOOK: type: QUERY -PREHOOK: Input: default@part -#### A masked pattern was here #### -POSTHOOK: query: -- 12. testFirstLastWithWhere -select p_mfgr,p_name, p_size, -rank() over(distribute by p_mfgr sort by p_name) as r, -sum(p_size) over (distribute by p_mfgr sort by p_name rows between current row and current row) as s2, -first_value(p_size) over w1 as f, -last_value(p_size, false) over w1 as l -from part -where p_mfgr = 'Manufacturer#3' -window w1 as (distribute by p_mfgr sort by p_name 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 2 14 17 1 -Manufacturer#3 almond antique metallic orange dim 19 3 19 17 45 -Manufacturer#3 almond antique misty red olive 1 4 1 14 45 -Manufacturer#3 almond antique olive coral navajo 45 5 45 19 45 -PREHOOK: query: -- 13. testSumWindow -select p_mfgr,p_name, p_size, -sum(p_size) over w1 as s1, -sum(p_size) over (distribute by p_mfgr sort by p_name rows between current row and current row) as s2 -from part -window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following) -PREHOOK: type: QUERY -PREHOOK: Input: default@part -#### A masked pattern was here #### -POSTHOOK: query: -- 13. testSumWindow -select p_mfgr,p_name, p_size, -sum(p_size) over w1 as s1, -sum(p_size) over (distribute by p_mfgr sort by p_name rows between current row and current row) as s2 -from part -window w1 as (distribute by p_mfgr sort by p_name 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 burnished rose metallic 2 44 2 -Manufacturer#1 almond antique chartreuse lavender yellow 34 72 34 -Manufacturer#1 almond antique salmon chartreuse burlywood 6 112 6 -Manufacturer#1 almond aquamarine burnished black steel 28 110 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 chartreuse khaki white 17 50 17 -Manufacturer#3 almond antique forest lavender goldenrod 14 51 14 -Manufacturer#3 almond antique metallic orange dim 19 96 19 -Manufacturer#3 almond antique misty red olive 1 79 1 -Manufacturer#3 almond antique olive coral navajo 45 65 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: -- 14. testNoSortClause -select p_mfgr,p_name, p_size, -rank() over(distribute by p_mfgr sort by p_name) as r, dense_rank() over(distribute by p_mfgr sort by p_name) as dr -from part -window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following) -PREHOOK: type: QUERY -PREHOOK: Input: default@part -#### A masked pattern was here #### -POSTHOOK: query: -- 14. testNoSortClause -select p_mfgr,p_name, p_size, -rank() over(distribute by p_mfgr sort by p_name) as r, dense_rank() over(distribute by p_mfgr sort by p_name) as dr -from part -window w1 as (distribute by p_mfgr sort by p_name 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 burnished rose metallic 2 1 1 -Manufacturer#1 almond antique chartreuse lavender yellow 34 3 2 -Manufacturer#1 almond antique salmon chartreuse burlywood 6 4 3 -Manufacturer#1 almond aquamarine burnished black steel 28 5 4 -Manufacturer#1 almond aquamarine pink moccasin thistle 42 6 5 -Manufacturer#2 almond antique violet chocolate turquoise 14 1 1 -Manufacturer#2 almond antique violet turquoise frosted 40 2 2 -Manufacturer#2 almond aquamarine midnight light salmon 2 3 3 -Manufacturer#2 almond aquamarine rose maroon antique 25 4 4 -Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 5 5 -Manufacturer#3 almond antique chartreuse khaki white 17 1 1 -Manufacturer#3 almond antique forest lavender goldenrod 14 2 2 -Manufacturer#3 almond antique metallic orange dim 19 3 3 -Manufacturer#3 almond antique misty red olive 1 4 4 -Manufacturer#3 almond antique olive coral navajo 45 5 5 -Manufacturer#4 almond antique gainsboro frosted violet 10 1 1 -Manufacturer#4 almond antique violet mint lemon 39 2 2 -Manufacturer#4 almond aquamarine floral ivory bisque 27 3 3 -Manufacturer#4 almond aquamarine yellow dodger mint 7 4 4 -Manufacturer#4 almond azure aquamarine papaya violet 12 5 5 -Manufacturer#5 almond antique blue firebrick mint 31 1 1 -Manufacturer#5 almond antique medium spring khaki 6 2 2 -Manufacturer#5 almond antique sky peru orange 2 3 3 -Manufacturer#5 almond aquamarine dodger light gainsboro 46 4 4 -Manufacturer#5 almond azure blanched chiffon midnight 23 5 5 -PREHOOK: query: -- 15. testExpressions -select p_mfgr,p_name, p_size, -rank() over(distribute by p_mfgr sort by p_name) as r, -dense_rank() over(distribute by p_mfgr sort by p_name) as dr, -cume_dist() over(distribute by p_mfgr sort by p_name) as cud, -percent_rank() over(distribute by p_mfgr sort by p_name) as pr, -ntile(3) over(distribute by p_mfgr sort by p_name) as nt, -count(p_size) over(distribute by p_mfgr sort by p_name) as ca, -avg(p_size) over(distribute by p_mfgr sort by p_name) as avg, -stddev(p_size) over(distribute by p_mfgr sort by p_name) as st, -first_value(p_size % 5) over(distribute by p_mfgr sort by p_name) as fv, -last_value(p_size) over(distribute by p_mfgr sort by p_name) as lv, -first_value(p_size) over w1 as fvW1 -from part -window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) -PREHOOK: type: QUERY -PREHOOK: Input: default@part -#### A masked pattern was here #### -POSTHOOK: query: -- 15. testExpressions -select p_mfgr,p_name, p_size, -rank() over(distribute by p_mfgr sort by p_name) as r, -dense_rank() over(distribute by p_mfgr sort by p_name) as dr, -cume_dist() over(distribute by p_mfgr sort by p_name) as cud, -percent_rank() over(distribute by p_mfgr sort by p_name) as pr, -ntile(3) over(distribute by p_mfgr sort by p_name) as nt, -count(p_size) over(distribute by p_mfgr sort by p_name) as ca, -avg(p_size) over(distribute by p_mfgr sort by p_name) as avg, -stddev(p_size) over(distribute by p_mfgr sort by p_name) as st, -first_value(p_size % 5) over(distribute by p_mfgr sort by p_name) as fv, -last_value(p_size) over(distribute by p_mfgr sort by p_name) as lv, -first_value(p_size) over w1 as fvW1 -from part -window w1 as (distribute by p_mfgr sort by p_mfgr, p_name 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 0 0.0 1 2 2.0 0.0 2 2 2 -Manufacturer#1 almond antique burnished rose metallic 2 1 1 0 0.0 1 2 2.0 0.0 2 2 2 -Manufacturer#1 almond antique chartreuse lavender yellow 34 3 2 0 0.4 2 3 12.666666666666666 15.084944665313014 2 34 2 -Manufacturer#1 almond antique salmon chartreuse burlywood 6 4 3 0 0.6 2 4 11.0 13.379088160259652 2 6 2 -Manufacturer#1 almond aquamarine burnished black steel 28 5 4 0 0.8 3 5 14.4 13.763720427268202 2 28 34 -Manufacturer#1 almond aquamarine pink moccasin thistle 42 6 5 1 1.0 3 6 19.0 16.237815945091466 2 42 6 -Manufacturer#2 almond antique violet chocolate turquoise 14 1 1 0 0.0 1 1 14.0 0.0 4 14 14 -Manufacturer#2 almond antique violet turquoise frosted 40 2 2 0 0.25 1 2 27.0 13.0 4 40 14 -Manufacturer#2 almond aquamarine midnight light salmon 2 3 3 0 0.5 2 3 18.666666666666668 15.86050300449376 4 2 14 -Manufacturer#2 almond aquamarine rose maroon antique 25 4 4 0 0.75 2 4 20.25 14.00669482783144 4 25 40 -Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 5 5 1 1.0 3 5 19.8 12.560254774486067 4 18 2 -Manufacturer#3 almond antique chartreuse khaki white 17 1 1 0 0.0 1 1 17.0 0.0 2 17 17 -Manufacturer#3 almond antique forest lavender goldenrod 14 2 2 0 0.25 1 2 15.5 1.5 2 14 17 -Manufacturer#3 almond antique metallic orange dim 19 3 3 0 0.5 2 3 16.666666666666668 2.0548046676563256 2 19 17 -Manufacturer#3 almond antique misty red olive 1 4 4 0 0.75 2 4 12.75 7.013380069552769 2 1 14 -Manufacturer#3 almond antique olive coral navajo 45 5 5 1 1.0 3 5 19.2 14.344336861632886 2 45 19 -Manufacturer#4 almond antique gainsboro frosted violet 10 1 1 0 0.0 1 1 10.0 0.0 0 10 10 -Manufacturer#4 almond antique violet mint lemon 39 2 2 0 0.25 1 2 24.5 14.5 0 39 10 -Manufacturer#4 almond aquamarine floral ivory bisque 27 3 3 0 0.5 2 3 25.333333333333332 11.897712198383164 0 27 10 -Manufacturer#4 almond aquamarine yellow dodger mint 7 4 4 0 0.75 2 4 20.75 13.007209539328564 0 7 39 -Manufacturer#4 almond azure aquamarine papaya violet 12 5 5 1 1.0 3 5 19.0 12.149074038789951 0 12 27 -Manufacturer#5 almond antique blue firebrick mint 31 1 1 0 0.0 1 1 31.0 0.0 1 31 31 -Manufacturer#5 almond antique medium spring khaki 6 2 2 0 0.25 1 2 18.5 12.5 1 6 31 -Manufacturer#5 almond antique sky peru orange 2 3 3 0 0.5 2 3 13.0 12.832251036613439 1 2 31 -Manufacturer#5 almond aquamarine dodger light gainsboro 46 4 4 0 0.75 2 4 21.25 18.102140757380052 1 46 6 -Manufacturer#5 almond azure blanched chiffon midnight 23 5 5 1 1.0 3 5 21.6 16.206171663906314 1 23 2 -PREHOOK: query: -- 16. testMultipleWindows -select p_mfgr,p_name, p_size, - rank() over(distribute by p_mfgr sort by p_name) as r, - dense_rank() over(distribute by p_mfgr sort by p_name) as dr, -cume_dist() over(distribute by p_mfgr sort by p_name) as cud, -sum(p_size) over (distribute by p_mfgr sort by p_name range between unbounded preceding and current row) as s1, -sum(p_size) over (distribute by p_mfgr sort by p_size range between 5 preceding and current row) as s2, -first_value(p_size) over w1 as fv1 -from part -window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) -PREHOOK: type: QUERY -PREHOOK: Input: default@part -#### A masked pattern was here #### -POSTHOOK: query: -- 16. testMultipleWindows -select p_mfgr,p_name, p_size, - rank() over(distribute by p_mfgr sort by p_name) as r, - dense_rank() over(distribute by p_mfgr sort by p_name) as dr, -cume_dist() over(distribute by p_mfgr sort by p_name) as cud, -sum(p_size) over (distribute by p_mfgr sort by p_name range between unbounded preceding and current row) as s1, -sum(p_size) over (distribute by p_mfgr sort by p_size range between 5 preceding and current row) as s2, -first_value(p_size) over w1 as fv1 -from part -window w1 as (distribute by p_mfgr sort by p_mfgr, p_name 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 0 4 4 2 -Manufacturer#1 almond antique burnished rose metallic 2 1 1 0 4 4 2 -Manufacturer#1 almond antique chartreuse lavender yellow 34 3 2 0 38 34 2 -Manufacturer#1 almond antique salmon chartreuse burlywood 6 4 3 0 44 10 2 -Manufacturer#1 almond aquamarine burnished black steel 28 5 4 0 72 28 34 -Manufacturer#1 almond aquamarine pink moccasin thistle 42 6 5 1 114 42 6 -Manufacturer#2 almond antique violet chocolate turquoise 14 1 1 0 14 14 14 -Manufacturer#2 almond antique violet turquoise frosted 40 2 2 0 54 40 14 -Manufacturer#2 almond aquamarine midnight light salmon 2 3 3 0 56 2 14 -Manufacturer#2 almond aquamarine rose maroon antique 25 4 4 0 81 25 40 -Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 5 5 1 99 32 2 -Manufacturer#3 almond antique chartreuse khaki white 17 1 1 0 17 31 17 -Manufacturer#3 almond antique forest lavender goldenrod 14 2 2 0 31 14 17 -Manufacturer#3 almond antique metallic orange dim 19 3 3 0 50 50 17 -Manufacturer#3 almond antique misty red olive 1 4 4 0 51 1 14 -Manufacturer#3 almond antique olive coral navajo 45 5 5 1 96 45 19 -Manufacturer#4 almond antique gainsboro frosted violet 10 1 1 0 10 17 10 -Manufacturer#4 almond antique violet mint lemon 39 2 2 0 49 39 10 -Manufacturer#4 almond aquamarine floral ivory bisque 27 3 3 0 76 27 10 -Manufacturer#4 almond aquamarine yellow dodger mint 7 4 4 0 83 7 39 -Manufacturer#4 almond azure aquamarine papaya violet 12 5 5 1 95 29 27 -Manufacturer#5 almond antique blue firebrick mint 31 1 1 0 31 31 31 -Manufacturer#5 almond antique medium spring khaki 6 2 2 0 37 8 31 -Manufacturer#5 almond antique sky peru orange 2 3 3 0 39 2 31 -Manufacturer#5 almond aquamarine dodger light gainsboro 46 4 4 0 85 46 6 -Manufacturer#5 almond azure blanched chiffon midnight 23 5 5 1 108 23 2 -PREHOOK: query: -- 17. testCountStar -select p_mfgr,p_name, p_size, -count(*) over(distribute by p_mfgr sort by p_name ) as c, -count(p_size) over(distribute by p_mfgr sort by p_name) as ca, -first_value(p_size) over w1 as fvW1 -from part -window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) -PREHOOK: type: QUERY -PREHOOK: Input: default@part -#### A masked pattern was here #### -POSTHOOK: query: -- 17. testCountStar -select p_mfgr,p_name, p_size, -count(*) over(distribute by p_mfgr sort by p_name ) as c, -count(p_size) over(distribute by p_mfgr sort by p_name) as ca, -first_value(p_size) over w1 as fvW1 -from part -window w1 as (distribute by p_mfgr sort by p_mfgr, p_name 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 burnished rose metallic 2 2 2 2 -Manufacturer#1 almond antique chartreuse lavender yellow 34 3 3 2 -Manufacturer#1 almond antique salmon chartreuse burlywood 6 4 4 2 -Manufacturer#1 almond aquamarine burnished black steel 28 5 5 34 -Manufacturer#1 almond aquamarine pink moccasin thistle 42 6 6 6 -Manufacturer#2 almond antique violet chocolate turquoise 14 1 1 14 -Manufacturer#2 almond antique violet turquoise frosted 40 2 2 14 -Manufacturer#2 almond aquamarine midnight light salmon 2 3 3 14 -Manufacturer#2 almond aquamarine rose maroon antique 25 4 4 40 -Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 5 5 2 -Manufacturer#3 almond antique chartreuse khaki white 17 1 1 17 -Manufacturer#3 almond antique forest lavender goldenrod 14 2 2 17 -Manufacturer#3 almond antique metallic orange dim 19 3 3 17 -Manufacturer#3 almond antique misty red olive 1 4 4 14 -Manufacturer#3 almond antique olive coral navajo 45 5 5 19 -Manufacturer#4 almond antique gainsboro frosted violet 10 1 1 10 -Manufacturer#4 almond antique violet mint lemon 39 2 2 10 -Manufacturer#4 almond aquamarine floral ivory bisque 27 3 3 10 -Manufacturer#4 almond aquamarine yellow dodger mint 7 4 4 39 -Manufacturer#4 almond azure aquamarine papaya violet 12 5 5 27 -Manufacturer#5 almond antique blue firebrick mint 31 1 1 31 -Manufacturer#5 almond antique medium spring khaki 6 2 2 31 -Manufacturer#5 almond antique sky peru orange 2 3 3 31 -Manufacturer#5 almond aquamarine dodger light gainsboro 46 4 4 6 -Manufacturer#5 almond azure blanched chiffon midnight 23 5 5 2 -PREHOOK: query: -- 18. testUDAFs -select p_mfgr,p_name, p_size, -round(sum(p_retailprice) over w1,2) as s, -min(p_retailprice) over w1 as mi, -max(p_retailprice) over w1 as ma, -round(avg(p_retailprice) over w1,2) as ag -from part -window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) -PREHOOK: type: QUERY -PREHOOK: Input: default@part -#### A masked pattern was here #### -POSTHOOK: query: -- 18. testUDAFs -select p_mfgr,p_name, p_size, -round(sum(p_retailprice) over w1,2) as s, -min(p_retailprice) over w1 as mi, -max(p_retailprice) over w1 as ma, -round(avg(p_retailprice) over w1,2) as ag -from part -window w1 as (distribute by p_mfgr sort by p_mfgr, p_name 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 4100.06 1173.15 1753.76 1366.69 -Manufacturer#1 almond antique burnished rose metallic 2 5702.65 1173.15 1753.76 1425.66 -Manufacturer#1 almond antique chartreuse lavender yellow 34 7117.07 1173.15 1753.76 1423.41 -Manufacturer#1 almond antique salmon chartreuse burlywood 6 7576.58 1173.15 1753.76 1515.32 -Manufacturer#1 almond aquamarine burnished black steel 28 6403.43 1414.42 1753.76 1600.86 -Manufacturer#1 almond aquamarine pink moccasin thistle 42 4649.67 1414.42 1632.66 1549.89 -Manufacturer#2 almond antique violet chocolate turquoise 14 5523.36 1690.68 2031.98 1841.12 -Manufacturer#2 almond antique violet turquoise frosted 40 7222.02 1690.68 2031.98 1805.51 -Manufacturer#2 almond aquamarine midnight light salmon 2 8923.62 1690.68 2031.98 1784.72 -Manufacturer#2 almond aquamarine rose maroon antique 25 7232.94 1698.66 2031.98 1808.24 -Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 5432.24 1698.66 2031.98 1810.75 -Manufacturer#3 almond antique chartreuse khaki white 17 4272.34 1190.27 1671.68 1424.11 -Manufacturer#3 almond antique forest lavender goldenrod 14 6195.32 1190.27 1922.98 1548.83 -Manufacturer#3 almond antique metallic orange dim 19 7532.61 1190.27 1922.98 1506.52 -Manufacturer#3 almond antique misty red olive 1 5860.93 1190.27 1922.98 1465.23 -Manufacturer#3 almond antique olive coral navajo 45 4670.66 1337.29 1922.98 1556.89 -Manufacturer#4 almond antique gainsboro frosted violet 10 4202.35 1206.26 1620.67 1400.78 -Manufacturer#4 almond antique violet mint lemon 39 6047.27 1206.26 1844.92 1511.82 -Manufacturer#4 almond aquamarine floral ivory bisque 27 7337.62 1206.26 1844.92 1467.52 -Manufacturer#4 almond aquamarine yellow dodger mint 7 5716.95 1206.26 1844.92 1429.24 -Manufacturer#4 almond azure aquamarine papaya violet 12 4341.53 1206.26 1844.92 1447.18 -Manufacturer#5 almond antique blue firebrick mint 31 5190.08 1611.66 1789.69 1730.03 -Manufacturer#5 almond antique medium spring khaki 6 6208.18 1018.1 1789.69 1552.05 -Manufacturer#5 almond antique sky peru orange 2 7672.66 1018.1 1789.69 1534.53 -Manufacturer#5 almond aquamarine dodger light gainsboro 46 5882.97 1018.1 1788.73 1470.74 -Manufacturer#5 almond azure blanched chiffon midnight 23 4271.31 1018.1 1788.73 1423.77 -PREHOOK: query: -- 19. testUDAFsWithGBY -select p_mfgr,p_name, p_size, p_retailprice, -round(sum(p_retailprice) over w1,2) as s, -min(p_retailprice) as mi , -max(p_retailprice) as ma , -round(avg(p_retailprice) over w1,2) as ag -from part -group by p_mfgr,p_name, p_size, p_retailprice -window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) -PREHOOK: type: QUERY -PREHOOK: Input: default@part -#### A masked pattern was here #### -POSTHOOK: query: -- 19. testUDAFsWithGBY -select p_mfgr,p_name, p_size, p_retailprice, -round(sum(p_retailprice) over w1,2) as s, -min(p_retailprice) as mi , -max(p_retailprice) as ma , -round(avg(p_retailprice) over w1,2) as ag -from part -group by p_mfgr,p_name, p_size, p_retailprice -window w1 as (distribute by p_mfgr sort by p_mfgr, p_name 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 1173.15 4529.5 1173.15 1173.15 1509.83 -Manufacturer#1 almond antique chartreuse lavender yellow 34 1753.76 5943.92 1753.76 1753.76 1485.98 -Manufacturer#1 almond antique salmon chartreuse burlywood 6 1602.59 7576.58 1602.59 1602.59 1515.32 -Manufacturer#1 almond aquamarine burnished black steel 28 1414.42 6403.43 1414.42 1414.42 1600.86 -Manufacturer#1 almond aquamarine pink moccasin thistle 42 1632.66 4649.67 1632.66 1632.66 1549.89 -Manufacturer#2 almond antique violet chocolate turquoise 14 1690.68 5523.36 1690.68 1690.68 1841.12 -Manufacturer#2 almond antique violet turquoise frosted 40 1800.7 7222.02 1800.7 1800.7 1805.51 -Manufacturer#2 almond aquamarine midnight light salmon 2 2031.98 8923.62 2031.98 2031.98 1784.72 -Manufacturer#2 almond aquamarine rose maroon antique 25 1698.66 7232.94 1698.66 1698.66 1808.24 -Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 1701.6 5432.24 1701.6 1701.6 1810.75 -Manufacturer#3 almond antique chartreuse khaki white 17 1671.68 4272.34 1671.68 1671.68 1424.11 -Manufacturer#3 almond antique forest lavender goldenrod 14 1190.27 6195.32 1190.27 1190.27 1548.83 -Manufacturer#3 almond antique metallic orange dim 19 1410.39 7532.61 1410.39 1410.39 1506.52 -Manufacturer#3 almond antique misty red olive 1 1922.98 5860.93 1922.98 1922.98 1465.23 -Manufacturer#3 almond antique olive coral navajo 45 1337.29 4670.66 1337.29 1337.29 1556.89 -Manufacturer#4 almond antique gainsboro frosted violet 10 1620.67 4202.35 1620.67 1620.67 1400.78 -Manufacturer#4 almond antique violet mint lemon 39 1375.42 6047.27 1375.42 1375.42 1511.82 -Manufacturer#4 almond aquamarine floral ivory bisque 27 1206.26 7337.62 1206.26 1206.26 1467.52 -Manufacturer#4 almond aquamarine yellow dodger mint 7 1844.92 5716.95 1844.92 1844.92 1429.24 -Manufacturer#4 almond azure aquamarine papaya violet 12 1290.35 4341.53 1290.35 1290.35 1447.18 -Manufacturer#5 almond antique blue firebrick mint 31 1789.69 5190.08 1789.69 1789.69 1730.03 -Manufacturer#5 almond antique medium spring khaki 6 1611.66 6208.18 1611.66 1611.66 1552.05 -Manufacturer#5 almond antique sky peru orange 2 1788.73 7672.66 1788.73 1788.73 1534.53 -Manufacturer#5 almond aquamarine dodger light gainsboro 46 1018.1 5882.97 1018.1 1018.1 1470.74 -Manufacturer#5 almond azure blanched chiffon midnight 23 1464.48 4271.31 1464.48 1464.48 1423.77 -PREHOOK: query: -- 20. testSTATs -select p_mfgr,p_name, p_size, -stddev(p_retailprice) over w1 as sdev, -stddev_pop(p_retailprice) over w1 as sdev_pop, -collect_set(p_size) over w1 as uniq_size, -variance(p_retailprice) over w1 as var, -corr(p_size, p_retailprice) over w1 as cor, -covar_pop(p_size, p_retailprice) over w1 as covarp -from part -window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) -PREHOOK: type: QUERY -PREHOOK: Input: default@part -#### A masked pattern was here #### -POSTHOOK: query: -- 20. testSTATs -select p_mfgr,p_name, p_size, -stddev(p_retailprice) over w1 as sdev, -stddev_pop(p_retailprice) over w1 as sdev_pop, -collect_set(p_size) over w1 as uniq_size, -variance(p_retailprice) over w1 as var, -corr(p_size, p_retailprice) over w1 as cor, -covar_pop(p_size, p_retailprice) over w1 as covarp -from part -window w1 as (distribute by p_mfgr sort by p_mfgr, p_name 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 258.10677784349235 258.10677784349235 [2,34,6] 66619.10876874991 0.811328754177887 2801.7074999999995 -Manufacturer#1 almond antique burnished rose metallic 2 273.70217881648074 273.70217881648074 [2,34] 74912.8826888888 1.0 4128.782222222221 -Manufacturer#1 almond antique chartreuse lavender yellow 34 230.90151585470358 230.90151585470358 [2,34,6,28] 53315.51002399992 0.695639377397664 2210.7864 -Manufacturer#1 almond antique salmon chartreuse burlywood 6 202.73109328368946 202.73109328368946 [2,34,6,28,42] 41099.896184 0.630785977101214 2009.9536000000007 -Manufacturer#1 almond aquamarine burnished black steel 28 121.6064517973862 121.6064517973862 [34,6,28,42] 14788.129118750014 0.2036684720435979 331.1337500000004 -Manufacturer#1 almond aquamarine pink moccasin thistle 42 96.5751586416853 96.5751586416853 [6,28,42] 9326.761266666683 -1.4442181184933883E-4 -0.20666666666708502 -Manufacturer#2 almond antique violet chocolate turquoise 14 142.2363169751898 142.2363169751898 [14,40,2] 20231.169866666663 -0.49369526554523185 -1113.7466666666658 -Manufacturer#2 almond antique violet turquoise frosted 40 137.76306498840682 137.76306498840682 [14,40,2,25] 18978.662075 -0.5205630897335946 -1004.4812499999995 -Manufacturer#2 almond aquamarine midnight light salmon 2 130.03972279269132 130.03972279269132 [14,40,2,25,18] 16910.329504000005 -0.46908967495720255 -766.1791999999995 -Manufacturer#2 almond aquamarine rose maroon antique 25 135.55100986344584 135.55100986344584 [40,2,25,18] 18374.07627499999 -0.6091405874714462 -1128.1787499999987 -Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 156.44019460768044 156.44019460768044 [2,25,18] 24473.534488888927 -0.9571686373491608 -1441.4466666666676 -Manufacturer#3 almond antique chartreuse khaki white 17 196.7742266885805 196.7742266885805 [17,14,19] 38720.09628888887 0.5557168646224995 224.6944444444446 -Manufacturer#3 almond antique forest lavender goldenrod 14 275.14144189852607 275.14144189852607 [17,14,19,1] 75702.81305 -0.6720833036576083 -1296.9000000000003 -Manufacturer#3 almond antique metallic orange dim 19 260.23473614412046 260.23473614412046 [17,14,19,1,45] 67722.117896 -0.5703526513979519 -2129.0664 -Manufacturer#3 almond antique misty red olive 1 275.9139962356932 275.9139962356932 [14,19,1,45] 76128.53331875012 -0.577476899644802 -2547.7868749999993 -Manufacturer#3 almond antique olive coral navajo 45 260.5815918713796 260.5815918713796 [19,1,45] 67902.76602222225 -0.8710736366736884 -4099.731111111111 -Manufacturer#4 almond antique gainsboro frosted violet 10 170.13011889596618 170.13011889596618 [10,39,27] 28944.25735555559 -0.6656975320098423 -1347.4777777777779 -Manufacturer#4 almond antique violet mint lemon 39 242.26834609323197 242.26834609323197 [10,39,27,7] 58693.95151875002 -0.8051852719193339 -2537.328125 -Manufacturer#4 almond aquamarine floral ivory bisque 27 234.10001662537326 234.10001662537326 [10,39,27,7,12] 54802.817784000035 -0.6046935574240581 -1719.8079999999995 -Manufacturer#4 almond aquamarine yellow dodger mint 7 247.3342714197732 247.3342714197732 [39,27,7,12] 61174.24181875003 -0.5508665654707869 -1719.0368749999975 -Manufacturer#4 almond azure aquamarine papaya violet 12 283.3344330566893 283.3344330566893 [27,7,12] 80278.40095555557 -0.7755740084632333 -1867.4888888888881 -Manufacturer#5 almond antique blue firebrick mint 31 83.69879024746363 83.69879024746363 [31,6,2] 7005.487488888913 0.39004303087285047 418.9233333333353 -Manufacturer#5 almond antique medium spring khaki 6 316.68049612345885 316.68049612345885 [31,6,2,46] 100286.53662500004 -0.713612911776183 -4090.853749999999 -Manufacturer#5 almond antique sky peru orange 2 285.40506298242155 285.40506298242155 [31,6,2,46,23] 81456.04997600002 -0.712858514567818 -3297.2011999999986 -Manufacturer#5 almond aquamarine dodger light gainsboro 46 285.43749038756283 285.43749038756283 [6,2,46,23] 81474.56091875004 -0.984128787153391 -4871.028125000002 -Manufacturer#5 almond azure blanched chiffon midnight 23 315.9225931564038 315.9225931564038 [2,46,23] 99807.08486666664 -0.9978877469246936 -5664.856666666666 -PREHOOK: query: -- 21. testDISTs -select p_mfgr,p_name, p_size, -histogram_numeric(p_retailprice, 5) over w1 as hist, -percentile(p_partkey, 0.5) over w1 as per, -row_number() over(distribute by p_mfgr sort by p_mfgr, p_name) as rn -from part -window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) -PREHOOK: type: QUERY -PREHOOK: Input: default@part -#### A masked pattern was here #### -POSTHOOK: query: -- 21. testDISTs -select p_mfgr,p_name, p_size, -histogram_numeric(p_retailprice, 5) over w1 as hist, -percentile(p_partkey, 0.5) over w1 as per, -row_number() over(distribute by p_mfgr sort by p_mfgr, p_name) as rn -from part -window w1 as (distribute by p_mfgr sort by p_mfgr, p_name 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 [{"x":1173.15,"y":2.0},{"x":1602.59,"y":1.0},{"x":1753.76,"y":1.0}] 115872.0 2 -Manufacturer#1 almond antique burnished rose metallic 2 [{"x":1173.15,"y":2.0},{"x":1753.76,"y":1.0}] 121152.0 1 -Manufacturer#1 almond antique chartreuse lavender yellow 34 [{"x":1173.15,"y":2.0},{"x":1414.42,"y":1.0},{"x":1602.59,"y":1.0},{"x":1753.76,"y":1.0}] 110592.0 3 -Manufacturer#1 almond antique salmon chartreuse burlywood 6 [{"x":1173.15,"y":1.0},{"x":1414.42,"y":1.0},{"x":1602.59,"y":1.0},{"x":1632.66,"y":1.0},{"x":1753.76,"y":1.0}] 86428.0 4 -Manufacturer#1 almond aquamarine burnished black steel 28 [{"x":1414.42,"y":1.0},{"x":1602.59,"y":1.0},{"x":1632.66,"y":1.0},{"x":1753.76,"y":1.0}] 86098.0 5 -Manufacturer#1 almond aquamarine pink moccasin thistle 42 [{"x":1414.42,"y":1.0},{"x":1602.59,"y":1.0},{"x":1632.66,"y":1.0}] 86428.0 6 -Manufacturer#2 almond antique violet chocolate turquoise 14 [{"x":1690.68,"y":1.0},{"x":1800.7,"y":1.0},{"x":2031.98,"y":1.0}] 146985.0 1 -Manufacturer#2 almond antique violet turquoise frosted 40 [{"x":1690.68,"y":1.0},{"x":1698.66,"y":1.0},{"x":1800.7,"y":1.0},{"x":2031.98,"y":1.0}] 139825.5 2 -Manufacturer#2 almond aquamarine midnight light salmon 2 [{"x":1690.68,"y":1.0},{"x":1698.66,"y":1.0},{"x":1701.6,"y":1.0},{"x":1800.7,"y":1.0},{"x":2031.98,"y":1.0}] 146985.0 3 -Manufacturer#2 almond aquamarine rose maroon antique 25 [{"x":1698.66,"y":1.0},{"x":1701.6,"y":1.0},{"x":1800.7,"y":1.0},{"x":2031.98,"y":1.0}] 169347.0 4 -Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 [{"x":1698.66,"y":1.0},{"x":1701.6,"y":1.0},{"x":2031.98,"y":1.0}] 146985.0 5 -Manufacturer#3 almond antique chartreuse khaki white 17 [{"x":1190.27,"y":1.0},{"x":1410.39,"y":1.0},{"x":1671.68,"y":1.0}] 90681.0 1 -Manufacturer#3 almond antique forest lavender goldenrod 14 [{"x":1190.27,"y":1.0},{"x":1410.39,"y":1.0},{"x":1671.68,"y":1.0},{"x":1922.98,"y":1.0}] 65831.5 2 -Manufacturer#3 almond antique metallic orange dim 19 [{"x":1190.27,"y":1.0},{"x":1337.29,"y":1.0},{"x":1410.39,"y":1.0},{"x":1671.68,"y":1.0},{"x":1922.98,"y":1.0}] 90681.0 3 -Manufacturer#3 almond antique misty red olive 1 [{"x":1190.27,"y":1.0},{"x":1337.29,"y":1.0},{"x":1410.39,"y":1.0},{"x":1922.98,"y":1.0}] 76690.0 4 -Manufacturer#3 almond antique olive coral navajo 45 [{"x":1337.29,"y":1.0},{"x":1410.39,"y":1.0},{"x":1922.98,"y":1.0}] 112398.0 5 -Manufacturer#4 almond antique gainsboro frosted violet 10 [{"x":1206.26,"y":1.0},{"x":1375.42,"y":1.0},{"x":1620.67,"y":1.0}] 48427.0 1 -Manufacturer#4 almond antique violet mint lemon 39 [{"x":1206.26,"y":1.0},{"x":1375.42,"y":1.0},{"x":1620.67,"y":1.0},{"x":1844.92,"y":1.0}] 46844.0 2 -Manufacturer#4 almond aquamarine floral ivory bisque 27 [{"x":1206.26,"y":1.0},{"x":1290.35,"y":1.0},{"x":1375.42,"y":1.0},{"x":1620.67,"y":1.0},{"x":1844.92,"y":1.0}] 45261.0 3 -Manufacturer#4 almond aquamarine yellow dodger mint 7 [{"x":1206.26,"y":1.0},{"x":1290.35,"y":1.0},{"x":1375.42,"y":1.0},{"x":1844.92,"y":1.0}] 39309.0 4 -Manufacturer#4 almond azure aquamarine papaya violet 12 [{"x":1206.26,"y":1.0},{"x":1290.35,"y":1.0},{"x":1844.92,"y":1.0}] 33357.0 5 -Manufacturer#5 almond antique blue firebrick mint 31 [{"x":1611.66,"y":1.0},{"x":1788.73,"y":1.0},{"x":1789.69,"y":1.0}] 155733.0 1 -Manufacturer#5 almond antique medium spring khaki 6 [{"x":1018.1,"y":1.0},{"x":1611.66,"y":1.0},{"x":1788.73,"y":1.0},{"x":1789.69,"y":1.0}] 99201.0 2 -Manufacturer#5 almond antique sky peru orange 2 [{"x":1018.1,"y":1.0},{"x":1464.48,"y":1.0},{"x":1611.66,"y":1.0},{"x":1788.73,"y":1.0},{"x":1789.69,"y":1.0}] 78486.0 3 -Manufacturer#5 almond aquamarine dodger light gainsboro 46 [{"x":1018.1,"y":1.0},{"x":1464.48,"y":1.0},{"x":1611.66,"y":1.0},{"x":1788.73,"y":1.0}] 60577.5 4 -Manufacturer#5 almond azure blanched chiffon midnight 23 [{"x":1018.1,"y":1.0},{"x":1464.48,"y":1.0},{"x":1788.73,"y":1.0}] 78486.0 5 -PREHOOK: query: -- 22. testViewAsTableInputWithWindowing -create view IF NOT EXISTS mfgr_price_view as -select p_mfgr, p_brand, -round(sum(p_retailprice),2) as s -from part -group by p_mfgr, p_brand -PREHOOK: type: CREATEVIEW -PREHOOK: Input: default@part -PREHOOK: Output: database:default -PREHOOK: Output: default@mfgr_price_view -POSTHOOK: query: -- 22. testViewAsTableInputWithWindowing -create view IF NOT EXISTS mfgr_price_view as -select p_mfgr, p_brand, -round(sum(p_retailprice),2) as s -from part -group by p_mfgr, p_brand -POSTHOOK: type: CREATEVIEW -POSTHOOK: Input: default@part -POSTHOOK: Output: database:default -POSTHOOK: Output: default@mfgr_price_view -PREHOOK: query: select * -from ( -select p_mfgr, p_brand, s, -round(sum(s) over w1 , 2) as s1 -from mfgr_price_view -window w1 as (distribute by p_mfgr sort by p_mfgr ) -) sq -order by p_mfgr, p_brand -PREHOOK: type: QUERY -PREHOOK: Input: default@mfgr_price_view -PREHOOK: Input: default@part -#### A masked pattern was here #### -POSTHOOK: query: select * -from ( -select p_mfgr, p_brand, s, -round(sum(s) over w1 , 2) as s1 -from mfgr_price_view -window w1 as (distribute by p_mfgr sort by p_mfgr ) -) sq -order by p_mfgr, p_brand -POSTHOOK: type: QUERY -POSTHOOK: Input: default@mfgr_price_view -POSTHOOK: Input: default@part -#### A masked pattern was here #### -Manufacturer#1 Brand#12 4800.84 8749.73 -Manufacturer#1 Brand#14 2346.3 8749.73 -Manufacturer#1 Brand#15 1602.59 8749.73 -Manufacturer#2 Brand#22 3491.38 8923.62 -Manufacturer#2 Brand#23 2031.98 8923.62 -Manufacturer#2 Brand#24 1698.66 8923.62 -Manufacturer#2 Brand#25 1701.6 8923.62 -Manufacturer#3 Brand#31 1671.68 7532.61 -Manufacturer#3 Brand#32 3333.37 7532.61 -Manufacturer#3 Brand#34 1337.29 7532.61 -Manufacturer#3 Brand#35 1190.27 7532.61 -Manufacturer#4 Brand#41 4755.94 7337.62 -Manufacturer#4 Brand#42 2581.68 7337.62 -Manufacturer#5 Brand#51 1611.66 7672.66 -Manufacturer#5 Brand#52 3254.17 7672.66 -Manufacturer#5 Brand#53 2806.83 7672.66 -PREHOOK: query: select p_mfgr, p_brand, s, -round(sum(s) over w1 ,2) as s1 -from mfgr_price_view -window w1 as (distribute by p_mfgr sort 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: select p_mfgr, p_brand, s, -round(sum(s) over w1 ,2) as s1 -from mfgr_price_view -window w1 as (distribute by p_mfgr sort 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.36 -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.94 4755.94 -Manufacturer#4 Brand#42 2581.68 7337.62 -Manufacturer#5 Brand#51 1611.66 1611.66 -Manufacturer#5 Brand#52 3254.17 4865.83 -Manufacturer#5 Brand#53 2806.83 7672.66 -PREHOOK: query: -- 23. testCreateViewWithWindowingQuery -create view IF NOT EXISTS mfgr_brand_price_view as -select p_mfgr, p_brand, -round(sum(p_retailprice) over w1,2) as s -from part -window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and current row) -PREHOOK: type: CREATEVIEW -PREHOOK: Input: default@part -PREHOOK: Output: database:default -PREHOOK: Output: default@mfgr_brand_price_view -POSTHOOK: query: -- 23. testCreateViewWithWindowingQuery -create view IF NOT EXISTS mfgr_brand_price_view as -select p_mfgr, p_brand, -round(sum(p_retailprice) over w1,2) as s -from part -window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and current row) -POSTHOOK: type: CREATEVIEW -POSTHOOK: Input: default@part -POSTHOOK: Output: database:default -POSTHOOK: Output: default@mfgr_brand_price_view -PREHOOK: query: select * from mfgr_brand_price_view -PREHOOK: type: QUERY -PREHOOK: Input: default@mfgr_brand_price_view -PREHOOK: Input: default@part -#### A masked pattern was here #### -POSTHOOK: query: select * from mfgr_brand_price_view -POSTHOOK: type: QUERY -POSTHOOK: Input: default@mfgr_brand_price_view -POSTHOOK: Input: default@part -#### A masked pattern was here #### -Manufacturer#1 Brand#12 4100.06 -Manufacturer#1 Brand#12 4649.67 -Manufacturer#1 Brand#12 4770.77 -Manufacturer#1 Brand#14 1173.15 -Manufacturer#1 Brand#14 2346.3 -Manufacturer#1 Brand#15 4529.5 -Manufacturer#2 Brand#22 1690.68 -Manufacturer#2 Brand#22 3491.38 -Manufacturer#2 Brand#23 5523.36 -Manufacturer#2 Brand#24 5531.34 -Manufacturer#2 Brand#25 5432.24 -Manufacturer#3 Brand#31 1671.68 -Manufacturer#3 Brand#32 4272.34 -Manufacturer#3 Brand#32 4523.64 -Manufacturer#3 Brand#34 4670.66 -Manufacturer#3 Brand#35 2861.95 -Manufacturer#4 Brand#41 1620.67 -Manufacturer#4 Brand#41 4341.53 -Manufacturer#4 Brand#41 4426.6 -Manufacturer#4 Brand#42 2996.09 -Manufacturer#4 Brand#42 4202.35 -Manufacturer#5 Brand#51 3401.35 -Manufacturer#5 Brand#52 1789.69 -Manufacturer#5 Brand#52 4271.31 -Manufacturer#5 Brand#53 4418.49 -Manufacturer#5 Brand#53 5190.08 -PREHOOK: query: -- 24. testLateralViews -select p_mfgr, p_name, -lv_col, p_size, sum(p_size) over w1 as s -from (select p_mfgr, p_name, p_size, array(1,2,3) arr from part) p -lateral view explode(arr) part_lv as lv_col -window w1 as (distribute by p_mfgr sort by p_size, lv_col rows between 2 preceding and current row) -PREHOOK: type: QUERY -PREHOOK: Input: default@part -#### A masked pattern was here #### -POSTHOOK: query: -- 24. testLateralViews -select p_mfgr, p_name, -lv_col, p_size, sum(p_size) over w1 as s -from (select p_mfgr, p_name, p_size, array(1,2,3) arr from part) p -lateral view explode(arr) part_lv as lv_col -window w1 as (distribute by p_mfgr sort by p_size, lv_col rows between 2 preceding and current row) -POSTHOOK: type: QUERY -POSTHOOK: Input: default@part -#### A masked pattern was here #### -Manufacturer#1 almond antique burnished rose metallic 1 2 2 -Manufacturer#1 almond antique burnished rose metallic 1 2 4 -Manufacturer#1 almond antique burnished rose metallic 2 2 6 -Manufacturer#1 almond antique burnished rose metallic 2 2 6 -Manufacturer#1 almond antique burnished rose metallic 3 2 6 -Manufacturer#1 almond antique burnished rose metallic 3 2 6 -Manufacturer#1 almond antique chartreuse lavender yellow 1 34 90 -Manufacturer#1 almond antique chartreuse lavender yellow 2 34 96 -Manufacturer#1 almond antique chartreuse lavender yellow 3 34 102 -Manufacturer#1 almond antique salmon chartreuse burlywood 1 6 10 -Manufacturer#1 almond antique salmon chartreuse burlywood 2 6 14 -Manufacturer#1 almond antique salmon chartreuse burlywood 3 6 18 -Manufacturer#1 almond aquamarine burnished black steel 1 28 40 -Manufacturer#1 almond aquamarine burnished black steel 2 28 62 -Manufacturer#1 almond aquamarine burnished black steel 3 28 84 -Manufacturer#1 almond aquamarine pink moccasin thistle 1 42 110 -Manufacturer#1 almond aquamarine pink moccasin thistle 2 42 118 -Manufacturer#1 almond aquamarine pink moccasin thistle 3 42 126 -Manufacturer#2 almond antique violet chocolate turquoise 1 14 18 -Manufacturer#2 almond antique violet chocolate turquoise 2 14 30 -Manufacturer#2 almond antique violet chocolate turquoise 3 14 42 -Manufacturer#2 almond antique violet turquoise frosted 1 40 90 -Manufacturer#2 almond antique violet turquoise frosted 2 40 105 -Manufacturer#2 almond antique violet turquoise frosted 3 40 120 -Manufacturer#2 almond aquamarine midnight light salmon 1 2 2 -Manufacturer#2 almond aquamarine midnight light salmon 2 2 4 -Manufacturer#2 almond aquamarine midnight light salmon 3 2 6 -Manufacturer#2 almond aquamarine rose maroon antique 1 25 61 -Manufacturer#2 almond aquamarine rose maroon antique 2 25 68 -Manufacturer#2 almond aquamarine rose maroon antique 3 25 75 -Manufacturer#2 almond aquamarine sandy cyan gainsboro 1 18 46 -Manufacturer#2 almond aquamarine sandy cyan gainsboro 2 18 50 -Manufacturer#2 almond aquamarine sandy cyan gainsboro 3 18 54 -Manufacturer#3 almond antique chartreuse khaki white 1 17 45 -Manufacturer#3 almond antique chartreuse khaki white 2 17 48 -Manufacturer#3 almond antique chartreuse khaki white 3 17 51 -Manufacturer#3 almond antique forest lavender goldenrod 1 14 16 -Manufacturer#3 almond antique forest lavender goldenrod 2 14 29 -Manufacturer#3 almond antique forest lavender goldenrod 3 14 42 -Manufacturer#3 almond antique metallic orange dim 1 19 53 -Manufacturer#3 almond antique metallic orange dim 2 19 55 -Manufacturer#3 almond antique metallic orange dim 3 19 57 -Manufacturer#3 almond antique misty red olive 1 1 1 -Manufacturer#3 almond antique misty red olive 2 1 2 -Manufacturer#3 almond antique misty red olive 3 1 3 -Manufacturer#3 almond antique olive coral navajo 1 45 83 -Manufacturer#3 almond antique olive coral navajo 2 45 109 -Manufacturer#3 almond antique olive coral navajo 3 45 135 -Manufacturer#4 almond antique gainsboro frosted violet 1 10 24 -Manufacturer#4 almond antique gainsboro frosted violet 2 10 27 -Manufacturer#4 almond antique gainsboro frosted violet 3 10 30 -Manufacturer#4 almond antique violet mint lemon 1 39 93 -Manufacturer#4 almond antique violet mint lemon 2 39 105 -Manufacturer#4 almond antique violet mint lemon 3 39 117 -Manufacturer#4 almond aquamarine floral ivory bisque 1 27 51 -Manufacturer#4 almond aquamarine floral ivory bisque 2 27 66 -Manufacturer#4 almond aquamarine floral ivory bisque 3 27 81 -Manufacturer#4 almond aquamarine yellow dodger mint 1 7 7 -Manufacturer#4 almond aquamarine yellow dodger mint 2 7 14 -Manufacturer#4 almond aquamarine yellow dodger mint 3 7 21 -Manufacturer#4 almond azure aquamarine papaya violet 1 12 32 -Manufacturer#4 almond azure aquamarine papaya violet 2 12 34 -Manufacturer#4 almond azure aquamarine papaya violet 3 12 36 -Manufacturer#5 almond antique blue firebrick mint 1 31 77 -Manufacturer#5 almond antique blue firebrick mint 2 31 85 -Manufacturer#5 almond antique blue firebrick mint 3 31 93 -Manufacturer#5 almond antique medium spring khaki 1 6 10 -Manufacturer#5 almond antique medium spring khaki 2 6 14 -Manufacturer#5 almond antique medium spring khaki 3 6 18 -Manufacturer#5 almond antique sky peru orange 1 2 2 -Manufacturer#5 almond antique sky peru orange 2 2 4 -Manufacturer#5 almond antique sky peru orange 3 2 6 -Manufacturer#5 almond aquamarine dodger light gainsboro 1 46 108 -Manufacturer#5 almond aquamarine dodger light gainsboro 2 46 123 -Manufacturer#5 almond aquamarine dodger light gainsboro 3 46 138 -Manufacturer#5 almond azure blanched chiffon midnight 1 23 35 -Manufacturer#5 almond azure blanched chiffon midnight 2 23 52 -Manufacturer#5 almond azure blanched chiffon midnight 3 23 69 -PREHOOK: query: -- 25. testMultipleInserts3SWQs -CREATE TABLE part_1( -p_mfgr STRING, -p_name STRING, -p_size INT, -r INT, -dr INT, -s DOUBLE) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@part_1 -POSTHOOK: query: -- 25. testMultipleInserts3SWQs -CREATE TABLE part_1( -p_mfgr STRING, -p_name STRING, -p_size INT, -r INT, -dr INT, -s DOUBLE) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@part_1 -PREHOOK: query: CREATE TABLE part_2( -p_mfgr STRING, -p_name STRING, -p_size INT, -r INT, -dr INT, -cud INT, -s2 DOUBLE, -fv1 INT) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@part_2 -POSTHOOK: query: CREATE TABLE part_2( -p_mfgr STRING, -p_name STRING, -p_size INT, -r INT, -dr INT, -cud INT, -s2 DOUBLE, -fv1 INT) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@part_2 -PREHOOK: query: CREATE TABLE part_3( -p_mfgr STRING, -p_name STRING, -p_size INT, -c INT, -ca INT, -fv INT) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@part_3 -POSTHOOK: query: CREATE TABLE part_3( -p_mfgr STRING, -p_name STRING, -p_size INT, -c INT, -ca INT, -fv INT) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@part_3 -PREHOOK: query: from part -INSERT OVERWRITE TABLE part_1 -select p_mfgr, p_name, p_size, -rank() over(distribute by p_mfgr sort by p_name ) as r, -dense_rank() over(distribute by p_mfgr sort by p_name ) as dr, -round(sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row),2) as s -INSERT OVERWRITE TABLE part_2 -select p_mfgr,p_name, p_size, -rank() over(distribute by p_mfgr sort by p_name) as r, -dense_rank() over(distribute by p_mfgr sort by p_name) as dr, -cume_dist() over(distribute by p_mfgr sort by p_name) as cud, -round(sum(p_size) over (distribute by p_mfgr sort by p_size range between 5 preceding and current row),1) as s2, -first_value(p_size) over w1 as fv1 -window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) -INSERT OVERWRITE TABLE part_3 -select p_mfgr,p_name, p_size, -count(*) over(distribute by p_mfgr sort by p_name) as c, -count(p_size) over(distribute by p_mfgr sort by p_name) as ca, -first_value(p_size) over w1 as fv -window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) -PREHOOK: type: QUERY -PREHOOK: Input: default@part -PREHOOK: Output: default@part_1 -PREHOOK: Output: default@part_2 -PREHOOK: Output: default@part_3 -POSTHOOK: query: from part -INSERT OVERWRITE TABLE part_1 -select p_mfgr, p_name, p_size, -rank() over(distribute by p_mfgr sort by p_name ) as r, -dense_rank() over(distribute by p_mfgr sort by p_name ) as dr, -round(sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row),2) as s -INSERT OVERWRITE TABLE part_2 -select p_mfgr,p_name, p_size, -rank() over(distribute by p_mfgr sort by p_name) as r, -dense_rank() over(distribute by p_mfgr sort by p_name) as dr, -cume_dist() over(distribute by p_mfgr sort by p_name) as cud, -round(sum(p_size) over (distribute by p_mfgr sort by p_size range between 5 preceding and current row),1) as s2, -first_value(p_size) over w1 as fv1 -window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) -INSERT OVERWRITE TABLE part_3 -select p_mfgr,p_name, p_size, -count(*) over(distribute by p_mfgr sort by p_name) as c, -count(p_size) over(distribute by p_mfgr sort by p_name) as ca, -first_value(p_size) over w1 as fv -window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) -POSTHOOK: type: QUERY -POSTHOOK: Input: default@part -POSTHOOK: Output: default@part_1 -POSTHOOK: Output: default@part_2 -POSTHOOK: Output: default@part_3 -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), ] -POSTHOOK: Lineage: part_1.p_mfgr SIMPLE [(part)part.FieldSchema(name:p_mfgr, type:string, comment:null), ] -POSTHOOK: Lineage: part_1.p_name SIMPLE [(part)part.FieldSchema(name:p_name, type:string, comment:null), ] -POSTHOOK: Lineage: part_1.p_size SIMPLE [(part)part.FieldSchema(name:p_size, type:int, comment:null), ] -POSTHOOK: Lineage: part_1.r 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), ] -POSTHOOK: Lineage: part_1.s 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), ] -POSTHOOK: Lineage: part_2.cud 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), ] -POSTHOOK: Lineage: part_2.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), ] -POSTHOOK: Lineage: part_2.fv1 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), ] -POSTHOOK: Lineage: part_2.p_mfgr SIMPLE [(part)part.FieldSchema(name:p_mfgr, type:string, comment:null), ] -POSTHOOK: Lineage: part_2.p_name SIMPLE [(part)part.FieldSchema(name:p_name, type:string, comment:null), ] -POSTHOOK: Lineage: part_2.p_size SIMPLE [(part)part.FieldSchema(name:p_size, type:int, comment:null), ] -POSTHOOK: Lineage: part_2.r 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), ] -POSTHOOK: Lineage: part_2.s2 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), ] -POSTHOOK: Lineage: part_3.c 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), ] -POSTHOOK: Lineage: part_3.ca 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), ] -POSTHOOK: Lineage: part_3.fv 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), ] -POSTHOOK: Lineage: part_3.p_mfgr SIMPLE [(part)part.FieldSchema(name:p_mfgr, type:string, comment:null), ] -POSTHOOK: Lineage: part_3.p_name SIMPLE [(part)part.FieldSchema(name:p_name, type:string, comment:null), ] -POSTHOOK: Lineage: part_3.p_size SIMPLE [(part)part.FieldSchema(name:p_size, type:int, comment:null), ] -PREHOOK: query: select * from part_1 -PREHOOK: type: QUERY -PREHOOK: Input: default@part_1 -#### A masked pattern was here #### -POSTHOOK: query: select * from part_1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@part_1 -#### 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.65 -Manufacturer#1 almond aquamarine burnished black steel 28 5 4 7117.07 -Manufacturer#1 almond aquamarine pink moccasin thistle 42 6 5 8749.73 -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.36 -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.62 -Manufacturer#5 almond antique blue firebrick mint 31 1 1 1789.69 -Manufacturer#5 almond antique medium spring khaki 6 2 2 3401.35 -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: select * from part_2 -PREHOOK: type: QUERY -PREHOOK: Input: default@part_2 -#### A masked pattern was here #### -POSTHOOK: query: select * from part_2 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@part_2 -#### A masked pattern was here #### -Manufacturer#1 almond antique burnished rose metallic 2 1 1 0 4.0 2 -Manufacturer#1 almond antique burnished rose metallic 2 1 1 0 4.0 2 -Manufacturer#1 almond antique chartreuse lavender yellow 34 3 2 0 34.0 2 -Manufacturer#1 almond antique salmon chartreuse burlywood 6 4 3 0 10.0 2 -Manufacturer#1 almond aquamarine burnished black steel 28 5 4 0 28.0 34 -Manufacturer#1 almond aquamarine pink moccasin thistle 42 6 5 1 42.0 6 -Manufacturer#2 almond antique violet chocolate turquoise 14 1 1 0 14.0 14 -Manufacturer#2 almond antique violet turquoise frosted 40 2 2 0 40.0 14 -Manufacturer#2 almond aquamarine midnight light salmon 2 3 3 0 2.0 14 -Manufacturer#2 almond aquamarine rose maroon antique 25 4 4 0 25.0 40 -Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 5 5 1 32.0 2 -Manufacturer#3 almond antique chartreuse khaki white 17 1 1 0 31.0 17 -Manufacturer#3 almond antique forest lavender goldenrod 14 2 2 0 14.0 17 -Manufacturer#3 almond antique metallic orange dim 19 3 3 0 50.0 17 -Manufacturer#3 almond antique misty red olive 1 4 4 0 1.0 14 -Manufacturer#3 almond antique olive coral navajo 45 5 5 1 45.0 19 -Manufacturer#4 almond antique gainsboro frosted violet 10 1 1 0 17.0 10 -Manufacturer#4 almond antique violet mint lemon 39 2 2 0 39.0 10 -Manufacturer#4 almond aquamarine floral ivory bisque 27 3 3 0 27.0 10 -Manufacturer#4 almond aquamarine yellow dodger mint 7 4 4 0 7.0 39 -Manufacturer#4 almond azure aquamarine papaya violet 12 5 5 1 29.0 27 -Manufacturer#5 almond antique blue firebrick mint 31 1 1 0 31.0 31 -Manufacturer#5 almond antique medium spring khaki 6 2 2 0 8.0 31 -Manufacturer#5 almond antique sky peru orange 2 3 3 0 2.0 31 -Manufacturer#5 almond aquamarine dodger light gainsboro 46 4 4 0 46.0 6 -Manufacturer#5 almond azure blanched chiffon midnight 23 5 5 1 23.0
<TRUNCATED>