Skip to main content
Aerospike Vector is now live with LangChain integrationTell me more
Loading

Deploying the Trino Connector and a Trino Cluster on Bare Metal or in VMs

You can run the Trino connector and a Trino cluster on bare-metal servers or in virtual machines.

Prerequisites​

  • Aerospike Database Enterprise Edition 5.2 or later is required.
  • Ensure that the feature key for Aerospike Connect for Trino is installed on each node of your Aerospike cluster.
  • To use secondary index (SI) query support you need Aerospike Database 6.0 or later.
  • If you are using Trino (formerly known as PrestoSQL), verify that you are using a compatible version of the Trino connector.

Procedure​

To install the Trino connector and start it, follow these steps:

Download the installation package​

Download the installation package for Aerospike Connect for Trino and extract the content to a temporary folder.

On each node of your Trino cluster, follow these steps:​

  1. Copy all .jar files from the trino-aerospike/target/trino-aerospike-<version> folder to plugin/aerospike folder under the Trino installation root.

  2. Create the file <trino_dir>/etc/catalog/aerospike.properties to mount the aerospike connector as the aerospike catalog, where <trino_dir> is the installation directory for Trino. If you plan to query more than one Aerospike database or federate queries across Aerospike databases, add additional properties files, one for each cluster, each with a different name, such as aerospike2.properties, to etc/catalog/.

  3. Add these lines to the file:

    connector.name=aerospike
    aerospike.hostlist=localhost:3000

  4. (Optional) Specify the Trino schemas that correspond to the Aerospike sets your client applications will query. By default, the Trino connector uses heuristics to rapidly infer schemas without requiring you to specify them. However, you can choose to provide the schemas.

  5. Specify values for configuration properties.

Restart each node in your Trino cluster​

What to do next​

Run test queries against your Aerospike database by using the Trino CLI, which you can install from here. For examples of how to do this, see Examples of Querying Aerospike Databases with the Trino CLI.

After testing, you can connect to Trino by using the business-intelligence or visualization tool of your choice, such as Tableau Desktop (version 2020.3 or later) or Jupyter Notebook, and start your analysis of data in Aerospike.

No matter which tool you use for your data analysis, remember that:

  • You must use the name you catalogued for your Aerospike database as the name of the Trino catalog. This name is also used for the .properties file in which configuration properties are set for the interactions between your Aerospike database and the Trino connector.
  • You must use the name of the Aerospike namespace where your data resides as the name of the Trino schema.
  • Sets in Aerospike correspond to tables in Trino.
Last updated on