[jira] [Resolved] (IMPALA-14571) Increase "cost" of geospatial functions during planning

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

     [ 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)