Skip to main content

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

  • February 3, 2015
  • 2 replies
  • 16 views

Wayne_1
Forum|alt.badge.img
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"*]


2 replies

Bhawana
Forum|alt.badge.img
  • Participating Frequently
  • February 5, 2015
Hi ,

Could you please let me know what version of Vertica are you using.


Regards

Bhawana

Wayne_1
Forum|alt.badge.img
  • Author
  • Participating Frequently
  • February 5, 2015
Thanks. it is 7.1.