3-5: unnest.sql

// r.scheduleでUNNEST
SELECT META(r).id as rid, r.airlineid, r.equipment, s.flight, s.utc
  FROM `travel-sample` r
  UNNEST r.schedule AS s
  WHERE r.sourceairport = "SFO"
  AND r.destinationairport = "LAX"
  ORDER BY rid ASC, s.utc ASC
  LIMIT 2;

// 結果
[{
  "airlineid": "airline_439",
  "equipment": "738",
  "flight": "AS639",
  "rid": "route_11981",
  "utc": "02:13:00"
},
{
  "airlineid": "airline_439",
  "equipment": "738",
  "flight": "AS599",
  "rid": "route_11981",
  "utc": "03:52:00"
}]