Hope you are doing good!
I work in a cross-functional team where we often deal with multiple databases to gather data, store them in a temporary table, and make the manipulations according to our business needs. When I try to do cross-database insert it fails with the following error.
Feature ‘Cross database insert select into temporary tables’ is not supported by MemSQL Distributed.
It will be really helpful if anyone can suggest a workaround/alternative for the cross-database insert.