You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2013/04/26 21:16:13 UTC
svn commit: r1476348 [24/29] - in /hive/branches/vectorization: ./ beeline/
beeline/src/java/org/apache/hive/beeline/ beeline/src/test/org/
beeline/src/test/org/apache/ beeline/src/test/org/apache/hive/
beeline/src/test/org/apache/hive/beeline/ beeline...
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/ptf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/ptf.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/ptf.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/ptf.q.out Fri Apr 26 19:14:49 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/vectorization/ql/src/test/results/clientpositive/ptf_general_queries.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/ptf_general_queries.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/ptf_general_queries.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/ptf_general_queries.q.out Fri Apr 26 19:14:49 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/vectorization/ql/src/test/results/clientpositive/rcfile_bigdata.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/rcfile_bigdata.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/rcfile_bigdata.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/rcfile_bigdata.q.out Fri Apr 26 19:14:49 2013
@@ -31,8 +31,6 @@ POSTHOOK: query: describe columnTable_Bi
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: columntable_bigdata.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: columntable_bigdata.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name data_type comment
-
key string None
value string None
PREHOOK: query: select count(columnTable_Bigdata.key) from columnTable_Bigdata
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/rcfile_columnar.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/rcfile_columnar.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/rcfile_columnar.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/rcfile_columnar.q.out Fri Apr 26 19:14:49 2013
@@ -31,8 +31,6 @@ POSTHOOK: query: describe columnTable
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: columntable.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: columntable.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name data_type comment
-
key string None
value string None
PREHOOK: query: SELECT columnTable.* FROM columnTable ORDER BY key ASC, value ASC
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/rcfile_default_format.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/rcfile_default_format.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/rcfile_default_format.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/rcfile_default_format.q.out Fri Apr 26 19:14:49 2013
@@ -7,8 +7,6 @@ PREHOOK: query: DESCRIBE EXTENDED rcfile
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED rcfile_default_format
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string None
#### A masked pattern was here ####
@@ -23,8 +21,6 @@ PREHOOK: query: DESCRIBE EXTENDED rcfile
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED rcfile_default_format_ctas
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string None
value string None
@@ -48,8 +44,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED rcfile_default_format_txtfile
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: rcfile_default_format_txtfile.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name data_type comment
-
key string None
#### A masked pattern was here ####
@@ -66,8 +60,6 @@ PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE EXTENDED textfile_default_format_ctas
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: rcfile_default_format_txtfile.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name data_type comment
-
key string None
value string None
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/rename_column.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/rename_column.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/rename_column.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/rename_column.q.out Fri Apr 26 19:14:49 2013
@@ -7,8 +7,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
a int None
b int None
c int None
@@ -24,8 +22,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
a string None
b int None
c int None
@@ -41,8 +37,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
a1 int None
b int None
c int None
@@ -58,8 +52,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
a2 int None
b int None
c int None
@@ -75,8 +67,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
b int None
a int None
c int None
@@ -92,8 +82,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
b int None
a1 int test comment1
c int None
@@ -109,8 +97,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
a2 int test comment2
b int None
c int None
@@ -126,8 +112,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
b int None
a int test comment2
c int None
@@ -170,8 +154,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
a int None
b int None
c int None
@@ -187,8 +169,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
a string None
b int None
c int None
@@ -204,8 +184,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
a1 int None
b int None
c int None
@@ -221,8 +199,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
a2 int None
b int None
c int None
@@ -238,8 +214,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
b int None
a int None
c int None
@@ -255,8 +229,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
b int None
a1 int test comment1
c int None
@@ -272,8 +244,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
a2 int test comment2
b int None
c int None
@@ -289,8 +259,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE kv_rename_test
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
b int None
a int test comment2
c int None
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/semijoin.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/semijoin.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/semijoin.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/semijoin.q.out Fri Apr 26 19:14:49 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/vectorization/ql/src/test/results/clientpositive/serde_reported_schema.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/serde_reported_schema.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/serde_reported_schema.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/serde_reported_schema.q.out Fri Apr 26 19:14:49 2013
@@ -17,8 +17,6 @@ PREHOOK: query: describe int_string
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe int_string
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
myint int from deserializer
mystring string from deserializer
underscore_int int from deserializer
@@ -39,8 +37,6 @@ PREHOOK: query: describe int_string part
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe int_string partition (b='part1')
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
myint int from deserializer
mystring string from deserializer
underscore_int int from deserializer
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/show_columns.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/show_columns.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/show_columns.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/show_columns.q.out Fri Apr 26 19:14:49 2013
@@ -32,8 +32,6 @@ PREHOOK: Input: default@shcol_test
POSTHOOK: query: SHOW COLUMNS from shcol_test
POSTHOOK: type: SHOWCOLUMNS
POSTHOOK: Input: default@shcol_test
-# col_name
-
key
value
ds
@@ -64,8 +62,6 @@ PREHOOK: Input: test_db@foo
POSTHOOK: query: SHOW COLUMNS from foo
POSTHOOK: type: SHOWCOLUMNS
POSTHOOK: Input: test_db@foo
-# col_name
-
a
PREHOOK: query: SHOW COLUMNS in foo
PREHOOK: type: SHOWCOLUMNS
@@ -73,8 +69,6 @@ PREHOOK: Input: test_db@foo
POSTHOOK: query: SHOW COLUMNS in foo
POSTHOOK: type: SHOWCOLUMNS
POSTHOOK: Input: test_db@foo
-# col_name
-
a
PREHOOK: query: -- SHOW COLUMNS from a database with a name that requires escaping
CREATE DATABASE `database`
@@ -97,8 +91,6 @@ PREHOOK: Input: database@foo
POSTHOOK: query: SHOW COLUMNS from foo
POSTHOOK: type: SHOWCOLUMNS
POSTHOOK: Input: database@foo
-# col_name
-
a
PREHOOK: query: use default
PREHOOK: type: SWITCHDATABASE
@@ -110,8 +102,6 @@ PREHOOK: Input: test_db@foo
POSTHOOK: query: SHOW COLUMNS from test_db.foo
POSTHOOK: type: SHOWCOLUMNS
POSTHOOK: Input: test_db@foo
-# col_name
-
a
PREHOOK: query: SHOW COLUMNS from foo from test_db
PREHOOK: type: SHOWCOLUMNS
@@ -119,6 +109,4 @@ PREHOOK: Input: test_db@foo
POSTHOOK: query: SHOW COLUMNS from foo from test_db
POSTHOOK: type: SHOWCOLUMNS
POSTHOOK: Input: test_db@foo
-# col_name
-
a
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/show_functions.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/show_functions.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/show_functions.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/show_functions.q.out Fri Apr 26 19:14:49 2013
@@ -167,7 +167,6 @@ translate
trim
ucase
unhex
-union_map
unix_timestamp
upper
var_pop
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/stats0.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/stats0.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/stats0.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/stats0.q.out Fri Apr 26 19:14:49 2013
@@ -152,8 +152,6 @@ POSTHOOK: query: desc extended stats_non
POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: stats_non_partitioned.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: stats_non_partitioned.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name data_type comment
-
key string None
value string None
@@ -1277,8 +1275,6 @@ POSTHOOK: Lineage: stats_non_partitioned
POSTHOOK: Lineage: stats_non_partitioned.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name data_type comment
-
key string None
value string None
ds string None
@@ -1297,8 +1293,6 @@ POSTHOOK: Lineage: stats_non_partitioned
POSTHOOK: Lineage: stats_non_partitioned.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name data_type comment
-
key string None
value string None
ds string None
@@ -1655,8 +1649,6 @@ POSTHOOK: Lineage: stats_non_partitioned
POSTHOOK: Lineage: stats_non_partitioned.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name data_type comment
-
key string None
value string None
@@ -2854,8 +2846,6 @@ POSTHOOK: Lineage: stats_partitioned PAR
POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name data_type comment
-
key string None
value string None
ds string None
@@ -2878,8 +2868,6 @@ POSTHOOK: Lineage: stats_partitioned PAR
POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name data_type comment
-
key string None
value string None
ds string None
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/tablename_with_select.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/tablename_with_select.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/tablename_with_select.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/tablename_with_select.q.out Fri Apr 26 19:14:49 2013
@@ -7,8 +7,6 @@ PREHOOK: query: DESCRIBE tmp_select
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE tmp_select
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
a int None
b string None
PREHOOK: query: INSERT OVERWRITE TABLE tmp_select SELECT key, value FROM src
Modified: hive/branches/vectorization/ql/src/test/results/clientpositive/udtf_explode.q.out
URL: http://svn.apache.org/viewvc/hive/branches/vectorization/ql/src/test/results/clientpositive/udtf_explode.q.out?rev=1476348&r1=1476347&r2=1476348&view=diff
==============================================================================
--- hive/branches/vectorization/ql/src/test/results/clientpositive/udtf_explode.q.out (original)
+++ hive/branches/vectorization/ql/src/test/results/clientpositive/udtf_explode.q.out Fri Apr 26 19:14:49 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