- Indicates Doris version 2.0 and above, all versions of CCR. It is recommended to use Doris version 2.0.15 or 2.1.6 or newer.
Database
Database Properties
Database-level tasks will synchronize the properties of the database during Full Sync.
| Property | Supported | Doris version | CCR version | Sync Method | Description |
|---|
| replication_allocation | Supported | - | - | FULL SYNC | |
| data quota | Not supported | | | | |
| replica quota | Not supported | | | | |
Modify Database Properties
CCR tasks do not synchronize operations that modify database properties.
| Property | Supported | Can upstream operate | Can downstream operate | Description |
|---|
| replication_allocation | Not supported | No | No | Operations by upstream and downstream will cause CCR tasks to be interrupted |
| data quota | Not supported | Yes | Yes | |
| replica quota | Not supported | Yes | Yes | |
Rename Database
Renaming is not supported for upstream and downstream; doing so may cause views to stop working.
Table
Table Properties
| Property | Supported | Doris version | CCR version | Sync Method | Description |
|---|
| Table Model (duplicate, unique, aggregate) | Supported | - | - | SQL | |
| Partitioning and Bucketing | Supported | - | - | SQL | |
| replication_num | Supported | - | - | SQL | |
| replication_allocation (resource group) | Supported | - | - | SQL | Upstream must be consistent with downstream; BE tags must be consistent, otherwise CCR tasks will fail |
| colocate_with | Not supported | | | | |
| storage_policy | Not supported | | | | |
| dynamic_partition | Supported | - | - | SQL | |
| storage_medium | Supported | - | - | SQL | |
| auto_bucket | Supported | - | - | SQL | |
| group_commit series | Supported | - | - | SQL | |
| enable_unique_key_merge_on_write | Supported | - | - | SQL | |
| enable_single_replica_compaction | Supported | - | - | SQL | |
| disable_auto_compaction | Supported | - | - | SQL | |
| compaction_policy | Supported | - | - | SQL | |
| time_series_compaction series | Supported | - | - | SQL | |
| binlog series | Supported | - | - | SQL | To be confirmed |
| variant_enable_flatten_nested | Supported | - | - | SQL | |
| skip_write_index_on_load | Supported | - | - | SQL | |
| row_store series | Supported | - | - | SQL | |
| seq column | Supported | - | - | SQL | |
| enable_light_schema_change | Supported | - | - | SQL | |
| compression_type | Supported | - | - | SQL | |
| index | Supported | - | - | SQL | |
| bloom_filter_columns | Supported | - | - | SQL | |
| bloom_filter_fpp | Not supported | | | | |
| storage_cooldown_time | Not supported | | | | |
| generated column | Supported | - | - | SQL | |
| auto-increment id | Not supported | | | | Issues exist |
Basic Table Operations
| Operation | Supported | Doris version | CCR version | Sync Method | Can downstream operate separately | Description |
|---|
| create table | Supported | - | - | SQL | Not supported for tables synchronized by CCR tasks. | Reference properties for creating tables |
| drop table | Supported | - | - | Before 2.0.15/2.1.6: Full Sync, after: SQL | Same as above | |
| rename table | Table-level tasks do not support database-level tasks | master (2.0/2.1 not supported) | | SQL | Same as above | Table-level task rename will cause CCR tasks to stop |
| replace table | Not supported | | | | Same as above | |
| truncate table | Supported | - | | SQL | Same as above | |
| restore table | Unknown | | | | Same as above | |
Modify Table Properties
Sync method is SQL.
| Property | Supported | Doris version | CCR version | Can upstream operate | Can downstream operate | Description |
|---|
| colocate | Not supported | | | Yes | No | |
| distribution type | Not supported | | | No | Same as above | |
| dynamic partition | Not supported | | | Yes | Same as above | |
| replication_num | Not supported | | | No | No | |
| replication_allocation | Not supported | | | No | | |
| storage policy | Not supported | | | No | No | |
| enable_light_schema_change | Not supported | | | | | CCR can only synchronize lightweight schema changes of tables. |
| row_store | Unknown | | | | | |
| bloom_filter_columns | Unknown | | | | | |
| bucket num | Not supported | | | Yes | No | |
| isBeingSyced | Not supported | | | No | No | |
| compaction series properties | Not supported | | | Yes | No, triggering full sync downstream operations will cause data loss | |
| skip_write_index_on_load | Not supported | | | Yes | Same as above | |
| seq column | Supported | - | - | Yes | No, triggering full sync downstream operations will cause data loss | |
| delete sign column | Supported | - | - | Yes | Same as above | |
| comment | Not supported | | | Yes | No, triggering full sync downstream operations will cause data loss | |
Column Operations
Column operations on Base Index in the table.
| Operation | Supported | Doris version | CCR version | Sync Method | Can downstream operate | Remarks |
|---|
| add key column | Supported | - | - | Database-level task Partial Sync, Table-level task Partial Sync | No | |
| add value column | Supported | - | - | SQL | No | |
| drop key column | Supported | - | - | Database-level task Partial Sync, Table-level task Partial Sync | Same as above | |
| drop value column | Supported | - | - | SQL | Same as above | |
| modify column | Supported | - | - | Full Sync / Partial Sync | Same as above | Will attempt to delete the downstream table before starting |
| order by | Supported | - | - | Full Sync / Partial Sync | Same as above | Will attempt to delete the downstream table before starting |
| rename | | | | | Same as above | |
| comment | Not supported | | | | Same as above | |
Column operations on Rollup Index in the table.
| Operation | Supported | Remarks |
|---|
| add column | Unknown | Causes CCR task interruption |
| drop column | Unknown | Same as above |
| modify column | Unknown | Same as above |
| order by | Unknown | Same as above |
Rollup
| Operation | Supported | Remarks |
|---|
| add rollup | Not supported | |
| drop rollup | Not supported | |
| rename rollup | Not supported | CCR task interruption |
Index
Inverted Index
| Operation | Supported | Remarks |
|---|
| create index | Not supported | Unknown impact |
| drop index | Unknown | Unknown impact |
Bloom Filter
| Operation | Supported | Remarks |
|---|
| add bloom filter | Not supported | Unknown impact |
| alter bloom filter | Not supported | Unknown impact |
| drop bloom filter | Not supported | Unknown impact |
Data
Import
| Import Method | Supported | Doris version | CCR version | Sync Method | Can downstream operate | Description |
|---|
| stream load | Supported (except for temporary partitions) | - | - | TXN | No, if downstream imports, subsequent triggers of full or Partial Sync will cause data loss | Upstream transactions are visible, i.e., data is visible when generating binlog, downstream starts syncing. |
| broker load | Supported (except for temporary partitions) | - | - | TXN | Same as above | Same as above |
| routine load | Supported (except for temporary partitions) | - | - | TXN | Same as above | Same as above |
| mysql load | Supported (except for temporary partitions) | - | - | TXN | Same as above | Same as above |
| group commit | Supported (except for temporary partitions) | 2.1 | 2.1 | TXN | Same as above | Same as above |
Data Operations
| Operation | Supported | Doris version | CCR version | Sync Method | Can downstream operate | Description |
|---|
| delete | Supported | - | - | TXN | No, if downstream operates, subsequent triggers of full or Partial Sync will cause data loss | Upstream transactions are visible, i.e., data is visible when generating binlog, downstream starts syncing. |
| update | Supported | - | - | TXN | Same as above | Same as above |
| insert | Supported | - | - | TXN | Same as above | Same as above |
| insert into overwrite | Supported (except for temporary partitions) | 2.1.6 | | Partial Sync | Same as above | Same as above |
| insert into overwrite | Supported (except for temporary partitions) | 2.0 | | full sync | Same as above | Same as above |
| Explicit transaction (3.0) begin commit | Not supported | | | | | |
Partition Operations
| Operation | Supported | Doris version | CCR version | Sync Method | Can downstream operate separately | Description |
|---|
| add partition | Supported | - | - | SQL | No, subsequent triggers of Full Sync or Partial Sync will cause downstream operations to be lost | cooldown time property and its behavior unknown |
| add temp partition | Not supported | | | | Same as above | |
| drop partition | Supported | - | - | Before 2.0.15/2.1.6: Full Sync, after: SQL | Same as above | |
| replace partition | Supported | | | Partial Sync | Same as above | Partial Sync only supports strict range and non-temp partition replace method, otherwise it will trigger Full Sync. |
| modify partition | Not supported | Not released | Not released | SQL | Same as above | |
| rename partition | Table-level tasks do not support database-level tasks | Not released | Not released | SQL | Same as above | Table-level task rename will cause CCR tasks to stop |
View
| Operation | Supported | Doris version | CCR version | Sync Method | Remarks |
|---|
| create view | Supported | - | - | SQL | Can work when upstream and downstream have the same name. |
| alter view | Not supported | | | | No binlog |
| drop view | Not supported | | | | |
Materialized View
Synchronous Materialized View
| Operation | Supported | Remarks |
|---|
| create materialized view | Unknown | Can work when upstream and downstream have the same name; if different names, downstream needs to manually recreate the view. |
| drop materialized view | Unknown | |
Asynchronous Materialized View
| Operation | Supported |
|---|
| create async materialized view | Not supported |
| alter async materialized view | Not supported |
| drop async materialized view | Not supported |
| refresh | Not supported |
| pause | Not supported |
| resume | Not supported |
Statistics
Not synchronized between upstream and downstream, work independently.
Others
| Operation | Supported |
|---|
| external table | Not supported |
| recycle bin | Not supported |
| catalog | Not supported |
| workload group | Not supported |
| job | Not supported |
| function | Not supported |
| policy | Not supported |
| user | Not supported |
| cancel alter job | Supported |
