
[K
[K
[K
[K
[KQuery17:
iteration 1
<main>: Error: Type annotation, code: 1030
    <main>:9:1: Error: At function: KiReadTable!
        <main>:9:1: Error: Cannot find table 'db.[/local/test_db/upload/tpch/s0.1/lineitem]' because it does not exist or you do not have access permissions. Please check correctness of table path and user permissions., code: 2003

Query text:
$z7_35 = 7.;
$z0_2_12 = 0.2;
$p = select p_partkey from `upload/tpch/s0.1/part`
where
    p_brand = 'Brand#23'
    and p_container = 'MED BOX'
;
$threshold = (
select
    $z0_2_12 * avg(l_quantity) as threshold,
    l.l_partkey as l_partkey
from
    `upload/tpch/s0.1/lineitem` as l
left semi join
    $p as p
on  
    p.p_partkey = l.l_partkey
group by
    l.l_partkey
);
$l = select l.l_partkey as l_partkey, l.l_quantity as l_quantity, l.l_extendedprice as l_extendedprice
from
    `upload/tpch/s0.1/lineitem` as l
join
    $p as p
on  
    p.p_partkey = l.l_partkey;
select
    sum(l.l_extendedprice) / $z7_35 as avg_yearly
from
    $l as l
join
    $threshold as t
on  
    t.l_partkey = l.l_partkey
where
    l.l_quantity < t.threshold;


[KQuery17:
iteration 2
<main>: Error: Type annotation, code: 1030
    <main>:9:1: Error: At function: KiReadTable!
        <main>:9:1: Error: Cannot find table 'db.[/local/test_db/upload/tpch/s0.1/lineitem]' because it does not exist or you do not have access permissions. Please check correctness of table path and user permissions., code: 2003

Query text:
$z7_35 = 7.;
$z0_2_12 = 0.2;
$p = select p_partkey from `upload/tpch/s0.1/part`
where
    p_brand = 'Brand#23'
    and p_container = 'MED BOX'
;
$threshold = (
select
    $z0_2_12 * avg(l_quantity) as threshold,
    l.l_partkey as l_partkey
from
    `upload/tpch/s0.1/lineitem` as l
left semi join
    $p as p
on  
    p.p_partkey = l.l_partkey
group by
    l.l_partkey
);
$l = select l.l_partkey as l_partkey, l.l_quantity as l_quantity, l.l_extendedprice as l_extendedprice
from
    `upload/tpch/s0.1/lineitem` as l
join
    $p as p
on  
    p.p_partkey = l.l_partkey;
select
    sum(l.l_extendedprice) / $z7_35 as avg_yearly
from
    $l as l
join
    $threshold as t
on  
    t.l_partkey = l.l_partkey
where
    l.l_quantity < t.threshold;

