Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Citus bug for bingo extension #7906

Open
jank9201 opened this issue Feb 20, 2025 · 1 comment
Open

Citus bug for bingo extension #7906

jank9201 opened this issue Feb 20, 2025 · 1 comment
Assignees

Comments

@jank9201
Copy link

jank9201 commented Feb 20, 2025

When I Create table for structure, I got an Error Message, my SQL code is as follow:

CREATE TABLE struct(
id int not null,
binary_molcontent bytea,
primary key (id)
);
create index structIdx on struct using bingo_idx (binary_molcontent bingo.bmolecule);

all the above code was OK;but when I executed the following code:
SELECT create_distributed_table('struct', 'id', 'hash');
I got the error "table struct has dependency on unsupported object "operator class bingo.bmolecule for access method bingo_idx", bingo.bmolecule and bingo_idx are from bingo extension, which can be used in standalone postgresql well
the detailed definition of bmolecule is

CREATE OPERATOR CLASS bmolecule
FOR TYPE bytea USING bingo_idx
AS
        OPERATOR        1       public.@ (bytea, sub),
        OPERATOR        2       public.@ (bytea, exact),
        OPERATOR        3       public.@ (bytea, smarts),
        OPERATOR        4       public.@ (bytea, gross),
        OPERATOR        5       public.< (bytea, mass),
        OPERATOR        6       public.> (bytea, mass),
        OPERATOR        7       public.@ (bytea, sim),
        FUNCTION	1	matchSub(bytea, sub),
        FUNCTION	2	matchExact(bytea, exact),
        FUNCTION	3	matchSmarts(bytea, smarts),
        FUNCTION	4	matchGross(bytea, gross),
        FUNCTION	5	_match_mass_less(bytea, mass),
        FUNCTION	6	_match_mass_great(bytea, mass),
        FUNCTION	7	matchSim(bytea, sim);

OS System CentOS 7 2009
Postgresql Version 15.10
Citus Version: 12.1.4
bingo extension version :1.28.0

@jank9201
Copy link
Author

Hi, ihalatci
thanks your labeling, here is the more information about bingo extension:
the documentation of how to use and install is at the site https://lifescience.opensource.epam.com/bingo/bingo-postgres.html,
the source code is at site https://github.com/epam/Indigo

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants