SingleStore Managed Service Resources
The following references will allow you to work more in-depth with SingleStore Managed Service and obtain support to answer any questions you may have.
Columnstore as Default
default_table_type engine variable specifies whether
CREATE TABLE creates a default rowstore or columnstore table. In SingleStore Managed Service, the default is set to
columnstore for newly created v7.3 clusters only. For existing clusters, this variable remains as
While the “columnstore as default” feature now creates columnstore tables by default via the standard
CREATE TABLE syntax, you may also create a rowstore table explicitly via the
CREATE ROWSTORE TABLE ... syntax, regardless of the setting of
Hash Keys and Sort Keys
CREATE TABLE statement using
<k> as a hash key in the resulting columnstore table.
Hash keys support fast equality lookups, but not fast range filters. To create an index to help support fast range filters on a columnstore table, a sort key
<sk> can be used by explicitly specifying
KEY(<sk>) USING CLUSTERED COLUMNSTORE in your
CREATE TABLE statement.
Using more than one ordered index is no longer supported. Effectively, a table may only have one, which is the columnstore sort key.
Multi-column Unique Keys not Supported
Using multi-column unique keys in a columnstore table is not supported and will result in an error.
Lookups of a composite key may now take longer. For example, instead of seeking on one index
KEY(a) index and the
KEY(b) index must both be searched, and the key sets must then be intersected to determine which rows to look up.
Refer to Creating a Columnstore Table Using Standard CREATE TABLE Syntax for additional information.
Work with a Cluster
Take a self-paced training course to learn about SingleStore Managed Service
Load Data into a Cluster
Use SingleStore Pipelines to ingest real-time data from external sources
Load data into your cluster via Kafka pipeline
Monitor a Cluster
Interact with your cluster via MemSQL Studio
Connect a Looker dashboard to SingleStore Managed Service
SingleStore DB Concepts
- SingleStore DB Concepts provide an overview of SingleStore DB.
SingleStore DB References
SQL Reference Overview provides an overview of SQL syntax supported by SingleStore DB and SingleStore Managed Service
Data Manipulation Language (DML)-related operations contains a list of all data manipulation language (DML) commands in SingleStore DB that can be run against the cluster’s Child Aggregator