Feature Differences between Shared-nothing and Shared-data Clusters
This topic lists the differences of features supported in shared-nothing and shared-data clusters.
Real-time Analytics and Primary Key Tablesβ
| Feature | Shared-nothing | Shared-data |
|---|
| Conditional Update | v2.5+ | v3.1+ |
| Partial Update Column mode | v3.1 | To be supported |
| Partial Update Row mode | v2.3+ | v3.1+ |
| Partial update with Conditional Update | v3.1+ | v3.4.1+ |
| Primary Key Index Persistence | v2.3+ | v3.2+ |
| Decoupled ORDER BY columns from Primary Keys | v3.0+ | v3.1+ |
| Rich UPDATE and DELETE syntax for Primary Key tables | v3.0+ | v3.1+ |
Storage Engineβ
| Feature | Shared-nothing | Shared-data |
|---|
| Fast Schema Evolution | v3.2+ | v4.0+ |
| File Bundling | Not applicable | v4.0+ |
| Inverted Index | v3.3+ | v4.1+ |
| Manual Compaction | v3.1+ | v3.3+ |
| Row Store | v3.2+ | To be supported |
| Adding/dropping STRUCT fields | v3.3.2+ | v3.3.5+ |
| Vector index | v3.4+ | To be supported |
Data Distributionβ
| Feature | Shared-nothing | Shared-data |
|---|
| Expression Partitioning | v3.0+ | v3.1.1+ |
| List Partitioning | v3.1+ | v3.1.1+ |
| Random Bucketing | v3.1+ | v3.2+ |
| Random Bucketing Optimization (with Sub-partition) | v3.2+ | v3.2+ |
| Unified Syntax for Multi-level Expression Partition | v3.4+ | v3.4+ |
| Optimize Table: Change Bucketing | v3.2+ | v3.3+ |
| Optimize Table: Change Bucketing Online | v3.3.3+ | Not applicable |
| Range-based Distribution | v4.1+ | v4.1+ |
| Feature | Shared-nothing | Shared-data |
|---|
| Cross-node Data Cache Sharing | Not applicable | v3.5.1+ |
| Generated Column | v3.1+ | v3.5+ |
| Query Cache | v2.5+ | v3.4+ |
| Rollup and Synchronous Materialized view | v1.x+ | v3.3+ |
Disaster Recoveryβ
| Feature | Shared-nothing | Shared-data |
|---|
| Backup & Restore | v1.x+ | Not applicable |
| BE/CN Blacklist | v3.3+ | v4.0+ |
| Cross-cluster Data Migration Tool | v3.3+ | Not applicable |
| Cluster Snapshot | Not applicable | v3.4.2+ |
Security and Authenticationβ
| Feature | Shared-nothing | Shared-data |
|---|
| Kerberos Support on HDFS | Not applicable | v3.2+ |