EXPORT INTO LOCAL CSV FILE does not work for ZIP files
Details
| Detail name | Value |
|---|---|
| Changelog Number | 11052 |
| Type | Bug |
| Status | Open |
| Affected Versions | Exasol 6.1.0, Exasol 6.2.0, Exasol 7.0.0 |
Description
Running an EXPORT to a local CSV file will return an error if the file specified is a .zip file.
Example:
EXPORT T1 INTO LOCAL CSV FILE 'test.zip'; Error: [42636] ETL-5106: Following error occured while writing data to external connection [https://10.48.106.14:43192/7074b018-1135-45c4-bb18-6810b45470b2.test.zip failed after 0 bytes. [Failed to connect to 10.48.106.14 port 43192: Connection refused],[7],[Couldn't connect to server]] while executing 'export t1 into CSV AT 'https://10.48.106.14:43192' FILE '7074b018-1135-45c4-bb18-6810b45470b2.test.zip' ;'
Workaround:
- Use '.gz' or '.bz2' files instead of '.zip' files.
- EXPORT '.zip' files to a remote source instead (e.g. FTP or HTTP server).
Fix
Exporting to a local csv file with a .zip extension will work as expected.