Data Operations

Apache Doris provides a complete set of data operation capabilities, covering the full pipeline from data ingestion to data export. You can load data from a variety of data sources, update and delete data with transactional guarantees, and export query results or table data to external storage systems.

In addition, Apache Doris also supports managing Apache Iceberg table data directly, including direct query acceleration, write, update, and delete operations on Iceberg tables. For details, see the data management section of Iceberg Catalog.

Data Loading

Load data from files, message queues, transactional databases, and other OLAP systems through Stream Load, Broker Load, Routine Load, INSERT, and streaming data synchronization jobs.

Data Update and Deletion

Update existing data, delete data using DELETE, TRUNCATE, atomic overwrite, and other methods, and combine multiple write operations into an atomic unit through transactions.

Data Export

Export query results or table data to HDFS, object storage, or the local file system using EXPORT, SELECT INTO OUTFILE, or mysqldump.

Iceberg Data Management

Connect to Iceberg table data by creating an Iceberg Catalog and perform data operations.