When using the COPY command in Redshift there's an option to specify MAXERROR - a number of row parsing errors that can occur before the query will be aborted.

Documentation doesn't specify the default value for this property. What is the default value?

1 Answer

The default value for MAXERROR is zero. It's undocumented, and zero is not necessarily the value you'd expect, but if you want any tolerance for errors during COPY you will need to set this to a non-zero value.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.