[
https://issues.apache.org/jira/browse/IMPALA-14571?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Csaba Ringhofer resolved IMPALA-14571.
--------------------------------------
Fix Version/s: Impala 5.0.0
Resolution: Fixed
> Increase "cost" of geospatial functions during planning
> -------------------------------------------------------
>
> Key: IMPALA-14571
> URL: https://issues.apache.org/jira/browse/IMPALA-14571
> Project: IMPALA
> Issue Type: Sub-task
> Components: Frontend
> Reporter: Csaba Ringhofer
> Assignee: Csaba Ringhofer
> Priority: Major
> Fix For: Impala 5.0.0
>
>
> Example:
> select * from functional.binary_tbl
> where st_geomfromwkb(binary_col) is not null and sqrt(id) = 1;
> The planner considers the cost of both function calls's cost '10' and keeps
> evaluating st_geomfromwkb() first:
> https://github.com/apache/impala/blob/3ce0004c12f587dbc6ac6d7451b5f362d148d033/fe/src/main/java/org/apache/impala/analysis/Expr.java#L91
> This is generally a bad decision, as st_geomfromwkb() contains both a
> native->JVM call and the processing of WKB binary format.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
