External tables with ORC, Parquet, and Avro provide an option to set size of string columns
- Services: Autonomous Database Serverless
- Release Date: January 07, 2025
When you access ORC, Parquet, or Avro data stored in object store using external tables, you can either automatically or explicitly set the maximum size of text columns.
By default the text column size is set based on the value of MAX_STRING_SIZE
.
See Query External Data with ORC, Parquet, or Avro Source Files and Explicitly Set the Text Column Size for more information.