Export Data as Parquet to a Directory
Shows the steps to export table data from your Autonomous Database to a directory as Parquet data by specifying a query.
Notes for exporting with DBMS_CLOUD.EXPORT_DATA
:
-
The
query
parameter that you supply can be an advanced query, if required, such as a query that includes joins or subqueries. -
Specify the
format
parameter with thecompression
option to compress the output files. -
See DBMS_CLOUD Package Oracle Data Type to Parquet Mapping for details on Oracle Type to Parquet Type mapping.
The following types are not supported or have limitations on their support for exporting Parquet with
DBMS_CLOUD.EXPORT_DATA
:Oracle Type Notes BFILE
Not supported
BLOB
Not supported
DATE
Supported with the following limitation:
DATE
format supports only date, month and year. Hour, minute and seconds are not supported.See DBMS_CLOUD Package Oracle Data Type to Parquet Mapping for details on NLS format limitations for exporting
DATE
to Parquet.INTERVAL DAY TO SECOND
Supported and is treated as string internally
INTERVAL YEAR TO MONTH
Supported and is treated as string internally
LONG
Not supported
LONG RAW
Not supported
NUMBER
Supported with the following limitations:
- Can have maximum precision of 38 and scale equal to less than precision.
- If no precision and scale is provided for the column
NUMBER
type, by default precision of 38 and scale of 20 is used. - Negative scale is not supported for
NUMBER
types.
Object Types
Not supported
TIMESTAMP
Supported with the following limitations:
- If there are multiple columns with different precision, highest precision will be taken.
TIMESTAMP WITH TIME ZONE
Oracle datatype will use the timestamp only.
See DBMS_CLOUD Package Oracle Data Type to Parquet Mapping for details on NLS format limitations for exporting
TIMESTAMP
to Parquet.
Parent topic: Export Data to a Directory