[
https://issues.apache.org/jira/browse/IGNITE-19813?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yury Gerzhedovich resolved IGNITE-19813.
----------------------------------------
Resolution: Cannot Reproduce
Seems has been fixed under IGNITE-20714
> 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
> Priority: Major
> Labels: ignite-3
>
> 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)
