citus icon indicating copy to clipboard operation
citus copied to clipboard

Citus bug for bingo extension

Open jank9201 opened this issue 10 months ago • 1 comments

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 avatar Feb 20 '25 02:02 jank9201

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

jank9201 avatar Feb 26 '25 01:02 jank9201