[
https://issues.apache.org/jira/browse/CALCITE-1861?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16070512#comment-16070512
]
Julian Hyde commented on CALCITE-1861:
--------------------------------------
Yes. Use a simple table {{t (id, x, y, h)}} with a constraint that {{h =
toHilbert(x, y)}}, and transform a query {{select * from t where x between 3
and 5 and y between 0 and 1}} into something like {{select * from t where h
between ... and ... or h between ... and ...}}.
The rule will be similar to DateRangeRules, added in CALCITE-1334, in how it
maps between columns that are connected using a check constraint.
> 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)
