Tutorial Presto 8.8 [cracked] -

Since Presto 8.8 is a historical release (from the 8.x line before the transition to Presto 8.x/Trino split), this guide focuses on key features available in Presto 8.8 and how to use them.

Example Query Patterns

• Aggregation: SELECT region, COUNT(*) AS orders, SUM(amount) AS total FROM orders WHERE order_date BETWEEN DATE '2026-01-01' AND DATE '2026-03-31' GROUP BY region;
• Join across systems: SELECT c.customer_id, c.name, o.total FROM mysql.customers c JOIN hive.orders o ON c.customer_id = o.customer_id WHERE o.order_date >= DATE '2026-04-01';

1.1 Download Presto 8.8

Navigate to the official PrestoDB release page or use wget:

wget https://repo1.maven.org/maven2/io/prestosql/presto-server/8.8/presto-server-8.8.tar.gz
tar -xzf presto-server-8.8.tar.gz
sudo mv presto-server-8.8 /usr/local/presto

Part 4: Basic Queries – Your First Presto 8.8 Session

Connect via CLI and run these commands:

-- List all catalogs
SHOW CATALOGS;
-- List schemas in the memory catalog
SHOW SCHEMAS FROM memory;
-- Create a sample table in memory
CREATE TABLE memory.default.sales (
order_id BIGINT,
product VARCHAR,
amount DECIMAL(10,2),
sale_date DATE
); 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');
-- Query with aggregation
SELECT product, SUM(amount) AS total
FROM memory.default.sales
GROUP BY product;
 Since Presto 8

Key Components

1. Coordinator – Parses SQL, plans queries, tracks worker progress.
2. Worker – Executes tasks, processes splits, exchanges data.
3. Connector – Bridges Presto to a data source (e.g., hive.properties).