4 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.

Populate a GridGain table with JSON data, query it with JSON_VALUE and JSON_QUERY, and speed up queries by flattening fields into indexed columns.