Tutorial Presto 8.8 < EXCLUSIVE - Fix >

bin/launcher status Expected output: Running as [PID] . wget https://repo1.maven.org/maven2/io/prestosql/presto-cli/8.8/presto-cli-8.8-executable.jar mv presto-cli-8.8-executable.jar presto chmod +x presto ./presto --server localhost:8080 You should see the Presto shell: presto> Part 3: Configuring Catalogs in Presto 8.8 Presto’s superpower is its connector architecture. Let’s set up three common catalogs. 1. Hive Connector (for S3 or HDFS) Create etc/catalog/hive.properties :

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

connector.name=postgresql connection-url=jdbc:postgresql://localhost:5432/analytics connection-user=db_user connection-password=db_pass Create etc/catalog/memory.properties : bin/launcher status Expected output: Running as [PID]