DBMS_CLOUD Package Format Options for Avro, ORC, or Parquet
The format argument in DBMS_CLOUD
specifies the format of source files.
The two ways to specify the format argument are:
format => '{"format_option" : “format_value” }'
And:
format => json_object('format_option' value 'format_value'))
Examples:
format => json_object('type' VALUE 'CSV')
To specify multiple format options, separate the values with a ",
".
For example:
format => json_object('ignoremissingcolumns' value 'true', 'removequotes' value 'true', 'dateformat' value 'YYYY-MM-DD-HH24-MI-SS', 'blankasnull' value 'true')
Format Option | Description | Syntax |
---|---|---|
|
When the value of The characters "*" and "?" are considered wildcard characters when the Regular expression patterns are only supported for the file name or subfolder path in your URIs and the pattern matching is identical to that performed by the For external tables, this option is only supported with the tables that are created on a file in the Object Storage. For example:
See REGEXP_LIKE Condition for more information on |
Default value : |
type |
Specifies the file type. |
|
|
When schema is set to The column names will match those found in Avro, ORC, or Parquet. The data types are converted from Avro, ORC, or Parquet data types to Oracle data types. All columns are added to the table. The value The value Default: If Note: For Avro, ORC, or Parquet format files the
|
|
Parent topic: DBMS_CLOUD Avro, ORC, and Parquet Support