Native

This document explains how to load Native format data files in Doris.It is suitable as an internal data exchange and backup format , rather than a general-purpose file exchange format. When data is circulated only within Doris, Native should be preferred to achieve the highest efficiency.

Supported Loading Methods

The following loading methods support Native format data:

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

Usage Examples

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

Stream Load

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

TVF Load

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