hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From amareshw...@apache.org
Subject svn commit: r1476039 [19/22] - in /hive/branches/HIVE-4115: ./ beeline/ beeline/src/java/org/apache/hive/beeline/ bin/ builtins/ cli/ common/src/java/org/apache/hadoop/hive/conf/ conf/ data/files/ eclipse-templates/ hbase-handler/ hbase-handler/src/jav...
Date Fri, 26 Apr 2013 04:59:58 GMT
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ptf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ptf.q.out?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ptf.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ptf.q.out Fri Apr 26 04:59:50 2013
@@ -833,7 +833,6 @@ PREHOOK: query: CREATE TABLE part_5( 
 p_mfgr STRING, 
 p_name STRING, 
 p_size INT, 
-s1 INT, 
 s2 INT, 
 r INT, 
 dr INT, 
@@ -844,7 +843,6 @@ POSTHOOK: query: CREATE TABLE part_5( 
 p_mfgr STRING, 
 p_name STRING, 
 p_size INT, 
-s1 INT, 
 s2 INT, 
 r INT, 
 dr INT, 
@@ -860,8 +858,7 @@ rank() over (distribute by p_mfgr sort b
 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  
 INSERT OVERWRITE TABLE part_5 select  p_mfgr,p_name, p_size,  
-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,
+round(sum(p_size),1) 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_mfgr, p_name) as r, 
 dense_rank() over (distribute by p_mfgr sort by p_mfgr, p_name) as dr, 
 cume_dist() over (distribute by p_mfgr sort by p_mfgr, p_name) as cud, 
@@ -879,8 +876,7 @@ rank() over (distribute by p_mfgr sort b
 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  
 INSERT OVERWRITE TABLE part_5 select  p_mfgr,p_name, p_size,  
-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,
+round(sum(p_size),1) 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_mfgr, p_name) as r, 
 dense_rank() over (distribute by p_mfgr sort by p_mfgr, p_name) as dr, 
 cume_dist() over (distribute by p_mfgr sort by p_mfgr, p_name) as cud, 
@@ -903,7 +899,6 @@ POSTHOOK: Lineage: part_5.p_mfgr SCRIPT 
 POSTHOOK: Lineage: part_5.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_5.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_5.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_5.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_5.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:), ]
 PREHOOK: query: select * from part_4
 PREHOOK: type: QUERY
@@ -926,7 +921,6 @@ POSTHOOK: Lineage: part_5.p_mfgr SCRIPT 
 POSTHOOK: Lineage: part_5.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_5.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_5.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_5.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_5.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:), ]
 Manufacturer#1	almond antique burnished rose metallic	2	1	1	1173.15
 Manufacturer#1	almond antique burnished rose metallic	2	1	1	2346.3
@@ -975,34 +969,33 @@ POSTHOOK: Lineage: part_5.p_mfgr SCRIPT 
 POSTHOOK: Lineage: part_5.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_5.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_5.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_5.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_5.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:), ]
-Manufacturer#1	almond antique burnished rose metallic	2	4	4	1	1	0.3333333333333333	2
-Manufacturer#1	almond antique burnished rose metallic	2	2	4	1	1	0.3333333333333333	2
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	44	10	4	3	0.6666666666666666	2
-Manufacturer#1	almond aquamarine burnished black steel	28	72	28	5	4	0.8333333333333334	34
-Manufacturer#1	almond antique chartreuse lavender yellow	34	38	34	3	2	0.5	2
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	114	42	6	5	1.0	6
-Manufacturer#2	almond aquamarine midnight light salmon	2	56	2	3	3	0.6	14
-Manufacturer#2	almond antique violet chocolate turquoise	14	14	14	1	1	0.2	14
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	99	32	5	5	1.0	2
-Manufacturer#2	almond aquamarine rose maroon antique	25	81	25	4	4	0.8	40
-Manufacturer#2	almond antique violet turquoise frosted	40	54	40	2	2	0.4	14
-Manufacturer#3	almond antique misty red olive	1	51	1	4	4	0.8	14
-Manufacturer#3	almond antique forest lavender goldenrod	14	31	14	2	2	0.4	17
-Manufacturer#3	almond antique chartreuse khaki white	17	17	31	1	1	0.2	17
-Manufacturer#3	almond antique metallic orange dim	19	50	50	3	3	0.6	17
-Manufacturer#3	almond antique olive coral navajo	45	96	45	5	5	1.0	19
-Manufacturer#4	almond aquamarine yellow dodger mint	7	83	7	4	4	0.8	39
-Manufacturer#4	almond antique gainsboro frosted violet	10	10	17	1	1	0.2	10
-Manufacturer#4	almond azure aquamarine papaya violet	12	95	29	5	5	1.0	27
-Manufacturer#4	almond aquamarine floral ivory bisque	27	76	27	3	3	0.6	10
-Manufacturer#4	almond antique violet mint lemon	39	49	39	2	2	0.4	10
-Manufacturer#5	almond antique sky peru orange	2	39	2	3	3	0.6	31
-Manufacturer#5	almond antique medium spring khaki	6	37	8	2	2	0.4	31
-Manufacturer#5	almond azure blanched chiffon midnight	23	108	23	5	5	1.0	2
-Manufacturer#5	almond antique blue firebrick mint	31	31	31	1	1	0.2	31
-Manufacturer#5	almond aquamarine dodger light gainsboro	46	85	46	4	4	0.8	6
+Manufacturer#1	almond antique burnished rose metallic	2	4	1	1	0.3333333333333333	2
+Manufacturer#1	almond antique burnished rose metallic	2	4	1	1	0.3333333333333333	2
+Manufacturer#1	almond antique chartreuse lavender yellow	34	34	3	2	0.5	2
+Manufacturer#1	almond antique salmon chartreuse burlywood	6	10	4	3	0.6666666666666666	2
+Manufacturer#1	almond aquamarine burnished black steel	28	28	5	4	0.8333333333333334	34
+Manufacturer#1	almond aquamarine pink moccasin thistle	42	42	6	5	1.0	6
+Manufacturer#2	almond antique violet chocolate turquoise	14	14	1	1	0.2	14
+Manufacturer#2	almond antique violet turquoise frosted	40	40	2	2	0.4	14
+Manufacturer#2	almond aquamarine midnight light salmon	2	2	3	3	0.6	14
+Manufacturer#2	almond aquamarine rose maroon antique	25	25	4	4	0.8	40
+Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	32	5	5	1.0	2
+Manufacturer#3	almond antique chartreuse khaki white	17	31	1	1	0.2	17
+Manufacturer#3	almond antique forest lavender goldenrod	14	14	2	2	0.4	17
+Manufacturer#3	almond antique metallic orange dim	19	50	3	3	0.6	17
+Manufacturer#3	almond antique misty red olive	1	1	4	4	0.8	14
+Manufacturer#3	almond antique olive coral navajo	45	45	5	5	1.0	19
+Manufacturer#4	almond antique gainsboro frosted violet	10	17	1	1	0.2	10
+Manufacturer#4	almond antique violet mint lemon	39	39	2	2	0.4	10
+Manufacturer#4	almond aquamarine floral ivory bisque	27	27	3	3	0.6	10
+Manufacturer#4	almond aquamarine yellow dodger mint	7	7	4	4	0.8	39
+Manufacturer#4	almond azure aquamarine papaya violet	12	29	5	5	1.0	27
+Manufacturer#5	almond antique blue firebrick mint	31	31	1	1	0.2	31
+Manufacturer#5	almond antique medium spring khaki	6	8	2	2	0.4	31
+Manufacturer#5	almond antique sky peru orange	2	2	3	3	0.6	31
+Manufacturer#5	almond aquamarine dodger light gainsboro	46	46	4	4	0.8	6
+Manufacturer#5	almond azure blanched chiffon midnight	23	23	5	5	1.0	2
 PREHOOK: query: -- 18. testMulti2OperatorsFunctionChainWithMap
 select p_mfgr, p_name,  
 rank() over (partition by p_mfgr,p_name) as r, 
@@ -1054,7 +1047,6 @@ POSTHOOK: Lineage: part_5.p_mfgr SCRIPT 
 POSTHOOK: Lineage: part_5.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_5.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_5.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_5.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_5.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:), ]
 Manufacturer#1	almond antique burnished rose metallic	1	1	2	2
 Manufacturer#1	almond antique burnished rose metallic	1	1	2	4
@@ -1133,7 +1125,6 @@ POSTHOOK: Lineage: part_5.p_mfgr SCRIPT 
 POSTHOOK: Lineage: part_5.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_5.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_5.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_5.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_5.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:), ]
 Manufacturer#1	almond antique burnished rose metallic	1	1	2	2
 Manufacturer#1	almond antique burnished rose metallic	1	1	2	4
@@ -1208,7 +1199,6 @@ POSTHOOK: Lineage: part_5.p_mfgr SCRIPT 
 POSTHOOK: Lineage: part_5.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_5.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_5.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_5.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_5.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:), ]
 Manufacturer#1	almond antique burnished rose metallic	1	1	2	4
 Manufacturer#1	almond antique burnished rose metallic	1	1	2	4
@@ -1287,7 +1277,6 @@ POSTHOOK: Lineage: part_5.p_mfgr SCRIPT 
 POSTHOOK: Lineage: part_5.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_5.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_5.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_5.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_5.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:), ]
 Manufacturer#1	almond antique burnished rose metallic	1	1	2	2
 Manufacturer#1	almond antique burnished rose metallic	1	1	2	4
@@ -1364,7 +1353,6 @@ POSTHOOK: Lineage: part_5.p_mfgr SCRIPT 
 POSTHOOK: Lineage: part_5.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_5.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_5.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_5.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_5.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:), ]
 Manufacturer#1	almond antique burnished rose metallic	1	1	2	2	2
 Manufacturer#1	almond antique burnished rose metallic	1	1	2	4	4
@@ -1394,11 +1382,11 @@ Manufacturer#5	almond aquamarine dodger 
 Manufacturer#5	almond azure blanched chiffon midnight	1	1	23	23	23
 PREHOOK: query: -- 23. testMultiOperatorChainWithDiffPartitionForWindow2
 select p_mfgr, p_name,  
-rank() over (partition by p_mfgr order by p_mfgr) as r, 
-dense_rank() over (partition by p_mfgr order by p_mfgr) as dr, 
+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, 
 p_size, 
-sum(p_size) over (partition by p_mfgr order by p_mfgr rows between unbounded preceding and current row) as s1, 
-sum(p_size) over (partition by p_mfgr order by p_mfgr rows between unbounded preceding and current row)  as s2
+sum(p_size) over (partition by p_mfgr order by p_name range between unbounded preceding and current row) as s1, 
+sum(p_size) over (partition by p_mfgr order by p_name range between unbounded preceding and current row)  as s2
 from noopwithmap(on 
         noop(on 
               noop(on part 
@@ -1410,11 +1398,11 @@ PREHOOK: Input: default@part
 #### A masked pattern was here ####
 POSTHOOK: query: -- 23. testMultiOperatorChainWithDiffPartitionForWindow2
 select p_mfgr, p_name,  
-rank() over (partition by p_mfgr order by p_mfgr) as r, 
-dense_rank() over (partition by p_mfgr order by p_mfgr) as dr, 
+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, 
 p_size, 
-sum(p_size) over (partition by p_mfgr order by p_mfgr rows between unbounded preceding and current row) as s1, 
-sum(p_size) over (partition by p_mfgr order by p_mfgr rows between unbounded preceding and current row)  as s2
+sum(p_size) over (partition by p_mfgr order by p_name range between unbounded preceding and current row) as s1, 
+sum(p_size) over (partition by p_mfgr order by p_name range between unbounded preceding and current row)  as s2
 from noopwithmap(on 
         noop(on 
               noop(on part 
@@ -1437,31 +1425,30 @@ POSTHOOK: Lineage: part_5.p_mfgr SCRIPT 
 POSTHOOK: Lineage: part_5.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_5.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_5.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_5.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_5.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:), ]
-Manufacturer#1	almond antique burnished rose metallic	1	1	2	2	2
-Manufacturer#1	almond antique chartreuse lavender yellow	1	1	34	36	36
-Manufacturer#1	almond antique burnished rose metallic	1	1	2	38	38
-Manufacturer#1	almond antique salmon chartreuse burlywood	1	1	6	44	44
-Manufacturer#1	almond aquamarine burnished black steel	1	1	28	72	72
-Manufacturer#1	almond aquamarine pink moccasin thistle	1	1	42	114	114
+Manufacturer#1	almond antique burnished rose metallic	1	1	2	4	4
+Manufacturer#1	almond antique burnished rose metallic	1	1	2	4	4
+Manufacturer#1	almond antique chartreuse lavender yellow	3	2	34	38	38
+Manufacturer#1	almond antique salmon chartreuse burlywood	4	3	6	44	44
+Manufacturer#1	almond aquamarine burnished black steel	5	4	28	72	72
+Manufacturer#1	almond aquamarine pink moccasin thistle	6	5	42	114	114
 Manufacturer#2	almond antique violet chocolate turquoise	1	1	14	14	14
-Manufacturer#2	almond antique violet turquoise frosted	1	1	40	54	54
-Manufacturer#2	almond aquamarine midnight light salmon	1	1	2	56	56
-Manufacturer#2	almond aquamarine rose maroon antique	1	1	25	81	81
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	1	1	18	99	99
-Manufacturer#3	almond antique metallic orange dim	1	1	19	19	19
-Manufacturer#3	almond antique chartreuse khaki white	1	1	17	36	36
-Manufacturer#3	almond antique forest lavender goldenrod	1	1	14	50	50
-Manufacturer#3	almond antique misty red olive	1	1	1	51	51
-Manufacturer#3	almond antique olive coral navajo	1	1	45	96	96
+Manufacturer#2	almond antique violet turquoise frosted	2	2	40	54	54
+Manufacturer#2	almond aquamarine midnight light salmon	3	3	2	56	56
+Manufacturer#2	almond aquamarine rose maroon antique	4	4	25	81	81
+Manufacturer#2	almond aquamarine sandy cyan gainsboro	5	5	18	99	99
+Manufacturer#3	almond antique chartreuse khaki white	1	1	17	17	17
+Manufacturer#3	almond antique forest lavender goldenrod	2	2	14	31	31
+Manufacturer#3	almond antique metallic orange dim	3	3	19	50	50
+Manufacturer#3	almond antique misty red olive	4	4	1	51	51
+Manufacturer#3	almond antique olive coral navajo	5	5	45	96	96
 Manufacturer#4	almond antique gainsboro frosted violet	1	1	10	10	10
-Manufacturer#4	almond antique violet mint lemon	1	1	39	49	49
-Manufacturer#4	almond aquamarine floral ivory bisque	1	1	27	76	76
-Manufacturer#4	almond aquamarine yellow dodger mint	1	1	7	83	83
-Manufacturer#4	almond azure aquamarine papaya violet	1	1	12	95	95
+Manufacturer#4	almond antique violet mint lemon	2	2	39	49	49
+Manufacturer#4	almond aquamarine floral ivory bisque	3	3	27	76	76
+Manufacturer#4	almond aquamarine yellow dodger mint	4	4	7	83	83
+Manufacturer#4	almond azure aquamarine papaya violet	5	5	12	95	95
 Manufacturer#5	almond antique blue firebrick mint	1	1	31	31	31
-Manufacturer#5	almond antique medium spring khaki	1	1	6	37	37
-Manufacturer#5	almond antique sky peru orange	1	1	2	39	39
-Manufacturer#5	almond aquamarine dodger light gainsboro	1	1	46	85	85
-Manufacturer#5	almond azure blanched chiffon midnight	1	1	23	108	108
+Manufacturer#5	almond antique medium spring khaki	2	2	6	37	37
+Manufacturer#5	almond antique sky peru orange	3	3	2	39	39
+Manufacturer#5	almond aquamarine dodger light gainsboro	4	4	46	85	85
+Manufacturer#5	almond azure blanched chiffon midnight	5	5	23	108	108

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ptf_general_queries.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ptf_general_queries.q.out?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ptf_general_queries.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ptf_general_queries.q.out Fri Apr 26 04:59:50 2013
@@ -79,49 +79,49 @@ Manufacturer#4	almond azure aquamarine p
 Manufacturer#5	almond azure blanched chiffon midnight	23
 PREHOOK: query: -- 2. testUDAFsNoWindowingNoPTFNoGBY
 select p_mfgr,p_name, p_retailprice,  
-sum(p_retailprice) over(partition by p_mfgr order by p_mfgr) as s,
-min(p_retailprice) over(partition by p_mfgr order by p_mfgr) as mi,
-max(p_retailprice) over(partition by p_mfgr order by p_mfgr) as ma,
-avg(p_retailprice) over(partition by p_mfgr order by p_mfgr) as av 
+sum(p_retailprice) over(partition by p_mfgr order by p_name) as s,
+min(p_retailprice) over(partition by p_mfgr order by p_name) as mi,
+max(p_retailprice) over(partition by p_mfgr order by p_name) as ma,
+avg(p_retailprice) over(partition by p_mfgr order by p_name) as av 
 from part
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
 POSTHOOK: query: -- 2. testUDAFsNoWindowingNoPTFNoGBY
 select p_mfgr,p_name, p_retailprice,  
-sum(p_retailprice) over(partition by p_mfgr order by p_mfgr) as s,
-min(p_retailprice) over(partition by p_mfgr order by p_mfgr) as mi,
-max(p_retailprice) over(partition by p_mfgr order by p_mfgr) as ma,
-avg(p_retailprice) over(partition by p_mfgr order by p_mfgr) as av 
+sum(p_retailprice) over(partition by p_mfgr order by p_name) as s,
+min(p_retailprice) over(partition by p_mfgr order by p_name) as mi,
+max(p_retailprice) over(partition by p_mfgr order by p_name) as ma,
+avg(p_retailprice) over(partition by p_mfgr order by p_name) as av 
 from part
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	1173.15	8749.73	1173.15	1753.76	1458.2883333333332
-Manufacturer#1	almond antique chartreuse lavender yellow	1753.76	8749.73	1173.15	1753.76	1458.2883333333332
-Manufacturer#1	almond antique burnished rose metallic	1173.15	8749.73	1173.15	1753.76	1458.2883333333332
-Manufacturer#1	almond antique salmon chartreuse burlywood	1602.59	8749.73	1173.15	1753.76	1458.2883333333332
-Manufacturer#1	almond aquamarine burnished black steel	1414.42	8749.73	1173.15	1753.76	1458.2883333333332
-Manufacturer#1	almond aquamarine pink moccasin thistle	1632.66	8749.73	1173.15	1753.76	1458.2883333333332
-Manufacturer#2	almond antique violet chocolate turquoise	1690.68	8923.62	1690.68	2031.98	1784.7240000000002
-Manufacturer#2	almond antique violet turquoise frosted	1800.7	8923.62	1690.68	2031.98	1784.7240000000002
-Manufacturer#2	almond aquamarine midnight light salmon	2031.98	8923.62	1690.68	2031.98	1784.7240000000002
-Manufacturer#2	almond aquamarine rose maroon antique	1698.66	8923.62	1690.68	2031.98	1784.7240000000002
+Manufacturer#1	almond antique burnished rose metallic	1173.15	2346.3	1173.15	1173.15	1173.15
+Manufacturer#1	almond antique burnished rose metallic	1173.15	2346.3	1173.15	1173.15	1173.15
+Manufacturer#1	almond antique chartreuse lavender yellow	1753.76	4100.06	1173.15	1753.76	1366.6866666666667
+Manufacturer#1	almond antique salmon chartreuse burlywood	1602.59	5702.650000000001	1173.15	1753.76	1425.6625000000001
+Manufacturer#1	almond aquamarine burnished black steel	1414.42	7117.070000000001	1173.15	1753.76	1423.4140000000002
+Manufacturer#1	almond aquamarine pink moccasin thistle	1632.66	8749.730000000001	1173.15	1753.76	1458.2883333333336
+Manufacturer#2	almond antique violet chocolate turquoise	1690.68	1690.68	1690.68	1690.68	1690.68
+Manufacturer#2	almond antique violet turquoise frosted	1800.7	3491.38	1690.68	1800.7	1745.69
+Manufacturer#2	almond aquamarine midnight light salmon	2031.98	5523.360000000001	1690.68	2031.98	1841.1200000000001
+Manufacturer#2	almond aquamarine rose maroon antique	1698.66	7222.02	1690.68	2031.98	1805.505
 Manufacturer#2	almond aquamarine sandy cyan gainsboro	1701.6	8923.62	1690.68	2031.98	1784.7240000000002
-Manufacturer#3	almond antique metallic orange dim	1410.39	7532.61	1190.27	1922.98	1506.522
-Manufacturer#3	almond antique chartreuse khaki white	1671.68	7532.61	1190.27	1922.98	1506.522
-Manufacturer#3	almond antique forest lavender goldenrod	1190.27	7532.61	1190.27	1922.98	1506.522
-Manufacturer#3	almond antique misty red olive	1922.98	7532.61	1190.27	1922.98	1506.522
+Manufacturer#3	almond antique chartreuse khaki white	1671.68	1671.68	1671.68	1671.68	1671.68
+Manufacturer#3	almond antique forest lavender goldenrod	1190.27	2861.95	1190.27	1671.68	1430.975
+Manufacturer#3	almond antique metallic orange dim	1410.39	4272.34	1190.27	1671.68	1424.1133333333335
+Manufacturer#3	almond antique misty red olive	1922.98	6195.32	1190.27	1922.98	1548.83
 Manufacturer#3	almond antique olive coral navajo	1337.29	7532.61	1190.27	1922.98	1506.522
-Manufacturer#4	almond antique gainsboro frosted violet	1620.67	7337.620000000001	1206.26	1844.92	1467.5240000000001
-Manufacturer#4	almond antique violet mint lemon	1375.42	7337.620000000001	1206.26	1844.92	1467.5240000000001
-Manufacturer#4	almond aquamarine floral ivory bisque	1206.26	7337.620000000001	1206.26	1844.92	1467.5240000000001
-Manufacturer#4	almond aquamarine yellow dodger mint	1844.92	7337.620000000001	1206.26	1844.92	1467.5240000000001
+Manufacturer#4	almond antique gainsboro frosted violet	1620.67	1620.67	1620.67	1620.67	1620.67
+Manufacturer#4	almond antique violet mint lemon	1375.42	2996.09	1375.42	1620.67	1498.045
+Manufacturer#4	almond aquamarine floral ivory bisque	1206.26	4202.35	1206.26	1620.67	1400.7833333333335
+Manufacturer#4	almond aquamarine yellow dodger mint	1844.92	6047.27	1206.26	1844.92	1511.8175
 Manufacturer#4	almond azure aquamarine papaya violet	1290.35	7337.620000000001	1206.26	1844.92	1467.5240000000001
-Manufacturer#5	almond antique blue firebrick mint	1789.69	7672.66	1018.1	1789.69	1534.532
-Manufacturer#5	almond antique medium spring khaki	1611.66	7672.66	1018.1	1789.69	1534.532
-Manufacturer#5	almond antique sky peru orange	1788.73	7672.66	1018.1	1789.69	1534.532
-Manufacturer#5	almond aquamarine dodger light gainsboro	1018.1	7672.66	1018.1	1789.69	1534.532
+Manufacturer#5	almond antique blue firebrick mint	1789.69	1789.69	1789.69	1789.69	1789.69
+Manufacturer#5	almond antique medium spring khaki	1611.66	3401.3500000000004	1611.66	1789.69	1700.6750000000002
+Manufacturer#5	almond antique sky peru orange	1788.73	5190.08	1611.66	1789.69	1730.0266666666666
+Manufacturer#5	almond aquamarine dodger light gainsboro	1018.1	6208.18	1018.1	1789.69	1552.045
 Manufacturer#5	almond azure blanched chiffon midnight	1464.48	7672.66	1018.1	1789.69	1534.532
 PREHOOK: query: -- 3. testConstExprInSelect
 select 'tst1' as key, count(1) as value from part

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/semijoin.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/semijoin.q.out?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/semijoin.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/semijoin.q.out Fri Apr 26 04:59:50 2013
@@ -2980,3 +2980,97 @@ POSTHOOK: Input: default@t3
 16
 18
 20
+PREHOOK: query: explain select a.key from t3 a left semi join t2 b on a.value = b.value where a.key > 100
+PREHOOK: type: QUERY
+POSTHOOK: query: explain select a.key from t3 a left semi join t2 b on a.value = b.value where a.key > 100
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_LEFTSEMIJOIN (TOK_TABREF (TOK_TABNAME t3) a) (TOK_TABREF (TOK_TABNAME t2) b) (= (. (TOK_TABLE_OR_COL a) value) (. (TOK_TABLE_OR_COL b) value)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key))) (TOK_WHERE (> (. (TOK_TABLE_OR_COL a) key) 100))))
+
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Alias -> Map Operator Tree:
+        a 
+          TableScan
+            alias: a
+            Filter Operator
+              predicate:
+                  expr: (key > 100)
+                  type: boolean
+              Reduce Output Operator
+                key expressions:
+                      expr: value
+                      type: string
+                sort order: +
+                Map-reduce partition columns:
+                      expr: value
+                      type: string
+                tag: 0
+                value expressions:
+                      expr: key
+                      type: int
+        b 
+          TableScan
+            alias: b
+            Select Operator
+              expressions:
+                    expr: value
+                    type: string
+              outputColumnNames: value
+              Group By Operator
+                bucketGroup: false
+                keys:
+                      expr: value
+                      type: string
+                mode: hash
+                outputColumnNames: _col0
+                Reduce Output Operator
+                  key expressions:
+                        expr: _col0
+                        type: string
+                  sort order: +
+                  Map-reduce partition columns:
+                        expr: _col0
+                        type: string
+                  tag: 1
+      Reduce Operator Tree:
+        Join Operator
+          condition map:
+               Left Semi Join 0 to 1
+          condition expressions:
+            0 {VALUE._col0}
+            1 
+          handleSkewJoin: false
+          outputColumnNames: _col0
+          Select Operator
+            expressions:
+                  expr: _col0
+                  type: int
+            outputColumnNames: _col0
+            File Output Operator
+              compressed: false
+              GlobalTableId: 0
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+
+
+PREHOOK: query: select a.key from t3 a left semi join t2 b on a.value = b.value where a.key > 100
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t2
+PREHOOK: Input: default@t3
+#### A masked pattern was here ####
+POSTHOOK: query: select a.key from t3 a left semi join t2 b on a.value = b.value where a.key > 100
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@t3
+#### A masked pattern was here ####

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/show_functions.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/show_functions.q.out?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/show_functions.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/show_functions.q.out Fri Apr 26 04:59:50 2013
@@ -167,7 +167,6 @@ translate
 trim
 ucase
 unhex
-union_map
 unix_timestamp
 upper
 var_pop

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udtf_explode.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udtf_explode.q.out?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udtf_explode.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udtf_explode.q.out Fri Apr 26 04:59:50 2013
@@ -621,3 +621,38 @@ POSTHOOK: Input: default@src
 238	1	one
 238	2	two
 238	3	three
+PREHOOK: query: -- HIVE-4295
+SELECT BLOCK__OFFSET__INSIDE__FILE, src.key, myKey, myVal FROM src lateral view explode(map(1,'one',2,'two',3,'three')) x AS myKey,myVal LIMIT 3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: -- HIVE-4295
+SELECT BLOCK__OFFSET__INSIDE__FILE, src.key, myKey, myVal FROM src lateral view explode(map(1,'one',2,'two',3,'three')) x AS myKey,myVal LIMIT 3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+0	238	1	one
+0	238	2	two
+0	238	3	three
+PREHOOK: query: SELECT src.key, myKey, myVal FROM src lateral view explode(map(1,'one',2,'two',3,'three')) x AS myKey,myVal LIMIT 3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT src.key, myKey, myVal FROM src lateral view explode(map(1,'one',2,'two',3,'three')) x AS myKey,myVal LIMIT 3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+238	1	one
+238	2	two
+238	3	three
+PREHOOK: query: SELECT BLOCK__OFFSET__INSIDE__FILE, src.key, myKey, myVal FROM src lateral view explode(map(1,'one',2,'two',3,'three')) x AS myKey,myVal LIMIT 3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT BLOCK__OFFSET__INSIDE__FILE, src.key, myKey, myVal FROM src lateral view explode(map(1,'one',2,'two',3,'three')) x AS myKey,myVal LIMIT 3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+0	238	1	one
+0	238	2	two
+0	238	3	three

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udtf_json_tuple.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udtf_json_tuple.q.out?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udtf_json_tuple.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udtf_json_tuple.q.out Fri Apr 26 04:59:50 2013
@@ -68,21 +68,21 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: key
                 Lateral View Join Operator
-                  outputColumnNames: _col0, _col2, _col3, _col4, _col5, _col6
+                  outputColumnNames: _col0, _col4, _col5, _col6, _col7, _col8
                   Select Operator
                     expressions:
                           expr: _col0
                           type: string
-                          expr: _col2
-                          type: string
-                          expr: _col3
-                          type: string
                           expr: _col4
                           type: string
                           expr: _col5
                           type: string
                           expr: _col6
                           type: string
+                          expr: _col7
+                          type: string
+                          expr: _col8
+                          type: string
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
                     Reduce Output Operator
                       key expressions:
@@ -121,21 +121,21 @@ STAGE PLANS:
                 UDTF Operator
                   function name: json_tuple
                   Lateral View Join Operator
-                    outputColumnNames: _col0, _col2, _col3, _col4, _col5, _col6
+                    outputColumnNames: _col0, _col4, _col5, _col6, _col7, _col8
                     Select Operator
                       expressions:
                             expr: _col0
                             type: string
-                            expr: _col2
-                            type: string
-                            expr: _col3
-                            type: string
                             expr: _col4
                             type: string
                             expr: _col5
                             type: string
                             expr: _col6
                             type: string
+                            expr: _col7
+                            type: string
+                            expr: _col8
+                            type: string
                       outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
                       Reduce Output Operator
                         key expressions:
@@ -305,14 +305,14 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: key
                 Lateral View Join Operator
-                  outputColumnNames: _col0, _col2, _col3, _col4, _col5, _col6
+                  outputColumnNames: _col0, _col4, _col5, _col6, _col7, _col8
                   Select Operator
                     expressions:
                           expr: _col0
                           type: string
-                          expr: _col3
+                          expr: _col5
                           type: string
-                          expr: _col6
+                          expr: _col8
                           type: string
                     outputColumnNames: _col0, _col1, _col2
                     Reduce Output Operator
@@ -346,14 +346,14 @@ STAGE PLANS:
                 UDTF Operator
                   function name: json_tuple
                   Lateral View Join Operator
-                    outputColumnNames: _col0, _col2, _col3, _col4, _col5, _col6
+                    outputColumnNames: _col0, _col4, _col5, _col6, _col7, _col8
                     Select Operator
                       expressions:
                             expr: _col0
                             type: string
-                            expr: _col3
+                            expr: _col5
                             type: string
-                            expr: _col6
+                            expr: _col8
                             type: string
                       outputColumnNames: _col0, _col1, _col2
                       Reduce Output Operator
@@ -425,22 +425,22 @@ STAGE PLANS:
             Lateral View Forward
               Select Operator
                 Lateral View Join Operator
-                  outputColumnNames: _col2, _col3, _col4, _col5, _col6
+                  outputColumnNames: _col4, _col5, _col6, _col7, _col8
                   Filter Operator
                     predicate:
-                        expr: _col2 is not null
+                        expr: _col4 is not null
                         type: boolean
                     Select Operator
                       expressions:
-                            expr: _col3
+                            expr: _col5
                             type: string
-                      outputColumnNames: _col3
+                      outputColumnNames: _col5
                       Group By Operator
                         aggregations:
                               expr: count()
                         bucketGroup: false
                         keys:
-                              expr: _col3
+                              expr: _col5
                               type: string
                         mode: hash
                         outputColumnNames: _col0, _col1
@@ -474,22 +474,22 @@ STAGE PLANS:
                 UDTF Operator
                   function name: json_tuple
                   Lateral View Join Operator
-                    outputColumnNames: _col2, _col3, _col4, _col5, _col6
+                    outputColumnNames: _col4, _col5, _col6, _col7, _col8
                     Filter Operator
                       predicate:
-                          expr: _col2 is not null
+                          expr: _col4 is not null
                           type: boolean
                       Select Operator
                         expressions:
-                              expr: _col3
+                              expr: _col5
                               type: string
-                        outputColumnNames: _col3
+                        outputColumnNames: _col5
                         Group By Operator
                           aggregations:
                                 expr: count()
                           bucketGroup: false
                           keys:
-                                expr: _col3
+                                expr: _col5
                                 type: string
                           mode: hash
                           outputColumnNames: _col0, _col1

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out Fri Apr 26 04:59:50 2013
@@ -89,15 +89,11 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: key
                 Lateral View Join Operator
-                  outputColumnNames: _col0, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10
+                  outputColumnNames: _col0, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12
                   Select Operator
                     expressions:
                           expr: _col0
                           type: string
-                          expr: _col2
-                          type: string
-                          expr: _col3
-                          type: string
                           expr: _col4
                           type: string
                           expr: _col5
@@ -112,6 +108,10 @@ STAGE PLANS:
                           type: string
                           expr: _col10
                           type: string
+                          expr: _col11
+                          type: string
+                          expr: _col12
+                          type: string
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
                     Reduce Output Operator
                       key expressions:
@@ -166,15 +166,11 @@ STAGE PLANS:
                 UDTF Operator
                   function name: parse_url_tuple
                   Lateral View Join Operator
-                    outputColumnNames: _col0, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10
+                    outputColumnNames: _col0, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12
                     Select Operator
                       expressions:
                             expr: _col0
                             type: string
-                            expr: _col2
-                            type: string
-                            expr: _col3
-                            type: string
                             expr: _col4
                             type: string
                             expr: _col5
@@ -189,6 +185,10 @@ STAGE PLANS:
                             type: string
                             expr: _col10
                             type: string
+                            expr: _col11
+                            type: string
+                            expr: _col12
+                            type: string
                       outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
                       Reduce Output Operator
                         key expressions:
@@ -384,23 +384,23 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: key
                 Lateral View Join Operator
-                  outputColumnNames: _col0, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
+                  outputColumnNames: _col0, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15
                   Select Operator
                     expressions:
                           expr: _col0
                           type: string
-                          expr: _col2
-                          type: string
                           expr: _col4
                           type: string
-                          expr: _col10
-                          type: string
-                          expr: _col11
+                          expr: _col6
                           type: string
                           expr: _col12
                           type: string
                           expr: _col13
                           type: string
+                          expr: _col14
+                          type: string
+                          expr: _col15
+                          type: string
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
                     Reduce Output Operator
                       key expressions:
@@ -455,23 +455,23 @@ STAGE PLANS:
                 UDTF Operator
                   function name: parse_url_tuple
                   Lateral View Join Operator
-                    outputColumnNames: _col0, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
+                    outputColumnNames: _col0, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15
                     Select Operator
                       expressions:
                             expr: _col0
                             type: string
-                            expr: _col2
-                            type: string
                             expr: _col4
                             type: string
-                            expr: _col10
-                            type: string
-                            expr: _col11
+                            expr: _col6
                             type: string
                             expr: _col12
                             type: string
                             expr: _col13
                             type: string
+                            expr: _col14
+                            type: string
+                            expr: _col15
+                            type: string
                       outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
                       Reduce Output Operator
                         key expressions:
@@ -549,22 +549,22 @@ STAGE PLANS:
             Lateral View Forward
               Select Operator
                 Lateral View Join Operator
-                  outputColumnNames: _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10
+                  outputColumnNames: _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12
                   Filter Operator
                     predicate:
-                        expr: _col10 is not null
+                        expr: _col12 is not null
                         type: boolean
                     Select Operator
                       expressions:
-                            expr: _col2
+                            expr: _col4
                             type: string
-                      outputColumnNames: _col2
+                      outputColumnNames: _col4
                       Group By Operator
                         aggregations:
                               expr: count()
                         bucketGroup: false
                         keys:
-                              expr: _col2
+                              expr: _col4
                               type: string
                         mode: hash
                         outputColumnNames: _col0, _col1
@@ -606,22 +606,22 @@ STAGE PLANS:
                 UDTF Operator
                   function name: parse_url_tuple
                   Lateral View Join Operator
-                    outputColumnNames: _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10
+                    outputColumnNames: _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12
                     Filter Operator
                       predicate:
-                          expr: _col10 is not null
+                          expr: _col12 is not null
                           type: boolean
                       Select Operator
                         expressions:
-                              expr: _col2
+                              expr: _col4
                               type: string
-                        outputColumnNames: _col2
+                        outputColumnNames: _col4
                         Group By Operator
                           aggregations:
                                 expr: count()
                           bucketGroup: false
                           keys:
-                                expr: _col2
+                                expr: _col4
                                 type: string
                           mode: hash
                           outputColumnNames: _col0, _col1

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udtf_stack.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udtf_stack.q.out?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udtf_stack.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udtf_stack.q.out Fri Apr 26 04:59:50 2013
@@ -24,12 +24,12 @@ STAGE PLANS:
             Lateral View Forward
               Select Operator
                 Lateral View Join Operator
-                  outputColumnNames: _col2, _col3
+                  outputColumnNames: _col4, _col5
                   Select Operator
                     expressions:
-                          expr: _col2
+                          expr: _col4
                           type: string
-                          expr: _col3
+                          expr: _col5
                           type: array<int>
                     outputColumnNames: _col0, _col1
                     Limit
@@ -53,12 +53,12 @@ STAGE PLANS:
                 UDTF Operator
                   function name: stack
                   Lateral View Join Operator
-                    outputColumnNames: _col2, _col3
+                    outputColumnNames: _col4, _col5
                     Select Operator
                       expressions:
-                            expr: _col2
+                            expr: _col4
                             type: string
-                            expr: _col3
+                            expr: _col5
                             type: array<int>
                       outputColumnNames: _col0, _col1
                       Limit
@@ -95,12 +95,12 @@ STAGE PLANS:
             Lateral View Forward
               Select Operator
                 Lateral View Join Operator
-                  outputColumnNames: _col2, _col3
+                  outputColumnNames: _col4, _col5
                   Select Operator
                     expressions:
-                          expr: _col2
+                          expr: _col4
                           type: string
-                          expr: _col3
+                          expr: _col5
                           type: array<int>
                     outputColumnNames: _col0, _col1
                     Limit
@@ -126,12 +126,12 @@ STAGE PLANS:
                 UDTF Operator
                   function name: stack
                   Lateral View Join Operator
-                    outputColumnNames: _col2, _col3
+                    outputColumnNames: _col4, _col5
                     Select Operator
                       expressions:
-                            expr: _col2
+                            expr: _col4
                             type: string
-                            expr: _col3
+                            expr: _col5
                             type: array<int>
                       outputColumnNames: _col0, _col1
                       Limit

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/union26.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/union26.q.out?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/union26.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/union26.q.out Fri Apr 26 04:59:50 2013
@@ -158,7 +158,7 @@ STAGE PLANS:
                       type: string
                 outputColumnNames: key, value
                 Lateral View Join Operator
-                  outputColumnNames: _col0, _col1, _col4
+                  outputColumnNames: _col0, _col1, _col6
                   Select Operator
                     expressions:
                           expr: _col0
@@ -209,7 +209,7 @@ STAGE PLANS:
                 UDTF Operator
                   function name: explode
                   Lateral View Join Operator
-                    outputColumnNames: _col0, _col1, _col4
+                    outputColumnNames: _col0, _col1, _col6
                     Select Operator
                       expressions:
                             expr: _col0



Mime
View raw message