You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by sz...@apache.org on 2015/01/12 23:08:34 UTC
svn commit: r1651213 [9/9] - in /hive/branches/spark: ./ hbase-handler/
hcatalog/src/test/e2e/templeton/tests/
itests/util/src/main/java/org/apache/hadoop/hive/ql/security/ metastore/if/
metastore/scripts/upgrade/derby/ metastore/scripts/upgrade/mssql/...
Modified: hive/branches/spark/ql/src/test/results/clientpositive/windowing.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/windowing.q.out?rev=1651213&r1=1651212&r2=1651213&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/windowing.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/windowing.q.out Mon Jan 12 22:08:32 2015
@@ -1,4 +1,6 @@
-PREHOOK: query: -- 1. testWindowing
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+-- 1. testWindowing
select p_mfgr, p_name, p_size,
rank() over(distribute by p_mfgr sort by p_name) as r,
dense_rank() over(distribute by p_mfgr sort by p_name) as dr,
@@ -7,7 +9,9 @@ from part
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 1. testWindowing
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+-- 1. testWindowing
select p_mfgr, p_name, p_size,
rank() over(distribute by p_mfgr sort by p_name) as r,
dense_rank() over(distribute by p_mfgr sort by p_name) as dr,
@@ -250,32 +254,32 @@ from part
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
+1 1 1 1620.67 0
+1 1 1 1671.68 0
+1 1 1 1690.68 0
+1 1 1 1789.69 0
1 1 2 1173.15 0
1 1 2 2346.3 0
-3 2 3 4100.06 32
-4 3 4 5702.650000000001 -28
-5 4 5 7117.070000000001 22
-6 5 6 8749.730000000001 14
-1 1 1 1690.68 0
-2 2 2 3491.38 26
-3 3 3 5523.360000000001 -38
-4 4 4 7222.02 23
-5 5 5 8923.62 -7
-1 1 1 1671.68 0
2 2 2 2861.95 -3
-3 3 3 4272.34 5
-4 4 4 6195.32 -18
-5 5 5 7532.61 44
-1 1 1 1620.67 0
2 2 2 2996.09 29
-3 3 3 4202.35 -12
-4 4 4 6047.27 -20
-5 5 5 7337.620000000001 5
-1 1 1 1789.69 0
2 2 2 3401.3500000000004 -25
+2 2 2 3491.38 26
+3 2 3 4100.06 32
+3 3 3 4202.35 -12
+3 3 3 4272.34 5
3 3 3 5190.08 -4
+3 3 3 5523.360000000001 -38
+4 3 4 5702.650000000001 -28
+4 4 4 6047.27 -20
+4 4 4 6195.32 -18
4 4 4 6208.18 44
+4 4 4 7222.02 23
+5 4 5 7117.070000000001 22
+5 5 5 7337.620000000001 5
+5 5 5 7532.61 44
5 5 5 7672.66 -23
+5 5 5 8923.62 -7
+6 5 6 8749.730000000001 14
PREHOOK: query: -- 7. testJoinWithWindowingAndPTF
select abc.p_mfgr, abc.p_name,
rank() over(distribute by abc.p_mfgr sort by abc.p_name) as r,
@@ -902,8 +906,8 @@ window w1 as (distribute by p_mfgr sort
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
-Manufacturer#1 almond antique burnished rose metallic 2 273.70217881648074 273.70217881648074 [2,34] 74912.8826888888 1.0 4128.782222222221
Manufacturer#1 almond antique burnished rose metallic 2 258.10677784349235 258.10677784349235 [2,34,6] 66619.10876874991 0.811328754177887 2801.7074999999995
+Manufacturer#1 almond antique burnished rose metallic 2 273.70217881648074 273.70217881648074 [2,34] 74912.8826888888 1.0 4128.782222222221
Manufacturer#1 almond antique chartreuse lavender yellow 34 230.90151585470358 230.90151585470358 [2,34,6,28] 53315.51002399992 0.695639377397664 2210.7864
Manufacturer#1 almond antique salmon chartreuse burlywood 6 202.73109328368946 202.73109328368946 [2,34,6,28,42] 41099.896184 0.630785977101214 2009.9536000000007
Manufacturer#1 almond aquamarine burnished black steel 28 121.6064517973862 121.6064517973862 [34,6,28,42] 14788.129118750014 0.2036684720435979 331.1337500000004
@@ -948,8 +952,8 @@ window w1 as (distribute by p_mfgr sort
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
-Manufacturer#1 almond antique burnished rose metallic 2 [{"x":1173.15,"y":2.0},{"x":1753.76,"y":1.0}] 121152.0 1
Manufacturer#1 almond antique burnished rose metallic 2 [{"x":1173.15,"y":2.0},{"x":1602.59,"y":1.0},{"x":1753.76,"y":1.0}] 115872.0 2
+Manufacturer#1 almond antique burnished rose metallic 2 [{"x":1173.15,"y":2.0},{"x":1753.76,"y":1.0}] 121152.0 1
Manufacturer#1 almond antique chartreuse lavender yellow 34 [{"x":1173.15,"y":2.0},{"x":1414.42,"y":1.0},{"x":1602.59,"y":1.0},{"x":1753.76,"y":1.0}] 110592.0 3
Manufacturer#1 almond antique salmon chartreuse burlywood 6 [{"x":1173.15,"y":1.0},{"x":1414.42,"y":1.0},{"x":1602.59,"y":1.0},{"x":1632.66,"y":1.0},{"x":1753.76,"y":1.0}] 86428.0 4
Manufacturer#1 almond aquamarine burnished black steel 28 [{"x":1414.42,"y":1.0},{"x":1602.59,"y":1.0},{"x":1632.66,"y":1.0},{"x":1753.76,"y":1.0}] 86098.0 5
@@ -1096,32 +1100,32 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@mfgr_brand_price_view
POSTHOOK: Input: default@part
#### A masked pattern was here ####
+Manufacturer#1 Brand#12 4100.06
+Manufacturer#1 Brand#12 4649.670000000001
+Manufacturer#1 Brand#12 4770.77
Manufacturer#1 Brand#14 1173.15
Manufacturer#1 Brand#14 2346.3
-Manufacturer#1 Brand#12 4100.06
Manufacturer#1 Brand#15 4529.5
-Manufacturer#1 Brand#12 4770.77
-Manufacturer#1 Brand#12 4649.670000000001
Manufacturer#2 Brand#22 1690.68
Manufacturer#2 Brand#22 3491.38
Manufacturer#2 Brand#23 5523.360000000001
Manufacturer#2 Brand#24 5531.34
Manufacturer#2 Brand#25 5432.240000000001
Manufacturer#3 Brand#31 1671.68
-Manufacturer#3 Brand#35 2861.95
Manufacturer#3 Brand#32 4272.34
Manufacturer#3 Brand#32 4523.639999999999
Manufacturer#3 Brand#34 4670.66
+Manufacturer#3 Brand#35 2861.95
Manufacturer#4 Brand#41 1620.67
+Manufacturer#4 Brand#41 4341.530000000001
+Manufacturer#4 Brand#41 4426.6
Manufacturer#4 Brand#42 2996.09
Manufacturer#4 Brand#42 4202.35
-Manufacturer#4 Brand#41 4426.6
-Manufacturer#4 Brand#41 4341.530000000001
-Manufacturer#5 Brand#52 1789.69
Manufacturer#5 Brand#51 3401.3500000000004
-Manufacturer#5 Brand#53 5190.08
-Manufacturer#5 Brand#53 4418.49
+Manufacturer#5 Brand#52 1789.69
Manufacturer#5 Brand#52 4271.3099999999995
+Manufacturer#5 Brand#53 4418.49
+Manufacturer#5 Brand#53 5190.08
PREHOOK: query: -- 24. testLateralViews
select p_mfgr, p_name,
lv_col, p_size, sum(p_size) over w1 as s
@@ -1146,78 +1150,78 @@ Manufacturer#1 almond antique burnished
Manufacturer#1 almond antique burnished rose metallic 2 2 6
Manufacturer#1 almond antique burnished rose metallic 3 2 6
Manufacturer#1 almond antique burnished rose metallic 3 2 6
+Manufacturer#1 almond antique chartreuse lavender yellow 1 34 90
+Manufacturer#1 almond antique chartreuse lavender yellow 2 34 96
+Manufacturer#1 almond antique chartreuse lavender yellow 3 34 102
Manufacturer#1 almond antique salmon chartreuse burlywood 1 6 10
Manufacturer#1 almond antique salmon chartreuse burlywood 2 6 14
Manufacturer#1 almond antique salmon chartreuse burlywood 3 6 18
Manufacturer#1 almond aquamarine burnished black steel 1 28 40
Manufacturer#1 almond aquamarine burnished black steel 2 28 62
Manufacturer#1 almond aquamarine burnished black steel 3 28 84
-Manufacturer#1 almond antique chartreuse lavender yellow 1 34 90
-Manufacturer#1 almond antique chartreuse lavender yellow 2 34 96
-Manufacturer#1 almond antique chartreuse lavender yellow 3 34 102
Manufacturer#1 almond aquamarine pink moccasin thistle 1 42 110
Manufacturer#1 almond aquamarine pink moccasin thistle 2 42 118
Manufacturer#1 almond aquamarine pink moccasin thistle 3 42 126
-Manufacturer#2 almond aquamarine midnight light salmon 1 2 2
-Manufacturer#2 almond aquamarine midnight light salmon 2 2 4
-Manufacturer#2 almond aquamarine midnight light salmon 3 2 6
Manufacturer#2 almond antique violet chocolate turquoise 1 14 18
Manufacturer#2 almond antique violet chocolate turquoise 2 14 30
Manufacturer#2 almond antique violet chocolate turquoise 3 14 42
-Manufacturer#2 almond aquamarine sandy cyan gainsboro 1 18 46
-Manufacturer#2 almond aquamarine sandy cyan gainsboro 2 18 50
-Manufacturer#2 almond aquamarine sandy cyan gainsboro 3 18 54
-Manufacturer#2 almond aquamarine rose maroon antique 1 25 61
-Manufacturer#2 almond aquamarine rose maroon antique 2 25 68
-Manufacturer#2 almond aquamarine rose maroon antique 3 25 75
Manufacturer#2 almond antique violet turquoise frosted 1 40 90
Manufacturer#2 almond antique violet turquoise frosted 2 40 105
Manufacturer#2 almond antique violet turquoise frosted 3 40 120
-Manufacturer#3 almond antique misty red olive 1 1 1
-Manufacturer#3 almond antique misty red olive 2 1 2
-Manufacturer#3 almond antique misty red olive 3 1 3
-Manufacturer#3 almond antique forest lavender goldenrod 1 14 16
-Manufacturer#3 almond antique forest lavender goldenrod 2 14 29
-Manufacturer#3 almond antique forest lavender goldenrod 3 14 42
+Manufacturer#2 almond aquamarine midnight light salmon 1 2 2
+Manufacturer#2 almond aquamarine midnight light salmon 2 2 4
+Manufacturer#2 almond aquamarine midnight light salmon 3 2 6
+Manufacturer#2 almond aquamarine rose maroon antique 1 25 61
+Manufacturer#2 almond aquamarine rose maroon antique 2 25 68
+Manufacturer#2 almond aquamarine rose maroon antique 3 25 75
+Manufacturer#2 almond aquamarine sandy cyan gainsboro 1 18 46
+Manufacturer#2 almond aquamarine sandy cyan gainsboro 2 18 50
+Manufacturer#2 almond aquamarine sandy cyan gainsboro 3 18 54
Manufacturer#3 almond antique chartreuse khaki white 1 17 45
Manufacturer#3 almond antique chartreuse khaki white 2 17 48
Manufacturer#3 almond antique chartreuse khaki white 3 17 51
+Manufacturer#3 almond antique forest lavender goldenrod 1 14 16
+Manufacturer#3 almond antique forest lavender goldenrod 2 14 29
+Manufacturer#3 almond antique forest lavender goldenrod 3 14 42
Manufacturer#3 almond antique metallic orange dim 1 19 53
Manufacturer#3 almond antique metallic orange dim 2 19 55
Manufacturer#3 almond antique metallic orange dim 3 19 57
+Manufacturer#3 almond antique misty red olive 1 1 1
+Manufacturer#3 almond antique misty red olive 2 1 2
+Manufacturer#3 almond antique misty red olive 3 1 3
Manufacturer#3 almond antique olive coral navajo 1 45 83
Manufacturer#3 almond antique olive coral navajo 2 45 109
Manufacturer#3 almond antique olive coral navajo 3 45 135
-Manufacturer#4 almond aquamarine yellow dodger mint 1 7 7
-Manufacturer#4 almond aquamarine yellow dodger mint 2 7 14
-Manufacturer#4 almond aquamarine yellow dodger mint 3 7 21
Manufacturer#4 almond antique gainsboro frosted violet 1 10 24
Manufacturer#4 almond antique gainsboro frosted violet 2 10 27
Manufacturer#4 almond antique gainsboro frosted violet 3 10 30
-Manufacturer#4 almond azure aquamarine papaya violet 1 12 32
-Manufacturer#4 almond azure aquamarine papaya violet 2 12 34
-Manufacturer#4 almond azure aquamarine papaya violet 3 12 36
-Manufacturer#4 almond aquamarine floral ivory bisque 1 27 51
-Manufacturer#4 almond aquamarine floral ivory bisque 2 27 66
-Manufacturer#4 almond aquamarine floral ivory bisque 3 27 81
Manufacturer#4 almond antique violet mint lemon 1 39 93
Manufacturer#4 almond antique violet mint lemon 2 39 105
Manufacturer#4 almond antique violet mint lemon 3 39 117
-Manufacturer#5 almond antique sky peru orange 1 2 2
-Manufacturer#5 almond antique sky peru orange 2 2 4
-Manufacturer#5 almond antique sky peru orange 3 2 6
-Manufacturer#5 almond antique medium spring khaki 1 6 10
-Manufacturer#5 almond antique medium spring khaki 2 6 14
-Manufacturer#5 almond antique medium spring khaki 3 6 18
-Manufacturer#5 almond azure blanched chiffon midnight 1 23 35
-Manufacturer#5 almond azure blanched chiffon midnight 2 23 52
-Manufacturer#5 almond azure blanched chiffon midnight 3 23 69
+Manufacturer#4 almond aquamarine floral ivory bisque 1 27 51
+Manufacturer#4 almond aquamarine floral ivory bisque 2 27 66
+Manufacturer#4 almond aquamarine floral ivory bisque 3 27 81
+Manufacturer#4 almond aquamarine yellow dodger mint 1 7 7
+Manufacturer#4 almond aquamarine yellow dodger mint 2 7 14
+Manufacturer#4 almond aquamarine yellow dodger mint 3 7 21
+Manufacturer#4 almond azure aquamarine papaya violet 1 12 32
+Manufacturer#4 almond azure aquamarine papaya violet 2 12 34
+Manufacturer#4 almond azure aquamarine papaya violet 3 12 36
Manufacturer#5 almond antique blue firebrick mint 1 31 77
Manufacturer#5 almond antique blue firebrick mint 2 31 85
Manufacturer#5 almond antique blue firebrick mint 3 31 93
+Manufacturer#5 almond antique medium spring khaki 1 6 10
+Manufacturer#5 almond antique medium spring khaki 2 6 14
+Manufacturer#5 almond antique medium spring khaki 3 6 18
+Manufacturer#5 almond antique sky peru orange 1 2 2
+Manufacturer#5 almond antique sky peru orange 2 2 4
+Manufacturer#5 almond antique sky peru orange 3 2 6
Manufacturer#5 almond aquamarine dodger light gainsboro 1 46 108
Manufacturer#5 almond aquamarine dodger light gainsboro 2 46 123
Manufacturer#5 almond aquamarine dodger light gainsboro 3 46 138
+Manufacturer#5 almond azure blanched chiffon midnight 1 23 35
+Manufacturer#5 almond azure blanched chiffon midnight 2 23 52
+Manufacturer#5 almond azure blanched chiffon midnight 3 23 69
PREHOOK: query: -- 25. testMultipleInserts3SWQs
CREATE TABLE part_1(
p_mfgr STRING,
@@ -1523,30 +1527,30 @@ POSTHOOK: Input: default@part
#### A masked pattern was here ####
Manufacturer#1 almond antique burnished rose metallic 2 4 10
Manufacturer#1 almond antique burnished rose metallic 2 4 10
+Manufacturer#1 almond antique chartreuse lavender yellow 34 62 76
Manufacturer#1 almond antique salmon chartreuse burlywood 6 10 6
Manufacturer#1 almond aquamarine burnished black steel 28 28 62
-Manufacturer#1 almond antique chartreuse lavender yellow 34 62 76
Manufacturer#1 almond aquamarine pink moccasin thistle 42 76 42
-Manufacturer#2 almond aquamarine midnight light salmon 2 2 2
Manufacturer#2 almond antique violet chocolate turquoise 14 14 32
-Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 32 43
-Manufacturer#2 almond aquamarine rose maroon antique 25 43 25
Manufacturer#2 almond antique violet turquoise frosted 40 40 40
-Manufacturer#3 almond antique misty red olive 1 1 1
-Manufacturer#3 almond antique forest lavender goldenrod 14 14 50
+Manufacturer#2 almond aquamarine midnight light salmon 2 2 2
+Manufacturer#2 almond aquamarine rose maroon antique 25 43 25
+Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 32 43
Manufacturer#3 almond antique chartreuse khaki white 17 31 36
+Manufacturer#3 almond antique forest lavender goldenrod 14 14 50
Manufacturer#3 almond antique metallic orange dim 19 50 19
+Manufacturer#3 almond antique misty red olive 1 1 1
Manufacturer#3 almond antique olive coral navajo 45 45 45
-Manufacturer#4 almond aquamarine yellow dodger mint 7 7 29
Manufacturer#4 almond antique gainsboro frosted violet 10 17 22
-Manufacturer#4 almond azure aquamarine papaya violet 12 29 12
-Manufacturer#4 almond aquamarine floral ivory bisque 27 27 27
Manufacturer#4 almond antique violet mint lemon 39 39 39
-Manufacturer#5 almond antique sky peru orange 2 2 8
-Manufacturer#5 almond antique medium spring khaki 6 8 6
-Manufacturer#5 almond azure blanched chiffon midnight 23 23 54
+Manufacturer#4 almond aquamarine floral ivory bisque 27 27 27
+Manufacturer#4 almond aquamarine yellow dodger mint 7 7 29
+Manufacturer#4 almond azure aquamarine papaya violet 12 29 12
Manufacturer#5 almond antique blue firebrick mint 31 54 31
+Manufacturer#5 almond antique medium spring khaki 6 8 6
+Manufacturer#5 almond antique sky peru orange 2 2 8
Manufacturer#5 almond aquamarine dodger light gainsboro 46 46 46
+Manufacturer#5 almond azure blanched chiffon midnight 23 23 54
PREHOOK: query: -- 28. testPartOrderInUDAFInvoke
select p_mfgr, p_name, p_size,
sum(p_size) over (partition by p_mfgr order by p_name rows between 2 preceding and 2 following) as s
@@ -2071,12 +2075,12 @@ Manufacturer#3 MEDIUM BURNISHED TIN EDIU
Manufacturer#3 PROMO ANODIZED TIN ROMO ANODIZED TIN 4
Manufacturer#3 STANDARD POLISHED STEEL TANDARD POLISHED STEEL 5
Manufacturer#4 ECONOMY BRUSHED COPPER CONOMY BRUSHED COPPER 1
+Manufacturer#4 PROMO POLISHED STEEL ROMO POLISHED STEEL 4
Manufacturer#4 SMALL BRUSHED BRASS MALL BRUSHED BRASS 2
Manufacturer#4 SMALL PLATED STEEL MALL PLATED STEEL 3
-Manufacturer#4 PROMO POLISHED STEEL ROMO POLISHED STEEL 4
Manufacturer#4 STANDARD ANODIZED TIN TANDARD ANODIZED TIN 5
-Manufacturer#5 LARGE BRUSHED BRASS ARGE BRUSHED BRASS 1
Manufacturer#5 ECONOMY BURNISHED STEEL CONOMY BURNISHED STEEL 2
+Manufacturer#5 LARGE BRUSHED BRASS ARGE BRUSHED BRASS 1
Manufacturer#5 MEDIUM BURNISHED TIN EDIUM BURNISHED TIN 3
Manufacturer#5 SMALL PLATED BRASS MALL PLATED BRASS 4
Manufacturer#5 STANDARD BURNISHED TIN TANDARD BURNISHED TIN 5
@@ -2136,30 +2140,30 @@ POSTHOOK: Input: default@part
#### A masked pattern was here ####
Manufacturer#1 almond antique burnished rose metallic 2 2346.3
Manufacturer#1 almond antique burnished rose metallic 2 2346.3
+Manufacturer#1 almond antique chartreuse lavender yellow 34 7117.070000000001
Manufacturer#1 almond antique salmon chartreuse burlywood 6 3948.8900000000003
Manufacturer#1 almond aquamarine burnished black steel 28 5363.31
-Manufacturer#1 almond antique chartreuse lavender yellow 34 7117.070000000001
Manufacturer#1 almond aquamarine pink moccasin thistle 42 8749.730000000001
-Manufacturer#2 almond aquamarine midnight light salmon 2 2031.98
Manufacturer#2 almond antique violet chocolate turquoise 14 3722.66
-Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 5424.26
-Manufacturer#2 almond aquamarine rose maroon antique 25 7122.92
Manufacturer#2 almond antique violet turquoise frosted 40 8923.62
-Manufacturer#3 almond antique misty red olive 1 1922.98
-Manufacturer#3 almond antique forest lavender goldenrod 14 3113.25
+Manufacturer#2 almond aquamarine midnight light salmon 2 2031.98
+Manufacturer#2 almond aquamarine rose maroon antique 25 7122.92
+Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 5424.26
Manufacturer#3 almond antique chartreuse khaki white 17 4784.93
+Manufacturer#3 almond antique forest lavender goldenrod 14 3113.25
Manufacturer#3 almond antique metallic orange dim 19 6195.320000000001
+Manufacturer#3 almond antique misty red olive 1 1922.98
Manufacturer#3 almond antique olive coral navajo 45 7532.610000000001
-Manufacturer#4 almond aquamarine yellow dodger mint 7 1844.92
Manufacturer#4 almond antique gainsboro frosted violet 10 3465.59
-Manufacturer#4 almond azure aquamarine papaya violet 12 4755.9400000000005
-Manufacturer#4 almond aquamarine floral ivory bisque 27 5962.200000000001
Manufacturer#4 almond antique violet mint lemon 39 7337.620000000001
-Manufacturer#5 almond antique sky peru orange 2 1788.73
-Manufacturer#5 almond antique medium spring khaki 6 3400.3900000000003
-Manufacturer#5 almond azure blanched chiffon midnight 23 4864.870000000001
+Manufacturer#4 almond aquamarine floral ivory bisque 27 5962.200000000001
+Manufacturer#4 almond aquamarine yellow dodger mint 7 1844.92
+Manufacturer#4 almond azure aquamarine papaya violet 12 4755.9400000000005
Manufacturer#5 almond antique blue firebrick mint 31 6654.560000000001
+Manufacturer#5 almond antique medium spring khaki 6 3400.3900000000003
+Manufacturer#5 almond antique sky peru orange 2 1788.73
Manufacturer#5 almond aquamarine dodger light gainsboro 46 7672.660000000002
+Manufacturer#5 almond azure blanched chiffon midnight 23 4864.870000000001
PREHOOK: query: -- 42. testUnboundedFollowingForRows
select p_mfgr, p_name, p_size,
sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between current row and unbounded following) as s1
@@ -2174,8 +2178,8 @@ select p_mfgr, p_name, p_size,
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
-Manufacturer#1 almond antique burnished rose metallic 2 8749.730000000001
Manufacturer#1 almond antique burnished rose metallic 2 7576.58
+Manufacturer#1 almond antique burnished rose metallic 2 8749.730000000001
Manufacturer#1 almond antique chartreuse lavender yellow 34 6403.43
Manufacturer#1 almond antique salmon chartreuse burlywood 6 4649.67
Manufacturer#1 almond aquamarine burnished black steel 28 3047.08
@@ -2216,30 +2220,30 @@ POSTHOOK: Input: default@part
#### A masked pattern was here ####
Manufacturer#1 almond antique burnished rose metallic 2 8749.730000000001
Manufacturer#1 almond antique burnished rose metallic 2 8749.730000000001
+Manufacturer#1 almond antique chartreuse lavender yellow 34 3386.42
Manufacturer#1 almond antique salmon chartreuse burlywood 6 6403.43
Manufacturer#1 almond aquamarine burnished black steel 28 4800.84
-Manufacturer#1 almond antique chartreuse lavender yellow 34 3386.42
Manufacturer#1 almond aquamarine pink moccasin thistle 42 1632.66
-Manufacturer#2 almond aquamarine midnight light salmon 2 8923.62
Manufacturer#2 almond antique violet chocolate turquoise 14 6891.639999999999
-Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 5200.96
-Manufacturer#2 almond aquamarine rose maroon antique 25 3499.36
Manufacturer#2 almond antique violet turquoise frosted 40 1800.7
-Manufacturer#3 almond antique misty red olive 1 7532.610000000001
-Manufacturer#3 almond antique forest lavender goldenrod 14 5609.63
+Manufacturer#2 almond aquamarine midnight light salmon 2 8923.62
+Manufacturer#2 almond aquamarine rose maroon antique 25 3499.36
+Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 5200.96
Manufacturer#3 almond antique chartreuse khaki white 17 4419.360000000001
+Manufacturer#3 almond antique forest lavender goldenrod 14 5609.63
Manufacturer#3 almond antique metallic orange dim 19 2747.6800000000003
+Manufacturer#3 almond antique misty red olive 1 7532.610000000001
Manufacturer#3 almond antique olive coral navajo 45 1337.29
-Manufacturer#4 almond aquamarine yellow dodger mint 7 7337.620000000001
Manufacturer#4 almond antique gainsboro frosted violet 10 5492.7
-Manufacturer#4 almond azure aquamarine papaya violet 12 3872.0299999999997
-Manufacturer#4 almond aquamarine floral ivory bisque 27 2581.6800000000003
Manufacturer#4 almond antique violet mint lemon 39 1375.42
-Manufacturer#5 almond antique sky peru orange 2 7672.660000000002
-Manufacturer#5 almond antique medium spring khaki 6 5883.93
-Manufacturer#5 almond azure blanched chiffon midnight 23 4272.27
+Manufacturer#4 almond aquamarine floral ivory bisque 27 2581.6800000000003
+Manufacturer#4 almond aquamarine yellow dodger mint 7 7337.620000000001
+Manufacturer#4 almond azure aquamarine papaya violet 12 3872.0299999999997
Manufacturer#5 almond antique blue firebrick mint 31 2807.79
+Manufacturer#5 almond antique medium spring khaki 6 5883.93
+Manufacturer#5 almond antique sky peru orange 2 7672.660000000002
Manufacturer#5 almond aquamarine dodger light gainsboro 46 1018.1
+Manufacturer#5 almond azure blanched chiffon midnight 23 4272.27
PREHOOK: query: -- 44. testOverNoPartitionSingleAggregate
select p_name, p_retailprice,
round(avg(p_retailprice) over(),2)
@@ -2316,10 +2320,10 @@ POSTHOOK: Input: default@part
#### A masked pattern was here ####
1173.15 1458.2883333333336 8749.730000000001
1173.15 1515.3160000000003 7576.580000000002
-1753.76 1600.8575000000003 6403.430000000001
-1602.59 1549.8900000000003 4649.670000000001
1414.42 1523.5400000000004 3047.080000000001
+1602.59 1549.8900000000003 4649.670000000001
1632.66 1632.6600000000008 1632.6600000000008
+1753.76 1600.8575000000003 6403.430000000001
PREHOOK: query: -- 47. empty partition
select sum(p_size) over (partition by p_mfgr )
from part where p_mfgr = 'm1'
Modified: hive/branches/spark/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/WritableByteObjectInspector.java
URL: http://svn.apache.org/viewvc/hive/branches/spark/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/WritableByteObjectInspector.java?rev=1651213&r1=1651212&r2=1651213&view=diff
==============================================================================
--- hive/branches/spark/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/WritableByteObjectInspector.java (original)
+++ hive/branches/spark/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/WritableByteObjectInspector.java Mon Jan 12 22:08:32 2015
@@ -33,17 +33,17 @@ public class WritableByteObjectInspector
@Override
public byte get(Object o) {
- return ((ByteWritable) o).get();
+ return ((org.apache.hadoop.io.ByteWritable) o).get();
}
@Override
public Object copyObject(Object o) {
- return o == null ? null : new ByteWritable(((ByteWritable) o).get());
+ return o == null ? null : new ByteWritable(get(o));
}
@Override
public Object getPrimitiveJavaObject(Object o) {
- return o == null ? null : Byte.valueOf(((ByteWritable) o).get());
+ return o == null ? null : Byte.valueOf(get(o));
}
@Override
@@ -53,7 +53,7 @@ public class WritableByteObjectInspector
@Override
public Object set(Object o, byte value) {
- ((ByteWritable) o).set(value);
+ ((org.apache.hadoop.io.ByteWritable) o).set(value);
return o;
}
}
Modified: hive/branches/spark/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/WritableDoubleObjectInspector.java
URL: http://svn.apache.org/viewvc/hive/branches/spark/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/WritableDoubleObjectInspector.java?rev=1651213&r1=1651212&r2=1651213&view=diff
==============================================================================
--- hive/branches/spark/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/WritableDoubleObjectInspector.java (original)
+++ hive/branches/spark/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/WritableDoubleObjectInspector.java Mon Jan 12 22:08:32 2015
@@ -33,17 +33,17 @@ public class WritableDoubleObjectInspect
@Override
public double get(Object o) {
- return ((DoubleWritable) o).get();
+ return ((org.apache.hadoop.io.DoubleWritable) o).get();
}
@Override
public Object copyObject(Object o) {
- return o == null ? null : new DoubleWritable(((DoubleWritable) o).get());
+ return o == null ? null : new DoubleWritable(get(o));
}
@Override
public Object getPrimitiveJavaObject(Object o) {
- return o == null ? null : Double.valueOf(((DoubleWritable) o).get());
+ return o == null ? null : Double.valueOf(get(o));
}
@Override
@@ -53,7 +53,7 @@ public class WritableDoubleObjectInspect
@Override
public Object set(Object o, double value) {
- ((DoubleWritable) o).set(value);
+ ((org.apache.hadoop.io.DoubleWritable) o).set(value);
return o;
}