citusdata / citusdata/citus

"ERROR: cache lookup failed for type 0" when joining two append tables

Open
#3,086 1 comment 1 reaction 0 assignees View on GitHub
bug
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

I have two workers, these tables and data:
```sql
CREATE TABLE part
(
p_partkey INTEGER not null,
p_name VARCHAR(55) not null,
p_mfgr CHAR(25) not null,
p_brand CHAR(10) not null,
p_type VARCHAR(25) not null,
p_size INTEGER not null,
p_container CHAR(10) not null,
p_retailprice DOUBLE PRECISION not null,
p_comment VARCHAR(23) not null
);

select create_distributed_table('part', 'p_partkey', 'append');

CREATE TABLE lineitem
(
l_orderkey BIGINT not null,
l_partkey INTEGER not null,
l_suppkey INTEGER not null,
l_linenumber INTEGER not null,
l_quantity DOUBLE PRECISION not null,
l_extendedprice DOUBLE PRECISION not null,
l_discount DOUBLE PRECISION not null,
l_tax DOUBLE PRECISION not null,
l_returnflag CHAR(1) not null,
l_linestatus CHAR(1) not null,
l_shipdate DATE not null,
l_commitdate DATE not null,
l_receiptdate DATE not null,
l_shipinstruct CHAR(25) not null,
l_shipmode CHAR(10) not null,
l_comment VARCHAR(44) not null
);

select create_distributed_table('lineitem', 'l_orderkey', 'append');
```
`lineitem.tbl`:
```
1|155190|7706|1|17|21168.23|0.04|0.02|N|O|1996-03-13|1996-02-12|1996-03-22|DELIVER IN PERSON|TRUCK|egular courts above the
1|67310|7311|2|36|45983.16|0.09|0.06|N|O|1996-04-12|1996-02-28|1996-04-20|TAKE BACK RETURN|MAIL|ly final dependencies: slyly bold
```

When I run this query, I get the error:
```sql
psql> SELECT * FROM part, lineitem WHERE p_partkey = l_partkey;
ERROR: cache lookup failed for type 0
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.