Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to ingest and work with PARQUET + AVRO files in Oracle 19c on-premise?

Sam_PNov 18 2021

Hello,
While this is not specifically a question for Oracle SQL Developer tool per say but we have Oracle 19c running on-premise.
If I have a bunch of PARQUET files and a bunch of AVRO files containing data, how should I go about: -
(1) Ingesting the contents of these files into one or more tables?
(2) Once data is ingested, how do I work/manipulate the data, similar to various JSON-related functions that are provided in Oracle 19c?
Thanks in advance.

Comments
Post Details
Added on Nov 18 2021
1 comment
1,034 views