You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by am...@apache.org on 2013/04/26 06:59:58 UTC
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...
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