Csaba Ringhofer created IMPALA-13851:
----------------------------------------
Summary: Add geospatial expression rewrites for lat/lon coded
points
Key: IMPALA-13851
URL: https://issues.apache.org/jira/browse/IMPALA-13851
Project: IMPALA
Issue Type: Improvement
Components: Frontend
Reporter: Csaba Ringhofer
It is a common (and currently the most efficient) way to store point data as
double x/double y pairs instead of a single geometry (BINARY) column.
For predicates where these points must intersect a complex geometry it can be a
useful optimization to prefilter x/y columns directly with the bounding rect of
the complex geometry in addittiton to running the st_ predicate. An example:
WHERE st_contains(<const_geometry>, st_point(x,y))
can be rewritten as:
WHERE st_contains(<const_geometry>, st_point(x,y))
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
