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.