Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Won't Fix
-
Impala 2.8.0
-
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