[
https://issues.apache.org/jira/browse/CALCITE-1861?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16141946#comment-16141946
]
Julian Hyde commented on CALCITE-1861:
--------------------------------------
[~stefano.bortoli], I logged CALCITE-1968 to support a GEOMETRY data type and
the OpenGIS functions. Spatial index support will use those functions. The
initial goal is to accelerate a query that finds all points within a given
distance of a given point:
{code}
SELECT *, ST_Distance(ST_MakePoint(r.x, r.y), ST_MakePoint(100, 250))
FROM Restaurant AS r
WHERE ST_Distance(ST_MakePoint(r.x, r.y), ST_MakePoint(100, 250)) < 10
{code}
I need help on this. This work will not get completed if I am the sole resource.
> Spatial Indexes
> ---------------
>
> Key: CALCITE-1861
> URL: https://issues.apache.org/jira/browse/CALCITE-1861
> Project: Calcite
> Issue Type: Improvement
> Reporter: Atri Sharma
> Assignee: Julian Hyde
>
> Many Calcite users, like Phoenix and Flink can benefit from support of
> Spatial indexes.
> See:
> http://revenant.ca/www/postgis/workshop/indexing.html
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
