[
https://issues.apache.org/jira/browse/CALCITE-1861?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17180766#comment-17180766
]
Julian Hyde commented on CALCITE-1861:
--------------------------------------
Sounds good. I recommend that [~txy2539] physically sorts the table on the
Hilbert value (or include several extra columns in the index). The range will
still be a significant fraction of the table (due to false positives) so you
want to avoid random I/O.
> Spatial index, based on Hilbert space-filling curve
> ---------------------------------------------------
>
> Key: CALCITE-1861
> URL: https://issues.apache.org/jira/browse/CALCITE-1861
> Project: Calcite
> Issue Type: Improvement
> Components: spatial
> Reporter: Atri Sharma
> Assignee: Julian Hyde
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.26.0
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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
(v8.3.4#803005)
