Quick Primer on Trino

Download Java 22 (or above):
https://www.oracle.com/java/technologies/downloads/

e.g.: 
wget https://download.oracle.com/java/24/latest/jdk-24_linux-x64_bin.deb
sudo dpkg -i jdk-24_linux-x64_bin.deb

put into .bashrc:
export JAVA_HOME=/usr/lib/jvm/jdk-24.0.1-oracle-x64
export PATH="$JAVA_HOME/bin:$PATH";

Go to https://trino.io/download

Download: 
Server packages: trino-server-475.tar.gz
Command line client: trino-cli-475-executable.jar
JDBC driver: trino-jdbc-475.jar (put this into SQLRunner/jdbc folder).

Extract:
tar -xvzf trino-server-475.tar.gz

Make a symbolic link:
ln -s trino-server-475 trino

put into .bashrc:
export TRINO_HOME=/home/alex/trino
export PATH="$TRINO_HOME/bin:$PATH";

Move trino-cli-475-executable.jar into $TRINO_HOME/bin

ln -s $TRINO_HOME/bin/trino-cli-475-executable.jar $TRINO_HOME/bin/trino

Create $TRINO_HOME/etc folder.

Create $TRINO_HOME/etc/node.properties:

node.environment=production
node.id=ffffffff-ffff-ffff-ffff-ffffffffffff
node.data-dir=/media/datassd2/trino-data/
(replace folder to where you want to store data).

Create $TRINO_HOME/etc/logo.properties: 

io.trino=INFO

Create $TRINO_HOME/etc/config.properties:

coordinator=true
node-scheduler.include-coordinator=true
http-server.http.port=8080
query.max-memory=16GB
discovery.uri=http://localhost:8080
catalog.management=dynamic
task.concurrency=32

Create $TRINO_HOME/etc/jvm.config:

-server
-Xmx16G
-Djol.tryWithSudo=true
-XX:+EnableDynamicAgentLoading
-XX:+UseG1GC
-XX:G1HeapRegionSize=32M
-XX:+ExplicitGCInvokesConcurrent
-XX:+ExitOnOutOfMemoryError
-XX:+HeapDumpOnOutOfMemoryError
-XX:ReservedCodeCacheSize=512M
-XX:PerMethodRecompilationCutoff=10000
-XX:PerBytecodeRecompilationCutoff=10000
-Djdk.attach.allowAttachSelf=true
-Djdk.nio.maxCachedBufferSize=2000000


RUNNING: 

In $TRINO_HOME folder: 

./launcher run

Connect to the server by running:

trino

connect it to PostgreSQL: 

trino> CREATE CATALOG pg USING postgresql
    -> WITH (
    ->   "connection-url" = 'jdbc:postgresql://localhost:5432/alex',
    ->   "connection-user" = 'alex',
    ->   "connection-password" = '12345',
    ->   "case-insensitive-name-matching" = 'true'
    -> );
CREATE CATALOG

trino>  select count(*) from pg.public.cts;
  _col0   
----------
 44314948