GBase 8a MPP Cluster offers three primary data distribution strategies: Hash distribution , random distribution , and replicated tables . Each determines how data is physically placed across nodes, directly impacting join and aggregation performance in a gbase database .

Strategy Overview

Strategy Syntax Distribution Method Key Feature

Hash DISTRIBUTED BY (column) Rows with the same column value are mapped to the same node via hash. Data locality — related rows are physically together, ideal for joins and grouping.

Random Default (no keyword) or DISTRIBUTED RANDOMLY Data is scattered evenly across all data nodes. Perfect load balancing — equal data volume and compute pressure on every node.

Replicated REPLICATED A full copy of the table exists on every data node. Global redundancy — no network transfer needed for joins.

When to Use Each Strategy

1.…