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 default_table_type 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