copy ... from ... rejected data as table

Hi, Vertica experts,

I use this syntax to copy text file to a table and try to save rejected data to a table.

Copy ZipCodes
from  'fzipcodes.txt' ON ANY NODE
rejected data as table _rejects_ZipCodes

It always show a warning message about the rejected data table. The data is copied to the table. But rejected data are NOT there. The rejected data is an external table and its folder should be controlled by vertica server. Why it shows warning message about the access permission? How can we resolve that? Thanks.

WARNING 2005:  Permission denied for
storage location [/data/secure1/v_secure1_node0001_data/RejectionTableData/TABLE_REJECTED_RECORDS_"_reject_ZipCodes"*]


Leave a Comment

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