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

Predicates are not always pushed to Kudu

    XMLWordPrintableJSON

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

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

              Dates

                Created:
                Updated:
                Resolved: