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

Predicates are not always pushed to Kudu

Agile BoardAttach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment