Skip to content

Instantly share code, notes, and snippets.

@purplefox

purplefox/curl1.txt

Created April 26, 2020 11:56
Show Gist options
  • Save purplefox/d531f614d63d4303b112dbf7f7c7b439 to your computer and use it in GitHub Desktop.
Save purplefox/d531f614d63d4303b112dbf7f7c7b439 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
curl1.txt
Tim-Foxs-MBP15:json_request tfox$ curl -X POST http://localhost:8088/query -H "Content-Type: application/json" -d '{
"ksql": "SELECT * FROM riderLocations WHERE GEO_DISTANCE(latitude, longitude, 37.4133, -122.1162) <= 5 EMIT CHANGES;",
"streamsProperties": {
"ksql.streams.auto.offset.reset": "earliest"
}
}'
[{"header":{"queryId":"none","schema":"`ROWKEY` STRING, `PROFILEID` STRING, `LATITUDE` DOUBLE, `LONGITUDE` DOUBLE"}},
{"row":{"columns":["4ab5cbad","4ab5cbad",37.3952,-122.0813]}},
{"row":{"columns":["8b6eae59","8b6eae59",37.3944,-122.0813]}},
{"row":{"columns":["4a7c7b41","4a7c7b41",37.4049,-122.0822]}},
{"row":{"columns":["4ab5cbad","4ab5cbad",37.3952,-122.0813]}},
{"row":{"columns":["8b6eae59","8b6eae59",37.3944,-122.0813]}},
{"row":{"columns":["4a7c7b41","4a7c7b41",37.4049,-122.0822]}},
{"row":{"columns":["4ab5cbad","4ab5cbad",37.3952,-122.0813]}},
{"row":{"columns":["8b6eae59","8b6eae59",37.3944,-122.0813]}},
{"row":{"columns":["4a7c7b41","4a7c7b41",37.4049,-122.0822]}},
{"row":{"columns":["4ab5cbad","4ab5cbad",37.3952,-122.0813]}},
{"row":{"columns":["8b6eae59","8b6eae59",37.3944,-122.0813]}},
{"row":{"columns":["4a7c7b41","4a7c7b41",37.4049,-122.0822]}},
{"row":{"columns":["4ab5cbad","4ab5cbad",37.3952,-122.0813]}},
{"row":{"columns":["8b6eae59","8b6eae59",37.3944,-122.0813]}},
{"row":{"columns":["4a7c7b41","4a7c7b41",37.4049,-122.0822]}},
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment