| ==== |
| ---- QUERY |
| select id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, |
| double_col, date_string_col, string_col, timestamp_col |
| from alltypessmall |
| ---- RESULTS |
| 0,true,0,0,0,0,0,0,'01/01/09','0',2009-01-01 00:00:00 |
| 1,false,1,1,1,10,1.100000023841858,10.1,'01/01/09','1',2009-01-01 00:01:00 |
| 10,true,0,0,0,0,0,0,'01/02/09','0',2009-01-02 00:10:00.450000000 |
| 11,false,1,1,1,10,1.100000023841858,10.1,'01/02/09','1',2009-01-02 00:11:00.450000000 |
| 12,true,2,2,2,20,2.200000047683716,20.2,'01/02/09','2',2009-01-02 00:12:00.460000000 |
| 13,false,3,3,3,30,3.299999952316284,30.3,'01/02/09','3',2009-01-02 00:13:00.480000000 |
| 14,true,4,4,4,40,4.400000095367432,40.4,'01/02/09','4',2009-01-02 00:14:00.510000000 |
| 15,false,5,5,5,50,5.5,50.5,'01/02/09','5',2009-01-02 00:15:00.550000000 |
| 16,true,6,6,6,60,6.599999904632568,60.6,'01/02/09','6',2009-01-02 00:16:00.600000000 |
| 17,false,7,7,7,70,7.699999809265137,70.7,'01/02/09','7',2009-01-02 00:17:00.660000000 |
| 18,true,8,8,8,80,8.800000190734863,80.8,'01/02/09','8',2009-01-02 00:18:00.730000000 |
| 19,false,9,9,9,90,9.899999618530273,90.90000000000001,'01/02/09','9',2009-01-02 00:19:00.810000000 |
| 2,true,2,2,2,20,2.200000047683716,20.2,'01/01/09','2',2009-01-01 00:02:00.100000000 |
| 20,true,0,0,0,0,0,0,'01/03/09','0',2009-01-03 00:20:00.900000000 |
| 21,false,1,1,1,10,1.100000023841858,10.1,'01/03/09','1',2009-01-03 00:21:00.900000000 |
| 22,true,2,2,2,20,2.200000047683716,20.2,'01/03/09','2',2009-01-03 00:22:00.910000000 |
| 23,false,3,3,3,30,3.299999952316284,30.3,'01/03/09','3',2009-01-03 00:23:00.930000000 |
| 24,true,4,4,4,40,4.400000095367432,40.4,'01/03/09','4',2009-01-03 00:24:00.960000000 |
| 25,false,0,0,0,0,0,0,'02/01/09','0',2009-02-01 00:00:00 |
| 26,true,1,1,1,10,1.100000023841858,10.1,'02/01/09','1',2009-02-01 00:01:00 |
| 27,false,2,2,2,20,2.200000047683716,20.2,'02/01/09','2',2009-02-01 00:02:00.100000000 |
| 28,true,3,3,3,30,3.299999952316284,30.3,'02/01/09','3',2009-02-01 00:03:00.300000000 |
| 29,false,4,4,4,40,4.400000095367432,40.4,'02/01/09','4',2009-02-01 00:04:00.600000000 |
| 3,false,3,3,3,30,3.299999952316284,30.3,'01/01/09','3',2009-01-01 00:03:00.300000000 |
| 30,true,5,5,5,50,5.5,50.5,'02/01/09','5',2009-02-01 00:05:00.100000000 |
| 31,false,6,6,6,60,6.599999904632568,60.6,'02/01/09','6',2009-02-01 00:06:00.150000000 |
| 32,true,7,7,7,70,7.699999809265137,70.7,'02/01/09','7',2009-02-01 00:07:00.210000000 |
| 33,false,8,8,8,80,8.800000190734863,80.8,'02/01/09','8',2009-02-01 00:08:00.280000000 |
| 34,true,9,9,9,90,9.899999618530273,90.90000000000001,'02/01/09','9',2009-02-01 00:09:00.360000000 |
| 35,false,0,0,0,0,0,0,'02/02/09','0',2009-02-02 00:10:00.450000000 |
| 36,true,1,1,1,10,1.100000023841858,10.1,'02/02/09','1',2009-02-02 00:11:00.450000000 |
| 37,false,2,2,2,20,2.200000047683716,20.2,'02/02/09','2',2009-02-02 00:12:00.460000000 |
| 38,true,3,3,3,30,3.299999952316284,30.3,'02/02/09','3',2009-02-02 00:13:00.480000000 |
| 39,false,4,4,4,40,4.400000095367432,40.4,'02/02/09','4',2009-02-02 00:14:00.510000000 |
| 4,true,4,4,4,40,4.400000095367432,40.4,'01/01/09','4',2009-01-01 00:04:00.600000000 |
| 40,true,5,5,5,50,5.5,50.5,'02/02/09','5',2009-02-02 00:15:00.550000000 |
| 41,false,6,6,6,60,6.599999904632568,60.6,'02/02/09','6',2009-02-02 00:16:00.600000000 |
| 42,true,7,7,7,70,7.699999809265137,70.7,'02/02/09','7',2009-02-02 00:17:00.660000000 |
| 43,false,8,8,8,80,8.800000190734863,80.8,'02/02/09','8',2009-02-02 00:18:00.730000000 |
| 44,true,9,9,9,90,9.899999618530273,90.90000000000001,'02/02/09','9',2009-02-02 00:19:00.810000000 |
| 45,false,0,0,0,0,0,0,'02/03/09','0',2009-02-03 00:20:00.900000000 |
| 46,true,1,1,1,10,1.100000023841858,10.1,'02/03/09','1',2009-02-03 00:21:00.900000000 |
| 47,false,2,2,2,20,2.200000047683716,20.2,'02/03/09','2',2009-02-03 00:22:00.910000000 |
| 48,true,3,3,3,30,3.299999952316284,30.3,'02/03/09','3',2009-02-03 00:23:00.930000000 |
| 49,false,4,4,4,40,4.400000095367432,40.4,'02/03/09','4',2009-02-03 00:24:00.960000000 |
| 5,false,5,5,5,50,5.5,50.5,'01/01/09','5',2009-01-01 00:05:00.100000000 |
| 50,true,0,0,0,0,0,0,'03/01/09','0',2009-03-01 00:00:00 |
| 51,false,1,1,1,10,1.100000023841858,10.1,'03/01/09','1',2009-03-01 00:01:00 |
| 52,true,2,2,2,20,2.200000047683716,20.2,'03/01/09','2',2009-03-01 00:02:00.100000000 |
| 53,false,3,3,3,30,3.299999952316284,30.3,'03/01/09','3',2009-03-01 00:03:00.300000000 |
| 54,true,4,4,4,40,4.400000095367432,40.4,'03/01/09','4',2009-03-01 00:04:00.600000000 |
| 55,false,5,5,5,50,5.5,50.5,'03/01/09','5',2009-03-01 00:05:00.100000000 |
| 56,true,6,6,6,60,6.599999904632568,60.6,'03/01/09','6',2009-03-01 00:06:00.150000000 |
| 57,false,7,7,7,70,7.699999809265137,70.7,'03/01/09','7',2009-03-01 00:07:00.210000000 |
| 58,true,8,8,8,80,8.800000190734863,80.8,'03/01/09','8',2009-03-01 00:08:00.280000000 |
| 59,false,9,9,9,90,9.899999618530273,90.90000000000001,'03/01/09','9',2009-03-01 00:09:00.360000000 |
| 6,true,6,6,6,60,6.599999904632568,60.6,'01/01/09','6',2009-01-01 00:06:00.150000000 |
| 60,true,0,0,0,0,0,0,'03/02/09','0',2009-03-02 00:10:00.450000000 |
| 61,false,1,1,1,10,1.100000023841858,10.1,'03/02/09','1',2009-03-02 00:11:00.450000000 |
| 62,true,2,2,2,20,2.200000047683716,20.2,'03/02/09','2',2009-03-02 00:12:00.460000000 |
| 63,false,3,3,3,30,3.299999952316284,30.3,'03/02/09','3',2009-03-02 00:13:00.480000000 |
| 64,true,4,4,4,40,4.400000095367432,40.4,'03/02/09','4',2009-03-02 00:14:00.510000000 |
| 65,false,5,5,5,50,5.5,50.5,'03/02/09','5',2009-03-02 00:15:00.550000000 |
| 66,true,6,6,6,60,6.599999904632568,60.6,'03/02/09','6',2009-03-02 00:16:00.600000000 |
| 67,false,7,7,7,70,7.699999809265137,70.7,'03/02/09','7',2009-03-02 00:17:00.660000000 |
| 68,true,8,8,8,80,8.800000190734863,80.8,'03/02/09','8',2009-03-02 00:18:00.730000000 |
| 69,false,9,9,9,90,9.899999618530273,90.90000000000001,'03/02/09','9',2009-03-02 00:19:00.810000000 |
| 7,false,7,7,7,70,7.699999809265137,70.7,'01/01/09','7',2009-01-01 00:07:00.210000000 |
| 70,true,0,0,0,0,0,0,'03/03/09','0',2009-03-03 00:20:00.900000000 |
| 71,false,1,1,1,10,1.100000023841858,10.1,'03/03/09','1',2009-03-03 00:21:00.900000000 |
| 72,true,2,2,2,20,2.200000047683716,20.2,'03/03/09','2',2009-03-03 00:22:00.910000000 |
| 73,false,3,3,3,30,3.299999952316284,30.3,'03/03/09','3',2009-03-03 00:23:00.930000000 |
| 74,true,4,4,4,40,4.400000095367432,40.4,'03/03/09','4',2009-03-03 00:24:00.960000000 |
| 75,false,0,0,0,0,0,0,'04/01/09','0',2009-04-01 00:00:00 |
| 76,true,1,1,1,10,1.100000023841858,10.1,'04/01/09','1',2009-04-01 00:01:00 |
| 77,false,2,2,2,20,2.200000047683716,20.2,'04/01/09','2',2009-04-01 00:02:00.100000000 |
| 78,true,3,3,3,30,3.299999952316284,30.3,'04/01/09','3',2009-04-01 00:03:00.300000000 |
| 79,false,4,4,4,40,4.400000095367432,40.4,'04/01/09','4',2009-04-01 00:04:00.600000000 |
| 8,true,8,8,8,80,8.800000190734863,80.8,'01/01/09','8',2009-01-01 00:08:00.280000000 |
| 80,true,5,5,5,50,5.5,50.5,'04/01/09','5',2009-04-01 00:05:00.100000000 |
| 81,false,6,6,6,60,6.599999904632568,60.6,'04/01/09','6',2009-04-01 00:06:00.150000000 |
| 82,true,7,7,7,70,7.699999809265137,70.7,'04/01/09','7',2009-04-01 00:07:00.210000000 |
| 83,false,8,8,8,80,8.800000190734863,80.8,'04/01/09','8',2009-04-01 00:08:00.280000000 |
| 84,true,9,9,9,90,9.899999618530273,90.90000000000001,'04/01/09','9',2009-04-01 00:09:00.360000000 |
| 85,false,0,0,0,0,0,0,'04/02/09','0',2009-04-02 00:10:00.450000000 |
| 86,true,1,1,1,10,1.100000023841858,10.1,'04/02/09','1',2009-04-02 00:11:00.450000000 |
| 87,false,2,2,2,20,2.200000047683716,20.2,'04/02/09','2',2009-04-02 00:12:00.460000000 |
| 88,true,3,3,3,30,3.299999952316284,30.3,'04/02/09','3',2009-04-02 00:13:00.480000000 |
| 89,false,4,4,4,40,4.400000095367432,40.4,'04/02/09','4',2009-04-02 00:14:00.510000000 |
| 9,false,9,9,9,90,9.899999618530273,90.90000000000001,'01/01/09','9',2009-01-01 00:09:00.360000000 |
| 90,true,5,5,5,50,5.5,50.5,'04/02/09','5',2009-04-02 00:15:00.550000000 |
| 91,false,6,6,6,60,6.599999904632568,60.6,'04/02/09','6',2009-04-02 00:16:00.600000000 |
| 92,true,7,7,7,70,7.699999809265137,70.7,'04/02/09','7',2009-04-02 00:17:00.660000000 |
| 93,false,8,8,8,80,8.800000190734863,80.8,'04/02/09','8',2009-04-02 00:18:00.730000000 |
| 94,true,9,9,9,90,9.899999618530273,90.90000000000001,'04/02/09','9',2009-04-02 00:19:00.810000000 |
| 95,false,0,0,0,0,0,0,'04/03/09','0',2009-04-03 00:20:00.900000000 |
| 96,true,1,1,1,10,1.100000023841858,10.1,'04/03/09','1',2009-04-03 00:21:00.900000000 |
| 97,false,2,2,2,20,2.200000047683716,20.2,'04/03/09','2',2009-04-03 00:22:00.910000000 |
| 98,true,3,3,3,30,3.299999952316284,30.3,'04/03/09','3',2009-04-03 00:23:00.930000000 |
| 99,false,4,4,4,40,4.400000095367432,40.4,'04/03/09','4',2009-04-03 00:24:00.960000000 |
| ---- TYPES |
| INT, BOOLEAN, TINYINT, SMALLINT, INT, BIGINT, FLOAT, DOUBLE, STRING, STRING, TIMESTAMP |
| ==== |
| ---- QUERY |
| # Notice the columns are ordered by family/qualifier |
| # and are not in the order declared in the DDL |
| select * from alltypessmall |
| ---- RESULTS |
| 0,0,true,'01/01/09',0,0,0,1,0,'0',2009-01-01 00:00:00,0,2009 |
| 1,10,false,'01/01/09',10.1,1.100000023841858,1,1,1,'1',2009-01-01 00:01:00,1,2009 |
| 10,0,true,'01/02/09',0,0,0,1,0,'0',2009-01-02 00:10:00.450000000,0,2009 |
| 11,10,false,'01/02/09',10.1,1.100000023841858,1,1,1,'1',2009-01-02 00:11:00.450000000,1,2009 |
| 12,20,true,'01/02/09',20.2,2.200000047683716,2,1,2,'2',2009-01-02 00:12:00.460000000,2,2009 |
| 13,30,false,'01/02/09',30.3,3.299999952316284,3,1,3,'3',2009-01-02 00:13:00.480000000,3,2009 |
| 14,40,true,'01/02/09',40.4,4.400000095367432,4,1,4,'4',2009-01-02 00:14:00.510000000,4,2009 |
| 15,50,false,'01/02/09',50.5,5.5,5,1,5,'5',2009-01-02 00:15:00.550000000,5,2009 |
| 16,60,true,'01/02/09',60.6,6.599999904632568,6,1,6,'6',2009-01-02 00:16:00.600000000,6,2009 |
| 17,70,false,'01/02/09',70.7,7.699999809265137,7,1,7,'7',2009-01-02 00:17:00.660000000,7,2009 |
| 18,80,true,'01/02/09',80.8,8.800000190734863,8,1,8,'8',2009-01-02 00:18:00.730000000,8,2009 |
| 19,90,false,'01/02/09',90.90000000000001,9.899999618530273,9,1,9,'9',2009-01-02 00:19:00.810000000,9,2009 |
| 2,20,true,'01/01/09',20.2,2.200000047683716,2,1,2,'2',2009-01-01 00:02:00.100000000,2,2009 |
| 20,0,true,'01/03/09',0,0,0,1,0,'0',2009-01-03 00:20:00.900000000,0,2009 |
| 21,10,false,'01/03/09',10.1,1.100000023841858,1,1,1,'1',2009-01-03 00:21:00.900000000,1,2009 |
| 22,20,true,'01/03/09',20.2,2.200000047683716,2,1,2,'2',2009-01-03 00:22:00.910000000,2,2009 |
| 23,30,false,'01/03/09',30.3,3.299999952316284,3,1,3,'3',2009-01-03 00:23:00.930000000,3,2009 |
| 24,40,true,'01/03/09',40.4,4.400000095367432,4,1,4,'4',2009-01-03 00:24:00.960000000,4,2009 |
| 25,0,false,'02/01/09',0,0,0,2,0,'0',2009-02-01 00:00:00,0,2009 |
| 26,10,true,'02/01/09',10.1,1.100000023841858,1,2,1,'1',2009-02-01 00:01:00,1,2009 |
| 27,20,false,'02/01/09',20.2,2.200000047683716,2,2,2,'2',2009-02-01 00:02:00.100000000,2,2009 |
| 28,30,true,'02/01/09',30.3,3.299999952316284,3,2,3,'3',2009-02-01 00:03:00.300000000,3,2009 |
| 29,40,false,'02/01/09',40.4,4.400000095367432,4,2,4,'4',2009-02-01 00:04:00.600000000,4,2009 |
| 3,30,false,'01/01/09',30.3,3.299999952316284,3,1,3,'3',2009-01-01 00:03:00.300000000,3,2009 |
| 30,50,true,'02/01/09',50.5,5.5,5,2,5,'5',2009-02-01 00:05:00.100000000,5,2009 |
| 31,60,false,'02/01/09',60.6,6.599999904632568,6,2,6,'6',2009-02-01 00:06:00.150000000,6,2009 |
| 32,70,true,'02/01/09',70.7,7.699999809265137,7,2,7,'7',2009-02-01 00:07:00.210000000,7,2009 |
| 33,80,false,'02/01/09',80.8,8.800000190734863,8,2,8,'8',2009-02-01 00:08:00.280000000,8,2009 |
| 34,90,true,'02/01/09',90.90000000000001,9.899999618530273,9,2,9,'9',2009-02-01 00:09:00.360000000,9,2009 |
| 35,0,false,'02/02/09',0,0,0,2,0,'0',2009-02-02 00:10:00.450000000,0,2009 |
| 36,10,true,'02/02/09',10.1,1.100000023841858,1,2,1,'1',2009-02-02 00:11:00.450000000,1,2009 |
| 37,20,false,'02/02/09',20.2,2.200000047683716,2,2,2,'2',2009-02-02 00:12:00.460000000,2,2009 |
| 38,30,true,'02/02/09',30.3,3.299999952316284,3,2,3,'3',2009-02-02 00:13:00.480000000,3,2009 |
| 39,40,false,'02/02/09',40.4,4.400000095367432,4,2,4,'4',2009-02-02 00:14:00.510000000,4,2009 |
| 4,40,true,'01/01/09',40.4,4.400000095367432,4,1,4,'4',2009-01-01 00:04:00.600000000,4,2009 |
| 40,50,true,'02/02/09',50.5,5.5,5,2,5,'5',2009-02-02 00:15:00.550000000,5,2009 |
| 41,60,false,'02/02/09',60.6,6.599999904632568,6,2,6,'6',2009-02-02 00:16:00.600000000,6,2009 |
| 42,70,true,'02/02/09',70.7,7.699999809265137,7,2,7,'7',2009-02-02 00:17:00.660000000,7,2009 |
| 43,80,false,'02/02/09',80.8,8.800000190734863,8,2,8,'8',2009-02-02 00:18:00.730000000,8,2009 |
| 44,90,true,'02/02/09',90.90000000000001,9.899999618530273,9,2,9,'9',2009-02-02 00:19:00.810000000,9,2009 |
| 45,0,false,'02/03/09',0,0,0,2,0,'0',2009-02-03 00:20:00.900000000,0,2009 |
| 46,10,true,'02/03/09',10.1,1.100000023841858,1,2,1,'1',2009-02-03 00:21:00.900000000,1,2009 |
| 47,20,false,'02/03/09',20.2,2.200000047683716,2,2,2,'2',2009-02-03 00:22:00.910000000,2,2009 |
| 48,30,true,'02/03/09',30.3,3.299999952316284,3,2,3,'3',2009-02-03 00:23:00.930000000,3,2009 |
| 49,40,false,'02/03/09',40.4,4.400000095367432,4,2,4,'4',2009-02-03 00:24:00.960000000,4,2009 |
| 5,50,false,'01/01/09',50.5,5.5,5,1,5,'5',2009-01-01 00:05:00.100000000,5,2009 |
| 50,0,true,'03/01/09',0,0,0,3,0,'0',2009-03-01 00:00:00,0,2009 |
| 51,10,false,'03/01/09',10.1,1.100000023841858,1,3,1,'1',2009-03-01 00:01:00,1,2009 |
| 52,20,true,'03/01/09',20.2,2.200000047683716,2,3,2,'2',2009-03-01 00:02:00.100000000,2,2009 |
| 53,30,false,'03/01/09',30.3,3.299999952316284,3,3,3,'3',2009-03-01 00:03:00.300000000,3,2009 |
| 54,40,true,'03/01/09',40.4,4.400000095367432,4,3,4,'4',2009-03-01 00:04:00.600000000,4,2009 |
| 55,50,false,'03/01/09',50.5,5.5,5,3,5,'5',2009-03-01 00:05:00.100000000,5,2009 |
| 56,60,true,'03/01/09',60.6,6.599999904632568,6,3,6,'6',2009-03-01 00:06:00.150000000,6,2009 |
| 57,70,false,'03/01/09',70.7,7.699999809265137,7,3,7,'7',2009-03-01 00:07:00.210000000,7,2009 |
| 58,80,true,'03/01/09',80.8,8.800000190734863,8,3,8,'8',2009-03-01 00:08:00.280000000,8,2009 |
| 59,90,false,'03/01/09',90.90000000000001,9.899999618530273,9,3,9,'9',2009-03-01 00:09:00.360000000,9,2009 |
| 6,60,true,'01/01/09',60.6,6.599999904632568,6,1,6,'6',2009-01-01 00:06:00.150000000,6,2009 |
| 60,0,true,'03/02/09',0,0,0,3,0,'0',2009-03-02 00:10:00.450000000,0,2009 |
| 61,10,false,'03/02/09',10.1,1.100000023841858,1,3,1,'1',2009-03-02 00:11:00.450000000,1,2009 |
| 62,20,true,'03/02/09',20.2,2.200000047683716,2,3,2,'2',2009-03-02 00:12:00.460000000,2,2009 |
| 63,30,false,'03/02/09',30.3,3.299999952316284,3,3,3,'3',2009-03-02 00:13:00.480000000,3,2009 |
| 64,40,true,'03/02/09',40.4,4.400000095367432,4,3,4,'4',2009-03-02 00:14:00.510000000,4,2009 |
| 65,50,false,'03/02/09',50.5,5.5,5,3,5,'5',2009-03-02 00:15:00.550000000,5,2009 |
| 66,60,true,'03/02/09',60.6,6.599999904632568,6,3,6,'6',2009-03-02 00:16:00.600000000,6,2009 |
| 67,70,false,'03/02/09',70.7,7.699999809265137,7,3,7,'7',2009-03-02 00:17:00.660000000,7,2009 |
| 68,80,true,'03/02/09',80.8,8.800000190734863,8,3,8,'8',2009-03-02 00:18:00.730000000,8,2009 |
| 69,90,false,'03/02/09',90.90000000000001,9.899999618530273,9,3,9,'9',2009-03-02 00:19:00.810000000,9,2009 |
| 7,70,false,'01/01/09',70.7,7.699999809265137,7,1,7,'7',2009-01-01 00:07:00.210000000,7,2009 |
| 70,0,true,'03/03/09',0,0,0,3,0,'0',2009-03-03 00:20:00.900000000,0,2009 |
| 71,10,false,'03/03/09',10.1,1.100000023841858,1,3,1,'1',2009-03-03 00:21:00.900000000,1,2009 |
| 72,20,true,'03/03/09',20.2,2.200000047683716,2,3,2,'2',2009-03-03 00:22:00.910000000,2,2009 |
| 73,30,false,'03/03/09',30.3,3.299999952316284,3,3,3,'3',2009-03-03 00:23:00.930000000,3,2009 |
| 74,40,true,'03/03/09',40.4,4.400000095367432,4,3,4,'4',2009-03-03 00:24:00.960000000,4,2009 |
| 75,0,false,'04/01/09',0,0,0,4,0,'0',2009-04-01 00:00:00,0,2009 |
| 76,10,true,'04/01/09',10.1,1.100000023841858,1,4,1,'1',2009-04-01 00:01:00,1,2009 |
| 77,20,false,'04/01/09',20.2,2.200000047683716,2,4,2,'2',2009-04-01 00:02:00.100000000,2,2009 |
| 78,30,true,'04/01/09',30.3,3.299999952316284,3,4,3,'3',2009-04-01 00:03:00.300000000,3,2009 |
| 79,40,false,'04/01/09',40.4,4.400000095367432,4,4,4,'4',2009-04-01 00:04:00.600000000,4,2009 |
| 8,80,true,'01/01/09',80.8,8.800000190734863,8,1,8,'8',2009-01-01 00:08:00.280000000,8,2009 |
| 80,50,true,'04/01/09',50.5,5.5,5,4,5,'5',2009-04-01 00:05:00.100000000,5,2009 |
| 81,60,false,'04/01/09',60.6,6.599999904632568,6,4,6,'6',2009-04-01 00:06:00.150000000,6,2009 |
| 82,70,true,'04/01/09',70.7,7.699999809265137,7,4,7,'7',2009-04-01 00:07:00.210000000,7,2009 |
| 83,80,false,'04/01/09',80.8,8.800000190734863,8,4,8,'8',2009-04-01 00:08:00.280000000,8,2009 |
| 84,90,true,'04/01/09',90.90000000000001,9.899999618530273,9,4,9,'9',2009-04-01 00:09:00.360000000,9,2009 |
| 85,0,false,'04/02/09',0,0,0,4,0,'0',2009-04-02 00:10:00.450000000,0,2009 |
| 86,10,true,'04/02/09',10.1,1.100000023841858,1,4,1,'1',2009-04-02 00:11:00.450000000,1,2009 |
| 87,20,false,'04/02/09',20.2,2.200000047683716,2,4,2,'2',2009-04-02 00:12:00.460000000,2,2009 |
| 88,30,true,'04/02/09',30.3,3.299999952316284,3,4,3,'3',2009-04-02 00:13:00.480000000,3,2009 |
| 89,40,false,'04/02/09',40.4,4.400000095367432,4,4,4,'4',2009-04-02 00:14:00.510000000,4,2009 |
| 9,90,false,'01/01/09',90.90000000000001,9.899999618530273,9,1,9,'9',2009-01-01 00:09:00.360000000,9,2009 |
| 90,50,true,'04/02/09',50.5,5.5,5,4,5,'5',2009-04-02 00:15:00.550000000,5,2009 |
| 91,60,false,'04/02/09',60.6,6.599999904632568,6,4,6,'6',2009-04-02 00:16:00.600000000,6,2009 |
| 92,70,true,'04/02/09',70.7,7.699999809265137,7,4,7,'7',2009-04-02 00:17:00.660000000,7,2009 |
| 93,80,false,'04/02/09',80.8,8.800000190734863,8,4,8,'8',2009-04-02 00:18:00.730000000,8,2009 |
| 94,90,true,'04/02/09',90.90000000000001,9.899999618530273,9,4,9,'9',2009-04-02 00:19:00.810000000,9,2009 |
| 95,0,false,'04/03/09',0,0,0,4,0,'0',2009-04-03 00:20:00.900000000,0,2009 |
| 96,10,true,'04/03/09',10.1,1.100000023841858,1,4,1,'1',2009-04-03 00:21:00.900000000,1,2009 |
| 97,20,false,'04/03/09',20.2,2.200000047683716,2,4,2,'2',2009-04-03 00:22:00.910000000,2,2009 |
| 98,30,true,'04/03/09',30.3,3.299999952316284,3,4,3,'3',2009-04-03 00:23:00.930000000,3,2009 |
| 99,40,false,'04/03/09',40.4,4.400000095367432,4,4,4,'4',2009-04-03 00:24:00.960000000,4,2009 |
| ---- TYPES |
| INT, BIGINT, BOOLEAN, STRING, DOUBLE, FLOAT, INT, INT, SMALLINT, STRING, TIMESTAMP, TINYINT, INT |
| ==== |
| ---- QUERY |
| select count(*) from alltypesagg where smallint_col is null and string_col is not null |
| ---- RESULTS |
| 100 |
| ---- TYPES |
| BIGINT |
| ==== |
| ---- QUERY |
| # show that the hdfs table has identical results |
| select count(*) from functional.alltypesagg where smallint_col is null and string_col is not null |
| ---- RESULTS |
| 200 |
| ---- TYPES |
| BIGINT |
| ==== |
| ---- QUERY |
| # HBase does not return rows if the selected columns don't exist. |
| # Since only smallint_col is selected, those expected NULLs don't appear. |
| # Therefore, the result returned by this query is zero. |
| select count(*) from alltypesagg where smallint_col is null |
| ---- RESULTS |
| 0 |
| ---- TYPES |
| BIGINT |
| ==== |
| ---- QUERY |
| # Compare this hdfs-equivalent query with the above one. |
| select count(*) from functional.alltypesagg where smallint_col is null |
| ---- RESULTS |
| 200 |
| ---- TYPES |
| BIGINT |
| ==== |
| ---- QUERY |
| # test adapted from aggregation.test but using the hbase equivalent table |
| select tinyint_col, count(bool_col) from alltypesagg group by 1 |
| ---- RESULTS |
| 3,1000 |
| 4,1000 |
| NULL,1000 |
| 1,1000 |
| 8,1000 |
| 6,1000 |
| 2,1000 |
| 5,1000 |
| 7,1000 |
| 9,1000 |
| ---- TYPES |
| TINYINT, BIGINT |
| ==== |
| ---- QUERY |
| # test adapted from aggregation.test but using the hbase equivalent table |
| # notice that the NULL value is missing because HBase does not |
| # return those rows where tinyint_col does not exist |
| select tinyint_col, count(*) from alltypesagg group by 1 |
| ---- RESULTS |
| 3,1000 |
| 4,1000 |
| 1,1000 |
| 8,1000 |
| 6,1000 |
| 2,1000 |
| 5,1000 |
| 7,1000 |
| 9,1000 |
| ---- TYPES |
| TINYINT, BIGINT |
| ==== |
| ---- QUERY |
| select tinyint_col, int_col % 10, count(*) from alltypesagg group by 1, 2 |
| ---- RESULTS |
| 7,7,1000 |
| 6,6,1000 |
| 5,5,1000 |
| NULL,0,990 |
| 4,4,1000 |
| 3,3,1000 |
| 2,2,1000 |
| 8,8,1000 |
| 1,1,1000 |
| 9,9,1000 |
| ---- TYPES |
| TINYINT, INT, BIGINT |
| ==== |
| ---- QUERY |
| select tinyint_col, count(*) from alltypesagg where (int_col % 10) = 0 group by tinyint_col |
| ---- RESULTS |
| NULL,990 |
| ---- TYPES |
| TINYINT, BIGINT |
| ==== |
| ---- QUERY |
| # test that conjuncts are evaluated even if no columns are referenced |
| select 1 from functional.alltypestiny where 3 > 4 |
| ---- RESULTS |
| ---- TYPES |
| TINYINT |
| ==== |
| ---- QUERY |
| select id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, |
| double_col, date_string_col, string_col, timestamp_col |
| from alltypessmallbinary |
| ---- RESULTS |
| 0,true,0,0,0,0,0,0,'01/01/09','0',2009-01-01 00:00:00 |
| 1,false,1,1,1,10,1.100000023841858,10.1,'01/01/09','1',2009-01-01 00:01:00 |
| 2,true,2,2,2,20,2.200000047683716,20.2,'01/01/09','2',2009-01-01 00:02:00.100000000 |
| 3,false,3,3,3,30,3.299999952316284,30.3,'01/01/09','3',2009-01-01 00:03:00.300000000 |
| 4,true,4,4,4,40,4.400000095367432,40.4,'01/01/09','4',2009-01-01 00:04:00.600000000 |
| 5,false,5,5,5,50,5.5,50.5,'01/01/09','5',2009-01-01 00:05:00.100000000 |
| 6,true,6,6,6,60,6.599999904632568,60.59999999999999,'01/01/09','6',2009-01-01 00:06:00.150000000 |
| 7,false,7,7,7,70,7.699999809265137,70.7,'01/01/09','7',2009-01-01 00:07:00.210000000 |
| 8,true,8,8,8,80,8.800000190734863,80.8,'01/01/09','8',2009-01-01 00:08:00.280000000 |
| 9,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/01/09','9',2009-01-01 00:09:00.360000000 |
| 10,true,0,0,0,0,0,0,'01/02/09','0',2009-01-02 00:10:00.450000000 |
| 11,false,1,1,1,10,1.100000023841858,10.1,'01/02/09','1',2009-01-02 00:11:00.450000000 |
| 12,true,2,2,2,20,2.200000047683716,20.2,'01/02/09','2',2009-01-02 00:12:00.460000000 |
| 13,false,3,3,3,30,3.299999952316284,30.3,'01/02/09','3',2009-01-02 00:13:00.480000000 |
| 14,true,4,4,4,40,4.400000095367432,40.4,'01/02/09','4',2009-01-02 00:14:00.510000000 |
| 15,false,5,5,5,50,5.5,50.5,'01/02/09','5',2009-01-02 00:15:00.550000000 |
| 16,true,6,6,6,60,6.599999904632568,60.59999999999999,'01/02/09','6',2009-01-02 00:16:00.600000000 |
| 17,false,7,7,7,70,7.699999809265137,70.7,'01/02/09','7',2009-01-02 00:17:00.660000000 |
| 18,true,8,8,8,80,8.800000190734863,80.8,'01/02/09','8',2009-01-02 00:18:00.730000000 |
| 19,false,9,9,9,90,9.899999618530273,90.89999999999999,'01/02/09','9',2009-01-02 00:19:00.810000000 |
| 20,true,0,0,0,0,0,0,'01/03/09','0',2009-01-03 00:20:00.900000000 |
| 21,false,1,1,1,10,1.100000023841858,10.1,'01/03/09','1',2009-01-03 00:21:00.900000000 |
| 22,true,2,2,2,20,2.200000047683716,20.2,'01/03/09','2',2009-01-03 00:22:00.910000000 |
| 23,false,3,3,3,30,3.299999952316284,30.3,'01/03/09','3',2009-01-03 00:23:00.930000000 |
| 24,true,4,4,4,40,4.400000095367432,40.4,'01/03/09','4',2009-01-03 00:24:00.960000000 |
| 25,false,0,0,0,0,0,0,'02/01/09','0',2009-02-01 00:00:00 |
| 26,true,1,1,1,10,1.100000023841858,10.1,'02/01/09','1',2009-02-01 00:01:00 |
| 27,false,2,2,2,20,2.200000047683716,20.2,'02/01/09','2',2009-02-01 00:02:00.100000000 |
| 28,true,3,3,3,30,3.299999952316284,30.3,'02/01/09','3',2009-02-01 00:03:00.300000000 |
| 29,false,4,4,4,40,4.400000095367432,40.4,'02/01/09','4',2009-02-01 00:04:00.600000000 |
| 30,true,5,5,5,50,5.5,50.5,'02/01/09','5',2009-02-01 00:05:00.100000000 |
| 31,false,6,6,6,60,6.599999904632568,60.59999999999999,'02/01/09','6',2009-02-01 00:06:00.150000000 |
| 32,true,7,7,7,70,7.699999809265137,70.7,'02/01/09','7',2009-02-01 00:07:00.210000000 |
| 33,false,8,8,8,80,8.800000190734863,80.8,'02/01/09','8',2009-02-01 00:08:00.280000000 |
| 34,true,9,9,9,90,9.899999618530273,90.89999999999999,'02/01/09','9',2009-02-01 00:09:00.360000000 |
| 35,false,0,0,0,0,0,0,'02/02/09','0',2009-02-02 00:10:00.450000000 |
| 36,true,1,1,1,10,1.100000023841858,10.1,'02/02/09','1',2009-02-02 00:11:00.450000000 |
| 37,false,2,2,2,20,2.200000047683716,20.2,'02/02/09','2',2009-02-02 00:12:00.460000000 |
| 38,true,3,3,3,30,3.299999952316284,30.3,'02/02/09','3',2009-02-02 00:13:00.480000000 |
| 39,false,4,4,4,40,4.400000095367432,40.4,'02/02/09','4',2009-02-02 00:14:00.510000000 |
| 40,true,5,5,5,50,5.5,50.5,'02/02/09','5',2009-02-02 00:15:00.550000000 |
| 41,false,6,6,6,60,6.599999904632568,60.59999999999999,'02/02/09','6',2009-02-02 00:16:00.600000000 |
| 42,true,7,7,7,70,7.699999809265137,70.7,'02/02/09','7',2009-02-02 00:17:00.660000000 |
| 43,false,8,8,8,80,8.800000190734863,80.8,'02/02/09','8',2009-02-02 00:18:00.730000000 |
| 44,true,9,9,9,90,9.899999618530273,90.89999999999999,'02/02/09','9',2009-02-02 00:19:00.810000000 |
| 45,false,0,0,0,0,0,0,'02/03/09','0',2009-02-03 00:20:00.900000000 |
| 46,true,1,1,1,10,1.100000023841858,10.1,'02/03/09','1',2009-02-03 00:21:00.900000000 |
| 47,false,2,2,2,20,2.200000047683716,20.2,'02/03/09','2',2009-02-03 00:22:00.910000000 |
| 48,true,3,3,3,30,3.299999952316284,30.3,'02/03/09','3',2009-02-03 00:23:00.930000000 |
| 49,false,4,4,4,40,4.400000095367432,40.4,'02/03/09','4',2009-02-03 00:24:00.960000000 |
| 50,true,0,0,0,0,0,0,'03/01/09','0',2009-03-01 00:00:00 |
| 51,false,1,1,1,10,1.100000023841858,10.1,'03/01/09','1',2009-03-01 00:01:00 |
| 52,true,2,2,2,20,2.200000047683716,20.2,'03/01/09','2',2009-03-01 00:02:00.100000000 |
| 53,false,3,3,3,30,3.299999952316284,30.3,'03/01/09','3',2009-03-01 00:03:00.300000000 |
| 54,true,4,4,4,40,4.400000095367432,40.4,'03/01/09','4',2009-03-01 00:04:00.600000000 |
| 55,false,5,5,5,50,5.5,50.5,'03/01/09','5',2009-03-01 00:05:00.100000000 |
| 56,true,6,6,6,60,6.599999904632568,60.59999999999999,'03/01/09','6',2009-03-01 00:06:00.150000000 |
| 57,false,7,7,7,70,7.699999809265137,70.7,'03/01/09','7',2009-03-01 00:07:00.210000000 |
| 58,true,8,8,8,80,8.800000190734863,80.8,'03/01/09','8',2009-03-01 00:08:00.280000000 |
| 59,false,9,9,9,90,9.899999618530273,90.89999999999999,'03/01/09','9',2009-03-01 00:09:00.360000000 |
| 60,true,0,0,0,0,0,0,'03/02/09','0',2009-03-02 00:10:00.450000000 |
| 61,false,1,1,1,10,1.100000023841858,10.1,'03/02/09','1',2009-03-02 00:11:00.450000000 |
| 62,true,2,2,2,20,2.200000047683716,20.2,'03/02/09','2',2009-03-02 00:12:00.460000000 |
| 63,false,3,3,3,30,3.299999952316284,30.3,'03/02/09','3',2009-03-02 00:13:00.480000000 |
| 64,true,4,4,4,40,4.400000095367432,40.4,'03/02/09','4',2009-03-02 00:14:00.510000000 |
| 65,false,5,5,5,50,5.5,50.5,'03/02/09','5',2009-03-02 00:15:00.550000000 |
| 66,true,6,6,6,60,6.599999904632568,60.59999999999999,'03/02/09','6',2009-03-02 00:16:00.600000000 |
| 67,false,7,7,7,70,7.699999809265137,70.7,'03/02/09','7',2009-03-02 00:17:00.660000000 |
| 68,true,8,8,8,80,8.800000190734863,80.8,'03/02/09','8',2009-03-02 00:18:00.730000000 |
| 69,false,9,9,9,90,9.899999618530273,90.89999999999999,'03/02/09','9',2009-03-02 00:19:00.810000000 |
| 70,true,0,0,0,0,0,0,'03/03/09','0',2009-03-03 00:20:00.900000000 |
| 71,false,1,1,1,10,1.100000023841858,10.1,'03/03/09','1',2009-03-03 00:21:00.900000000 |
| 72,true,2,2,2,20,2.200000047683716,20.2,'03/03/09','2',2009-03-03 00:22:00.910000000 |
| 73,false,3,3,3,30,3.299999952316284,30.3,'03/03/09','3',2009-03-03 00:23:00.930000000 |
| 74,true,4,4,4,40,4.400000095367432,40.4,'03/03/09','4',2009-03-03 00:24:00.960000000 |
| 75,false,0,0,0,0,0,0,'04/01/09','0',2009-04-01 00:00:00 |
| 76,true,1,1,1,10,1.100000023841858,10.1,'04/01/09','1',2009-04-01 00:01:00 |
| 77,false,2,2,2,20,2.200000047683716,20.2,'04/01/09','2',2009-04-01 00:02:00.100000000 |
| 78,true,3,3,3,30,3.299999952316284,30.3,'04/01/09','3',2009-04-01 00:03:00.300000000 |
| 79,false,4,4,4,40,4.400000095367432,40.4,'04/01/09','4',2009-04-01 00:04:00.600000000 |
| 80,true,5,5,5,50,5.5,50.5,'04/01/09','5',2009-04-01 00:05:00.100000000 |
| 81,false,6,6,6,60,6.599999904632568,60.59999999999999,'04/01/09','6',2009-04-01 00:06:00.150000000 |
| 82,true,7,7,7,70,7.699999809265137,70.7,'04/01/09','7',2009-04-01 00:07:00.210000000 |
| 83,false,8,8,8,80,8.800000190734863,80.8,'04/01/09','8',2009-04-01 00:08:00.280000000 |
| 84,true,9,9,9,90,9.899999618530273,90.89999999999999,'04/01/09','9',2009-04-01 00:09:00.360000000 |
| 85,false,0,0,0,0,0,0,'04/02/09','0',2009-04-02 00:10:00.450000000 |
| 86,true,1,1,1,10,1.100000023841858,10.1,'04/02/09','1',2009-04-02 00:11:00.450000000 |
| 87,false,2,2,2,20,2.200000047683716,20.2,'04/02/09','2',2009-04-02 00:12:00.460000000 |
| 88,true,3,3,3,30,3.299999952316284,30.3,'04/02/09','3',2009-04-02 00:13:00.480000000 |
| 89,false,4,4,4,40,4.400000095367432,40.4,'04/02/09','4',2009-04-02 00:14:00.510000000 |
| 90,true,5,5,5,50,5.5,50.5,'04/02/09','5',2009-04-02 00:15:00.550000000 |
| 91,false,6,6,6,60,6.599999904632568,60.59999999999999,'04/02/09','6',2009-04-02 00:16:00.600000000 |
| 92,true,7,7,7,70,7.699999809265137,70.7,'04/02/09','7',2009-04-02 00:17:00.660000000 |
| 93,false,8,8,8,80,8.800000190734863,80.8,'04/02/09','8',2009-04-02 00:18:00.730000000 |
| 94,true,9,9,9,90,9.899999618530273,90.89999999999999,'04/02/09','9',2009-04-02 00:19:00.810000000 |
| 95,false,0,0,0,0,0,0,'04/03/09','0',2009-04-03 00:20:00.900000000 |
| 96,true,1,1,1,10,1.100000023841858,10.1,'04/03/09','1',2009-04-03 00:21:00.900000000 |
| 97,false,2,2,2,20,2.200000047683716,20.2,'04/03/09','2',2009-04-03 00:22:00.910000000 |
| 98,true,3,3,3,30,3.299999952316284,30.3,'04/03/09','3',2009-04-03 00:23:00.930000000 |
| 99,false,4,4,4,40,4.400000095367432,40.4,'04/03/09','4',2009-04-03 00:24:00.960000000 |
| ---- TYPES |
| INT, BOOLEAN, TINYINT, SMALLINT, INT, BIGINT, FLOAT, DOUBLE, STRING, STRING, TIMESTAMP |
| ==== |
| ---- QUERY |
| select id from alltypessmallbinary |
| ---- RESULTS |
| 0 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
| 21 |
| 22 |
| 23 |
| 24 |
| 25 |
| 26 |
| 27 |
| 28 |
| 29 |
| 30 |
| 31 |
| 32 |
| 33 |
| 34 |
| 35 |
| 36 |
| 37 |
| 38 |
| 39 |
| 40 |
| 41 |
| 42 |
| 43 |
| 44 |
| 45 |
| 46 |
| 47 |
| 48 |
| 49 |
| 50 |
| 51 |
| 52 |
| 53 |
| 54 |
| 55 |
| 56 |
| 57 |
| 58 |
| 59 |
| 60 |
| 61 |
| 62 |
| 63 |
| 64 |
| 65 |
| 66 |
| 67 |
| 68 |
| 69 |
| 70 |
| 71 |
| 72 |
| 73 |
| 74 |
| 75 |
| 76 |
| 77 |
| 78 |
| 79 |
| 80 |
| 81 |
| 82 |
| 83 |
| 84 |
| 85 |
| 86 |
| 87 |
| 88 |
| 89 |
| 90 |
| 91 |
| 92 |
| 93 |
| 94 |
| 95 |
| 96 |
| 97 |
| 98 |
| 99 |
| ---- TYPES |
| INT |
| ==== |
| ---- QUERY |
| # Notice the columns are ordered by family/qualifier |
| # and are not in the order declared in the DDL |
| select * from alltypessmallbinary |
| ---- RESULTS |
| 0,0,true,'01/01/09',0,0,0,1,0,'0',2009-01-01 00:00:00,0,2009 |
| 1,10,false,'01/01/09',10.1,1.100000023841858,1,1,1,'1',2009-01-01 00:01:00,1,2009 |
| 2,20,true,'01/01/09',20.2,2.200000047683716,2,1,2,'2',2009-01-01 00:02:00.100000000,2,2009 |
| 3,30,false,'01/01/09',30.3,3.299999952316284,3,1,3,'3',2009-01-01 00:03:00.300000000,3,2009 |
| 4,40,true,'01/01/09',40.4,4.400000095367432,4,1,4,'4',2009-01-01 00:04:00.600000000,4,2009 |
| 5,50,false,'01/01/09',50.5,5.5,5,1,5,'5',2009-01-01 00:05:00.100000000,5,2009 |
| 6,60,true,'01/01/09',60.59999999999999,6.599999904632568,6,1,6,'6',2009-01-01 00:06:00.150000000,6,2009 |
| 7,70,false,'01/01/09',70.7,7.699999809265137,7,1,7,'7',2009-01-01 00:07:00.210000000,7,2009 |
| 8,80,true,'01/01/09',80.8,8.800000190734863,8,1,8,'8',2009-01-01 00:08:00.280000000,8,2009 |
| 9,90,false,'01/01/09',90.89999999999999,9.899999618530273,9,1,9,'9',2009-01-01 00:09:00.360000000,9,2009 |
| 10,0,true,'01/02/09',0,0,0,1,0,'0',2009-01-02 00:10:00.450000000,0,2009 |
| 11,10,false,'01/02/09',10.1,1.100000023841858,1,1,1,'1',2009-01-02 00:11:00.450000000,1,2009 |
| 12,20,true,'01/02/09',20.2,2.200000047683716,2,1,2,'2',2009-01-02 00:12:00.460000000,2,2009 |
| 13,30,false,'01/02/09',30.3,3.299999952316284,3,1,3,'3',2009-01-02 00:13:00.480000000,3,2009 |
| 14,40,true,'01/02/09',40.4,4.400000095367432,4,1,4,'4',2009-01-02 00:14:00.510000000,4,2009 |
| 15,50,false,'01/02/09',50.5,5.5,5,1,5,'5',2009-01-02 00:15:00.550000000,5,2009 |
| 16,60,true,'01/02/09',60.59999999999999,6.599999904632568,6,1,6,'6',2009-01-02 00:16:00.600000000,6,2009 |
| 17,70,false,'01/02/09',70.7,7.699999809265137,7,1,7,'7',2009-01-02 00:17:00.660000000,7,2009 |
| 18,80,true,'01/02/09',80.8,8.800000190734863,8,1,8,'8',2009-01-02 00:18:00.730000000,8,2009 |
| 19,90,false,'01/02/09',90.89999999999999,9.899999618530273,9,1,9,'9',2009-01-02 00:19:00.810000000,9,2009 |
| 20,0,true,'01/03/09',0,0,0,1,0,'0',2009-01-03 00:20:00.900000000,0,2009 |
| 21,10,false,'01/03/09',10.1,1.100000023841858,1,1,1,'1',2009-01-03 00:21:00.900000000,1,2009 |
| 22,20,true,'01/03/09',20.2,2.200000047683716,2,1,2,'2',2009-01-03 00:22:00.910000000,2,2009 |
| 23,30,false,'01/03/09',30.3,3.299999952316284,3,1,3,'3',2009-01-03 00:23:00.930000000,3,2009 |
| 24,40,true,'01/03/09',40.4,4.400000095367432,4,1,4,'4',2009-01-03 00:24:00.960000000,4,2009 |
| 25,0,false,'02/01/09',0,0,0,2,0,'0',2009-02-01 00:00:00,0,2009 |
| 26,10,true,'02/01/09',10.1,1.100000023841858,1,2,1,'1',2009-02-01 00:01:00,1,2009 |
| 27,20,false,'02/01/09',20.2,2.200000047683716,2,2,2,'2',2009-02-01 00:02:00.100000000,2,2009 |
| 28,30,true,'02/01/09',30.3,3.299999952316284,3,2,3,'3',2009-02-01 00:03:00.300000000,3,2009 |
| 29,40,false,'02/01/09',40.4,4.400000095367432,4,2,4,'4',2009-02-01 00:04:00.600000000,4,2009 |
| 30,50,true,'02/01/09',50.5,5.5,5,2,5,'5',2009-02-01 00:05:00.100000000,5,2009 |
| 31,60,false,'02/01/09',60.59999999999999,6.599999904632568,6,2,6,'6',2009-02-01 00:06:00.150000000,6,2009 |
| 32,70,true,'02/01/09',70.7,7.699999809265137,7,2,7,'7',2009-02-01 00:07:00.210000000,7,2009 |
| 33,80,false,'02/01/09',80.8,8.800000190734863,8,2,8,'8',2009-02-01 00:08:00.280000000,8,2009 |
| 34,90,true,'02/01/09',90.89999999999999,9.899999618530273,9,2,9,'9',2009-02-01 00:09:00.360000000,9,2009 |
| 35,0,false,'02/02/09',0,0,0,2,0,'0',2009-02-02 00:10:00.450000000,0,2009 |
| 36,10,true,'02/02/09',10.1,1.100000023841858,1,2,1,'1',2009-02-02 00:11:00.450000000,1,2009 |
| 37,20,false,'02/02/09',20.2,2.200000047683716,2,2,2,'2',2009-02-02 00:12:00.460000000,2,2009 |
| 38,30,true,'02/02/09',30.3,3.299999952316284,3,2,3,'3',2009-02-02 00:13:00.480000000,3,2009 |
| 39,40,false,'02/02/09',40.4,4.400000095367432,4,2,4,'4',2009-02-02 00:14:00.510000000,4,2009 |
| 40,50,true,'02/02/09',50.5,5.5,5,2,5,'5',2009-02-02 00:15:00.550000000,5,2009 |
| 41,60,false,'02/02/09',60.59999999999999,6.599999904632568,6,2,6,'6',2009-02-02 00:16:00.600000000,6,2009 |
| 42,70,true,'02/02/09',70.7,7.699999809265137,7,2,7,'7',2009-02-02 00:17:00.660000000,7,2009 |
| 43,80,false,'02/02/09',80.8,8.800000190734863,8,2,8,'8',2009-02-02 00:18:00.730000000,8,2009 |
| 44,90,true,'02/02/09',90.89999999999999,9.899999618530273,9,2,9,'9',2009-02-02 00:19:00.810000000,9,2009 |
| 45,0,false,'02/03/09',0,0,0,2,0,'0',2009-02-03 00:20:00.900000000,0,2009 |
| 46,10,true,'02/03/09',10.1,1.100000023841858,1,2,1,'1',2009-02-03 00:21:00.900000000,1,2009 |
| 47,20,false,'02/03/09',20.2,2.200000047683716,2,2,2,'2',2009-02-03 00:22:00.910000000,2,2009 |
| 48,30,true,'02/03/09',30.3,3.299999952316284,3,2,3,'3',2009-02-03 00:23:00.930000000,3,2009 |
| 49,40,false,'02/03/09',40.4,4.400000095367432,4,2,4,'4',2009-02-03 00:24:00.960000000,4,2009 |
| 50,0,true,'03/01/09',0,0,0,3,0,'0',2009-03-01 00:00:00,0,2009 |
| 51,10,false,'03/01/09',10.1,1.100000023841858,1,3,1,'1',2009-03-01 00:01:00,1,2009 |
| 52,20,true,'03/01/09',20.2,2.200000047683716,2,3,2,'2',2009-03-01 00:02:00.100000000,2,2009 |
| 53,30,false,'03/01/09',30.3,3.299999952316284,3,3,3,'3',2009-03-01 00:03:00.300000000,3,2009 |
| 54,40,true,'03/01/09',40.4,4.400000095367432,4,3,4,'4',2009-03-01 00:04:00.600000000,4,2009 |
| 55,50,false,'03/01/09',50.5,5.5,5,3,5,'5',2009-03-01 00:05:00.100000000,5,2009 |
| 56,60,true,'03/01/09',60.59999999999999,6.599999904632568,6,3,6,'6',2009-03-01 00:06:00.150000000,6,2009 |
| 57,70,false,'03/01/09',70.7,7.699999809265137,7,3,7,'7',2009-03-01 00:07:00.210000000,7,2009 |
| 58,80,true,'03/01/09',80.8,8.800000190734863,8,3,8,'8',2009-03-01 00:08:00.280000000,8,2009 |
| 59,90,false,'03/01/09',90.89999999999999,9.899999618530273,9,3,9,'9',2009-03-01 00:09:00.360000000,9,2009 |
| 60,0,true,'03/02/09',0,0,0,3,0,'0',2009-03-02 00:10:00.450000000,0,2009 |
| 61,10,false,'03/02/09',10.1,1.100000023841858,1,3,1,'1',2009-03-02 00:11:00.450000000,1,2009 |
| 62,20,true,'03/02/09',20.2,2.200000047683716,2,3,2,'2',2009-03-02 00:12:00.460000000,2,2009 |
| 63,30,false,'03/02/09',30.3,3.299999952316284,3,3,3,'3',2009-03-02 00:13:00.480000000,3,2009 |
| 64,40,true,'03/02/09',40.4,4.400000095367432,4,3,4,'4',2009-03-02 00:14:00.510000000,4,2009 |
| 65,50,false,'03/02/09',50.5,5.5,5,3,5,'5',2009-03-02 00:15:00.550000000,5,2009 |
| 66,60,true,'03/02/09',60.59999999999999,6.599999904632568,6,3,6,'6',2009-03-02 00:16:00.600000000,6,2009 |
| 67,70,false,'03/02/09',70.7,7.699999809265137,7,3,7,'7',2009-03-02 00:17:00.660000000,7,2009 |
| 68,80,true,'03/02/09',80.8,8.800000190734863,8,3,8,'8',2009-03-02 00:18:00.730000000,8,2009 |
| 69,90,false,'03/02/09',90.89999999999999,9.899999618530273,9,3,9,'9',2009-03-02 00:19:00.810000000,9,2009 |
| 70,0,true,'03/03/09',0,0,0,3,0,'0',2009-03-03 00:20:00.900000000,0,2009 |
| 71,10,false,'03/03/09',10.1,1.100000023841858,1,3,1,'1',2009-03-03 00:21:00.900000000,1,2009 |
| 72,20,true,'03/03/09',20.2,2.200000047683716,2,3,2,'2',2009-03-03 00:22:00.910000000,2,2009 |
| 73,30,false,'03/03/09',30.3,3.299999952316284,3,3,3,'3',2009-03-03 00:23:00.930000000,3,2009 |
| 74,40,true,'03/03/09',40.4,4.400000095367432,4,3,4,'4',2009-03-03 00:24:00.960000000,4,2009 |
| 75,0,false,'04/01/09',0,0,0,4,0,'0',2009-04-01 00:00:00,0,2009 |
| 76,10,true,'04/01/09',10.1,1.100000023841858,1,4,1,'1',2009-04-01 00:01:00,1,2009 |
| 77,20,false,'04/01/09',20.2,2.200000047683716,2,4,2,'2',2009-04-01 00:02:00.100000000,2,2009 |
| 78,30,true,'04/01/09',30.3,3.299999952316284,3,4,3,'3',2009-04-01 00:03:00.300000000,3,2009 |
| 79,40,false,'04/01/09',40.4,4.400000095367432,4,4,4,'4',2009-04-01 00:04:00.600000000,4,2009 |
| 80,50,true,'04/01/09',50.5,5.5,5,4,5,'5',2009-04-01 00:05:00.100000000,5,2009 |
| 81,60,false,'04/01/09',60.59999999999999,6.599999904632568,6,4,6,'6',2009-04-01 00:06:00.150000000,6,2009 |
| 82,70,true,'04/01/09',70.7,7.699999809265137,7,4,7,'7',2009-04-01 00:07:00.210000000,7,2009 |
| 83,80,false,'04/01/09',80.8,8.800000190734863,8,4,8,'8',2009-04-01 00:08:00.280000000,8,2009 |
| 84,90,true,'04/01/09',90.89999999999999,9.899999618530273,9,4,9,'9',2009-04-01 00:09:00.360000000,9,2009 |
| 85,0,false,'04/02/09',0,0,0,4,0,'0',2009-04-02 00:10:00.450000000,0,2009 |
| 86,10,true,'04/02/09',10.1,1.100000023841858,1,4,1,'1',2009-04-02 00:11:00.450000000,1,2009 |
| 87,20,false,'04/02/09',20.2,2.200000047683716,2,4,2,'2',2009-04-02 00:12:00.460000000,2,2009 |
| 88,30,true,'04/02/09',30.3,3.299999952316284,3,4,3,'3',2009-04-02 00:13:00.480000000,3,2009 |
| 89,40,false,'04/02/09',40.4,4.400000095367432,4,4,4,'4',2009-04-02 00:14:00.510000000,4,2009 |
| 90,50,true,'04/02/09',50.5,5.5,5,4,5,'5',2009-04-02 00:15:00.550000000,5,2009 |
| 91,60,false,'04/02/09',60.59999999999999,6.599999904632568,6,4,6,'6',2009-04-02 00:16:00.600000000,6,2009 |
| 92,70,true,'04/02/09',70.7,7.699999809265137,7,4,7,'7',2009-04-02 00:17:00.660000000,7,2009 |
| 93,80,false,'04/02/09',80.8,8.800000190734863,8,4,8,'8',2009-04-02 00:18:00.730000000,8,2009 |
| 94,90,true,'04/02/09',90.89999999999999,9.899999618530273,9,4,9,'9',2009-04-02 00:19:00.810000000,9,2009 |
| 95,0,false,'04/03/09',0,0,0,4,0,'0',2009-04-03 00:20:00.900000000,0,2009 |
| 96,10,true,'04/03/09',10.1,1.100000023841858,1,4,1,'1',2009-04-03 00:21:00.900000000,1,2009 |
| 97,20,false,'04/03/09',20.2,2.200000047683716,2,4,2,'2',2009-04-03 00:22:00.910000000,2,2009 |
| 98,30,true,'04/03/09',30.3,3.299999952316284,3,4,3,'3',2009-04-03 00:23:00.930000000,3,2009 |
| 99,40,false,'04/03/09',40.4,4.400000095367432,4,4,4,'4',2009-04-03 00:24:00.960000000,4,2009 |
| ---- TYPES |
| INT, BIGINT, BOOLEAN, STRING, DOUBLE, FLOAT, INT, INT, SMALLINT, STRING, TIMESTAMP, TINYINT, INT |
| ==== |
| ---- QUERY |
| # Scan an HBase table with multiple column families (IMPALA-4220) |
| select * from hbasecolumnfamilies |
| ---- RESULTS |
| 0,true,0,0,0,0,'01/01/09',0,0,'0',2009-01-01 00:00:00 |
| 1,false,1,1,1,10,'01/01/09',10.1,1.100000023841858,'1',2009-01-01 00:01:00 |
| 2,true,0,0,0,0,'02/01/09',0,0,'0',2009-02-01 00:00:00 |
| 3,false,1,1,1,10,'02/01/09',10.1,1.100000023841858,'1',2009-02-01 00:01:00 |
| 4,true,0,0,0,0,'03/01/09',0,0,'0',2009-03-01 00:00:00 |
| 5,false,1,1,1,10,'03/01/09',10.1,1.100000023841858,'1',2009-03-01 00:01:00 |
| 6,true,0,0,0,0,'04/01/09',0,0,'0',2009-04-01 00:00:00 |
| 7,false,1,1,1,10,'04/01/09',10.1,1.100000023841858,'1',2009-04-01 00:01:00 |
| ---- TYPES |
| INT, BOOLEAN, TINYINT, SMALLINT, INT, BIGINT, STRING, DOUBLE, FLOAT, STRING, TIMESTAMP |
| ==== |
| ---- QUERY |
| select id_col, date_part, date_col from date_tbl; |
| ---- RESULTS |
| 0,0001-01-01,0001-01-01 |
| 1,0001-01-01,0001-12-31 |
| 2,0001-01-01,0002-01-01 |
| 3,0001-01-01,1399-12-31 |
| 4,0001-01-01,2017-11-28 |
| 5,0001-01-01,9999-12-31 |
| 6,0001-01-01,NULL |
| 10,1399-06-27,2017-11-28 |
| 11,1399-06-27,NULL |
| 12,1399-06-27,2018-12-31 |
| 20,2017-11-27,0001-06-21 |
| 21,2017-11-27,0001-06-22 |
| 22,2017-11-27,0001-06-23 |
| 23,2017-11-27,0001-06-24 |
| 24,2017-11-27,0001-06-25 |
| 25,2017-11-27,0001-06-26 |
| 26,2017-11-27,0001-06-27 |
| 27,2017-11-27,0001-06-28 |
| 28,2017-11-27,0001-06-29 |
| 29,2017-11-27,2017-11-28 |
| 30,9999-12-31,9999-12-01 |
| 31,9999-12-31,9999-12-31 |
| ---- TYPES |
| INT,DATE,DATE |
| ==== |
| ---- QUERY |
| select count(*) from date_tbl where date_col is null and date_part is not null |
| ---- RESULTS |
| 2 |
| ---- TYPES |
| BIGINT |
| ==== |
| ---- QUERY |
| # show that the hdfs table has identical results |
| select count(*) from functional.date_tbl where date_col is null and date_part is not null |
| ---- RESULTS |
| 2 |
| ---- TYPES |
| BIGINT |
| ==== |
| ---- QUERY |
| # HBase does not return rows if the selected columns don't exist. |
| # Since only date_col is selected, those expected NULLs don't appear. |
| # Therefore, the result returned by this query is zero. |
| select count(*) from date_tbl where date_col is null |
| ---- RESULTS |
| 0 |
| ---- TYPES |
| BIGINT |
| ==== |
| ---- QUERY |
| # Compare this hdfs-equivalent query with the above one. |
| select count(*) from functional.date_tbl where date_col is null |
| ---- RESULTS |
| 2 |
| ---- TYPES |
| BIGINT |
| ==== |
| ---- QUERY |
| select date_col, count(date_part) from date_tbl group by 1 |
| ---- RESULTS |
| 1399-12-31,1 |
| 0001-06-28,1 |
| 9999-12-31,2 |
| 0001-06-27,1 |
| 2018-12-31,1 |
| 0001-06-23,1 |
| 0002-01-01,1 |
| 0001-06-21,1 |
| 2017-11-28,3 |
| 0001-06-29,1 |
| 0001-06-22,1 |
| 0001-12-31,1 |
| 0001-06-24,1 |
| 0001-06-26,1 |
| 9999-12-01,1 |
| 0001-06-25,1 |
| 0001-01-01,1 |
| NULL,2 |
| ---- TYPES |
| DATE, BIGINT |
| ==== |
| ---- QUERY |
| # Notice that the NULL value is missing because HBase does not |
| # return those rows where date_col does not exist |
| select date_col, count(*) from date_tbl group by 1 |
| ---- RESULTS |
| 1399-12-31,1 |
| 0001-06-28,1 |
| 9999-12-31,2 |
| 0001-06-27,1 |
| 2018-12-31,1 |
| 0001-06-23,1 |
| 0002-01-01,1 |
| 0001-06-21,1 |
| 2017-11-28,3 |
| 0001-06-29,1 |
| 0001-06-22,1 |
| 0001-12-31,1 |
| 0001-06-24,1 |
| 0001-06-26,1 |
| 9999-12-01,1 |
| 0001-06-25,1 |
| 0001-01-01,1 |
| ---- TYPES |
| DATE, BIGINT |
| ==== |
| ---- QUERY |
| select date_col, date_part, count(*) from date_tbl group by 1, 2 |
| ---- RESULTS |
| 0001-01-01,0001-01-01,1 |
| 0001-06-21,2017-11-27,1 |
| 0001-06-22,2017-11-27,1 |
| 0001-06-23,2017-11-27,1 |
| 0001-06-24,2017-11-27,1 |
| 0001-06-25,2017-11-27,1 |
| 0001-06-26,2017-11-27,1 |
| 0001-06-27,2017-11-27,1 |
| 0001-06-28,2017-11-27,1 |
| 0001-06-29,2017-11-27,1 |
| 0001-12-31,0001-01-01,1 |
| 0002-01-01,0001-01-01,1 |
| 1399-12-31,0001-01-01,1 |
| 2017-11-28,0001-01-01,1 |
| 2017-11-28,1399-06-27,1 |
| 2017-11-28,2017-11-27,1 |
| 2018-12-31,1399-06-27,1 |
| 9999-12-01,9999-12-31,1 |
| 9999-12-31,0001-01-01,1 |
| 9999-12-31,9999-12-31,1 |
| NULL,0001-01-01,1 |
| NULL,1399-06-27,1 |
| ---- TYPES |
| DATE, DATE, BIGINT |
| ==== |
| ---- QUERY |
| select date_col, count(*) from date_tbl where date_part = '1399-06-27' group by date_col |
| ---- RESULTS |
| NULL,1 |
| 2018-12-31,1 |
| 2017-11-28,1 |
| ---- TYPES |
| DATE, BIGINT |
| ==== |
