Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-7108

With statistics enabled TPCH 16 has two additional exchange operators

    XMLWordPrintableJSON

Details

    Description

      TPCH 16 with sf 100 runs 14% slower. Here is the query:

      select
        p.p_brand,
        p.p_type,
        p.p_size,
        count(distinct ps.ps_suppkey) as supplier_cnt
      from
        partsupp ps,
        part p
      where
        p.p_partkey = ps.ps_partkey
        and p.p_brand <> 'Brand#21'
        and p.p_type not like 'MEDIUM PLATED%'
        and p.p_size in (38, 2, 8, 31, 44, 5, 14, 24)
        and ps.ps_suppkey not in (
          select
            s.s_suppkey
          from
            supplier s
          where
            s.s_comment like '%Customer%Complaints%'
        )
      group by
        p.p_brand,
        p.p_type,
        p.p_size
      order by
        supplier_cnt desc,
        p.p_brand,
        p.p_type,
        p.p_size;
      

      Attachments

        Issue Links

          Activity

            People

              gparai Gautam Parai
              rhou Robert Hou
              Aman Sinha Aman Sinha
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: