IMPORT/EXPORT FROM LOCAL FILE fails if ZIP file path contains a space

Details

Detail name Value
Changelog Number 4678
Type Bug
Status Resolved
Affected Versions EXASOL 6.0.0, EXASolution 5.0.0
Fix Versions EXASOL 6.0.4
Resolution Date 2017-10-27

Problem description:

An IMPORT/EXPORT INTO/FROM LOCAL FILE will fail if the file is a ZIP file and the path contains a space.

For example:

IMPORT INTO table1 FROM LOCAL CSV
FILE 'C:\Users\user1\test file.zip';

produces an error message such as

[42636] java.sql.SQLException: 
ETL-5105: Following error occured while reading data from external connection [https://<host>/9322c5a7-98e0-44f2-b7ae-2c5ba872b895.C:\Users\user1\test file.zip failed after 0 bytes.
...
04509 java.sql.SQLException: java.io.IOException: Wrong cookie received.

Workaround:

Do not use file names with special characters

Fix:

EXASOL 6.0.4 fixes the problem.