hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject svn commit: r1471691 [3/5] - in /hive/branches/branch-0.11/ql/src/test: queries/clientpositive/ results/clientpositive/
Date Wed, 24 Apr 2013 21:29:59 GMT
Modified: hive/branches/branch-0.11/ql/src/test/results/clientpositive/windowing.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.11/ql/src/test/results/clientpositive/windowing.q.out?rev=1471691&r1=1471690&r2=1471691&view=diff
==============================================================================
--- hive/branches/branch-0.11/ql/src/test/results/clientpositive/windowing.q.out (original)
+++ hive/branches/branch-0.11/ql/src/test/results/clientpositive/windowing.q.out Wed Apr 24 21:29:59 2013
@@ -497,40 +497,40 @@ Manufacturer#5	almond aquamarine dodger 
 Manufacturer#5	almond azure blanched chiffon midnight	23	5	5	7672.66
 PREHOOK: query: -- 11. testFirstLast   
 select  p_mfgr,p_name, p_size, 
-sum(p_size) over (distribute by p_mfgr sort by p_mfgr rows between current row and current row) as s2, 
+sum(p_size) over (distribute by p_mfgr sort by p_name rows between current row and current row) as s2, 
 first_value(p_size) over w1  as f, 
 last_value(p_size, false) over w1  as l 
 from part 
-window w1 as (distribute by p_mfgr sort by p_mfgr rows between 2 preceding and 2 following)
+window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
 POSTHOOK: query: -- 11. testFirstLast   
 select  p_mfgr,p_name, p_size, 
-sum(p_size) over (distribute by p_mfgr sort by p_mfgr rows between current row and current row) as s2, 
+sum(p_size) over (distribute by p_mfgr sort by p_name rows between current row and current row) as s2, 
 first_value(p_size) over w1  as f, 
 last_value(p_size, false) over w1  as l 
 from part 
-window w1 as (distribute by p_mfgr sort by p_mfgr rows between 2 preceding and 2 following)
+window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	2	2	2	2
-Manufacturer#1	almond antique chartreuse lavender yellow	34	34	2	6
-Manufacturer#1	almond antique burnished rose metallic	2	2	2	28
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	6	34	42
-Manufacturer#1	almond aquamarine burnished black steel	28	28	2	42
+Manufacturer#1	almond antique burnished rose metallic	2	2	2	34
+Manufacturer#1	almond antique burnished rose metallic	2	2	2	6
+Manufacturer#1	almond antique chartreuse lavender yellow	34	34	2	28
+Manufacturer#1	almond antique salmon chartreuse burlywood	6	6	2	42
+Manufacturer#1	almond aquamarine burnished black steel	28	28	34	42
 Manufacturer#1	almond aquamarine pink moccasin thistle	42	42	6	42
 Manufacturer#2	almond antique violet chocolate turquoise	14	14	14	2
 Manufacturer#2	almond antique violet turquoise frosted	40	40	14	25
 Manufacturer#2	almond aquamarine midnight light salmon	2	2	14	18
 Manufacturer#2	almond aquamarine rose maroon antique	25	25	40	18
 Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	18	2	18
-Manufacturer#3	almond antique metallic orange dim	19	19	19	14
-Manufacturer#3	almond antique chartreuse khaki white	17	17	19	1
-Manufacturer#3	almond antique forest lavender goldenrod	14	14	19	45
-Manufacturer#3	almond antique misty red olive	1	1	17	45
-Manufacturer#3	almond antique olive coral navajo	45	45	14	45
+Manufacturer#3	almond antique chartreuse khaki white	17	17	17	19
+Manufacturer#3	almond antique forest lavender goldenrod	14	14	17	1
+Manufacturer#3	almond antique metallic orange dim	19	19	17	45
+Manufacturer#3	almond antique misty red olive	1	1	14	45
+Manufacturer#3	almond antique olive coral navajo	45	45	19	45
 Manufacturer#4	almond antique gainsboro frosted violet	10	10	10	27
 Manufacturer#4	almond antique violet mint lemon	39	39	10	7
 Manufacturer#4	almond aquamarine floral ivory bisque	27	27	10	12
@@ -543,67 +543,67 @@ Manufacturer#5	almond aquamarine dodger 
 Manufacturer#5	almond azure blanched chiffon midnight	23	23	2	23
 PREHOOK: query: -- 12. testFirstLastWithWhere
 select  p_mfgr,p_name, p_size, 
-rank() over(distribute by p_mfgr sort by p_mfgr) as r, 
-sum(p_size) over (distribute by p_mfgr sort by p_mfgr rows between current row and current row) as s2, 
+rank() over(distribute by p_mfgr sort by p_name) as r, 
+sum(p_size) over (distribute by p_mfgr sort by p_name rows between current row and current row) as s2, 
 first_value(p_size) over w1 as f,  
 last_value(p_size, false) over w1 as l 
 from part 
 where p_mfgr = 'Manufacturer#3'  
-window w1 as (distribute by p_mfgr sort by p_mfgr rows between 2 preceding and 2 following)
+window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
 POSTHOOK: query: -- 12. testFirstLastWithWhere
 select  p_mfgr,p_name, p_size, 
-rank() over(distribute by p_mfgr sort by p_mfgr) as r, 
-sum(p_size) over (distribute by p_mfgr sort by p_mfgr rows between current row and current row) as s2, 
+rank() over(distribute by p_mfgr sort by p_name) as r, 
+sum(p_size) over (distribute by p_mfgr sort by p_name rows between current row and current row) as s2, 
 first_value(p_size) over w1 as f,  
 last_value(p_size, false) over w1 as l 
 from part 
 where p_mfgr = 'Manufacturer#3'  
-window w1 as (distribute by p_mfgr sort by p_mfgr rows between 2 preceding and 2 following)
+window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
 Manufacturer#3	almond antique chartreuse khaki white	17	1	17	17	19
-Manufacturer#3	almond antique forest lavender goldenrod	14	1	14	17	1
-Manufacturer#3	almond antique metallic orange dim	19	1	19	17	45
-Manufacturer#3	almond antique misty red olive	1	1	1	14	45
-Manufacturer#3	almond antique olive coral navajo	45	1	45	19	45
+Manufacturer#3	almond antique forest lavender goldenrod	14	2	14	17	1
+Manufacturer#3	almond antique metallic orange dim	19	3	19	17	45
+Manufacturer#3	almond antique misty red olive	1	4	1	14	45
+Manufacturer#3	almond antique olive coral navajo	45	5	45	19	45
 PREHOOK: query: -- 13. testSumWindow
 select  p_mfgr,p_name, p_size,  
 sum(p_size) over w1 as s1, 
-sum(p_size) over (distribute by p_mfgr  sort by p_mfgr rows between current row and current row)  as s2 
+sum(p_size) over (distribute by p_mfgr  sort by p_name rows between current row and current row)  as s2 
 from part 
-window w1 as (distribute by p_mfgr  sort by p_mfgr rows between 2 preceding and 2 following)
+window w1 as (distribute by p_mfgr  sort by p_name rows between 2 preceding and 2 following)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
 POSTHOOK: query: -- 13. testSumWindow
 select  p_mfgr,p_name, p_size,  
 sum(p_size) over w1 as s1, 
-sum(p_size) over (distribute by p_mfgr  sort by p_mfgr rows between current row and current row)  as s2 
+sum(p_size) over (distribute by p_mfgr  sort by p_name rows between current row and current row)  as s2 
 from part 
-window w1 as (distribute by p_mfgr  sort by p_mfgr rows between 2 preceding and 2 following)
+window w1 as (distribute by p_mfgr  sort by p_name rows between 2 preceding and 2 following)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
 Manufacturer#1	almond antique burnished rose metallic	2	38	2
-Manufacturer#1	almond antique chartreuse lavender yellow	34	44	34
-Manufacturer#1	almond antique burnished rose metallic	2	72	2
+Manufacturer#1	almond antique burnished rose metallic	2	44	2
+Manufacturer#1	almond antique chartreuse lavender yellow	34	72	34
 Manufacturer#1	almond antique salmon chartreuse burlywood	6	112	6
-Manufacturer#1	almond aquamarine burnished black steel	28	78	28
+Manufacturer#1	almond aquamarine burnished black steel	28	110	28
 Manufacturer#1	almond aquamarine pink moccasin thistle	42	76	42
 Manufacturer#2	almond antique violet chocolate turquoise	14	56	14
 Manufacturer#2	almond antique violet turquoise frosted	40	81	40
 Manufacturer#2	almond aquamarine midnight light salmon	2	99	2
 Manufacturer#2	almond aquamarine rose maroon antique	25	85	25
 Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	45	18
-Manufacturer#3	almond antique metallic orange dim	19	50	19
-Manufacturer#3	almond antique chartreuse khaki white	17	51	17
-Manufacturer#3	almond antique forest lavender goldenrod	14	96	14
-Manufacturer#3	almond antique misty red olive	1	77	1
-Manufacturer#3	almond antique olive coral navajo	45	60	45
+Manufacturer#3	almond antique chartreuse khaki white	17	50	17
+Manufacturer#3	almond antique forest lavender goldenrod	14	51	14
+Manufacturer#3	almond antique metallic orange dim	19	96	19
+Manufacturer#3	almond antique misty red olive	1	79	1
+Manufacturer#3	almond antique olive coral navajo	45	65	45
 Manufacturer#4	almond antique gainsboro frosted violet	10	76	10
 Manufacturer#4	almond antique violet mint lemon	39	83	39
 Manufacturer#4	almond aquamarine floral ivory bisque	27	95	27
@@ -616,58 +616,58 @@ Manufacturer#5	almond aquamarine dodger 
 Manufacturer#5	almond azure blanched chiffon midnight	23	71	23
 PREHOOK: query: -- 14. testNoSortClause
 select  p_mfgr,p_name, p_size, 
-rank() over(distribute by p_mfgr) as r, dense_rank() over(distribute by p_mfgr) as dr 
+rank() over(distribute by p_mfgr sort by p_name) as r, dense_rank() over(distribute by p_mfgr sort by p_name) as dr 
 from part  
-window w1 as (distribute by p_mfgr rows between 2 preceding and 2 following)
+window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
 POSTHOOK: query: -- 14. testNoSortClause
 select  p_mfgr,p_name, p_size, 
-rank() over(distribute by p_mfgr) as r, dense_rank() over(distribute by p_mfgr) as dr 
+rank() over(distribute by p_mfgr sort by p_name) as r, dense_rank() over(distribute by p_mfgr sort by p_name) as dr 
 from part  
-window w1 as (distribute by p_mfgr rows between 2 preceding and 2 following)
+window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
 Manufacturer#1	almond antique burnished rose metallic	2	1	1
-Manufacturer#1	almond antique chartreuse lavender yellow	34	1	1
 Manufacturer#1	almond antique burnished rose metallic	2	1	1
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	1	1
-Manufacturer#1	almond aquamarine burnished black steel	28	1	1
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	1	1
+Manufacturer#1	almond antique chartreuse lavender yellow	34	3	2
+Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	3
+Manufacturer#1	almond aquamarine burnished black steel	28	5	4
+Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	5
 Manufacturer#2	almond antique violet chocolate turquoise	14	1	1
-Manufacturer#2	almond antique violet turquoise frosted	40	1	1
-Manufacturer#2	almond aquamarine midnight light salmon	2	1	1
-Manufacturer#2	almond aquamarine rose maroon antique	25	1	1
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	1	1
-Manufacturer#3	almond antique metallic orange dim	19	1	1
+Manufacturer#2	almond antique violet turquoise frosted	40	2	2
+Manufacturer#2	almond aquamarine midnight light salmon	2	3	3
+Manufacturer#2	almond aquamarine rose maroon antique	25	4	4
+Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	5	5
 Manufacturer#3	almond antique chartreuse khaki white	17	1	1
-Manufacturer#3	almond antique forest lavender goldenrod	14	1	1
-Manufacturer#3	almond antique misty red olive	1	1	1
-Manufacturer#3	almond antique olive coral navajo	45	1	1
+Manufacturer#3	almond antique forest lavender goldenrod	14	2	2
+Manufacturer#3	almond antique metallic orange dim	19	3	3
+Manufacturer#3	almond antique misty red olive	1	4	4
+Manufacturer#3	almond antique olive coral navajo	45	5	5
 Manufacturer#4	almond antique gainsboro frosted violet	10	1	1
-Manufacturer#4	almond antique violet mint lemon	39	1	1
-Manufacturer#4	almond aquamarine floral ivory bisque	27	1	1
-Manufacturer#4	almond aquamarine yellow dodger mint	7	1	1
-Manufacturer#4	almond azure aquamarine papaya violet	12	1	1
+Manufacturer#4	almond antique violet mint lemon	39	2	2
+Manufacturer#4	almond aquamarine floral ivory bisque	27	3	3
+Manufacturer#4	almond aquamarine yellow dodger mint	7	4	4
+Manufacturer#4	almond azure aquamarine papaya violet	12	5	5
 Manufacturer#5	almond antique blue firebrick mint	31	1	1
-Manufacturer#5	almond antique medium spring khaki	6	1	1
-Manufacturer#5	almond antique sky peru orange	2	1	1
-Manufacturer#5	almond aquamarine dodger light gainsboro	46	1	1
-Manufacturer#5	almond azure blanched chiffon midnight	23	1	1
+Manufacturer#5	almond antique medium spring khaki	6	2	2
+Manufacturer#5	almond antique sky peru orange	2	3	3
+Manufacturer#5	almond aquamarine dodger light gainsboro	46	4	4
+Manufacturer#5	almond azure blanched chiffon midnight	23	5	5
 PREHOOK: query: -- 15. testExpressions
 select  p_mfgr,p_name, p_size,  
-rank() over(distribute by p_mfgr sort by p_mfgr) as r,  
-dense_rank() over(distribute by p_mfgr sort by p_mfgr) as dr, 
-cume_dist() over(distribute by p_mfgr sort by p_mfgr) as cud, 
-percent_rank() over(distribute by p_mfgr sort by p_mfgr) as pr, 
-ntile(3) over(distribute by p_mfgr sort by p_mfgr) as nt, 
-count(p_size) over(distribute by p_mfgr sort by p_mfgr) as ca, 
-avg(p_size) over(distribute by p_mfgr sort by p_mfgr) as avg, 
-stddev(p_size) over(distribute by p_mfgr sort by p_mfgr) as st, 
-first_value(p_size % 5) over(distribute by p_mfgr sort by p_mfgr) as fv, 
-last_value(p_size) over(distribute by p_mfgr sort by p_mfgr) as lv, 
+rank() over(distribute by p_mfgr sort by p_name) as r,  
+dense_rank() over(distribute by p_mfgr sort by p_name) as dr, 
+cume_dist() over(distribute by p_mfgr sort by p_name) as cud, 
+percent_rank() over(distribute by p_mfgr sort by p_name) as pr, 
+ntile(3) over(distribute by p_mfgr sort by p_name) as nt, 
+count(p_size) over(distribute by p_mfgr sort by p_name) as ca, 
+avg(p_size) over(distribute by p_mfgr sort by p_name) as avg, 
+stddev(p_size) over(distribute by p_mfgr sort by p_name) as st, 
+first_value(p_size % 5) over(distribute by p_mfgr sort by p_name) as fv, 
+last_value(p_size) over(distribute by p_mfgr sort by p_name) as lv, 
 first_value(p_size) over w1  as fvW1
 from part 
 window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following)
@@ -676,54 +676,54 @@ PREHOOK: Input: default@part
 #### A masked pattern was here ####
 POSTHOOK: query: -- 15. testExpressions
 select  p_mfgr,p_name, p_size,  
-rank() over(distribute by p_mfgr sort by p_mfgr) as r,  
-dense_rank() over(distribute by p_mfgr sort by p_mfgr) as dr, 
-cume_dist() over(distribute by p_mfgr sort by p_mfgr) as cud, 
-percent_rank() over(distribute by p_mfgr sort by p_mfgr) as pr, 
-ntile(3) over(distribute by p_mfgr sort by p_mfgr) as nt, 
-count(p_size) over(distribute by p_mfgr sort by p_mfgr) as ca, 
-avg(p_size) over(distribute by p_mfgr sort by p_mfgr) as avg, 
-stddev(p_size) over(distribute by p_mfgr sort by p_mfgr) as st, 
-first_value(p_size % 5) over(distribute by p_mfgr sort by p_mfgr) as fv, 
-last_value(p_size) over(distribute by p_mfgr sort by p_mfgr) as lv, 
+rank() over(distribute by p_mfgr sort by p_name) as r,  
+dense_rank() over(distribute by p_mfgr sort by p_name) as dr, 
+cume_dist() over(distribute by p_mfgr sort by p_name) as cud, 
+percent_rank() over(distribute by p_mfgr sort by p_name) as pr, 
+ntile(3) over(distribute by p_mfgr sort by p_name) as nt, 
+count(p_size) over(distribute by p_mfgr sort by p_name) as ca, 
+avg(p_size) over(distribute by p_mfgr sort by p_name) as avg, 
+stddev(p_size) over(distribute by p_mfgr sort by p_name) as st, 
+first_value(p_size % 5) over(distribute by p_mfgr sort by p_name) as fv, 
+last_value(p_size) over(distribute by p_mfgr sort by p_name) as lv, 
 first_value(p_size) over w1  as fvW1
 from part 
 window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	2	1	1	1.0	0.0	2	6	19.0	16.237815945091466	2	42	2
-Manufacturer#1	almond antique burnished rose metallic	2	1	1	1.0	0.0	1	6	19.0	16.237815945091466	2	42	2
-Manufacturer#1	almond antique chartreuse lavender yellow	34	1	1	1.0	0.0	1	6	19.0	16.237815945091466	2	42	2
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	1	1	1.0	0.0	2	6	19.0	16.237815945091466	2	42	2
-Manufacturer#1	almond aquamarine burnished black steel	28	1	1	1.0	0.0	3	6	19.0	16.237815945091466	2	42	34
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	1	1	1.0	0.0	3	6	19.0	16.237815945091466	2	42	6
-Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	1.0	0.0	1	5	19.8	12.560254774486067	4	18	14
-Manufacturer#2	almond antique violet turquoise frosted	40	1	1	1.0	0.0	1	5	19.8	12.560254774486067	4	18	14
-Manufacturer#2	almond aquamarine midnight light salmon	2	1	1	1.0	0.0	2	5	19.8	12.560254774486067	4	18	14
-Manufacturer#2	almond aquamarine rose maroon antique	25	1	1	1.0	0.0	2	5	19.8	12.560254774486067	4	18	40
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	1	1	1.0	0.0	3	5	19.8	12.560254774486067	4	18	2
-Manufacturer#3	almond antique chartreuse khaki white	17	1	1	1.0	0.0	1	5	19.2	14.344336861632886	4	45	17
-Manufacturer#3	almond antique forest lavender goldenrod	14	1	1	1.0	0.0	2	5	19.2	14.344336861632886	4	45	17
-Manufacturer#3	almond antique metallic orange dim	19	1	1	1.0	0.0	1	5	19.2	14.344336861632886	4	45	17
-Manufacturer#3	almond antique misty red olive	1	1	1	1.0	0.0	2	5	19.2	14.344336861632886	4	45	14
-Manufacturer#3	almond antique olive coral navajo	45	1	1	1.0	0.0	3	5	19.2	14.344336861632886	4	45	19
-Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	1.0	0.0	1	5	19.0	12.149074038789951	0	12	10
-Manufacturer#4	almond antique violet mint lemon	39	1	1	1.0	0.0	1	5	19.0	12.149074038789951	0	12	10
-Manufacturer#4	almond aquamarine floral ivory bisque	27	1	1	1.0	0.0	2	5	19.0	12.149074038789951	0	12	10
-Manufacturer#4	almond aquamarine yellow dodger mint	7	1	1	1.0	0.0	2	5	19.0	12.149074038789951	0	12	39
-Manufacturer#4	almond azure aquamarine papaya violet	12	1	1	1.0	0.0	3	5	19.0	12.149074038789951	0	12	27
-Manufacturer#5	almond antique blue firebrick mint	31	1	1	1.0	0.0	1	5	21.6	16.206171663906314	1	23	31
-Manufacturer#5	almond antique medium spring khaki	6	1	1	1.0	0.0	1	5	21.6	16.206171663906314	1	23	31
-Manufacturer#5	almond antique sky peru orange	2	1	1	1.0	0.0	2	5	21.6	16.206171663906314	1	23	31
-Manufacturer#5	almond aquamarine dodger light gainsboro	46	1	1	1.0	0.0	2	5	21.6	16.206171663906314	1	23	6
-Manufacturer#5	almond azure blanched chiffon midnight	23	1	1	1.0	0.0	3	5	21.6	16.206171663906314	1	23	2
+Manufacturer#1	almond antique burnished rose metallic	2	1	1	0.3333333333333333	0.0	1	2	2.0	0.0	2	2	2
+Manufacturer#1	almond antique burnished rose metallic	2	1	1	0.3333333333333333	0.0	1	2	2.0	0.0	2	2	2
+Manufacturer#1	almond antique chartreuse lavender yellow	34	3	2	0.5	0.4	2	3	12.666666666666666	15.084944665313014	2	34	2
+Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	3	0.6666666666666666	0.6	2	4	11.0	13.379088160259652	2	6	2
+Manufacturer#1	almond aquamarine burnished black steel	28	5	4	0.8333333333333334	0.8	3	5	14.4	13.763720427268202	2	28	34
+Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	5	1.0	1.0	3	6	19.0	16.237815945091466	2	42	6
+Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	0.2	0.0	1	1	14.0	0.0	4	14	14
+Manufacturer#2	almond antique violet turquoise frosted	40	2	2	0.4	0.25	1	2	27.0	13.0	4	40	14
+Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	0.6	0.5	2	3	18.666666666666668	15.86050300449376	4	2	14
+Manufacturer#2	almond aquamarine rose maroon antique	25	4	4	0.8	0.75	2	4	20.25	14.00669482783144	4	25	40
+Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	5	5	1.0	1.0	3	5	19.8	12.560254774486067	4	18	2
+Manufacturer#3	almond antique chartreuse khaki white	17	1	1	0.2	0.0	1	1	17.0	0.0	2	17	17
+Manufacturer#3	almond antique forest lavender goldenrod	14	2	2	0.4	0.25	1	2	15.5	1.5	2	14	17
+Manufacturer#3	almond antique metallic orange dim	19	3	3	0.6	0.5	2	3	16.666666666666668	2.0548046676563256	2	19	17
+Manufacturer#3	almond antique misty red olive	1	4	4	0.8	0.75	2	4	12.75	7.013380069552769	2	1	14
+Manufacturer#3	almond antique olive coral navajo	45	5	5	1.0	1.0	3	5	19.2	14.344336861632886	2	45	19
+Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	0.2	0.0	1	1	10.0	0.0	0	10	10
+Manufacturer#4	almond antique violet mint lemon	39	2	2	0.4	0.25	1	2	24.5	14.5	0	39	10
+Manufacturer#4	almond aquamarine floral ivory bisque	27	3	3	0.6	0.5	2	3	25.333333333333332	11.897712198383164	0	27	10
+Manufacturer#4	almond aquamarine yellow dodger mint	7	4	4	0.8	0.75	2	4	20.75	13.007209539328564	0	7	39
+Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	1.0	1.0	3	5	19.0	12.149074038789951	0	12	27
+Manufacturer#5	almond antique blue firebrick mint	31	1	1	0.2	0.0	1	1	31.0	0.0	1	31	31
+Manufacturer#5	almond antique medium spring khaki	6	2	2	0.4	0.25	1	2	18.5	12.5	1	6	31
+Manufacturer#5	almond antique sky peru orange	2	3	3	0.6	0.5	2	3	13.0	12.832251036613439	1	2	31
+Manufacturer#5	almond aquamarine dodger light gainsboro	46	4	4	0.8	0.75	2	4	21.25	18.102140757380052	1	46	6
+Manufacturer#5	almond azure blanched chiffon midnight	23	5	5	1.0	1.0	3	5	21.6	16.206171663906314	1	23	2
 PREHOOK: query: -- 16. testMultipleWindows
 select  p_mfgr,p_name, p_size,  
-  rank() over(distribute by p_mfgr sort by p_mfgr) as r, 
-  dense_rank() over(distribute by p_mfgr sort by p_mfgr) as dr, 
-cume_dist() over(distribute by p_mfgr sort by p_mfgr) as cud, 
-sum(p_size) over (distribute by p_mfgr sort by p_mfgr, p_name rows between unbounded preceding and current row) as s1, 
+  rank() over(distribute by p_mfgr sort by p_name) as r, 
+  dense_rank() over(distribute by p_mfgr sort by p_name) as dr, 
+cume_dist() over(distribute by p_mfgr sort by p_name) as cud, 
+sum(p_size) over (distribute by p_mfgr sort by p_name range between unbounded preceding and current row) as s1, 
 sum(p_size) over (distribute by p_mfgr sort by p_size range between 5 preceding and current row) as s2, 
 first_value(p_size) over w1  as fv1
 from part 
@@ -733,10 +733,10 @@ PREHOOK: Input: default@part
 #### A masked pattern was here ####
 POSTHOOK: query: -- 16. testMultipleWindows
 select  p_mfgr,p_name, p_size,  
-  rank() over(distribute by p_mfgr sort by p_mfgr) as r, 
-  dense_rank() over(distribute by p_mfgr sort by p_mfgr) as dr, 
-cume_dist() over(distribute by p_mfgr sort by p_mfgr) as cud, 
-sum(p_size) over (distribute by p_mfgr sort by p_mfgr, p_name rows between unbounded preceding and current row) as s1, 
+  rank() over(distribute by p_mfgr sort by p_name) as r, 
+  dense_rank() over(distribute by p_mfgr sort by p_name) as dr, 
+cume_dist() over(distribute by p_mfgr sort by p_name) as cud, 
+sum(p_size) over (distribute by p_mfgr sort by p_name range between unbounded preceding and current row) as s1, 
 sum(p_size) over (distribute by p_mfgr sort by p_size range between 5 preceding and current row) as s2, 
 first_value(p_size) over w1  as fv1
 from part 
@@ -744,36 +744,36 @@ window w1 as (distribute by p_mfgr sort 
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	2	1	1	1.0	4	4	2
-Manufacturer#1	almond antique burnished rose metallic	2	1	1	1.0	2	4	2
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	1	1	1.0	44	10	2
-Manufacturer#1	almond aquamarine burnished black steel	28	1	1	1.0	72	28	34
-Manufacturer#1	almond antique chartreuse lavender yellow	34	1	1	1.0	38	34	2
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	1	1	1.0	114	42	6
-Manufacturer#2	almond aquamarine midnight light salmon	2	1	1	1.0	56	2	14
-Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	1.0	14	14	14
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	1	1	1.0	99	32	2
-Manufacturer#2	almond aquamarine rose maroon antique	25	1	1	1.0	81	25	40
-Manufacturer#2	almond antique violet turquoise frosted	40	1	1	1.0	54	40	14
-Manufacturer#3	almond antique misty red olive	1	1	1	1.0	51	1	14
-Manufacturer#3	almond antique forest lavender goldenrod	14	1	1	1.0	31	14	17
-Manufacturer#3	almond antique chartreuse khaki white	17	1	1	1.0	17	31	17
-Manufacturer#3	almond antique metallic orange dim	19	1	1	1.0	50	50	17
-Manufacturer#3	almond antique olive coral navajo	45	1	1	1.0	96	45	19
-Manufacturer#4	almond aquamarine yellow dodger mint	7	1	1	1.0	83	7	39
-Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	1.0	10	17	10
-Manufacturer#4	almond azure aquamarine papaya violet	12	1	1	1.0	95	29	27
-Manufacturer#4	almond aquamarine floral ivory bisque	27	1	1	1.0	76	27	10
-Manufacturer#4	almond antique violet mint lemon	39	1	1	1.0	49	39	10
-Manufacturer#5	almond antique sky peru orange	2	1	1	1.0	39	2	31
-Manufacturer#5	almond antique medium spring khaki	6	1	1	1.0	37	8	31
-Manufacturer#5	almond azure blanched chiffon midnight	23	1	1	1.0	108	23	2
-Manufacturer#5	almond antique blue firebrick mint	31	1	1	1.0	31	31	31
-Manufacturer#5	almond aquamarine dodger light gainsboro	46	1	1	1.0	85	46	6
+Manufacturer#1	almond antique burnished rose metallic	2	1	1	0.3333333333333333	4	4	2
+Manufacturer#1	almond antique burnished rose metallic	2	1	1	0.3333333333333333	4	4	2
+Manufacturer#1	almond antique chartreuse lavender yellow	34	3	2	0.5	38	34	2
+Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	3	0.6666666666666666	44	10	2
+Manufacturer#1	almond aquamarine burnished black steel	28	5	4	0.8333333333333334	72	28	34
+Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	5	1.0	114	42	6
+Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	0.2	14	14	14
+Manufacturer#2	almond antique violet turquoise frosted	40	2	2	0.4	54	40	14
+Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	0.6	56	2	14
+Manufacturer#2	almond aquamarine rose maroon antique	25	4	4	0.8	81	25	40
+Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	5	5	1.0	99	32	2
+Manufacturer#3	almond antique chartreuse khaki white	17	1	1	0.2	17	31	17
+Manufacturer#3	almond antique forest lavender goldenrod	14	2	2	0.4	31	14	17
+Manufacturer#3	almond antique metallic orange dim	19	3	3	0.6	50	50	17
+Manufacturer#3	almond antique misty red olive	1	4	4	0.8	51	1	14
+Manufacturer#3	almond antique olive coral navajo	45	5	5	1.0	96	45	19
+Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	0.2	10	17	10
+Manufacturer#4	almond antique violet mint lemon	39	2	2	0.4	49	39	10
+Manufacturer#4	almond aquamarine floral ivory bisque	27	3	3	0.6	76	27	10
+Manufacturer#4	almond aquamarine yellow dodger mint	7	4	4	0.8	83	7	39
+Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	1.0	95	29	27
+Manufacturer#5	almond antique blue firebrick mint	31	1	1	0.2	31	31	31
+Manufacturer#5	almond antique medium spring khaki	6	2	2	0.4	37	8	31
+Manufacturer#5	almond antique sky peru orange	2	3	3	0.6	39	2	31
+Manufacturer#5	almond aquamarine dodger light gainsboro	46	4	4	0.8	85	46	6
+Manufacturer#5	almond azure blanched chiffon midnight	23	5	5	1.0	108	23	2
 PREHOOK: query: -- 17. testCountStar
 select  p_mfgr,p_name, p_size,
-count(*) over(distribute by p_mfgr sort by p_mfgr ) as c, 
-count(p_size) over(distribute by p_mfgr sort by p_mfgr) as ca, 
+count(*) over(distribute by p_mfgr sort by p_name ) as c, 
+count(p_size) over(distribute by p_mfgr sort by p_name) as ca, 
 first_value(p_size) over w1  as fvW1
 from part 
 window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following)
@@ -782,39 +782,39 @@ PREHOOK: Input: default@part
 #### A masked pattern was here ####
 POSTHOOK: query: -- 17. testCountStar
 select  p_mfgr,p_name, p_size,
-count(*) over(distribute by p_mfgr sort by p_mfgr ) as c, 
-count(p_size) over(distribute by p_mfgr sort by p_mfgr) as ca, 
+count(*) over(distribute by p_mfgr sort by p_name ) as c, 
+count(p_size) over(distribute by p_mfgr sort by p_name) as ca, 
 first_value(p_size) over w1  as fvW1
 from part 
 window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	2	6	6	2
-Manufacturer#1	almond antique burnished rose metallic	2	6	6	2
-Manufacturer#1	almond antique chartreuse lavender yellow	34	6	6	2
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	6	6	2
-Manufacturer#1	almond aquamarine burnished black steel	28	6	6	34
+Manufacturer#1	almond antique burnished rose metallic	2	2	2	2
+Manufacturer#1	almond antique burnished rose metallic	2	2	2	2
+Manufacturer#1	almond antique chartreuse lavender yellow	34	3	3	2
+Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	4	2
+Manufacturer#1	almond aquamarine burnished black steel	28	5	5	34
 Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	6	6
-Manufacturer#2	almond antique violet chocolate turquoise	14	5	5	14
-Manufacturer#2	almond antique violet turquoise frosted	40	5	5	14
-Manufacturer#2	almond aquamarine midnight light salmon	2	5	5	14
-Manufacturer#2	almond aquamarine rose maroon antique	25	5	5	40
+Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	14
+Manufacturer#2	almond antique violet turquoise frosted	40	2	2	14
+Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	14
+Manufacturer#2	almond aquamarine rose maroon antique	25	4	4	40
 Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	5	5	2
-Manufacturer#3	almond antique chartreuse khaki white	17	5	5	17
-Manufacturer#3	almond antique forest lavender goldenrod	14	5	5	17
-Manufacturer#3	almond antique metallic orange dim	19	5	5	17
-Manufacturer#3	almond antique misty red olive	1	5	5	14
+Manufacturer#3	almond antique chartreuse khaki white	17	1	1	17
+Manufacturer#3	almond antique forest lavender goldenrod	14	2	2	17
+Manufacturer#3	almond antique metallic orange dim	19	3	3	17
+Manufacturer#3	almond antique misty red olive	1	4	4	14
 Manufacturer#3	almond antique olive coral navajo	45	5	5	19
-Manufacturer#4	almond antique gainsboro frosted violet	10	5	5	10
-Manufacturer#4	almond antique violet mint lemon	39	5	5	10
-Manufacturer#4	almond aquamarine floral ivory bisque	27	5	5	10
-Manufacturer#4	almond aquamarine yellow dodger mint	7	5	5	39
+Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	10
+Manufacturer#4	almond antique violet mint lemon	39	2	2	10
+Manufacturer#4	almond aquamarine floral ivory bisque	27	3	3	10
+Manufacturer#4	almond aquamarine yellow dodger mint	7	4	4	39
 Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	27
-Manufacturer#5	almond antique blue firebrick mint	31	5	5	31
-Manufacturer#5	almond antique medium spring khaki	6	5	5	31
-Manufacturer#5	almond antique sky peru orange	2	5	5	31
-Manufacturer#5	almond aquamarine dodger light gainsboro	46	5	5	6
+Manufacturer#5	almond antique blue firebrick mint	31	1	1	31
+Manufacturer#5	almond antique medium spring khaki	6	2	2	31
+Manufacturer#5	almond antique sky peru orange	2	3	3	31
+Manufacturer#5	almond aquamarine dodger light gainsboro	46	4	4	6
 Manufacturer#5	almond azure blanched chiffon midnight	23	5	5	2
 PREHOOK: query: -- 18. testUDAFs
 select  p_mfgr,p_name, p_size, 
@@ -969,7 +969,7 @@ PREHOOK: query: -- 21. testDISTs
 select  p_mfgr,p_name, p_size, 
 histogram_numeric(p_retailprice, 5) over w1 as hist, 
 percentile(p_partkey, 0.5) over w1 as per,
-row_number() over(distribute by p_mfgr sort by p_mfgr) as rn
+row_number() over(distribute by p_mfgr sort by p_name) as rn
 from part
 window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following)
 PREHOOK: type: QUERY
@@ -979,15 +979,15 @@ POSTHOOK: query: -- 21. testDISTs
 select  p_mfgr,p_name, p_size, 
 histogram_numeric(p_retailprice, 5) over w1 as hist, 
 percentile(p_partkey, 0.5) over w1 as per,
-row_number() over(distribute by p_mfgr sort by p_mfgr) as rn
+row_number() over(distribute by p_mfgr sort by p_name) as rn
 from part
 window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	2	[{"x":1173.15,"y":2.0},{"x":1602.59,"y":1.0},{"x":1753.76,"y":1.0}]	115872.0	1
-Manufacturer#1	almond antique chartreuse lavender yellow	34	[{"x":1173.15,"y":2.0},{"x":1414.42,"y":1.0},{"x":1602.59,"y":1.0},{"x":1753.76,"y":1.0}]	110592.0	2
-Manufacturer#1	almond antique burnished rose metallic	2	[{"x":1173.15,"y":2.0},{"x":1753.76,"y":1.0}]	121152.0	3
+Manufacturer#1	almond antique burnished rose metallic	2	[{"x":1173.15,"y":2.0},{"x":1753.76,"y":1.0}]	121152.0	1
+Manufacturer#1	almond antique burnished rose metallic	2	[{"x":1173.15,"y":2.0},{"x":1602.59,"y":1.0},{"x":1753.76,"y":1.0}]	115872.0	2
+Manufacturer#1	almond antique chartreuse lavender yellow	34	[{"x":1173.15,"y":2.0},{"x":1414.42,"y":1.0},{"x":1602.59,"y":1.0},{"x":1753.76,"y":1.0}]	110592.0	3
 Manufacturer#1	almond antique salmon chartreuse burlywood	6	[{"x":1173.15,"y":1.0},{"x":1414.42,"y":1.0},{"x":1602.59,"y":1.0},{"x":1632.66,"y":1.0},{"x":1753.76,"y":1.0}]	86428.0	4
 Manufacturer#1	almond aquamarine burnished black steel	28	[{"x":1414.42,"y":1.0},{"x":1602.59,"y":1.0},{"x":1632.66,"y":1.0},{"x":1753.76,"y":1.0}]	86098.0	5
 Manufacturer#1	almond aquamarine pink moccasin thistle	42	[{"x":1414.42,"y":1.0},{"x":1602.59,"y":1.0},{"x":1632.66,"y":1.0}]	86428.0	6
@@ -996,9 +996,9 @@ Manufacturer#2	almond antique violet tur
 Manufacturer#2	almond aquamarine midnight light salmon	2	[{"x":1690.68,"y":1.0},{"x":1698.66,"y":1.0},{"x":1701.6,"y":1.0},{"x":1800.7,"y":1.0},{"x":2031.98,"y":1.0}]	146985.0	3
 Manufacturer#2	almond aquamarine rose maroon antique	25	[{"x":1698.66,"y":1.0},{"x":1701.6,"y":1.0},{"x":1800.7,"y":1.0},{"x":2031.98,"y":1.0}]	169347.0	4
 Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	[{"x":1698.66,"y":1.0},{"x":1701.6,"y":1.0},{"x":2031.98,"y":1.0}]	146985.0	5
-Manufacturer#3	almond antique metallic orange dim	19	[{"x":1190.27,"y":1.0},{"x":1337.29,"y":1.0},{"x":1410.39,"y":1.0},{"x":1671.68,"y":1.0},{"x":1922.98,"y":1.0}]	90681.0	1
-Manufacturer#3	almond antique chartreuse khaki white	17	[{"x":1190.27,"y":1.0},{"x":1410.39,"y":1.0},{"x":1671.68,"y":1.0}]	90681.0	2
-Manufacturer#3	almond antique forest lavender goldenrod	14	[{"x":1190.27,"y":1.0},{"x":1410.39,"y":1.0},{"x":1671.68,"y":1.0},{"x":1922.98,"y":1.0}]	65831.5	3
+Manufacturer#3	almond antique chartreuse khaki white	17	[{"x":1190.27,"y":1.0},{"x":1410.39,"y":1.0},{"x":1671.68,"y":1.0}]	90681.0	1
+Manufacturer#3	almond antique forest lavender goldenrod	14	[{"x":1190.27,"y":1.0},{"x":1410.39,"y":1.0},{"x":1671.68,"y":1.0},{"x":1922.98,"y":1.0}]	65831.5	2
+Manufacturer#3	almond antique metallic orange dim	19	[{"x":1190.27,"y":1.0},{"x":1337.29,"y":1.0},{"x":1410.39,"y":1.0},{"x":1671.68,"y":1.0},{"x":1922.98,"y":1.0}]	90681.0	3
 Manufacturer#3	almond antique misty red olive	1	[{"x":1190.27,"y":1.0},{"x":1337.29,"y":1.0},{"x":1410.39,"y":1.0},{"x":1922.98,"y":1.0}]	76690.0	4
 Manufacturer#3	almond antique olive coral navajo	45	[{"x":1337.29,"y":1.0},{"x":1410.39,"y":1.0},{"x":1922.98,"y":1.0}]	112398.0	5
 Manufacturer#4	almond antique gainsboro frosted violet	10	[{"x":1206.26,"y":1.0},{"x":1375.42,"y":1.0},{"x":1620.67,"y":1.0}]	48427.0	1
@@ -1014,63 +1014,71 @@ Manufacturer#5	almond azure blanched chi
 PREHOOK: query: -- 22. testViewAsTableInputWithWindowing
 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
 POSTHOOK: query: -- 22. testViewAsTableInputWithWindowing
 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
 POSTHOOK: Output: default@mfgr_price_view
-PREHOOK: query: select p_mfgr, p_brand, s, 
-sum(s) over w1  as s1
+PREHOOK: query: select * 
+from (
+select p_mfgr, p_brand, s, 
+round(sum(s),2) over w1  as s1
 from mfgr_price_view 
-window w1 as (distribute by p_mfgr sort by p_mfgr rows between 2 preceding and current row)
+window w1 as (distribute by p_mfgr sort by p_mfgr )
+) sq
+order by p_mfgr, p_brand
 PREHOOK: type: QUERY
 PREHOOK: Input: default@mfgr_price_view
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
-POSTHOOK: query: select p_mfgr, p_brand, s, 
-sum(s) over w1  as s1
+POSTHOOK: query: select * 
+from (
+select p_mfgr, p_brand, s, 
+round(sum(s),2) over w1  as s1
 from mfgr_price_view 
-window w1 as (distribute by p_mfgr sort by p_mfgr rows between 2 preceding and current row)
+window w1 as (distribute by p_mfgr sort by p_mfgr )
+) sq
+order by p_mfgr, p_brand
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@mfgr_price_view
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
-Manufacturer#1	Brand#14	2346.3	2346.3
-Manufacturer#1	Brand#12	4800.84	7147.14
+Manufacturer#1	Brand#12	4800.84	8749.73
+Manufacturer#1	Brand#14	2346.3	8749.73
 Manufacturer#1	Brand#15	1602.59	8749.73
-Manufacturer#2	Brand#22	3491.38	3491.38
-Manufacturer#2	Brand#23	2031.98	5523.360000000001
-Manufacturer#2	Brand#24	1698.66	7222.02
-Manufacturer#2	Brand#25	1701.6	5432.24
-Manufacturer#3	Brand#32	3333.37	3333.37
-Manufacturer#3	Brand#31	1671.68	5005.05
-Manufacturer#3	Brand#34	1337.29	6342.34
-Manufacturer#3	Brand#35	1190.27	4199.24
-Manufacturer#4	Brand#41	4755.9400000000005	4755.9400000000005
-Manufacturer#4	Brand#42	2581.6800000000003	7337.620000000001
-Manufacturer#5	Brand#51	1611.66	1611.66
-Manufacturer#5	Brand#52	3254.17	4865.83
+Manufacturer#2	Brand#22	3491.38	8923.62
+Manufacturer#2	Brand#23	2031.98	8923.62
+Manufacturer#2	Brand#24	1698.66	8923.62
+Manufacturer#2	Brand#25	1701.6	8923.62
+Manufacturer#3	Brand#31	1671.68	7532.61
+Manufacturer#3	Brand#32	3333.37	7532.61
+Manufacturer#3	Brand#34	1337.29	7532.61
+Manufacturer#3	Brand#35	1190.27	7532.61
+Manufacturer#4	Brand#41	4755.94	7337.62
+Manufacturer#4	Brand#42	2581.68	7337.62
+Manufacturer#5	Brand#51	1611.66	7672.66
+Manufacturer#5	Brand#52	3254.17	7672.66
 Manufacturer#5	Brand#53	2806.83	7672.66
 PREHOOK: query: -- 23. testCreateViewWithWindowingQuery
 create view IF NOT EXISTS mfgr_brand_price_view as 
 select p_mfgr, p_brand, 
 sum(p_retailprice) over w1  as s
 from part 
-window w1 as (distribute by p_mfgr sort by p_mfgr rows between 2 preceding and current row)
+window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and current row)
 PREHOOK: type: CREATEVIEW
 POSTHOOK: query: -- 23. testCreateViewWithWindowingQuery
 create view IF NOT EXISTS mfgr_brand_price_view as 
 select p_mfgr, p_brand, 
 sum(p_retailprice) over w1  as s
 from part 
-window w1 as (distribute by p_mfgr sort by p_mfgr rows between 2 preceding and current row)
+window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and current row)
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@mfgr_brand_price_view
 PREHOOK: query: select * from mfgr_brand_price_view
@@ -1084,21 +1092,21 @@ POSTHOOK: Input: default@mfgr_brand_pric
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
 Manufacturer#1	Brand#14	1173.15
-Manufacturer#1	Brand#12	2926.91
-Manufacturer#1	Brand#14	4100.0599999999995
+Manufacturer#1	Brand#14	2346.3
+Manufacturer#1	Brand#12	4100.06
 Manufacturer#1	Brand#15	4529.5
-Manufacturer#1	Brand#12	4190.16
+Manufacturer#1	Brand#12	4770.77
 Manufacturer#1	Brand#12	4649.67
 Manufacturer#2	Brand#22	1690.68
 Manufacturer#2	Brand#22	3491.38
 Manufacturer#2	Brand#23	5523.360000000001
 Manufacturer#2	Brand#24	5531.34
 Manufacturer#2	Brand#25	5432.24
-Manufacturer#3	Brand#32	1410.39
-Manufacturer#3	Brand#31	3082.07
-Manufacturer#3	Brand#35	4272.34
-Manufacturer#3	Brand#32	4784.93
-Manufacturer#3	Brand#34	4450.54
+Manufacturer#3	Brand#31	1671.68
+Manufacturer#3	Brand#35	2861.95
+Manufacturer#3	Brand#32	4272.34
+Manufacturer#3	Brand#32	4523.639999999999
+Manufacturer#3	Brand#34	4670.66
 Manufacturer#4	Brand#41	1620.67
 Manufacturer#4	Brand#42	2996.09
 Manufacturer#4	Brand#42	4202.35
@@ -1114,7 +1122,7 @@ select p_mfgr, p_name, 
 lv_col, p_size, sum(p_size) over w1   as s
 from (select p_mfgr, p_name, p_size, array(1,2,3) arr from part) p 
 lateral view explode(arr) part_lv as lv_col
-window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and current row)
+window w1 as (distribute by p_mfgr sort by p_size, lv_col rows between 2 preceding and current row)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
@@ -1123,88 +1131,88 @@ select p_mfgr, p_name, 
 lv_col, p_size, sum(p_size) over w1   as s
 from (select p_mfgr, p_name, p_size, array(1,2,3) arr from part) p 
 lateral view explode(arr) part_lv as lv_col
-window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and current row)
+window w1 as (distribute by p_mfgr sort by p_size, lv_col rows between 2 preceding and current row)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	2	2	2
+Manufacturer#1	almond antique burnished rose metallic	1	2	2
 Manufacturer#1	almond antique burnished rose metallic	1	2	4
-Manufacturer#1	almond antique burnished rose metallic	3	2	6
-Manufacturer#1	almond antique burnished rose metallic	1	2	6
+Manufacturer#1	almond antique burnished rose metallic	2	2	6
 Manufacturer#1	almond antique burnished rose metallic	2	2	6
 Manufacturer#1	almond antique burnished rose metallic	3	2	6
-Manufacturer#1	almond antique chartreuse lavender yellow	1	34	38
-Manufacturer#1	almond antique chartreuse lavender yellow	2	34	70
-Manufacturer#1	almond antique chartreuse lavender yellow	3	34	102
-Manufacturer#1	almond antique salmon chartreuse burlywood	1	6	74
-Manufacturer#1	almond antique salmon chartreuse burlywood	2	6	46
+Manufacturer#1	almond antique burnished rose metallic	3	2	6
+Manufacturer#1	almond antique salmon chartreuse burlywood	1	6	10
+Manufacturer#1	almond antique salmon chartreuse burlywood	2	6	14
 Manufacturer#1	almond antique salmon chartreuse burlywood	3	6	18
 Manufacturer#1	almond aquamarine burnished black steel	1	28	40
 Manufacturer#1	almond aquamarine burnished black steel	2	28	62
 Manufacturer#1	almond aquamarine burnished black steel	3	28	84
-Manufacturer#1	almond aquamarine pink moccasin thistle	1	42	98
-Manufacturer#1	almond aquamarine pink moccasin thistle	2	42	112
+Manufacturer#1	almond antique chartreuse lavender yellow	1	34	90
+Manufacturer#1	almond antique chartreuse lavender yellow	2	34	96
+Manufacturer#1	almond antique chartreuse lavender yellow	3	34	102
+Manufacturer#1	almond aquamarine pink moccasin thistle	1	42	110
+Manufacturer#1	almond aquamarine pink moccasin thistle	2	42	118
 Manufacturer#1	almond aquamarine pink moccasin thistle	3	42	126
-Manufacturer#2	almond antique violet chocolate turquoise	2	14	14
-Manufacturer#2	almond antique violet chocolate turquoise	1	14	28
-Manufacturer#2	almond antique violet chocolate turquoise	3	14	42
-Manufacturer#2	almond antique violet turquoise frosted	1	40	68
-Manufacturer#2	almond antique violet turquoise frosted	2	40	94
-Manufacturer#2	almond antique violet turquoise frosted	3	40	120
-Manufacturer#2	almond aquamarine midnight light salmon	1	2	82
-Manufacturer#2	almond aquamarine midnight light salmon	2	2	44
+Manufacturer#2	almond aquamarine midnight light salmon	1	2	2
+Manufacturer#2	almond aquamarine midnight light salmon	2	2	4
 Manufacturer#2	almond aquamarine midnight light salmon	3	2	6
-Manufacturer#2	almond aquamarine rose maroon antique	1	25	29
-Manufacturer#2	almond aquamarine rose maroon antique	2	25	52
-Manufacturer#2	almond aquamarine rose maroon antique	3	25	75
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	1	18	68
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	2	18	61
+Manufacturer#2	almond antique violet chocolate turquoise	1	14	18
+Manufacturer#2	almond antique violet chocolate turquoise	2	14	30
+Manufacturer#2	almond antique violet chocolate turquoise	3	14	42
+Manufacturer#2	almond aquamarine sandy cyan gainsboro	1	18	46
+Manufacturer#2	almond aquamarine sandy cyan gainsboro	2	18	50
 Manufacturer#2	almond aquamarine sandy cyan gainsboro	3	18	54
-Manufacturer#3	almond antique chartreuse khaki white	1	17	17
-Manufacturer#3	almond antique chartreuse khaki white	2	17	34
-Manufacturer#3	almond antique chartreuse khaki white	3	17	51
-Manufacturer#3	almond antique forest lavender goldenrod	1	14	48
-Manufacturer#3	almond antique forest lavender goldenrod	2	14	45
+Manufacturer#2	almond aquamarine rose maroon antique	1	25	61
+Manufacturer#2	almond aquamarine rose maroon antique	2	25	68
+Manufacturer#2	almond aquamarine rose maroon antique	3	25	75
+Manufacturer#2	almond antique violet turquoise frosted	1	40	90
+Manufacturer#2	almond antique violet turquoise frosted	2	40	105
+Manufacturer#2	almond antique violet turquoise frosted	3	40	120
+Manufacturer#3	almond antique misty red olive	1	1	1
+Manufacturer#3	almond antique misty red olive	2	1	2
+Manufacturer#3	almond antique misty red olive	3	1	3
+Manufacturer#3	almond antique forest lavender goldenrod	1	14	16
+Manufacturer#3	almond antique forest lavender goldenrod	2	14	29
 Manufacturer#3	almond antique forest lavender goldenrod	3	14	42
-Manufacturer#3	almond antique metallic orange dim	1	19	47
-Manufacturer#3	almond antique metallic orange dim	2	19	52
+Manufacturer#3	almond antique chartreuse khaki white	1	17	45
+Manufacturer#3	almond antique chartreuse khaki white	2	17	48
+Manufacturer#3	almond antique chartreuse khaki white	3	17	51
+Manufacturer#3	almond antique metallic orange dim	1	19	53
+Manufacturer#3	almond antique metallic orange dim	2	19	55
 Manufacturer#3	almond antique metallic orange dim	3	19	57
-Manufacturer#3	almond antique misty red olive	1	1	39
-Manufacturer#3	almond antique misty red olive	2	1	21
-Manufacturer#3	almond antique misty red olive	3	1	3
-Manufacturer#3	almond antique olive coral navajo	1	45	47
-Manufacturer#3	almond antique olive coral navajo	2	45	91
+Manufacturer#3	almond antique olive coral navajo	1	45	83
+Manufacturer#3	almond antique olive coral navajo	2	45	109
 Manufacturer#3	almond antique olive coral navajo	3	45	135
-Manufacturer#4	almond antique gainsboro frosted violet	1	10	10
-Manufacturer#4	almond antique gainsboro frosted violet	2	10	20
-Manufacturer#4	almond antique gainsboro frosted violet	3	10	30
-Manufacturer#4	almond antique violet mint lemon	1	39	59
-Manufacturer#4	almond antique violet mint lemon	2	39	88
-Manufacturer#4	almond antique violet mint lemon	3	39	117
-Manufacturer#4	almond aquamarine floral ivory bisque	1	27	105
-Manufacturer#4	almond aquamarine floral ivory bisque	2	27	93
-Manufacturer#4	almond aquamarine floral ivory bisque	3	27	81
-Manufacturer#4	almond aquamarine yellow dodger mint	1	7	61
-Manufacturer#4	almond aquamarine yellow dodger mint	2	7	41
+Manufacturer#4	almond aquamarine yellow dodger mint	1	7	7
+Manufacturer#4	almond aquamarine yellow dodger mint	2	7	14
 Manufacturer#4	almond aquamarine yellow dodger mint	3	7	21
-Manufacturer#4	almond azure aquamarine papaya violet	1	12	26
-Manufacturer#4	almond azure aquamarine papaya violet	2	12	31
+Manufacturer#4	almond antique gainsboro frosted violet	1	10	24
+Manufacturer#4	almond antique gainsboro frosted violet	2	10	27
+Manufacturer#4	almond antique gainsboro frosted violet	3	10	30
+Manufacturer#4	almond azure aquamarine papaya violet	1	12	32
+Manufacturer#4	almond azure aquamarine papaya violet	2	12	34
 Manufacturer#4	almond azure aquamarine papaya violet	3	12	36
-Manufacturer#5	almond antique blue firebrick mint	2	31	31
-Manufacturer#5	almond antique blue firebrick mint	1	31	62
-Manufacturer#5	almond antique blue firebrick mint	3	31	93
-Manufacturer#5	almond antique medium spring khaki	1	6	68
-Manufacturer#5	almond antique medium spring khaki	2	6	43
-Manufacturer#5	almond antique medium spring khaki	3	6	18
-Manufacturer#5	almond antique sky peru orange	2	2	14
-Manufacturer#5	almond antique sky peru orange	1	2	10
+Manufacturer#4	almond aquamarine floral ivory bisque	1	27	51
+Manufacturer#4	almond aquamarine floral ivory bisque	2	27	66
+Manufacturer#4	almond aquamarine floral ivory bisque	3	27	81
+Manufacturer#4	almond antique violet mint lemon	1	39	93
+Manufacturer#4	almond antique violet mint lemon	2	39	105
+Manufacturer#4	almond antique violet mint lemon	3	39	117
+Manufacturer#5	almond antique sky peru orange	1	2	2
+Manufacturer#5	almond antique sky peru orange	2	2	4
 Manufacturer#5	almond antique sky peru orange	3	2	6
-Manufacturer#5	almond aquamarine dodger light gainsboro	1	46	50
-Manufacturer#5	almond aquamarine dodger light gainsboro	2	46	94
-Manufacturer#5	almond aquamarine dodger light gainsboro	3	46	138
-Manufacturer#5	almond azure blanched chiffon midnight	1	23	115
-Manufacturer#5	almond azure blanched chiffon midnight	2	23	92
+Manufacturer#5	almond antique medium spring khaki	1	6	10
+Manufacturer#5	almond antique medium spring khaki	2	6	14
+Manufacturer#5	almond antique medium spring khaki	3	6	18
+Manufacturer#5	almond azure blanched chiffon midnight	1	23	35
+Manufacturer#5	almond azure blanched chiffon midnight	2	23	52
 Manufacturer#5	almond azure blanched chiffon midnight	3	23	69
+Manufacturer#5	almond antique blue firebrick mint	1	31	77
+Manufacturer#5	almond antique blue firebrick mint	2	31	85
+Manufacturer#5	almond antique blue firebrick mint	3	31	93
+Manufacturer#5	almond aquamarine dodger light gainsboro	1	46	108
+Manufacturer#5	almond aquamarine dodger light gainsboro	2	46	123
+Manufacturer#5	almond aquamarine dodger light gainsboro	3	46	138
 PREHOOK: query: -- 25. testMultipleInserts3SWQs
 CREATE TABLE part_1( 
 p_mfgr STRING, 
@@ -1230,8 +1238,7 @@ p_name STRING, 
 p_size INT, 
 r INT, 
 dr INT, 
-cud INT, 
-s1 DOUBLE, 
+cud INT,  
 s2 DOUBLE, 
 fv1 INT)
 PREHOOK: type: CREATETABLE
@@ -1241,8 +1248,7 @@ p_name STRING, 
 p_size INT, 
 r INT, 
 dr INT, 
-cud INT, 
-s1 DOUBLE, 
+cud INT,  
 s2 DOUBLE, 
 fv1 INT)
 POSTHOOK: type: CREATETABLE
@@ -1272,17 +1278,16 @@ dense_rank() over(distribute by p_mfgr s
 sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row)  as s
 INSERT OVERWRITE TABLE part_2 
 select  p_mfgr,p_name, p_size,  
-rank() over(distribute by p_mfgr sort by p_mfgr) as r, 
-dense_rank() over(distribute by p_mfgr sort by p_mfgr) as dr, 
-cume_dist() over(distribute by p_mfgr sort by p_mfgr) as cud, 
-sum(p_size) over (distribute by p_mfgr sort by p_mfgr, p_name rows between unbounded preceding and current row) as s1, 
-sum(p_size) over (distribute by p_mfgr sort by p_size range between 5 preceding and current row) as s2, 
+rank() over(distribute by p_mfgr sort by p_name) as r, 
+dense_rank() over(distribute by p_mfgr sort by p_name) as dr, 
+cume_dist() over(distribute by p_mfgr sort by p_name) as cud, 
+round(sum(p_size),1) over (distribute by p_mfgr sort by p_size range between 5 preceding and current row) as s2, 
 first_value(p_size) over w1  as fv1
 window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) 
 INSERT OVERWRITE TABLE part_3 
 select  p_mfgr,p_name, p_size,  
-count(*) over(distribute by p_mfgr sort by p_mfgr) as c, 
-count(p_size) over(distribute by p_mfgr sort by p_mfgr) as ca, 
+count(*) over(distribute by p_mfgr sort by p_name) as c, 
+count(p_size) over(distribute by p_mfgr sort by p_name) as ca, 
 first_value(p_size) over w1  as fv
 window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following)
 PREHOOK: type: QUERY
@@ -1298,17 +1303,16 @@ dense_rank() over(distribute by p_mfgr s
 sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row)  as s
 INSERT OVERWRITE TABLE part_2 
 select  p_mfgr,p_name, p_size,  
-rank() over(distribute by p_mfgr sort by p_mfgr) as r, 
-dense_rank() over(distribute by p_mfgr sort by p_mfgr) as dr, 
-cume_dist() over(distribute by p_mfgr sort by p_mfgr) as cud, 
-sum(p_size) over (distribute by p_mfgr sort by p_mfgr, p_name rows between unbounded preceding and current row) as s1, 
-sum(p_size) over (distribute by p_mfgr sort by p_size range between 5 preceding and current row) as s2, 
+rank() over(distribute by p_mfgr sort by p_name) as r, 
+dense_rank() over(distribute by p_mfgr sort by p_name) as dr, 
+cume_dist() over(distribute by p_mfgr sort by p_name) as cud, 
+round(sum(p_size),1) over (distribute by p_mfgr sort by p_size range between 5 preceding and current row) as s2, 
 first_value(p_size) over w1  as fv1
 window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following) 
 INSERT OVERWRITE TABLE part_3 
 select  p_mfgr,p_name, p_size,  
-count(*) over(distribute by p_mfgr sort by p_mfgr) as c, 
-count(p_size) over(distribute by p_mfgr sort by p_mfgr) as ca, 
+count(*) over(distribute by p_mfgr sort by p_name) as c, 
+count(p_size) over(distribute by p_mfgr sort by p_name) as ca, 
 first_value(p_size) over w1  as fv
 window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following)
 POSTHOOK: type: QUERY
@@ -1329,7 +1333,6 @@ POSTHOOK: Lineage: part_2.p_mfgr SCRIPT 
 POSTHOOK: Lineage: part_2.p_name SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_2.p_size SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_2.r SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-POSTHOOK: Lineage: part_2.s1 SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_2.s2 SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_3.c SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_3.ca SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
@@ -1358,7 +1361,6 @@ POSTHOOK: Lineage: part_2.p_mfgr SCRIPT 
 POSTHOOK: Lineage: part_2.p_name SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_2.p_size SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_2.r SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-POSTHOOK: Lineage: part_2.s1 SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_2.s2 SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_3.c SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_3.ca SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
@@ -1413,7 +1415,6 @@ POSTHOOK: Lineage: part_2.p_mfgr SCRIPT 
 POSTHOOK: Lineage: part_2.p_name SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_2.p_size SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_2.r SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-POSTHOOK: Lineage: part_2.s1 SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_2.s2 SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_3.c SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_3.ca SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
@@ -1421,32 +1422,32 @@ POSTHOOK: Lineage: part_3.fv SCRIPT [(pa
 POSTHOOK: Lineage: part_3.p_mfgr SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_3.p_name SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_3.p_size SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-Manufacturer#1	almond antique burnished rose metallic	2	1	1	1	4.0	4.0	2
-Manufacturer#1	almond antique burnished rose metallic	2	1	1	1	2.0	4.0	2
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	1	1	1	44.0	10.0	2
-Manufacturer#1	almond aquamarine burnished black steel	28	1	1	1	72.0	28.0	34
-Manufacturer#1	almond antique chartreuse lavender yellow	34	1	1	1	38.0	34.0	2
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	1	1	1	114.0	42.0	6
-Manufacturer#2	almond aquamarine midnight light salmon	2	1	1	1	56.0	2.0	14
-Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	1	14.0	14.0	14
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	1	1	1	99.0	32.0	2
-Manufacturer#2	almond aquamarine rose maroon antique	25	1	1	1	81.0	25.0	40
-Manufacturer#2	almond antique violet turquoise frosted	40	1	1	1	54.0	40.0	14
-Manufacturer#3	almond antique misty red olive	1	1	1	1	51.0	1.0	14
-Manufacturer#3	almond antique forest lavender goldenrod	14	1	1	1	31.0	14.0	17
-Manufacturer#3	almond antique chartreuse khaki white	17	1	1	1	17.0	31.0	17
-Manufacturer#3	almond antique metallic orange dim	19	1	1	1	50.0	50.0	17
-Manufacturer#3	almond antique olive coral navajo	45	1	1	1	96.0	45.0	19
-Manufacturer#4	almond aquamarine yellow dodger mint	7	1	1	1	83.0	7.0	39
-Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	1	10.0	17.0	10
-Manufacturer#4	almond azure aquamarine papaya violet	12	1	1	1	95.0	29.0	27
-Manufacturer#4	almond aquamarine floral ivory bisque	27	1	1	1	76.0	27.0	10
-Manufacturer#4	almond antique violet mint lemon	39	1	1	1	49.0	39.0	10
-Manufacturer#5	almond antique sky peru orange	2	1	1	1	39.0	2.0	31
-Manufacturer#5	almond antique medium spring khaki	6	1	1	1	37.0	8.0	31
-Manufacturer#5	almond azure blanched chiffon midnight	23	1	1	1	108.0	23.0	2
-Manufacturer#5	almond antique blue firebrick mint	31	1	1	1	31.0	31.0	31
-Manufacturer#5	almond aquamarine dodger light gainsboro	46	1	1	1	85.0	46.0	6
+Manufacturer#1	almond antique burnished rose metallic	2	1	1	0	4.0	2
+Manufacturer#1	almond antique burnished rose metallic	2	1	1	0	4.0	2
+Manufacturer#1	almond antique chartreuse lavender yellow	34	3	2	0	34.0	2
+Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	3	0	10.0	2
+Manufacturer#1	almond aquamarine burnished black steel	28	5	4	0	28.0	34
+Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	5	1	42.0	6
+Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	0	14.0	14
+Manufacturer#2	almond antique violet turquoise frosted	40	2	2	0	40.0	14
+Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	0	2.0	14
+Manufacturer#2	almond aquamarine rose maroon antique	25	4	4	0	25.0	40
+Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	5	5	1	32.0	2
+Manufacturer#3	almond antique chartreuse khaki white	17	1	1	0	31.0	17
+Manufacturer#3	almond antique forest lavender goldenrod	14	2	2	0	14.0	17
+Manufacturer#3	almond antique metallic orange dim	19	3	3	0	50.0	17
+Manufacturer#3	almond antique misty red olive	1	4	4	0	1.0	14
+Manufacturer#3	almond antique olive coral navajo	45	5	5	1	45.0	19
+Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	0	17.0	10
+Manufacturer#4	almond antique violet mint lemon	39	2	2	0	39.0	10
+Manufacturer#4	almond aquamarine floral ivory bisque	27	3	3	0	27.0	10
+Manufacturer#4	almond aquamarine yellow dodger mint	7	4	4	0	7.0	39
+Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	1	29.0	27
+Manufacturer#5	almond antique blue firebrick mint	31	1	1	0	31.0	31
+Manufacturer#5	almond antique medium spring khaki	6	2	2	0	8.0	31
+Manufacturer#5	almond antique sky peru orange	2	3	3	0	2.0	31
+Manufacturer#5	almond aquamarine dodger light gainsboro	46	4	4	0	46.0	6
+Manufacturer#5	almond azure blanched chiffon midnight	23	5	5	1	23.0	2
 PREHOOK: query: select * from part_3
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_3
@@ -1468,7 +1469,6 @@ POSTHOOK: Lineage: part_2.p_mfgr SCRIPT 
 POSTHOOK: Lineage: part_2.p_name SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_2.p_size SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_2.r SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-POSTHOOK: Lineage: part_2.s1 SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_2.s2 SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_3.c SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_3.ca SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
@@ -1476,31 +1476,31 @@ POSTHOOK: Lineage: part_3.fv SCRIPT [(pa
 POSTHOOK: Lineage: part_3.p_mfgr SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_3.p_name SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_3.p_size SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-Manufacturer#1	almond antique burnished rose metallic	2	6	6	2
-Manufacturer#1	almond antique burnished rose metallic	2	6	6	2
-Manufacturer#1	almond antique chartreuse lavender yellow	34	6	6	2
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	6	6	2
-Manufacturer#1	almond aquamarine burnished black steel	28	6	6	34
+Manufacturer#1	almond antique burnished rose metallic	2	2	2	2
+Manufacturer#1	almond antique burnished rose metallic	2	2	2	2
+Manufacturer#1	almond antique chartreuse lavender yellow	34	3	3	2
+Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	4	2
+Manufacturer#1	almond aquamarine burnished black steel	28	5	5	34
 Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	6	6
-Manufacturer#2	almond antique violet chocolate turquoise	14	5	5	14
-Manufacturer#2	almond antique violet turquoise frosted	40	5	5	14
-Manufacturer#2	almond aquamarine midnight light salmon	2	5	5	14
-Manufacturer#2	almond aquamarine rose maroon antique	25	5	5	40
+Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	14
+Manufacturer#2	almond antique violet turquoise frosted	40	2	2	14
+Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	14
+Manufacturer#2	almond aquamarine rose maroon antique	25	4	4	40
 Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	5	5	2
-Manufacturer#3	almond antique chartreuse khaki white	17	5	5	17
-Manufacturer#3	almond antique forest lavender goldenrod	14	5	5	17
-Manufacturer#3	almond antique metallic orange dim	19	5	5	17
-Manufacturer#3	almond antique misty red olive	1	5	5	14
+Manufacturer#3	almond antique chartreuse khaki white	17	1	1	17
+Manufacturer#3	almond antique forest lavender goldenrod	14	2	2	17
+Manufacturer#3	almond antique metallic orange dim	19	3	3	17
+Manufacturer#3	almond antique misty red olive	1	4	4	14
 Manufacturer#3	almond antique olive coral navajo	45	5	5	19
-Manufacturer#4	almond antique gainsboro frosted violet	10	5	5	10
-Manufacturer#4	almond antique violet mint lemon	39	5	5	10
-Manufacturer#4	almond aquamarine floral ivory bisque	27	5	5	10
-Manufacturer#4	almond aquamarine yellow dodger mint	7	5	5	39
+Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	10
+Manufacturer#4	almond antique violet mint lemon	39	2	2	10
+Manufacturer#4	almond aquamarine floral ivory bisque	27	3	3	10
+Manufacturer#4	almond aquamarine yellow dodger mint	7	4	4	39
 Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	27
-Manufacturer#5	almond antique blue firebrick mint	31	5	5	31
-Manufacturer#5	almond antique medium spring khaki	6	5	5	31
-Manufacturer#5	almond antique sky peru orange	2	5	5	31
-Manufacturer#5	almond aquamarine dodger light gainsboro	46	5	5	6
+Manufacturer#5	almond antique blue firebrick mint	31	1	1	31
+Manufacturer#5	almond antique medium spring khaki	6	2	2	31
+Manufacturer#5	almond antique sky peru orange	2	3	3	31
+Manufacturer#5	almond aquamarine dodger light gainsboro	46	4	4	6
 Manufacturer#5	almond azure blanched chiffon midnight	23	5	5	2
 PREHOOK: query: -- 26. testGroupByHavingWithSWQAndAlias
 select p_mfgr, p_name, p_size, min(p_retailprice) as mi,
@@ -1537,7 +1537,6 @@ POSTHOOK: Lineage: part_2.p_mfgr SCRIPT 
 POSTHOOK: Lineage: part_2.p_name SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_2.p_size SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]

[... 628 lines stripped ...]


Mime
View raw message