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

Predicates are not always pushed to Kudu

    Details

      Description

      Predicates in some cases do not seem to be pushed to Kudu and are executed at the Impala scan node instead. Example from the TPC-H Q6:

      # Q6 - Forecasting Revenue Change Query
      select
       round(sum(l_extendedprice * l_discount), 2) as revenue
      from
        tpch_kudu.lineitem
      where
        l_shipdate >= '1994-01-01'
        and l_shipdate < '1995-01-01'
        and l_discount between 0.05 and 0.07
        and l_quantity < 24
      ---- PLAN
      01:AGGREGATE [FINALIZE]
      |  output: sum(l_extendedprice * l_discount)
      |
      00:SCAN KUDU [tpch_kudu.lineitem]
         *predicates: l_quantity < 24, l_shipdate < '1995-01-01'*
         kudu predicates: l_discount >= 0.05, l_discount <= 0.07, l_shipdate >= '1994-01-01'
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                mjacobs Matthew Jacobs
                Reporter:
                dtsirogiannis Dimitris Tsirogiannis
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: