memsql does not support temporary table or table variable?

Tried to create temp table in Memsql: Create temporary table ppl_in_grp as select pid from h_groupings where dt= '2014-10-05' and location = 'Seattle'

Got this error: Feature 'TEMPORARY tables' is not supported by MemSQL.

Is there any equivalence I can use instead? Thanks!

Solution

temp tables are definitely on the roadmap. For now, with MemSQL 4 you can create a regular table and clean it up at the end of your session, or use subqueries.

In MySQL, how can I do a DELETE based on the result from a table where I did an INNER JOIN with the same table?
Create a stored procedure that iterates over another stored procedure?
How do I use a temp table across multiple c# calls
Stored proc temporary table with parameters
Is it possible to insert into two tables at the same time?
How to design usage of Global temp table for a multi-user environment? (or alternatives)
Select Into Explanation / Temporary Tables
Is there a correct way to utilise SQL UNIONs in order to select the max value from three potential queries?
How can I create a new temp table for each day given in a range?
TSQL select into Temp table from dynamic sql
Is it possible to wrap a string of CTE's together into one TEMP table in SQL?
Using temporary table- How do I pass more than 1,000 parameters in SQL in Clause
How to fetch records having multiple rows with different column values
Temporary table in SQL server causing ' There is already an object named' error
Temp Table INLINE Indexing UNIQUE CLUSTERED vs NON-UNIQUE NONCLUSTERED, and naming requirements
Using a temp PostgreSQL table in a connection from pgbouncer pool
Copy data from different activities in ADF and wait for all to finish before copying to dedicated table in Synapse
Use temp table with SQLAlchemy
What's the difference between a temp table and table variable in SQL Server?
How to retrieve field names from temporary table (SQL Server 2008)
Big Query SQL syntax error using the WITH clause
PLSQL to search a database for a value
CREATE TEMPORARY TABLE IN SNOWFLAKE USING CTE
Drop temp table if it exists on SQL Azure
delete temporary files in postgresql
How to insert into a temp table the info given by RESTORE FILELISTONLY / HEADERONLY / VERIFYONLY
SQL GAPS AND ISLANDS
Joining return tables from sql functions which have same name temp tables
BigQuery stored procedure: unexpected identifier error when using declared variable in LIMIT clause
SQL Insert Into Temp Table in both If and Else Blocks