enum ColumnCountMismatchHandlingAction
Language | Type name |
---|---|
.NET | Amazon.CDK.AWS.Glue.Alpha.ColumnCountMismatchHandlingAction |
Go | github.com/aws/aws-cdk-go/awscdkgluealpha/v2#ColumnCountMismatchHandlingAction |
Java | software.amazon.awscdk.services.glue.alpha.ColumnCountMismatchHandlingAction |
Python | aws_cdk.aws_glue_alpha.ColumnCountMismatchHandlingAction |
TypeScript (source) | @aws-cdk/aws-glue-alpha ยป ColumnCountMismatchHandlingAction |
Identifies if the file contains less or more values for a row than the number of columns specified in the external table definition.
This property is only available for an uncompressed text file format.
See also: [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"](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")
Members
Name | Description |
---|---|
DISABLED | Column count mismatch handling is turned off. |
FAIL | Fail the query if the column count mismatch is detected. |
SET_TO_NULL | Fill missing values with NULL and ignore the additional values in each row. |
DROP_ROW | Drop all rows that contain column count mismatch error from the scan. |
DISABLED
Column count mismatch handling is turned off.
FAIL
Fail the query if the column count mismatch is detected.
SET_TO_NULL
Fill missing values with NULL and ignore the additional values in each row.
DROP_ROW
Drop all rows that contain column count mismatch error from the scan.