http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/vector_ptf_part_simple.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_ptf_part_simple.q.out b/ql/src/test/results/clientpositive/llap/vector_ptf_part_simple.q.out index 9aeb650..ec8611d 100644 --- a/ql/src/test/results/clientpositive/llap/vector_ptf_part_simple.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_ptf_part_simple.q.out @@ -309,46 +309,46 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@vector_ptf_part_simple_orc #### A masked pattern was here #### p_mfgr p_name p_retailprice rn r dr fv lv c cs -Manufacturer#4 almond azure aquamarine papaya violet 1290.35 1 1 1 1290.35 1206.26 4 6 -Manufacturer#4 almond antique violet mint lemon 1375.42 2 1 1 1290.35 1206.26 4 6 -Manufacturer#4 almond aquamarine floral ivory bisque NULL 3 1 1 1290.35 1206.26 4 6 -Manufacturer#4 almond antique gainsboro frosted violet NULL 4 1 1 1290.35 1206.26 4 6 -Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 5 1 1 1290.35 1206.26 4 6 -Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 6 1 1 1290.35 1206.26 4 6 -Manufacturer#5 almond azure blanched chiffon midnight 1464.48 1 1 1 1464.48 1788.73 6 6 -Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 2 1 1 1464.48 1788.73 6 6 -Manufacturer#5 almond antique medium spring khaki 1611.66 3 1 1 1464.48 1788.73 6 6 -Manufacturer#5 almond antique blue firebrick mint 1789.69 4 1 1 1464.48 1788.73 6 6 -Manufacturer#5 almond antique medium spring khaki 1611.66 5 1 1 1464.48 1788.73 6 6 -Manufacturer#5 almond antique sky peru orange 1788.73 6 1 1 1464.48 1788.73 6 6 -Manufacturer#2 almond aquamarine rose maroon antique 900.66 1 1 1 900.66 1800.7 8 8 -Manufacturer#2 almond aquamarine rose maroon antique 1698.66 2 1 1 900.66 1800.7 8 8 -Manufacturer#2 almond antique violet turquoise frosted 1800.7 3 1 1 900.66 1800.7 8 8 -Manufacturer#2 almond antique violet chocolate turquoise 1690.68 4 1 1 900.66 1800.7 8 8 -Manufacturer#2 almond antique violet turquoise frosted 1800.7 5 1 1 900.66 1800.7 8 8 -Manufacturer#2 almond aquamarine sandy cyan gainsboro 1000.6 6 1 1 900.66 1800.7 8 8 -Manufacturer#2 almond aquamarine midnight light salmon 2031.98 7 1 1 900.66 1800.7 8 8 -Manufacturer#2 almond antique violet turquoise frosted 1800.7 8 1 1 900.66 1800.7 8 8 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 2 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 3 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 4 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond aquamarine burnished black steel 1414.42 5 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond antique burnished rose metallic 1173.15 6 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 7 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 8 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond antique burnished rose metallic 1173.15 9 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 10 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond aquamarine pink moccasin thistle NULL 11 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 12 1 1 1753.76 1632.66 11 12 -Manufacturer#3 almond antique forest lavender goldenrod 590.27 1 1 1 590.27 99.68 7 8 -Manufacturer#3 almond antique metallic orange dim 55.39 2 1 1 590.27 99.68 7 8 -Manufacturer#3 almond antique forest lavender goldenrod 1190.27 3 1 1 590.27 99.68 7 8 -Manufacturer#3 almond antique olive coral navajo 1337.29 4 1 1 590.27 99.68 7 8 -Manufacturer#3 almond antique misty red olive 1922.98 5 1 1 590.27 99.68 7 8 -Manufacturer#3 almond antique forest lavender goldenrod 1190.27 6 1 1 590.27 99.68 7 8 -Manufacturer#3 almond antique forest lavender goldenrod NULL 7 1 1 590.27 99.68 7 8 -Manufacturer#3 almond antique chartreuse khaki white 99.68 8 1 1 590.27 99.68 7 8 +Manufacturer#2 almond aquamarine rose maroon antique 900.66 1 1 1 900.66 2031.98 8 8 +Manufacturer#2 almond aquamarine rose maroon antique 1698.66 2 1 1 900.66 2031.98 8 8 +Manufacturer#2 almond antique violet turquoise frosted 1800.7 3 1 1 900.66 2031.98 8 8 +Manufacturer#2 almond antique violet chocolate turquoise 1690.68 4 1 1 900.66 2031.98 8 8 +Manufacturer#2 almond antique violet turquoise frosted 1800.7 5 1 1 900.66 2031.98 8 8 +Manufacturer#2 almond antique violet turquoise frosted 1800.7 6 1 1 900.66 2031.98 8 8 +Manufacturer#2 almond aquamarine sandy cyan gainsboro 1000.6 7 1 1 900.66 2031.98 8 8 +Manufacturer#2 almond aquamarine midnight light salmon 2031.98 8 1 1 900.66 2031.98 8 8 +Manufacturer#3 almond antique forest lavender goldenrod NULL 1 1 1 NULL 1922.98 7 8 +Manufacturer#3 almond antique forest lavender goldenrod 1190.27 2 1 1 NULL 1922.98 7 8 +Manufacturer#3 almond antique forest lavender goldenrod 590.27 3 1 1 NULL 1922.98 7 8 +Manufacturer#3 almond antique forest lavender goldenrod 1190.27 4 1 1 NULL 1922.98 7 8 +Manufacturer#3 almond antique metallic orange dim 55.39 5 1 1 NULL 1922.98 7 8 +Manufacturer#3 almond antique olive coral navajo 1337.29 6 1 1 NULL 1922.98 7 8 +Manufacturer#3 almond antique chartreuse khaki white 99.68 7 1 1 NULL 1922.98 7 8 +Manufacturer#3 almond antique misty red olive 1922.98 8 1 1 NULL 1922.98 7 8 +Manufacturer#4 almond aquamarine floral ivory bisque NULL 1 1 1 NULL 1375.42 4 6 +Manufacturer#4 almond antique gainsboro frosted violet NULL 2 1 1 NULL 1375.42 4 6 +Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 3 1 1 NULL 1375.42 4 6 +Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 4 1 1 NULL 1375.42 4 6 +Manufacturer#4 almond azure aquamarine papaya violet 1290.35 5 1 1 NULL 1375.42 4 6 +Manufacturer#4 almond antique violet mint lemon 1375.42 6 1 1 NULL 1375.42 4 6 +Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 2 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 3 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 4 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 5 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 6 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 7 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond antique burnished rose metallic 1173.15 8 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond aquamarine burnished black steel 1414.42 9 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond aquamarine pink moccasin thistle NULL 10 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 11 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond antique burnished rose metallic 1173.15 12 1 1 1632.66 1173.15 11 12 +Manufacturer#5 almond antique medium spring khaki 1611.66 1 1 1 1611.66 1789.69 6 6 +Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 2 1 1 1611.66 1789.69 6 6 +Manufacturer#5 almond antique sky peru orange 1788.73 3 1 1 1611.66 1789.69 6 6 +Manufacturer#5 almond antique medium spring khaki 1611.66 4 1 1 1611.66 1789.69 6 6 +Manufacturer#5 almond azure blanched chiffon midnight 1464.48 5 1 1 1611.66 1789.69 6 6 +Manufacturer#5 almond antique blue firebrick mint 1789.69 6 1 1 1611.66 1789.69 6 6 PREHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, row_number() over(partition by p_mfgr range between unbounded preceding and unbounded following) as rn, @@ -538,46 +538,46 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@vector_ptf_part_simple_orc #### A masked pattern was here #### p_mfgr p_name p_retailprice rn r dr fv lv c cs -Manufacturer#4 almond azure aquamarine papaya violet 1290.35 1 1 1 1290.35 1206.26 4 6 -Manufacturer#4 almond antique violet mint lemon 1375.42 2 1 1 1290.35 1206.26 4 6 -Manufacturer#4 almond aquamarine floral ivory bisque NULL 3 1 1 1290.35 1206.26 4 6 -Manufacturer#4 almond antique gainsboro frosted violet NULL 4 1 1 1290.35 1206.26 4 6 -Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 5 1 1 1290.35 1206.26 4 6 -Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 6 1 1 1290.35 1206.26 4 6 -Manufacturer#5 almond azure blanched chiffon midnight 1464.48 1 1 1 1464.48 1788.73 6 6 -Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 2 1 1 1464.48 1788.73 6 6 -Manufacturer#5 almond antique medium spring khaki 1611.66 3 1 1 1464.48 1788.73 6 6 -Manufacturer#5 almond antique blue firebrick mint 1789.69 4 1 1 1464.48 1788.73 6 6 -Manufacturer#5 almond antique medium spring khaki 1611.66 5 1 1 1464.48 1788.73 6 6 -Manufacturer#5 almond antique sky peru orange 1788.73 6 1 1 1464.48 1788.73 6 6 -Manufacturer#2 almond aquamarine rose maroon antique 900.66 1 1 1 900.66 1800.7 8 8 -Manufacturer#2 almond aquamarine rose maroon antique 1698.66 2 1 1 900.66 1800.7 8 8 -Manufacturer#2 almond antique violet turquoise frosted 1800.7 3 1 1 900.66 1800.7 8 8 -Manufacturer#2 almond antique violet chocolate turquoise 1690.68 4 1 1 900.66 1800.7 8 8 -Manufacturer#2 almond antique violet turquoise frosted 1800.7 5 1 1 900.66 1800.7 8 8 -Manufacturer#2 almond aquamarine sandy cyan gainsboro 1000.6 6 1 1 900.66 1800.7 8 8 -Manufacturer#2 almond aquamarine midnight light salmon 2031.98 7 1 1 900.66 1800.7 8 8 -Manufacturer#2 almond antique violet turquoise frosted 1800.7 8 1 1 900.66 1800.7 8 8 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 2 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 3 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 4 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond aquamarine burnished black steel 1414.42 5 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond antique burnished rose metallic 1173.15 6 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 7 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 8 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond antique burnished rose metallic 1173.15 9 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 10 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond aquamarine pink moccasin thistle NULL 11 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 12 1 1 1753.76 1632.66 11 12 -Manufacturer#3 almond antique forest lavender goldenrod 590.27 1 1 1 590.27 99.68 7 8 -Manufacturer#3 almond antique metallic orange dim 55.39 2 1 1 590.27 99.68 7 8 -Manufacturer#3 almond antique forest lavender goldenrod 1190.27 3 1 1 590.27 99.68 7 8 -Manufacturer#3 almond antique olive coral navajo 1337.29 4 1 1 590.27 99.68 7 8 -Manufacturer#3 almond antique misty red olive 1922.98 5 1 1 590.27 99.68 7 8 -Manufacturer#3 almond antique forest lavender goldenrod 1190.27 6 1 1 590.27 99.68 7 8 -Manufacturer#3 almond antique forest lavender goldenrod NULL 7 1 1 590.27 99.68 7 8 -Manufacturer#3 almond antique chartreuse khaki white 99.68 8 1 1 590.27 99.68 7 8 +Manufacturer#2 almond aquamarine rose maroon antique 900.66 1 1 1 900.66 2031.98 8 8 +Manufacturer#2 almond aquamarine rose maroon antique 1698.66 2 1 1 900.66 2031.98 8 8 +Manufacturer#2 almond antique violet turquoise frosted 1800.7 3 1 1 900.66 2031.98 8 8 +Manufacturer#2 almond antique violet chocolate turquoise 1690.68 4 1 1 900.66 2031.98 8 8 +Manufacturer#2 almond antique violet turquoise frosted 1800.7 5 1 1 900.66 2031.98 8 8 +Manufacturer#2 almond antique violet turquoise frosted 1800.7 6 1 1 900.66 2031.98 8 8 +Manufacturer#2 almond aquamarine sandy cyan gainsboro 1000.6 7 1 1 900.66 2031.98 8 8 +Manufacturer#2 almond aquamarine midnight light salmon 2031.98 8 1 1 900.66 2031.98 8 8 +Manufacturer#3 almond antique forest lavender goldenrod NULL 1 1 1 NULL 1922.98 7 8 +Manufacturer#3 almond antique forest lavender goldenrod 1190.27 2 1 1 NULL 1922.98 7 8 +Manufacturer#3 almond antique forest lavender goldenrod 590.27 3 1 1 NULL 1922.98 7 8 +Manufacturer#3 almond antique forest lavender goldenrod 1190.27 4 1 1 NULL 1922.98 7 8 +Manufacturer#3 almond antique metallic orange dim 55.39 5 1 1 NULL 1922.98 7 8 +Manufacturer#3 almond antique olive coral navajo 1337.29 6 1 1 NULL 1922.98 7 8 +Manufacturer#3 almond antique chartreuse khaki white 99.68 7 1 1 NULL 1922.98 7 8 +Manufacturer#3 almond antique misty red olive 1922.98 8 1 1 NULL 1922.98 7 8 +Manufacturer#4 almond aquamarine floral ivory bisque NULL 1 1 1 NULL 1375.42 4 6 +Manufacturer#4 almond antique gainsboro frosted violet NULL 2 1 1 NULL 1375.42 4 6 +Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 3 1 1 NULL 1375.42 4 6 +Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 4 1 1 NULL 1375.42 4 6 +Manufacturer#4 almond azure aquamarine papaya violet 1290.35 5 1 1 NULL 1375.42 4 6 +Manufacturer#4 almond antique violet mint lemon 1375.42 6 1 1 NULL 1375.42 4 6 +Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 2 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 3 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 4 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 5 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 6 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 7 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond antique burnished rose metallic 1173.15 8 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond aquamarine burnished black steel 1414.42 9 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond aquamarine pink moccasin thistle NULL 10 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 11 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond antique burnished rose metallic 1173.15 12 1 1 1632.66 1173.15 11 12 +Manufacturer#5 almond antique medium spring khaki 1611.66 1 1 1 1611.66 1789.69 6 6 +Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 2 1 1 1611.66 1789.69 6 6 +Manufacturer#5 almond antique sky peru orange 1788.73 3 1 1 1611.66 1789.69 6 6 +Manufacturer#5 almond antique medium spring khaki 1611.66 4 1 1 1611.66 1789.69 6 6 +Manufacturer#5 almond azure blanched chiffon midnight 1464.48 5 1 1 1611.66 1789.69 6 6 +Manufacturer#5 almond antique blue firebrick mint 1789.69 6 1 1 1611.66 1789.69 6 6 PREHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, row_number() over(partition by p_mfgr rows between unbounded preceding and unbounded following) as rn, @@ -767,46 +767,46 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@vector_ptf_part_simple_orc #### A masked pattern was here #### p_mfgr p_name p_retailprice rn r dr fv lv c cs -Manufacturer#4 almond azure aquamarine papaya violet 1290.35 1 1 1 1290.35 1290.35 1 1 -Manufacturer#4 almond antique violet mint lemon 1375.42 2 1 1 1290.35 1375.42 2 2 -Manufacturer#4 almond aquamarine floral ivory bisque NULL 3 1 1 1290.35 NULL 2 3 -Manufacturer#4 almond antique gainsboro frosted violet NULL 4 1 1 1290.35 NULL 2 4 -Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 5 1 1 1290.35 1844.92 3 5 -Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 6 1 1 1290.35 1206.26 4 6 -Manufacturer#5 almond azure blanched chiffon midnight 1464.48 1 1 1 1464.48 1464.48 1 1 -Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 2 1 1 1464.48 1018.1 2 2 -Manufacturer#5 almond antique medium spring khaki 1611.66 3 1 1 1464.48 1611.66 3 3 -Manufacturer#5 almond antique blue firebrick mint 1789.69 4 1 1 1464.48 1789.69 4 4 -Manufacturer#5 almond antique medium spring khaki 1611.66 5 1 1 1464.48 1611.66 5 5 -Manufacturer#5 almond antique sky peru orange 1788.73 6 1 1 1464.48 1788.73 6 6 Manufacturer#2 almond aquamarine rose maroon antique 900.66 1 1 1 900.66 900.66 1 1 Manufacturer#2 almond aquamarine rose maroon antique 1698.66 2 1 1 900.66 1698.66 2 2 Manufacturer#2 almond antique violet turquoise frosted 1800.7 3 1 1 900.66 1800.7 3 3 Manufacturer#2 almond antique violet chocolate turquoise 1690.68 4 1 1 900.66 1690.68 4 4 Manufacturer#2 almond antique violet turquoise frosted 1800.7 5 1 1 900.66 1800.7 5 5 -Manufacturer#2 almond aquamarine sandy cyan gainsboro 1000.6 6 1 1 900.66 1000.6 6 6 -Manufacturer#2 almond aquamarine midnight light salmon 2031.98 7 1 1 900.66 2031.98 7 7 -Manufacturer#2 almond antique violet turquoise frosted 1800.7 8 1 1 900.66 1800.7 8 8 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 1 1 1753.76 1753.76 1 1 -Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 2 1 1 1753.76 1632.66 2 2 -Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 3 1 1 1753.76 1632.66 3 3 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 4 1 1 1753.76 1753.76 4 4 -Manufacturer#1 almond aquamarine burnished black steel 1414.42 5 1 1 1753.76 1414.42 5 5 -Manufacturer#1 almond antique burnished rose metallic 1173.15 6 1 1 1753.76 1173.15 6 6 -Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 7 1 1 1753.76 1602.59 7 7 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 8 1 1 1753.76 1753.76 8 8 -Manufacturer#1 almond antique burnished rose metallic 1173.15 9 1 1 1753.76 1173.15 9 9 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 10 1 1 1753.76 1753.76 10 10 -Manufacturer#1 almond aquamarine pink moccasin thistle NULL 11 1 1 1753.76 NULL 10 11 -Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 12 1 1 1753.76 1632.66 11 12 -Manufacturer#3 almond antique forest lavender goldenrod 590.27 1 1 1 590.27 590.27 1 1 -Manufacturer#3 almond antique metallic orange dim 55.39 2 1 1 590.27 55.39 2 2 -Manufacturer#3 almond antique forest lavender goldenrod 1190.27 3 1 1 590.27 1190.27 3 3 -Manufacturer#3 almond antique olive coral navajo 1337.29 4 1 1 590.27 1337.29 4 4 -Manufacturer#3 almond antique misty red olive 1922.98 5 1 1 590.27 1922.98 5 5 -Manufacturer#3 almond antique forest lavender goldenrod 1190.27 6 1 1 590.27 1190.27 6 6 -Manufacturer#3 almond antique forest lavender goldenrod NULL 7 1 1 590.27 NULL 6 7 -Manufacturer#3 almond antique chartreuse khaki white 99.68 8 1 1 590.27 99.68 7 8 +Manufacturer#2 almond antique violet turquoise frosted 1800.7 6 1 1 900.66 1800.7 6 6 +Manufacturer#2 almond aquamarine sandy cyan gainsboro 1000.6 7 1 1 900.66 1000.6 7 7 +Manufacturer#2 almond aquamarine midnight light salmon 2031.98 8 1 1 900.66 2031.98 8 8 +Manufacturer#3 almond antique forest lavender goldenrod NULL 1 1 1 NULL NULL 0 1 +Manufacturer#3 almond antique forest lavender goldenrod 1190.27 2 1 1 NULL 1190.27 1 2 +Manufacturer#3 almond antique forest lavender goldenrod 590.27 3 1 1 NULL 590.27 2 3 +Manufacturer#3 almond antique forest lavender goldenrod 1190.27 4 1 1 NULL 1190.27 3 4 +Manufacturer#3 almond antique metallic orange dim 55.39 5 1 1 NULL 55.39 4 5 +Manufacturer#3 almond antique olive coral navajo 1337.29 6 1 1 NULL 1337.29 5 6 +Manufacturer#3 almond antique chartreuse khaki white 99.68 7 1 1 NULL 99.68 6 7 +Manufacturer#3 almond antique misty red olive 1922.98 8 1 1 NULL 1922.98 7 8 +Manufacturer#4 almond aquamarine floral ivory bisque NULL 1 1 1 NULL NULL 0 1 +Manufacturer#4 almond antique gainsboro frosted violet NULL 2 1 1 NULL NULL 0 2 +Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 3 1 1 NULL 1206.26 1 3 +Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 4 1 1 NULL 1844.92 2 4 +Manufacturer#4 almond azure aquamarine papaya violet 1290.35 5 1 1 NULL 1290.35 3 5 +Manufacturer#4 almond antique violet mint lemon 1375.42 6 1 1 NULL 1375.42 4 6 +Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1 1 1 1632.66 1632.66 1 1 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 2 1 1 1632.66 1753.76 2 2 +Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 3 1 1 1632.66 1632.66 3 3 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 4 1 1 1632.66 1753.76 4 4 +Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 5 1 1 1632.66 1632.66 5 5 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 6 1 1 1632.66 1753.76 6 6 +Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 7 1 1 1632.66 1602.59 7 7 +Manufacturer#1 almond antique burnished rose metallic 1173.15 8 1 1 1632.66 1173.15 8 8 +Manufacturer#1 almond aquamarine burnished black steel 1414.42 9 1 1 1632.66 1414.42 9 9 +Manufacturer#1 almond aquamarine pink moccasin thistle NULL 10 1 1 1632.66 NULL 9 10 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 11 1 1 1632.66 1753.76 10 11 +Manufacturer#1 almond antique burnished rose metallic 1173.15 12 1 1 1632.66 1173.15 11 12 +Manufacturer#5 almond antique medium spring khaki 1611.66 1 1 1 1611.66 1611.66 1 1 +Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 2 1 1 1611.66 1018.1 2 2 +Manufacturer#5 almond antique sky peru orange 1788.73 3 1 1 1611.66 1788.73 3 3 +Manufacturer#5 almond antique medium spring khaki 1611.66 4 1 1 1611.66 1611.66 4 4 +Manufacturer#5 almond azure blanched chiffon midnight 1464.48 5 1 1 1611.66 1464.48 5 5 +Manufacturer#5 almond antique blue firebrick mint 1789.69 6 1 1 1611.66 1789.69 6 6 PREHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, row_number() over(partition by p_mfgr order by p_name) as rn, @@ -2442,46 +2442,46 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@vector_ptf_part_simple_orc #### A masked pattern was here #### p_mfgr p_name p_retailprice s mi ma av -Manufacturer#4 almond azure aquamarine papaya violet 1290.35 5716.950000000001 1206.26 1844.92 1429.2375000000002 -Manufacturer#4 almond antique violet mint lemon 1375.42 5716.950000000001 1206.26 1844.92 1429.2375000000002 -Manufacturer#4 almond aquamarine floral ivory bisque NULL 5716.950000000001 1206.26 1844.92 1429.2375000000002 -Manufacturer#4 almond antique gainsboro frosted violet NULL 5716.950000000001 1206.26 1844.92 1429.2375000000002 -Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 5716.950000000001 1206.26 1844.92 1429.2375000000002 -Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 5716.950000000001 1206.26 1844.92 1429.2375000000002 -Manufacturer#5 almond azure blanched chiffon midnight 1464.48 9284.32 1018.1 1789.69 1547.3866666666665 -Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 9284.32 1018.1 1789.69 1547.3866666666665 -Manufacturer#5 almond antique medium spring khaki 1611.66 9284.32 1018.1 1789.69 1547.3866666666665 -Manufacturer#5 almond antique blue firebrick mint 1789.69 9284.32 1018.1 1789.69 1547.3866666666665 -Manufacturer#5 almond antique medium spring khaki 1611.66 9284.32 1018.1 1789.69 1547.3866666666665 -Manufacturer#5 almond antique sky peru orange 1788.73 9284.32 1018.1 1789.69 1547.3866666666665 Manufacturer#2 almond aquamarine rose maroon antique 900.66 12724.68 900.66 2031.98 1590.585 Manufacturer#2 almond aquamarine rose maroon antique 1698.66 12724.68 900.66 2031.98 1590.585 Manufacturer#2 almond antique violet turquoise frosted 1800.7 12724.68 900.66 2031.98 1590.585 Manufacturer#2 almond antique violet chocolate turquoise 1690.68 12724.68 900.66 2031.98 1590.585 Manufacturer#2 almond antique violet turquoise frosted 1800.7 12724.68 900.66 2031.98 1590.585 +Manufacturer#2 almond antique violet turquoise frosted 1800.7 12724.68 900.66 2031.98 1590.585 Manufacturer#2 almond aquamarine sandy cyan gainsboro 1000.6 12724.68 900.66 2031.98 1590.585 Manufacturer#2 almond aquamarine midnight light salmon 2031.98 12724.68 900.66 2031.98 1590.585 -Manufacturer#2 almond antique violet turquoise frosted 1800.7 12724.68 900.66 2031.98 1590.585 +Manufacturer#3 almond antique forest lavender goldenrod NULL 6386.15 55.39 1922.98 912.3071428571428 +Manufacturer#3 almond antique forest lavender goldenrod 1190.27 6386.15 55.39 1922.98 912.3071428571428 +Manufacturer#3 almond antique forest lavender goldenrod 590.27 6386.15 55.39 1922.98 912.3071428571428 +Manufacturer#3 almond antique forest lavender goldenrod 1190.27 6386.15 55.39 1922.98 912.3071428571428 +Manufacturer#3 almond antique metallic orange dim 55.39 6386.15 55.39 1922.98 912.3071428571428 +Manufacturer#3 almond antique olive coral navajo 1337.29 6386.15 55.39 1922.98 912.3071428571428 +Manufacturer#3 almond antique chartreuse khaki white 99.68 6386.15 55.39 1922.98 912.3071428571428 +Manufacturer#3 almond antique misty red olive 1922.98 6386.15 55.39 1922.98 912.3071428571428 +Manufacturer#4 almond aquamarine floral ivory bisque NULL 5716.950000000001 1206.26 1844.92 1429.2375000000002 +Manufacturer#4 almond antique gainsboro frosted violet NULL 5716.950000000001 1206.26 1844.92 1429.2375000000002 +Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 5716.950000000001 1206.26 1844.92 1429.2375000000002 +Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 5716.950000000001 1206.26 1844.92 1429.2375000000002 +Manufacturer#4 almond azure aquamarine papaya violet 1290.35 5716.950000000001 1206.26 1844.92 1429.2375000000002 +Manufacturer#4 almond antique violet mint lemon 1375.42 5716.950000000001 1206.26 1844.92 1429.2375000000002 +Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 17276.33 1173.15 1753.76 1570.5754545454547 Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 17276.33 1173.15 1753.76 1570.5754545454547 Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 17276.33 1173.15 1753.76 1570.5754545454547 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 17276.33 1173.15 1753.76 1570.5754545454547 Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 17276.33 1173.15 1753.76 1570.5754545454547 Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 17276.33 1173.15 1753.76 1570.5754545454547 -Manufacturer#1 almond aquamarine burnished black steel 1414.42 17276.33 1173.15 1753.76 1570.5754545454547 -Manufacturer#1 almond antique burnished rose metallic 1173.15 17276.33 1173.15 1753.76 1570.5754545454547 Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 17276.33 1173.15 1753.76 1570.5754545454547 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 17276.33 1173.15 1753.76 1570.5754545454547 Manufacturer#1 almond antique burnished rose metallic 1173.15 17276.33 1173.15 1753.76 1570.5754545454547 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 17276.33 1173.15 1753.76 1570.5754545454547 +Manufacturer#1 almond aquamarine burnished black steel 1414.42 17276.33 1173.15 1753.76 1570.5754545454547 Manufacturer#1 almond aquamarine pink moccasin thistle NULL 17276.33 1173.15 1753.76 1570.5754545454547 -Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 17276.33 1173.15 1753.76 1570.5754545454547 -Manufacturer#3 almond antique forest lavender goldenrod 590.27 6386.15 55.39 1922.98 912.3071428571428 -Manufacturer#3 almond antique metallic orange dim 55.39 6386.15 55.39 1922.98 912.3071428571428 -Manufacturer#3 almond antique forest lavender goldenrod 1190.27 6386.15 55.39 1922.98 912.3071428571428 -Manufacturer#3 almond antique olive coral navajo 1337.29 6386.15 55.39 1922.98 912.3071428571428 -Manufacturer#3 almond antique misty red olive 1922.98 6386.15 55.39 1922.98 912.3071428571428 -Manufacturer#3 almond antique forest lavender goldenrod 1190.27 6386.15 55.39 1922.98 912.3071428571428 -Manufacturer#3 almond antique forest lavender goldenrod NULL 6386.15 55.39 1922.98 912.3071428571428 -Manufacturer#3 almond antique chartreuse khaki white 99.68 6386.15 55.39 1922.98 912.3071428571428 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 17276.33 1173.15 1753.76 1570.5754545454547 +Manufacturer#1 almond antique burnished rose metallic 1173.15 17276.33 1173.15 1753.76 1570.5754545454547 +Manufacturer#5 almond antique medium spring khaki 1611.66 9284.32 1018.1 1789.69 1547.3866666666665 +Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 9284.32 1018.1 1789.69 1547.3866666666665 +Manufacturer#5 almond antique sky peru orange 1788.73 9284.32 1018.1 1789.69 1547.3866666666665 +Manufacturer#5 almond antique medium spring khaki 1611.66 9284.32 1018.1 1789.69 1547.3866666666665 +Manufacturer#5 almond azure blanched chiffon midnight 1464.48 9284.32 1018.1 1789.69 1547.3866666666665 +Manufacturer#5 almond antique blue firebrick mint 1789.69 9284.32 1018.1 1789.69 1547.3866666666665 PREHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, sum(p_retailprice) over(partition by p_mfgr range between unbounded preceding and current row) as s, @@ -2670,46 +2670,46 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@vector_ptf_part_simple_orc #### A masked pattern was here #### p_mfgr p_name p_retailprice s mi ma av -Manufacturer#4 almond azure aquamarine papaya violet 1290.35 5716.950000000001 1206.26 1844.92 1429.2375000000002 -Manufacturer#4 almond antique violet mint lemon 1375.42 5716.950000000001 1206.26 1844.92 1429.2375000000002 -Manufacturer#4 almond aquamarine floral ivory bisque NULL 5716.950000000001 1206.26 1844.92 1429.2375000000002 -Manufacturer#4 almond antique gainsboro frosted violet NULL 5716.950000000001 1206.26 1844.92 1429.2375000000002 -Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 5716.950000000001 1206.26 1844.92 1429.2375000000002 -Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 5716.950000000001 1206.26 1844.92 1429.2375000000002 -Manufacturer#5 almond azure blanched chiffon midnight 1464.48 9284.32 1018.1 1789.69 1547.3866666666665 -Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 9284.32 1018.1 1789.69 1547.3866666666665 -Manufacturer#5 almond antique medium spring khaki 1611.66 9284.32 1018.1 1789.69 1547.3866666666665 -Manufacturer#5 almond antique blue firebrick mint 1789.69 9284.32 1018.1 1789.69 1547.3866666666665 -Manufacturer#5 almond antique medium spring khaki 1611.66 9284.32 1018.1 1789.69 1547.3866666666665 -Manufacturer#5 almond antique sky peru orange 1788.73 9284.32 1018.1 1789.69 1547.3866666666665 Manufacturer#2 almond aquamarine rose maroon antique 900.66 12724.68 900.66 2031.98 1590.585 Manufacturer#2 almond aquamarine rose maroon antique 1698.66 12724.68 900.66 2031.98 1590.585 Manufacturer#2 almond antique violet turquoise frosted 1800.7 12724.68 900.66 2031.98 1590.585 Manufacturer#2 almond antique violet chocolate turquoise 1690.68 12724.68 900.66 2031.98 1590.585 Manufacturer#2 almond antique violet turquoise frosted 1800.7 12724.68 900.66 2031.98 1590.585 +Manufacturer#2 almond antique violet turquoise frosted 1800.7 12724.68 900.66 2031.98 1590.585 Manufacturer#2 almond aquamarine sandy cyan gainsboro 1000.6 12724.68 900.66 2031.98 1590.585 Manufacturer#2 almond aquamarine midnight light salmon 2031.98 12724.68 900.66 2031.98 1590.585 -Manufacturer#2 almond antique violet turquoise frosted 1800.7 12724.68 900.66 2031.98 1590.585 +Manufacturer#3 almond antique forest lavender goldenrod NULL 6386.15 55.39 1922.98 912.3071428571428 +Manufacturer#3 almond antique forest lavender goldenrod 1190.27 6386.15 55.39 1922.98 912.3071428571428 +Manufacturer#3 almond antique forest lavender goldenrod 590.27 6386.15 55.39 1922.98 912.3071428571428 +Manufacturer#3 almond antique forest lavender goldenrod 1190.27 6386.15 55.39 1922.98 912.3071428571428 +Manufacturer#3 almond antique metallic orange dim 55.39 6386.15 55.39 1922.98 912.3071428571428 +Manufacturer#3 almond antique olive coral navajo 1337.29 6386.15 55.39 1922.98 912.3071428571428 +Manufacturer#3 almond antique chartreuse khaki white 99.68 6386.15 55.39 1922.98 912.3071428571428 +Manufacturer#3 almond antique misty red olive 1922.98 6386.15 55.39 1922.98 912.3071428571428 +Manufacturer#4 almond aquamarine floral ivory bisque NULL 5716.950000000001 1206.26 1844.92 1429.2375000000002 +Manufacturer#4 almond antique gainsboro frosted violet NULL 5716.950000000001 1206.26 1844.92 1429.2375000000002 +Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 5716.950000000001 1206.26 1844.92 1429.2375000000002 +Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 5716.950000000001 1206.26 1844.92 1429.2375000000002 +Manufacturer#4 almond azure aquamarine papaya violet 1290.35 5716.950000000001 1206.26 1844.92 1429.2375000000002 +Manufacturer#4 almond antique violet mint lemon 1375.42 5716.950000000001 1206.26 1844.92 1429.2375000000002 +Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 17276.33 1173.15 1753.76 1570.5754545454547 Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 17276.33 1173.15 1753.76 1570.5754545454547 Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 17276.33 1173.15 1753.76 1570.5754545454547 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 17276.33 1173.15 1753.76 1570.5754545454547 Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 17276.33 1173.15 1753.76 1570.5754545454547 Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 17276.33 1173.15 1753.76 1570.5754545454547 -Manufacturer#1 almond aquamarine burnished black steel 1414.42 17276.33 1173.15 1753.76 1570.5754545454547 -Manufacturer#1 almond antique burnished rose metallic 1173.15 17276.33 1173.15 1753.76 1570.5754545454547 Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 17276.33 1173.15 1753.76 1570.5754545454547 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 17276.33 1173.15 1753.76 1570.5754545454547 Manufacturer#1 almond antique burnished rose metallic 1173.15 17276.33 1173.15 1753.76 1570.5754545454547 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 17276.33 1173.15 1753.76 1570.5754545454547 +Manufacturer#1 almond aquamarine burnished black steel 1414.42 17276.33 1173.15 1753.76 1570.5754545454547 Manufacturer#1 almond aquamarine pink moccasin thistle NULL 17276.33 1173.15 1753.76 1570.5754545454547 -Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 17276.33 1173.15 1753.76 1570.5754545454547 -Manufacturer#3 almond antique forest lavender goldenrod 590.27 6386.15 55.39 1922.98 912.3071428571428 -Manufacturer#3 almond antique metallic orange dim 55.39 6386.15 55.39 1922.98 912.3071428571428 -Manufacturer#3 almond antique forest lavender goldenrod 1190.27 6386.15 55.39 1922.98 912.3071428571428 -Manufacturer#3 almond antique olive coral navajo 1337.29 6386.15 55.39 1922.98 912.3071428571428 -Manufacturer#3 almond antique misty red olive 1922.98 6386.15 55.39 1922.98 912.3071428571428 -Manufacturer#3 almond antique forest lavender goldenrod 1190.27 6386.15 55.39 1922.98 912.3071428571428 -Manufacturer#3 almond antique forest lavender goldenrod NULL 6386.15 55.39 1922.98 912.3071428571428 -Manufacturer#3 almond antique chartreuse khaki white 99.68 6386.15 55.39 1922.98 912.3071428571428 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 17276.33 1173.15 1753.76 1570.5754545454547 +Manufacturer#1 almond antique burnished rose metallic 1173.15 17276.33 1173.15 1753.76 1570.5754545454547 +Manufacturer#5 almond antique medium spring khaki 1611.66 9284.32 1018.1 1789.69 1547.3866666666665 +Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 9284.32 1018.1 1789.69 1547.3866666666665 +Manufacturer#5 almond antique sky peru orange 1788.73 9284.32 1018.1 1789.69 1547.3866666666665 +Manufacturer#5 almond antique medium spring khaki 1611.66 9284.32 1018.1 1789.69 1547.3866666666665 +Manufacturer#5 almond azure blanched chiffon midnight 1464.48 9284.32 1018.1 1789.69 1547.3866666666665 +Manufacturer#5 almond antique blue firebrick mint 1789.69 9284.32 1018.1 1789.69 1547.3866666666665 PREHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, sum(p_retailprice) over(partition by p_mfgr rows between unbounded preceding and current row) as s, @@ -2867,46 +2867,46 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@vector_ptf_part_simple_orc #### A masked pattern was here #### p_mfgr p_name p_retailprice s mi ma av -Manufacturer#4 almond azure aquamarine papaya violet 1290.35 1290.35 1290.35 1290.35 1290.35 -Manufacturer#4 almond antique violet mint lemon 1375.42 2665.77 1290.35 1375.42 1332.885 -Manufacturer#4 almond aquamarine floral ivory bisque NULL 2665.77 1290.35 1375.42 1332.885 -Manufacturer#4 almond antique gainsboro frosted violet NULL 2665.77 1290.35 1375.42 1332.885 -Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 4510.6900000000005 1290.35 1844.92 1503.5633333333335 -Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 5716.950000000001 1206.26 1844.92 1429.2375000000002 -Manufacturer#5 almond azure blanched chiffon midnight 1464.48 1464.48 1464.48 1464.48 1464.48 -Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 2482.58 1018.1 1464.48 1241.29 -Manufacturer#5 almond antique medium spring khaki 1611.66 4094.24 1018.1 1611.66 1364.7466666666667 -Manufacturer#5 almond antique blue firebrick mint 1789.69 5883.93 1018.1 1789.69 1470.9825 -Manufacturer#5 almond antique medium spring khaki 1611.66 7495.59 1018.1 1789.69 1499.118 -Manufacturer#5 almond antique sky peru orange 1788.73 9284.32 1018.1 1789.69 1547.3866666666665 Manufacturer#2 almond aquamarine rose maroon antique 900.66 900.66 900.66 900.66 900.66 Manufacturer#2 almond aquamarine rose maroon antique 1698.66 2599.32 900.66 1698.66 1299.66 Manufacturer#2 almond antique violet turquoise frosted 1800.7 4400.02 900.66 1800.7 1466.6733333333334 Manufacturer#2 almond antique violet chocolate turquoise 1690.68 6090.700000000001 900.66 1800.7 1522.6750000000002 Manufacturer#2 almond antique violet turquoise frosted 1800.7 7891.400000000001 900.66 1800.7 1578.2800000000002 -Manufacturer#2 almond aquamarine sandy cyan gainsboro 1000.6 8892.0 900.66 1800.7 1482.0 -Manufacturer#2 almond aquamarine midnight light salmon 2031.98 10923.98 900.66 2031.98 1560.5685714285714 -Manufacturer#2 almond antique violet turquoise frosted 1800.7 12724.68 900.66 2031.98 1590.585 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1753.76 1753.76 1753.76 1753.76 -Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 3386.42 1632.66 1753.76 1693.21 +Manufacturer#2 almond antique violet turquoise frosted 1800.7 9692.1 900.66 1800.7 1615.3500000000001 +Manufacturer#2 almond aquamarine sandy cyan gainsboro 1000.6 10692.7 900.66 1800.7 1527.5285714285715 +Manufacturer#2 almond aquamarine midnight light salmon 2031.98 12724.68 900.66 2031.98 1590.585 +Manufacturer#3 almond antique forest lavender goldenrod NULL NULL NULL NULL NULL +Manufacturer#3 almond antique forest lavender goldenrod 1190.27 1190.27 1190.27 1190.27 1190.27 +Manufacturer#3 almond antique forest lavender goldenrod 590.27 1780.54 590.27 1190.27 890.27 +Manufacturer#3 almond antique forest lavender goldenrod 1190.27 2970.81 590.27 1190.27 990.27 +Manufacturer#3 almond antique metallic orange dim 55.39 3026.2 55.39 1190.27 756.55 +Manufacturer#3 almond antique olive coral navajo 1337.29 4363.49 55.39 1337.29 872.698 +Manufacturer#3 almond antique chartreuse khaki white 99.68 4463.17 55.39 1337.29 743.8616666666667 +Manufacturer#3 almond antique misty red olive 1922.98 6386.15 55.39 1922.98 912.3071428571428 +Manufacturer#4 almond aquamarine floral ivory bisque NULL NULL NULL NULL NULL +Manufacturer#4 almond antique gainsboro frosted violet NULL NULL NULL NULL NULL +Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 1206.26 1206.26 1206.26 1206.26 +Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 3051.1800000000003 1206.26 1844.92 1525.5900000000001 +Manufacturer#4 almond azure aquamarine papaya violet 1290.35 4341.530000000001 1206.26 1844.92 1447.176666666667 +Manufacturer#4 almond antique violet mint lemon 1375.42 5716.950000000001 1206.26 1844.92 1429.2375000000002 +Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1632.66 1632.66 1632.66 1632.66 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 3386.42 1632.66 1753.76 1693.21 Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 5019.08 1632.66 1753.76 1673.0266666666666 Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 6772.84 1632.66 1753.76 1693.21 -Manufacturer#1 almond aquamarine burnished black steel 1414.42 8187.26 1414.42 1753.76 1637.452 -Manufacturer#1 almond antique burnished rose metallic 1173.15 9360.41 1173.15 1753.76 1560.0683333333334 -Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 10963.0 1173.15 1753.76 1566.142857142857 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 12716.76 1173.15 1753.76 1589.595 -Manufacturer#1 almond antique burnished rose metallic 1173.15 13889.91 1173.15 1753.76 1543.3233333333333 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 15643.67 1173.15 1753.76 1564.367 -Manufacturer#1 almond aquamarine pink moccasin thistle NULL 15643.67 1173.15 1753.76 1564.367 -Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 17276.33 1173.15 1753.76 1570.5754545454547 -Manufacturer#3 almond antique forest lavender goldenrod 590.27 590.27 590.27 590.27 590.27 -Manufacturer#3 almond antique metallic orange dim 55.39 645.66 55.39 590.27 322.83 -Manufacturer#3 almond antique forest lavender goldenrod 1190.27 1835.9299999999998 55.39 1190.27 611.9766666666666 -Manufacturer#3 almond antique olive coral navajo 1337.29 3173.22 55.39 1337.29 793.305 -Manufacturer#3 almond antique misty red olive 1922.98 5096.2 55.39 1922.98 1019.24 -Manufacturer#3 almond antique forest lavender goldenrod 1190.27 6286.469999999999 55.39 1922.98 1047.745 -Manufacturer#3 almond antique forest lavender goldenrod NULL 6286.469999999999 55.39 1922.98 1047.745 -Manufacturer#3 almond antique chartreuse khaki white 99.68 6386.15 55.39 1922.98 912.3071428571428 +Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 8405.5 1632.66 1753.76 1681.1 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 10159.26 1632.66 1753.76 1693.21 +Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 11761.85 1602.59 1753.76 1680.2642857142857 +Manufacturer#1 almond antique burnished rose metallic 1173.15 12935.0 1173.15 1753.76 1616.875 +Manufacturer#1 almond aquamarine burnished black steel 1414.42 14349.42 1173.15 1753.76 1594.38 +Manufacturer#1 almond aquamarine pink moccasin thistle NULL 14349.42 1173.15 1753.76 1594.38 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 16103.18 1173.15 1753.76 1610.318 +Manufacturer#1 almond antique burnished rose metallic 1173.15 17276.33 1173.15 1753.76 1570.5754545454547 +Manufacturer#5 almond antique medium spring khaki 1611.66 1611.66 1611.66 1611.66 1611.66 +Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 2629.76 1018.1 1611.66 1314.88 +Manufacturer#5 almond antique sky peru orange 1788.73 4418.49 1018.1 1788.73 1472.83 +Manufacturer#5 almond antique medium spring khaki 1611.66 6030.15 1018.1 1788.73 1507.5375 +Manufacturer#5 almond azure blanched chiffon midnight 1464.48 7494.629999999999 1018.1 1788.73 1498.926 +Manufacturer#5 almond antique blue firebrick mint 1789.69 9284.32 1018.1 1789.69 1547.3866666666665 PREHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, sum(p_retailprice) over(partition by p_mfgr order by p_name) as s, @@ -4456,46 +4456,46 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@vector_ptf_part_simple_orc_decimal #### A masked pattern was here #### p_mfgr p_name p_retailprice s mi ma av -Manufacturer#4 almond azure aquamarine papaya violet 1290.350000000000000000 5716.950000000000000000 1206.260000000000000000 1844.920000000000000000 1429.237500000000000000 -Manufacturer#4 almond antique violet mint lemon 1375.420000000000000000 5716.950000000000000000 1206.260000000000000000 1844.920000000000000000 1429.237500000000000000 -Manufacturer#4 almond aquamarine floral ivory bisque NULL 5716.950000000000000000 1206.260000000000000000 1844.920000000000000000 1429.237500000000000000 -Manufacturer#4 almond antique gainsboro frosted violet NULL 5716.950000000000000000 1206.260000000000000000 1844.920000000000000000 1429.237500000000000000 -Manufacturer#4 almond aquamarine yellow dodger mint 1844.920000000000000000 5716.950000000000000000 1206.260000000000000000 1844.920000000000000000 1429.237500000000000000 -Manufacturer#4 almond aquamarine floral ivory bisque 1206.260000000000000000 5716.950000000000000000 1206.260000000000000000 1844.920000000000000000 1429.237500000000000000 -Manufacturer#5 almond azure blanched chiffon midnight 1464.480000000000000000 9284.320000000000000000 1018.100000000000000000 1789.690000000000000000 1547.386666666666666667 -Manufacturer#5 almond aquamarine dodger light gainsboro 1018.100000000000000000 9284.320000000000000000 1018.100000000000000000 1789.690000000000000000 1547.386666666666666667 -Manufacturer#5 almond antique medium spring khaki 1611.660000000000000000 9284.320000000000000000 1018.100000000000000000 1789.690000000000000000 1547.386666666666666667 -Manufacturer#5 almond antique blue firebrick mint 1789.690000000000000000 9284.320000000000000000 1018.100000000000000000 1789.690000000000000000 1547.386666666666666667 -Manufacturer#5 almond antique medium spring khaki 1611.660000000000000000 9284.320000000000000000 1018.100000000000000000 1789.690000000000000000 1547.386666666666666667 -Manufacturer#5 almond antique sky peru orange 1788.730000000000000000 9284.320000000000000000 1018.100000000000000000 1789.690000000000000000 1547.386666666666666667 Manufacturer#2 almond aquamarine rose maroon antique 900.660000000000000000 12724.680000000000000000 900.660000000000000000 2031.980000000000000000 1590.585000000000000000 Manufacturer#2 almond aquamarine rose maroon antique 1698.660000000000000000 12724.680000000000000000 900.660000000000000000 2031.980000000000000000 1590.585000000000000000 Manufacturer#2 almond antique violet turquoise frosted 1800.700000000000000000 12724.680000000000000000 900.660000000000000000 2031.980000000000000000 1590.585000000000000000 Manufacturer#2 almond antique violet chocolate turquoise 1690.680000000000000000 12724.680000000000000000 900.660000000000000000 2031.980000000000000000 1590.585000000000000000 Manufacturer#2 almond antique violet turquoise frosted 1800.700000000000000000 12724.680000000000000000 900.660000000000000000 2031.980000000000000000 1590.585000000000000000 +Manufacturer#2 almond antique violet turquoise frosted 1800.700000000000000000 12724.680000000000000000 900.660000000000000000 2031.980000000000000000 1590.585000000000000000 Manufacturer#2 almond aquamarine sandy cyan gainsboro 1000.600000000000000000 12724.680000000000000000 900.660000000000000000 2031.980000000000000000 1590.585000000000000000 Manufacturer#2 almond aquamarine midnight light salmon 2031.980000000000000000 12724.680000000000000000 900.660000000000000000 2031.980000000000000000 1590.585000000000000000 -Manufacturer#2 almond antique violet turquoise frosted 1800.700000000000000000 12724.680000000000000000 900.660000000000000000 2031.980000000000000000 1590.585000000000000000 +Manufacturer#3 almond antique forest lavender goldenrod NULL 6386.150000000000000000 55.390000000000000000 1922.980000000000000000 912.307142857142857143 +Manufacturer#3 almond antique forest lavender goldenrod 1190.270000000000000000 6386.150000000000000000 55.390000000000000000 1922.980000000000000000 912.307142857142857143 +Manufacturer#3 almond antique forest lavender goldenrod 590.270000000000000000 6386.150000000000000000 55.390000000000000000 1922.980000000000000000 912.307142857142857143 +Manufacturer#3 almond antique forest lavender goldenrod 1190.270000000000000000 6386.150000000000000000 55.390000000000000000 1922.980000000000000000 912.307142857142857143 +Manufacturer#3 almond antique metallic orange dim 55.390000000000000000 6386.150000000000000000 55.390000000000000000 1922.980000000000000000 912.307142857142857143 +Manufacturer#3 almond antique olive coral navajo 1337.290000000000000000 6386.150000000000000000 55.390000000000000000 1922.980000000000000000 912.307142857142857143 +Manufacturer#3 almond antique chartreuse khaki white 99.680000000000000000 6386.150000000000000000 55.390000000000000000 1922.980000000000000000 912.307142857142857143 +Manufacturer#3 almond antique misty red olive 1922.980000000000000000 6386.150000000000000000 55.390000000000000000 1922.980000000000000000 912.307142857142857143 +Manufacturer#4 almond aquamarine floral ivory bisque NULL 5716.950000000000000000 1206.260000000000000000 1844.920000000000000000 1429.237500000000000000 +Manufacturer#4 almond antique gainsboro frosted violet NULL 5716.950000000000000000 1206.260000000000000000 1844.920000000000000000 1429.237500000000000000 +Manufacturer#4 almond aquamarine floral ivory bisque 1206.260000000000000000 5716.950000000000000000 1206.260000000000000000 1844.920000000000000000 1429.237500000000000000 +Manufacturer#4 almond aquamarine yellow dodger mint 1844.920000000000000000 5716.950000000000000000 1206.260000000000000000 1844.920000000000000000 1429.237500000000000000 +Manufacturer#4 almond azure aquamarine papaya violet 1290.350000000000000000 5716.950000000000000000 1206.260000000000000000 1844.920000000000000000 1429.237500000000000000 +Manufacturer#4 almond antique violet mint lemon 1375.420000000000000000 5716.950000000000000000 1206.260000000000000000 1844.920000000000000000 1429.237500000000000000 +Manufacturer#1 almond aquamarine pink moccasin thistle 1632.660000000000000000 17276.330000000000000000 1173.150000000000000000 1753.760000000000000000 1570.575454545454545455 Manufacturer#1 almond antique chartreuse lavender yellow 1753.760000000000000000 17276.330000000000000000 1173.150000000000000000 1753.760000000000000000 1570.575454545454545455 Manufacturer#1 almond aquamarine pink moccasin thistle 1632.660000000000000000 17276.330000000000000000 1173.150000000000000000 1753.760000000000000000 1570.575454545454545455 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.760000000000000000 17276.330000000000000000 1173.150000000000000000 1753.760000000000000000 1570.575454545454545455 Manufacturer#1 almond aquamarine pink moccasin thistle 1632.660000000000000000 17276.330000000000000000 1173.150000000000000000 1753.760000000000000000 1570.575454545454545455 Manufacturer#1 almond antique chartreuse lavender yellow 1753.760000000000000000 17276.330000000000000000 1173.150000000000000000 1753.760000000000000000 1570.575454545454545455 -Manufacturer#1 almond aquamarine burnished black steel 1414.420000000000000000 17276.330000000000000000 1173.150000000000000000 1753.760000000000000000 1570.575454545454545455 -Manufacturer#1 almond antique burnished rose metallic 1173.150000000000000000 17276.330000000000000000 1173.150000000000000000 1753.760000000000000000 1570.575454545454545455 Manufacturer#1 almond antique salmon chartreuse burlywood 1602.590000000000000000 17276.330000000000000000 1173.150000000000000000 1753.760000000000000000 1570.575454545454545455 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.760000000000000000 17276.330000000000000000 1173.150000000000000000 1753.760000000000000000 1570.575454545454545455 Manufacturer#1 almond antique burnished rose metallic 1173.150000000000000000 17276.330000000000000000 1173.150000000000000000 1753.760000000000000000 1570.575454545454545455 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.760000000000000000 17276.330000000000000000 1173.150000000000000000 1753.760000000000000000 1570.575454545454545455 +Manufacturer#1 almond aquamarine burnished black steel 1414.420000000000000000 17276.330000000000000000 1173.150000000000000000 1753.760000000000000000 1570.575454545454545455 Manufacturer#1 almond aquamarine pink moccasin thistle NULL 17276.330000000000000000 1173.150000000000000000 1753.760000000000000000 1570.575454545454545455 -Manufacturer#1 almond aquamarine pink moccasin thistle 1632.660000000000000000 17276.330000000000000000 1173.150000000000000000 1753.760000000000000000 1570.575454545454545455 -Manufacturer#3 almond antique forest lavender goldenrod 590.270000000000000000 6386.150000000000000000 55.390000000000000000 1922.980000000000000000 912.307142857142857143 -Manufacturer#3 almond antique metallic orange dim 55.390000000000000000 6386.150000000000000000 55.390000000000000000 1922.980000000000000000 912.307142857142857143 -Manufacturer#3 almond antique forest lavender goldenrod 1190.270000000000000000 6386.150000000000000000 55.390000000000000000 1922.980000000000000000 912.307142857142857143 -Manufacturer#3 almond antique olive coral navajo 1337.290000000000000000 6386.150000000000000000 55.390000000000000000 1922.980000000000000000 912.307142857142857143 -Manufacturer#3 almond antique misty red olive 1922.980000000000000000 6386.150000000000000000 55.390000000000000000 1922.980000000000000000 912.307142857142857143 -Manufacturer#3 almond antique forest lavender goldenrod 1190.270000000000000000 6386.150000000000000000 55.390000000000000000 1922.980000000000000000 912.307142857142857143 -Manufacturer#3 almond antique forest lavender goldenrod NULL 6386.150000000000000000 55.390000000000000000 1922.980000000000000000 912.307142857142857143 -Manufacturer#3 almond antique chartreuse khaki white 99.680000000000000000 6386.150000000000000000 55.390000000000000000 1922.980000000000000000 912.307142857142857143 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.760000000000000000 17276.330000000000000000 1173.150000000000000000 1753.760000000000000000 1570.575454545454545455 +Manufacturer#1 almond antique burnished rose metallic 1173.150000000000000000 17276.330000000000000000 1173.150000000000000000 1753.760000000000000000 1570.575454545454545455 +Manufacturer#5 almond antique medium spring khaki 1611.660000000000000000 9284.320000000000000000 1018.100000000000000000 1789.690000000000000000 1547.386666666666666667 +Manufacturer#5 almond aquamarine dodger light gainsboro 1018.100000000000000000 9284.320000000000000000 1018.100000000000000000 1789.690000000000000000 1547.386666666666666667 +Manufacturer#5 almond antique sky peru orange 1788.730000000000000000 9284.320000000000000000 1018.100000000000000000 1789.690000000000000000 1547.386666666666666667 +Manufacturer#5 almond antique medium spring khaki 1611.660000000000000000 9284.320000000000000000 1018.100000000000000000 1789.690000000000000000 1547.386666666666666667 +Manufacturer#5 almond azure blanched chiffon midnight 1464.480000000000000000 9284.320000000000000000 1018.100000000000000000 1789.690000000000000000 1547.386666666666666667 +Manufacturer#5 almond antique blue firebrick mint 1789.690000000000000000 9284.320000000000000000 1018.100000000000000000 1789.690000000000000000 1547.386666666666666667 PREHOOK: query: explain vectorization detail select p_mfgr,p_name, p_retailprice, sum(p_retailprice) over(partition by p_mfgr order by p_name) as s, @@ -4934,46 +4934,46 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@vector_ptf_part_simple_orc_long #### A masked pattern was here #### p_mfgr p_name p_bigint s mi ma av -Manufacturer#4 almond azure aquamarine papaya violet 129035 571695 120626 184492 142923.75 -Manufacturer#4 almond antique violet mint lemon 137542 571695 120626 184492 142923.75 -Manufacturer#4 almond aquamarine floral ivory bisque NULL 571695 120626 184492 142923.75 -Manufacturer#4 almond antique gainsboro frosted violet NULL 571695 120626 184492 142923.75 -Manufacturer#4 almond aquamarine yellow dodger mint 184492 571695 120626 184492 142923.75 -Manufacturer#4 almond aquamarine floral ivory bisque 120626 571695 120626 184492 142923.75 -Manufacturer#5 almond azure blanched chiffon midnight 146448 928432 101810 178969 154738.66666666666 -Manufacturer#5 almond aquamarine dodger light gainsboro 101810 928432 101810 178969 154738.66666666666 -Manufacturer#5 almond antique medium spring khaki 161166 928432 101810 178969 154738.66666666666 -Manufacturer#5 almond antique blue firebrick mint 178969 928432 101810 178969 154738.66666666666 -Manufacturer#5 almond antique medium spring khaki 161166 928432 101810 178969 154738.66666666666 -Manufacturer#5 almond antique sky peru orange 178873 928432 101810 178969 154738.66666666666 Manufacturer#2 almond aquamarine rose maroon antique 90066 1272468 90066 203198 159058.5 Manufacturer#2 almond aquamarine rose maroon antique 169866 1272468 90066 203198 159058.5 Manufacturer#2 almond antique violet turquoise frosted 180070 1272468 90066 203198 159058.5 Manufacturer#2 almond antique violet chocolate turquoise 169068 1272468 90066 203198 159058.5 Manufacturer#2 almond antique violet turquoise frosted 180070 1272468 90066 203198 159058.5 +Manufacturer#2 almond antique violet turquoise frosted 180070 1272468 90066 203198 159058.5 Manufacturer#2 almond aquamarine sandy cyan gainsboro 100060 1272468 90066 203198 159058.5 Manufacturer#2 almond aquamarine midnight light salmon 203198 1272468 90066 203198 159058.5 -Manufacturer#2 almond antique violet turquoise frosted 180070 1272468 90066 203198 159058.5 +Manufacturer#3 almond antique forest lavender goldenrod NULL 638615 5539 192298 91230.71428571429 +Manufacturer#3 almond antique forest lavender goldenrod 119027 638615 5539 192298 91230.71428571429 +Manufacturer#3 almond antique forest lavender goldenrod 59027 638615 5539 192298 91230.71428571429 +Manufacturer#3 almond antique forest lavender goldenrod 119027 638615 5539 192298 91230.71428571429 +Manufacturer#3 almond antique metallic orange dim 5539 638615 5539 192298 91230.71428571429 +Manufacturer#3 almond antique olive coral navajo 133729 638615 5539 192298 91230.71428571429 +Manufacturer#3 almond antique chartreuse khaki white 9968 638615 5539 192298 91230.71428571429 +Manufacturer#3 almond antique misty red olive 192298 638615 5539 192298 91230.71428571429 +Manufacturer#4 almond aquamarine floral ivory bisque NULL 571695 120626 184492 142923.75 +Manufacturer#4 almond antique gainsboro frosted violet NULL 571695 120626 184492 142923.75 +Manufacturer#4 almond aquamarine floral ivory bisque 120626 571695 120626 184492 142923.75 +Manufacturer#4 almond aquamarine yellow dodger mint 184492 571695 120626 184492 142923.75 +Manufacturer#4 almond azure aquamarine papaya violet 129035 571695 120626 184492 142923.75 +Manufacturer#4 almond antique violet mint lemon 137542 571695 120626 184492 142923.75 +Manufacturer#1 almond aquamarine pink moccasin thistle 163266 1727633 117315 175376 157057.54545454544 Manufacturer#1 almond antique chartreuse lavender yellow 175376 1727633 117315 175376 157057.54545454544 Manufacturer#1 almond aquamarine pink moccasin thistle 163266 1727633 117315 175376 157057.54545454544 +Manufacturer#1 almond antique chartreuse lavender yellow 175376 1727633 117315 175376 157057.54545454544 Manufacturer#1 almond aquamarine pink moccasin thistle 163266 1727633 117315 175376 157057.54545454544 Manufacturer#1 almond antique chartreuse lavender yellow 175376 1727633 117315 175376 157057.54545454544 -Manufacturer#1 almond aquamarine burnished black steel 141442 1727633 117315 175376 157057.54545454544 -Manufacturer#1 almond antique burnished rose metallic 117315 1727633 117315 175376 157057.54545454544 Manufacturer#1 almond antique salmon chartreuse burlywood 160259 1727633 117315 175376 157057.54545454544 -Manufacturer#1 almond antique chartreuse lavender yellow 175376 1727633 117315 175376 157057.54545454544 Manufacturer#1 almond antique burnished rose metallic 117315 1727633 117315 175376 157057.54545454544 -Manufacturer#1 almond antique chartreuse lavender yellow 175376 1727633 117315 175376 157057.54545454544 +Manufacturer#1 almond aquamarine burnished black steel 141442 1727633 117315 175376 157057.54545454544 Manufacturer#1 almond aquamarine pink moccasin thistle NULL 1727633 117315 175376 157057.54545454544 -Manufacturer#1 almond aquamarine pink moccasin thistle 163266 1727633 117315 175376 157057.54545454544 -Manufacturer#3 almond antique forest lavender goldenrod 59027 638615 5539 192298 91230.71428571429 -Manufacturer#3 almond antique metallic orange dim 5539 638615 5539 192298 91230.71428571429 -Manufacturer#3 almond antique forest lavender goldenrod 119027 638615 5539 192298 91230.71428571429 -Manufacturer#3 almond antique olive coral navajo 133729 638615 5539 192298 91230.71428571429 -Manufacturer#3 almond antique misty red olive 192298 638615 5539 192298 91230.71428571429 -Manufacturer#3 almond antique forest lavender goldenrod 119027 638615 5539 192298 91230.71428571429 -Manufacturer#3 almond antique forest lavender goldenrod NULL 638615 5539 192298 91230.71428571429 -Manufacturer#3 almond antique chartreuse khaki white 9968 638615 5539 192298 91230.71428571429 +Manufacturer#1 almond antique chartreuse lavender yellow 175376 1727633 117315 175376 157057.54545454544 +Manufacturer#1 almond antique burnished rose metallic 117315 1727633 117315 175376 157057.54545454544 +Manufacturer#5 almond antique medium spring khaki 161166 928432 101810 178969 154738.66666666666 +Manufacturer#5 almond aquamarine dodger light gainsboro 101810 928432 101810 178969 154738.66666666666 +Manufacturer#5 almond antique sky peru orange 178873 928432 101810 178969 154738.66666666666 +Manufacturer#5 almond antique medium spring khaki 161166 928432 101810 178969 154738.66666666666 +Manufacturer#5 almond azure blanched chiffon midnight 146448 928432 101810 178969 154738.66666666666 +Manufacturer#5 almond antique blue firebrick mint 178969 928432 101810 178969 154738.66666666666 PREHOOK: query: explain vectorization detail select p_mfgr,p_name, p_bigint, sum(p_bigint) over(partition by p_mfgr order by p_name) as s, @@ -5363,46 +5363,46 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@vector_ptf_part_simple_orc #### A masked pattern was here #### p_mfgr p_retailprice r -Manufacturer#4 1290.35 1 -Manufacturer#4 1375.42 1 -Manufacturer#4 NULL 1 -Manufacturer#4 NULL 1 -Manufacturer#4 1844.92 1 -Manufacturer#4 1206.26 1 -Manufacturer#5 1464.48 1 -Manufacturer#5 1018.1 1 -Manufacturer#5 1611.66 1 -Manufacturer#5 1789.69 1 -Manufacturer#5 1611.66 1 -Manufacturer#5 1788.73 1 Manufacturer#2 900.66 1 Manufacturer#2 1698.66 1 Manufacturer#2 1800.7 1 Manufacturer#2 1690.68 1 Manufacturer#2 1800.7 1 +Manufacturer#2 1800.7 1 Manufacturer#2 1000.6 1 Manufacturer#2 2031.98 1 -Manufacturer#2 1800.7 1 +Manufacturer#3 NULL 1 +Manufacturer#3 1190.27 1 +Manufacturer#3 590.27 1 +Manufacturer#3 1190.27 1 +Manufacturer#3 55.39 1 +Manufacturer#3 1337.29 1 +Manufacturer#3 99.68 1 +Manufacturer#3 1922.98 1 +Manufacturer#4 NULL 1 +Manufacturer#4 NULL 1 +Manufacturer#4 1206.26 1 +Manufacturer#4 1844.92 1 +Manufacturer#4 1290.35 1 +Manufacturer#4 1375.42 1 +Manufacturer#1 1632.66 1 Manufacturer#1 1753.76 1 Manufacturer#1 1632.66 1 +Manufacturer#1 1753.76 1 Manufacturer#1 1632.66 1 Manufacturer#1 1753.76 1 -Manufacturer#1 1414.42 1 -Manufacturer#1 1173.15 1 Manufacturer#1 1602.59 1 -Manufacturer#1 1753.76 1 Manufacturer#1 1173.15 1 -Manufacturer#1 1753.76 1 +Manufacturer#1 1414.42 1 Manufacturer#1 NULL 1 -Manufacturer#1 1632.66 1 -Manufacturer#3 590.27 1 -Manufacturer#3 55.39 1 -Manufacturer#3 1190.27 1 -Manufacturer#3 1337.29 1 -Manufacturer#3 1922.98 1 -Manufacturer#3 1190.27 1 -Manufacturer#3 NULL 1 -Manufacturer#3 99.68 1 +Manufacturer#1 1753.76 1 +Manufacturer#1 1173.15 1 +Manufacturer#5 1611.66 1 +Manufacturer#5 1018.1 1 +Manufacturer#5 1788.73 1 +Manufacturer#5 1611.66 1 +Manufacturer#5 1464.48 1 +Manufacturer#5 1789.69 1 PREHOOK: query: explain vectorization detail select p_mfgr, p_retailprice, rank() over(partition by p_mfgr order by p_name) as r @@ -5733,18 +5733,6 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@vector_ptf_part_simple_orc #### A masked pattern was here #### p_mfgr p_name p_retailprice r -Manufacturer#1 almond aquamarine burnished black steel 1414.42 1 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 -Manufacturer#1 almond aquamarine pink moccasin thistle NULL 1 -Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 -Manufacturer#1 almond antique burnished rose metallic 1173.15 1 -Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 1 -Manufacturer#1 almond antique burnished rose metallic 1173.15 1 -Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 -Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 Manufacturer#2 almond aquamarine rose maroon antique 900.66 1 Manufacturer#2 almond aquamarine rose maroon antique 1698.66 1 Manufacturer#2 almond antique violet turquoise frosted 1800.7 1 @@ -5753,26 +5741,38 @@ Manufacturer#2 almond antique violet turquoise frosted 1800.7 1 Manufacturer#2 almond antique violet turquoise frosted 1800.7 1 Manufacturer#2 almond aquamarine sandy cyan gainsboro 1000.6 1 Manufacturer#2 almond aquamarine midnight light salmon 2031.98 1 -Manufacturer#4 almond antique violet mint lemon 1375.42 1 -Manufacturer#4 almond antique gainsboro frosted violet NULL 1 -Manufacturer#4 almond aquamarine floral ivory bisque NULL 1 -Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 1 +Manufacturer#5 almond antique sky peru orange 1788.73 1 +Manufacturer#5 almond antique medium spring khaki 1611.66 1 +Manufacturer#5 almond antique medium spring khaki 1611.66 1 +Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 1 +Manufacturer#5 almond azure blanched chiffon midnight 1464.48 1 +Manufacturer#5 almond antique blue firebrick mint 1789.69 1 Manufacturer#4 almond azure aquamarine papaya violet 1290.35 1 +Manufacturer#4 almond aquamarine floral ivory bisque NULL 1 +Manufacturer#4 almond antique gainsboro frosted violet NULL 1 +Manufacturer#4 almond antique violet mint lemon 1375.42 1 Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 1 -Manufacturer#3 almond antique misty red olive 1922.98 1 -Manufacturer#3 almond antique chartreuse khaki white 99.68 1 +Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 1 +Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 +Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 +Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 +Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 1 +Manufacturer#1 almond antique burnished rose metallic 1173.15 1 +Manufacturer#1 almond aquamarine burnished black steel 1414.42 1 +Manufacturer#1 almond aquamarine pink moccasin thistle NULL 1 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 +Manufacturer#1 almond antique burnished rose metallic 1173.15 1 +Manufacturer#3 almond antique forest lavender goldenrod 1190.27 1 Manufacturer#3 almond antique forest lavender goldenrod 1190.27 1 Manufacturer#3 almond antique metallic orange dim 55.39 1 Manufacturer#3 almond antique olive coral navajo 1337.29 1 -Manufacturer#3 almond antique forest lavender goldenrod 1190.27 1 +Manufacturer#3 almond antique chartreuse khaki white 99.68 1 Manufacturer#3 almond antique forest lavender goldenrod 590.27 1 +Manufacturer#3 almond antique misty red olive 1922.98 1 Manufacturer#3 almond antique forest lavender goldenrod NULL 1 -Manufacturer#5 almond antique medium spring khaki 1611.66 1 -Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 1 -Manufacturer#5 almond antique sky peru orange 1788.73 1 -Manufacturer#5 almond antique medium spring khaki 1611.66 1 -Manufacturer#5 almond azure blanched chiffon midnight 1464.48 1 -Manufacturer#5 almond antique blue firebrick mint 1789.69 1 PREHOOK: query: explain vectorization detail select p_mfgr, p_name, p_retailprice, rank() over(partition by p_mfgr, case when p_mfgr == "Manufacturer#2" then timestamp "2000-01-01 00:00:00" end order by p_name) as r @@ -6000,46 +6000,46 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@vector_ptf_part_simple_orc #### A masked pattern was here #### p_mfgr p_name p_retailprice rn r dr fv lv c cs -Manufacturer#4 almond azure aquamarine papaya violet 1290.35 1 1 1 1290.35 1206.26 4 6 -Manufacturer#4 almond antique violet mint lemon 1375.42 2 1 1 1290.35 1206.26 4 6 -Manufacturer#4 almond aquamarine floral ivory bisque NULL 3 1 1 1290.35 1206.26 4 6 -Manufacturer#4 almond antique gainsboro frosted violet NULL 4 1 1 1290.35 1206.26 4 6 -Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 5 1 1 1290.35 1206.26 4 6 -Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 6 1 1 1290.35 1206.26 4 6 -Manufacturer#5 almond azure blanched chiffon midnight 1464.48 1 1 1 1464.48 1788.73 6 6 -Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 2 1 1 1464.48 1788.73 6 6 -Manufacturer#5 almond antique medium spring khaki 1611.66 3 1 1 1464.48 1788.73 6 6 -Manufacturer#5 almond antique blue firebrick mint 1789.69 4 1 1 1464.48 1788.73 6 6 -Manufacturer#5 almond antique medium spring khaki 1611.66 5 1 1 1464.48 1788.73 6 6 -Manufacturer#5 almond antique sky peru orange 1788.73 6 1 1 1464.48 1788.73 6 6 -Manufacturer#2 almond aquamarine rose maroon antique 900.66 1 1 1 900.66 1800.7 8 8 -Manufacturer#2 almond aquamarine rose maroon antique 1698.66 2 1 1 900.66 1800.7 8 8 -Manufacturer#2 almond antique violet turquoise frosted 1800.7 3 1 1 900.66 1800.7 8 8 -Manufacturer#2 almond antique violet chocolate turquoise 1690.68 4 1 1 900.66 1800.7 8 8 -Manufacturer#2 almond antique violet turquoise frosted 1800.7 5 1 1 900.66 1800.7 8 8 -Manufacturer#2 almond aquamarine sandy cyan gainsboro 1000.6 6 1 1 900.66 1800.7 8 8 -Manufacturer#2 almond aquamarine midnight light salmon 2031.98 7 1 1 900.66 1800.7 8 8 -Manufacturer#2 almond antique violet turquoise frosted 1800.7 8 1 1 900.66 1800.7 8 8 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 2 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 3 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 4 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond aquamarine burnished black steel 1414.42 5 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond antique burnished rose metallic 1173.15 6 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 7 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 8 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond antique burnished rose metallic 1173.15 9 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 10 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond aquamarine pink moccasin thistle NULL 11 1 1 1753.76 1632.66 11 12 -Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 12 1 1 1753.76 1632.66 11 12 -Manufacturer#3 almond antique forest lavender goldenrod 590.27 1 1 1 590.27 99.68 7 8 -Manufacturer#3 almond antique metallic orange dim 55.39 2 1 1 590.27 99.68 7 8 -Manufacturer#3 almond antique forest lavender goldenrod 1190.27 3 1 1 590.27 99.68 7 8 -Manufacturer#3 almond antique olive coral navajo 1337.29 4 1 1 590.27 99.68 7 8 -Manufacturer#3 almond antique misty red olive 1922.98 5 1 1 590.27 99.68 7 8 -Manufacturer#3 almond antique forest lavender goldenrod 1190.27 6 1 1 590.27 99.68 7 8 -Manufacturer#3 almond antique forest lavender goldenrod NULL 7 1 1 590.27 99.68 7 8 -Manufacturer#3 almond antique chartreuse khaki white 99.68 8 1 1 590.27 99.68 7 8 +Manufacturer#2 almond aquamarine rose maroon antique 900.66 1 1 1 900.66 2031.98 8 8 +Manufacturer#2 almond aquamarine rose maroon antique 1698.66 2 1 1 900.66 2031.98 8 8 +Manufacturer#2 almond antique violet turquoise frosted 1800.7 3 1 1 900.66 2031.98 8 8 +Manufacturer#2 almond antique violet chocolate turquoise 1690.68 4 1 1 900.66 2031.98 8 8 +Manufacturer#2 almond antique violet turquoise frosted 1800.7 5 1 1 900.66 2031.98 8 8 +Manufacturer#2 almond antique violet turquoise frosted 1800.7 6 1 1 900.66 2031.98 8 8 +Manufacturer#2 almond aquamarine sandy cyan gainsboro 1000.6 7 1 1 900.66 2031.98 8 8 +Manufacturer#2 almond aquamarine midnight light salmon 2031.98 8 1 1 900.66 2031.98 8 8 +Manufacturer#3 almond antique forest lavender goldenrod NULL 1 1 1 NULL 1922.98 7 8 +Manufacturer#3 almond antique forest lavender goldenrod 1190.27 2 1 1 NULL 1922.98 7 8 +Manufacturer#3 almond antique forest lavender goldenrod 590.27 3 1 1 NULL 1922.98 7 8 +Manufacturer#3 almond antique forest lavender goldenrod 1190.27 4 1 1 NULL 1922.98 7 8 +Manufacturer#3 almond antique metallic orange dim 55.39 5 1 1 NULL 1922.98 7 8 +Manufacturer#3 almond antique olive coral navajo 1337.29 6 1 1 NULL 1922.98 7 8 +Manufacturer#3 almond antique chartreuse khaki white 99.68 7 1 1 NULL 1922.98 7 8 +Manufacturer#3 almond antique misty red olive 1922.98 8 1 1 NULL 1922.98 7 8 +Manufacturer#4 almond aquamarine floral ivory bisque NULL 1 1 1 NULL 1375.42 4 6 +Manufacturer#4 almond antique gainsboro frosted violet NULL 2 1 1 NULL 1375.42 4 6 +Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 3 1 1 NULL 1375.42 4 6 +Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 4 1 1 NULL 1375.42 4 6 +Manufacturer#4 almond azure aquamarine papaya violet 1290.35 5 1 1 NULL 1375.42 4 6 +Manufacturer#4 almond antique violet mint lemon 1375.42 6 1 1 NULL 1375.42 4 6 +Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 2 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 3 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 4 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 5 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 6 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 7 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond antique burnished rose metallic 1173.15 8 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond aquamarine burnished black steel 1414.42 9 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond aquamarine pink moccasin thistle NULL 10 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 11 1 1 1632.66 1173.15 11 12 +Manufacturer#1 almond antique burnished rose metallic 1173.15 12 1 1 1632.66 1173.15 11 12 +Manufacturer#5 almond antique medium spring khaki 1611.66 1 1 1 1611.66 1789.69 6 6 +Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 2 1 1 1611.66 1789.69 6 6 +Manufacturer#5 almond antique sky peru orange 1788.73 3 1 1 1611.66 1789.69 6 6 +Manufacturer#5 almond antique medium spring khaki 1611.66 4 1 1 1611.66 1789.69 6 6 +Manufacturer#5 almond azure blanched chiffon midnight 1464.48 5 1 1 1611.66 1789.69 6 6 +Manufacturer#5 almond antique blue firebrick mint 1789.69 6 1 1 1611.66 1789.69 6 6 PREHOOK: query: select p_mfgr,p_name, p_retailprice, row_number() over(partition by p_mfgr order by p_name) as rn, rank() over(partition by p_mfgr order by p_name) as r, @@ -6264,46 +6264,46 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@vector_ptf_part_simple_orc #### A masked pattern was here #### p_mfgr p_retailprice r -Manufacturer#4 1290.35 1 -Manufacturer#4 1375.42 1 -Manufacturer#4 NULL 1 -Manufacturer#4 NULL 1 -Manufacturer#4 1844.92 1 -Manufacturer#4 1206.26 1 -Manufacturer#5 1464.48 1 -Manufacturer#5 1018.1 1 -Manufacturer#5 1611.66 1 -Manufacturer#5 1789.69 1 -Manufacturer#5 1611.66 1 -Manufacturer#5 1788.73 1 Manufacturer#2 900.66 1 Manufacturer#2 1698.66 1 Manufacturer#2 1800.7 1 Manufacturer#2 1690.68 1 Manufacturer#2 1800.7 1 +Manufacturer#2 1800.7 1 Manufacturer#2 1000.6 1 Manufacturer#2 2031.98 1 -Manufacturer#2 1800.7 1 +Manufacturer#3 NULL 1 +Manufacturer#3 1190.27 1 +Manufacturer#3 590.27 1 +Manufacturer#3 1190.27 1 +Manufacturer#3 55.39 1 +Manufacturer#3 1337.29 1 +Manufacturer#3 99.68 1 +Manufacturer#3 1922.98 1 +Manufacturer#4 NULL 1 +Manufacturer#4 NULL 1 +Manufacturer#4 1206.26 1 +Manufacturer#4 1844.92 1 +Manufacturer#4 1290.35 1 +Manufacturer#4 1375.42 1 +Manufacturer#1 1632.66 1 Manufacturer#1 1753.76 1 Manufacturer#1 1632.66 1 +Manufacturer#1 1753.76 1 Manufacturer#1 1632.66 1 Manufacturer#1 1753.76 1 -Manufacturer#1 1414.42 1 -Manufacturer#1 1173.15 1 Manufacturer#1 1602.59 1 -Manufacturer#1 1753.76 1 Manufacturer#1 1173.15 1 -Manufacturer#1 1753.76 1 +Manufacturer#1 1414.42 1 Manufacturer#1 NULL 1 -Manufacturer#1 1632.66 1 -Manufacturer#3 590.27 1 -Manufacturer#3 55.39 1 -Manufacturer#3 1190.27 1 -Manufacturer#3 1337.29 1 -Manufacturer#3 1922.98 1 -Manufacturer#3 1190.27 1 -Manufacturer#3 NULL 1 -Manufacturer#3 99.68 1 +Manufacturer#1 1753.76 1 +Manufacturer#1 1173.15 1 +Manufacturer#5 1611.66 1 +Manufacturer#5 1018.1 1 +Manufacturer#5 1788.73 1 +Manufacturer#5 1611.66 1 +Manufacturer#5 1464.48 1 +Manufacturer#5 1789.69 1 PREHOOK: query: explain vectorization detail select p_mfgr, p_retailprice, rank() over(partition by p_mfgr order by p_name) as r @@ -6836,18 +6836,6 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@vector_ptf_part_simple_orc #### A masked pattern was here #### p_mfgr p_name p_retailprice r -Manufacturer#1 almond aquamarine burnished black steel 1414.42 1 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 -Manufacturer#1 almond aquamarine pink moccasin thistle NULL 1 -Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 -Manufacturer#1 almond antique burnished rose metallic 1173.15 1 -Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 1 -Manufacturer#1 almond antique burnished rose metallic 1173.15 1 -Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 -Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 Manufacturer#2 almond aquamarine rose maroon antique 900.66 1 Manufacturer#2 almond aquamarine rose maroon antique 1698.66 1 Manufacturer#2 almond antique violet turquoise frosted 1800.7 1 @@ -6856,23 +6844,35 @@ Manufacturer#2 almond antique violet turquoise frosted 1800.7 1 Manufacturer#2 almond antique violet turquoise frosted 1800.7 1 Manufacturer#2 almond aquamarine sandy cyan gainsboro 1000.6 1 Manufacturer#2 almond aquamarine midnight light salmon 2031.98 1 -Manufacturer#4 almond antique violet mint lemon 1375.42 1 -Manufacturer#4 almond antique gainsboro frosted violet NULL 1 -Manufacturer#4 almond aquamarine floral ivory bisque NULL 1 -Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 1 +Manufacturer#5 almond antique sky peru orange 1788.73 1 +Manufacturer#5 almond antique medium spring khaki 1611.66 1 +Manufacturer#5 almond antique medium spring khaki 1611.66 1 +Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 1 +Manufacturer#5 almond azure blanched chiffon midnight 1464.48 1 +Manufacturer#5 almond antique blue firebrick mint 1789.69 1 Manufacturer#4 almond azure aquamarine papaya violet 1290.35 1 +Manufacturer#4 almond aquamarine floral ivory bisque NULL 1 +Manufacturer#4 almond antique gainsboro frosted violet NULL 1 +Manufacturer#4 almond antique violet mint lemon 1375.42 1 Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 1 -Manufacturer#3 almond antique misty red olive 1922.98 1 -Manufacturer#3 almond antique chartreuse khaki white 99.68 1 +Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 1 +Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 +Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 +Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 +Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 1 +Manufacturer#1 almond antique burnished rose metallic 1173.15 1 +Manufacturer#1 almond aquamarine burnished black steel 1414.42 1 +Manufacturer#1 almond aquamarine pink moccasin thistle NULL 1 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 +Manufacturer#1 almond antique burnished rose metallic 1173.15 1 +Manufacturer#3 almond antique forest lavender goldenrod 1190.27 1 Manufacturer#3 almond antique forest lavender goldenrod 1190.27 1 Manufacturer#3 almond antique metallic orange dim 55.39 1 Manufacturer#3 almond antique olive coral navajo 1337.29 1 -Manufacturer#3 almond antique forest lavender goldenrod 1190.27 1 +Manufacturer#3 almond antique chartreuse khaki white 99.68 1 Manufacturer#3 almond antique forest lavender goldenrod 590.27 1 +Manufacturer#3 almond antique misty red olive 1922.98 1 Manufacturer#3 almond antique forest lavender goldenrod NULL 1 -Manufacturer#5 almond antique medium spring khaki 1611.66 1 -Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 1 -Manufacturer#5 almond antique sky peru orange 1788.73 1 -Manufacturer#5 almond antique medium spring khaki 1611.66 1 -Manufacturer#5 almond azure blanched chiffon midnight 1464.48 1 -Manufacturer#5 almond antique blue firebrick mint 1789.69 1
http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/vector_windowing_expressions.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_windowing_expressions.q.out b/ql/src/test/results/clientpositive/llap/vector_windowing_expressions.q.out index 401a73e..18bda85 100644 --- a/ql/src/test/results/clientpositive/llap/vector_windowing_expressions.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_windowing_expressions.q.out @@ -1457,32 +1457,32 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@part #### A masked pattern was here #### p_mfgr avg_window_0 -Manufacturer#2 1800.7 -Manufacturer#4 1375.42 +Manufacturer#1 1753.76 +Manufacturer#3 1410.39 Manufacturer#4 1620.67 -Manufacturer#4 1206.26 +Manufacturer#5 1018.1 Manufacturer#5 1788.73 -Manufacturer#1 1632.66 +Manufacturer#1 1173.15 +Manufacturer#1 1173.15 +Manufacturer#2 1800.7 Manufacturer#2 1690.68 -Manufacturer#2 1698.66 -Manufacturer#2 1701.6 -Manufacturer#3 1337.29 +Manufacturer#3 1922.98 Manufacturer#4 1844.92 Manufacturer#4 1290.35 -Manufacturer#5 1018.1 Manufacturer#5 1789.69 -Manufacturer#1 1753.76 -Manufacturer#1 1602.59 -Manufacturer#1 1173.15 -Manufacturer#1 1173.15 Manufacturer#1 1414.42 -Manufacturer#2 2031.98 -Manufacturer#3 1922.98 -Manufacturer#3 1410.39 +Manufacturer#2 1701.6 Manufacturer#3 1190.27 -Manufacturer#5 1464.48 +Manufacturer#3 1337.29 +Manufacturer#4 1206.26 Manufacturer#5 1611.66 +Manufacturer#1 1632.66 +Manufacturer#1 1602.59 +Manufacturer#2 2031.98 +Manufacturer#2 1698.66 Manufacturer#3 1671.68 +Manufacturer#4 1375.42 +Manufacturer#5 1464.48 PREHOOK: query: explain vectorization detail select p_mfgr, avg(p_retailprice) over(partition by p_mfgr order by p_type,p_mfgr rows between unbounded preceding and current row) from part PREHOOK: type: QUERY @@ -2145,32 +2145,32 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@part #### A masked pattern was here #### p_mfgr avg_window_0 -Manufacturer#2 1800.7 -Manufacturer#4 1375.42 +Manufacturer#1 1753.76 +Manufacturer#3 1410.39 Manufacturer#4 1620.67 -Manufacturer#4 1206.26 +Manufacturer#5 1018.1 Manufacturer#5 1788.73 -Manufacturer#1 1632.66 +Manufacturer#1 1173.15 +Manufacturer#1 1173.15 +Manufacturer#2 1800.7 Manufacturer#2 1690.68 -Manufacturer#2 1698.66 -Manufacturer#2 1701.6 -Manufacturer#3 1337.29 +Manufacturer#3 1922.98 Manufacturer#4 1844.92 Manufacturer#4 1290.35 -Manufacturer#5 1018.1 Manufacturer#5 1789.69 -Manufacturer#1 1753.76 -Manufacturer#1 1602.59 -Manufacturer#1 1173.15 -Manufacturer#1 1173.15 Manufacturer#1 1414.42 -Manufacturer#2 2031.98 -Manufacturer#3 1922.98 -Manufacturer#3 1410.39 +Manufacturer#2 1701.6 Manufacturer#3 1190.27 -Manufacturer#5 1464.48 +Manufacturer#3 1337.29 +Manufacturer#4 1206.26 Manufacturer#5 1611.66 +Manufacturer#1 1632.66 +Manufacturer#1 1602.59 +Manufacturer#2 2031.98 +Manufacturer#2 1698.66 Manufacturer#3 1671.68 +Manufacturer#4 1375.42 +Manufacturer#5 1464.48 PREHOOK: query: select p_mfgr, avg(p_retailprice) over(partition by p_mfgr order by p_type,p_mfgr rows between unbounded preceding and current row) from part PREHOOK: type: QUERY PREHOOK: Input: default@part http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/vector_windowing_multipartitioning.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_windowing_multipartitioning.q.out b/ql/src/test/results/clientpositive/llap/vector_windowing_multipartitioning.q.out index 595b0a8..09ecb775 100644 --- a/ql/src/test/results/clientpositive/llap/vector_windowing_multipartitioning.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_windowing_multipartitioning.q.out @@ -10724,36 +10724,36 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@over10k #### A masked pattern was here #### s _c1 sum_window_1 -bob steinbeck 722083 38.33000183105469 -tom allen 1248023 89.88999938964844 -tom allen 1248023 83.47000122070312 -bob steinbeck 722083 47.810001373291016 -bob steinbeck 722083 68.46999740600586 -tom allen 1248023 68.46999740600586 -bob steinbeck 722083 28.479999542236328 -tom allen 1248023 2.8499999046325684 -bob steinbeck 722083 26.290000915527344 -bob steinbeck 722083 36.209999084472656 +tom allen 1248023 47.16999816894531 +tom allen 1248023 77.77999877929688 bob steinbeck 722083 83.52999877929688 +tom allen 1248023 83.47000122070312 +tom allen 1248023 15.84000015258789 tom allen 1248023 39.4900016784668 bob steinbeck 722083 80.7300033569336 -tom allen 1248023 77.77999877929688 -tom allen 1248023 26.239999771118164 -tom allen 1248023 95.41000366210938 -tom allen 1248023 81.8499984741211 tom allen 1248023 11.300000190734863 +tom allen 1248023 2.8499999046325684 +tom allen 1248023 19.459999084472656 +bob steinbeck 722083 26.290000915527344 +tom allen 1248023 14.510000228881836 +bob steinbeck 722083 83.52999877929688 +tom allen 1248023 52.779998779296875 +bob steinbeck 722083 9.699999809265137 tom allen 1248023 55.38999938964844 tom allen 1248023 132.82000350952148 bob steinbeck 722083 132.82000350952148 -tom allen 1248023 47.16999816894531 tom allen 1248023 11.069999694824219 -bob steinbeck 722083 83.52999877929688 -tom allen 1248023 19.459999084472656 -tom allen 1248023 14.510000228881836 +bob steinbeck 722083 38.33000183105469 +tom allen 1248023 26.239999771118164 +bob steinbeck 722083 47.810001373291016 +bob steinbeck 722083 68.46999740600586 +tom allen 1248023 68.46999740600586 +bob steinbeck 722083 28.479999542236328 +bob steinbeck 722083 36.209999084472656 +tom allen 1248023 95.41000366210938 +tom allen 1248023 89.88999938964844 tom allen 1248023 38.93000030517578 -tom allen 1248023 15.84000015258789 -tom allen 1248023 52.779998779296875 -bob steinbeck 722083 9.699999809265137 +tom allen 1248023 81.8499984741211 PREHOOK: query: explain vectorization detail select s, rank() over (partition by s order by bo), rank() over (partition by si order by bin desc) from over10k where s = 'tom allen' or s = 'bob steinbeck'
