when running the ncluster_export for a database object containing uppercase letters, the object name gets translated to lowercase even if double quotes are used, resulting in a failure to find the object.
CREATE TABLE "TesT" (id int) DISTRIBUTE BY HASH (id);
./ncluster_export -h 192.168.1.100 -U xxx -w xxx -c "TesT" outputFile
Exporting tuples using node '192.168.1.100'.
ERROR: relation "test" does not exist
Last table processed was: 'TesT'
Exit code: 5
Is there a way to overcome this? (other than renaming the tables to lowercase) :-)
Same behavior on Linux and Windows client tools.
In order to make the case sensitive use of table name the qoutes should be escaped like below:
./ncluster_export -h 192.168.1.100 -U xxx -w xxx -c \"TesT\" outputFile