Last updated on
Paimon Catalog Capability Matrix
The following matrix summarizes the Paimon Catalog capabilities currently available in Doris. The rows are grouped by capability area, and the backend columns show whether each operation is available when Doris uses the corresponding metadata service. ✅ indicates that Doris supports the operation, and ❌ indicates that the operation is not currently supported.
The DLF column refers to paimon.catalog.type=dlf, which uses a Hive-compatible metastore client and requires OSS or OSS-HDFS storage configuration. DLF accessed through paimon.catalog.type=rest is covered by the REST column.
| Capability category | Operation | Filesystem | HMS | DLF | JDBC | REST |
|---|---|---|---|---|---|---|
| Namespace / Database | LIST_NAMESPACES | ✅ | ✅ | ✅ | ✅ | ✅ |
LOAD_NAMESPACE | ✅ | ✅ | ✅ | ✅ | ✅ | |
NAMESPACE_EXISTS | ✅ | ✅ | ✅ | ✅ | ✅ | |
CREATE_NAMESPACE | ✅ | ✅ | ✅ | ✅ | ✅ | |
ALTER_NAMESPACE_PROPERTIES | ❌ | ❌ | ❌ | ❌ | ❌ | |
DROP_NAMESPACE | ✅ | ✅ | ✅ | ✅ | ✅ | |
DROP_NAMESPACE_CASCADE | ✅ | ✅ | ✅ | ✅ | ✅ | |
MULTILEVEL_NAMESPACE | ❌ | ❌ | ❌ | ❌ | ❌ | |
| Table lifecycle | LIST_TABLES | ✅ | ✅ | ✅ | ✅ | ✅ |
LOAD_TABLE | ✅ | ✅ | ✅ | ✅ | ✅ | |
TABLE_EXISTS | ✅ | ✅ | ✅ | ✅ | ✅ | |
CREATE_TABLE | ✅ | ✅ | ✅ | ✅ | ✅ | |
CREATE_TABLE_WITH_LOCATION | ✅ | ✅ | ✅ | ✅ | ✅ | |
CTAS | ✅ | ✅ | ✅ | ✅ | ✅ | |
ATOMIC_CTAS | ❌ | ❌ | ❌ | ❌ | ❌ | |
REGISTER_TABLE | ❌ | ❌ | ❌ | ❌ | ❌ | |
REPLACE_TABLE | ❌ | ❌ | ❌ | ❌ | ❌ | |
DROP_TABLE | ✅ | ✅ | ✅ | ✅ | ✅ | |
PURGE_TABLE | ❌ | ❌ | ❌ | ❌ | ❌ | |
RENAME_TABLE | ❌ | ❌ | ❌ | ❌ | ❌ | |
SET_TABLE_LOCATION | ❌ | ❌ | ❌ | ❌ | ❌ | |
| Schema and layout evolution | ADD_COLUMN | ✅ | ✅ | ✅ | ✅ | ✅ |
DROP_COLUMN | ✅ | ✅ | ✅ | ✅ | ✅ | |
RENAME_COLUMN | ✅ | ✅ | ✅ | ✅ | ✅ | |
ALTER_COLUMN_TYPE | ✅ | ✅ | ✅ | ✅ | ✅ | |
ALTER_COLUMN_NULLABILITY | ✅ | ✅ | ✅ | ✅ | ✅ | |
SET_TABLE_PROPERTIES | ❌ | ❌ | ❌ | ❌ | ❌ | |
UNSET_TABLE_PROPERTIES | ❌ | ❌ | ❌ | ❌ | ❌ | |
EVOLVE_PARTITION_SPEC | ❌ | ❌ | ❌ | ❌ | ❌ | |
EVOLVE_SORT_ORDER | ❌ | ❌ | ❌ | ❌ | ❌ | |
| View | LIST_VIEWS | ❌ | ❌ | ❌ | ❌ | ❌ |
LOAD_VIEW | ❌ | ❌ | ❌ | ❌ | ❌ | |
READ_VIEW | ❌ | ❌ | ❌ | ❌ | ❌ | |
CREATE_VIEW | ❌ | ❌ | ❌ | ❌ | ❌ | |
REPLACE_VIEW | ❌ | ❌ | ❌ | ❌ | ❌ | |
ALTER_VIEW | ❌ | ❌ | ❌ | ❌ | ❌ | |
RENAME_VIEW | ❌ | ❌ | ❌ | ❌ | ❌ | |
DROP_VIEW | ❌ | ❌ | ❌ | ❌ | ❌ | |
| Data write | APPEND | ✅ | ✅ | ✅ | ✅ | ✅ |
OVERWRITE_TABLE | ✅ | ✅ | ✅ | ✅ | ✅ | |
OVERWRITE_PARTITION | ✅ | ✅ | ✅ | ✅ | ✅ | |
DYNAMIC_PARTITION_OVERWRITE | ✅ | ✅ | ✅ | ✅ | ✅ | |
UPDATE | ✅ | ✅ | ✅ | ✅ | ✅ | |
DELETE | ✅ | ✅ | ✅ | ✅ | ✅ | |
MERGE_INTO | ✅ | ✅ | ✅ | ✅ | ✅ | |
UPSERT | ✅ | ✅ | ✅ | ✅ | ✅ | |
PARTIAL_UPDATE | ✅ | ✅ | ✅ | ✅ | ✅ | |
WRITE_TO_BRANCH | ❌ | ❌ | ❌ | ❌ | ❌ | |
SCHEMA_EVOLUTION_ON_WRITE | ❌ | ❌ | ❌ | ❌ | ❌ | |
| Transactions and concurrency | ATOMIC_SINGLE_TABLE_COMMIT | ✅ | ✅ | ✅ | ✅ | ✅ |
MULTI_TABLE_COMMIT | ❌ | ❌ | ❌ | ❌ | ❌ | |
STAGED_CREATE | ❌ | ❌ | ❌ | ❌ | ❌ | |
OPTIMISTIC_CONCURRENCY | ✅ | ✅ | ✅ | ✅ | ✅ | |
COMMIT_CONFLICT_DETECTION | ✅ | ✅ | ✅ | ✅ | ✅ | |
COMMIT_RETRY | ❌ | ❌ | ❌ | ❌ | ❌ | |
COMMIT_IDEMPOTENCY | ✅ | ✅ | ✅ | ✅ | ✅ | |
COMMIT_STATUS_RECOVERY | ✅ | ✅ | ✅ | ✅ | ✅ | |
LOCK_REQUIRED | ❌ | ❌ | ❌ | ✅ | ❌ | |
LOCK_CONFIGURED | ❌ | ❌ | ❌ | ✅ | ❌ | |
SERIALIZABLE_ISOLATION | ❌ | ❌ | ❌ | ❌ | ❌ | |
FAILED_WRITE_CLEANUP | ✅ | ✅ | ✅ | ✅ | ✅ | |
| Branch / Tag | BRANCH_CREATE | ❌ | ❌ | ❌ | ❌ | ❌ |
BRANCH_DROP | ❌ | ❌ | ❌ | ❌ | ❌ | |
READ_BY_BRANCH | ✅ | ✅ | ✅ | ✅ | ✅ | |
BRANCH_WRITE | ❌ | ❌ | ❌ | ❌ | ❌ | |
BRANCH_FAST_FORWARD | ❌ | ❌ | ❌ | ❌ | ❌ | |
TAG_CREATE | ❌ | ❌ | ❌ | ❌ | ❌ | |
TAG_DROP | ❌ | ❌ | ❌ | ❌ | ❌ | |
READ_BY_TAG | ✅ | ✅ | ✅ | ✅ | ✅ | |
TAG_WRITE | ❌ | ❌ | ❌ | ❌ | ❌ | |
TAG_FAST_FORWARD | ❌ | ❌ | ❌ | ❌ | ❌ | |
| Snapshot | READ_BY_VERSION | ✅ | ✅ | ✅ | ✅ | ✅ |
READ_BY_TIME | ✅ | ✅ | ✅ | ✅ | ✅ | |
ROLLBACK | ❌ | ❌ | ❌ | ❌ | ❌ | |
EXPIRE | ❌ | ❌ | ❌ | ❌ | ❌ | |
| Maintenance | REMOVE_ORPHAN_FILES | ❌ | ❌ | ❌ | ❌ | ❌ |
REWRITE_DATA_FILES / COMPACT | ❌ | ❌ | ❌ | ❌ | ❌ | |
REWRITE_MANIFESTS | ❌ | ❌ | ❌ | ❌ | ❌ | |
REWRITE_DELETE_FILES | ❌ | ❌ | ❌ | ❌ | ❌ | |
EXPIRE_CHANGELOGS | ❌ | ❌ | ❌ | ❌ | ❌ | |
| Data ingestion | ADD_FILES | ❌ | ❌ | ❌ | ❌ | ❌ |
MIGRATE_TABLE | ❌ | ❌ | ❌ | ❌ | ❌ | |
COMPUTE_TABLE_STATS | ❌ | ❌ | ❌ | ❌ | ❌ |