Updated on 2025-08-08 GMT+08:00

Doris Data Change Rules

This topic describes the rules and suggestions for changing Doris data.

Data Modification Rules

  • [Mandatory] Applications must not directly execute delete or update statements for data modifications. Instead, employ the CDC's upsert method.
    • The upsert method is suitable for infrequent operations, such as updates every few minutes.
    • Specify partition conditions when using delete statements.
  • [Mandatory] Use INSERT INTO tbl1 VALUES ("1"), ("a") for small-scale data imports. For larger imports, opt for Doris-provided methods like StreamLoad, BrokerLoad, SparkLoad, or Flink Connector.
  • [Optional] For extended SQL operations, set session variables in hint mode using SELECT /*+ SET_VAR(query_timeout = xxx*/ from table. Avoid altering global system variables.