Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-10969

Remove unnecessary cast in query

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Minor
    • Resolution: Duplicate
    • Impala 4.0.0
    • None
    • Frontend
    • None
    • ghx-label-2

    Description

      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:

      1. For non partition columns, remove these unnecessary cast will improve query performance;
      2. 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.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              skyyws Sheng Wang
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: