The Ultimate Guide to High Availability with MariaDB

Cross-Engine join on external server

You are viewing an old version of this question. View the current version here.

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.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.