[ https://issues.apache.org/jira/browse/DRILL-7108?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Robert Hou closed DRILL-7108. ----------------------------- > With statistics enabled TPCH 16 has two additional exchange operators > --------------------------------------------------------------------- > > Key: DRILL-7108 > URL: https://issues.apache.org/jira/browse/DRILL-7108 > Project: Apache Drill > Issue Type: Bug > Components: Query Planning & Optimization > Affects Versions: 1.16.0 > Reporter: Robert Hou > Assignee: Gautam Parai > Priority: Major > Labels: ready-to-commit > Fix For: 1.16.0 > > > TPCH 16 with sf 100 runs 14% slower. Here is the query: > {noformat} > 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; > {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005)