Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

Distributed SQL Surface Area

SingleStore DB 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 is a superset of the shard key).
  • Sharded tables do not support UPDATE queries that modify the shard key.
  • Sharded tables do not support UPDATE...LIMIT.