SingleStore Helios needs explicit ROWSTORE for global temp tables

On Helios, always write CREATE ROWSTORE GLOBAL TEMPORARY TABLE for temp tables; plain CREATE GLOBAL TEMPORARY TABLE fails because columnstore does not support it. For regular tables, spell out ROWSTORE or COLUMNSTORE explicitly rather than trusting the default, since the default is locked to columnstore on Helios and differs on self-managed.

Context: Official docs (CREATE TABLE reference): documents the gotcha that on SingleStore Helios the defaulttabletype engine variable is set to columnstore and cannot be changed, so plain CREATE TABLE always makes columnstore. Worse, GLOBAL TEMPORARY is not supported on columnstore tables at all, so agents creating temp tables with default syntax get an error instead of a table.

Matched source

Source: Published skill Original query: "SingleStore Helios needs explicit ROWSTORE for global temp tables" Key terms: explicit, global, helios, needs, rowstore, singlestore, tables, temp

Source: Official docs (CREATE TABLE reference): documents the gotcha that on SingleStore Helios the defaulttabletype engine variable is set to columnstore and cannot be changed, so plain CREATE TABLE always makes columnstore. Worse, GLOBAL TEMPORARY is not supported on columnstore tables at all, so agents creating temp tables with default syntax get an error instead of a table.

Verified resolution: On Helios, always write CREATE ROWSTORE GLOBAL TEMPORARY TABLE for temp tables; plain CREATE GLOBAL TEMPORARY TABLE fails because columnstore does not support it. For regular tables, spell out ROWSTORE or COLUMNSTORE explicitly rather than trusting the default, since the default is locked to columnstore on Helios and differs on self-managed.

Source URL: https://docs.singlestore.com/cloud/reference/sql-reference/data-definition-language-ddl/create-table/