Error writing to exceptions file in COPY command


I'm seeing this error when using the COPY command:
ERROR 4368:  Permission denied for storage location [/tmp/exceptions]
My command line looks like:
cat data.txt | /opt/vertica/bin/vsql   <host,user,password args> -c "COPY table1(col1,col2) FROM STDIN   EXCEPTIONS '/tmp/exceptions' STREAM NAME 'test load'"
The permissions seem correct:
$ ls -la /tmp
total 40
drwxrwxrwt 4 root root 4096 Jan 23 17:07 .
drwxr-xr-x 32 root root 4096 Sep 25 15:23 ..
srw-rw-rw- 1 spread verticadba 0 Jan 23 06:03 4803
-rw-r--r-- 1 ntp ntp 7 Jan 23 15:24 drift
-rwxrwxrwx 1 acochran acochran 0 Jan 23 17:03 exceptions
drwx------ 2 root root 16384 Jun 3 2011 lost+found

I'm the user acochran

If I remove the EXCEPTIONS and filename from the COPY command then I don't get any errors but I also don't get any data loaded into the table.

The dba checked vertica.log but that didn't show any errors with the COPY command.

I am running vsql on the same host as I am connecting to in the vsql command line.


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file