![]() ) COMPRESSION = AUTO | SNAPPY | NONE BINARY_AS_TEXT = TRUE | FALSE TRIM_SPACE = TRUE | FALSE NULL_IF = ( ' ' ) - If FILE_FORMAT = ( TYPE = XML. ) TRIM_SPACE = TRUE | FALSE NULL_IF = ( ' ' ) - If FILE_FORMAT = ( TYPE = PARQUET. ) COMPRESSION = AUTO | GZIP | BROTLI | ZSTD | DEFLATE | RAW_DEFLATE | NONE TRIM_SPACE = TRUE | FALSE NULL_IF = ( ' ' ) - If FILE_FORMAT = ( TYPE = ORC. ) COMPRESSION = AUTO | GZIP | BZ2 | BROTLI | ZSTD | DEFLATE | RAW_DEFLATE | NONE DATE_FORMAT = ' ' | AUTO TIME_FORMAT = ' ' | AUTO TIMESTAMP_FORMAT = ' ' | AUTO BINARY_FORMAT = HEX | BASE64 | UTF8 TRIM_SPACE = TRUE | FALSE NULL_IF = ( ' ' ) ENABLE_OCTAL = TRUE | FALSE ALLOW_DUPLICATE = TRUE | FALSE STRIP_OUTER_ARRAY = TRUE | FALSE STRIP_NULL_VALUES = TRUE | FALSE REPLACE_INVALID_CHARACTERS = TRUE | FALSE IGNORE_UTF8_ERRORS = TRUE | FALSE SKIP_BYTE_ORDER_MARK = TRUE | FALSE - If FILE_FORMAT = ( TYPE = AVRO. ) COMPRESSION = AUTO | GZIP | BZ2 | BROTLI | ZSTD | DEFLATE | RAW_DEFLATE | NONE RECORD_DELIMITER = ' ' | NONE FIELD_DELIMITER = ' ' | NONE SKIP_HEADER = SKIP_BLANK_LINES = TRUE | FALSE DATE_FORMAT = ' ' | AUTO TIME_FORMAT = ' ' | AUTO TIMESTAMP_FORMAT = ' ' | AUTO BINARY_FORMAT = HEX | BASE64 | UTF8 ESCAPE = ' ' | NONE ESCAPE_UNENCLOSED_FIELD = ' ' | NONE TRIM_SPACE = TRUE | FALSE FIELD_OPTIONALLY_ENCLOSED_BY = ' ' | NONE NULL_IF = ( ' ' ) ERROR_ON_COLUMN_COUNT_MISMATCH = TRUE | FALSE REPLACE_INVALID_CHARACTERS = TRUE | FALSE EMPTY_FIELD_AS_NULL = TRUE | FALSE SKIP_BYTE_ORDER_MARK = TRUE | FALSE ENCODING = ' ' | UTF8 - If FILE_FORMAT = ( TYPE = JSON. * Standard data load */ COPY INTO FROM ) ] įormatTypeOptions ::= - If FILE_FORMAT = ( TYPE = CSV.
0 Comments
Leave a Reply. |