An error occurred when executing the SQL command:
create temporary table tmp_tab_b_max as
select max(col1) as col1 from tab_a where group by col2;
Feature ‘Cross database insert select into temporary tables’ is not supported by MemSQL Distributed.
1 statement failed.
In above scenario (MemSQL 6.8.14), table tab_a in database db_a, and trying to create the temporary table tmp_tab_b_max in database db_b.
Any limitations on creating temporary tables in a database using tables in another database? Also, any limitations on size of the tables?