Any queries do not work on tables which are distributed on columns that does not have any default op class (ie:json, point). The error message is: "cache lookup failed for opclass 0"
Open
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
Any queries do not work on tables which are distributed on columns that does not have any default op class (ie:json, point). The error message is: "cache lookup failed for opclass 0"
Contributor guide
Research direction
No file, test, or entry point is named. Start by reproducing a query on a distributed table using a json or point distribution column, then trace the PostgreSQL/Citus handling of columns without a default operator class. Done means such queries execute without the “cache lookup failed for opclass 0” error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- c, postgresql, sql
- Domain
- databases, distributed-systems
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100