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

Query with analytic function doesn't need to materialize the predicate pushed down to kudu

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • Impala 4.0.0
    • Impala 4.0.0
    • Frontend
    • None

    Description

      The query with analytic function doesn't need to materialize the predicate pushed down to kudu.

      E.g.

      select min(n_nationkey) over(partition by n_regionkey) from tpch_kudu.nation t1 where t1.n_name in ('ALGERIA', 'ARGENTINA');
      

      The plan

      PLAN-ROOT SINK
      |
      02:ANALYTIC
      |  functions: min(n_nationkey)
      |  partition by: n_regionkey
      |  row-size=25B cardinality=2
      |
      01:SORT
      |  order by: n_regionkey ASC NULLS LAST
      |  row-size=23B cardinality=2
      |
      00:SCAN KUDU [tpch_kudu.nation t1]
         kudu predicates: t1.n_name IN ('ALGERIA', 'ARGENTINA')
         row-size=27B cardinality=2
      

      We don't need to materialize the slot 'n_name'.

       

      Attachments

        Activity

          People

            xqhe Xianqing He
            xqhe Xianqing He
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: