[ 
https://issues.apache.org/jira/browse/IMPALA-10969?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Quanlong Huang resolved IMPALA-10969.
-------------------------------------
    Resolution: Duplicate

Thanks for reporting this! I think this duplicates IMPALA-10836. We can discuss 
there.

> Remove unnecessary cast in query
> --------------------------------
>
>                 Key: IMPALA-10969
>                 URL: https://issues.apache.org/jira/browse/IMPALA-10969
>             Project: IMPALA
>          Issue Type: Improvement
>          Components: Frontend
>    Affects Versions: Impala 4.0.0
>            Reporter: Sheng Wang
>            Priority: Minor
>
> In some queries, cast target data type is same as column origin data type. We 
> can remove these unnecessary cast by adding a new expr rewrite rule. There 
> are two benefits:
>  # For non partition columns, remove these unnecessary cast will improve 
> query performance;
>  # If we visit kudu table, predicates with cast cannot push down to Kudu 
> side, such as 'cast(a as int) > 100', but ' a > 100' can push down to kudu 
> side. We can remove this cast if a is INT type.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to