| # These tests check that page selection and value-skipping works well for all types |
| # of plain-encoded columns. Queries have predicates on different columns, might have |
| # multiple predicates joined by AND. This way we can test how page filtering combines |
| # these predicates to filter out even more rows. |
| ==== |
| ---- QUERY |
| select * from alltypes_tiny_pages_plain where id < 30 |
| ---- RESULTS |
| 13,false,3,3,3,30,3.299999952316284,30.3,'01/02/09','3',2009-01-01 23:13:00.480000000,2009,1 |
| 12,true,2,2,2,20,2.200000047683716,20.2,'01/02/09','2',2009-01-01 23:12:00.460000000,2009,1 |
| 11,false,1,1,1,10,1.100000023841858,10.1,'01/02/09','1',2009-01-01 23:11:00.450000000,2009,1 |
| 10,true,0,0,0,0,0,0,'01/02/09','0',2009-01-01 23:10:00.450000000,2009,1 |
| 9,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/01/09','9',2008-12-31 23:09:00.360000000,2009,1 |
| 8,true,8,8,8,80,8.800000190734863,80.8,'01/01/09','8',2008-12-31 23:08:00.280000000,2009,1 |
| 7,false,7,7,7,70,7.699999809265137,70.7,'01/01/09','7',2008-12-31 23:07:00.210000000,2009,1 |
| 6,true,6,6,6,60,6.599999904632568,60.59999999999999,'01/01/09','6',2008-12-31 23:06:00.150000000,2009,1 |
| 5,false,5,5,5,50,5.5,50.5,'01/01/09','5',2008-12-31 23:05:00.100000000,2009,1 |
| 4,true,4,4,4,40,4.400000095367432,40.4,'01/01/09','4',2008-12-31 23:04:00.600000000,2009,1 |
| 3,false,3,3,3,30,3.299999952316284,30.3,'01/01/09','3',2008-12-31 23:03:00.300000000,2009,1 |
| 2,true,2,2,2,20,2.200000047683716,20.2,'01/01/09','2',2008-12-31 23:02:00.100000000,2009,1 |
| 1,false,1,1,1,10,1.100000023841858,10.1,'01/01/09','1',2008-12-31 23:01:00,2009,1 |
| 0,true,0,0,0,0,0,0,'01/01/09','0',2008-12-31 23:00:00,2009,1 |
| 29,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/03/09','9',2009-01-02 23:29:01.260000000,2009,1 |
| 28,true,8,8,8,80,8.800000190734863,80.8,'01/03/09','8',2009-01-02 23:28:01.180000000,2009,1 |
| 27,false,7,7,7,70,7.699999809265137,70.7,'01/03/09','7',2009-01-02 23:27:01.110000000,2009,1 |
| 26,true,6,6,6,60,6.599999904632568,60.59999999999999,'01/03/09','6',2009-01-02 23:26:01.500000000,2009,1 |
| 25,false,5,5,5,50,5.5,50.5,'01/03/09','5',2009-01-02 23:25:01,2009,1 |
| 24,true,4,4,4,40,4.400000095367432,40.4,'01/03/09','4',2009-01-02 23:24:00.960000000,2009,1 |
| 23,false,3,3,3,30,3.299999952316284,30.3,'01/03/09','3',2009-01-02 23:23:00.930000000,2009,1 |
| 22,true,2,2,2,20,2.200000047683716,20.2,'01/03/09','2',2009-01-02 23:22:00.910000000,2009,1 |
| 21,false,1,1,1,10,1.100000023841858,10.1,'01/03/09','1',2009-01-02 23:21:00.900000000,2009,1 |
| 20,true,0,0,0,0,0,0,'01/03/09','0',2009-01-02 23:20:00.900000000,2009,1 |
| 19,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/02/09','9',2009-01-01 23:19:00.810000000,2009,1 |
| 18,true,8,8,8,80,8.800000190734863,80.8,'01/02/09','8',2009-01-01 23:18:00.730000000,2009,1 |
| 17,false,7,7,7,70,7.699999809265137,70.7,'01/02/09','7',2009-01-01 23:17:00.660000000,2009,1 |
| 16,true,6,6,6,60,6.599999904632568,60.59999999999999,'01/02/09','6',2009-01-01 23:16:00.600000000,2009,1 |
| 15,false,5,5,5,50,5.5,50.5,'01/02/09','5',2009-01-01 23:15:00.550000000,2009,1 |
| 14,true,4,4,4,40,4.400000095367432,40.4,'01/02/09','4',2009-01-01 23:14:00.510000000,2009,1 |
| ---- TYPES |
| INT, BOOLEAN, TINYINT, SMALLINT, INT, BIGINT, FLOAT, DOUBLE, STRING, STRING, TIMESTAMP, INT, INT |
| ---- RUNTIME_PROFILE |
| aggregation(SUM, NumStatsFilteredPages): 5656 |
| ==== |
| ---- QUERY |
| select * from alltypes_tiny_pages_plain where id > 7270 |
| ---- RESULTS |
| 7290,true,0,0,0,0,0,0,'12/31/10','0',2010-12-31 04:00:13.500000000,2010,12 |
| 7291,false,1,1,1,10,1.100000023841858,10.1,'12/31/10','1',2010-12-31 04:01:13.500000000,2010,12 |
| 7292,true,2,2,2,20,2.200000047683716,20.2,'12/31/10','2',2010-12-31 04:02:13.510000000,2010,12 |
| 7293,false,3,3,3,30,3.299999952316284,30.3,'12/31/10','3',2010-12-31 04:03:13.530000000,2010,12 |
| 7294,true,4,4,4,40,4.400000095367432,40.4,'12/31/10','4',2010-12-31 04:04:13.560000000,2010,12 |
| 7295,false,5,5,5,50,5.5,50.5,'12/31/10','5',2010-12-31 04:05:13.600000000,2010,12 |
| 7296,true,6,6,6,60,6.599999904632568,60.59999999999999,'12/31/10','6',2010-12-31 04:06:13.650000000,2010,12 |
| 7297,false,7,7,7,70,7.699999809265137,70.7,'12/31/10','7',2010-12-31 04:07:13.710000000,2010,12 |
| 7298,true,8,8,8,80,8.800000190734863,80.8,'12/31/10','8',2010-12-31 04:08:13.780000000,2010,12 |
| 7299,false,9,9,9,90,9.899999618530273,90.89999999999999,'12/31/10','9',2010-12-31 04:09:13.860000000,2010,12 |
| 7289,false,9,9,9,90,9.899999618530273,90.89999999999999,'12/30/10','9',2010-12-30 03:59:13.410000000,2010,12 |
| 7288,true,8,8,8,80,8.800000190734863,80.8,'12/30/10','8',2010-12-30 03:58:13.330000000,2010,12 |
| 7287,false,7,7,7,70,7.699999809265137,70.7,'12/30/10','7',2010-12-30 03:57:13.260000000,2010,12 |
| 7286,true,6,6,6,60,6.599999904632568,60.59999999999999,'12/30/10','6',2010-12-30 03:56:13.200000000,2010,12 |
| 7285,false,5,5,5,50,5.5,50.5,'12/30/10','5',2010-12-30 03:55:13.150000000,2010,12 |
| 7284,true,4,4,4,40,4.400000095367432,40.4,'12/30/10','4',2010-12-30 03:54:13.110000000,2010,12 |
| 7283,false,3,3,3,30,3.299999952316284,30.3,'12/30/10','3',2010-12-30 03:53:13.800000000,2010,12 |
| 7282,true,2,2,2,20,2.200000047683716,20.2,'12/30/10','2',2010-12-30 03:52:13.600000000,2010,12 |
| 7281,false,1,1,1,10,1.100000023841858,10.1,'12/30/10','1',2010-12-30 03:51:13.500000000,2010,12 |
| 7280,true,0,0,0,0,0,0,'12/30/10','0',2010-12-30 03:50:13.500000000,2010,12 |
| 7279,false,9,9,9,90,9.899999618530273,90.89999999999999,'12/29/10','9',2010-12-29 03:49:12.960000000,2010,12 |
| 7278,true,8,8,8,80,8.800000190734863,80.8,'12/29/10','8',2010-12-29 03:48:12.880000000,2010,12 |
| 7277,false,7,7,7,70,7.699999809265137,70.7,'12/29/10','7',2010-12-29 03:47:12.810000000,2010,12 |
| 7276,true,6,6,6,60,6.599999904632568,60.59999999999999,'12/29/10','6',2010-12-29 03:46:12.750000000,2010,12 |
| 7275,false,5,5,5,50,5.5,50.5,'12/29/10','5',2010-12-29 03:45:12.700000000,2010,12 |
| 7274,true,4,4,4,40,4.400000095367432,40.4,'12/29/10','4',2010-12-29 03:44:12.660000000,2010,12 |
| 7273,false,3,3,3,30,3.299999952316284,30.3,'12/29/10','3',2010-12-29 03:43:12.630000000,2010,12 |
| 7272,true,2,2,2,20,2.200000047683716,20.2,'12/29/10','2',2010-12-29 03:42:12.610000000,2010,12 |
| 7271,false,1,1,1,10,1.100000023841858,10.1,'12/29/10','1',2010-12-29 03:41:12.600000000,2010,12 |
| ---- TYPES |
| INT, BOOLEAN, TINYINT, SMALLINT, INT, BIGINT, FLOAT, DOUBLE, STRING, STRING, TIMESTAMP, INT, INT |
| ---- RUNTIME_PROFILE |
| aggregation(SUM, NumStatsFilteredPages): 5656 |
| ==== |
| ---- QUERY |
| select * from alltypes_tiny_pages_plain where id > 2300 and id < 2310 |
| ---- RESULTS |
| 2309,false,9,9,9,90,9.899999618530273,90.89999999999999,'08/19/09','9',2009-08-19 01:09:08.460000000,2009,8 |
| 2308,true,8,8,8,80,8.800000190734863,80.8,'08/19/09','8',2009-08-19 01:08:08.380000000,2009,8 |
| 2307,false,7,7,7,70,7.699999809265137,70.7,'08/19/09','7',2009-08-19 01:07:08.310000000,2009,8 |
| 2306,true,6,6,6,60,6.599999904632568,60.59999999999999,'08/19/09','6',2009-08-19 01:06:08.250000000,2009,8 |
| 2305,false,5,5,5,50,5.5,50.5,'08/19/09','5',2009-08-19 01:05:08.200000000,2009,8 |
| 2304,true,4,4,4,40,4.400000095367432,40.4,'08/19/09','4',2009-08-19 01:04:08.160000000,2009,8 |
| 2303,false,3,3,3,30,3.299999952316284,30.3,'08/19/09','3',2009-08-19 01:03:08.130000000,2009,8 |
| 2302,true,2,2,2,20,2.200000047683716,20.2,'08/19/09','2',2009-08-19 01:02:08.110000000,2009,8 |
| 2301,false,1,1,1,10,1.100000023841858,10.1,'08/19/09','1',2009-08-19 01:01:08.100000000,2009,8 |
| ---- TYPES |
| INT, BOOLEAN, TINYINT, SMALLINT, INT, BIGINT, FLOAT, DOUBLE, STRING, STRING, TIMESTAMP, INT, INT |
| ---- RUNTIME_PROFILE |
| aggregation(SUM, NumStatsFilteredPages): 5560 |
| ==== |
| ---- QUERY |
| select * from alltypes_tiny_pages_plain where bigint_col = 0 and month = 7 and year = 2010 |
| ---- RESULTS |
| 5540,true,0,0,0,0,0,0,'07/09/10','0',2010-07-08 23:20:03.600000000,2010,7 |
| 5530,true,0,0,0,0,0,0,'07/08/10','0',2010-07-07 23:10:03.150000000,2010,7 |
| 5520,true,0,0,0,0,0,0,'07/07/10','0',2010-07-06 23:00:02.700000000,2010,7 |
| 5560,true,0,0,0,0,0,0,'07/11/10','0',2010-07-10 23:40:04.500000000,2010,7 |
| 5550,true,0,0,0,0,0,0,'07/10/10','0',2010-07-09 23:30:04.500000000,2010,7 |
| 5490,true,0,0,0,0,0,0,'07/04/10','0',2010-07-03 22:30:01.350000000,2010,7 |
| 5480,true,0,0,0,0,0,0,'07/03/10','0',2010-07-02 22:20:00.900000000,2010,7 |
| 5470,true,0,0,0,0,0,0,'07/02/10','0',2010-07-01 22:10:00.450000000,2010,7 |
| 5510,true,0,0,0,0,0,0,'07/06/10','0',2010-07-05 22:50:02.250000000,2010,7 |
| 5500,true,0,0,0,0,0,0,'07/05/10','0',2010-07-04 22:40:01.800000000,2010,7 |
| 5640,true,0,0,0,0,0,0,'07/19/10','0',2010-07-19 01:00:08.100000000,2010,7 |
| 5630,true,0,0,0,0,0,0,'07/18/10','0',2010-07-18 00:50:07.650000000,2010,7 |
| 5670,true,0,0,0,0,0,0,'07/22/10','0',2010-07-22 01:30:09.450000000,2010,7 |
| 5660,true,0,0,0,0,0,0,'07/21/10','0',2010-07-21 01:20:09,2010,7 |
| 5650,true,0,0,0,0,0,0,'07/20/10','0',2010-07-20 01:10:08.550000000,2010,7 |
| 5590,true,0,0,0,0,0,0,'07/14/10','0',2010-07-14 00:10:05.850000000,2010,7 |
| 5580,true,0,0,0,0,0,0,'07/13/10','0',2010-07-13 00:00:05.400000000,2010,7 |
| 5570,true,0,0,0,0,0,0,'07/12/10','0',2010-07-11 23:50:04.950000000,2010,7 |
| 5620,true,0,0,0,0,0,0,'07/17/10','0',2010-07-17 00:40:07.200000000,2010,7 |
| 5610,true,0,0,0,0,0,0,'07/16/10','0',2010-07-16 00:30:06.750000000,2010,7 |
| 5600,true,0,0,0,0,0,0,'07/15/10','0',2010-07-15 00:20:06.300000000,2010,7 |
| 5740,true,0,0,0,0,0,0,'07/29/10','0',2010-07-29 02:40:12.600000000,2010,7 |
| 5730,true,0,0,0,0,0,0,'07/28/10','0',2010-07-28 02:30:12.150000000,2010,7 |
| 5720,true,0,0,0,0,0,0,'07/27/10','0',2010-07-27 02:20:11.700000000,2010,7 |
| 5760,true,0,0,0,0,0,0,'07/31/10','0',2010-07-31 03:00:13.500000000,2010,7 |
| 5750,true,0,0,0,0,0,0,'07/30/10','0',2010-07-30 02:50:13.500000000,2010,7 |
| 5690,true,0,0,0,0,0,0,'07/24/10','0',2010-07-24 01:50:10.350000000,2010,7 |
| 5680,true,0,0,0,0,0,0,'07/23/10','0',2010-07-23 01:40:09.900000000,2010,7 |
| 5460,true,0,0,0,0,0,0,'07/01/10','0',2010-06-30 22:00:00,2010,7 |
| 5710,true,0,0,0,0,0,0,'07/26/10','0',2010-07-26 02:10:11.250000000,2010,7 |
| 5700,true,0,0,0,0,0,0,'07/25/10','0',2010-07-25 02:00:10.800000000,2010,7 |
| ---- TYPES |
| INT, BOOLEAN, TINYINT, SMALLINT, INT, BIGINT, FLOAT, DOUBLE, STRING, STRING, TIMESTAMP, INT, INT |
| ---- RUNTIME_PROFILE |
| aggregation(SUM, NumStatsFilteredPages): 5380 |
| ==== |
| ---- QUERY |
| select * from alltypes_tiny_pages_plain where date_string_col = '02/02/09' |
| ---- RESULTS |
| 320,true,0,0,0,0,0,0,'02/02/09','0',2009-02-01 23:10:00.450000000,2009,2 |
| 321,false,1,1,1,10,1.100000023841858,10.1,'02/02/09','1',2009-02-01 23:11:00.450000000,2009,2 |
| 322,true,2,2,2,20,2.200000047683716,20.2,'02/02/09','2',2009-02-01 23:12:00.460000000,2009,2 |
| 323,false,3,3,3,30,3.299999952316284,30.3,'02/02/09','3',2009-02-01 23:13:00.480000000,2009,2 |
| 324,true,4,4,4,40,4.400000095367432,40.4,'02/02/09','4',2009-02-01 23:14:00.510000000,2009,2 |
| 325,false,5,5,5,50,5.5,50.5,'02/02/09','5',2009-02-01 23:15:00.550000000,2009,2 |
| 326,true,6,6,6,60,6.599999904632568,60.59999999999999,'02/02/09','6',2009-02-01 23:16:00.600000000,2009,2 |
| 327,false,7,7,7,70,7.699999809265137,70.7,'02/02/09','7',2009-02-01 23:17:00.660000000,2009,2 |
| 328,true,8,8,8,80,8.800000190734863,80.8,'02/02/09','8',2009-02-01 23:18:00.730000000,2009,2 |
| 329,false,9,9,9,90,9.899999618530273,90.89999999999999,'02/02/09','9',2009-02-01 23:19:00.810000000,2009,2 |
| ---- TYPES |
| INT, BOOLEAN, TINYINT, SMALLINT, INT, BIGINT, FLOAT, DOUBLE, STRING, STRING, TIMESTAMP, INT, INT |
| ---- RUNTIME_PROFILE |
| aggregation(SUM, NumStatsFilteredPages): 5624 |
| ==== |
| ---- QUERY |
| select * from alltypes_tiny_pages_plain |
| where month = 1 and smallint_col = 9 and timestamp_col < '2009-12-08 00:19:03' |
| ---- RESULTS |
| 129,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/13/09','9',2009-01-13 01:09:05.760000000,2009,1 |
| 139,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/14/09','9',2009-01-14 01:19:06.210000000,2009,1 |
| 99,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/10/09','9',2009-01-10 00:39:04.410000000,2009,1 |
| 109,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/11/09','9',2009-01-11 00:49:04.860000000,2009,1 |
| 119,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/12/09','9',2009-01-12 00:59:05.310000000,2009,1 |
| 179,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/18/09','9',2009-01-18 01:59:08.100000000,2009,1 |
| 189,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/19/09','9',2009-01-19 02:09:08.460000000,2009,1 |
| 149,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/15/09','9',2009-01-15 01:29:06.660000000,2009,1 |
| 159,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/16/09','9',2009-01-16 01:39:07.110000000,2009,1 |
| 169,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/17/09','9',2009-01-17 01:49:07.560000000,2009,1 |
| 59,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/06/09','9',2009-01-05 23:59:02.610000000,2009,1 |
| 49,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/05/09','9',2009-01-04 23:49:02.160000000,2009,1 |
| 39,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/04/09','9',2009-01-03 23:39:01.710000000,2009,1 |
| 79,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/08/09','9',2009-01-08 00:19:03.510000000,2009,1 |
| 69,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/07/09','9',2009-01-07 00:09:03.600000000,2009,1 |
| 9,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/01/09','9',2008-12-31 23:09:00.360000000,2009,1 |
| 89,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/09/09','9',2009-01-09 00:29:03.960000000,2009,1 |
| 29,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/03/09','9',2009-01-02 23:29:01.260000000,2009,1 |
| 19,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/02/09','9',2009-01-01 23:19:00.810000000,2009,1 |
| 279,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/28/09','9',2009-01-28 03:39:12.510000000,2009,1 |
| 269,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/27/09','9',2009-01-27 03:29:12.600000000,2009,1 |
| 259,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/26/09','9',2009-01-26 03:19:11.610000000,2009,1 |
| 309,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/31/09','9',2009-01-31 04:09:13.860000000,2009,1 |
| 299,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/30/09','9',2009-01-30 03:59:13.410000000,2009,1 |
| 289,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/29/09','9',2009-01-29 03:49:12.960000000,2009,1 |
| 219,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/22/09','9',2009-01-22 02:39:09.810000000,2009,1 |
| 209,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/21/09','9',2009-01-21 02:29:09.360000000,2009,1 |
| 199,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/20/09','9',2009-01-20 02:19:08.910000000,2009,1 |
| 249,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/25/09','9',2009-01-25 03:09:11.160000000,2009,1 |
| 239,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/24/09','9',2009-01-24 02:59:10.710000000,2009,1 |
| 229,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/23/09','9',2009-01-23 02:49:10.260000000,2009,1 |
| ---- TYPES |
| INT, BOOLEAN, TINYINT, SMALLINT, INT, BIGINT, FLOAT, DOUBLE, STRING, STRING, TIMESTAMP, INT, INT |
| ---- RUNTIME_PROFILE |
| aggregation(SUM, NumStatsFilteredPages): 5199 |
| ==== |
| ---- QUERY |
| select * from alltypes_tiny_pages_plain |
| where double_col > 70 and double_col < 71 and month = 8 and year = 2010 |
| ---- RESULTS |
| 6037,false,7,7,7,70,7.699999809265137,70.7,'08/27/10','7',2010-08-27 02:27:11.910000000,2010,8 |
| 6027,false,7,7,7,70,7.699999809265137,70.7,'08/26/10','7',2010-08-26 02:17:11.460000000,2010,8 |
| 6067,false,7,7,7,70,7.699999809265137,70.7,'08/30/10','7',2010-08-30 02:57:13.260000000,2010,8 |
| 6057,false,7,7,7,70,7.699999809265137,70.7,'08/29/10','7',2010-08-29 02:47:12.810000000,2010,8 |
| 6047,false,7,7,7,70,7.699999809265137,70.7,'08/28/10','7',2010-08-28 02:37:12.360000000,2010,8 |
| 5987,false,7,7,7,70,7.699999809265137,70.7,'08/22/10','7',2010-08-22 01:37:09.660000000,2010,8 |
| 5977,false,7,7,7,70,7.699999809265137,70.7,'08/21/10','7',2010-08-21 01:27:09.210000000,2010,8 |
| 6017,false,7,7,7,70,7.699999809265137,70.7,'08/25/10','7',2010-08-25 02:07:11.100000000,2010,8 |
| 6007,false,7,7,7,70,7.699999809265137,70.7,'08/24/10','7',2010-08-24 01:57:10.560000000,2010,8 |
| 5997,false,7,7,7,70,7.699999809265137,70.7,'08/23/10','7',2010-08-23 01:47:10.110000000,2010,8 |
| 5837,false,7,7,7,70,7.699999809265137,70.7,'08/07/10','7',2010-08-06 23:07:02.910000000,2010,8 |
| 5827,false,7,7,7,70,7.699999809265137,70.7,'08/06/10','7',2010-08-05 22:57:02.460000000,2010,8 |
| 5867,false,7,7,7,70,7.699999809265137,70.7,'08/10/10','7',2010-08-09 23:37:04.260000000,2010,8 |
| 5857,false,7,7,7,70,7.699999809265137,70.7,'08/09/10','7',2010-08-08 23:27:03.810000000,2010,8 |
| 5847,false,7,7,7,70,7.699999809265137,70.7,'08/08/10','7',2010-08-07 23:17:03.360000000,2010,8 |
| 5787,false,7,7,7,70,7.699999809265137,70.7,'08/02/10','7',2010-08-01 22:17:00.660000000,2010,8 |
| 5777,false,7,7,7,70,7.699999809265137,70.7,'08/01/10','7',2010-07-31 22:07:00.210000000,2010,8 |
| 5817,false,7,7,7,70,7.699999809265137,70.7,'08/05/10','7',2010-08-04 22:47:02.100000000,2010,8 |
| 5807,false,7,7,7,70,7.699999809265137,70.7,'08/04/10','7',2010-08-03 22:37:01.560000000,2010,8 |
| 5797,false,7,7,7,70,7.699999809265137,70.7,'08/03/10','7',2010-08-02 22:27:01.110000000,2010,8 |
| 5937,false,7,7,7,70,7.699999809265137,70.7,'08/17/10','7',2010-08-17 00:47:07.410000000,2010,8 |
| 5927,false,7,7,7,70,7.699999809265137,70.7,'08/16/10','7',2010-08-16 00:37:06.960000000,2010,8 |
| 5967,false,7,7,7,70,7.699999809265137,70.7,'08/20/10','7',2010-08-20 01:17:08.760000000,2010,8 |
| 5957,false,7,7,7,70,7.699999809265137,70.7,'08/19/10','7',2010-08-19 01:07:08.310000000,2010,8 |
| 5947,false,7,7,7,70,7.699999809265137,70.7,'08/18/10','7',2010-08-18 00:57:07.860000000,2010,8 |
| 5887,false,7,7,7,70,7.699999809265137,70.7,'08/12/10','7',2010-08-11 23:57:05.160000000,2010,8 |
| 5877,false,7,7,7,70,7.699999809265137,70.7,'08/11/10','7',2010-08-10 23:47:04.710000000,2010,8 |
| 5917,false,7,7,7,70,7.699999809265137,70.7,'08/15/10','7',2010-08-15 00:27:06.510000000,2010,8 |
| 5907,false,7,7,7,70,7.699999809265137,70.7,'08/14/10','7',2010-08-14 00:17:06.600000000,2010,8 |
| 5897,false,7,7,7,70,7.699999809265137,70.7,'08/13/10','7',2010-08-13 00:07:05.610000000,2010,8 |
| 6077,false,7,7,7,70,7.699999809265137,70.7,'08/31/10','7',2010-08-31 03:07:13.710000000,2010,8 |
| ---- TYPES |
| INT, BOOLEAN, TINYINT, SMALLINT, INT, BIGINT, FLOAT, DOUBLE, STRING, STRING, TIMESTAMP, INT, INT |
| ---- RUNTIME_PROFILE |
| aggregation(SUM, NumStatsFilteredPages): 5381 |
| ==== |