hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From amareshw...@apache.org
Subject svn commit: r1476039 [21/22] - in /hive/branches/HIVE-4115: ./ beeline/ beeline/src/java/org/apache/hive/beeline/ bin/ builtins/ cli/ common/src/java/org/apache/hadoop/hive/conf/ conf/ data/files/ eclipse-templates/ hbase-handler/ hbase-handler/src/jav...
Date Fri, 26 Apr 2013 04:59:58 GMT
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_expressions.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_expressions.q.out?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_expressions.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_expressions.q.out Fri Apr 26 04:59:50 2013
@@ -77,7 +77,7 @@ POSTHOOK: query: load data local inpath 
 POSTHOOK: type: LOAD
 POSTHOOK: Output: default@over10k
 PREHOOK: query: select p_mfgr, p_retailprice, p_size,
-round(sum(p_retailprice),2) = round((sum(lag(p_retailprice,1)) - first_value(p_retailprice)) + last_value(p_retailprice),2) 
+round(sum(p_retailprice),2) = round(sum(lag(p_retailprice,1,0.0)) + last_value(p_retailprice),2) 
   over(distribute by p_mfgr sort by p_retailprice),
 max(p_retailprice) - min(p_retailprice) = last_value(p_retailprice) - first_value(p_retailprice)
   over(distribute by p_mfgr sort by p_retailprice)
@@ -86,7 +86,7 @@ PREHOOK: type: QUERY
 PREHOOK: Input: default@part
 #### A masked pattern was here ####
 POSTHOOK: query: select p_mfgr, p_retailprice, p_size,
-round(sum(p_retailprice),2) = round((sum(lag(p_retailprice,1)) - first_value(p_retailprice)) + last_value(p_retailprice),2) 
+round(sum(p_retailprice),2) = round(sum(lag(p_retailprice,1,0.0)) + last_value(p_retailprice),2) 
   over(distribute by p_mfgr sort by p_retailprice),
 max(p_retailprice) - min(p_retailprice) = last_value(p_retailprice) - first_value(p_retailprice)
   over(distribute by p_mfgr sort by p_retailprice)
@@ -162,119 +162,119 @@ Manufacturer#5	1464.48	23	2	2482.58	2477
 Manufacturer#5	1611.66	6	3	4094.24	4089.24
 Manufacturer#5	1788.73	2	4	5882.969999999999	5877.969999999999
 Manufacturer#5	1789.69	31	5	7672.66	7667.66
-PREHOOK: query: select s, si, f, si - lead(f, 3) over (partition by t order by bo desc) from over10k limit 100
+PREHOOK: query: select s, si, f, si - lead(f, 3) over (partition by t order by bo,s,si,f desc) from over10k limit 100
 PREHOOK: type: QUERY
 PREHOOK: Input: default@over10k
 #### A masked pattern was here ####
-POSTHOOK: query: select s, si, f, si - lead(f, 3) over (partition by t order by bo desc) from over10k limit 100
+POSTHOOK: query: select s, si, f, si - lead(f, 3) over (partition by t order by bo,s,si,f desc) from over10k limit 100
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 #### A masked pattern was here ####
-david hernandez	408	81.68	352.41
-mike allen	465	83.39	441.78
-sarah miller	386	58.81	297.22
-luke king	337	55.59	256.35
-nick robinson	350	23.22	349.17
-katie ichabod	469	88.78	400.27
-gabriella brown	498	80.65	415.26
-oscar davidson	432	0.83	350.05
-holly nixon	505	68.73	502.74
-holly polk	268	82.74	202.5
-rachel davidson	507	81.95	498.63
-mike polk	500	2.26	443.8
-yuri xylophone	430	65.5	357.74
-bob ellison	339	8.37	254.25
-luke ichabod	289	56.2	203.04001
-nick nixon	335	72.26	282.7
-holly thompson	387	84.75	331.59
-jessica miller	299	85.96	298.44
-calvin white	280	52.3	232.49
-oscar johnson	469	55.41	406.88
-rachel thompson	344	0.56	279.71
-david falkner	469	47.51	374.78
-mike white	454	62.12	431.65
-irene young	458	64.29	396.19
-oscar johnson	315	94.22	300.77
-bob johnson	374	22.35	345.22
-victor robinson	415	61.81	333.03
-ethan underhill	339	14.23	257.36
-xavier ovid	280	28.78	198.61
-mike xylophone	448	81.97	429.56
-tom hernandez	467	81.64	428.95
-tom steinbeck	414	81.39	316.12
-alice falkner	280	18.44	182.48999
-david carson	270	38.05	217.87
-sarah zipper	376	97.88	368.9
-tom hernandez	477	97.51	438.78
-victor thompson	344	52.13	332.93
-ulysses carson	343	7.1	282.72
-sarah xylophone	275	38.22	268.2
-oscar miller	324	11.07	251.7
-quinn polk	507	60.28	463.6
-luke young	451	6.8	422.25
-bob underhill	465	72.3	452.88
-victor allen	337	43.4	330.17
-xavier garcia	493	28.75	396.22
-zach thompson	386	12.12	293.29
-bob van buren	433	6.83	423.14
-fred ellison	376	96.78	304.03
-jessica king	459	92.71	399.93
+alice allen	400	76.31	337.23
+alice davidson	384	71.97	357.79
+alice king	455	2.48	395.93
+alice king	458	62.77	384.16998
+alice xylophone	485	26.21	464.05
+bob falkner	260	59.07	242.4
+bob ichabod	454	73.83	381.7
+bob polk	264	20.95	257.17
+bob underhill	454	17.6	424.94
+bob underhill	465	72.3	453.17
+bob van buren	433	6.83	398.4
+calvin ichabod	431	29.06	334.22
+david garcia	485	11.83	421.51
+ethan steinbeck	298	34.6	288.14
+fred ellison	376	96.78	330.76
+holly steinbeck	384	63.49	293.7
 holly underhill	318	9.86	269.91
-alice davidson	384	71.97	340.31
-bob falkner	260	59.07	237.66
-jessica johnson	494	48.09	468.5
-victor hernandez	447	43.69	427.06
-ulysses steinbeck	333	22.34	273.66
-wendy quirinius	279	25.5	257.0
-quinn ellison	266	19.94	181.61
-ulysses ellison	381	59.34	377.18
-priscilla laertes	316	22.0	244.22
-sarah robinson	320	84.39	298.66
-luke garcia	311	3.82	290.05
-wendy robinson	275	71.78	231.27
-priscilla zipper	485	21.34	422.19
-bob polk	264	20.95	187.69
-oscar garcia	362	43.73	351.74
-jessica white	284	62.81	238.76
-alice allen	400	76.31	370.94
-ulysses quirinius	303	10.26	268.4
-irene ellison	458	45.24	394.51
-calvin ichabod	431	29.06	356.08002
-ethan steinbeck	298	34.6	234.81
-holly steinbeck	384	63.49	365.73
-mike king	275	74.92	261.33
-priscilla quirinius	423	63.19	360.61
-zach young	286	18.27	223.23
-wendy xylophone	314	13.67	223.7
-victor xylophone	438	62.39	420.4
-alice king	458	62.77	455.52
-irene underhill	307	90.3	295.17
-bob underhill	454	17.6	427.79
-alice king	455	2.48	381.16998
-david garcia	485	11.83	428.95
-alice xylophone	485	26.21	459.33
-bob ichabod	454	73.83	NULL
-tom polk	346	56.05	NULL
-ulysses robinson	313	25.67	NULL
-nick laertes	502	48.26	462.38
-oscar zipper	445	35.62	420.6
-nick falkner	384	1.65	378.41
-irene ichabod	409	39.62	321.22
-wendy ichabod	387	24.4	310.48
-ethan quirinius	503	5.59	431.97
-alice carson	473	87.78	455.91
-quinn laertes	340	76.52	295.12
-tom xylophone	352	71.03	295.24
-tom ellison	420	17.09	346.94
-fred ichabod	371	44.88	298.41
-luke xylophone	395	56.76	319.22
-quinn hernandez	456	73.06	439.65
-ethan falkner	261	72.59	212.26
-PREHOOK: query: select s, i, i - lead(i, 3, 0) over (partition by si order by i) from over10k limit 100
+irene ellison	458	45.24	365.29
+irene underhill	307	90.3	244.19
+jessica johnson	494	48.09	490.18
+jessica king	459	92.71	452.2
+jessica white	284	62.81	209.08
+luke garcia	311	3.82	267.27
+luke young	451	6.8	429.0
+mike king	275	74.92	211.81
+oscar garcia	362	43.73	340.66
+priscilla laertes	316	22.0	296.06
+priscilla quirinius	423	63.19	362.72
+priscilla zipper	485	21.34	400.61
+quinn ellison	266	19.94	209.95
+quinn polk	507	60.28	447.66
+sarah robinson	320	84.39	309.74
+tom polk	346	56.05	320.33
+ulysses ellison	381	59.34	358.66
+ulysses quirinius	303	10.26	259.6
+ulysses robinson	313	25.67	269.31
+ulysses steinbeck	333	22.34	270.61
+victor allen	337	43.4	311.5
+victor hernandez	447	43.69	375.22
+victor xylophone	438	62.39	424.33
+wendy quirinius	279	25.5	250.25
+wendy robinson	275	71.78	262.88
+wendy xylophone	314	13.67	295.73
+xavier garcia	493	28.75	474.56
+zach thompson	386	12.12	377.63
+zach young	286	18.27	263.65
+alice falkner	280	18.44	227.7
+bob ellison	339	8.37	300.95
+bob johnson	374	22.35	326.49
+calvin white	280	52.3	198.32
+david carson	270	38.05	255.77
+david falkner	469	47.51	388.35
+david hernandez	408	81.68	339.27
+ethan underhill	339	14.23	256.26
+gabriella brown	498	80.65	413.25
+holly nixon	505	68.73	440.71
+holly polk	268	82.74	182.04001
+holly thompson	387	84.75	298.22
+irene young	458	64.29	401.8
+jessica miller	299	85.96	243.41
+katie ichabod	469	88.78	385.61
+luke ichabod	289	56.2	286.74
+luke king	337	55.59	274.88
+mike allen	465	83.39	383.03
+mike polk	500	2.26	427.74
+mike white	454	62.12	430.78
+mike xylophone	448	81.97	447.17
+nick nixon	335	72.26	240.78
+nick robinson	350	23.22	294.59
+oscar davidson	432	0.83	420.93
+oscar johnson	315	94.22	233.05
+oscar johnson	469	55.41	468.44
+oscar miller	324	11.07	265.19
+rachel davidson	507	81.95	468.78
+rachel thompson	344	0.56	246.12
+sarah miller	386	58.81	304.36
+sarah xylophone	275	38.22	177.48999
+sarah zipper	376	97.88	294.61
+tom hernandez	467	81.64	459.9
+tom hernandez	477	97.51	415.19
+tom steinbeck	414	81.39	361.87
+ulysses carson	343	7.1	314.22
+victor robinson	415	61.81	349.5
+victor thompson	344	52.13	NULL
+xavier ovid	280	28.78	NULL
+yuri xylophone	430	65.5	NULL
+alice underhill	389	26.68	368.06
+alice underhill	446	6.49	444.21
+bob ovid	331	67.12	236.43
+bob van buren	406	20.94	383.32
+david falkner	406	1.79	374.34
+david miller	450	94.57	380.13
+ethan allen	380	22.68	375.6
+ethan king	395	31.66	361.51
+ethan nixon	475	69.87	431.39
+ethan polk	283	4.4	243.82
+fred allen	331	33.49	281.68
+fred king	511	43.61	457.22
+fred polk	261	39.18	248.73
+fred young	303	49.32	221.51001
+PREHOOK: query: select s, i, i - lead(i, 3, 0) over (partition by si order by i,s) from over10k limit 100
 PREHOOK: type: QUERY
 PREHOOK: Input: default@over10k
 #### A masked pattern was here ####
-POSTHOOK: query: select s, i, i - lead(i, 3, 0) over (partition by si order by i) from over10k limit 100
+POSTHOOK: query: select s, i, i - lead(i, 3, 0) over (partition by si order by i,s) from over10k limit 100
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 #### A masked pattern was here ####
@@ -288,8 +288,8 @@ ethan falkner	65586	-18
 victor davidson	65596	-17
 xavier quirinius	65599	-14
 fred quirinius	65604	-11
-xavier van buren	65613	-3
-nick zipper	65613	-7
+nick zipper	65613	-3
+xavier van buren	65613	-7
 victor johnson	65615	-12
 alice ovid	65616	-24
 xavier ovid	65620	-23
@@ -307,8 +307,8 @@ zach white	65733	-8
 fred hernandez	65737	-7
 rachel ellison	65738	-6
 oscar steinbeck	65741	-6
-tom allen	65744	-8
-alice ellison	65744	-19
+alice ellison	65744	-8
+tom allen	65744	-19
 quinn quirinius	65747	-31
 victor hernandez	65752	-26
 holly xylophone	65763	-26
@@ -328,14 +328,14 @@ victor xylophone	65578	-16
 gabriella ellison	65584	-26
 nick quirinius	65588	-22
 holly robinson	65594	-18
-yuri brown	65610	-16
-alice xylophone	65610	-21
+alice xylophone	65610	-16
+yuri brown	65610	-21
 sarah hernandez	65612	-26
 katie garcia	65626	-28
 jessica laertes	65631	-23
 ethan underhill	65638	-17
-priscilla thompson	65654	-37
-irene young	65654	-40
+irene young	65654	-37
+priscilla thompson	65654	-40
 luke quirinius	65655	-44
 david brown	65691	-20
 luke falkner	65694	-18
@@ -351,16 +351,16 @@ ulysses young	65748	-23
 nick davidson	65752	-19
 fred zipper	65756	-15
 yuri nixon	65771	-10
-zach zipper	65771	-19
-zach hernandez	65771	65771
+zach hernandez	65771	-19
+zach zipper	65771	65771
 alice underhill	65781	65781
 oscar laertes	65790	65790
 sarah zipper	65546	-19
-luke ovid	65551	-17
 bob falkner	65551	-17
+luke ovid	65551	-17
 katie allen	65565	-4
-zach steinbeck	65568	-5
-nick falkner	65568	-11
+nick falkner	65568	-5
+zach steinbeck	65568	-11
 oscar van buren	65569	-13
 gabriella young	65573	-11
 jessica ichabod	65579	-24
@@ -373,16 +373,16 @@ jessica laertes	65617	-62
 fred king	65656	-61
 priscilla underhill	65669	-48
 priscilla zipper	65679	-45
-sarah polk	65717	-11
-nick king	65717	-17
+nick king	65717	-11
+sarah polk	65717	-17
 irene quirinius	65724	-28
 tom laertes	65728	-25
 yuri johnson	65734	-27
-PREHOOK: query: select s, si, d, si - lag(d, 3) over (partition by b order by si) from over10k limit 100
+PREHOOK: query: select s, si, d, si - lag(d, 3) over (partition by b order by si,s,d) from over10k limit 100
 PREHOOK: type: QUERY
 PREHOOK: Input: default@over10k
 #### A masked pattern was here ####
-POSTHOOK: query: select s, si, d, si - lag(d, 3) over (partition by b order by si) from over10k limit 100
+POSTHOOK: query: select s, si, d, si - lag(d, 3) over (partition by b order by si,s,d) from over10k limit 100
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 #### A masked pattern was here ####
@@ -420,18 +420,18 @@ ethan ellison	453	47.92	405.78
 irene nixon	454	48.03	421.40999999999997
 bob steinbeck	462	47.04	442.37
 luke robinson	462	47.48	414.08
-tom hernandez	467	29.36	418.97
-gabriella steinbeck	467	9.35	419.96
+gabriella steinbeck	467	9.35	418.97
+tom hernandez	467	29.36	419.96
 irene polk	485	14.26	437.52
-mike xylophone	494	36.92	464.64
-calvin allen	499	39.99	489.65
+mike xylophone	494	36.92	484.65
+calvin allen	499	39.99	469.64
 quinn steinbeck	503	16.62	488.74
-ulysses garcia	263	31.85	NULL
 calvin thompson	263	30.87	NULL
 rachel quirinius	263	29.46	NULL
-mike steinbeck	266	48.57	234.15
-rachel young	275	14.75	244.13
-tom king	278	31.11	248.54
+ulysses garcia	263	31.85	NULL
+mike steinbeck	266	48.57	235.13
+rachel young	275	14.75	245.54
+tom king	278	31.11	246.15
 oscar robinson	283	30.35	234.43
 zach allen	284	1.88	269.25
 bob king	308	27.61	276.89
@@ -455,11 +455,11 @@ sarah xylophone	507	16.09	499.97
 rachel thompson	267	46.87	NULL
 gabriella van buren	271	41.04	NULL
 mike steinbeck	284	11.44	NULL
-luke falkner	293	40.67	246.13
-ethan ovid	293	2.08	251.96
+ethan ovid	293	2.08	246.13
+luke falkner	293	40.67	251.96
 irene nixon	321	24.35	309.56
-mike van buren	327	2.58	286.33
-ulysses robinson	329	26.64	326.92
+mike van buren	327	2.58	324.92
+ulysses robinson	329	26.64	288.33
 quinn laertes	332	10.71	307.65
 tom polk	346	34.03	343.42
 jessica johnson	352	45.71	325.36
@@ -674,12 +674,12 @@ PREHOOK: type: CREATETABLE
 POSTHOOK: query: create table t2 (a1 int, b1 string)
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: default@t2
-PREHOOK: query: from (select sum(i) over (), s from over10k) tt insert overwrite table t1 select * insert overwrite table t2 select *
+PREHOOK: query: from (select sum(i) over (partition by ts order by i), s from over10k) tt insert overwrite table t1 select * insert overwrite table t2 select *
 PREHOOK: type: QUERY
 PREHOOK: Input: default@over10k
 PREHOOK: Output: default@t1
 PREHOOK: Output: default@t2
-POSTHOOK: query: from (select sum(i) over (), s from over10k) tt insert overwrite table t1 select * insert overwrite table t2 select *
+POSTHOOK: query: from (select sum(i) over (partition by ts order by i), s from over10k) tt insert overwrite table t1 select * insert overwrite table t2 select *
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 POSTHOOK: Output: default@t1
@@ -700,9 +700,9 @@ POSTHOOK: Lineage: t1.a1 SCRIPT [(over10
 POSTHOOK: Lineage: t1.b1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: t2.a1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: t2.b1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-656584379	bob davidson
-656584379	alice zipper
-656584379	katie davidson
+65542	rachel thompson
+131088	oscar brown
+262258	wendy steinbeck
 PREHOOK: query: select * from t2 limit 3
 PREHOOK: type: QUERY
 PREHOOK: Input: default@t2
@@ -715,6 +715,37 @@ POSTHOOK: Lineage: t1.a1 SCRIPT [(over10
 POSTHOOK: Lineage: t1.b1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: t2.a1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: t2.b1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-656584379	bob davidson
-656584379	alice zipper
-656584379	katie davidson
+65542	rachel thompson
+131088	oscar brown
+262258	wendy steinbeck
+PREHOOK: query: select p_mfgr, p_retailprice, p_size,
+round(sum(p_retailprice),2) + 50.0 = round(sum(lag(p_retailprice,1,50.0)) + last_value(p_retailprice),2) 
+  over(distribute by p_mfgr sort by p_retailprice)
+from part
+limit 11
+PREHOOK: type: QUERY
+PREHOOK: Input: default@part
+#### A masked pattern was here ####
+POSTHOOK: query: select p_mfgr, p_retailprice, p_size,
+round(sum(p_retailprice),2) + 50.0 = round(sum(lag(p_retailprice,1,50.0)) + last_value(p_retailprice),2) 
+  over(distribute by p_mfgr sort by p_retailprice)
+from part
+limit 11
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@part
+#### A masked pattern was here ####
+POSTHOOK: Lineage: t1.a1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: t1.b1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: t2.a1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: t2.b1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+Manufacturer#1	1173.15	2	true
+Manufacturer#1	1173.15	2	true
+Manufacturer#1	1414.42	28	true
+Manufacturer#1	1602.59	6	true
+Manufacturer#1	1632.66	42	true
+Manufacturer#1	1753.76	34	true
+Manufacturer#2	1690.68	14	true
+Manufacturer#2	1698.66	25	true
+Manufacturer#2	1701.6	18	true
+Manufacturer#2	1800.7	40	true
+Manufacturer#2	2031.98	2	true

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_multipartitioning.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_multipartitioning.q.out?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_multipartitioning.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_multipartitioning.q.out Fri Apr 26 04:59:50 2013
@@ -271,44 +271,44 @@ bob steinbeck	5	1
 tom allen	1	1
 bob steinbeck	1	1
 tom allen	7	2
-PREHOOK: query: select s, sum(f) over (partition by i), row_number() over () from over10k where s = 'tom allen' or s = 'bob steinbeck'
+PREHOOK: query: select s, sum(f) over (partition by i), row_number() over (order by f) from over10k where s = 'tom allen' or s = 'bob steinbeck'
 PREHOOK: type: QUERY
 PREHOOK: Input: default@over10k
 #### A masked pattern was here ####
-POSTHOOK: query: select s, sum(f) over (partition by i), row_number() over () from over10k where s = 'tom allen' or s = 'bob steinbeck'
+POSTHOOK: query: select s, sum(f) over (partition by i), row_number() over (order by f) from over10k where s = 'tom allen' or s = 'bob steinbeck'
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 #### A masked pattern was here ####
-bob steinbeck	47.810001373291016	1
-tom allen	11.069999694824219	2
-tom allen	54.00000190734863	3
-tom allen	54.00000190734863	4
-tom allen	26.239999771118164	5
-bob steinbeck	28.479999542236328	6
-tom allen	81.8499984741211	7
-tom allen	15.84000015258789	8
-bob steinbeck	83.52999877929688	9
-bob steinbeck	38.33000183105469	10
-bob steinbeck	83.52999877929688	11
-bob steinbeck	80.7300033569336	12
-bob steinbeck	9.699999809265137	13
-tom allen	89.88999938964844	14
-bob steinbeck	26.290000915527344	15
-bob steinbeck	36.209999084472656	16
-tom allen	52.779998779296875	17
-tom allen	11.300000190734863	18
-tom allen	77.77999877929688	19
-tom allen	40.5099983215332	20
-bob steinbeck	82.19000244140625	21
-tom allen	83.47000122070312	22
-tom allen	38.93000030517578	23
-tom allen	47.16999816894531	24
-tom allen	19.459999084472656	25
-tom allen	50.630001068115234	26
-bob steinbeck	27.959999084472656	27
-tom allen	2.8499999046325684	28
-tom allen	95.41000366210938	29
-tom allen	55.38999938964844	30
+tom allen	2.8499999046325684	1
+bob steinbeck	9.699999809265137	2
+tom allen	11.069999694824219	3
+tom allen	11.300000190734863	4
+tom allen	54.00000190734863	5
+tom allen	15.84000015258789	6
+tom allen	19.459999084472656	7
+tom allen	26.239999771118164	8
+bob steinbeck	26.290000915527344	9
+bob steinbeck	27.959999084472656	10
+bob steinbeck	28.479999542236328	11
+bob steinbeck	36.209999084472656	12
+bob steinbeck	38.33000183105469	13
+tom allen	38.93000030517578	14
+tom allen	54.00000190734863	15
+tom allen	40.5099983215332	16
+tom allen	47.16999816894531	17
+bob steinbeck	47.810001373291016	18
+tom allen	50.630001068115234	19
+tom allen	52.779998779296875	20
+tom allen	55.38999938964844	21
+tom allen	77.77999877929688	22
+bob steinbeck	80.7300033569336	23
+tom allen	81.8499984741211	24
+bob steinbeck	82.19000244140625	25
+tom allen	83.47000122070312	26
+bob steinbeck	83.52999877929688	27
+bob steinbeck	83.52999877929688	28
+tom allen	89.88999938964844	29
+tom allen	95.41000366210938	30
 PREHOOK: query: select s, rank() over w1, 
 rank() over w2 
 from over10k 

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_navfn.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_navfn.q.out?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_navfn.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_navfn.q.out Fri Apr 26 04:59:50 2013
@@ -147,119 +147,119 @@ david garcia	1
 holly hernandez	2
 tom white	3
 rachel ellison	1
-PREHOOK: query: select i, lead(s) over (partition by bin order by d desc) from over10k limit 100
+PREHOOK: query: select i, lead(s) over (partition by bin order by d,i desc) from over10k limit 100
 PREHOOK: type: QUERY
 PREHOOK: Input: default@over10k
 #### A masked pattern was here ####
-POSTHOOK: query: select i, lead(s) over (partition by bin order by d desc) from over10k limit 100
+POSTHOOK: query: select i, lead(s) over (partition by bin order by d,i desc) from over10k limit 100
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 #### A masked pattern was here ####
-65551	sarah steinbeck
-65575	holly underhill
-65779	yuri thompson
-65603	irene brown
-65700	alice ovid
-65761	zach polk
-65662	bob king
-65646	irene garcia
-65683	sarah underhill
-65732	bob underhill
-65683	david robinson
-65680	irene nixon
-65771	david young
-65698	ulysses johnson
-65776	priscilla nixon
-65677	jessica thompson
-65575	jessica ovid
-65546	irene zipper
-65689	nick king
-65732	katie laertes
-65559	bob quirinius
-65572	alice davidson
-65690	bob zipper
-65659	yuri ellison
-65536	ulysses garcia
-65762	mike hernandez
-65537	david laertes
-65720	tom johnson
-65536	wendy brown
-65728	alice steinbeck
-65599	ethan brown
-65598	gabriella zipper
-65738	oscar king
-65550	katie falkner
-65621	sarah hernandez
-65540	mike allen
-65646	sarah thompson
-65716	fred laertes
-65603	ulysses underhill
-65745	zach davidson
-65791	katie garcia
-65661	quinn carson
-65644	katie laertes
-65745	mike garcia
-65669	bob carson
-65775	irene van buren
-65589	sarah young
-65758	quinn nixon
-65677	wendy ichabod
-65725	ethan thompson
-65768	sarah king
-65784	irene polk
-65670	holly king
-65759	irene young
-65679	nick laertes
-65740	wendy nixon
-65746	holly van buren
-65572	xavier johnson
-65607	irene van buren
-65671	alice king
-65538	katie van buren
-65649	tom quirinius
-65540	quinn white
-65660	zach ellison
-65692	alice quirinius
-65577	ethan hernandez
-65553	calvin robinson
-65758	mike garcia
-65692	ethan nixon
-65766	mike ichabod
-65571	irene johnson
-65568	yuri xylophone
-65667	nick ellison
-65691	ethan brown
-65791	quinn ovid
-65573	zach thompson
-65551	alice garcia
-65759	ulysses king
-65732	gabriella laertes
-65609	bob garcia
-65585	priscilla robinson
-65640	xavier ellison
-65647	fred zipper
-65735	quinn polk
-65625	victor robinson
-65746	bob steinbeck
-65617	katie allen
-65658	quinn davidson
-65659	victor allen
-65707	alice falkner
-65775	zach nixon
-65752	tom polk
-65700	nick brown
-65587	bob van buren
-65661	katie polk
-65680	rachel polk
-65634	rachel king
-65756	xavier ichabod
-65783	luke garcia
-65650	tom carson
-PREHOOK: query: select i, lag(dec) over (partition by i order by s) from over10k limit 100
+65773	gabriella van buren
+65727	quinn steinbeck
+65649	katie laertes
+65643	luke young
+65712	xavier white
+65554	oscar garcia
+65715	katie ichabod
+65737	mike garcia
+65641	katie thompson
+65674	zach falkner
+65627	katie ovid
+65628	irene davidson
+65657	wendy van buren
+65686	yuri ichabod
+65594	ethan underhill
+65615	zach young
+65708	calvin falkner
+65674	nick xylophone
+65717	tom hernandez
+65713	tom ichabod
+65681	priscilla ichabod
+65654	victor laertes
+65580	victor van buren
+65711	holly xylophone
+65727	david garcia
+65692	yuri ovid
+65760	oscar xylophone
+65545	luke falkner
+65653	alice falkner
+65773	jessica robinson
+65756	fred davidson
+65698	tom hernandez
+65659	irene ellison
+65662	holly robinson
+65610	mike garcia
+65537	yuri hernandez
+65601	ulysses garcia
+65545	mike brown
+65538	ethan nixon
+65551	yuri falkner
+65709	rachel robinson
+65774	yuri polk
+65713	yuri nixon
+65613	sarah thompson
+65693	nick nixon
+65650	ethan carson
+65781	oscar king
+65675	priscilla ichabod
+65541	jessica thompson
+65719	mike polk
+65694	luke brown
+65538	victor young
+65746	oscar nixon
+65564	tom zipper
+65708	irene ellison
+65696	alice davidson
+65596	jessica garcia
+65586	victor miller
+65696	holly white
+65600	david robinson
+65785	jessica davidson
+65606	ulysses brown
+65734	ethan underhill
+65546	ethan miller
+65578	tom thompson
+65776	holly steinbeck
+65741	yuri underhill
+65770	priscilla king
+65562	bob white
+65605	victor van buren
+65764	bob allen
+65725	david underhill
+65700	holly king
+65648	victor ovid
+65733	priscilla xylophone
+65682	katie miller
+65694	victor xylophone
+65553	mike steinbeck
+65635	holly laertes
+65537	katie steinbeck
+65761	zach white
+65747	ethan falkner
+65601	ulysses king
+65590	rachel davidson
+65732	irene young
+65642	bob thompson
+65570	tom xylophone
+65692	sarah davidson
+65760	tom laertes
+65784	yuri johnson
+65630	zach laertes
+65774	nick polk
+65788	quinn xylophone
+65595	yuri white
+65765	xavier ellison
+65541	jessica ichabod
+65711	tom steinbeck
+65536	alice hernandez
+65545	tom zipper
+65789	ulysses hernandez
+PREHOOK: query: select i, lag(dec) over (partition by i order by s,i,dec) from over10k limit 100
 PREHOOK: type: QUERY
 PREHOOK: Input: default@over10k
 #### A masked pattern was here ####
-POSTHOOK: query: select i, lag(dec) over (partition by i order by s) from over10k limit 100
+POSTHOOK: query: select i, lag(dec) over (partition by i order by s,i,dec) from over10k limit 100
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 #### A masked pattern was here ####

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_ntile.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_ntile.q.out?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_ntile.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_ntile.q.out Fri Apr 26 04:59:50 2013
@@ -39,240 +39,240 @@ PREHOOK: Output: default@over10k
 POSTHOOK: query: load data local inpath '../data/files/over10k' into table over10k
 POSTHOOK: type: LOAD
 POSTHOOK: Output: default@over10k
-PREHOOK: query: select i, ntile(10) over (partition by s) from over10k limit 100
+PREHOOK: query: select i, ntile(10) over (partition by s order by i) from over10k limit 100
 PREHOOK: type: QUERY
 PREHOOK: Input: default@over10k
 #### A masked pattern was here ####
-POSTHOOK: query: select i, ntile(10) over (partition by s) from over10k limit 100
+POSTHOOK: query: select i, ntile(10) over (partition by s order by i) from over10k limit 100
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 #### A masked pattern was here ####
-65600	1
-65758	2
-65609	3
-65557	4
+65545	1
+65557	2
+65600	3
+65609	4
 65662	5
 65670	6
-65545	7
-65720	8
-65790	1
-65781	1
-65570	2
-65708	2
-65704	3
-65707	3
-65779	4
-65667	4
-65673	5
+65720	7
+65758	8
+65569	1
+65570	1
+65666	2
+65667	2
+65673	3
+65696	3
+65704	4
+65707	4
+65708	5
 65711	6
-65569	7
-65666	8
-65733	9
-65696	10
-65785	1
-65710	2
-65747	3
-65713	4
-65559	5
-65559	6
-65545	7
-65565	8
-65695	9
-65576	10
+65733	7
+65779	8
+65781	9
+65790	10
+65545	1
+65559	2
+65559	3
+65565	4
+65576	5
+65695	6
+65710	7
+65713	8
+65747	9
+65785	10
+65544	1
 65547	1
-65677	1
-65676	2
-65596	2
-65791	3
-65707	3
-65690	4
-65563	4
-65560	5
+65554	2
+65560	2
+65563	3
+65590	3
+65596	4
+65631	4
 65641	5
-65544	6
+65676	5
+65677	6
 65677	6
-65590	7
-65747	7
+65690	7
+65707	7
 65740	8
-65554	8
-65631	9
-65742	10
-65730	1
-65612	1
-65745	2
-65677	2
-65699	3
-65713	3
-65544	4
-65537	4
-65557	5
-65698	5
-65787	6
+65742	8
+65747	9
+65791	10
+65537	1
+65544	1
+65557	2
+65572	2
+65612	3
+65677	3
+65681	4
+65698	4
+65699	5
+65713	5
+65730	6
 65741	7
-65572	8
-65681	9
-65744	10
-65773	1
-65611	1
-65669	2
-65699	2
-65752	3
-65722	3
-65597	4
-65715	4
+65744	8
+65745	9
+65787	10
+65596	1
+65597	1
+65611	2
+65622	2
+65669	3
+65685	3
+65690	4
+65699	4
 65709	5
-65718	5
-65622	6
-65775	6
-65690	7
-65685	7
-65596	8
-65710	9
+65710	5
+65715	6
+65718	6
+65722	7
+65752	7
+65773	8
+65775	9
 65785	10
-65623	1
-65746	1
-65725	2
-65712	2
-65759	3
-65613	3
-65744	4
-65573	5
-65630	6
-65674	7
-65675	8
+65573	1
+65613	1
+65623	2
+65630	2
+65674	3
+65675	3
+65712	4
+65725	5
+65734	6
+65744	7
+65746	8
 65746	9
-65734	10
+65759	10
 65543	1
-65685	1
-65684	2
-65691	2
-65737	3
-PREHOOK: query: select s, ntile(100) over (partition by i) from over10k limit 100
+65545	1
+65569	2
+65603	2
+65633	3
+PREHOOK: query: select s, ntile(100) over (partition by i order by s) from over10k limit 100
 PREHOOK: type: QUERY
 PREHOOK: Input: default@over10k
 #### A masked pattern was here ####
-POSTHOOK: query: select s, ntile(100) over (partition by i) from over10k limit 100
+POSTHOOK: query: select s, ntile(100) over (partition by i order by s) from over10k limit 100
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 #### A masked pattern was here ####
-rachel ichabod	1
+alice ichabod	1
 alice robinson	2
-priscilla young	3
-david laertes	4
-david nixon	5
-wendy polk	6
-alice ichabod	7
-holly white	8
-xavier davidson	9
-oscar ovid	10
-sarah thompson	11
-ethan johnson	12
-tom steinbeck	13
-katie ellison	14
-gabriella garcia	15
-luke allen	16
-zach hernandez	17
+bob robinson	3
+calvin thompson	4
+david johnson	5
+david laertes	6
+david nixon	7
+david nixon	8
+ethan johnson	9
+ethan ovid	10
+ethan underhill	11
+fred miller	12
+fred miller	13
+gabriella garcia	14
+gabriella underhill	15
+holly white	16
+irene johnson	17
+katie ellison	18
+luke allen	19
+mike quirinius	20
+mike white	21
+nick davidson	22
+oscar allen	23
+oscar garcia	24
+oscar ichabod	25
+oscar ovid	26
+oscar steinbeck	27
+priscilla garcia	28
+priscilla white	29
+priscilla xylophone	30
+priscilla young	31
+rachel brown	32
+rachel ichabod	33
+rachel xylophone	34
+sarah thompson	35
+sarah thompson	36
+tom johnson	37
+tom steinbeck	38
+ulysses polk	39
+victor johnson	40
+wendy polk	41
+xavier davidson	42
+yuri ellison	43
+zach allen	44
+zach hernandez	45
+alice ellison	1
+bob carson	2
+calvin brown	3
+david xylophone	4
+ethan white	5
+fred johnson	6
+fred van buren	7
+gabriella ichabod	8
+holly laertes	9
+holly quirinius	10
+jessica hernandez	11
+katie robinson	12
+katie thompson	13
+luke nixon	14
+mike garcia	15
+mike hernandez	16
+nick carson	17
 nick davidson	18
-zach allen	19
-sarah thompson	20
-david johnson	21
-bob robinson	22
-ethan ovid	23
-calvin thompson	24
-rachel brown	25
-rachel xylophone	26
-tom johnson	27
-ulysses polk	28
-oscar allen	29
-irene johnson	30
-oscar ichabod	31
-yuri ellison	32
-fred miller	33
-mike white	34
-david nixon	35
-priscilla white	36
-oscar garcia	37
-fred miller	38
-victor johnson	39
-oscar steinbeck	40
-priscilla garcia	41
-gabriella underhill	42
-priscilla xylophone	43
-mike quirinius	44
-ethan underhill	45
-oscar carson	1
-nick carson	2
-katie thompson	3
-victor xylophone	4
-xavier underhill	5
-zach nixon	6
-bob carson	7
-yuri garcia	8
-fred van buren	9
-sarah ichabod	10
-oscar robinson	11
-david xylophone	12
-wendy garcia	13
-mike garcia	14
-ulysses falkner	15
-sarah falkner	16
-mike hernandez	17
-fred johnson	18
-katie robinson	19
-holly quirinius	20
-luke nixon	21
-alice ellison	22
-yuri quirinius	23
-zach falkner	24
-zach ovid	25
-gabriella ichabod	26
-priscilla white	27
-ethan white	28
-calvin brown	29
-jessica hernandez	30
-wendy van buren	31
-holly laertes	32
+oscar carson	19
+oscar robinson	20
+priscilla white	21
+sarah falkner	22
+sarah ichabod	23
+ulysses falkner	24
+victor xylophone	25
+wendy garcia	26
+wendy van buren	27
+xavier underhill	28
+yuri garcia	29
+yuri quirinius	30
+yuri white	31
+zach falkner	32
 zach ichabod	33
-nick davidson	34
-yuri white	35
-victor garcia	1
-sarah ichabod	2
-mike brown	3
-holly thompson	4
-alice king	5
-quinn garcia	6
-holly hernandez	7
-gabriella nixon	8
-zach van buren	9
+zach nixon	34
+zach ovid	35
+alice ichabod	1
+alice king	2
+alice robinson	3
+calvin allen	4
+gabriella johnson	5
+gabriella nixon	6
+holly falkner	7
+holly hernandez	8
+holly thompson	9
 katie nixon	10
-luke davidson	11
-rachel young	12
-alice robinson	13
-oscar white	14
-holly falkner	15
-tom polk	16
-quinn laertes	17
-calvin allen	18
-luke brown	19
-xavier davidson	20
-PREHOOK: query: select f, ntile(4) over (partition by d) from over10k limit 100
+luke brown	11
+luke davidson	12
+luke white	13
+mike brown	14
+nick quirinius	15
+oscar white	16
+priscilla xylophone	17
+quinn garcia	18
+quinn laertes	19
+rachel young	20
+PREHOOK: query: select f, ntile(4) over (partition by d order by f) from over10k limit 100
 PREHOOK: type: QUERY
 PREHOOK: Input: default@over10k
 #### A masked pattern was here ####
-POSTHOOK: query: select f, ntile(4) over (partition by d) from over10k limit 100
+POSTHOOK: query: select f, ntile(4) over (partition by d order by f) from over10k limit 100
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 #### A masked pattern was here ####
 8.39	1
-25.5	1
-5.29	2
+5.29	1
+25.5	2
 37.59	3
 79.24	1
-60.0	1
-48.5	2
+48.5	1
+60.0	2
 77.84	3
-51.57	1
-14.36	2
+14.36	1
+51.57	2
 87.91	3
 40.91	1
 59.09	2
@@ -280,65 +280,65 @@ POSTHOOK: Input: default@over10k
 46.55	2
 92.71	3
 59.72	1
-98.89	2
-97.35	3
+97.35	2
+98.89	3
 19.11	1
-35.21	1
-13.33	2
+13.33	1
+35.21	2
 30.47	1
 90.04	1
-77.44	1
-15.36	2
-60.76	3
+15.36	1
+60.76	2
+77.44	3
 9.07	1
 50.08	1
 13.3	1
 87.05	1
-66.95	1
-3.94	2
-41.66	1
-75.93	2
+3.94	1
+66.95	2
+18.65	1
+41.66	2
 48.52	3
-18.65	4
-70.77	1
-84.83	2
-50.15	3
+75.93	4
+50.15	1
+70.77	2
+84.83	3
 64.79	1
 88.94	2
-96.71	1
-1.42	2
-94.14	1
-9.88	2
+1.42	1
+96.71	2
+9.88	1
+94.14	2
 25.69	1
 67.56	2
 85.72	3
-82.8	1
+30.0	1
 40.0	1
-95.11	2
-61.73	3
-30.0	4
+61.73	2
+82.8	3
+95.11	4
 80.65	1
-96.54	1
-7.96	2
-61.07	1
+7.96	1
+96.54	2
 20.74	1
-89.36	2
-49.61	3
-69.97	4
-61.71	1
+49.61	1
+61.07	2
+69.97	3
+89.36	4
+2.66	1
 38.69	2
-2.66	3
-58.25	4
+58.25	3
+61.71	4
 32.69	1
 98.29	2
-25.63	1
-0.62	2
+0.62	1
+25.63	2
 90.1	3
-69.42	1
-29.06	2
-85.03	1
-38.09	2
-68.81	3
+29.06	1
+69.42	2
+38.09	1
+68.81	2
+85.03	3
 75.75	1
 88.22	2
 24.02	1
@@ -346,100 +346,100 @@ POSTHOOK: Input: default@over10k
 76.99	1
 96.45	1
 1.09	1
-57.61	1
-84.92	2
-26.21	3
+26.21	1
+57.61	2
+84.92	3
 80.99	1
 39.16	1
 39.82	2
-44.57	1
-24.15	2
+24.15	1
+44.57	2
 38.05	1
 81.55	2
-74.45	1
-49.13	2
+49.13	1
+74.45	2
 42.49	1
-67.28	1
+37.63	1
 49.09	2
-37.63	3
+67.28	3
 10.6	1
-PREHOOK: query: select d, ntile(1000) over (partition by dec) from over10k limit 100
+PREHOOK: query: select d, ntile(1000) over (partition by dec order by d) from over10k limit 100
 PREHOOK: type: QUERY
 PREHOOK: Input: default@over10k
 #### A masked pattern was here ####
-POSTHOOK: query: select d, ntile(1000) over (partition by dec) from over10k limit 100
+POSTHOOK: query: select d, ntile(1000) over (partition by dec order by d) from over10k limit 100
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 #### A masked pattern was here ####
-41.04	1
-9.71	2
+9.71	1
+41.04	2
 43.7	1
-33.72	1
-1.42	2
+1.42	1
+33.72	2
 4.83	1
 12.49	1
 6.26	1
 14.11	2
 41.76	3
 6.55	1
-32.62	1
-11.27	2
+11.27	1
+32.62	2
 40.35	3
 41.23	1
 39.43	1
 21.2	1
 40.64	1
-43.97	1
-12.07	2
+12.07	1
+43.97	2
 27.64	1
-4.1	1
-0.7	2
+0.7	1
+4.1	2
 33.38	1
-33.65	1
-18.69	2
+18.69	1
+33.65	2
 2.2	1
 0.38	1
 15.83	1
-43.34	1
-11.38	2
-23.27	1
-38.18	2
-15.95	3
+11.38	1
+43.34	2
+15.95	1
+23.27	2
+38.18	3
 20.76	1
 5.63	1
 13.64	1
 34.33	2
 43.48	3
-46.79	1
-44.21	2
+44.21	1
+46.79	2
 6.52	1
 3.59	1
 40.26	2
-25.9	1
-16.31	2
+16.31	1
+25.9	2
 46.21	3
 45.08	1
 7.91	1
 24.37	2
 37.13	1
-39.25	1
-5.37	2
-7.64	1
-7.25	2
+5.37	1
+39.25	2
+7.25	1
+7.64	2
 16.09	3
 49.82	1
 16.08	1
 4.6	1
 14.12	1
-28.42	1
-27.58	2
+27.58	1
+28.42	2
 45.53	3
 48.56	4
 36.7	1
 32.68	1
-40.09	1
-3.17	2
-24.84	3
+3.17	1
+24.84	2
+40.09	3
 26.36	1
 33.49	1
 24.76	1
@@ -460,14 +460,14 @@ POSTHOOK: Input: default@over10k
 37.82	1
 15.27	1
 15.22	1
-40.54	1
-11.43	2
-22.64	1
-4.81	2
+11.43	1
+40.54	2
+4.81	1
+22.64	2
 14.18	1
 44.83	1
 5.15	1
-7.52	1
-2.78	2
-3.7	3
+2.78	1
+3.7	2
+7.52	3
 45.55	4

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_rank.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_rank.q.out?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_rank.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_rank.q.out Fri Apr 26 04:59:50 2013
@@ -147,222 +147,222 @@ ulysses garcia	1
 irene falkner	1
 holly robinson	1
 yuri white	1
-PREHOOK: query: select s, dense_rank() over (partition by ts order by i desc) from over10k limit 100
+PREHOOK: query: select s, dense_rank() over (partition by ts order by i,s desc) from over10k limit 100
 PREHOOK: type: QUERY
 PREHOOK: Input: default@over10k
 #### A masked pattern was here ####
-POSTHOOK: query: select s, dense_rank() over (partition by ts order by i desc) from over10k limit 100
+POSTHOOK: query: select s, dense_rank() over (partition by ts order by i,s desc) from over10k limit 100
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 #### A masked pattern was here ####
-jessica polk	1
-calvin steinbeck	2
-katie king	3
-rachel garcia	3
-bob ovid	4
-mike laertes	5
-gabriella xylophone	6
-sarah falkner	7
-jessica laertes	8
-tom johnson	9
-calvin brown	10
-yuri allen	11
-calvin laertes	12
+rachel thompson	1
+oscar brown	2
+wendy steinbeck	3
+victor van buren	4
+fred zipper	5
+priscilla zipper	6
+katie white	7
+fred nixon	8
+gabriella van buren	9
+luke zipper	10
+victor ellison	11
+david falkner	12
 nick carson	13
-david falkner	14
-victor ellison	15
-luke zipper	16
-gabriella van buren	17
-fred nixon	18
-priscilla zipper	19
-katie white	19
-fred zipper	20
-wendy steinbeck	21
-victor van buren	21
-oscar brown	22
-rachel thompson	23
-luke king	1
-holly thompson	1
-luke xylophone	2
-rachel robinson	3
-wendy thompson	4
-priscilla hernandez	5
-fred polk	6
-irene brown	7
-rachel young	8
-bob falkner	9
-katie davidson	10
+calvin laertes	14
+yuri allen	15
+calvin brown	16
+tom johnson	17
+jessica laertes	18
+sarah falkner	19
+gabriella xylophone	20
+mike laertes	21
+bob ovid	22
+rachel garcia	23
+katie king	24
+calvin steinbeck	25
+jessica polk	26
+xavier davidson	1
+ethan ovid	2
+calvin white	3
+katie zipper	4
+quinn allen	5
+victor underhill	6
+ulysses xylophone	7
+priscilla zipper	8
+quinn ovid	9
+katie xylophone	10
 rachel ovid	11
-jessica brown	12
-holly falkner	13
-sarah van buren	14
-yuri hernandez	15
-zach young	16
-calvin carson	17
-bob king	18
-calvin nixon	19
-gabriella johnson	20
-xavier johnson	20
-ethan young	21
-jessica brown	22
-jessica nixon	23
-fred king	23
-ulysses johnson	23
-wendy johnson	24
-oscar davidson	25
-nick ellison	26
-luke steinbeck	27
-jessica robinson	28
-priscilla brown	29
-gabriella underhill	29
-gabriella steinbeck	30
-luke thompson	31
-alice miller	32
-oscar van buren	32
-yuri brown	33
-rachel ovid	34
-katie xylophone	35
-quinn ovid	36
-priscilla zipper	37
-victor underhill	38
-ulysses xylophone	38
-quinn allen	39
-katie zipper	40
-calvin white	41
-ethan ovid	42
-xavier davidson	43
-oscar carson	1
-priscilla garcia	2
-priscilla hernandez	3
-bob carson	4
-quinn van buren	5
-rachel ichabod	6
-ethan ichabod	6
-jessica ovid	7
-ulysses carson	7
-holly allen	8
-wendy falkner	8
-rachel ellison	9
-jessica johnson	10
-rachel ichabod	11
-wendy underhill	12
-sarah falkner	13
-tom hernandez	14
+yuri brown	12
+oscar van buren	13
+alice miller	14
+luke thompson	15
+gabriella steinbeck	16
+priscilla brown	17
+gabriella underhill	18
+jessica robinson	19
+luke steinbeck	20
+nick ellison	21
+oscar davidson	22
+wendy johnson	23
+ulysses johnson	24
+jessica nixon	25
+fred king	26
+jessica brown	27
+ethan young	28
+xavier johnson	29
+gabriella johnson	30
+calvin nixon	31
+bob king	32
+calvin carson	33
+zach young	34
+yuri hernandez	35
+sarah van buren	36
+holly falkner	37
+jessica brown	38
+rachel ovid	39
+katie davidson	40
+bob falkner	41
+rachel young	42
+irene brown	43
+fred polk	44
+priscilla hernandez	45
+wendy thompson	46
+rachel robinson	47
+luke xylophone	48
+luke king	49
+holly thompson	50
+yuri garcia	1
+nick king	2
+calvin white	3
+rachel polk	4
+rachel davidson	5
+victor hernandez	6
+wendy miller	7
+wendy brown	8
+priscilla thompson	9
+holly nixon	10
+victor hernandez	11
+priscilla polk	12
+ethan nixon	13
+alice underhill	14
 jessica thompson	15
-alice underhill	16
-ethan nixon	16
-priscilla polk	17
-victor hernandez	18
-holly nixon	19
-priscilla thompson	20
-PREHOOK: query: select s, cume_dist() over (partition by bo order by b) from over10k limit 100
+tom hernandez	16
+sarah falkner	17
+wendy underhill	18
+rachel ichabod	19
+jessica johnson	20
+rachel ellison	21
+wendy falkner	22
+holly allen	23
+ulysses carson	24
+PREHOOK: query: select s, cume_dist() over (partition by bo order by b,s) from over10k limit 100
 PREHOOK: type: QUERY
 PREHOOK: Input: default@over10k
 #### A masked pattern was here ####
-POSTHOOK: query: select s, cume_dist() over (partition by bo order by b) from over10k limit 100
+POSTHOOK: query: select s, cume_dist() over (partition by bo order by b,s) from over10k limit 100
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 #### A masked pattern was here ####
-holly allen	0.004625905068382945
-wendy falkner	0.004625905068382945
-david ovid	0.004625905068382945
-victor garcia	0.004625905068382945
-katie xylophone	0.004625905068382945
-ulysses xylophone	0.004625905068382945
-nick steinbeck	0.004625905068382945
-ethan ellison	0.004625905068382945
-nick quirinius	0.004625905068382945
-irene garcia	0.004625905068382945
-mike xylophone	0.004625905068382945
-victor xylophone	0.004625905068382945
-jessica steinbeck	0.004625905068382945
-irene van buren	0.004625905068382945
-quinn steinbeck	0.004625905068382945
-calvin allen	0.004625905068382945
-david zipper	0.004625905068382945
-sarah miller	0.004625905068382945
-ulysses nixon	0.004625905068382945
-ulysses ichabod	0.004625905068382945
+calvin allen	2.0112630732099757E-4
+david ovid	4.0225261464199515E-4
+david zipper	6.033789219629927E-4
+ethan ellison	8.045052292839903E-4
+holly allen	0.001005631536604988
+irene garcia	0.0012067578439259854
+irene van buren	0.0014078841512469831
+jessica steinbeck	0.0016090104585679806
+katie xylophone	0.0018101367658889783
+mike xylophone	0.002011263073209976
+nick quirinius	0.0022123893805309734
+nick steinbeck	0.002413515687851971
+quinn steinbeck	0.002614641995172969
+rachel thompson	0.0028157683024939663
+sarah miller	0.0030168946098149637
+tom hernandez	0.003218020917135961
+ulysses ichabod	0.003419147224456959
+ulysses nixon	0.0036202735317779565
+ulysses xylophone	0.003821399839098954
+victor garcia	0.004022526146419952
+victor xylophone	0.004223652453740949
+wendy falkner	0.004424778761061947
 yuri nixon	0.004625905068382945
-tom hernandez	0.004625905068382945
-rachel thompson	0.004625905068382945
-katie xylophone	0.007441673370876911
-oscar quirinius	0.007441673370876911
-rachel davidson	0.007441673370876911
-sarah van buren	0.007441673370876911
-ulysses allen	0.007441673370876911
-bob king	0.007441673370876911
-bob johnson	0.007441673370876911
-calvin van buren	0.007441673370876911
-tom king	0.007441673370876911
+bob johnson	0.004827031375703942
+bob king	0.00502815768302494
+calvin van buren	0.005229283990345938
+gabriella robinson	0.005430410297666935
+katie xylophone	0.0056315366049879325
+mike steinbeck	0.00583266291230893
+oscar quirinius	0.006033789219629927
+rachel davidson	0.006234915526950925
+sarah van buren	0.006436041834271922
+tom king	0.00663716814159292
+ulysses allen	0.006838294448913918
+wendy ellison	0.007039420756234915
+zach allen	0.007240547063555913
 zach young	0.007441673370876911
-zach allen	0.007441673370876911
-mike steinbeck	0.007441673370876911
-wendy ellison	0.007441673370876911
-gabriella robinson	0.007441673370876911
+alice falkner	0.007642799678197908
+bob ovid	0.007843925985518906
+bob underhill	0.008045052292839904
+ethan ovid	0.008246178600160902
+gabriella davidson	0.008447304907481898
+gabriella garcia	0.008648431214802896
+irene nixon	0.008849557522123894
+jessica brown	0.009050683829444892
+jessica miller	0.00925181013676589
+jessica quirinius	0.009452936444086887
+luke falkner	0.009654062751407884
+luke robinson	0.009855189058728881
+mike steinbeck	0.01005631536604988
+mike van buren	0.010257441673370877
+priscilla hernandez	0.010458567980691875
+tom polk	0.010659694288012871
+ulysses king	0.01086082059533387
+ulysses robinson	0.011061946902654867
 xavier davidson	0.011263073209975865
-jessica miller	0.011263073209975865
-mike steinbeck	0.011263073209975865
-alice falkner	0.011263073209975865
-irene nixon	0.011263073209975865
-jessica brown	0.011263073209975865
-ethan ovid	0.011263073209975865
-ulysses king	0.011263073209975865
-gabriella davidson	0.011263073209975865
-jessica quirinius	0.011263073209975865
-luke falkner	0.011263073209975865
-luke robinson	0.011263073209975865
-priscilla hernandez	0.011263073209975865
-mike van buren	0.011263073209975865
-ulysses robinson	0.011263073209975865
-bob underhill	0.011263073209975865
-bob ovid	0.011263073209975865
-tom polk	0.011263073209975865
-gabriella garcia	0.011263073209975865
-wendy allen	0.015084473049074818
-victor robinson	0.015084473049074818
-calvin nixon	0.015084473049074818
-wendy nixon	0.015084473049074818
-mike falkner	0.015084473049074818
-nick falkner	0.015084473049074818
-priscilla nixon	0.015084473049074818
-david davidson	0.015084473049074818
-bob underhill	0.015084473049074818
-oscar laertes	0.015084473049074818
-oscar miller	0.015084473049074818
-priscilla xylophone	0.015084473049074818
-jessica robinson	0.015084473049074818
-quinn miller	0.015084473049074818
+alice hernandez	0.011464199517296863
+bob underhill	0.01166532582461786
+calvin nixon	0.011866452131938857
+david davidson	0.012067578439259855
+holly falkner	0.012268704746580853
+irene laertes	0.01246983105390185
+jessica robinson	0.012670957361222849
+mike falkner	0.012872083668543845
+nick falkner	0.013073209975864843
+oscar laertes	0.01327433628318584
+oscar miller	0.013475462590506838
+oscar thompson	0.013676588897827836
+priscilla nixon	0.013877715205148834
+priscilla xylophone	0.01407884151246983
+quinn miller	0.014279967819790828
+victor robinson	0.014481094127111826
+wendy allen	0.014682220434432824
+wendy nixon	0.014883346741753822
 yuri ellison	0.015084473049074818
-holly falkner	0.015084473049074818
-oscar thompson	0.015084473049074818
-irene laertes	0.015084473049074818
-alice hernandez	0.015084473049074818
-luke johnson	0.01830249396621078
-fred carson	0.01830249396621078
-nick allen	0.01830249396621078
-nick ellison	0.01830249396621078
-priscilla laertes	0.01830249396621078
-priscilla underhill	0.01830249396621078
-calvin nixon	0.01830249396621078
-oscar king	0.01830249396621078
-katie polk	0.01830249396621078
-irene king	0.01830249396621078
-jessica davidson	0.01830249396621078
-victor steinbeck	0.01830249396621078
-priscilla young	0.01830249396621078
-katie polk	0.01830249396621078
-holly davidson	0.01830249396621078
+calvin nixon	0.015285599356395816
+fred carson	0.015486725663716814
+holly davidson	0.015687851971037812
+irene king	0.01588897827835881
+jessica davidson	0.016090104585679808
+katie polk	0.016492357200321803
+katie polk	0.016492357200321803
+luke johnson	0.0166934835076428
+nick allen	0.016894609814963796
+nick ellison	0.017095736122284794
+oscar king	0.01729686242960579
+priscilla laertes	0.01749798873692679
+priscilla underhill	0.017699115044247787
+priscilla young	0.017900241351568785
+victor steinbeck	0.018101367658889783
 wendy miller	0.01830249396621078
-zach johnson	0.02252614641995173
-mike falkner	0.02252614641995173
-victor zipper	0.02252614641995173
-wendy king	0.02252614641995173
-fred ellison	0.02252614641995173
-mike hernandez	0.02252614641995173
-xavier allen	0.02252614641995173
-zach zipper	0.02252614641995173
-ethan laertes	0.02252614641995173
+calvin carson	0.01850362027353178
+ethan hernandez	0.018704746580852777
+ethan laertes	0.01910699919549477
+ethan laertes	0.01910699919549477
+ethan white	0.019308125502815767
+fred ellison	0.019509251810136765
+gabriella hernandez	0.019710378117457763
+gabriella ovid	0.01991150442477876
+gabriella steinbeck	0.02011263073209976
 PREHOOK: query: select s, percent_rank() over (partition by dec order by f) from over10k limit 100
 PREHOOK: type: QUERY
 PREHOOK: Input: default@over10k
@@ -476,7 +476,7 @@ PREHOOK: query: -- If following tests fa
 select ts, dec, rnk
 from
   (select ts, dec,
-          rank() over (partition by ts)  as rnk
+          rank() over (partition by ts order by dec)  as rnk
           from
             (select other.ts, other.dec
              from over10k other
@@ -492,7 +492,7 @@ POSTHOOK: query: -- If following tests f
 select ts, dec, rnk
 from
   (select ts, dec,
-          rank() over (partition by ts)  as rnk
+          rank() over (partition by ts order by dec)  as rnk
           from
             (select other.ts, other.dec
              from over10k other
@@ -503,16 +503,16 @@ where rnk =  1 limit 10
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 #### A masked pattern was here ####
-2013-03-01 09:11:58.70307	34.22	1
-2013-03-01 09:11:58.70307	34.22	1
-2013-03-01 09:11:58.70307	34.22	1
-2013-03-01 09:11:58.70307	34.22	1
-2013-03-01 09:11:58.70307	34.22	1
-2013-03-01 09:11:58.70307	34.22	1
-2013-03-01 09:11:58.70307	34.22	1
-2013-03-01 09:11:58.70307	34.22	1
-2013-03-01 09:11:58.70307	34.22	1
-2013-03-01 09:11:58.70307	34.22	1
+2013-03-01 09:11:58.70307	0.5	1
+2013-03-01 09:11:58.70307	0.5	1
+2013-03-01 09:11:58.70307	0.5	1
+2013-03-01 09:11:58.70307	0.5	1
+2013-03-01 09:11:58.70307	0.5	1
+2013-03-01 09:11:58.70307	0.5	1
+2013-03-01 09:11:58.70307	0.5	1
+2013-03-01 09:11:58.70307	0.5	1
+2013-03-01 09:11:58.70307	0.5	1
+2013-03-01 09:11:58.70307	0.5	1
 PREHOOK: query: select ts, dec, rnk
 from
   (select ts, dec,
@@ -554,7 +554,7 @@ POSTHOOK: Input: default@over10k
 PREHOOK: query: select ts, dec, rnk
 from
   (select ts, dec,
-          rank() over (partition by ts)  as rnk
+          rank() over (partition by ts order by dec)  as rnk
           from
             (select other.ts, other.dec
              from over10k other
@@ -569,7 +569,7 @@ PREHOOK: Input: default@over10k
 POSTHOOK: query: select ts, dec, rnk
 from
   (select ts, dec,
-          rank() over (partition by ts)  as rnk
+          rank() over (partition by ts order by dec)  as rnk
           from
             (select other.ts, other.dec
              from over10k other
@@ -581,13 +581,13 @@ where rnk = 1 limit 10
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 #### A masked pattern was here ####
-2013-03-01 09:11:58.70307	53.25	1
-2013-03-01 09:11:58.70307	53.25	1
-2013-03-01 09:11:58.70307	53.25	1
-2013-03-01 09:11:58.70307	53.25	1
-2013-03-01 09:11:58.70307	53.25	1
-2013-03-01 09:11:58.70307	53.25	1
-2013-03-01 09:11:58.70307	53.25	1
-2013-03-01 09:11:58.70307	53.25	1
-2013-03-01 09:11:58.70307	53.25	1
-2013-03-01 09:11:58.70307	79.99	1
+2013-03-01 09:11:58.70307	37.3	1
+2013-03-01 09:11:58.70307	37.3	1
+2013-03-01 09:11:58.70307	37.3	1
+2013-03-01 09:11:58.70307	37.3	1
+2013-03-01 09:11:58.70307	37.3	1
+2013-03-01 09:11:58.70307	37.3	1
+2013-03-01 09:11:58.70307	37.3	1
+2013-03-01 09:11:58.70307	37.3	1
+2013-03-01 09:11:58.70307	37.3	1
+2013-03-01 09:11:58.70307	37.3	1

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_udaf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_udaf.q.out?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_udaf.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_udaf.q.out Fri Apr 26 04:59:50 2013
@@ -147,128 +147,128 @@ alice hernandez	65543
 alice hernandez	65543
 alice hernandez	65543
 alice hernandez	65543
-PREHOOK: query: select s, avg(f) over (partition by si order by t) from over10k limit 100
+PREHOOK: query: select s, avg(f) over (partition by si order by s) from over10k limit 100
 PREHOOK: type: QUERY
 PREHOOK: Input: default@over10k
 #### A masked pattern was here ####
-POSTHOOK: query: select s, avg(f) over (partition by si order by t) from over10k limit 100
+POSTHOOK: query: select s, avg(f) over (partition by si order by s) from over10k limit 100
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 #### A masked pattern was here ####
-fred quirinius	40.970001220703125
-ulysses white	47.60000038146973
-alice ellison	44.45333353678385
-sarah white	41.5
-victor thompson	44.07000001271566
-calvin johnson	44.07000001271566
-nick zipper	51.10142871311733
-victor johnson	47.296250104904175
-calvin young	49.61400032043457
-zach nixon	49.61400032043457
-xavier quirinius	54.20833365122477
-victor robinson	54.20833365122477
-victor hernandez	54.74692329993615
-tom allen	54.20571436200823
-sarah brown	56.666666920979814
-irene polk	58.91937518119812
-holly xylophone	56.917647193459906
-rachel ovid	54.96833345625136
-wendy garcia	54.67736846522281
-oscar steinbeck	54.6835000038147
-zach white	54.382272633639246
-ethan thompson	54.382272633639246
-quinn hernandez	55.655652004739515
-fred hernandez	53.47749984264374
-wendy nixon	55.13319995880127
-david davidson	55.86461540368887
-rachel ellison	54.12888890725595
-gabriella falkner	53.41321430887495
-ethan falkner	52.01862072122508
-alice ovid	52.830666605631514
-zach underhill	53.1432257621519
-alice robinson	53.058787837173
-quinn quirinius	53.058787837173
-ulysses young	51.977352927712836
-xavier van buren	52.72857131958008
-xavier ovid	52.70055548350016
-victor davidson	51.42081073812536
-jessica laertes	51.61000061035156
-yuri nixon	52.75
-ethan king	61.550000508626304
-sarah hernandez	46.9425003528595
-alice underhill	41.020000267028806
-alice xylophone	50.516666889190674
-victor xylophone	52.099999972752165
-yuri brown	51.53500020503998
-oscar young	51.92777792612711
-nick quirinius	57.051818414167926
-zach underhill	57.051818414167926
-gabriella ellison	55.287500301996864
-holly white	54.27615407797006
-zach hernandez	54.87000022615705
-xavier brown	54.62933343251546
-irene young	52.748750150203705
-katie garcia	51.00941192402559
-oscar laertes	48.69000016318427
-katie ichabod	48.97000006625527
-nick davidson	48.98899998664856
-priscilla miller	47.38761901855469
-rachel robinson	48.00090911171653
-fred brown	50.08826098234757
-wendy brown	49.570400161743166
-fred zipper	49.570400161743166
-holly robinson	51.34037053143537
-priscilla laertes	51.34037053143537
-nick zipper	52.96571438653128
-ethan polk	54.25793121600973
-priscilla thompson	52.37741947174072
-luke quirinius	52.37741947174072
-oscar thompson	50.77843761444092
-ulysses young	50.225151639996156
-ethan underhill	51.552353017470416
-luke falkner	50.90800007411412
-zach zipper	52.148889011806915
-david brown	52.92216233949404
-zach hernandez	52.05473699067768
-mike underhill	51.34564116062262
-zach hernandez	51.274500131607056
-tom laertes	9.050000190734863
-oscar van buren	37.92999887466431
-priscilla underhill	49.59750008583069
-jessica ichabod	49.59750008583069
-bob falkner	54.244999726613365
-xavier zipper	54.244999726613365
-zach zipper	54.014285632542204
-jessica laertes	54.80499994754791
-calvin davidson	45.944000005722046
-calvin steinbeck	45.944000005722046
-gabriella young	44.62636371092363
-luke ovid	48.321666836738586
-nick king	54.24857177053179
-sarah zipper	54.24857177053179
-alice nixon	53.90733372370402
-ulysses laertes	50.65812536329031
-priscilla zipper	51.28058867594775
-calvin johnson	48.576667077011535
-katie allen	51.187895254084935
-zach steinbeck	49.3070004761219
-priscilla zipper	48.46285759267353
-mike underhill	48.61545496095311
-irene quirinius	49.54521778873775
-PREHOOK: query: select s, avg(i) over (partition by t, b) from over10k limit 100
+alice ellison	38.15999984741211
+alice ovid	57.26999855041504
+alice robinson	61.9533322652181
+calvin johnson	48.489999294281006
+calvin young	57.602000045776364
+david davidson	60.36000029246012
+ethan falkner	53.59000028882708
+ethan thompson	50.917500138282776
+fred hernandez	45.63555569118924
+fred quirinius	45.169000244140626
+gabriella falkner	44.16181841763583
+holly xylophone	42.55583349863688
+irene polk	46.413846236008865
+nick zipper	49.762142998831614
+oscar steinbeck	50.098000081380206
+quinn hernandez	52.19624996185303
+quinn quirinius	51.01882351146025
+rachel ellison	48.684444427490234
+rachel ovid	47.271052611501595
+sarah brown	49.46350011825562
+sarah white	48.66238103594099
+tom allen	48.59454545107755
+ulysses white	48.839565194171406
+ulysses young	47.483333349227905
+victor davidson	45.79800001144409
+victor hernandez	46.39076920656058
+victor johnson	45.437777748814334
+victor robinson	46.12964274202074
+victor thompson	47.65344815418638
+wendy garcia	47.7129998366038
+wendy nixon	49.234193478861165
+xavier ovid	49.311874970793724
+xavier quirinius	50.531212185368396
+xavier van buren	51.34705878706539
+zach nixon	50.55771423067365
+zach underhill	50.889999959203934
+zach white	51.42081073812536
+alice underhill	17.329999923706055
+alice xylophone	57.66499996185303
+david brown	65.36333401997884
+ethan king	68.81000089645386
+ethan polk	73.13600120544433
+ethan underhill	76.83833408355713
+fred brown	79.57714380536761
+fred zipper	72.68500089645386
+gabriella ellison	68.5955564710829
+holly robinson	69.57500076293945
+holly white	67.0809097290039
+irene young	63.535833994547524
+jessica laertes	62.61846219576322
+katie garcia	59.8014292035784
+katie ichabod	59.41533381144206
+luke falkner	57.51437544822693
+luke quirinius	56.508823843563306
+mike underhill	54.72500027550591
+nick davidson	54.44210544385408
+nick quirinius	55.77850008010864
+nick zipper	57.73428571791876
+oscar laertes	55.53090910478072
+oscar thompson	53.169130449709684
+oscar young	53.24833333492279
+priscilla laertes	53.86000003814697
+priscilla miller	52.379230792705826
+priscilla thompson	50.80222225189209
+rachel robinson	51.162142923900056
+sarah hernandez	49.505517301888304
+ulysses young	48.93933340708415
+victor xylophone	49.34774195763372
+wendy brown	49.7678125500679
+xavier brown	49.81303030071837
+yuri brown	49.74735299278708
+yuri nixon	49.86571431841169
+zach hernandez	49.37763158898605
+zach hernandez	49.37763158898605
+zach hernandez	49.37763158898605
+zach underhill	50.13846162649301
+zach zipper	51.274500131607056
+alice nixon	31.255000591278076
+alice nixon	31.255000591278076
+bob falkner	51.356666247049965
+calvin davidson	39.96249973773956
+calvin johnson	32.491999769210814
+calvin steinbeck	29.613333185513813
+david garcia	34.99428541319711
+fred king	40.516249507665634
+gabriella young	39.50888853602939
+holly johnson	40.59399974346161
+irene quirinius	43.26727249405601
+jessica falkner	42.47249974807104
+jessica ichabod	42.86076903343201
+jessica laertes	44.109285541943144
+katie allen	47.71466666857402
+luke ovid	50.293125078082085
+mike underhill	50.38294123200809
+nick falkner	52.106666922569275
+nick king	54.01842131112751
+nick xylophone	54.5635001540184
+oscar van buren	55.146666697093416
+priscilla underhill	56.049545580690555
+priscilla zipper	55.24625018239021
+PREHOOK: query: select s, avg(i) over (partition by t, b order by s) from over10k limit 100
 PREHOOK: type: QUERY
 PREHOOK: Input: default@over10k
 #### A masked pattern was here ####
-POSTHOOK: query: select s, avg(i) over (partition by t, b) from over10k limit 100
+POSTHOOK: query: select s, avg(i) over (partition by t, b order by s) from over10k limit 100
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 #### A masked pattern was here ####
 oscar miller	65773.0
-bob underhill	65743.5
+bob underhill	65735.0
 tom polk	65743.5
 wendy robinson	65622.0
 alice king	65570.0
-ethan steinbeck	65695.5
+ethan steinbeck	65720.0
 quinn polk	65695.5
 bob ellison	65671.0
 mike xylophone	65610.0
@@ -279,13 +279,13 @@ xavier ovid	65769.0
 oscar garcia	65712.0
 sarah zipper	65766.0
 wendy xylophone	65670.0
-gabriella brown	65680.33333333333
+gabriella brown	65751.0
+irene young	65715.0
 sarah miller	65680.33333333333
-irene young	65680.33333333333
 nick nixon	65696.0
 tom steinbeck	65608.0
+calvin white	65548.0
 oscar johnson	65650.0
-calvin white	65650.0
 holly thompson	65550.0
 david falkner	65698.0
 ulysses steinbeck	65562.0
@@ -293,31 +293,31 @@ victor allen	65658.0
 rachel thompson	65733.0
 jessica johnson	65589.0
 alice falkner	65597.0
-ulysses carson	65728.33333333333
-priscilla quirinius	65728.33333333333
+priscilla quirinius	65646.0
+ulysses carson	65714.5
 victor thompson	65728.33333333333
 ulysses ellison	65640.0
 bob johnson	65731.0
 quinn ellison	65736.0
+bob polk	65776.0
 victor xylophone	65697.0
-bob polk	65697.0
 jessica white	65566.0
 holly nixon	65565.0
 oscar johnson	65671.0
 irene ellison	65696.0
 priscilla zipper	65669.0
 fred ellison	65548.0
+nick robinson	65566.0
 sarah robinson	65605.0
-nick robinson	65605.0
 tom hernandez	65575.0
-alice xylophone	65618.0
+alice xylophone	65661.0
 sarah xylophone	65618.0
 priscilla laertes	65696.0
 holly polk	65710.0
 katie ichabod	65577.0
 holly underhill	65553.0
+alice davidson	65676.0
 ethan underhill	65706.5
-alice davidson	65706.5
 bob van buren	65654.0
 jessica king	65644.0
 mike allen	65551.0
@@ -343,8 +343,8 @@ mike king	65543.0
 rachel davidson	65728.0
 luke ichabod	65757.0
 luke young	65696.0
+victor robinson	65571.0
 wendy quirinius	65616.0
-victor robinson	65616.0
 jessica miller	65763.0
 bob ichabod	65733.0
 bob falkner	65595.0
@@ -353,15 +353,15 @@ zach zipper	65588.0
 alice underhill	65790.0
 alice xylophone	65715.0
 ethan nixon	65782.0
+bob van buren	65582.0
 katie ovid	65613.0
-bob van buren	65613.0
+fred king	65712.0
 yuri hernandez	65657.5
-fred king	65657.5
 nick falkner	65604.0
+david laertes	65612.0
 sarah steinbeck	65655.0
-david laertes	65655.0
+alice carson	65565.0
 katie thompson	65582.5
-alice carson	65582.5
 oscar van buren	65595.0
 PREHOOK: query: select max(i) over w from over10k window w as (partition by f) limit 100
 PREHOOK: type: QUERY



Mime
View raw message