Tutorial Presto: 8.8

-- Query with aggregation SELECT product, SUM(amount) AS total FROM memory.default.sales GROUP BY product; 5.1 Cross-Connector Joins (Data Federation) One of the most celebrated features is querying across different data sources in a single SQL statement.

-- List all catalogs SHOW CATALOGS; -- List schemas in the memory catalog SHOW SCHEMAS FROM memory; tutorial presto 8.8

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): -- Query with aggregation SELECT product, SUM(amount) AS

node.environment=production node.id=presto-master-01 node.data-dir=/var/presto/data Create etc/jvm.config : You can control it: coordinator=true node-scheduler

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

SELECT name, ST_Area(geometry) AS area_sqkm FROM hive.gis.locations WHERE ST_Within(geometry, ST_Point(-74.006, 40.7128)); In Presto 8.8, dynamic filtering is enabled by default. You can control it:

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: