framework/resources/Functional/window_functions/tpcds/query51.e_tsv - drill-test-framework - Git at Google

 1	1999-06-06	87.8	null	87.8	45.31
 1	1999-06-12	94.28	null	94.28	45.31
 8	1999-05-21	44.54	null	44.54	23.490000000000002
 13	1999-05-19	57.65	null	57.65	20.009999999999998
 13	1999-05-27	96.72999999999999	null	96.72999999999999	20.009999999999998
 16	1999-05-18	108.82	null	108.82	62.940000000000005
 16	1999-07-09	161.26	null	161.26	121.36
 16	1999-07-20	null	140.6	161.26	140.6
 16	1999-07-27	null	145.65	161.26	145.65
 16	1999-07-30	273.56	null	273.56	145.65
 16	1999-08-05	null	146.55	273.56	146.55
 16	1999-08-16	null	179.67000000000002	273.56	179.67000000000002
 16	1999-08-22	null	239.4	273.56	239.4
 16	1999-09-10	424.3	389.16	424.3	389.16
 16	1999-09-11	null	392.55	424.3	392.55
 16	1999-09-16	null	393.90000000000003	424.3	393.90000000000003
 16	1999-10-07	null	397.19000000000005	424.3	397.19000000000005
 25	1999-05-09	117.24	89.5	117.24	89.5
 25	1999-07-02	364.88	null	364.88	144.75
 25	1999-07-11	null	150.95	364.88	150.95
 25	1999-07-25	386.78	null	386.78	150.95
 25	1999-08-04	null	176.22	386.78	176.22
 25	1999-08-05	null	189.71	386.78	189.71
 25	1999-08-07	null	281.1	386.78	281.1
 25	1999-08-08	null	367.17	386.78	367.17
 28	1999-05-21	null	11.63	46.31	11.63
 28	1999-06-22	null	42.74	46.31	42.74
 31	1999-05-21	null	8.62	35.2	8.62
 32	1999-05-15	null	1.06	155.46	1.06
 32	1999-05-21	null	16.58	155.46	16.58
 32	1999-05-30	null	96.72	155.46	96.72
 34	1999-06-19	250.95000000000002	null	250.95000000000002	132.20000000000002
 34	1999-07-08	null	145.12	250.95000000000002	145.12
 34	1999-07-19	331.73	null	331.73	145.12
 34	1999-07-21	452.21000000000004	null	452.21000000000004	145.12
 34	1999-08-04	null	197.18	452.21000000000004	197.18
 34	1999-08-05	null	197.18	452.21000000000004	197.18
 34	1999-08-08	null	199.06	452.21000000000004	199.06
 34	1999-08-11	null	233.94	452.21000000000004	233.94
 34	1999-08-12	null	320.34000000000003	452.21000000000004	320.34000000000003
 34	1999-08-18	null	348.28000000000003	452.21000000000004	348.28000000000003
 34	1999-08-23	null	389.06000000000006	452.21000000000004	389.06000000000006
 34	1999-08-28	null	447.44000000000005	452.21000000000004	447.44000000000005
 34	1999-09-01	null	450.0400000000001	452.21000000000004	450.0400000000001
 34	1999-09-08	null	452.05000000000007	452.21000000000004	452.05000000000007
 35	2000-01-14	null	55.24	177.88	55.24
 35	2000-01-16	null	95.92	177.88	95.92
 35	2000-01-18	null	126.45	177.88	126.45
 35	2000-01-19	null	167.07	177.88	167.07
 35	2000-02-17	null	173.97	177.88	173.97
 35	2000-02-22	270.43	null	270.43	173.97
 35	2000-02-23	null	180.60999999999999	270.43	180.60999999999999
 35	2000-03-03	null	181.98999999999998	270.43	181.98999999999998
 35	2000-03-05	null	221.23999999999998	270.43	221.23999999999998
 35	2000-03-06	null	266.40999999999997	270.43	266.40999999999997
 37	1999-07-09	null	2.43	94.04	2.43
 37	1999-07-21	null	3.75	94.04	3.75
 37	1999-07-30	null	22.24	94.04	22.24
 37	1999-08-13	149.65	null	149.65	22.24
 37	1999-08-14	null	23.259999999999998	149.65	23.259999999999998
 37	1999-08-20	null	70.14	149.65	70.14
 37	1999-08-22	null	76.21000000000001	149.65	76.21000000000001
 37	1999-09-01	null	77.69000000000001	149.65	77.69000000000001
 37	1999-09-03	null	93.79000000000002	149.65	93.79000000000002
 37	1999-09-08	null	95.94000000000003	149.65	95.94000000000003
 37	1999-09-19	189.01	null	189.01	162.12000000000003
 37	1999-09-23	285.39	206.49000000000004	285.39	206.49000000000004
 37	1999-09-26	null	264.55000000000007	285.39	264.55000000000007
 37	1999-10-02	328.63	null	328.63	264.55000000000007
 37	1999-10-03	null	264.55000000000007	328.63	264.55000000000007
 37	1999-10-04	349.87	null	349.87	264.55000000000007
 37	1999-10-10	null	305.2200000000001	349.87	305.2200000000001
 37	1999-10-14	515.39	null	515.39	305.2200000000001
 37	1999-10-15	null	447.3900000000001	515.39	447.3900000000001
 37	1999-10-16	518.35	null	518.35	447.3900000000001
 37	1999-10-20	null	517.0200000000001	518.35	517.0200000000001
 40	1999-05-11	null	33.19	54.53	33.19
 40	1999-05-21	null	42.01	54.53	42.01
 41	2000-01-21	null	15.54	123.34	15.54
 41	2000-02-03	null	21.04	123.34	21.04
 41	2000-02-16	null	33.46	123.34	33.46
 41	2000-02-20	null	37.46	123.34	37.46
 41	2000-02-22	null	58.57	123.34	58.57
 41	2000-03-05	null	70.06	123.34	70.06
 41	2000-03-17	178.84	150.76	178.84	150.76
 41	2000-04-26	263.14000000000004	null	263.14000000000004	254.88
 53	2000-01-02	12.85	1.13	12.85	1.13
 53	2000-01-08	119.24	null	119.24	1.13
 53	2000-01-09	126.97999999999999	null	126.97999999999999	1.13
 53	2000-01-15	null	3.1999999999999997	126.97999999999999	3.1999999999999997
 53	2000-02-04	null	22.89	126.97999999999999	22.89
 53	2000-02-05	null	64.45	126.97999999999999	64.45
 53	2000-02-12	null	66.06	126.97999999999999	66.06
 56	1999-05-13	26.14	null	26.14	16.53
 56	1999-05-17	null	16.880000000000003	26.14	16.880000000000003
 56	1999-06-08	null	18.540000000000003	26.14	18.540000000000003
 61	1999-06-11	210.12	207.87000000000003	210.12	207.87000000000003
 61	1999-08-05	494.6	null	494.6	492.7800000000001
 70	1999-05-14	124.08	null	124.08	36.3
 70	1999-05-31	170.86	null	170.86	36.3
	1 1999-06-06 87.8 null 87.8 45.31
	1 1999-06-12 94.28 null 94.28 45.31
	8 1999-05-21 44.54 null 44.54 23.490000000000002
	13 1999-05-19 57.65 null 57.65 20.009999999999998
	13 1999-05-27 96.72999999999999 null 96.72999999999999 20.009999999999998
	16 1999-05-18 108.82 null 108.82 62.940000000000005
	16 1999-07-09 161.26 null 161.26 121.36
	16 1999-07-20 null 140.6 161.26 140.6
	16 1999-07-27 null 145.65 161.26 145.65
	16 1999-07-30 273.56 null 273.56 145.65
	16 1999-08-05 null 146.55 273.56 146.55
	16 1999-08-16 null 179.67000000000002 273.56 179.67000000000002
	16 1999-08-22 null 239.4 273.56 239.4
	16 1999-09-10 424.3 389.16 424.3 389.16
	16 1999-09-11 null 392.55 424.3 392.55
	16 1999-09-16 null 393.90000000000003 424.3 393.90000000000003
	16 1999-10-07 null 397.19000000000005 424.3 397.19000000000005
	25 1999-05-09 117.24 89.5 117.24 89.5
	25 1999-07-02 364.88 null 364.88 144.75
	25 1999-07-11 null 150.95 364.88 150.95
	25 1999-07-25 386.78 null 386.78 150.95
	25 1999-08-04 null 176.22 386.78 176.22
	25 1999-08-05 null 189.71 386.78 189.71
	25 1999-08-07 null 281.1 386.78 281.1
	25 1999-08-08 null 367.17 386.78 367.17
	28 1999-05-21 null 11.63 46.31 11.63
	28 1999-06-22 null 42.74 46.31 42.74
	31 1999-05-21 null 8.62 35.2 8.62
	32 1999-05-15 null 1.06 155.46 1.06
	32 1999-05-21 null 16.58 155.46 16.58
	32 1999-05-30 null 96.72 155.46 96.72
	34 1999-06-19 250.95000000000002 null 250.95000000000002 132.20000000000002
	34 1999-07-08 null 145.12 250.95000000000002 145.12
	34 1999-07-19 331.73 null 331.73 145.12
	34 1999-07-21 452.21000000000004 null 452.21000000000004 145.12
	34 1999-08-04 null 197.18 452.21000000000004 197.18
	34 1999-08-05 null 197.18 452.21000000000004 197.18
	34 1999-08-08 null 199.06 452.21000000000004 199.06
	34 1999-08-11 null 233.94 452.21000000000004 233.94
	34 1999-08-12 null 320.34000000000003 452.21000000000004 320.34000000000003
	34 1999-08-18 null 348.28000000000003 452.21000000000004 348.28000000000003
	34 1999-08-23 null 389.06000000000006 452.21000000000004 389.06000000000006
	34 1999-08-28 null 447.44000000000005 452.21000000000004 447.44000000000005
	34 1999-09-01 null 450.0400000000001 452.21000000000004 450.0400000000001
	34 1999-09-08 null 452.05000000000007 452.21000000000004 452.05000000000007
	35 2000-01-14 null 55.24 177.88 55.24
	35 2000-01-16 null 95.92 177.88 95.92
	35 2000-01-18 null 126.45 177.88 126.45
	35 2000-01-19 null 167.07 177.88 167.07
	35 2000-02-17 null 173.97 177.88 173.97
	35 2000-02-22 270.43 null 270.43 173.97
	35 2000-02-23 null 180.60999999999999 270.43 180.60999999999999
	35 2000-03-03 null 181.98999999999998 270.43 181.98999999999998
	35 2000-03-05 null 221.23999999999998 270.43 221.23999999999998
	35 2000-03-06 null 266.40999999999997 270.43 266.40999999999997
	37 1999-07-09 null 2.43 94.04 2.43
	37 1999-07-21 null 3.75 94.04 3.75
	37 1999-07-30 null 22.24 94.04 22.24
	37 1999-08-13 149.65 null 149.65 22.24
	37 1999-08-14 null 23.259999999999998 149.65 23.259999999999998
	37 1999-08-20 null 70.14 149.65 70.14
	37 1999-08-22 null 76.21000000000001 149.65 76.21000000000001
	37 1999-09-01 null 77.69000000000001 149.65 77.69000000000001
	37 1999-09-03 null 93.79000000000002 149.65 93.79000000000002
	37 1999-09-08 null 95.94000000000003 149.65 95.94000000000003
	37 1999-09-19 189.01 null 189.01 162.12000000000003
	37 1999-09-23 285.39 206.49000000000004 285.39 206.49000000000004
	37 1999-09-26 null 264.55000000000007 285.39 264.55000000000007
	37 1999-10-02 328.63 null 328.63 264.55000000000007
	37 1999-10-03 null 264.55000000000007 328.63 264.55000000000007
	37 1999-10-04 349.87 null 349.87 264.55000000000007
	37 1999-10-10 null 305.2200000000001 349.87 305.2200000000001
	37 1999-10-14 515.39 null 515.39 305.2200000000001
	37 1999-10-15 null 447.3900000000001 515.39 447.3900000000001
	37 1999-10-16 518.35 null 518.35 447.3900000000001
	37 1999-10-20 null 517.0200000000001 518.35 517.0200000000001
	40 1999-05-11 null 33.19 54.53 33.19
	40 1999-05-21 null 42.01 54.53 42.01
	41 2000-01-21 null 15.54 123.34 15.54
	41 2000-02-03 null 21.04 123.34 21.04
	41 2000-02-16 null 33.46 123.34 33.46
	41 2000-02-20 null 37.46 123.34 37.46
	41 2000-02-22 null 58.57 123.34 58.57
	41 2000-03-05 null 70.06 123.34 70.06
	41 2000-03-17 178.84 150.76 178.84 150.76
	41 2000-04-26 263.14000000000004 null 263.14000000000004 254.88
	53 2000-01-02 12.85 1.13 12.85 1.13
	53 2000-01-08 119.24 null 119.24 1.13
	53 2000-01-09 126.97999999999999 null 126.97999999999999 1.13
	53 2000-01-15 null 3.1999999999999997 126.97999999999999 3.1999999999999997
	53 2000-02-04 null 22.89 126.97999999999999 22.89
	53 2000-02-05 null 64.45 126.97999999999999 64.45
	53 2000-02-12 null 66.06 126.97999999999999 66.06
	56 1999-05-13 26.14 null 26.14 16.53
	56 1999-05-17 null 16.880000000000003 26.14 16.880000000000003
	56 1999-06-08 null 18.540000000000003 26.14 18.540000000000003
	61 1999-06-11 210.12 207.87000000000003 210.12 207.87000000000003
	61 1999-08-05 494.6 null 494.6 492.7800000000001
	70 1999-05-14 124.08 null 124.08 36.3
	70 1999-05-31 170.86 null 170.86 36.3