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/03/28 22:53:40 UTC
svn commit: r1462322 [2/4] - in /hive/branches/ptf-windowing/ql/src:
java/org/apache/hadoop/hive/ql/parse/ java/org/apache/hadoop/hive/ql/plan/
java/org/apache/hadoop/hive/ql/udf/ptf/ test/queries/clientnegative/
test/queries/clientpositive/ test/resul...
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/ptf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/ptf.q.out?rev=1462322&r1=1462321&r2=1462322&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/ptf.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/ptf.q.out Thu Mar 28 21:53:39 2013
@@ -231,8 +231,7 @@ p_size, p_size - lag(p_size,1,p_size) ov
from noop(on part
partition by p_mfgr
order by p_name
- )
-having p_size > 0
+ )
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
@@ -244,8 +243,7 @@ p_size, p_size - lag(p_size,1,p_size) ov
from noop(on part
partition by p_mfgr
order by p_name
- )
-having p_size > 0
+ )
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
@@ -638,31 +636,31 @@ window w1 as (partition by p_mfgr order
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
-Manufacturer#1 almond antique burnished rose metallic 6 4100.06
-Manufacturer#1 almond antique burnished rose metallic 6 5702.650000000001
-Manufacturer#1 almond antique chartreuse lavender yellow 6 7117.070000000001
-Manufacturer#1 almond antique salmon chartreuse burlywood 6 7576.58
-Manufacturer#1 almond aquamarine burnished black steel 6 6403.43
+Manufacturer#1 almond antique burnished rose metallic 2 4100.06
+Manufacturer#1 almond antique burnished rose metallic 2 5702.650000000001
+Manufacturer#1 almond antique chartreuse lavender yellow 3 7117.070000000001
+Manufacturer#1 almond antique salmon chartreuse burlywood 4 7576.58
+Manufacturer#1 almond aquamarine burnished black steel 5 6403.43
Manufacturer#1 almond aquamarine pink moccasin thistle 6 4649.67
-Manufacturer#2 almond antique violet chocolate turquoise 5 5523.360000000001
-Manufacturer#2 almond antique violet turquoise frosted 5 7222.02
-Manufacturer#2 almond aquamarine midnight light salmon 5 8923.62
-Manufacturer#2 almond aquamarine rose maroon antique 5 7232.9400000000005
+Manufacturer#2 almond antique violet chocolate turquoise 1 5523.360000000001
+Manufacturer#2 almond antique violet turquoise frosted 2 7222.02
+Manufacturer#2 almond aquamarine midnight light salmon 3 8923.62
+Manufacturer#2 almond aquamarine rose maroon antique 4 7232.9400000000005
Manufacturer#2 almond aquamarine sandy cyan gainsboro 5 5432.24
-Manufacturer#3 almond antique chartreuse khaki white 5 4272.34
-Manufacturer#3 almond antique forest lavender goldenrod 5 6195.32
-Manufacturer#3 almond antique metallic orange dim 5 7532.61
-Manufacturer#3 almond antique misty red olive 5 5860.929999999999
+Manufacturer#3 almond antique chartreuse khaki white 1 4272.34
+Manufacturer#3 almond antique forest lavender goldenrod 2 6195.32
+Manufacturer#3 almond antique metallic orange dim 3 7532.61
+Manufacturer#3 almond antique misty red olive 4 5860.929999999999
Manufacturer#3 almond antique olive coral navajo 5 4670.66
-Manufacturer#4 almond antique gainsboro frosted violet 5 4202.35
-Manufacturer#4 almond antique violet mint lemon 5 6047.27
-Manufacturer#4 almond aquamarine floral ivory bisque 5 7337.620000000001
-Manufacturer#4 almond aquamarine yellow dodger mint 5 5716.950000000001
+Manufacturer#4 almond antique gainsboro frosted violet 1 4202.35
+Manufacturer#4 almond antique violet mint lemon 2 6047.27
+Manufacturer#4 almond aquamarine floral ivory bisque 3 7337.620000000001
+Manufacturer#4 almond aquamarine yellow dodger mint 4 5716.950000000001
Manufacturer#4 almond azure aquamarine papaya violet 5 4341.530000000001
-Manufacturer#5 almond antique blue firebrick mint 5 5190.08
-Manufacturer#5 almond antique medium spring khaki 5 6208.18
-Manufacturer#5 almond antique sky peru orange 5 7672.66
-Manufacturer#5 almond aquamarine dodger light gainsboro 5 5882.970000000001
+Manufacturer#5 almond antique blue firebrick mint 1 5190.08
+Manufacturer#5 almond antique medium spring khaki 2 6208.18
+Manufacturer#5 almond antique sky peru orange 3 7672.66
+Manufacturer#5 almond aquamarine dodger light gainsboro 4 5882.970000000001
Manufacturer#5 almond azure blanched chiffon midnight 5 4271.3099999999995
PREHOOK: query: -- 14. testPTFJoinWithWindowingWithCount
select abc.p_mfgr, abc.p_name,
@@ -692,33 +690,33 @@ order by p_name
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
-Manufacturer#1 almond antique burnished rose metallic 1 1 8 1173.15 1173.15 2 0
-Manufacturer#1 almond antique burnished rose metallic 1 1 8 1173.15 2346.3 2 0
-Manufacturer#1 almond antique burnished rose metallic 1 1 8 1173.15 3519.4500000000003 2 0
-Manufacturer#1 almond antique burnished rose metallic 1 1 8 1173.15 4692.6 2 0
-Manufacturer#1 almond antique chartreuse lavender yellow 5 2 8 1753.76 6446.360000000001 34 32
-Manufacturer#1 almond antique salmon chartreuse burlywood 6 3 8 1602.59 8048.950000000001 6 -28
-Manufacturer#1 almond aquamarine burnished black steel 7 4 8 1414.42 9463.37 28 22
+Manufacturer#1 almond antique burnished rose metallic 1 1 4 1173.15 1173.15 2 0
+Manufacturer#1 almond antique burnished rose metallic 1 1 4 1173.15 2346.3 2 0
+Manufacturer#1 almond antique burnished rose metallic 1 1 4 1173.15 3519.4500000000003 2 0
+Manufacturer#1 almond antique burnished rose metallic 1 1 4 1173.15 4692.6 2 0
+Manufacturer#1 almond antique chartreuse lavender yellow 5 2 5 1753.76 6446.360000000001 34 32
+Manufacturer#1 almond antique salmon chartreuse burlywood 6 3 6 1602.59 8048.950000000001 6 -28
+Manufacturer#1 almond aquamarine burnished black steel 7 4 7 1414.42 9463.37 28 22
Manufacturer#1 almond aquamarine pink moccasin thistle 8 5 8 1632.66 11096.03 42 14
-Manufacturer#2 almond antique violet chocolate turquoise 1 1 5 1690.68 1690.68 14 0
-Manufacturer#2 almond antique violet turquoise frosted 2 2 5 1800.7 3491.38 40 26
-Manufacturer#2 almond aquamarine midnight light salmon 3 3 5 2031.98 5523.360000000001 2 -38
-Manufacturer#2 almond aquamarine rose maroon antique 4 4 5 1698.66 7222.02 25 23
+Manufacturer#2 almond antique violet chocolate turquoise 1 1 1 1690.68 1690.68 14 0
+Manufacturer#2 almond antique violet turquoise frosted 2 2 2 1800.7 3491.38 40 26
+Manufacturer#2 almond aquamarine midnight light salmon 3 3 3 2031.98 5523.360000000001 2 -38
+Manufacturer#2 almond aquamarine rose maroon antique 4 4 4 1698.66 7222.02 25 23
Manufacturer#2 almond aquamarine sandy cyan gainsboro 5 5 5 1701.6 8923.62 18 -7
-Manufacturer#3 almond antique chartreuse khaki white 1 1 5 1671.68 1671.68 17 0
-Manufacturer#3 almond antique forest lavender goldenrod 2 2 5 1190.27 2861.95 14 -3
-Manufacturer#3 almond antique metallic orange dim 3 3 5 1410.39 4272.34 19 5
-Manufacturer#3 almond antique misty red olive 4 4 5 1922.98 6195.32 1 -18
+Manufacturer#3 almond antique chartreuse khaki white 1 1 1 1671.68 1671.68 17 0
+Manufacturer#3 almond antique forest lavender goldenrod 2 2 2 1190.27 2861.95 14 -3
+Manufacturer#3 almond antique metallic orange dim 3 3 3 1410.39 4272.34 19 5
+Manufacturer#3 almond antique misty red olive 4 4 4 1922.98 6195.32 1 -18
Manufacturer#3 almond antique olive coral navajo 5 5 5 1337.29 7532.61 45 44
-Manufacturer#4 almond antique gainsboro frosted violet 1 1 5 1620.67 1620.67 10 0
-Manufacturer#4 almond antique violet mint lemon 2 2 5 1375.42 2996.09 39 29
-Manufacturer#4 almond aquamarine floral ivory bisque 3 3 5 1206.26 4202.35 27 -12
-Manufacturer#4 almond aquamarine yellow dodger mint 4 4 5 1844.92 6047.27 7 -20
+Manufacturer#4 almond antique gainsboro frosted violet 1 1 1 1620.67 1620.67 10 0
+Manufacturer#4 almond antique violet mint lemon 2 2 2 1375.42 2996.09 39 29
+Manufacturer#4 almond aquamarine floral ivory bisque 3 3 3 1206.26 4202.35 27 -12
+Manufacturer#4 almond aquamarine yellow dodger mint 4 4 4 1844.92 6047.27 7 -20
Manufacturer#4 almond azure aquamarine papaya violet 5 5 5 1290.35 7337.620000000001 12 5
-Manufacturer#5 almond antique blue firebrick mint 1 1 5 1789.69 1789.69 31 0
-Manufacturer#5 almond antique medium spring khaki 2 2 5 1611.66 3401.3500000000004 6 -25
-Manufacturer#5 almond antique sky peru orange 3 3 5 1788.73 5190.08 2 -4
-Manufacturer#5 almond aquamarine dodger light gainsboro 4 4 5 1018.1 6208.18 46 44
+Manufacturer#5 almond antique blue firebrick mint 1 1 1 1789.69 1789.69 31 0
+Manufacturer#5 almond antique medium spring khaki 2 2 2 1611.66 3401.3500000000004 6 -25
+Manufacturer#5 almond antique sky peru orange 3 3 3 1788.73 5190.08 2 -4
+Manufacturer#5 almond aquamarine dodger light gainsboro 4 4 4 1018.1 6208.18 46 44
Manufacturer#5 almond azure blanched chiffon midnight 5 5 5 1464.48 7672.66 23 -23
PREHOOK: query: -- 15. testDistinctInSelectWithPTF
select DISTINCT p_mfgr, p_name, p_size
@@ -865,12 +863,11 @@ dense_rank() over (distribute by p_mfgr
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_mfgr, p_name range between p_size 5 preceding and current row) as s2,
+sum(p_size) over (distribute by p_mfgr sort by p_size range between 5 preceding and current row) as s2,
rank() over (distribute by p_mfgr sort by p_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,
first_value(p_size, true) over w1 as fv1
-having p_size > 5
window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following)
PREHOOK: type: QUERY
PREHOOK: Input: default@part
@@ -885,12 +882,11 @@ dense_rank() over (distribute by p_mfgr
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_mfgr, p_name range between p_size 5 preceding and current row) as s2,
+sum(p_size) over (distribute by p_mfgr sort by p_size range between 5 preceding and current row) as s2,
rank() over (distribute by p_mfgr sort by p_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,
first_value(p_size, true) over w1 as fv1
-having p_size > 5
window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
@@ -983,27 +979,32 @@ POSTHOOK: Lineage: part_5.p_size SCRIPT
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), ]
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), ]
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), ]
-Manufacturer#1 almond antique chartreuse lavender yellow 34 38 34 3 2 0.5 2
-Manufacturer#1 almond antique salmon chartreuse burlywood 6 44 44 4 3 0.6666666666666666 2
+Manufacturer#1 almond antique burnished rose metallic 2 4 4 1 1 0.16666666666666666 2
+Manufacturer#1 almond antique burnished rose metallic 2 2 4 1 1 0.16666666666666666 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 antique violet turquoise frosted 40 54 40 2 2 0.4 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 aquamarine sandy cyan gainsboro 18 99 43 5 5 1.0 2
-Manufacturer#3 almond antique chartreuse khaki white 17 17 17 1 1 0.2 17
-Manufacturer#3 almond antique forest lavender goldenrod 14 31 31 2 2 0.4 17
-Manufacturer#3 almond antique metallic orange dim 19 50 19 3 3 0.6 17
+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 antique gainsboro frosted violet 10 10 10 1 1 0.2 10
+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#4 almond aquamarine floral ivory bisque 27 76 66 3 3 0.6 10
-Manufacturer#4 almond aquamarine yellow dodger mint 7 83 83 4 4 0.8 39
-Manufacturer#4 almond azure aquamarine papaya violet 12 95 12 5 5 1.0 27
+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 antique medium spring khaki 6 37 37 2 2 0.4 31
Manufacturer#5 almond aquamarine dodger light gainsboro 46 85 46 4 4 0.8 6
-Manufacturer#5 almond azure blanched chiffon midnight 23 108 69 5 5 1.0 2
PREHOOK: query: -- 18. testMulti2OperatorsFunctionChainWithMap
select p_mfgr, p_name,
rank() over (partition by p_mfgr,p_name) as r,
@@ -1211,31 +1212,31 @@ POSTHOOK: Lineage: part_5.p_size SCRIPT
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), ]
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), ]
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), ]
-Manufacturer#1 almond antique burnished rose metallic 1 1 2 114
-Manufacturer#1 almond antique burnished rose metallic 1 1 2 114
-Manufacturer#1 almond antique chartreuse lavender yellow 3 2 34 114
-Manufacturer#1 almond antique salmon chartreuse burlywood 4 3 6 114
-Manufacturer#1 almond aquamarine burnished black steel 5 4 28 114
+Manufacturer#1 almond antique burnished rose metallic 1 1 2 4
+Manufacturer#1 almond antique burnished rose metallic 1 1 2 4
+Manufacturer#1 almond antique chartreuse lavender yellow 3 2 34 38
+Manufacturer#1 almond antique salmon chartreuse burlywood 4 3 6 44
+Manufacturer#1 almond aquamarine burnished black steel 5 4 28 72
Manufacturer#1 almond aquamarine pink moccasin thistle 6 5 42 114
-Manufacturer#2 almond antique violet chocolate turquoise 1 1 14 99
-Manufacturer#2 almond antique violet turquoise frosted 2 2 40 99
-Manufacturer#2 almond aquamarine midnight light salmon 3 3 2 99
-Manufacturer#2 almond aquamarine rose maroon antique 4 4 25 99
+Manufacturer#2 almond antique violet chocolate turquoise 1 1 14 14
+Manufacturer#2 almond antique violet turquoise frosted 2 2 40 54
+Manufacturer#2 almond aquamarine midnight light salmon 3 3 2 56
+Manufacturer#2 almond aquamarine rose maroon antique 4 4 25 81
Manufacturer#2 almond aquamarine sandy cyan gainsboro 5 5 18 99
-Manufacturer#3 almond antique chartreuse khaki white 1 1 17 96
-Manufacturer#3 almond antique forest lavender goldenrod 2 2 14 96
-Manufacturer#3 almond antique metallic orange dim 3 3 19 96
-Manufacturer#3 almond antique misty red olive 4 4 1 96
+Manufacturer#3 almond antique chartreuse khaki white 1 1 17 17
+Manufacturer#3 almond antique forest lavender goldenrod 2 2 14 31
+Manufacturer#3 almond antique metallic orange dim 3 3 19 50
+Manufacturer#3 almond antique misty red olive 4 4 1 51
Manufacturer#3 almond antique olive coral navajo 5 5 45 96
-Manufacturer#4 almond antique gainsboro frosted violet 1 1 10 95
-Manufacturer#4 almond antique violet mint lemon 2 2 39 95
-Manufacturer#4 almond aquamarine floral ivory bisque 3 3 27 95
-Manufacturer#4 almond aquamarine yellow dodger mint 4 4 7 95
+Manufacturer#4 almond antique gainsboro frosted violet 1 1 10 10
+Manufacturer#4 almond antique violet mint lemon 2 2 39 49
+Manufacturer#4 almond aquamarine floral ivory bisque 3 3 27 76
+Manufacturer#4 almond aquamarine yellow dodger mint 4 4 7 83
Manufacturer#4 almond azure aquamarine papaya violet 5 5 12 95
-Manufacturer#5 almond antique blue firebrick mint 1 1 31 108
-Manufacturer#5 almond antique medium spring khaki 2 2 6 108
-Manufacturer#5 almond antique sky peru orange 3 3 2 108
-Manufacturer#5 almond aquamarine dodger light gainsboro 4 4 46 108
+Manufacturer#5 almond antique blue firebrick mint 1 1 31 31
+Manufacturer#5 almond antique medium spring khaki 2 2 6 37
+Manufacturer#5 almond antique sky peru orange 3 3 2 39
+Manufacturer#5 almond aquamarine dodger light gainsboro 4 4 46 85
Manufacturer#5 almond azure blanched chiffon midnight 5 5 23 108
PREHOOK: query: -- 21. testMultiOperatorChainEndsWithNoopMap
select p_mfgr, p_name,
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/ptf_general_queries.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/ptf_general_queries.q.out?rev=1462322&r1=1462321&r2=1462322&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/ptf_general_queries.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/ptf_general_queries.q.out Thu Mar 28 21:53:39 2013
@@ -79,38 +79,38 @@ 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(distribute by p_mfgr sort by p_mfgr, p_name) as s,
-min(p_retailprice) over(distribute by p_mfgr sort by p_mfgr, p_name) as mi,
-max(p_retailprice) over(distribute by p_mfgr sort by p_mfgr, p_name) as ma,
-avg(p_retailprice) over(distribute by p_mfgr sort by p_mfgr, p_name) as av
+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
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(distribute by p_mfgr sort by p_mfgr, p_name) as s,
-min(p_retailprice) over(distribute by p_mfgr sort by p_mfgr, p_name) as mi,
-max(p_retailprice) over(distribute by p_mfgr sort by p_mfgr, p_name) as ma,
-avg(p_retailprice) over(distribute by p_mfgr sort by p_mfgr, p_name) as av
+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
from part
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
-Manufacturer#1 almond antique burnished rose metallic 1173.15 8749.730000000001 1173.15 1753.76 1458.2883333333336
-Manufacturer#1 almond antique burnished rose metallic 1173.15 8749.730000000001 1173.15 1753.76 1458.2883333333336
-Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 8749.730000000001 1173.15 1753.76 1458.2883333333336
-Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 8749.730000000001 1173.15 1753.76 1458.2883333333336
-Manufacturer#1 almond aquamarine burnished black steel 1414.42 8749.730000000001 1173.15 1753.76 1458.2883333333336
-Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 8749.730000000001 1173.15 1753.76 1458.2883333333336
+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#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 metallic orange dim 1410.39 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 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