Not able to create column store temporary table getting below error:-
ERROR 1706 ER_MEMSQL_FEATURE_LOCKDOWN: Feature ‘Columnstore temporary table’ is not supported by MemSQL.
But in docs mentioned that “Temporary tables can be further classified as global temporary tables, which can only be created in rowstores.”
Create table Syntax:-
CREATE Temporary TABLE test_abc113
(
testid int,
name1 varchar(50),
key(testid) USING CLUSTERED COLUMNSTORE
);