3 docs tagged with "sql"

Build a real-time transit monitoring system that ingests GTFS feeds, stores time-series data in Apache Ignite 3, and runs SQL-based monitoring queries.

Create tables, run queries, and use EXPLAIN to understand colocated query execution in Ignite SQL.

Move beyond client-side joins. Annotate POJOs with @QuerySqlField, run SqlFieldsQuery on cached data, and use colocation for fast cross-cache JOINs.