Skip to content

Instantly share code, notes, and snippets.

@ijokarumawak
Created October 6, 2015 14:57
Show Gist options
  • Save ijokarumawak/bb7696e13ba856446bc3 to your computer and use it in GitHub Desktop.
Save ijokarumawak/bb7696e13ba856446bc3 to your computer and use it in GitHub Desktop.
// 元となるN1QLクエリ
SELECT r.* from `travel-sample` r
WHERE r.sourceairport = "SFO"
AND r.destinationairport = "LAX"
LIMIT 1;
// 結果
{
"airline": "AS",
"airlineid": "airline_439",
"destinationairport": "LAX",
"distance": 543.1728350169337,
"equipment": "738",
"id": 11981,
"schedule": [
{ "day": 0, "flight": "AS274", "utc": "10:06:00" },
"中略",
{ "day": 6, "flight": "AS987", "utc": "08:21:00" }
],
"sourceairport": "SFO",
"stops": 0,
"type": "route"
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment