Parquet

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

Supported Loading Methods

The following loading methods support Parquet format data:

• Stream Load
• Broker Load
• INSERT INTO FROM S3 TVF
• INSERT INTO FROM HDFS TVF

Usage Examples

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

Stream Load

curl --location-trusted -u <user>:<passwd> \
    -H "format: parquet" \
    -T example.parquet \
    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.parquet")
    INTO TABLE example_table
    FORMAT AS "parquet"
)
WITH S3 
(
    ...
);

TVF Load

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