IMPORT/EXPORT URLs/paths may not be properly URL encoded
Details
| Detail name | Value |
|---|---|
| Changelog Number | 12988 |
| Type | Bug |
| Status | Open |
| Affected Versions | Exasol 7.1.0, Exasol 8.0.0 |
Description
The URLs/paths specified in IMPORT/EXPORT statements may not be properly URL encoded. This may lead to failures.
Example
The following example may fail because the file name has a space in it.
IMPORT INTO table1 FROM CSV AT 'ftp://ftp_server' USER 'user1' IDENTIFIED BY 'pw1' FILE 'test file.csv'
Error:
ETL-5105: Following error occured while reading data from external connection [ftp://ftp_server/test file.csv failed after 0 bytes. [URL rejected: Malformed input to a URL function],[3],[URL using bad/illegal format or missing URL]]
Workaround
Non-URL-encoded characters can be manually replaced in the provided URLs/paths. For example, the ' ' (space) can be replaced by %20.
IMPORT INTO table1 FROM CSV AT 'ftp://ftp_server' USER 'user1' IDENTIFIED BY 'pw1' FILE 'test%20file.csv'
Fix
URLs and paths are automatically URL-encoded.
