enum SurplusCharHandlingAction
| Language | Type name |
|---|---|
 .NET | Amazon.CDK.AWS.Glue.Alpha.SurplusCharHandlingAction |
 Go | github.com/aws/aws-cdk-go/awscdkgluealpha/v2#SurplusCharHandlingAction |
 Java | software.amazon.awscdk.services.glue.alpha.SurplusCharHandlingAction |
 Python | aws_cdk.aws_glue_alpha.SurplusCharHandlingAction |
 TypeScript (source) | @aws-cdk/aws-glue-alpha » SurplusCharHandlingAction |
Specifies how to handle data being loaded that exceeds the length of the data type defined for columns containing VARCHAR, CHAR, or string data.
By default, Redshift Spectrum sets the value to null for data that exceeds the width of the column.
See also: [https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_EXTERNAL_TABLE.html#r_CREATE_EXTERNAL_TABLE-parameters - under "TABLE PROPERTIES" > "surplus_char_handling"](https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_EXTERNAL_TABLE.html#r_CREATE_EXTERNAL_TABLE-parameters - under "TABLE PROPERTIES" > "surplus_char_handling")
Members
| Name | Description |
|---|---|
| SET_TO_NULL | Replaces data that exceeds the column width with null. |
| DISABLED | Doesn't perform surplus character handling. |
| FAIL | Cancels queries that return data exceeding the column width. |
| DROP_ROW | Replaces each value in the row with null. |
| TRUNCATE | Removes the characters that exceed the maximum number of characters defined for the column. |
SET_TO_NULL
Replaces data that exceeds the column width with null.
DISABLED
Doesn't perform surplus character handling.
FAIL
Cancels queries that return data exceeding the column width.
DROP_ROW
Replaces each value in the row with null.
TRUNCATE
Removes the characters that exceed the maximum number of characters defined for the column.