VerticaCopyStream and "REJECTED DATA AS TABLE"
I use JDBC VerticaCopyStream to transfer data to the database.
I would like to keep the problem data in the database instead of going back to the server when I upload it.
It is look like "REJECTED DATA AS TABLE" COPY option is good variant for me.
My SQL statement for COPY looks something like
COPY "my_schema"."my_table" (k,v,d) FROM STDIN UNCOMPRESSED REJECTED DATA AS TABLE loader_rejects DELIMITER AS E'\002' NULL AS E'\004' ESCAPE AS E'\001' RECORD TERMINATOR E'\003' DIRECT
Unfortunetely I rejected error Cannot do LOCAL and REJECTED DATA AS TABLE
All stack trace look like here
Cause: com.vertica.support.exceptions.DataException: [Vertica][VJDBC](5767) ERROR: Cannot do LOCAL and REJECTED DATA AS TABLE in the same query; rejected records can only be saved to one location at com.vertica.util.ServerErrorData.buildException(Unknown Source) at com.vertica.io.ProtocolStream.readExpectedMessage(Unknown Source) at com.vertica.io.ProtocolStream.readExpectedMessage(Unknown Source) at com.vertica.dataengine.VQueryExecutor.readCopyStartResponse(Unknown Source) at com.vertica.dataengine.VQueryExecutor.handleExecuteResponse(Unknown Source) at com.vertica.dataengine.VQueryExecutor.execute(Unknown Source) at com.vertica.jdbc.VerticaCopyStream.execute(Unknown Source) at com.vertica.jdbc.VerticaCopyStream.start(Unknown Source)
It's weird, because in my expression for Copy there is no option "LOCAL".
Are there any ways to use JDCB VerticaCopyStream and save bad data to the database?