Copy command not finding file path

Follow

HAPPY

• September 22, 2023 21:04

Hi,

When i try to issue 

copy (select * from geotweets_en_2023) to '/data/results/test.csv';

I get the error:

File or directory "/data/kang/heavyai/storage/export/test.csv" does not exist.

I can see /data/results folder on the Heavy server.

Thanks,

Happy

0

• 

  jieguo

  • September 26, 2023 06:11

  Adding parameters to the heavy.conf file，and attention to the owner permissions of the directory

  allowed-export-paths=["/data/kang/heavyai/storage/export"]

  then restart heavydb.

  0

  Comment actions Permalink
• 

  Candido Dessanti

  • September 29, 2023 01:22

  Hi Happy,

  Are you certain about that? When I run that command, I encounter a different error, likely because the specified directory doesn't exist in my case, and it may be the same in your situation as well.
  Please note that the specified folder must be a local directory on the server where "heavydb" is running.

  heavysql> copy (select * from geotweets_en_2023) to '/data/results/test.csv';
  File or directory "/data/results/test.csv" does not exist.

  By default, you can export files using the "copy" or "dump" command, and these files are stored in the $HEAVYAI_BASE/storage/export directory. If you want to use a different directory for exports, you'll need to add that directory to the "allowed-export-paths," as mentioned by @jieguo.

  Please note that the specified folder must be a local directory on the server where "heavydb" is running.

  Candido

  0

  Comment actions Permalink

Please sign in to leave a comment.