VeloDB Cloud
User Guide
Data Ingestion
File Formats
ORC

ORC

This document explains how to load ORC format data files in Doris.

Supported Loading Methods

The following loading methods support ORC format data:

Usage Examples

This section demonstrates the usage of ORC format in different loading methods.

Stream Load

curl --location-trusted -u <user>:<passwd> \
    -H "format: orc" \
    -T example.orc \
    http://<fe_host>:<fe_http_port>/api/example_db/example_table/_stream_load

Broker Load

LOAD LABEL example_db.example_label
(
    DATA INFILE("s3://bucket/example.orc")
    INTO TABLE example_table
    FORMAT AS "orc"
)
WITH S3 
(
    ...
);

TVF Load

INSERT INTO example_table
SELECT *
FROM S3
(
    "path" = "s3://bucket/example.orc",
    "format" = "orc",
    ...
);