Running ncluster_export fails with uppercase objects

Aster

Running ncluster_export fails with uppercase objects

Hello,

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.

Example:

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.

Thanks,

Jan

2 REPLIES

Re: Running ncluster_export fails with uppercase objects

Hi,

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
Khurram

Re: Running ncluster_export fails with uppercase objects

Works, thank you!