svn commit: r1462362 [3/3] - in /hive/branches/ptf-windowing: data/files/over10k ql/src/test/results/clientpositive/windowing_expressions.q.out ql/src/test/results/clientpositive/windowing_rank.q.out

[ha...@apache.org]

Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/windowing_expressions.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/windowing_expressions.q.out?rev=1462362&r1=1462361&r2=1462362&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/windowing_expressions.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/windowing_expressions.q.out Fri Mar 29 00:09:02 2013
@@ -170,106 +170,106 @@ POSTHOOK: query: select s, si, f, si - l
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 #### A masked pattern was here ####
-sarah polk	325	24.97	295.89
-mike young	504	28.26	418.22
-xavier johnson	419	25.68	414.72
-irene steinbeck	420	29.11	417.0
-calvin quirinius	316	85.78	249.85
-gabriella hernandez	457	4.28	403.72
-victor polk	370	3.0	313.83002
-calvin hernandez	446	66.15	359.9
-irene robinson	442	53.28	425.28
-david xylophone	389	56.17	362.56
-jessica ichabod	309	86.1	230.69
-mike hernandez	491	16.72	477.61
-fred robinson	409	26.44	358.62
-fred davidson	507	78.31	471.26
-tom quirinius	492	13.39	426.86
-priscilla king	285	50.38	230.56
-luke thompson	414	35.74	331.49
-mike quirinius	300	65.14	223.07
-irene van buren	454	54.44	436.25
-quinn quirinius	352	82.51	282.23
-zach nixon	386	76.93	301.56
-holly zipper	506	17.75	440.39
-gabriella brown	270	69.77	232.81
-victor van buren	263	84.44	190.03
-yuri laertes	450	65.61	392.28
-luke polk	480	37.19	432.41
-irene ichabod	474	72.97	434.39
-mike zipper	441	57.72	354.41998
-alice robinson	423	47.59	404.01
-calvin hernandez	507	39.61	493.04
-ulysses ovid	500	86.58	409.14
-wendy laertes	405	18.99	322.11
-bob laertes	487	13.96	395.69
-irene white	261	90.86	250.33
-irene davidson	495	82.89	488.83
-sarah garcia	399	91.31	307.88
-bob laertes	376	10.67	360.62
-zach carson	381	6.17	350.7
-luke falkner	441	91.12	409.34
-victor young	263	15.38	185.18
-alice brown	425	30.3	417.14
-gabriella king	474	31.66	444.05
-sarah nixon	378	77.82	328.47
-calvin laertes	329	7.86	317.5
-fred polk	295	29.95	276.57
-tom ichabod	292	49.53	287.59
-victor thompson	294	11.5	226.78
-luke laertes	428	18.43	414.83
-yuri thompson	267	4.41	236.2
-katie king	396	67.22	320.43
-gabriella nixon	405	13.17	394.26
-sarah johnson	337	30.8	240.63
-calvin carson	447	75.57	384.23
-wendy davidson	449	10.74	403.83002
-fred underhill	489	96.37	411.1
-jessica king	435	62.77	365.2
-luke xylophone	431	45.17	383.12
-fred underhill	473	77.9	375.88
-gabriella van buren	276	69.8	273.65
-victor king	444	47.88	392.91998
-alice garcia	486	97.12	437.11
-ethan polk	260	2.35	239.64
-gabriella underhill	329	51.08	292.44
-yuri carson	489	48.89	443.61
-holly quirinius	363	20.36	279.69
-jessica garcia	400	36.56	354.9
-mike johnson	278	45.39	198.86
-xavier falkner	434	83.31	354.79
-sarah laertes	262	45.1	250.61
-victor underhill	434	79.14	372.59
-tom johnson	320	79.21	237.89
-david underhill	311	11.39	276.22
-yuri hernandez	413	61.41	391.86
-tom davidson	336	82.11	309.09
-ethan steinbeck	461	34.78	384.96
-priscilla miller	267	21.14	168.91
-mike johnson	286	26.91	203.20999
-luke young	276	76.04	195.76999
-ethan king	279	98.09	215.19
-fred van buren	501	82.79	441.02
-alice nixon	299	80.23	246.4
-xavier robinson	469	63.81	433.31
-bob miller	484	59.98	434.58002
-irene quirinius	486	52.6	441.41998
-ethan underhill	299	35.69	258.51
-wendy polk	352	49.42	264.9
-gabriella garcia	395	44.58	317.65
-oscar laertes	432	40.49	429.61
-gabriella ichabod	403	87.1	368.52
-sarah carson	493	77.35	415.3
-david white	432	2.39	355.13
-quinn thompson	372	34.48	277.82
-rachel underhill	282	77.7	278.48
-holly laertes	306	76.87	239.05
-quinn carson	361	94.18	352.49
-mike nixon	434	3.52	352.15
-sarah falkner	360	66.95	355.31
-wendy xylophone	274	8.51	245.64
-tom allen	373	81.85	308.18
-irene laertes	402	4.69	329.72
+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
+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
 PREHOOK: type: QUERY
 PREHOOK: Input: default@over10k

Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/windowing_rank.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/windowing_rank.q.out?rev=1462362&r1=1462361&r2=1462362&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/windowing_rank.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/windowing_rank.q.out Fri Mar 29 00:09:02 2013
@@ -48,67 +48,67 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 #### A masked pattern was here ####
 bob ichabod	1
-yuri thompson	1
-fred zipper	1
-luke king	1
-luke steinbeck	3
-quinn miller	1
-calvin van buren	2
+yuri thompson	2
+luke steinbeck	1
+fred zipper	2
+luke king	3
+calvin van buren	1
+quinn miller	2
 holly steinbeck	1
 david davidson	1
-calvin thompson	1
-calvin quirinius	2
-holly thompson	1
-nick zipper	1
-david ovid	3
-victor robinson	1
-victor steinbeck	2
+calvin quirinius	1
+calvin thompson	2
+david ovid	1
+nick zipper	2
+holly thompson	3
+victor steinbeck	1
+victor robinson	2
 zach ovid	1
 ulysses zipper	1
-luke falkner	1
-irene thompson	2
+irene thompson	1
+luke falkner	2
 yuri johnson	1
-gabriella robinson	1
-ulysses falkner	2
+ulysses falkner	1
+gabriella robinson	2
 alice robinson	1
-priscilla xylophone	1
-mike underhill	1
-david laertes	2
+priscilla xylophone	2
+david laertes	1
+mike underhill	2
 victor van buren	1
 holly falkner	1
 priscilla falkner	1
 luke zipper	1
 ethan ovid	2
-mike steinbeck	1
-alice quirinius	2
-calvin white	3
+alice quirinius	1
+calvin white	2
+mike steinbeck	3
 nick young	1
 wendy polk	2
 irene miller	3
-yuri davidson	1
-ethan ellison	2
+ethan ellison	1
+yuri davidson	2
 zach hernandez	1
 wendy miller	1
 katie underhill	1
 irene zipper	1
 holly allen	1
-quinn brown	1
+quinn brown	2
 calvin ovid	1
-nick miller	1
-zach robinson	2
+zach robinson	1
+nick miller	2
 mike allen	1
-zach miller	1
-yuri van buren	1
-priscilla young	3
-victor xylophone	1
-sarah falkner	2
+priscilla young	1
+yuri van buren	2
+zach miller	3
+sarah falkner	1
+victor xylophone	2
 rachel ichabod	1
 calvin ovid	1
 alice robinson	2
 calvin ovid	1
-luke laertes	1
-david hernandez	1
-alice ovid	3
+alice ovid	1
+david hernandez	2
+luke laertes	3
 luke quirinius	1
 oscar white	1
 zach falkner	1
@@ -118,12 +118,12 @@ xavier polk	1
 wendy ichabod	1
 rachel ovid	1
 wendy allen	1
-mike brown	1
-luke brown	2
-oscar ichabod	3
+luke brown	1
+oscar ichabod	2
+mike brown	3
 xavier garcia	1
-yuri brown	1
-bob xylophone	2
+bob xylophone	1
+yuri brown	2
 ethan quirinius	1
 luke davidson	2
 zach davidson	1
@@ -137,8 +137,8 @@ bob carson	3
 sarah robinson	1
 david king	1
 oscar davidson	1
-victor hernandez	1
-wendy polk	2
+wendy polk	1
+victor hernandez	2
 david ellison	1
 ulysses johnson	1
 jessica ovid	1
@@ -155,106 +155,106 @@ POSTHOOK: query: select s, dense_rank() 
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 #### A masked pattern was here ####
-tom carson	1
-zach allen	1
-calvin young	2
-rachel quirinius	3
-jessica polk	3
-xavier carson	4
-katie robinson	5
-ulysses garcia	6
-yuri brown	7
-holly thompson	7
-luke king	7
-xavier carson	8
-oscar white	8
-sarah ovid	9
-quinn miller	9
-mike white	10
-luke xylophone	10
-mike xylophone	10
-ulysses polk	10
-gabriella king	10
-bob young	11
-quinn brown	11
-calvin steinbeck	11
-victor hernandez	12
-fred underhill	12
-rachel robinson	13
-katie brown	14
-wendy thompson	14
-zach xylophone	14
-ulysses hernandez	14
-victor xylophone	15
-priscilla hernandez	16
-oscar carson	17
-alice nixon	18
-holly xylophone	19
-priscilla garcia	19
-jessica brown	20
-luke thompson	20
-fred polk	20
-gabriella davidson	21
-alice polk	21
-gabriella nixon	22
-mike ellison	22
-zach van buren	23
-ethan allen	24
-priscilla hernandez	25
-irene brown	25
-bob carson	26
-sarah carson	26
-calvin king	26
-zach xylophone	27
-quinn van buren	27
-gabriella zipper	28
-tom quirinius	29
-quinn allen	29
-rachel ichabod	30
-holly ichabod	30
-rachel garcia	30
-ethan ichabod	30
-katie king	30
-jessica ovid	31
-fred miller	31
-ulysses carson	31
-yuri brown	31
-priscilla falkner	31
-bob ovid	32
-ethan davidson	32
-holly allen	33
-wendy garcia	33
-wendy falkner	33
-katie ovid	34
-katie brown	34
-nick ellison	35
-ulysses allen	36
-priscilla robinson	36
-rachel young	36
-xavier carson	37
-bob falkner	38
-zach ovid	38
-rachel ellison	38
-luke robinson	39
-victor young	39
-xavier carson	39
-fred hernandez	39
-irene falkner	39
-jessica johnson	40
-katie davidson	41
-mike laertes	42
-holly steinbeck	43
-calvin underhill	44
-rachel ovid	45
-jessica davidson	45
-calvin johnson	45
-calvin johnson	45
-irene ichabod	46
-yuri johnson	47
-priscilla quirinius	47
-jessica brown	48
-yuri ichabod	48
-gabriella van buren	49
+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
+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
+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
+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
 PREHOOK: type: QUERY
 PREHOOK: Input: default@over10k
@@ -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.136070307	38.43	1
-2013-03-01 09:11:58.136070307	38.43	1
-2013-03-01 09:11:58.136070307	38.43	1
-2013-03-01 09:11:58.136070307	38.43	1
-2013-03-01 09:11:58.136070307	38.43	1
-2013-03-01 09:11:58.136070307	38.43	1
-2013-03-01 09:11:58.136070307	38.43	1
-2013-03-01 09:11:58.136070307	38.43	1
-2013-03-01 09:11:58.136070307	38.43	1
-2013-03-01 09:11:58.136070307	38.43	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	34.22	1
 PREHOOK: query: select ts, dec, rnk
 from
   (select ts, dec,
@@ -541,16 +541,16 @@ where dec = 89.5 limit 10
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@over10k
 #### A masked pattern was here ####
-2013-03-01 09:11:58.136070312	89.5	1
-2013-03-01 09:11:58.136070312	89.5	1
-2013-03-01 09:11:58.136070312	89.5	1
-2013-03-01 09:11:58.136070312	89.5	1
-2013-03-01 09:11:58.136070312	89.5	1
-2013-03-01 09:11:58.136070312	89.5	1
-2013-03-01 09:11:58.136070312	89.5	1
-2013-03-01 09:11:58.136070312	89.5	1
-2013-03-01 09:11:58.136070312	89.5	1
-2013-03-01 09:11:58.136070312	89.5	1
+2013-03-01 09:11:58.703124	89.5	1
+2013-03-01 09:11:58.703124	89.5	1
+2013-03-01 09:11:58.703124	89.5	1
+2013-03-01 09:11:58.703124	89.5	1
+2013-03-01 09:11:58.703124	89.5	1
+2013-03-01 09:11:58.703124	89.5	1
+2013-03-01 09:11:58.703124	89.5	1
+2013-03-01 09:11:58.703124	89.5	1
+2013-03-01 09:11:58.703124	89.5	1
+2013-03-01 09:11:58.703124	89.5	1
 PREHOOK: query: select ts, dec, rnk
 from
   (select ts, dec,
@@ -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.136070307	52.01	1
-2013-03-01 09:11:58.136070307	52.01	1
-2013-03-01 09:11:58.136070307	52.01	1
-2013-03-01 09:11:58.136070307	52.01	1
-2013-03-01 09:11:58.136070307	52.01	1
-2013-03-01 09:11:58.136070307	52.01	1
-2013-03-01 09:11:58.136070307	52.01	1
-2013-03-01 09:11:58.136070307	52.01	1
-2013-03-01 09:11:58.136070307	52.01	1
-2013-03-01 09:11:58.136070307	52.01	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	53.25	1
+2013-03-01 09:11:58.70307	79.99	1