-
Notifications
You must be signed in to change notification settings - Fork 743
Closed
Labels
area/runtimeYDB runtime issuesYDB runtime issuescompatibilityenv:acceptanceIssues found in acceptance testing before deploymentIssues found in acceptance testing before deploymentprio:medstable-25-1-1
Description
TPC-H (row) scale 1 with mixed cluster 24-4 + 25-1
7:
iteration 0
<main>: Error: [Compute spilling][TEvError] Spilling Service not started
<main>: Error: Query invalidated on scheme/internal error during Data execution, code: 2019
Query text:
$z1_12 = 1;
$n = select n_name, n_nationkey from `olap_yatests/tpch/s1/nation` as n
where n_name = 'FRANCE' or n_name = 'GERMANY';
$l = select
l_orderkey, l_suppkey,
DateTime::GetYear(cast(l_shipdate as timestamp)) as l_year,
l_extendedprice * ($z1_12 - l_discount) as volume
from
`olap_yatests/tpch/s1/lineitem` as l
where
l.l_shipdate between Date('1995-01-01') and Date('1996-12-31');
$j1 = select
n_name as supp_nation,
s_suppkey
from
`olap_yatests/tpch/s1/supplier` as supplier
join
$n as n1
on
supplier.s_nationkey = n1.n_nationkey;
$j2 = select
n_name as cust_nation,
c_custkey
from
`olap_yatests/tpch/s1/customer` as customer
join
$n as n2
on
customer.c_nationkey = n2.n_nationkey;
$j3 = select
cust_nation, o_orderkey
from
`olap_yatests/tpch/s1/orders` as orders
join
$j2 as customer
on
orders.o_custkey = customer.c_custkey;
$j4 = select
cust_nation,
l_orderkey, l_suppkey,
l_year,
volume
from
$l as lineitem
join
$j3 as orders
on
lineitem.l_orderkey = orders.o_orderkey;
$j5 = select
supp_nation, cust_nation,
l_year, volume
from
$j4 as lineitem
join
$j1 as supplier
on
lineitem.l_suppkey = supplier.s_suppkey
where (supp_nation = 'FRANCE' and cust_nation = 'GERMANY')
OR (supp_nation = 'GERMANY' and cust_nation = 'FRANCE');
select
supp_nation,
cust_nation,
l_year,
sum(volume) as revenue
from
$j5 as shipping
group by
supp_nation,
cust_nation,
l_year
order by
supp_nation,
cust_nation,
l_year;
Without mixed cluster (24-4 only or 25-1 only works fine)
Metadata
Metadata
Assignees
Labels
area/runtimeYDB runtime issuesYDB runtime issuescompatibilityenv:acceptanceIssues found in acceptance testing before deploymentIssues found in acceptance testing before deploymentprio:medstable-25-1-1