Class ColumnCountMismatchHandlingAction
(experimental) Identifies if the file contains less or more values for a row than the number of columns specified in the external table definition.
Inheritance
Namespace: Amazon.CDK.AWS.Glue.Alpha
Assembly: Amazon.CDK.AWS.Glue.Alpha.dll
Syntax (csharp)
public sealed class ColumnCountMismatchHandlingAction : Enum
Syntax (vb)
Public NotInheritable Class ColumnCountMismatchHandlingAction
Inherits
Enum
Remarks
This property is only available for an uncompressed text file format.
Stability: Experimental
See: https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_EXTERNAL_TABLE.html#r_CREATE_EXTERNAL_TABLE-parameters - under "TABLE PROPERTIES" > "column_count_mismatch_handling"
Synopsis
Fields
DISABLED | (experimental) Column count mismatch handling is turned off. |
DROP_ROW | (experimental) Drop all rows that contain column count mismatch error from the scan. |
FAIL | (experimental) Fail the query if the column count mismatch is detected. |
SET_TO_NULL | (experimental) Fill missing values with NULL and ignore the additional values in each row. |
value__ |
Fields
DISABLED
(experimental) Column count mismatch handling is turned off.
public const ColumnCountMismatchHandlingAction DISABLED
Field Value
Type | Description |
---|---|
ColumnCountMismatchHandlingAction |
Remarks
Stability: Experimental
DROP_ROW
(experimental) Drop all rows that contain column count mismatch error from the scan.
public const ColumnCountMismatchHandlingAction DROP_ROW
Field Value
Type | Description |
---|---|
ColumnCountMismatchHandlingAction |
Remarks
Stability: Experimental
FAIL
(experimental) Fail the query if the column count mismatch is detected.
public const ColumnCountMismatchHandlingAction FAIL
Field Value
Type | Description |
---|---|
ColumnCountMismatchHandlingAction |
Remarks
Stability: Experimental
SET_TO_NULL
(experimental) Fill missing values with NULL and ignore the additional values in each row.
public const ColumnCountMismatchHandlingAction SET_TO_NULL
Field Value
Type | Description |
---|---|
ColumnCountMismatchHandlingAction |
Remarks
Stability: Experimental
value__
public int value__
Field Value
Type | Description |
---|---|
System.Int32 |