Tutorial Presto 8.8 May 2026

SELECT p.product_name, p.category, s.sale_amount FROM postgresql.public.products p JOIN memory.default.sales s ON p.product_id = s.order_id WHERE s.sale_date > DATE '2025-01-01'; Here, Presto 8.8 seamlessly pulls products from PostgreSQL and sales from the memory connector. Assuming you have a geotable with a geometry column (e.g., in Hive):

-server -Xmx4G -XX:+UseG1GC -XX:G1HeapRegionSize=32M -XX:+UseGCOverheadLimit -XX:+ExplicitGCInvokesConcurrent -Dlog.levels-file=etc/log.properties Create etc/config.properties (coordinator + worker on same machine): tutorial presto 8.8

connector.name=memory memory.max-data-per-node=512MB Restart Presto after adding catalogs: SELECT p

-- Create a sample table in memory CREATE TABLE memory.default.sales ( order_id BIGINT, product VARCHAR, amount DECIMAL(10,2), sale_date DATE ); sale_date DATE )

bin/launcher restart Connect via CLI and run these commands:

coordinator=true node-scheduler.include-coordinator=true http-server.http.port=8080 discovery.uri=http://localhost:8080 query.max-memory=3GB query.max-memory-per-node=1GB query.max-total-memory-per-node=2GB bin/launcher start Check status: