hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sze...@apache.org
Subject 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/...
Date Mon, 12 Jan 2015 22:08:34 GMT
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;
   }
 



Mime
View raw message