Class SurplusCharHandlingAction
(experimental) Specifies how to handle data being loaded that exceeds the length of the data type defined for columns containing VARCHAR, CHAR, or string data.
Inheritance
Namespace: Amazon.CDK.AWS.Glue.Alpha
Assembly: Amazon.CDK.AWS.Glue.Alpha.dll
Syntax (csharp)
public sealed class SurplusCharHandlingAction : Enum
Syntax (vb)
Public NotInheritable Class SurplusCharHandlingAction
Inherits
Enum
Remarks
By default, Redshift Spectrum sets the value to null for data that exceeds the width of the column.
Stability: Experimental
See: https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_EXTERNAL_TABLE.html#r_CREATE_EXTERNAL_TABLE-parameters - under "TABLE PROPERTIES" > "surplus_char_handling"
Synopsis
Fields
DISABLED | (experimental) Doesn't perform surplus character handling. |
DROP_ROW | (experimental) Replaces each value in the row with null. |
FAIL | (experimental) Cancels queries that return data exceeding the column width. |
SET_TO_NULL | (experimental) Replaces data that exceeds the column width with null. |
TRUNCATE | (experimental) Removes the characters that exceed the maximum number of characters defined for the column. |
value__ |
Fields
DISABLED
(experimental) Doesn't perform surplus character handling.
public const SurplusCharHandlingAction DISABLED
Field Value
Type | Description |
---|---|
SurplusCharHandlingAction |
Remarks
Stability: Experimental
DROP_ROW
(experimental) Replaces each value in the row with null.
public const SurplusCharHandlingAction DROP_ROW
Field Value
Type | Description |
---|---|
SurplusCharHandlingAction |
Remarks
Stability: Experimental
FAIL
(experimental) Cancels queries that return data exceeding the column width.
public const SurplusCharHandlingAction FAIL
Field Value
Type | Description |
---|---|
SurplusCharHandlingAction |
Remarks
Stability: Experimental
SET_TO_NULL
(experimental) Replaces data that exceeds the column width with null.
public const SurplusCharHandlingAction SET_TO_NULL
Field Value
Type | Description |
---|---|
SurplusCharHandlingAction |
Remarks
Stability: Experimental
TRUNCATE
(experimental) Removes the characters that exceed the maximum number of characters defined for the column.
public const SurplusCharHandlingAction TRUNCATE
Field Value
Type | Description |
---|---|
SurplusCharHandlingAction |
Remarks
Stability: Experimental
value__
public int value__
Field Value
Type | Description |
---|---|
System.Int32 |