Nested data organizes fields inside other structured values. In ksqlDB, model each nested object with STRUCT, including its field names and types. section 11.6
Work with nested fields by following the structure:
- Define every object as STRUCT<field type, ...>, nesting STRUCT declarations when objects contain other objects. section 11.6
- Dereference nested fields with ->, repeating the path for deeper objects; use an index to select an array entry. section 11.6
Course recommendations from a school event
A JSON event can contain a student, class, professor, and the professor's other classes. Query event->student->id and event->class->professor->other_classes to emit a student identifier and suggested courses.
