We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


copy ... from ... rejected data as table — Vertica Forum

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"*]


Comments

Leave a Comment

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