Tutorial Presto 8.8 [ ESSENTIAL ]

Assuming you have a geotable with a geometry column (e.g., in Hive):

SELECT
    name,
    ST_Area(geometry) AS area_sqkm
FROM hive.gis.locations
WHERE ST_Within(geometry, ST_Point(-74.006, 40.7128));

Presto 8.8 leverages modern Garbage Collectors. Use these optimal flags for Java 17:

-server
-Xmx8G
-XX:+UseG1GC
-XX:G1HeapRegionSize=32M
-XX:+UseGCOverheadLimit
-XX:+ExplicitGCInvokesConcurrent
-XX:+HeapDumpOnOutOfMemoryError
-XX:+ExitOnOutOfMemoryError
--add-opens=java.base/sun.nio.ch=ALL-UNNAMED

This file distinguishes each node in the cluster. For a single node: tutorial presto 8.8

node.environment=production
node.id=presto-coordinator-1
node.data-dir=/var/presto/data

To get the most out of this tutorial, apply these tuning suggestions.

Presto runs as a coordinator (master) and workers (slaves). For this tutorial, we will set up a single-node cluster (one machine acting as both coordinator and worker). Assuming you have a geotable with a geometry column (e

Navigate to the official PrestoDB release page or use wget:

wget https://repo1.maven.org/maven2/io/prestosql/presto-server/8.8/presto-server-8.8.tar.gz
tar -xzf presto-server-8.8.tar.gz
sudo mv presto-server-8.8 /usr/local/presto

-- Show catalogs (Iceberg, PostgreSQL, etc.)
SHOW CATALOGS;
-- Show schemas in PostgreSQL
SHOW SCHEMAS FROM postgresql; Presto 8
-- Show tables in Iceberg
SHOW TABLES FROM iceberg.default;