Tutorial Presto 8.8 (2025)

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:

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

-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): SELECT name, ST_Area(geometry) AS area_sqkm FROM hive

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