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

Predicates with constant folded exprs don't get pushed to Kudu scans

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Won't Fix
    • Impala 2.8.0
    • Product Backlog
    • Frontend
    • ghx-label-3

    Description

      Predicates with expressions that get constant folded don't get pushed to Kudu scans even though they could be. E.g.:

      [localhost:21000] > explain select * from functional_kudu.alltypestiny where bigint_col < 1000 / 100;
      Query: explain select * from functional_kudu.alltypestiny where bigint_col < 1000 / 100
      +---------------------------------------------+
      | Explain String                              |
      +---------------------------------------------+
      | Per-Host Resource Reservation: Memory=0B    |
      | Per-Host Resource Estimates: Memory=10.00MB |
      | Codegen disabled by planner                 |
      |                                             |
      | PLAN-ROOT SINK                              |
      | |                                           |
      | 00:SCAN KUDU [functional_kudu.alltypestiny] |
      |    predicates: bigint_col < 10              |
      +---------------------------------------------+
      Fetched 8 row(s) in 0.08s
      [localhost:21000] > explain select * from functional_kudu.alltypestiny where bigint_col < 10;
      Query: explain select * from functional_kudu.alltypestiny where bigint_col < 10
      +---------------------------------------------+
      | Explain String                              |
      +---------------------------------------------+
      | Per-Host Resource Reservation: Memory=0B    |
      | Per-Host Resource Estimates: Memory=10.00MB |
      | Codegen disabled by planner                 |
      |                                             |
      | PLAN-ROOT SINK                              |
      | |                                           |
      | 00:SCAN KUDU [functional_kudu.alltypestiny] |
      |    kudu predicates: bigint_col < 10         |
      +---------------------------------------------+
      Fetched 8 row(s) in 0.05s
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            mjacobs Matthew Jacobs
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: