Distributed SQL Surface Area
SingleStoreDB supports a large subset of the SQL surface area, with the following limitations:
Reference tables must have explicit primary keys.
An
AUTO_INCREMENT
column in a distributed table must be a BIGINT. Auto-increment values are monotonically increasing on each aggregator but not consecutive across the cluster.Sharded tables do not support unique keys (unless the unique key contains all columns of the shard key).
Sharded tables do not support
UPDATE
queries that modify the shard key.Sharded tables do not support
UPDATE...LIMIT
.