Is there a way to load data via the COPY command from a local text file on one server to a remote server? When I try it I get an error saying that the file does not exist.
Code: Select all
[root@cognos]# vsql -h 10.255.10.100 -U dbadmin -c "copy dash_wh.region_dim from '/source/data/vertica_region_dim.txt' direct no escape null as '\N' exceptions '/source/data/vertica_region_dim.err';"
ERROR: COPY: Could not open file /source/data/vertica_region_dim.txt for reading; No such file or directory
Code: Select all
[root@cognos]# ls -lrt /source/data/vertica_region_dim.txt
-rw-rw-rw- 1 root root 19743515 May 29 09:19 vertica_region_dim.txt