Cross-Engine join on external server
The cross engine join documentation https://mariadb.com/kb/en/library/configuring-columnstore-cross-engine-joins/ implies that once configured I can join a column store table on my local host to an innodb table on a different host. I could not find any example of how to write such a query. How do I write a query where table1 is the column store table on local server and table2 is an innodb table on the host referenced in the CrossEngineSupport XML?
Answer Answered by Andrew Hutchings in this comment.
Technically it is possible but we do not officially support it. To do this you would need identical InnoDB schemas on the local sever for all the tables on the remote so the parser can execute the query. You might be better off using the CONNECT engine or similar and doing a local cross-engine join to that.
