The Ultimate Guide to High Availability with MariaDB

Configuring ColumnStore Cross-Engine Joins

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

MariaDB ColumnStore allows columnstore tables to be joined with non-columnstore tables (e.g. MyISAM tables) within a query. The non-columnstore table may be on the MariaDB ColumnStore system OR on an external server that supports JDBC connections.

To enable this process, the <CrossEngineSupport> section in Columnstore.XML is configured with JDBC connection information. The following is an example entry in the Columnstore.XML configuration file to gain access to joined tables residing in native MariaDB on the same server as MariaDB ColumnStore:

<CrossEngineSupport>
       <Host>127.0.0.1</Host>
       <Port>3306</Port>
       <User>mydbuser</User>
       <Password>pwd</Password>
</CrossEngineSupport>

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.