IMPORT FROM (LOCAL) CSV may fail in case of missing row separator

Details

Detail name Value
Changelog Number 14777
Type Bug
Status Resolved
Affected Versions Exasol 7.0.0, Exasol 7.1.0
Fix Versions Exasol 7.1.12, Exasol 8.1.0
Resolution Date 2022-07-13

Description

An IMPORT FROM (LOCAL) CSV may fail with a parsing error if the following conditions are met

  • the first parsed line of a CSV file ends without a value (i.e. is NULL)
  • the line also does not have the ROW SEPARATOR value (e.g. LF or CRLF) at the end of the line

Example:
test.csv: A two-byte file (without a row separator).

1,

IMPORT:

create table t1(c1 int, c2 int);
import into t1 from local csv file 'test.csv';
-- Error: [42636] ETL-6009: Number of columns in source (=3) and destination (=2) table differs ...

Workaround

Modify the CSV file by adding a row separator to the end of the line

Fix

IMPORT succeeds in those cases.