You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Sheng Wang (Jira)" <ji...@apache.org> on 2021/10/14 02:34:00 UTC
[jira] [Comment Edited] (IMPALA-10969) Remove unnecessary cast in
query
[ https://issues.apache.org/jira/browse/IMPALA-10969?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17428568#comment-17428568 ]
Sheng Wang edited comment on IMPALA-10969 at 10/14/21, 2:33 AM:
----------------------------------------------------------------
Hi [~stigahuang], how do you think of this feature? If ok, I would like to contribute to this JIRA.
was (Author: skyyws):
Hi [~stigahuang], how do you think of this feature?
> 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)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org