{"action":"opened","issue":{"url":"https://api.github.com/repos/druid-io/druid/issues/5482","repository_url":"https://api.github.com/repos/druid-io/druid","labels_url":"https://api.github.com/repos/druid-io/druid/issues/5482/labels{/name}","comments_url":"https://api.github.com/repos/druid-io/druid/issues/5482/comments","events_url":"https://api.github.com/repos/druid-io/druid/issues/5482/events","html_url":"https://github.com/druid-io/druid/issues/5482","id":304849694,"number":5482,"title":"SQL: Support spatial filters","user":{"login":"gianm","id":1214075,"avatar_url":"https://avatars3.githubusercontent.com/u/1214075?v=4","gravatar_id":"","url":"https://api.github.com/users/gianm","html_url":"https://github.com/gianm","followers_url":"https://api.github.com/users/gianm/followers","following_url":"https://api.github.com/users/gianm/following{/other_user}","gists_url":"https://api.github.com/users/gianm/gists{/gist_id}","starred_url":"https://api.github.com/users/gianm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gianm/subscriptions","organizations_url":"https://api.github.com/users/gianm/orgs","repos_url":"https://api.github.com/users/gianm/repos","events_url":"https://api.github.com/users/gianm/events{/privacy}","received_events_url":"https://api.github.com/users/gianm/received_events","type":"User","site_admin":false},"labels":[{"id":690563172,"url":"https://api.github.com/repos/druid-io/druid/labels/Area%20-%20SQL","name":"Area - SQL","color":"fef2c0","default":false},{"id":17287687,"url":"https://api.github.com/repos/druid-io/druid/labels/Feature","name":"Feature","color":"2ceefb","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-03-13T16:54:35Z","updated_at":"2018-03-13T16:54:35Z","closed_at":null,"author_association":"OWNER","body":"Druid spatial filters currently support point-in-polygon and point-within-radius. If I'm reading the docs right, I think that means we could expose these in SQL using OpenGIS (https://calcite.apache.org/docs/spatial.html) functions ST_Intersects and ST_DWithin.\r\n\r\n- https://postgis.net/docs/ST_DWithin.html\r\n- https://postgis.net/docs/ST_Intersects.html"}}
{"actor":{"display_login":"gianm"}}