Tutorial Presto 8.8 Fix -

WITH session_bounds AS ( SELECT session_id, MIN(event_time) AS start_time, MAX(event_time) AS end_time, COUNT(*) AS clicks FROM clicks WHERE event_date BETWEEN '2025-04-20' AND '2025-04-27' GROUP BY session_id ) SELECT session_id, date_diff('second', start_time, end_time) AS duration_sec, clicks, RANK() OVER (ORDER BY date_diff('second', start_time, end_time) DESC) AS rank FROM session_bounds ORDER BY duration_sec DESC LIMIT 10;

Create iceberg.properties :

Now that we have set up the Presto cluster and created a catalog, let's query some data. Here are the basic steps: tutorial presto 8.8