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.