| set datestyle = 'ISO, DMY'; |
| -- Using Error Log with SEGMENT REJECT LIMIT #NUM ROWS |
| DROP EXTERNAL TABLE IF EXISTS tbl_ext_fixedwidth; |
| NOTICE: table "tbl_ext_fixedwidth" does not exist, skipping |
| CREATE READABLE EXTERNAL TABLE tbl_ext_fixedwidth ( |
| s1 char(10), s2 varchar(10), s3 text, dt timestamp, |
| n1 smallint, n2 integer, n3 bigint, n4 decimal, |
| n5 numeric, n6 real, n7 double precision) |
| LOCATION ('file://@hostname@@abs_srcdir@/data/fixedwidth_small_error_rejectlimitnotcrossed.tbl') |
| FORMAT 'CUSTOM' (formatter='fixedwidth_in', s1='10', |
| s2='10', s3='10', dt='20',n1='5', n2='10', |
| n3='10', n4='10', n5='10', n6='10', n7='15') |
| LOG ERRORS |
| SEGMENT REJECT LIMIT 5 ROWS; |
| SELECT * FROM tbl_ext_fixedwidth ORDER BY s1; |
| NOTICE: found 4 data formatting errors (4 or more input rows), rejected related input data |
| s1 | s2 | s3 | dt | n1 | n2 | n3 | n4 | n5 | n6 | n7 |
| ------------+------+--------+---------------------+----+-----+--------+-------+---------+---------+------------ |
| aaa | twoa | shpits | 2011-06-01 12:30:30 | 23 | 732 | 834567 | 45.67 | 789.123 | 7.12345 | 123.456789 |
| bbb | twob | shpits | 2011-06-01 12:30:30 | 23 | 732 | 834567 | 45.67 | 789.123 | 7.12345 | 123.456789 |
| ggg | twog | shpits | 2011-06-01 12:30:30 | 23 | 732 | 834567 | 45.67 | 789.123 | 7.12345 | 123.456789 |
| hhh | twoh | shpits | 2011-06-01 12:30:30 | 23 | 732 | 834567 | 45.67 | 789.123 | 7.12345 | 123.456789 |
| iii | twoi | shpits | 2011-06-01 12:30:30 | 23 | 732 | 834567 | 45.67 | 789.123 | 7.12345 | 123.456789 |
| jjj | twoj | shpits | 2011-06-01 12:30:30 | 23 | 732 | 834567 | 45.67 | 789.123 | 7.12345 | 123.456789 |
| (6 rows) |
| |
| SELECT relname,linenum,errmsg FROM gp_read_error_log('tbl_ext_fixedwidth') ORDER BY linenum; |
| relname | linenum | errmsg |
| --------------------+---------+---------------------------------------------- |
| tbl_ext_fixedwidth | 3 | invalid input syntax for type integer: "s32" |
| tbl_ext_fixedwidth | 4 | invalid input syntax for type integer: "7v2" |
| tbl_ext_fixedwidth | 5 | invalid input syntax for type integer: "y32" |
| tbl_ext_fixedwidth | 6 | invalid input syntax for type integer: "7d2" |
| (4 rows) |
| |
