Trino Installation on VM with OpenLineage

This guide explains how to install Trino on a Linux virtual machine and configure OpenLineage integration for capturing query lineage events.

The document covers:

System preparation
Trino installation
Trino configuration
OpenLineage plugin setup
Starting and validating Trino
Installing the Trino CLI

Running Trino as a system service.

1. System Preparation

Before installing Trino, update the system and install the required dependencies.

Update the System

Bash
    
 
sudo apt update && sudo apt upgrade -y
Copy

Install Java (Required for Trino)

Bash
    
 
sudo apt install -y openjdk-17-jdkjava -version
Copy

Install Additional Utilities

Bash
    
 
sudo apt install -y wget curl jq
Copy

2. Install Trino

Create the installation directory

Bash
    
 
sudo mkdir -p /opt/trinocd /opt/trino
Copy

Download the Trino server package

Bash
    
 
sudo wget https://repo1.maven.org/maven2/io/trino/trino-server/438/trino-server-438.tar.gz
Copy

Extract and organize the installation

Bash
    
 
sudo tar -xzf trino-server-438.tar.gzsudo mv trino-server-438 serversudo rm trino-server-438.tar.gz
Copy

Create required directories

Bash
    
 
sudo mkdir -p /var/trino/datasudo mkdir -p /opt/trino/server/etcsudo mkdir -p /opt/trino/server/etc/catalog
Copy

3. Configure Trino

Trino requires several configuration files located under:

Create node.properties

This file defines node identity and data directory.

Bash
    
 
sudo tee /opt/trino/server/etc/node.properties > /dev/null << 'EOF'node.environment=productionnode.id=trino-single-nodenode.data-dir=/var/trino/dataEOF
Copy

Create jvm.config

Configure JVM memory settings and adjust the -Xmx value according to your VM memory.

Example for an 8GB memory allocation:

Bash
    
 
sudo tee /opt/trino/server/etc/jvm.config > /dev/null << 'EOF'-server-Xmx8G-XX:InitialRAMPercentage=80-XX:MaxRAMPercentage=80-XX:+ExplicitGCInvokesConcurrent-XX:+ExitOnOutOfMemoryError-XX:+HeapDumpOnOutOfMemoryErrorEOF
Copy

Create config.properties

Defines Trino server behavior.

Bash
    
 
sudo tee /opt/trino/server/etc/config.properties > /dev/null << 'EOF'coordinator=truenode-scheduler.include-coordinator=truehttp-server.http.port=8080discovery.uri=http://localhost:8080EOF
Copy

Configure Logging

Bash
    
 
sudo tee /opt/trino/server/etc/log.properties > /dev/null << 'EOF'io.trino=INFOEOF
Copy

Configure a Test Catalog (TPC-H)

This creates a sample catalog for testing queries.

Bash
    
 
sudo tee /opt/trino/server/etc/catalog/tpch.properties > /dev/null << 'EOF'connector.name=tpchEOF
Copy

4. Install the OpenLineage Plugin

The OpenLineage plugin allows Trino to send lineage events to external systems.

Navigate to the plugin directory

Bash
    
 
cd /opt/trino/server/plugin
Copy

Create a directory for the OpenLineage plugin

Bash
    
 
sudo mkdir -p openlineagecd openlineage
Copy

Download the Plugin

Bash
    
 
sudo wget https://repo1.maven.org/maven2/io/openlineage/openlineage-trino/1.23.0/openlineage-trino-1.23.0.jar
Copy

Verify the Installation

Bash
    
 
ls -lh
Copy

Expected Output: openlineage-trino-1.23.0.jar

5. Configure OpenLineage Event Listener

Create the event listener configuration file.

Bash
    
​x
 
sudo tee /opt/trino/server/etc/event-listener.properties > /dev/null << 'EOF'event-listener.name=openlineage​# Trino server URIopenlineage-event-listener.trino.uri=http://<YOUR_TRINO_HOST>:8080​# Transport configurationopenlineage-event-listener.transport.type=httpopenlineage-event-listener.transport.url=https://<TENANT_NAME>.acceldata.app/torch-pipeline/api/v1/lineage​# Authentication headersopenlineage-event-listener.transport.headers=accessKey:<YOUR_ACCESS_KEY>,secretKey:<YOUR_SECRET_KEY>​# Query types to captureopenlineage-event-listener.trino.include-query-types=INSERT,MERGE,DELETE,UPDATE​# Namespace for lineage eventsopenlineage-event-listener.namespace=trino-productionEOF
Copy

Replace the following placeholders with your environment values:

Place Holder	Description
`<YOUR_TRINO_HOST>`	Hostname or IP of the Trino server
`<TENANT_NAME>`	Acceldata tenant name
`<YOUR_ACCESS_KEY>`	Acceldata access key
`<YOUR_SECRET_KEY>`	Acceldata secret key

6. Set Directory Ownership

Ensure the correct user owns the directories.

Bash
    
 
sudo chown -R $USER:$USER /opt/trinosudo chown -R $USER:$USER /var/trino
Copy

7. Start Trino

Navigate to the Trino installation

Bash
    
 
cd /opt/trino/server
Copy

Start the server

Bash
    
 
./bin/launcher start
Copy

Check the server status

Bash
    
 
./bin/launcher status
Copy

Wait for the server to initialize.

Bash
    
 
sleep 30
Copy

8. Verify OpenLineage Initialization

Check logs to confirm the OpenLineage listener is registered.

Bash
    
 
grep -i "openlineage" /var/trino/data/var/log/server.log
Copy

Expected log message:

9. Verify Trino is Running

Bash
    
 
sudo netstat -tlnp | grep 8080
Copy

If successful, the output should show port 8080 listening.

10. Install Trino CLI

The CLI allows you to run queries from the command line.

Download the CLI

Bash
    
 
cd /tmpwget https://repo1.maven.org/maven2/io/trino/trino-cli/438/trino-cli-438-executable.jar
Copy

Install the CLI

Bash
    
 
sudo mv trino-cli-438-executable.jar /usr/local/bin/trinosudo chmod +x /usr/local/bin/trino
Copy

Verify installation

Bash
    
 
trino --version
Copy

11. Connect to Trino

Run the following command to connect to the server.

Bash
    
 
trino --server localhost:8080 --catalog tpch --schema tiny
Copy

You can now run SQL queries.

Example:

SQL
    
 
SELECT * FROM nation;
Copy

12. Run Trino as a systemd Service (Recommended)

Running Trino as a system service ensures it automatically starts after system reboot.

Create a Trino Service User

Bash
    
 
sudo useradd -r -s /bin/false trin
Copy

Assign Ownership

Bash
    
 
sudo chown -R trino:trino /opt/trinosudo chown -R trino:trino /var/trino
Copy

Stop the Manually Running Instance

Bash
    
 
cd /opt/trino/server./bin/launcher stop
Copy

Create the systemd Service File

Bash
    
 
sudo tee /etc/systemd/system/trino.service > /dev/null << 'EOF'[Unit]Description=Trino ServerAfter=network.target​[Service]Type=forkingUser=trinoGroup=trinoExecStart=/opt/trino/server/bin/launcher startExecStop=/opt/trino/server/bin/launcher stopRestart=on-failureRestartSec=10​[Install]WantedBy=multi-user.targetEOF
Copy

Enable and Start the Service

Reload systemd:

Bash
    
 
sudo systemctl daemon-reload
Copy

Enable Trino at boot:

Bash
    
 
sudo systemctl enable trino
Copy

Start the service:

Bash
    
 
sudo systemctl start trino
Copy

Verify Service Status

Bash
    
 
sudo systemctl status trino
Copy

Installation Complete

You have successfully:

Installed Trino

Configured TPC-H test catalog

Integrated OpenLineage

Installed the Trino CLI

Configured Trino as a system service

Trino is now ready for running queries and emitting lineage events to your configured OpenLineage endpoint.

Last updated on

Was this page helpful?