Distributed SQL Surface Area
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
SingleStore supports a large subset of the SQL surface area, with the following limitations:
-
Reference tables must have explicit primary keys.
-
An
AUTO_
column in a distributed table must be a BIGINT.INCREMENT 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
Last modified: June 22, 2022