You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2018/10/18 18:35:43 UTC
[3/7] hive git commit: HIVE-20572 : Change default value of
hive.tez.llap.min.reducer.per.executor
http://git-wip-us.apache.org/repos/asf/hive/blob/f89274ab/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 6fa48e8..3c189d9 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
@@ -321,20 +321,26 @@ Manufacturer#2 almond antique violet turquoise frosted 1800.7 5 1 1 900.66 2031.
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#3 almond antique forest lavender goldenrod 1190.27 1 1 1 1190.27 1190.27 7 8
+Manufacturer#3 almond antique chartreuse khaki white 99.68 2 1 1 1190.27 1190.27 7 8
+Manufacturer#3 almond antique forest lavender goldenrod NULL 3 1 1 1190.27 1190.27 7 8
+Manufacturer#3 almond antique metallic orange dim 55.39 4 1 1 1190.27 1190.27 7 8
+Manufacturer#3 almond antique misty red olive 1922.98 5 1 1 1190.27 1190.27 7 8
+Manufacturer#3 almond antique forest lavender goldenrod 590.27 6 1 1 1190.27 1190.27 7 8
+Manufacturer#3 almond antique olive coral navajo 1337.29 7 1 1 1190.27 1190.27 7 8
+Manufacturer#3 almond antique forest lavender goldenrod 1190.27 8 1 1 1190.27 1190.27 7 8
+Manufacturer#4 almond antique gainsboro frosted violet NULL 1 1 1 NULL 1290.35 4 6
+Manufacturer#4 almond aquamarine floral ivory bisque NULL 2 1 1 NULL 1290.35 4 6
+Manufacturer#4 almond antique violet mint lemon 1375.42 3 1 1 NULL 1290.35 4 6
+Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 4 1 1 NULL 1290.35 4 6
+Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 5 1 1 NULL 1290.35 4 6
+Manufacturer#4 almond azure aquamarine papaya violet 1290.35 6 1 1 NULL 1290.35 4 6
+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 azure blanched chiffon midnight 1464.48 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 antique sky peru orange 1788.73 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
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
@@ -347,12 +353,6 @@ Manufacturer#1 almond aquamarine burnished black steel 1414.42 9 1 1 1632.66 117
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,
@@ -554,20 +554,26 @@ Manufacturer#2 almond antique violet turquoise frosted 1800.7 5 1 1 900.66 2031.
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#3 almond antique forest lavender goldenrod 1190.27 1 1 1 1190.27 1190.27 7 8
+Manufacturer#3 almond antique chartreuse khaki white 99.68 2 1 1 1190.27 1190.27 7 8
+Manufacturer#3 almond antique forest lavender goldenrod NULL 3 1 1 1190.27 1190.27 7 8
+Manufacturer#3 almond antique metallic orange dim 55.39 4 1 1 1190.27 1190.27 7 8
+Manufacturer#3 almond antique misty red olive 1922.98 5 1 1 1190.27 1190.27 7 8
+Manufacturer#3 almond antique forest lavender goldenrod 590.27 6 1 1 1190.27 1190.27 7 8
+Manufacturer#3 almond antique olive coral navajo 1337.29 7 1 1 1190.27 1190.27 7 8
+Manufacturer#3 almond antique forest lavender goldenrod 1190.27 8 1 1 1190.27 1190.27 7 8
+Manufacturer#4 almond antique gainsboro frosted violet NULL 1 1 1 NULL 1290.35 4 6
+Manufacturer#4 almond aquamarine floral ivory bisque NULL 2 1 1 NULL 1290.35 4 6
+Manufacturer#4 almond antique violet mint lemon 1375.42 3 1 1 NULL 1290.35 4 6
+Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 4 1 1 NULL 1290.35 4 6
+Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 5 1 1 NULL 1290.35 4 6
+Manufacturer#4 almond azure aquamarine papaya violet 1290.35 6 1 1 NULL 1290.35 4 6
+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 azure blanched chiffon midnight 1464.48 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 antique sky peru orange 1788.73 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
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
@@ -580,12 +586,6 @@ Manufacturer#1 almond aquamarine burnished black steel 1414.42 9 1 1 1632.66 117
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,
@@ -787,20 +787,26 @@ Manufacturer#2 almond antique violet turquoise frosted 1800.7 5 1 1 900.66 1800.
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#3 almond antique forest lavender goldenrod 1190.27 1 1 1 1190.27 1190.27 1 1
+Manufacturer#3 almond antique chartreuse khaki white 99.68 2 1 1 1190.27 99.68 2 2
+Manufacturer#3 almond antique forest lavender goldenrod NULL 3 1 1 1190.27 NULL 2 3
+Manufacturer#3 almond antique metallic orange dim 55.39 4 1 1 1190.27 55.39 3 4
+Manufacturer#3 almond antique misty red olive 1922.98 5 1 1 1190.27 1922.98 4 5
+Manufacturer#3 almond antique forest lavender goldenrod 590.27 6 1 1 1190.27 590.27 5 6
+Manufacturer#3 almond antique olive coral navajo 1337.29 7 1 1 1190.27 1337.29 6 7
+Manufacturer#3 almond antique forest lavender goldenrod 1190.27 8 1 1 1190.27 1190.27 7 8
+Manufacturer#4 almond antique gainsboro frosted violet NULL 1 1 1 NULL NULL 0 1
+Manufacturer#4 almond aquamarine floral ivory bisque NULL 2 1 1 NULL NULL 0 2
+Manufacturer#4 almond antique violet mint lemon 1375.42 3 1 1 NULL 1375.42 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#4 almond aquamarine floral ivory bisque 1206.26 5 1 1 NULL 1206.26 3 5
+Manufacturer#4 almond azure aquamarine papaya violet 1290.35 6 1 1 NULL 1290.35 4 6
+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 azure blanched chiffon midnight 1464.48 3 1 1 1611.66 1464.48 3 3
+Manufacturer#5 almond antique medium spring khaki 1611.66 4 1 1 1611.66 1611.66 4 4
+Manufacturer#5 almond antique sky peru orange 1788.73 5 1 1 1611.66 1788.73 5 5
+Manufacturer#5 almond antique blue firebrick mint 1789.69 6 1 1 1611.66 1789.69 6 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
@@ -813,12 +819,6 @@ Manufacturer#1 almond aquamarine burnished black steel 1414.42 9 1 1 1632.66 141
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,
@@ -2490,20 +2490,26 @@ Manufacturer#2 almond antique violet turquoise frosted 1800.7 12724.68 900.66 20
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#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 forest lavender goldenrod NULL 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 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#3 almond antique forest lavender goldenrod 590.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 forest lavender goldenrod 1190.27 6386.15 55.39 1922.98 912.3071428571428
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 floral ivory bisque NULL 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 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#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#5 almond antique medium spring khaki 1611.66 9284.320000000002 1018.1 1789.69 1547.386666666667
+Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 9284.320000000002 1018.1 1789.69 1547.386666666667
+Manufacturer#5 almond azure blanched chiffon midnight 1464.48 9284.320000000002 1018.1 1789.69 1547.386666666667
+Manufacturer#5 almond antique medium spring khaki 1611.66 9284.320000000002 1018.1 1789.69 1547.386666666667
+Manufacturer#5 almond antique sky peru orange 1788.73 9284.320000000002 1018.1 1789.69 1547.386666666667
+Manufacturer#5 almond antique blue firebrick mint 1789.69 9284.320000000002 1018.1 1789.69 1547.386666666667
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
@@ -2516,12 +2522,6 @@ Manufacturer#1 almond aquamarine burnished black steel 1414.42 17276.33 1173.15
Manufacturer#1 almond aquamarine pink moccasin thistle NULL 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#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,
@@ -2722,20 +2722,26 @@ Manufacturer#2 almond antique violet turquoise frosted 1800.7 12724.68 900.66 20
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#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 forest lavender goldenrod NULL 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 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#3 almond antique forest lavender goldenrod 590.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 forest lavender goldenrod 1190.27 6386.15 55.39 1922.98 912.3071428571428
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 floral ivory bisque NULL 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 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#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#5 almond antique medium spring khaki 1611.66 9284.320000000002 1018.1 1789.69 1547.386666666667
+Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 9284.320000000002 1018.1 1789.69 1547.386666666667
+Manufacturer#5 almond azure blanched chiffon midnight 1464.48 9284.320000000002 1018.1 1789.69 1547.386666666667
+Manufacturer#5 almond antique medium spring khaki 1611.66 9284.320000000002 1018.1 1789.69 1547.386666666667
+Manufacturer#5 almond antique sky peru orange 1788.73 9284.320000000002 1018.1 1789.69 1547.386666666667
+Manufacturer#5 almond antique blue firebrick mint 1789.69 9284.320000000002 1018.1 1789.69 1547.386666666667
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
@@ -2748,12 +2754,6 @@ Manufacturer#1 almond aquamarine burnished black steel 1414.42 17276.33 1173.15
Manufacturer#1 almond aquamarine pink moccasin thistle NULL 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#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,
@@ -2954,20 +2954,26 @@ Manufacturer#2 almond antique violet turquoise frosted 1800.7 7891.400000000001
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#3 almond antique chartreuse khaki white 99.68 1289.95 99.68 1190.27 644.975
+Manufacturer#3 almond antique forest lavender goldenrod NULL 1289.95 99.68 1190.27 644.975
+Manufacturer#3 almond antique metallic orange dim 55.39 1345.3400000000001 55.39 1190.27 448.4466666666667
+Manufacturer#3 almond antique misty red olive 1922.98 3268.32 55.39 1922.98 817.08
+Manufacturer#3 almond antique forest lavender goldenrod 590.27 3858.59 55.39 1922.98 771.7180000000001
+Manufacturer#3 almond antique olive coral navajo 1337.29 5195.88 55.39 1922.98 865.98
+Manufacturer#3 almond antique forest lavender goldenrod 1190.27 6386.15 55.39 1922.98 912.3071428571428
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#4 almond aquamarine floral ivory bisque NULL NULL NULL NULL NULL
+Manufacturer#4 almond antique violet mint lemon 1375.42 1375.42 1375.42 1375.42 1375.42
+Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 3220.34 1375.42 1844.92 1610.17
+Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 4426.6 1206.26 1844.92 1475.5333333333335
+Manufacturer#4 almond azure aquamarine papaya violet 1290.35 5716.950000000001 1206.26 1844.92 1429.2375000000002
+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 azure blanched chiffon midnight 1464.48 4094.2400000000002 1018.1 1611.66 1364.7466666666667
+Manufacturer#5 almond antique medium spring khaki 1611.66 5705.900000000001 1018.1 1611.66 1426.4750000000001
+Manufacturer#5 almond antique sky peru orange 1788.73 7494.630000000001 1018.1 1788.73 1498.9260000000002
+Manufacturer#5 almond antique blue firebrick mint 1789.69 9284.320000000002 1018.1 1789.69 1547.386666666667
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
@@ -2980,12 +2986,6 @@ Manufacturer#1 almond aquamarine burnished black steel 1414.42 14349.42 1173.15
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,
@@ -4635,20 +4635,26 @@ Manufacturer#2 almond antique violet turquoise frosted 1800.700000000000000000 1
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#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 forest lavender goldenrod NULL 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 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#3 almond antique forest lavender goldenrod 590.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 forest lavender goldenrod 1190.270000000000000000 6386.150000000000000000 55.390000000000000000 1922.980000000000000000 912.307142857142857143
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 floral ivory bisque NULL 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 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#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#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 azure blanched chiffon midnight 1464.480000000000000000 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#5 almond antique blue firebrick mint 1789.690000000000000000 9284.320000000000000000 1018.100000000000000000 1789.690000000000000000 1547.386666666666666667
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
@@ -4661,12 +4667,6 @@ Manufacturer#1 almond aquamarine burnished black steel 1414.420000000000000000 1
Manufacturer#1 almond aquamarine pink moccasin thistle NULL 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#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,
@@ -5121,20 +5121,26 @@ Manufacturer#2 almond antique violet turquoise frosted 180070 1272468 90066 2031
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#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 forest lavender goldenrod NULL 638615 5539 192298 91230.71428571429
+Manufacturer#3 almond antique metallic orange dim 5539 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#3 almond antique forest lavender goldenrod 59027 638615 5539 192298 91230.71428571429
+Manufacturer#3 almond antique olive coral navajo 133729 638615 5539 192298 91230.71428571429
+Manufacturer#3 almond antique forest lavender goldenrod 119027 638615 5539 192298 91230.71428571429
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 floral ivory bisque NULL 571695 120626 184492 142923.75
+Manufacturer#4 almond antique violet mint lemon 137542 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#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#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 azure blanched chiffon midnight 146448 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#5 almond antique blue firebrick mint 178969 928432 101810 178969 154738.66666666666
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
@@ -5147,12 +5153,6 @@ Manufacturer#1 almond aquamarine burnished black steel 141442 1727633 117315 175
Manufacturer#1 almond aquamarine pink moccasin thistle NULL 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#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,
@@ -5558,20 +5558,26 @@ Manufacturer#2 1800.7 1
Manufacturer#2 1800.7 1
Manufacturer#2 1000.6 1
Manufacturer#2 2031.98 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 NULL 1
+Manufacturer#3 55.39 1
Manufacturer#3 1922.98 1
+Manufacturer#3 590.27 1
+Manufacturer#3 1337.29 1
+Manufacturer#3 1190.27 1
Manufacturer#4 NULL 1
Manufacturer#4 NULL 1
-Manufacturer#4 1206.26 1
+Manufacturer#4 1375.42 1
Manufacturer#4 1844.92 1
+Manufacturer#4 1206.26 1
Manufacturer#4 1290.35 1
-Manufacturer#4 1375.42 1
+Manufacturer#5 1611.66 1
+Manufacturer#5 1018.1 1
+Manufacturer#5 1464.48 1
+Manufacturer#5 1611.66 1
+Manufacturer#5 1788.73 1
+Manufacturer#5 1789.69 1
Manufacturer#1 1632.66 1
Manufacturer#1 1753.76 1
Manufacturer#1 1632.66 1
@@ -5584,12 +5590,6 @@ Manufacturer#1 1414.42 1
Manufacturer#1 NULL 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
@@ -5959,11 +5959,23 @@ 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 antique chartreuse lavender yellow 1753.76 1
+Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 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 burnished rose metallic 1173.15 1
+Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1
+Manufacturer#1 almond antique burnished rose metallic 1173.15 1
+Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1
+Manufacturer#1 almond aquamarine burnished black steel 1414.42 1
+Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 1
+Manufacturer#1 almond aquamarine pink moccasin thistle NULL 1
+Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1
Manufacturer#5 almond antique blue firebrick mint 1789.69 1
-Manufacturer#5 almond azure blanched chiffon midnight 1464.48 1
Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 1
Manufacturer#5 almond antique medium spring khaki 1611.66 1
Manufacturer#5 almond antique sky peru orange 1788.73 1
+Manufacturer#5 almond azure blanched chiffon midnight 1464.48 1
Manufacturer#5 almond antique medium spring khaki 1611.66 1
Manufacturer#2 almond aquamarine rose maroon antique 900.66 1
Manufacturer#2 almond aquamarine rose maroon antique 1698.66 1
@@ -5973,32 +5985,20 @@ 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 azure aquamarine papaya violet 1290.35 1
-Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 1
-Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 1
-Manufacturer#4 almond antique gainsboro frosted violet NULL 1
-Manufacturer#4 almond antique violet mint lemon 1375.42 1
-Manufacturer#4 almond aquamarine floral ivory bisque NULL 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 chartreuse lavender yellow 1753.76 1
-Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 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 aquamarine burnished black steel 1414.42 1
-Manufacturer#1 almond aquamarine pink moccasin thistle NULL 1
-Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 1
-Manufacturer#1 almond antique burnished rose metallic 1173.15 1
-Manufacturer#3 almond antique olive coral navajo 1337.29 1
Manufacturer#3 almond antique forest lavender goldenrod 590.27 1
-Manufacturer#3 almond antique chartreuse khaki white 99.68 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 NULL 1
Manufacturer#3 almond antique misty red olive 1922.98 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 forest lavender goldenrod NULL 1
+Manufacturer#3 almond antique metallic orange dim 55.39 1
+Manufacturer#3 almond antique chartreuse khaki white 99.68 1
+Manufacturer#4 almond antique violet mint lemon 1375.42 1
+Manufacturer#4 almond aquamarine floral ivory bisque NULL 1
+Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 1
+Manufacturer#4 almond azure aquamarine papaya violet 1290.35 1
+Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 1
+Manufacturer#4 almond antique gainsboro frosted violet NULL 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
@@ -6238,20 +6238,26 @@ Manufacturer#2 almond antique violet turquoise frosted 1800.7 5 1 1 900.66 2031.
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#3 almond antique forest lavender goldenrod 1190.27 1 1 1 1190.27 1190.27 7 8
+Manufacturer#3 almond antique chartreuse khaki white 99.68 2 1 1 1190.27 1190.27 7 8
+Manufacturer#3 almond antique forest lavender goldenrod NULL 3 1 1 1190.27 1190.27 7 8
+Manufacturer#3 almond antique metallic orange dim 55.39 4 1 1 1190.27 1190.27 7 8
+Manufacturer#3 almond antique misty red olive 1922.98 5 1 1 1190.27 1190.27 7 8
+Manufacturer#3 almond antique forest lavender goldenrod 590.27 6 1 1 1190.27 1190.27 7 8
+Manufacturer#3 almond antique olive coral navajo 1337.29 7 1 1 1190.27 1190.27 7 8
+Manufacturer#3 almond antique forest lavender goldenrod 1190.27 8 1 1 1190.27 1190.27 7 8
+Manufacturer#4 almond antique gainsboro frosted violet NULL 1 1 1 NULL 1290.35 4 6
+Manufacturer#4 almond aquamarine floral ivory bisque NULL 2 1 1 NULL 1290.35 4 6
+Manufacturer#4 almond antique violet mint lemon 1375.42 3 1 1 NULL 1290.35 4 6
+Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 4 1 1 NULL 1290.35 4 6
+Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 5 1 1 NULL 1290.35 4 6
+Manufacturer#4 almond azure aquamarine papaya violet 1290.35 6 1 1 NULL 1290.35 4 6
+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 azure blanched chiffon midnight 1464.48 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 antique sky peru orange 1788.73 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
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
@@ -6264,12 +6270,6 @@ Manufacturer#1 almond aquamarine burnished black steel 1414.42 9 1 1 1632.66 117
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,
@@ -6506,20 +6506,26 @@ Manufacturer#2 1800.7 1
Manufacturer#2 1800.7 1
Manufacturer#2 1000.6 1
Manufacturer#2 2031.98 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 NULL 1
+Manufacturer#3 55.39 1
Manufacturer#3 1922.98 1
+Manufacturer#3 590.27 1
+Manufacturer#3 1337.29 1
+Manufacturer#3 1190.27 1
Manufacturer#4 NULL 1
Manufacturer#4 NULL 1
-Manufacturer#4 1206.26 1
+Manufacturer#4 1375.42 1
Manufacturer#4 1844.92 1
+Manufacturer#4 1206.26 1
Manufacturer#4 1290.35 1
-Manufacturer#4 1375.42 1
+Manufacturer#5 1611.66 1
+Manufacturer#5 1018.1 1
+Manufacturer#5 1464.48 1
+Manufacturer#5 1611.66 1
+Manufacturer#5 1788.73 1
+Manufacturer#5 1789.69 1
Manufacturer#1 1632.66 1
Manufacturer#1 1753.76 1
Manufacturer#1 1632.66 1
@@ -6532,12 +6538,6 @@ Manufacturer#1 1414.42 1
Manufacturer#1 NULL 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
@@ -7113,11 +7113,23 @@ 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 antique chartreuse lavender yellow 1753.76 1
+Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 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 burnished rose metallic 1173.15 1
+Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1
+Manufacturer#1 almond antique burnished rose metallic 1173.15 1
+Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1
+Manufacturer#1 almond aquamarine burnished black steel 1414.42 1
+Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 1
+Manufacturer#1 almond aquamarine pink moccasin thistle NULL 1
+Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1
Manufacturer#5 almond antique blue firebrick mint 1789.69 1
-Manufacturer#5 almond azure blanched chiffon midnight 1464.48 1
Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 1
Manufacturer#5 almond antique medium spring khaki 1611.66 1
Manufacturer#5 almond antique sky peru orange 1788.73 1
+Manufacturer#5 almond azure blanched chiffon midnight 1464.48 1
Manufacturer#5 almond antique medium spring khaki 1611.66 1
Manufacturer#2 almond aquamarine rose maroon antique 900.66 1
Manufacturer#2 almond aquamarine rose maroon antique 1698.66 1
@@ -7127,29 +7139,17 @@ 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 azure aquamarine papaya violet 1290.35 1
-Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 1
-Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 1
-Manufacturer#4 almond antique gainsboro frosted violet NULL 1
-Manufacturer#4 almond antique violet mint lemon 1375.42 1
-Manufacturer#4 almond aquamarine floral ivory bisque NULL 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 chartreuse lavender yellow 1753.76 1
-Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 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 aquamarine burnished black steel 1414.42 1
-Manufacturer#1 almond aquamarine pink moccasin thistle NULL 1
-Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 1
-Manufacturer#1 almond antique burnished rose metallic 1173.15 1
-Manufacturer#3 almond antique olive coral navajo 1337.29 1
Manufacturer#3 almond antique forest lavender goldenrod 590.27 1
-Manufacturer#3 almond antique chartreuse khaki white 99.68 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 NULL 1
Manufacturer#3 almond antique misty red olive 1922.98 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 forest lavender goldenrod NULL 1
+Manufacturer#3 almond antique metallic orange dim 55.39 1
+Manufacturer#3 almond antique chartreuse khaki white 99.68 1
+Manufacturer#4 almond antique violet mint lemon 1375.42 1
+Manufacturer#4 almond aquamarine floral ivory bisque NULL 1
+Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 1
+Manufacturer#4 almond azure aquamarine papaya violet 1290.35 1
+Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 1
+Manufacturer#4 almond antique gainsboro frosted violet NULL 1
http://git-wip-us.apache.org/repos/asf/hive/blob/f89274ab/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 49daa40..fa63dc4 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
@@ -1508,31 +1508,31 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
p_mfgr avg_window_0
+Manufacturer#1 1753.76
Manufacturer#1 1632.66
+Manufacturer#1 1602.59
Manufacturer#1 1414.42
Manufacturer#2 1800.7
-Manufacturer#2 1701.6
-Manufacturer#3 1190.27
-Manufacturer#3 1337.29
-Manufacturer#1 1173.15
-Manufacturer#1 1173.15
-Manufacturer#4 1290.35
-Manufacturer#5 1464.48
-Manufacturer#5 1789.69
-Manufacturer#1 1753.76
-Manufacturer#1 1602.59
Manufacturer#2 1690.68
Manufacturer#2 2031.98
+Manufacturer#2 1701.6
Manufacturer#3 1410.39
Manufacturer#3 1671.68
+Manufacturer#3 1190.27
+Manufacturer#3 1337.29
Manufacturer#4 1375.42
Manufacturer#5 1788.73
+Manufacturer#1 1173.15
+Manufacturer#1 1173.15
Manufacturer#2 1698.66
Manufacturer#3 1922.98
Manufacturer#4 1844.92
Manufacturer#4 1620.67
Manufacturer#4 1206.26
+Manufacturer#4 1290.35
Manufacturer#5 1018.1
+Manufacturer#5 1464.48
+Manufacturer#5 1789.69
Manufacturer#5 1611.66
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
@@ -2239,31 +2239,31 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
p_mfgr avg_window_0
+Manufacturer#1 1753.76
Manufacturer#1 1632.66
+Manufacturer#1 1602.59
Manufacturer#1 1414.42
Manufacturer#2 1800.7
-Manufacturer#2 1701.6
-Manufacturer#3 1190.27
-Manufacturer#3 1337.29
-Manufacturer#1 1173.15
-Manufacturer#1 1173.15
-Manufacturer#4 1290.35
-Manufacturer#5 1464.48
-Manufacturer#5 1789.69
-Manufacturer#1 1753.76
-Manufacturer#1 1602.59
Manufacturer#2 1690.68
Manufacturer#2 2031.98
+Manufacturer#2 1701.6
Manufacturer#3 1410.39
Manufacturer#3 1671.68
+Manufacturer#3 1190.27
+Manufacturer#3 1337.29
Manufacturer#4 1375.42
Manufacturer#5 1788.73
+Manufacturer#1 1173.15
+Manufacturer#1 1173.15
Manufacturer#2 1698.66
Manufacturer#3 1922.98
Manufacturer#4 1844.92
Manufacturer#4 1620.67
Manufacturer#4 1206.26
+Manufacturer#4 1290.35
Manufacturer#5 1018.1
+Manufacturer#5 1464.48
+Manufacturer#5 1789.69
Manufacturer#5 1611.66
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
http://git-wip-us.apache.org/repos/asf/hive/blob/f89274ab/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 7596c9a..adca292 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
@@ -10737,34 +10737,34 @@ POSTHOOK: Input: default@over10k_n6
s _c1 sum_window_1
tom allen 1248023 47.16999816894531
tom allen 1248023 77.77999877929688
+tom allen 1248023 11.069999694824219
bob steinbeck 722083 83.52999877929688
+bob steinbeck 722083 38.33000183105469
+tom allen 1248023 26.239999771118164
tom allen 1248023 83.47000122070312
+bob steinbeck 722083 47.810001373291016
tom allen 1248023 15.84000015258789
tom allen 1248023 39.4900016784668
bob steinbeck 722083 80.7300033569336
tom allen 1248023 11.300000190734863
+tom allen 1248023 68.46999740600586
+bob steinbeck 722083 68.46999740600586
+bob steinbeck 722083 28.479999542236328
tom allen 1248023 2.8499999046325684
tom allen 1248023 19.459999084472656
bob steinbeck 722083 26.290000915527344
+bob steinbeck 722083 36.209999084472656
+tom allen 1248023 95.41000366210938
+tom allen 1248023 89.88999938964844
tom allen 1248023 14.510000228881836
bob steinbeck 722083 83.52999877929688
+tom allen 1248023 38.93000030517578
+tom allen 1248023 81.8499984741211
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 11.069999694824219
-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 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_n6
where s = 'tom allen' or s = 'bob steinbeck'