Sheng Wang created IMPALA-10969:
-----------------------------------

             Summary: 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


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