8.8 - Tutorial Presto

node.environment=production node.id=presto-master-01 node.data-dir=/var/presto/data Create etc/jvm.config :

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

-- Insert data INSERT INTO memory.default.sales VALUES (1, 'Laptop', 999.99, DATE '2025-01-15'), (2, 'Mouse', 25.50, DATE '2025-01-16'); In Presto 8.8

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