[jira] [Created] (IMPALA-13851) Add geospatial expression rewrites for lat/lon coded points

["Csaba Ringhofer (Jira)" <ji...@apache.org>]

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: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org