It’s impossible to create pipeline with ERRORS HANDLE:
CREATE OR REPLACE PIPELINE pp_name AS LOAD DATA
LINK MY_S3_LINK ‘bucket/dir/*.txt’
SKIP ALL ERRORS
INTO TABLE tbl(col1, col2)
FIELDS TERMINATED BY ‘\t’
LINES TERMINATED BY ‘\n’
IGNORE 1 LINES
SET source = pipeline_source_file()
ERRORS HANDLE ‘data_import’;
Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ERRORS HANDLE ‘data_import’’ at line 1
Without last row I can create this pipeline.
Table has columns col1, col2, source - all text.
Exists any workaround to handle errors without such pipeline failure ?