AKKOAnalytics Kernel · Keep OwnershipDocumentationWrite to usFR

Blog

What we learn while building AKKO.

Technical tutorials, tested end to end, on the engines and formats we use. Every command was replayed, every output comes from a real run.

RSS feed

Latest article

Trino

Trino 484: what's new, tested (JSON, EXCLUDE, Iceberg)

Trino 484 in seven queries

Standard SQL/JSON, precise intervals, EXCLUDE in window frames, and fixes for silently wrong results. Every example ran on the previous release, then on Trino 484.

Abderrahmen Dridi15 min readIntermediate
Read the article →

Inside

  1. 01JSON_TABLE finally reads the JSON type
  2. 02JSON keeps its order and its numbers
  3. 03Intervals with a precise type
  4. 04CREATE VIEW IF NOT EXISTS protects the existing view
  5. 05EXCLUDE compares a row with the others
  6. 06Wrong results fixed
  7. 07Iceberg accepts sorted_by and gc_enabled