All Forums Aster
jan.simecka 4 posts Joined 01/13
29 Jul 2016
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

M.Saeed Khurram 544 posts Joined 09/12
30 Jul 2016

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

jan.simecka 4 posts Joined 01/13
02 Aug 2016

Works, thank you!

You must sign in to leave a comment.