Alexander Belyak created IGNITE-19813:
-----------------------------------------
Summary: Unable to execute TPCH Q2 query
Key: IGNITE-19813
URL: https://issues.apache.org/jira/browse/IGNITE-19813
Project: Ignite
Issue Type: Bug
Components: sql
Affects Versions: 3.0
Reporter: Alexander Belyak
Executing for standatd TPC-H query Q2 took few minutes. Not work neither as
Plain test nor PreparedStatement
{code:java}
SELECT
s_acctbal,
s_name,
n_name,
p_partkey,
p_mfgr,
s_address,
s_phone,
s_comment
FROM
part,
supplier,
partsupp,
nation,
region
WHERE
p_partkey = ps_partkey
AND s_suppkey = ps_suppkey
AND p_size = 12
AND p_type LIKE '%NICKEL'
AND s_nationkey = n_nationkey
AND n_regionkey = r_regionkey
AND r_name = 'AFRICA'
AND ps_supplycost =
(
SELECT
MIN(ps_supplycost)
FROM
partsupp,
supplier,
nation,
region
WHERE
p_partkey = ps_partkey
AND s_suppkey = ps_suppkey
AND s_nationkey = n_nationkey
AND n_regionkey = r_regionkey
AND r_name = 'AFRICA'
)
ORDER BY
s_acctbal DESC,
n_name,
s_name,
p_partkey LIMIT 100 {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
