[
https://issues.apache.org/jira/browse/DRILL-7121?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Robert Hou updated DRILL-7121:
------------------------------
Summary: TPCH 4 takes longer when Statistics is disabled. (was: TPCH 4
takes longer)
> TPCH 4 takes longer when Statistics is disabled.
> ------------------------------------------------
>
> Key: DRILL-7121
> URL: https://issues.apache.org/jira/browse/DRILL-7121
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Affects Versions: 1.16.0
> Reporter: Robert Hou
> Assignee: Gautam Parai
> Priority: Blocker
> Fix For: 1.16.0
>
>
> Here is TPCH 4 with sf 100:
> {noformat}
> select
> o.o_orderpriority,
> count(*) as order_count
> from
> orders o
> where
> o.o_orderdate >= date '1996-10-01'
> and o.o_orderdate < date '1996-10-01' + interval '3' month
> and
> exists (
> select
> *
> from
> lineitem l
> where
> l.l_orderkey = o.o_orderkey
> and l.l_commitdate < l.l_receiptdate
> )
> group by
> o.o_orderpriority
> order by
> o.o_orderpriority;
> {noformat}
> The plan has changed when Statistics is disabled. A Hash Agg and a
> Broadcast Exchange have been added. These two operators expand the number of
> rows from the lineitem table from 137M to 9B rows. This forces the hash
> join to use 6GB of memory instead of 30 MB.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
