Tutorial #

A hands-on path from zero to the features that make Pizza different. Every lesson runs against the deterministic teaching dataset, and every query in it is live — press the button, see real results. Wherever the SQL subset reaches the same question, the lesson shows both spellings side by side: the DSL example and its SQL twin, each in its own live widget.

The lessons #

1. First search — start the node, index documents, run your first queries, watch them update in real time.
2. Text search — term vs match, phrases, fuzzy, wildcard, regexp; how analyzers shape what matches.
3. Structure and numbers — ranges, sorts, pagination with cursors, and the field-type system behind them.
4. Aggregations — metrics, buckets, histograms, composite paging; known answers every step of the way.
5. Graph traversal — entities and relationships as documents, traverse over related_to edges, seeds by keys or by query, hit sets rendered with the graph block, and a real movie graph modeled end to end.
6. Hybrid search — the explicit retrieve → fuse → score pipeline, BM25 and vectors side by side.
7. Geographic search — from schema to data to queries: geo_point vs geo_shape, distance/box/polygon filters, shape relations.
8. Joins — one query across two collections: the semi-join step by step, declared references, routing and salting. Advanced, and server-side — the first lesson that cannot run in the browser widget.
9. Operations — partial updates in place, compaction, the change feed, and reading cluster health.

Start with Lesson 1 — first search, or pick the topic you need. For the full query vocabulary while you work through the lessons, see the search reference and the aggregation reference.