====
---- QUERY
select id, bool_col, tinyint_col, smallint_col from alltypeserror order by id
---- ERRORS
Error converting column: 3 to SMALLINT
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 2 to TINYINT
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 1 to BOOLEAN
Error converting column: 2 to TINYINT
Error converting column: 3 to SMALLINT
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 2 to TINYINT
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 1 to BOOLEAN
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 2 to TINYINT
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 3 to SMALLINT
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 1 to BOOLEAN
Error converting column: 2 to TINYINT
Error converting column: 3 to SMALLINT
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
---- RESULTS
0,NULL,NULL,0
1,NULL,NULL,1
2,true,NULL,NULL
3,false,3,NULL
4,true,4,4
5,false,5,5
6,true,6,6
7,NULL,NULL,7
8,false,NULL,NULL
9,NULL,NULL,NULL
10,NULL,NULL,NULL
11,false,NULL,NULL
12,true,2,NULL
13,false,3,3
14,true,4,4
15,false,NULL,5
16,NULL,NULL,NULL
17,false,7,7
18,true,8,8
19,false,9,9
20,true,0,0
21,false,1,1
22,true,2,2
23,false,3,NULL
24,true,4,4
25,false,5,5
26,true,6,6
27,false,NULL,7
28,true,8,8
29,false,9,9
30,NULL,NULL,NULL
---- TYPES
int, boolean, tinyint, smallint
====
---- QUERY
select * from date_tbl_error order by id_col;
---- ERRORS
Error converting column: 1 to DATE
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 1 to DATE
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 1 to DATE
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 1 to DATE
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 1 to DATE
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 1 to DATE
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 1 to DATE
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 1 to DATE
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 1 to DATE
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 1 to DATE
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
---- RESULTS
0,0001-01-01,0001-01-01
1,NULL,0001-01-01
2,NULL,0001-01-01
3,NULL,0001-01-01
4,NULL,0001-01-01
5,NULL,0001-01-01
6,NULL,0001-01-01
10,NULL,1399-06-27
11,NULL,1399-06-27
12,2018-12-31,1399-06-27
20,0001-06-21,2017-11-27
21,0001-06-22,2017-11-27
22,0001-06-23,2017-11-27
23,NULL,2017-11-27
24,NULL,2017-11-27
25,0001-06-26,2017-11-27
26,0001-06-27,2017-11-27
27,NULL,2017-11-27
28,0001-06-29,2017-11-27
29,2017-11-28,2017-11-27
30,NULL,9999-12-31
31,9999-12-31,9999-12-31
---- TYPES
INT, DATE, DATE
====
---- QUERY
select count(*) from functional_text_lzo.bad_text_lzo
---- ERRORS
Blocksize: 536870911 is greater than LZO_MAX_BLOCK_SIZE: 67108864
---- RESULTS
5141
---- TYPES
bigint
====
---- QUERY
select count(field) from functional_text_lzo.bad_text_lzo
---- ERRORS
Blocksize: 536870911 is greater than LZO_MAX_BLOCK_SIZE: 67108864
---- RESULTS
5141
---- TYPES
bigint
====
---- QUERY
select * from alltypeserrornonulls
---- ERRORS
Error converting column: 3 to SMALLINT
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 4 to INT
Error converting column: 10 to TIMESTAMP
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 2 to TINYINT
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 10 to TIMESTAMP
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 4 to INT
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 6 to FLOAT
Error converting column: 7 to DOUBLE
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 2 to TINYINT
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 7 to DOUBLE
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 10 to TIMESTAMP
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 1 to BOOLEAN
Error converting column: 10 to TIMESTAMP
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 2 to TINYINT
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 3 to SMALLINT
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 4 to INT
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 5 to BIGINT
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 6 to FLOAT
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 7 to DOUBLE
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
Error converting column: 1 to BOOLEAN
Error converting column: 2 to TINYINT
Error converting column: 3 to SMALLINT
Error converting column: 4 to INT
Error converting column: 5 to BIGINT
Error converting column: 6 to FLOAT
Error converting column: 7 to DOUBLE
row_regex: .*Error parsing row: file: $NAMENODE/.* before offset: \d+
---- RESULTS
0,true,0,0,0,0,0,0,'01/01/09','0',NULL,2009,1
1,NULL,1,1,1,10,1,10.1,'01/01/09','1',NULL,2009,1
2,true,NULL,2,2,20,2,20.2,'01/01/09','2',2012-03-22 11:20:01.123000000,2009,1
3,false,3,NULL,3,30,3,30.3,'01/01/09','3',2012-03-22 11:20:01.123000000,2009,1
4,true,4,4,NULL,40,4,40.4,'01/01/09','4',2012-03-22 11:20:01.123000000,2009,1
5,false,5,5,5,NULL,5,50.5,'01/01/09','5',2012-03-22 11:20:01.123000000,2009,1
6,true,6,6,6,60,NULL,60.6,'01/01/09','6',2012-03-22 11:20:01.123000000,2009,1
7,false,7,7,7,70,7,NULL,'01/01/09','7',2012-03-22 11:20:01.123000000,2009,1
8,false,8,8,8,80,8,80.8,'01/01/09','8',2012-03-22 11:20:01.123000000,2009,1
9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'01/01/09','9',2012-03-22 11:20:01.123000000,2009,1
10,true,0,0,0,0,0,0,'02/01/09','0',2012-03-22 11:20:01.123000000,2009,2
11,false,1,1,1,10,1,10.1,'02/01/09','1',2012-03-22 11:20:01.123000000,2009,2
12,true,2,2,2,20,2,20.2,'02/01/09','2',2012-03-22 11:20:01.123000000,2009,2
13,false,3,3,3,30,NULL,NULL,'02/01/09','3',2012-03-22 11:20:01.123000000,2009,2
14,true,4,4,4,40,4,40.4,'02/01/09','4',2012-03-22 11:20:01.123000000,2009,2
15,false,NULL,5,5,50,5,50.5,'02/01/09','5',2012-03-22 11:20:01.123000000,2009,2
16,true,6,6,6,60,6,60.6,'02/01/09','6',2012-03-22 11:20:01.123000000,2009,2
17,false,7,7,7,70,7,NULL,'02/01/09','7',2012-03-22 11:20:01.123000000,2009,2
18,true,8,8,8,80,8,80.8,'02/01/09','8',2012-03-22 11:20:01.123000000,2009,2
19,false,9,9,9,90,9,90.90000000000001,'02/01/09','9',2012-03-22 11:20:01.123000000,2009,2
20,true,0,0,0,0,0,0,'03/01/09','0',2012-03-22 11:20:01.123000000,2009,3
21,false,1,1,1,10,1,10.1,'03/01/09','1',2012-03-22 11:20:01.123000000,2009,3
22,true,2,2,2,20,2,20.2,'03/01/09','2',2012-03-22 11:20:01.123000000,2009,3
23,false,3,NULL,3,30,3,30.3,'03/01/09','3',2012-03-22 11:20:01.123000000,2009,3
24,true,4,4,4,40,4,40.4,'03/01/09','4',2012-03-22 11:20:01.123000000,2009,3
25,false,5,5,NULL,50,5,50.5,'03/01/09','5',NULL,2009,3
26,true,6,6,6,60,6,60.6,'03/01/09','6',2012-03-22 11:20:01.123000000,2009,3
27,false,NULL,7,7,70,7,70.7,'03/01/09','7',2012-03-22 11:20:01.123000000,2009,3
28,true,8,8,8,80,8,80.8,'03/01/09','8',NULL,2009,3
29,false,9,9,NULL,90,9,90.90000000000001,'03/01/09','9',2012-03-22 00:00:00,2009,3
---- TYPES
int, boolean, tinyint, smallint, int, bigint, float, double, string, string, timestamp, int, int
====
---- QUERY
select count(*) from functional_text_gzip.bad_text_gzip
---- CATCH
Unexpected end of compressed file. File may be truncated.
====