Tutorial Presto 8.8 [ Tested ]

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

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

connector.name=postgresql connection-url=jdbc:postgresql://localhost:5432/analytics connection-user=db_user connection-password=db_pass Create etc/catalog/memory.properties : connector

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): tutorial presto 8.8

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: