GA ANNOUNCEMENT - ADW now supports ORC files

Content

ADB has expanded object storage support in two important ways: it can now query ORC files as well as complex data types found in Parquet, ORC and Avro files.

ORC, Parquet and Avro file types provide the ability to capture fields containing complex data types, including arrays, maps, unions and objects (or structs). These complex types can now be queried in ADB using Oracle’s extensive JSON query support.

Note: support for ORC and complex data types are only available in 19c.

DOC: DBMS_CLOUD Package ORC to Oracle Data Type Mapping for ADW, click here.

DOC: DBMS_CLOUD Package ORC, Parquet and Avro Complex Types for ADW,