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:
connector.name=hive-hadoop2 hive.metastore.uri=thrift://localhost:9083 hive.allow-drop-table=true hive.s3.aws-access-key=YOUR_ACCESS_KEY hive.s3.aws-secret-key=YOUR_SECRET_KEY Create etc/catalog/postgresql.properties : tutorial presto 8.8
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
-- Create a sample table in memory CREATE TABLE memory.default.sales ( order_id BIGINT, product VARCHAR, amount DECIMAL(10,2), sale_date DATE ); In 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.
connector.name=memory memory.max-data-per-node=512MB Restart Presto after adding catalogs: