COPY FROM LOCAL DOESN'T WORK
I am tryin to insert to my table from a file on my computer to my remote node.
COPY mytable FROM LOCAL 'C:\disk1.txt' WITH DELIMITER E'\t';
with no success.
On MC I get the error:[Vertica]VJDBC File-based COPY LOCAL statements cannot be executed because they are disabled.
? where do I enable it?
and when I run the command via vsql through my remote terminal I get:
Could not open file [C:\disk1.txt] for reading (in function statFiles() at Bulkload.cpp:338)
All I am trying to do i copy from a local file on my windows computer to the remote node.
Thanks in advance