[
https://issues.apache.org/jira/browse/IMPALA-14577?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Csaba Ringhofer resolved IMPALA-14577.
--------------------------------------
Fix Version/s: Impala 5.0.0
Resolution: Done
> Try bounding rect check on x/y cols directly in st_point(x,y)
> -------------------------------------------------------------
>
> Key: IMPALA-14577
> URL: https://issues.apache.org/jira/browse/IMPALA-14577
> Project: IMPALA
> Issue Type: Sub-task
> Reporter: Csaba Ringhofer
> Assignee: Csaba Ringhofer
> Priority: Major
> Fix For: Impala 5.0.0
>
>
> Example:
> {code}
> st_intersect(CONST_GEOM, st_point(x, y))
> -> infer predicate:
> x >= st_minx(CONST_GEOM) AND y >= st_minx(CONST_GEOM) AND
> x <= st_maxx(CONST_GEOM) AND y <= st_maxy(CONST_GEOM) AND
> st_intersect(CONST_GEOM, st_point(x, y))
> {code}
> with IMPALA-14576 it would be also possible to do this by rewriting
> st_envIntersects:
> {code}
> st_intersect(CONST_GEOM, st_point(x, y))
> -> add st_envIntersects:
> st_envIntersects(CONST_GEOM, st_point(x, y)) AND
> st_intersect(CONST_GEOM, st_point(x, y))
> -> rewrite st_envIntersects
> x >= st_minx(CONST_GEOM) AND y >= st_minx(CONST_GEOM) AND
> x <= st_maxx(CONST_GEOM) AND y <= st_maxy(CONST_GEOM) AND
> st_intersect(CONST_GEOM, st_point(x, y))
> {code}
> Doing <= / >= on coordinate columns directly allows using min/max
> filtering, so bounding box check can be also done at file/page level.
> With IMPALA-14123 it also possible to ensure that these predicates are always
> pushed down to Iceberg.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
