What Is the Default Value of `Maxerror` in a Redshift `Copy` Command?
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...
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.
Chloe Bennett explores the intersection of pop culture, streaming entertainment, digital trends, and contemporary lifestyle. Her weekly commentary reaches thousands of culture enthusiasts.
