Alexander Belyak created IGNITE-19621:
-----------------------------------------
Summary: Slow query planning
Key: IGNITE-19621
URL: https://issues.apache.org/jira/browse/IGNITE-19621
Project: Ignite
Issue Type: Bug
Components: sql
Affects Versions: 3.0
Reporter: Alexander Belyak
Query from the TPC-H benchmark took 13 to 18 seconds to plan (try to execute on
an empty TPCH tables)
Problem query is:
{code:java}
select sum(case when nation = 'aaaa' then volume else 0 end) / sum(volume) as
mkt_share , o_year
from (
select floor(o_orderdate / (cast (365 as bigint) * 86400000)) as o_year,
l_extendedprice * (1 - l_discount) as volume,
n2.n_name as nation
from part, supplier, lineitem, orders, customer, nation n1, nation n2,
region
where p_partkey = l_partkey and s_suppkey = l_suppkey and l_orderkey =
o_orderkey and o_custkey = c_custkey and c_nationkey = n1.n_nationkey
and n1.n_regionkey = r_regionkey and r_name = 'rrr2' and s_nationkey =
n2.n_nationkey
and o_orderdate between 788904000000 and 851972400000
and p_type = 1111
) as all_nations
group by o_year
order by o_year
{code}
Second run took about 50ms (query cache works fine).
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
