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"*]
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"*]
0
Comments
Could you please let me know what version of Vertica are you using.
Regards
Bhawana