The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Error loading data using PloadDelimitedSource, especially with REJECTED DATA and EXCEPTIONS
We managed to install and use the pload library. However, we are having trouble getting the REJECTED DATA and EXCEPTIONS clauses to work. They seem to only work with COPY LOCAL.
COPY some_schema.some_table with source PloadDelimitedSource(file='/tmp/some_file.txt') DELIMITER E'\t' REJECTED DATA '/tmp/failed.rejected_lines' EXCEPTIONS '/tmp/failed.why_they_failed' DIRECT
I get the following error:
vsql:example.sql:10: ERROR 4368: Permission denied for storage location [/tmp/failed.why_they_failed]
But locally, all permissions are ok (especially since it is /tmp)