We have resolved this. In Vertica, only a super user (or sudo) can copy the data. See the following from manual:
So, we need to add the word 'local' to the copy command. The below modification will work.Only a superuser can use the COPY statement to bulk load data. The COPY exceptions to requiring a superuser to bulk load data files are to run copy to load from a stream on the host (such as STDIN) rather than a file (see Streaming Data via JDBC), or to use the COPY statement with its
FROM LOCAL option. A non-superuser can also perform a standard batch insert using a prepared statement, which invokes COPY as a background task to load data.
Code: Select all
copy wdrake.copy_test from local '/home/wdrake/my.txt' direct no escape null as '\N';