-- List all catalogs SHOW CATALOGS; -- List schemas in the memory catalog SHOW SCHEMAS FROM memory;
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
-- Insert data INSERT INTO memory.default.sales VALUES (1, 'Laptop', 999.99, DATE '2025-01-15'), (2, 'Mouse', 25.50, DATE '2025-01-16'); -- List all catalogs SHOW CATALOGS; -- List
node.environment=production node.id=presto-master-01 node.data-dir=/var/presto/data Create etc/jvm.config : -- List all catalogs SHOW CATALOGS
connector.name=postgresql connection-url=jdbc:postgresql://localhost:5432/analytics connection-user=db_user connection-password=db_pass Create etc/catalog/memory.properties :