memsql does not support temporary table or table variable? -

tried create temp table in memsql: create temporary table ppl_in_grp select pid h_groupings dt= '2014-10-05' , location = 'seattle'

got error: feature 'temporary tables' not supported memsql.

is there equivalence can use instead? thanks!

temp tables on roadmap. now, memsql 4 can create regular table , clean @ end of session, or use subqueries.