| ==== |
| ---- QUERY |
| select * from hbasealltypeserror |
| ---- ERRORS |
| Error converting column d:timestamp_col: '0' to TIMESTAMP |
| hbase table: functional_hbase.hbasealltypeserror |
| row key: 0 |
| Error converting column d:bool_col: 'errfalse' to BOOL |
| hbase table: functional_hbase.hbasealltypeserror |
| row key: 1 |
| Error converting column d:double_col: 'xyz30.300000' to DOUBLE |
| Error converting column d:float_col: 'xyz3.000000' to FLOAT |
| hbase table: functional_hbase.hbasealltypeserror |
| row key: 13 |
| Error converting column d:timestamp_col: '0009-01-01 00:00:00' to TIMESTAMP |
| Error converting column d:tinyint_col: 'xyz5' to TINYINT |
| hbase table: functional_hbase.hbasealltypeserror |
| row key: 15 |
| Error converting column d:timestamp_col: '0' to TIMESTAMP |
| hbase table: functional_hbase.hbasealltypeserror |
| row key: 16 |
| Error converting column d:double_col: 'xyz70.700000' to DOUBLE |
| hbase table: functional_hbase.hbasealltypeserror |
| row key: 17 |
| Error converting column d:timestamp_col: '1999-10-10 90:10:10' to TIMESTAMP |
| Error converting column d:tinyint_col: 'err2' to TINYINT |
| hbase table: functional_hbase.hbasealltypeserror |
| row key: 2 |
| Error converting column d:timestamp_col: '2020-20-10 10:10:10.123' to TIMESTAMP |
| hbase table: functional_hbase.hbasealltypeserror |
| row key: 21 |
| Error converting column d:timestamp_col: '2020-10-40 10:10:10.123' to TIMESTAMP |
| hbase table: functional_hbase.hbasealltypeserror |
| row key: 22 |
| Error converting column d:smallint_col: 'abc3' to SMALLINT |
| Error converting column d:timestamp_col: '2020-10-10 60:10:10.123' to TIMESTAMP |
| hbase table: functional_hbase.hbasealltypeserror |
| row key: 23 |
| Error converting column d:timestamp_col: '2020-10-10 10:70:10.123' to TIMESTAMP |
| hbase table: functional_hbase.hbasealltypeserror |
| row key: 24 |
| Error converting column d:int_col: 'abc5' to INT |
| hbase table: functional_hbase.hbasealltypeserror |
| row key: 25 |
| Error converting column d:tinyint_col: 'abc7' to TINYINT |
| hbase table: functional_hbase.hbasealltypeserror |
| row key: 27 |
| Error converting column d:int_col: 'abc9' to INT |
| hbase table: functional_hbase.hbasealltypeserror |
| row key: 29 |
| Error converting column d:smallint_col: 'err3' to SMALLINT |
| Error converting column d:timestamp_col: '2002-14-10 00:00:00' to TIMESTAMP |
| hbase table: functional_hbase.hbasealltypeserror |
| row key: 3 |
| Error converting column d:bigint_col: 'err300' to BIGINT |
| Error converting column d:bool_col: 't\rue' to BOOL |
| Error converting column d:double_col: 'err300.900000' to DOUBLE |
| Error converting column d:float_col: 'err30..000000' to FLOAT |
| Error converting column d:int_col: 'err30' to INT |
| Error converting column d:smallint_col: 'err30' to SMALLINT |
| Error converting column d:timestamp_col: '0000-01-01 00:00:00' to TIMESTAMP |
| Error converting column d:tinyint_col: 'err30' to TINYINT |
| hbase table: functional_hbase.hbasealltypeserror |
| row key: 30 |
| Error converting column d:int_col: 'err4' to INT |
| hbase table: functional_hbase.hbasealltypeserror |
| row key: 4 |
| Error converting column d:bigint_col: 'err50' to BIGINT |
| hbase table: functional_hbase.hbasealltypeserror |
| row key: 5 |
| Error converting column d:float_col: 'err6.000000' to FLOAT |
| hbase table: functional_hbase.hbasealltypeserror |
| row key: 6 |
| Error converting column d:double_col: 'err70.700000' to DOUBLE |
| hbase table: functional_hbase.hbasealltypeserror |
| row key: 7 |
| Error converting column d:bigint_col: 'err90' to BIGINT |
| Error converting column d:bool_col: 'errtrue' to BOOL |
| Error converting column d:double_col: 'err90.900000' to DOUBLE |
| Error converting column d:float_col: 'err9.000000' to FLOAT |
| Error converting column d:int_col: 'err9' to INT |
| Error converting column d:smallint_col: 'err9' to SMALLINT |
| Error converting column d:timestamp_col: '0000-01-01 00:00:00' to TIMESTAMP |
| Error converting column d:tinyint_col: 'err9' to TINYINT |
| hbase table: functional_hbase.hbasealltypeserror |
| row key: 9 |
| ---- FILEERRORS |
| file: hbasealltypeserror,15 |
| ---- TYPES |
| int, bigint, boolean, string, double, float, int, smallint, string, timestamp, tinyint |
| ---- RESULTS |
| 0,0,NULL,'01/01/09',0,0,0,0,'0',NULL,NULL |
| 1,10,NULL,'01/01/09',10.1,1,1,1,'1',1999-10-10 00:00:00,NULL |
| 10,0,NULL,'02/01/09',0,0,0,NULL,'0',2009-01-01 00:00:00,NULL |
| 11,10,false,'02/01/09',10.1,1,NULL,NULL,'1',2009-01-01 00:00:00,NULL |
| 12,NULL,true,'02/01/09',20.2,2,NULL,NULL,'2',2009-01-01 00:00:00,2 |
| 13,NULL,false,'02/01/09',NULL,NULL,NULL,3,'3',2009-01-01 00:00:00,3 |
| 14,40,true,'02/01/09',NULL,NULL,4,4,'4',2009-01-01 00:00:00,4 |
| 15,50,false,'02/01/09',50.5,5,5,5,'5',NULL,NULL |
| 16,NULL,NULL,'02/01/09',NULL,NULL,NULL,NULL,'6',NULL,NULL |
| 17,70,false,'02/01/09',NULL,7,7,7,'7',2009-01-01 00:00:00,7 |
| 18,80,true,'02/01/09',80.8,8,8,8,'8',2009-01-01 00:00:00,8 |
| 19,90,false,'02/01/09',90.90000000000001,9,9,9,'9',2009-01-01 00:00:00,9 |
| 2,20,true,'01/01/09',20.2,2,2,NULL,'2',NULL,NULL |
| 20,0,true,'03/01/09',0,0,0,0,'0',2020-10-10 10:10:10.123000000,0 |
| 21,10,false,'03/01/09',10.1,1,1,1,'1',NULL,1 |
| 22,20,true,'03/01/09',20.2,2,2,2,'2',NULL,2 |
| 23,30,false,'03/01/09',30.3,3,3,NULL,'3',NULL,3 |
| 24,40,true,'03/01/09',40.4,4,4,4,'4',NULL,4 |
| 25,50,false,'03/01/09',50.5,5,NULL,5,'5',2020-10-10 10:10:10.123000000,5 |
| 26,60,true,'03/01/09',60.6,6,6,6,'6',2020-10-10 10:10:10.123000000,6 |
| 27,70,false,'03/01/09',70.7,7,7,7,'7',2020-10-10 10:10:10.123000000,NULL |
| 28,80,true,'03/01/09',80.8,8,8,8,'8',2020-10-10 10:10:10.123000000,8 |
| 29,90,false,'03/01/09',90.90000000000001,9,NULL,9,'9',2020-10-10 10:10:10.123000000,9 |
| 3,30,false,'01/01/09',30.3,3,NULL,NULL,'3',NULL,3 |
| 30,NULL,NULL,'01/01/10',NULL,NULL,NULL,NULL,'10',NULL,NULL |
| 4,NULL,true,'01/01/09',40.4,4,NULL,4,'4',1970-01-01 00:00:00,4 |
| 5,NULL,false,'01/01/09',50.5,NULL,5,5,'5',1970-01-01 00:00:00,5 |
| 6,60,true,'01/01/09',NULL,NULL,6,6,'6',1970-01-01 00:00:00,6 |
| 7,70,NULL,'01/01/09',NULL,7,7,7,'7',1970-01-01 00:00:00,NULL |
| 8,80,false,'01/01/09',80.8,8,8,NULL,'8',1970-01-01 00:00:00,NULL |
| 9,NULL,NULL,'01/01/09',NULL,NULL,NULL,NULL,'9',NULL,NULL |
| ==== |
| ---- QUERY |
| select * from hbasealltypeserrornonulls |
| ---- ERRORS |
| Error converting column d:timestamp_col: '123456' to TIMESTAMP |
| hbase table: functional_hbase.hbasealltypeserrornonulls |
| row key: 0 |
| Error converting column d:bool_col: 'errfalse' to BOOL |
| Error converting column d:timestamp_col: '1990-00-01 10:10:10' to TIMESTAMP |
| hbase table: functional_hbase.hbasealltypeserrornonulls |
| row key: 1 |
| Error converting column d:double_col: 'xyz30.300000' to DOUBLE |
| Error converting column d:float_col: 'xyz3.000000' to FLOAT |
| hbase table: functional_hbase.hbasealltypeserrornonulls |
| row key: 13 |
| Error converting column d:tinyint_col: 'xyz5' to TINYINT |
| hbase table: functional_hbase.hbasealltypeserrornonulls |
| row key: 15 |
| Error converting column d:double_col: 'xyz70.700000' to DOUBLE |
| hbase table: functional_hbase.hbasealltypeserrornonulls |
| row key: 17 |
| Error converting column d:tinyint_col: 'err2' to TINYINT |
| hbase table: functional_hbase.hbasealltypeserrornonulls |
| row key: 2 |
| Error converting column d:smallint_col: 'abc3' to SMALLINT |
| hbase table: functional_hbase.hbasealltypeserrornonulls |
| row key: 23 |
| Error converting column d:int_col: 'abc5' to INT |
| Error converting column d:timestamp_col: '2012-Mar-22 11:20:01.123' to TIMESTAMP |
| hbase table: functional_hbase.hbasealltypeserrornonulls |
| row key: 25 |
| Error converting column d:tinyint_col: 'abc7' to TINYINT |
| hbase table: functional_hbase.hbasealltypeserrornonulls |
| row key: 27 |
| Error converting column d:timestamp_col: '11:20:01.123 2012-03-22 ' to TIMESTAMP |
| hbase table: functional_hbase.hbasealltypeserrornonulls |
| row key: 28 |
| Error converting column d:int_col: 'abc9' to INT |
| hbase table: functional_hbase.hbasealltypeserrornonulls |
| row key: 29 |
| Error converting column d:smallint_col: 'err3' to SMALLINT |
| hbase table: functional_hbase.hbasealltypeserrornonulls |
| row key: 3 |
| Error converting column d:int_col: 'err4' to INT |
| hbase table: functional_hbase.hbasealltypeserrornonulls |
| row key: 4 |
| Error converting column d:bigint_col: 'err50' to BIGINT |
| hbase table: functional_hbase.hbasealltypeserrornonulls |
| row key: 5 |
| Error converting column d:float_col: 'err6.000000' to FLOAT |
| hbase table: functional_hbase.hbasealltypeserrornonulls |
| row key: 6 |
| Error converting column d:double_col: 'err70.700000' to DOUBLE |
| hbase table: functional_hbase.hbasealltypeserrornonulls |
| row key: 7 |
| Error converting column d:bigint_col: 'err90' to BIGINT |
| Error converting column d:bool_col: 'errtrue' to BOOL |
| Error converting column d:double_col: 'err90.900000' to DOUBLE |
| Error converting column d:float_col: 'err9.000000' to FLOAT |
| Error converting column d:int_col: 'err9' to INT |
| Error converting column d:smallint_col: 'err9' to SMALLINT |
| Error converting column d:tinyint_col: 'err9' to TINYINT |
| hbase table: functional_hbase.hbasealltypeserrornonulls |
| row key: 9 |
| ---- FILEERRORS |
| file: hbasealltypeserrornonulls,15 |
| ---- TYPES |
| int, bigint, boolean, string, double, float, int, smallint, string, timestamp, tinyint |
| ---- RESULTS |
| 0,0,true,'01/01/09',0,0,0,0,'0',NULL,0 |
| 1,10,NULL,'01/01/09',10.1,1,1,1,'1',NULL,1 |
| 10,0,true,'02/01/09',0,0,0,0,'0',2012-03-22 11:20:01.123000000,0 |
| 11,10,false,'02/01/09',10.1,1,1,1,'1',2012-03-22 11:20:01.123000000,1 |
| 12,20,true,'02/01/09',20.2,2,2,2,'2',2012-03-22 11:20:01.123000000,2 |
| 13,30,false,'02/01/09',NULL,NULL,3,3,'3',2012-03-22 11:20:01.123000000,3 |
| 14,40,true,'02/01/09',40.4,4,4,4,'4',2012-03-22 11:20:01.123000000,4 |
| 15,50,false,'02/01/09',50.5,5,5,5,'5',2012-03-22 11:20:01.123000000,NULL |
| 16,60,true,'02/01/09',60.6,6,6,6,'6',2012-03-22 11:20:01.123000000,6 |
| 17,70,false,'02/01/09',NULL,7,7,7,'7',2012-03-22 11:20:01.123000000,7 |
| 18,80,true,'02/01/09',80.8,8,8,8,'8',2012-03-22 11:20:01.123000000,8 |
| 19,90,false,'02/01/09',90.90000000000001,9,9,9,'9',2012-03-22 11:20:01.123000000,9 |
| 2,20,true,'01/01/09',20.2,2,2,2,'2',2012-03-22 11:20:01.123000000,NULL |
| 20,0,true,'03/01/09',0,0,0,0,'0',2012-03-22 11:20:01.123000000,0 |
| 21,10,false,'03/01/09',10.1,1,1,1,'1',2012-03-22 11:20:01.123000000,1 |
| 22,20,true,'03/01/09',20.2,2,2,2,'2',2012-03-22 11:20:01.123000000,2 |
| 23,30,false,'03/01/09',30.3,3,3,NULL,'3',2012-03-22 11:20:01.123000000,3 |
| 24,40,true,'03/01/09',40.4,4,4,4,'4',2012-03-22 11:20:01.123000000,4 |
| 25,50,false,'03/01/09',50.5,5,NULL,5,'5',NULL,5 |
| 26,60,true,'03/01/09',60.6,6,6,6,'6',2012-03-22 11:20:01.123000000,6 |
| 27,70,false,'03/01/09',70.7,7,7,7,'7',2012-03-22 11:20:01.123000000,NULL |
| 28,80,true,'03/01/09',80.8,8,8,8,'8',NULL,8 |
| 29,90,false,'03/01/09',90.90000000000001,9,NULL,9,'9',2012-03-22 00:00:00,9 |
| 3,30,false,'01/01/09',30.3,3,3,NULL,'3',2012-03-22 11:20:01.123000000,3 |
| 4,40,true,'01/01/09',40.4,4,NULL,4,'4',2012-03-22 11:20:01.123000000,4 |
| 5,NULL,false,'01/01/09',50.5,5,5,5,'5',2012-03-22 11:20:01.123000000,5 |
| 6,60,true,'01/01/09',60.6,NULL,6,6,'6',2012-03-22 11:20:01.123000000,6 |
| 7,70,false,'01/01/09',NULL,7,7,7,'7',2012-03-22 11:20:01.123000000,7 |
| 8,80,false,'01/01/09',80.8,8,8,8,'8',2012-03-22 11:20:01.123000000,8 |
| 9,NULL,NULL,'01/01/09',NULL,NULL,NULL,NULL,'9',2012-03-22 11:20:01.123000000,NULL |
| ==== |