hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From aihu...@apache.org
Subject [05/13] hive git commit: HIVE-15520: Improve the sum performance for Range based window (Aihua Xu, reviewed by Yongzhi Chen)
Date Thu, 12 Jan 2017 14:25:49 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/a28b28f3/ql/src/test/results/clientpositive/spark/ptf.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/ptf.q.out b/ql/src/test/results/clientpositive/spark/ptf.q.out
index 2903003..eafe457 100644
--- a/ql/src/test/results/clientpositive/spark/ptf.q.out
+++ b/ql/src/test/results/clientpositive/spark/ptf.q.out
@@ -5,7 +5,7 @@ explain
 select p_mfgr, p_name, p_size,
 rank() over (partition by p_mfgr order by p_name) as r,
 dense_rank() over (partition by p_mfgr order by p_name) as dr,
-sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded preceding
and current row) as s1
+round(sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded
preceding and current row),2) as s1
 from noop(on part 
   partition by p_mfgr
   order by p_name
@@ -18,7 +18,7 @@ explain
 select p_mfgr, p_name, p_size,
 rank() over (partition by p_mfgr order by p_name) as r,
 dense_rank() over (partition by p_mfgr order by p_name) as dr,
-sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded preceding
and current row) as s1
+round(sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded
preceding and current row),2) as s1
 from noop(on part 
   partition by p_mfgr
   order by p_name
@@ -114,7 +114,7 @@ STAGE PLANS:
                               window frame: PRECEDING(MAX)~CURRENT
                   Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
-                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type:
int), rank_window_0 (type: int), dense_rank_window_1 (type: int), sum_window_2 (type: double)
+                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type:
int), rank_window_0 (type: int), dense_rank_window_1 (type: int), round(sum_window_2, 2) (type:
double)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
                     Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column
stats: NONE
                     File Output Operator
@@ -134,7 +134,7 @@ STAGE PLANS:
 PREHOOK: query: select p_mfgr, p_name, p_size,
 rank() over (partition by p_mfgr order by p_name) as r,
 dense_rank() over (partition by p_mfgr order by p_name) as dr,
-sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded preceding
and current row) as s1
+round(sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded
preceding and current row),2) as s1
 from noop(on part 
   partition by p_mfgr
   order by p_name
@@ -145,7 +145,7 @@ PREHOOK: Input: default@part
 POSTHOOK: query: select p_mfgr, p_name, p_size,
 rank() over (partition by p_mfgr order by p_name) as r,
 dense_rank() over (partition by p_mfgr order by p_name) as dr,
-sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded preceding
and current row) as s1
+round(sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded
preceding and current row),2) as s1
 from noop(on part 
   partition by p_mfgr
   order by p_name
@@ -156,12 +156,12 @@ POSTHOOK: Input: default@part
 Manufacturer#1	almond antique burnished rose metallic	2	1	1	1173.15
 Manufacturer#1	almond antique burnished rose metallic	2	1	1	2346.3
 Manufacturer#1	almond antique chartreuse lavender yellow	34	3	2	4100.06
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	3	5702.650000000001
-Manufacturer#1	almond aquamarine burnished black steel	28	5	4	7117.070000000001
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	5	8749.730000000001
+Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	3	5702.65
+Manufacturer#1	almond aquamarine burnished black steel	28	5	4	7117.07
+Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	5	8749.73
 Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	1690.68
 Manufacturer#2	almond antique violet turquoise frosted	40	2	2	3491.38
-Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	5523.360000000001
+Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	5523.36
 Manufacturer#2	almond aquamarine rose maroon antique	25	4	4	7222.02
 Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	5	5	8923.62
 Manufacturer#3	almond antique chartreuse khaki white	17	1	1	1671.68
@@ -173,9 +173,9 @@ Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	1620.67
 Manufacturer#4	almond antique violet mint lemon	39	2	2	2996.09
 Manufacturer#4	almond aquamarine floral ivory bisque	27	3	3	4202.35
 Manufacturer#4	almond aquamarine yellow dodger mint	7	4	4	6047.27
-Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	7337.620000000001
+Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	7337.62
 Manufacturer#5	almond antique blue firebrick mint	31	1	1	1789.69
-Manufacturer#5	almond antique medium spring khaki	6	2	2	3401.3500000000004
+Manufacturer#5	almond antique medium spring khaki	6	2	2	3401.35
 Manufacturer#5	almond antique sky peru orange	2	3	3	5190.08
 Manufacturer#5	almond aquamarine dodger light gainsboro	46	4	4	6208.18
 Manufacturer#5	almond azure blanched chiffon midnight	23	5	5	7672.66
@@ -485,7 +485,7 @@ explain
 select p_mfgr, p_name, p_size,
 rank() over (partition by p_mfgr order by p_name) as r,
 dense_rank() over (partition by p_mfgr order by p_name) as dr,
-sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded preceding
and current row) as s1
+round(sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded
preceding and current row),2) as s1
 from noop(on part 
   partition by p_mfgr
   order by p_name
@@ -496,7 +496,7 @@ explain
 select p_mfgr, p_name, p_size,
 rank() over (partition by p_mfgr order by p_name) as r,
 dense_rank() over (partition by p_mfgr order by p_name) as dr,
-sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded preceding
and current row) as s1
+round(sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded
preceding and current row),2) as s1
 from noop(on part 
   partition by p_mfgr
   order by p_name
@@ -592,7 +592,7 @@ STAGE PLANS:
                               window frame: PRECEDING(MAX)~CURRENT
                   Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
-                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type:
int), rank_window_0 (type: int), dense_rank_window_1 (type: int), sum_window_2 (type: double)
+                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type:
int), rank_window_0 (type: int), dense_rank_window_1 (type: int), round(sum_window_2, 2) (type:
double)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
                     Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column
stats: NONE
                     File Output Operator
@@ -612,7 +612,7 @@ STAGE PLANS:
 PREHOOK: query: select p_mfgr, p_name, p_size,
 rank() over (partition by p_mfgr order by p_name) as r,
 dense_rank() over (partition by p_mfgr order by p_name) as dr,
-sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded preceding
and current row) as s1
+round(sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded
preceding and current row),2) as s1
 from noop(on part 
   partition by p_mfgr
   order by p_name
@@ -623,7 +623,7 @@ PREHOOK: Input: default@part
 POSTHOOK: query: select p_mfgr, p_name, p_size,
 rank() over (partition by p_mfgr order by p_name) as r,
 dense_rank() over (partition by p_mfgr order by p_name) as dr,
-sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded preceding
and current row) as s1
+round(sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded
preceding and current row),2) as s1
 from noop(on part 
   partition by p_mfgr
   order by p_name
@@ -634,12 +634,12 @@ POSTHOOK: Input: default@part
 Manufacturer#1	almond antique burnished rose metallic	2	1	1	1173.15
 Manufacturer#1	almond antique burnished rose metallic	2	1	1	2346.3
 Manufacturer#1	almond antique chartreuse lavender yellow	34	3	2	4100.06
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	3	5702.650000000001
-Manufacturer#1	almond aquamarine burnished black steel	28	5	4	7117.070000000001
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	5	8749.730000000001
+Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	3	5702.65
+Manufacturer#1	almond aquamarine burnished black steel	28	5	4	7117.07
+Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	5	8749.73
 Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	1690.68
 Manufacturer#2	almond antique violet turquoise frosted	40	2	2	3491.38
-Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	5523.360000000001
+Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	5523.36
 Manufacturer#2	almond aquamarine rose maroon antique	25	4	4	7222.02
 Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	5	5	8923.62
 Manufacturer#3	almond antique chartreuse khaki white	17	1	1	1671.68
@@ -651,9 +651,9 @@ Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	1620.67
 Manufacturer#4	almond antique violet mint lemon	39	2	2	2996.09
 Manufacturer#4	almond aquamarine floral ivory bisque	27	3	3	4202.35
 Manufacturer#4	almond aquamarine yellow dodger mint	7	4	4	6047.27
-Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	7337.620000000001
+Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	7337.62
 Manufacturer#5	almond antique blue firebrick mint	31	1	1	1789.69
-Manufacturer#5	almond antique medium spring khaki	6	2	2	3401.3500000000004
+Manufacturer#5	almond antique medium spring khaki	6	2	2	3401.35
 Manufacturer#5	almond antique sky peru orange	2	3	3	5190.08
 Manufacturer#5	almond aquamarine dodger light gainsboro	46	4	4	6208.18
 Manufacturer#5	almond azure blanched chiffon midnight	23	5	5	7672.66
@@ -1499,7 +1499,7 @@ explain
 select p_mfgr, p_name, p_size,
 rank() over (partition by p_mfgr order by p_name) as r,
 dense_rank() over (partition by p_mfgr order by p_name) as dr,
-sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded preceding
and current row) as s1
+round(sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded
preceding and current row),2) as s1
 from noopwithmap(on part 
   partition by p_mfgr
   order by p_name)
@@ -1509,7 +1509,7 @@ explain
 select p_mfgr, p_name, p_size,
 rank() over (partition by p_mfgr order by p_name) as r,
 dense_rank() over (partition by p_mfgr order by p_name) as dr,
-sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded preceding
and current row) as s1
+round(sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded
preceding and current row),2) as s1
 from noopwithmap(on part 
   partition by p_mfgr
   order by p_name)
@@ -1621,7 +1621,7 @@ STAGE PLANS:
                               window frame: PRECEDING(MAX)~CURRENT
                   Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
-                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type:
int), rank_window_0 (type: int), dense_rank_window_1 (type: int), sum_window_2 (type: double)
+                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type:
int), rank_window_0 (type: int), dense_rank_window_1 (type: int), round(sum_window_2, 2) (type:
double)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
                     Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column
stats: NONE
                     File Output Operator
@@ -1641,7 +1641,7 @@ STAGE PLANS:
 PREHOOK: query: select p_mfgr, p_name, p_size,
 rank() over (partition by p_mfgr order by p_name) as r,
 dense_rank() over (partition by p_mfgr order by p_name) as dr,
-sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded preceding
and current row) as s1
+round(sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded
preceding and current row),2) as s1
 from noopwithmap(on part 
   partition by p_mfgr
   order by p_name)
@@ -1651,7 +1651,7 @@ PREHOOK: Input: default@part
 POSTHOOK: query: select p_mfgr, p_name, p_size,
 rank() over (partition by p_mfgr order by p_name) as r,
 dense_rank() over (partition by p_mfgr order by p_name) as dr,
-sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded preceding
and current row) as s1
+round(sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded
preceding and current row),2) as s1
 from noopwithmap(on part 
   partition by p_mfgr
   order by p_name)
@@ -1661,12 +1661,12 @@ POSTHOOK: Input: default@part
 Manufacturer#1	almond antique burnished rose metallic	2	1	1	1173.15
 Manufacturer#1	almond antique burnished rose metallic	2	1	1	2346.3
 Manufacturer#1	almond antique chartreuse lavender yellow	34	3	2	4100.06
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	3	5702.650000000001
-Manufacturer#1	almond aquamarine burnished black steel	28	5	4	7117.070000000001
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	5	8749.730000000001
+Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	3	5702.65
+Manufacturer#1	almond aquamarine burnished black steel	28	5	4	7117.07
+Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	5	8749.73
 Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	1690.68
 Manufacturer#2	almond antique violet turquoise frosted	40	2	2	3491.38
-Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	5523.360000000001
+Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	5523.36
 Manufacturer#2	almond aquamarine rose maroon antique	25	4	4	7222.02
 Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	5	5	8923.62
 Manufacturer#3	almond antique chartreuse khaki white	17	1	1	1671.68
@@ -1678,9 +1678,9 @@ Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	1620.67
 Manufacturer#4	almond antique violet mint lemon	39	2	2	2996.09
 Manufacturer#4	almond aquamarine floral ivory bisque	27	3	3	4202.35
 Manufacturer#4	almond aquamarine yellow dodger mint	7	4	4	6047.27
-Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	7337.620000000001
+Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	7337.62
 Manufacturer#5	almond antique blue firebrick mint	31	1	1	1789.69
-Manufacturer#5	almond antique medium spring khaki	6	2	2	3401.3500000000004
+Manufacturer#5	almond antique medium spring khaki	6	2	2	3401.35
 Manufacturer#5	almond antique sky peru orange	2	3	3	5190.08
 Manufacturer#5	almond aquamarine dodger light gainsboro	46	4	4	6208.18
 Manufacturer#5	almond azure blanched chiffon midnight	23	5	5	7672.66
@@ -1689,7 +1689,7 @@ explain
 select p_mfgr, p_name, p_size,
 rank() over (partition by p_mfgr order by p_name) as r,
 dense_rank() over (partition by p_mfgr order by p_name) as dr,
-sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded preceding
and current row) as s1
+round(sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded
preceding and current row),2) as s1
 from noop(on part
 partition by p_mfgr
 order by p_name)
@@ -1699,7 +1699,7 @@ explain
 select p_mfgr, p_name, p_size,
 rank() over (partition by p_mfgr order by p_name) as r,
 dense_rank() over (partition by p_mfgr order by p_name) as dr,
-sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded preceding
and current row) as s1
+round(sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded
preceding and current row),2) as s1
 from noop(on part
 partition by p_mfgr
 order by p_name)
@@ -1794,7 +1794,7 @@ STAGE PLANS:
                               window frame: PRECEDING(MAX)~CURRENT
                   Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
-                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type:
int), rank_window_0 (type: int), dense_rank_window_1 (type: int), sum_window_2 (type: double)
+                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type:
int), rank_window_0 (type: int), dense_rank_window_1 (type: int), round(sum_window_2, 2) (type:
double)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
                     Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column
stats: NONE
                     File Output Operator
@@ -1814,7 +1814,7 @@ STAGE PLANS:
 PREHOOK: query: select p_mfgr, p_name, p_size,
 rank() over (partition by p_mfgr order by p_name) as r,
 dense_rank() over (partition by p_mfgr order by p_name) as dr,
-sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded preceding
and current row) as s1
+round(sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded
preceding and current row),2) as s1
 from noop(on part
 partition by p_mfgr
 order by p_name)
@@ -1824,7 +1824,7 @@ PREHOOK: Input: default@part
 POSTHOOK: query: select p_mfgr, p_name, p_size,
 rank() over (partition by p_mfgr order by p_name) as r,
 dense_rank() over (partition by p_mfgr order by p_name) as dr,
-sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded preceding
and current row) as s1
+round(sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded
preceding and current row),2) as s1
 from noop(on part
 partition by p_mfgr
 order by p_name)
@@ -1834,12 +1834,12 @@ POSTHOOK: Input: default@part
 Manufacturer#1	almond antique burnished rose metallic	2	1	1	1173.15
 Manufacturer#1	almond antique burnished rose metallic	2	1	1	2346.3
 Manufacturer#1	almond antique chartreuse lavender yellow	34	3	2	4100.06
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	3	5702.650000000001
-Manufacturer#1	almond aquamarine burnished black steel	28	5	4	7117.070000000001
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	5	8749.730000000001
+Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	3	5702.65
+Manufacturer#1	almond aquamarine burnished black steel	28	5	4	7117.07
+Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	5	8749.73
 Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	1690.68
 Manufacturer#2	almond antique violet turquoise frosted	40	2	2	3491.38
-Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	5523.360000000001
+Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	5523.36
 Manufacturer#2	almond aquamarine rose maroon antique	25	4	4	7222.02
 Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	5	5	8923.62
 Manufacturer#3	almond antique chartreuse khaki white	17	1	1	1671.68
@@ -1851,9 +1851,9 @@ Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	1620.67
 Manufacturer#4	almond antique violet mint lemon	39	2	2	2996.09
 Manufacturer#4	almond aquamarine floral ivory bisque	27	3	3	4202.35
 Manufacturer#4	almond aquamarine yellow dodger mint	7	4	4	6047.27
-Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	7337.620000000001
+Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	7337.62
 Manufacturer#5	almond antique blue firebrick mint	31	1	1	1789.69
-Manufacturer#5	almond antique medium spring khaki	6	2	2	3401.3500000000004
+Manufacturer#5	almond antique medium spring khaki	6	2	2	3401.35
 Manufacturer#5	almond antique sky peru orange	2	3	3	5190.08
 Manufacturer#5	almond aquamarine dodger light gainsboro	46	4	4	6208.18
 Manufacturer#5	almond azure blanched chiffon midnight	23	5	5	7672.66
@@ -1862,7 +1862,7 @@ explain
 select p_mfgr, p_name, p_size, 
 rank() over (partition by p_mfgr order by p_name) as r, 
 dense_rank() over (partition by p_mfgr order by p_name) as dr, 
-sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded preceding
and current row)  as s1
+round(sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded
preceding and current row),2) as s1
 from noop(on noopwithmap(on noop(on part 
 partition by p_mfgr 
 order by p_mfgr DESC, p_name
@@ -1873,7 +1873,7 @@ explain
 select p_mfgr, p_name, p_size, 
 rank() over (partition by p_mfgr order by p_name) as r, 
 dense_rank() over (partition by p_mfgr order by p_name) as dr, 
-sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded preceding
and current row)  as s1
+round(sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded
preceding and current row),2) as s1
 from noop(on noopwithmap(on noop(on part 
 partition by p_mfgr 
 order by p_mfgr DESC, p_name
@@ -2027,7 +2027,7 @@ STAGE PLANS:
                               window frame: PRECEDING(MAX)~CURRENT
                   Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
-                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type:
int), rank_window_0 (type: int), dense_rank_window_1 (type: int), sum_window_2 (type: double)
+                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type:
int), rank_window_0 (type: int), dense_rank_window_1 (type: int), round(sum_window_2, 2) (type:
double)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
                     Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column
stats: NONE
                     File Output Operator
@@ -2047,7 +2047,7 @@ STAGE PLANS:
 PREHOOK: query: select p_mfgr, p_name, p_size, 
 rank() over (partition by p_mfgr order by p_name) as r, 
 dense_rank() over (partition by p_mfgr order by p_name) as dr, 
-sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded preceding
and current row)  as s1
+round(sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded
preceding and current row),2) as s1
 from noop(on noopwithmap(on noop(on part 
 partition by p_mfgr 
 order by p_mfgr DESC, p_name
@@ -2058,7 +2058,7 @@ PREHOOK: Input: default@part
 POSTHOOK: query: select p_mfgr, p_name, p_size, 
 rank() over (partition by p_mfgr order by p_name) as r, 
 dense_rank() over (partition by p_mfgr order by p_name) as dr, 
-sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded preceding
and current row)  as s1
+round(sum(p_retailprice) over (partition by p_mfgr order by p_name rows between unbounded
preceding and current row),2) as s1
 from noop(on noopwithmap(on noop(on part 
 partition by p_mfgr 
 order by p_mfgr DESC, p_name
@@ -2069,12 +2069,12 @@ POSTHOOK: Input: default@part
 Manufacturer#1	almond antique burnished rose metallic	2	1	1	1173.15
 Manufacturer#1	almond antique burnished rose metallic	2	1	1	2346.3
 Manufacturer#1	almond antique chartreuse lavender yellow	34	3	2	4100.06
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	3	5702.650000000001
-Manufacturer#1	almond aquamarine burnished black steel	28	5	4	7117.070000000001
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	5	8749.730000000001
+Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	3	5702.65
+Manufacturer#1	almond aquamarine burnished black steel	28	5	4	7117.07
+Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	5	8749.73
 Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	1690.68
 Manufacturer#2	almond antique violet turquoise frosted	40	2	2	3491.38
-Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	5523.360000000001
+Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	5523.36
 Manufacturer#2	almond aquamarine rose maroon antique	25	4	4	7222.02
 Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	5	5	8923.62
 Manufacturer#3	almond antique chartreuse khaki white	17	1	1	1671.68
@@ -2086,9 +2086,9 @@ Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	1620.67
 Manufacturer#4	almond antique violet mint lemon	39	2	2	2996.09
 Manufacturer#4	almond aquamarine floral ivory bisque	27	3	3	4202.35
 Manufacturer#4	almond aquamarine yellow dodger mint	7	4	4	6047.27
-Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	7337.620000000001
+Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	7337.62
 Manufacturer#5	almond antique blue firebrick mint	31	1	1	1789.69
-Manufacturer#5	almond antique medium spring khaki	6	2	2	3401.3500000000004
+Manufacturer#5	almond antique medium spring khaki	6	2	2	3401.35
 Manufacturer#5	almond antique sky peru orange	2	3	3	5190.08
 Manufacturer#5	almond aquamarine dodger light gainsboro	46	4	4	6208.18
 Manufacturer#5	almond azure blanched chiffon midnight	23	5	5	7672.66
@@ -2099,7 +2099,7 @@ sub1.cd, sub1.s1
 from (select p_mfgr, p_name, 
 count(p_size) over (partition by p_mfgr order by p_name) as cd, 
 p_retailprice, 
-sum(p_retailprice) over w1  as s1
+round(sum(p_retailprice) over w1,2) as s1
 from noop(on part 
 partition by p_mfgr 
 order by p_name) 
@@ -2113,7 +2113,7 @@ sub1.cd, sub1.s1
 from (select p_mfgr, p_name, 
 count(p_size) over (partition by p_mfgr order by p_name) as cd, 
 p_retailprice, 
-sum(p_retailprice) over w1  as s1
+round(sum(p_retailprice) over w1,2) as s1
 from noop(on part 
 partition by p_mfgr 
 order by p_name) 
@@ -2202,7 +2202,7 @@ STAGE PLANS:
                               window frame: PRECEDING(2)~FOLLOWING(2)
                   Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
-                    expressions: _col2 (type: string), _col1 (type: string), count_window_0
(type: bigint), sum_window_1 (type: double)
+                    expressions: _col2 (type: string), _col1 (type: string), count_window_0
(type: bigint), round(sum_window_1, 2) (type: double)
                     outputColumnNames: _col0, _col1, _col2, _col3
                     Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column
stats: NONE
                     File Output Operator
@@ -2224,7 +2224,7 @@ sub1.cd, sub1.s1
 from (select p_mfgr, p_name, 
 count(p_size) over (partition by p_mfgr order by p_name) as cd, 
 p_retailprice, 
-sum(p_retailprice) over w1  as s1
+round(sum(p_retailprice) over w1,2)  as s1
 from noop(on part 
 partition by p_mfgr 
 order by p_name) 
@@ -2238,7 +2238,7 @@ sub1.cd, sub1.s1
 from (select p_mfgr, p_name, 
 count(p_size) over (partition by p_mfgr order by p_name) as cd, 
 p_retailprice, 
-sum(p_retailprice) over w1  as s1
+round(sum(p_retailprice) over w1,2)  as s1
 from noop(on part 
 partition by p_mfgr 
 order by p_name) 
@@ -2248,38 +2248,38 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
 Manufacturer#1	almond antique burnished rose metallic	2	4100.06
-Manufacturer#1	almond antique burnished rose metallic	2	5702.650000000001
-Manufacturer#1	almond antique chartreuse lavender yellow	3	7117.070000000001
+Manufacturer#1	almond antique burnished rose metallic	2	5702.65
+Manufacturer#1	almond antique chartreuse lavender yellow	3	7117.07
 Manufacturer#1	almond antique salmon chartreuse burlywood	4	7576.58
 Manufacturer#1	almond aquamarine burnished black steel	5	6403.43
 Manufacturer#1	almond aquamarine pink moccasin thistle	6	4649.67
-Manufacturer#2	almond antique violet chocolate turquoise	1	5523.360000000001
+Manufacturer#2	almond antique violet chocolate turquoise	1	5523.36
 Manufacturer#2	almond antique violet turquoise frosted	2	7222.02
 Manufacturer#2	almond aquamarine midnight light salmon	3	8923.62
-Manufacturer#2	almond aquamarine rose maroon antique	4	7232.9400000000005
+Manufacturer#2	almond aquamarine rose maroon antique	4	7232.94
 Manufacturer#2	almond aquamarine sandy cyan gainsboro	5	5432.24
 Manufacturer#3	almond antique chartreuse khaki white	1	4272.34
 Manufacturer#3	almond antique forest lavender goldenrod	2	6195.32
 Manufacturer#3	almond antique metallic orange dim	3	7532.61
-Manufacturer#3	almond antique misty red olive	4	5860.929999999999
+Manufacturer#3	almond antique misty red olive	4	5860.93
 Manufacturer#3	almond antique olive coral navajo	5	4670.66
 Manufacturer#4	almond antique gainsboro frosted violet	1	4202.35
 Manufacturer#4	almond antique violet mint lemon	2	6047.27
-Manufacturer#4	almond aquamarine floral ivory bisque	3	7337.620000000001
-Manufacturer#4	almond aquamarine yellow dodger mint	4	5716.950000000001
-Manufacturer#4	almond azure aquamarine papaya violet	5	4341.530000000001
+Manufacturer#4	almond aquamarine floral ivory bisque	3	7337.62
+Manufacturer#4	almond aquamarine yellow dodger mint	4	5716.95
+Manufacturer#4	almond azure aquamarine papaya violet	5	4341.53
 Manufacturer#5	almond antique blue firebrick mint	1	5190.08
 Manufacturer#5	almond antique medium spring khaki	2	6208.18
 Manufacturer#5	almond antique sky peru orange	3	7672.66
-Manufacturer#5	almond aquamarine dodger light gainsboro	4	5882.970000000001
-Manufacturer#5	almond azure blanched chiffon midnight	5	4271.3099999999995
+Manufacturer#5	almond aquamarine dodger light gainsboro	4	5882.97
+Manufacturer#5	almond azure blanched chiffon midnight	5	4271.31
 PREHOOK: query: -- 14. testPTFJoinWithWindowingWithCount
 explain
 select abc.p_mfgr, abc.p_name, 
 rank() over (distribute by abc.p_mfgr sort by abc.p_name) as r, 
 dense_rank() over (distribute by abc.p_mfgr sort by abc.p_name) as dr, 
 count(abc.p_name) over (distribute by abc.p_mfgr sort by abc.p_name) as cd, 
-abc.p_retailprice, sum(abc.p_retailprice) over (distribute by abc.p_mfgr sort by abc.p_name
rows between unbounded preceding and current row) as s1, 
+abc.p_retailprice, round(sum(abc.p_retailprice) over (distribute by abc.p_mfgr sort by abc.p_name
rows between unbounded preceding and current row),2) as s1,
 abc.p_size, abc.p_size - lag(abc.p_size,1,abc.p_size) over (distribute by abc.p_mfgr sort
by abc.p_name) as deltaSz 
 from noop(on part 
 partition by p_mfgr 
@@ -2292,7 +2292,7 @@ select abc.p_mfgr, abc.p_name,
 rank() over (distribute by abc.p_mfgr sort by abc.p_name) as r, 
 dense_rank() over (distribute by abc.p_mfgr sort by abc.p_name) as dr, 
 count(abc.p_name) over (distribute by abc.p_mfgr sort by abc.p_name) as cd, 
-abc.p_retailprice, sum(abc.p_retailprice) over (distribute by abc.p_mfgr sort by abc.p_name
rows between unbounded preceding and current row) as s1, 
+abc.p_retailprice, round(sum(abc.p_retailprice) over (distribute by abc.p_mfgr sort by abc.p_name
rows between unbounded preceding and current row),2) as s1,
 abc.p_size, abc.p_size - lag(abc.p_size,1,abc.p_size) over (distribute by abc.p_mfgr sort
by abc.p_name) as deltaSz 
 from noop(on part 
 partition by p_mfgr 
@@ -2435,7 +2435,7 @@ STAGE PLANS:
                               isPivotResult: true
                   Statistics: Num rows: 28 Data size: 3461 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
-                    expressions: _col2 (type: string), _col1 (type: string), rank_window_0
(type: int), dense_rank_window_1 (type: int), count_window_2 (type: bigint), _col7 (type:
double), sum_window_3 (type: double), _col5 (type: int), (_col5 - lag_window_4) (type: int)
+                    expressions: _col2 (type: string), _col1 (type: string), rank_window_0
(type: int), dense_rank_window_1 (type: int), count_window_2 (type: bigint), _col7 (type:
double), round(sum_window_3, 2) (type: double), _col5 (type: int), (_col5 - lag_window_4)
(type: int)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7,
_col8
                     Statistics: Num rows: 28 Data size: 3461 Basic stats: COMPLETE Column
stats: NONE
                     File Output Operator
@@ -2455,8 +2455,8 @@ STAGE PLANS:
 PREHOOK: query: select abc.p_mfgr, abc.p_name, 
 rank() over (distribute by abc.p_mfgr sort by abc.p_name) as r, 
 dense_rank() over (distribute by abc.p_mfgr sort by abc.p_name) as dr, 
-count(abc.p_name) over (distribute by abc.p_mfgr sort by abc.p_name) as cd, 
-abc.p_retailprice, sum(abc.p_retailprice) over (distribute by abc.p_mfgr sort by abc.p_name
rows between unbounded preceding and current row) as s1, 
+count(abc.p_name) over (distribute by abc.p_mfgr sort by abc.p_name) as cd,
+abc.p_retailprice, round(sum(abc.p_retailprice) over (distribute by abc.p_mfgr sort by abc.p_name
rows between unbounded preceding and current row),2) as s1,
 abc.p_size, abc.p_size - lag(abc.p_size,1,abc.p_size) over (distribute by abc.p_mfgr sort
by abc.p_name) as deltaSz 
 from noop(on part 
 partition by p_mfgr 
@@ -2468,8 +2468,8 @@ PREHOOK: Input: default@part
 POSTHOOK: query: select abc.p_mfgr, abc.p_name, 
 rank() over (distribute by abc.p_mfgr sort by abc.p_name) as r, 
 dense_rank() over (distribute by abc.p_mfgr sort by abc.p_name) as dr, 
-count(abc.p_name) over (distribute by abc.p_mfgr sort by abc.p_name) as cd, 
-abc.p_retailprice, sum(abc.p_retailprice) over (distribute by abc.p_mfgr sort by abc.p_name
rows between unbounded preceding and current row) as s1, 
+count(abc.p_name) over (distribute by abc.p_mfgr sort by abc.p_name) as cd,
+abc.p_retailprice, round(sum(abc.p_retailprice) over (distribute by abc.p_mfgr sort by abc.p_name
rows between unbounded preceding and current row),2) as s1,
 abc.p_size, abc.p_size - lag(abc.p_size,1,abc.p_size) over (distribute by abc.p_mfgr sort
by abc.p_name) as deltaSz 
 from noop(on part 
 partition by p_mfgr 
@@ -2480,15 +2480,15 @@ POSTHOOK: Input: default@part
 #### A masked pattern was here ####
 Manufacturer#1	almond antique burnished rose metallic	1	1	4	1173.15	1173.15	2	0
 Manufacturer#1	almond antique burnished rose metallic	1	1	4	1173.15	2346.3	2	0
-Manufacturer#1	almond antique burnished rose metallic	1	1	4	1173.15	3519.4500000000003	2
0
+Manufacturer#1	almond antique burnished rose metallic	1	1	4	1173.15	3519.45	2	0
 Manufacturer#1	almond antique burnished rose metallic	1	1	4	1173.15	4692.6	2	0
-Manufacturer#1	almond antique chartreuse lavender yellow	5	2	5	1753.76	6446.360000000001
34	32
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	3	6	1602.59	8048.950000000001
6	-28
+Manufacturer#1	almond antique chartreuse lavender yellow	5	2	5	1753.76	6446.36	34	32
+Manufacturer#1	almond antique salmon chartreuse burlywood	6	3	6	1602.59	8048.95	6	-28
 Manufacturer#1	almond aquamarine burnished black steel	7	4	7	1414.42	9463.37	28	22
 Manufacturer#1	almond aquamarine pink moccasin thistle	8	5	8	1632.66	11096.03	42	14
 Manufacturer#2	almond antique violet chocolate turquoise	1	1	1	1690.68	1690.68	14	0
 Manufacturer#2	almond antique violet turquoise frosted	2	2	2	1800.7	3491.38	40	26
-Manufacturer#2	almond aquamarine midnight light salmon	3	3	3	2031.98	5523.360000000001	2
-38
+Manufacturer#2	almond aquamarine midnight light salmon	3	3	3	2031.98	5523.36	2	-38
 Manufacturer#2	almond aquamarine rose maroon antique	4	4	4	1698.66	7222.02	25	23
 Manufacturer#2	almond aquamarine sandy cyan gainsboro	5	5	5	1701.6	8923.62	18	-7
 Manufacturer#3	almond antique chartreuse khaki white	1	1	1	1671.68	1671.68	17	0
@@ -2500,9 +2500,9 @@ Manufacturer#4	almond antique gainsboro frosted violet	1	1	1	1620.67
1620.67	10
 Manufacturer#4	almond antique violet mint lemon	2	2	2	1375.42	2996.09	39	29
 Manufacturer#4	almond aquamarine floral ivory bisque	3	3	3	1206.26	4202.35	27	-12
 Manufacturer#4	almond aquamarine yellow dodger mint	4	4	4	1844.92	6047.27	7	-20
-Manufacturer#4	almond azure aquamarine papaya violet	5	5	5	1290.35	7337.620000000001	12	5
+Manufacturer#4	almond azure aquamarine papaya violet	5	5	5	1290.35	7337.62	12	5
 Manufacturer#5	almond antique blue firebrick mint	1	1	1	1789.69	1789.69	31	0
-Manufacturer#5	almond antique medium spring khaki	2	2	2	1611.66	3401.3500000000004	6	-25
+Manufacturer#5	almond antique medium spring khaki	2	2	2	1611.66	3401.35	6	-25
 Manufacturer#5	almond antique sky peru orange	3	3	3	1788.73	5190.08	2	-4
 Manufacturer#5	almond aquamarine dodger light gainsboro	4	4	4	1018.1	6208.18	46	44
 Manufacturer#5	almond azure blanched chiffon midnight	5	5	5	1464.48	7672.66	23	-23
@@ -2640,7 +2640,7 @@ Manufacturer#5	almond azure blanched chiffon midnight	23
 PREHOOK: query: -- 16. testViewAsTableInputToPTF
 create view IF NOT EXISTS mfgr_price_view as 
 select p_mfgr, p_brand, 
-sum(p_retailprice) as s 
+round(sum(p_retailprice),2) as s
 from part 
 group by p_mfgr, p_brand
 PREHOOK: type: CREATEVIEW
@@ -2650,7 +2650,7 @@ PREHOOK: Output: default@mfgr_price_view
 POSTHOOK: query: -- 16. testViewAsTableInputToPTF
 create view IF NOT EXISTS mfgr_price_view as 
 select p_mfgr, p_brand, 
-sum(p_retailprice) as s 
+round(sum(p_retailprice),2) as s
 from part 
 group by p_mfgr, p_brand
 POSTHOOK: type: CREATEVIEW
@@ -2659,7 +2659,7 @@ POSTHOOK: Output: database:default
 POSTHOOK: Output: default@mfgr_price_view
 PREHOOK: query: explain
 select p_mfgr, p_brand, s, 
-sum(s) over w1  as s1
+round(sum(s) over w1,2)  as s1
 from noop(on mfgr_price_view 
 partition by p_mfgr 
 order by p_mfgr)  
@@ -2667,7 +2667,7 @@ window w1 as ( partition by p_mfgr order by p_brand rows between 2 preceding
and
 PREHOOK: type: QUERY
 POSTHOOK: query: explain
 select p_mfgr, p_brand, s, 
-sum(s) over w1  as s1
+round(sum(s) over w1,2)  as s1
 from noop(on mfgr_price_view 
 partition by p_mfgr 
 order by p_mfgr)  
@@ -2714,26 +2714,30 @@ STAGE PLANS:
                 mode: mergepartial
                 outputColumnNames: _col0, _col1, _col2
                 Statistics: Num rows: 13 Data size: 1573 Basic stats: COMPLETE Column stats:
NONE
-                PTF Operator
-                  Function definitions:
-                      Input definition
-                        input alias: mfgr_price_view
-                        output shape: _col0: string, _col1: string, _col2: double
-                        type: TABLE
-                      Partition table definition
-                        input alias: ptf_1
-                        name: noop
-                        order by: _col0 ASC NULLS FIRST
-                        output shape: _col0: string, _col1: string, _col2: double
-                        partition by: _col0
-                        raw input shape:
+                Select Operator
+                  expressions: _col0 (type: string), _col1 (type: string), round(_col2, 2)
(type: double)
+                  outputColumnNames: _col0, _col1, _col2
                   Statistics: Num rows: 13 Data size: 1573 Basic stats: COMPLETE Column stats:
NONE
-                  Reduce Output Operator
-                    key expressions: _col0 (type: string), _col1 (type: string)
-                    sort order: ++
-                    Map-reduce partition columns: _col0 (type: string)
+                  PTF Operator
+                    Function definitions:
+                        Input definition
+                          input alias: mfgr_price_view
+                          output shape: _col0: string, _col1: string, _col2: double
+                          type: TABLE
+                        Partition table definition
+                          input alias: ptf_1
+                          name: noop
+                          order by: _col0 ASC NULLS FIRST
+                          output shape: _col0: string, _col1: string, _col2: double
+                          partition by: _col0
+                          raw input shape:
                     Statistics: Num rows: 13 Data size: 1573 Basic stats: COMPLETE Column
stats: NONE
-                    value expressions: _col2 (type: double)
+                    Reduce Output Operator
+                      key expressions: _col0 (type: string), _col1 (type: string)
+                      sort order: ++
+                      Map-reduce partition columns: _col0 (type: string)
+                      Statistics: Num rows: 13 Data size: 1573 Basic stats: COMPLETE Column
stats: NONE
+                      value expressions: _col2 (type: double)
         Reducer 3 
             Reduce Operator Tree:
               Select Operator
@@ -2761,7 +2765,7 @@ STAGE PLANS:
                               window frame: PRECEDING(2)~CURRENT
                   Statistics: Num rows: 13 Data size: 1573 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
-                    expressions: _col0 (type: string), _col1 (type: string), _col2 (type:
double), sum_window_0 (type: double)
+                    expressions: _col0 (type: string), _col1 (type: string), _col2 (type:
double), round(sum_window_0, 2) (type: double)
                     outputColumnNames: _col0, _col1, _col2, _col3
                     Statistics: Num rows: 13 Data size: 1573 Basic stats: COMPLETE Column
stats: NONE
                     File Output Operator
@@ -2779,7 +2783,7 @@ STAGE PLANS:
         ListSink
 
 PREHOOK: query: select p_mfgr, p_brand, s, 
-sum(s) over w1  as s1
+round(sum(s) over w1,2) as s1
 from noop(on mfgr_price_view 
 partition by p_mfgr 
 order by p_mfgr)  
@@ -2789,7 +2793,7 @@ PREHOOK: Input: default@mfgr_price_view
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
 POSTHOOK: query: select p_mfgr, p_brand, s, 
-sum(s) over w1  as s1
+round(sum(s) over w1,2) as s1
 from noop(on mfgr_price_view 
 partition by p_mfgr 
 order by p_mfgr)  
@@ -2802,15 +2806,15 @@ Manufacturer#1	Brand#12	4800.84	4800.84
 Manufacturer#1	Brand#14	2346.3	7147.14
 Manufacturer#1	Brand#15	1602.59	8749.73
 Manufacturer#2	Brand#22	3491.38	3491.38
-Manufacturer#2	Brand#23	2031.98	5523.360000000001
+Manufacturer#2	Brand#23	2031.98	5523.36
 Manufacturer#2	Brand#24	1698.66	7222.02
-Manufacturer#2	Brand#25	1701.6	5432.240000000001
+Manufacturer#2	Brand#25	1701.6	5432.24
 Manufacturer#3	Brand#31	1671.68	1671.68
 Manufacturer#3	Brand#32	3333.37	5005.05
 Manufacturer#3	Brand#34	1337.29	6342.34
 Manufacturer#3	Brand#35	1190.27	5860.93
-Manufacturer#4	Brand#41	4755.9400000000005	4755.9400000000005
-Manufacturer#4	Brand#42	2581.6800000000003	7337.620000000001
+Manufacturer#4	Brand#41	4755.94	4755.94
+Manufacturer#4	Brand#42	2581.68	7337.62
 Manufacturer#5	Brand#51	1611.66	1611.66
 Manufacturer#5	Brand#52	3254.17	4865.83
 Manufacturer#5	Brand#53	2806.83	7672.66
@@ -2867,7 +2871,7 @@ order by p_name)
 INSERT OVERWRITE TABLE part_4 select p_mfgr, p_name, p_size, 
 rank() over (distribute by p_mfgr sort by p_name) as r, 
 dense_rank() over (distribute by p_mfgr sort by p_name) as dr, 
-sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding
and current row)  as s  
+round(sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded
preceding and current row),2)  as s
 INSERT OVERWRITE TABLE part_5 select  p_mfgr,p_name, p_size,  
 round(sum(p_size) over (distribute by p_mfgr sort by p_size range between 5 preceding and
current row),1) as s2,
 rank() over (distribute by p_mfgr sort by p_mfgr, p_name) as r, 
@@ -2883,7 +2887,7 @@ order by p_name)
 INSERT OVERWRITE TABLE part_4 select p_mfgr, p_name, p_size, 
 rank() over (distribute by p_mfgr sort by p_name) as r, 
 dense_rank() over (distribute by p_mfgr sort by p_name) as dr, 
-sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding
and current row)  as s  
+round(sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded
preceding and current row),2)  as s
 INSERT OVERWRITE TABLE part_5 select  p_mfgr,p_name, p_size,  
 round(sum(p_size) over (distribute by p_mfgr sort by p_size range between 5 preceding and
current row),1) as s2,
 rank() over (distribute by p_mfgr sort by p_mfgr, p_name) as r, 
@@ -2962,7 +2966,7 @@ STAGE PLANS:
                               window frame: PRECEDING(MAX)~CURRENT
                   Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
-                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type:
int), rank_window_0 (type: int), dense_rank_window_1 (type: int), sum_window_2 (type: double)
+                    expressions: _col2 (type: string), _col1 (type: string), _col5 (type:
int), rank_window_0 (type: int), dense_rank_window_1 (type: int), round(sum_window_2, 2) (type:
double)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
                     Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column
stats: NONE
                     File Output Operator
@@ -3149,7 +3153,7 @@ order by p_name)
 INSERT OVERWRITE TABLE part_4 select p_mfgr, p_name, p_size, 
 rank() over (distribute by p_mfgr sort by p_name) as r, 
 dense_rank() over (distribute by p_mfgr sort by p_name) as dr, 
-sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding
and current row)  as s  
+round(sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded
preceding and current row),2)  as s
 INSERT OVERWRITE TABLE part_5 select  p_mfgr,p_name, p_size,  
 round(sum(p_size) over (distribute by p_mfgr sort by p_size range between 5 preceding and
current row),1) as s2,
 rank() over (distribute by p_mfgr sort by p_mfgr, p_name) as r, 
@@ -3167,7 +3171,7 @@ order by p_name)
 INSERT OVERWRITE TABLE part_4 select p_mfgr, p_name, p_size, 
 rank() over (distribute by p_mfgr sort by p_name) as r, 
 dense_rank() over (distribute by p_mfgr sort by p_name) as dr, 
-sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding
and current row)  as s  
+round(sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded
preceding and current row),2)  as s
 INSERT OVERWRITE TABLE part_5 select  p_mfgr,p_name, p_size,  
 round(sum(p_size) over (distribute by p_mfgr sort by p_size range between 5 preceding and
current row),1) as s2,
 rank() over (distribute by p_mfgr sort by p_mfgr, p_name) as r, 
@@ -3204,12 +3208,12 @@ POSTHOOK: Input: default@part_4
 Manufacturer#1	almond antique burnished rose metallic	2	1	1	1173.15
 Manufacturer#1	almond antique burnished rose metallic	2	1	1	2346.3
 Manufacturer#1	almond antique chartreuse lavender yellow	34	3	2	4100.06
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	3	5702.650000000001
-Manufacturer#1	almond aquamarine burnished black steel	28	5	4	7117.070000000001
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	5	8749.730000000001
+Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	3	5702.65
+Manufacturer#1	almond aquamarine burnished black steel	28	5	4	7117.07
+Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	5	8749.73
 Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	1690.68
 Manufacturer#2	almond antique violet turquoise frosted	40	2	2	3491.38
-Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	5523.360000000001
+Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	5523.36
 Manufacturer#2	almond aquamarine rose maroon antique	25	4	4	7222.02
 Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	5	5	8923.62
 Manufacturer#3	almond antique chartreuse khaki white	17	1	1	1671.68
@@ -3221,9 +3225,9 @@ Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	1620.67
 Manufacturer#4	almond antique violet mint lemon	39	2	2	2996.09
 Manufacturer#4	almond aquamarine floral ivory bisque	27	3	3	4202.35
 Manufacturer#4	almond aquamarine yellow dodger mint	7	4	4	6047.27
-Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	7337.620000000001
+Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	7337.62
 Manufacturer#5	almond antique blue firebrick mint	31	1	1	1789.69
-Manufacturer#5	almond antique medium spring khaki	6	2	2	3401.3500000000004
+Manufacturer#5	almond antique medium spring khaki	6	2	2	3401.35
 Manufacturer#5	almond antique sky peru orange	2	3	3	5190.08
 Manufacturer#5	almond aquamarine dodger light gainsboro	46	4	4	6208.18
 Manufacturer#5	almond azure blanched chiffon midnight	23	5	5	7672.66


Mime
View raw message