hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject svn commit: r1471691 [2/5] - in /hive/branches/branch-0.11/ql/src/test: queries/clientpositive/ results/clientpositive/
Date Wed, 24 Apr 2013 21:29:59 GMT
Modified: hive/branches/branch-0.11/ql/src/test/results/clientpositive/ptf_general_queries.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.11/ql/src/test/results/clientpositive/ptf_general_queries.q.out?rev=1471691&r1=1471690&r2=1471691&view=diff
==============================================================================
--- hive/branches/branch-0.11/ql/src/test/results/clientpositive/ptf_general_queries.q.out
(original)
+++ hive/branches/branch-0.11/ql/src/test/results/clientpositive/ptf_general_queries.q.out
Wed Apr 24 21:29:59 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



Mime
View raw message