pgvector with citus could not determine data type of parameter $1
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
citus 11.3
pgvector 0.4.1
table:
CREATE TABLE public.test_vectors (
id bigserial primary key NOT NULL,
set_id character varying(255),
biz character varying(255),
pic character varying(255),
url character varying(700),
cls smallint,
loc character varying(64),
emb public.vector(256)
);
400 million data
set citus.shard_count=16;
SELECT create_distributed_table('test_vectors', 'id');
CREATE INDEX concurrently ON test_vectors USING ivfflat (emb vector_l2_ops) WITH (lists =3000);
SELECT id,pic,emb <-> ? as score FROM test_vectors ORDER BY emb <-> ? LIMIT ?
2023-07-22 15:54:19.468 CST 1552574 10.10.4.133(61306) test_rw test_db citus_internal gpid=10000870393 ERROR: could not determine data type of parameter $1
2023-07-22 15:54:19.468 CST 1552574 10.10.4.133(61306) test_rw test_db citus_internal gpid=10000870393 STATEMENT: EXPLAIN (ANALYZE FALSE, VERBOSE FALSE, COSTS TRUE, BUFFERS FALSE, WAL FALSE, TIMING FALSE, SUMMARY FALSE, FORMAT TEXT) SELECT id, pic, (emb OPERATOR(public.<->) '[-1.1893998,-0.34622306,-0.609328,0.40442777,-0.8460801,0.66174126,1.9525605,0.1889332,-0.37625992,1.3034844,-0.25307286,-0.43337464,-0.9519192,2.4657252,0.3203187,-0.562115,1.850466,-0.08794359,-0.89797455,-0.7653946,0.3541695,-1.0330834,0.19742182,-1.2364742,-0.024869706,1.934728,0.48434785,0.29349166,-0.8010251,0.45409697,-0.81996906,1.4666,-0.15344587,-0.19700336,1.3978295,-2.1481507,-1.3831365,-0.18521146,-0.40225434,-0.74266034,-1.8603404,-1.1065743,-0.78424865,2.0686784,0.39909637,0.8812663,-0.34561053,0.12338272,1.5342269,-1.1849447,-1.1660718,1.7402958,0.72690743,1.1411679,0.67448235,-0.3290782,-0.6835719,-0.36655194,-1.0928777,-0.05261419,-0.24782977,0.79175246,-0.64336604,-0.118650265,-0.6042613,-0.60065556,-0.35889402,-1.3511137,-0.42719293,1.3007776,1.0917344,-1.7651798,-0.380116,1.4087954,-0.2875197,1.151519,0.6113933,0.65364265,1.314457,-0.750805,1.0817913,-0.16276374,1.3207716,0.9150789,-0.9169475,-0.04400392,-0.26954338,1.9268079,0.8518603,0.384836,0.6033045,-0.8788716,-0.059788182,0.46429944,-0.92284477,-1.6432097,-0.81268483,1.1733625,0.8333506,0.36396402,-0.2834418,0.07503271,-0.72271764,1.693439,0.6770047,0.17277834,0.9274245,-0.5784056,-0.68560004,-0.7050826,0.78840846,0.0053467974,-2.667864,0.7187821,0.7508771,0.32933307,1.9373426,-1.3484668,0.29140344,-1.1887476,1.4634773,2.8748178,-0.40542933,0.55294925,0.27143636,0.44380033,-0.28102165,0.3383108,1.0436716,-1.2590662,0.49445084,-1.5377033,-0.48323205,0.7684838,0.027586356,0.96842825,1.5458604,-1.043598,-2.172805,1.2075111,-0.06432064,-1.7168549,-1.6237634,1.7284849,0.19749312,0.06630958,-0.07124713,1.598366,0.32341835,1.7920147,-0.3502002,-0.25532547,-1.1919851,0.73669875,1.0183297,-0.9559959,0.47450328,-1.6003281,1.1129271,0.60521144,0.9704529,-0.88785785,-0.67660946,0.20401368,0.92732126,0.08722458,0.10555348,-0.6859503,-0.7557584,-0.108810365,-2.71555,0.1491059,-0.12171068,-0.030641569,-1.0116756,-1.7432405,-0.4139969,0.1765181,0.5421829,0.86813843,2.2830324,2.17602,-0.10845189,0.091021255,1.7028924,0.46342763,0.53423023,0.67004925,-0.6282963,1.5108258,-0.7545764,-0.81837195,1.2647028,-0.8021888,0.37020445,-0.9178703,1.67368,-0.57647717,1.2729746,-1.3862264,2.1543546,0.67479557,1.2835424,-0.8096215,-1.4355549,0.36489654,0.063405864,1.086749,-0.6910573,-1.8925982,-1.1237181,0.24876222,-0.9822031,0.42509264,1.6628625,-0.18003972,-0.82666886,-0.015131656,1.2386942,-2.1123972,2.184511,-0.08187582,-0.64686435,-0.9376162,-0.97856647,-0.30144575,0.34240258,0.48382488,1.1075871,1.0035895,1.3804704,-1.7912134,1.36866,-0.30897683,-0.21203333,-1.0295082,-0.10916523,0.21158496,0.6167335,0.43505692,0.033123527,-0.087190926,1.2089525,-1.6635786,-0.5368144,-1.0201524,-0.8941489,0.8359103,0.23625061,-1.6639335,1.2413968,0.30935875,-0.24340445,0.13668457,0.3654117,-0.3381225]'::public.vector) AS score, (emb OPERATOR(public.<->) '[-1.1893998,-0.34622306,-0.609328,0.40442777,-0.8460801,0.66174126,1.9525605,0.1889332,-0.37625992,1.3034844,-0.25307286,-0.43337464,-0.9519192,2.4657252,0.3203187,-0.562115,1.850466,-0.08794359,-0.89797455,-0.7653946,0.3541695,-1.0330834,0.19742182,-1.2364742,-0.024869706,1.934728,0.48434785,0.29349166,-0.8010251,0.45409697,-0.81996906,1.4666,-0.15344587,-0.19700336,1.3978295,-2.1481507,-1.3831365,-0.18521146,-0.40225434,-0.74266034,-1.8603404,-1.1065743,-0.78424865,2.0686784,0.39909637,0.8812663,-0.34561053,0.12338272,1.5342269,-1.1849447,-1.1660718,1.7402958,0.72690743,1.1411679,0.67448235,-0.3290782,-0.6835719,-0.36655194,-1.0928777,-0.05261419,-0.24782977,0.79175246,-0.64336604,-0.118650265,-0.6042613,-0.60065556,-0.35889402,-1.3511137,-0.42719293,1.3007776,1.0917344,-1.7651798,-0.380116,1.4087954,-0.2875197,1.151519,0.6113933,0.65364265,1.314457,-0.750805,1.0817913,-0.16276374,1.3207716,0.9150789,-0.9169475,-0.04400392,-0.26954338,1.9268079,0.8518603,0.384836,0.6033045,-0.8788716,-0.059788182,0.46429944,-0.92284477,-1.6432097,-0.81268483,1.1733625,0.8333506,0.36396402,-0.2834418,0.07503271,-0.72271764,1.693439,0.6770047,0.17277834,0.9274245,-0.5784056,-0.68560004,-0.7050826,0.78840846,0.0053467974,-2.667864,0.7187821,0.7508771,0.32933307,1.9373426,-1.3484668,0.29140344,-1.1887476,1.4634773,2.8748178,-0.40542933,0.55294925,0.27143636,0.44380033,-0.28102165,0.3383108,1.0436716,-1.2590662,0.49445084,-1.5377033,-0.48323205,0.7684838,0.027586356,0.96842825,1.5458604,-1.043598,-2.172805,1.2075111,-0.06432064,-1.7168549,-1.6237634,1.7284849,0.19749312,0.06630958,-0.07124713,1.598366,0.32341835,1.7920147,-0.3502002,-0.25532547,-1.1919851,0.73669875,1.0183297,-0.9559959,0.47450328,-1.6003281,1.1129271,0.60521144,0.9704529,-0.88785785,-0.67660946,0.20401368,0.92732126,0.08722458,0.10555348,-0.6859503,-0.7557584,-0.108810365,-2.71555,0.1491059,-0.12171068,-0.030641569,-1.0116756,-1.7432405,-0.4139969,0.1765181,0.5421829,0.86813843,2.2830324,2.17602,-0.10845189,0.091021255,1.7028924,0.46342763,0.53423023,0.67004925,-0.6282963,1.5108258,-0.7545764,-0.81837195,1.2647028,-0.8021888,0.37020445,-0.9178703,1.67368,-0.57647717,1.2729746,-1.3862264,2.1543546,0.67479557,1.2835424,-0.8096215,-1.4355549,0.36489654,0.063405864,1.086749,-0.6910573,-1.8925982,-1.1237181,0.24876222,-0.9822031,0.42509264,1.6628625,-0.18003972,-0.82666886,-0.015131656,1.2386942,-2.1123972,2.184511,-0.08187582,-0.64686435,-0.9376162,-0.97856647,-0.30144575,0.34240258,0.48382488,1.1075871,1.0035895,1.3804704,-1.7912134,1.36866,-0.30897683,-0.21203333,-1.0295082,-0.10916523,0.21158496,0.6167335,0.43505692,0.033123527,-0.087190926,1.2089525,-1.6635786,-0.5368144,-1.0201524,-0.8941489,0.8359103,0.23625061,-1.6639335,1.2413968,0.30935875,-0.24340445,0.13668457,0.3654117,-0.3381225]'::public.vector) AS worker_column_4 FROM public.test_vectors_102008 test_vectors WHERE true ORDER BY (emb OPERATOR(public.<->) '[-1.1893998,-0.34622306,-0.609328,0.40442777,-0.8460801,0.66174126,1.9525605,0.1889332,-0.37625992,1.3034844,-0.25307286,-0.43337464,-0.9519192,2.4657252,0.3203187,-0.562115,1.850466,-0.08794359,-0.89797455,-0.7653946,0.3541695,-1.0330834,0.19742182,-1.2364742,-0.024869706,1.934728,0.48434785,0.29349166,-0.8010251,0.45409697,-0.81996906,1.4666,-0.15344587,-0.19700336,1.3978295,-2.1481507,-1.3831365,-0.18521146,-0.40225434,-0.74266034,-1.8603404,-1.1065743,-0.78424865,2.0686784,0.39909637,0.8812663,-0.34561053,0.12338272,1.5342269,-1.1849447,-1.1660718,1.7402958,0.72690743,1.1411679,0.67448235,-0.3290782,-0.6835719,-0.36655194,-1.0928777,-0.05261419,-0.24782977,0.79175246,-0.64336604,-0.118650265,-0.6042613,-0.60065556,-0.35889402,-1.3511137,-0.42719293,1.3007776,1.0917344,-1.7651798,-0.380116,1.4087954,-0.2875197,1.151519,0.6113933,0.65364265,1.314457,-0.750805,1.0817913,-0.16276374,1.3207716,0.9150789,-0.9169475,-0.04400392,-0.26954338,1.9268079,0.8518603,0.384836,0.6033045,-0.8788716,-0.059788182,0.46429944,-0.92284477,-1.6432097,-0.81268483,1.1733625,0.8333506,0.36396402,-0.2834418,0.07503271,-0.72271764,1.693439,0.6770047,0.17277834,0.9274245,-0.5784056,-0.68560004,-0.7050826,0.78840846,0.0053467974,-2.667864,0.7187821,0.7508771,0.32933307,1.9373426,-1.3484668,0.29140344,-1.1887476,1.4634773,2.8748178,-0.40542933,0.55294925,0.27143636,0.44380033,-0.28102165,0.3383108,1.0436716,-1.2590662,0.49445084,-1.5377033,-0.48323205,0.7684838,0.027586356,0.96842825,1.5458604,-1.043598,-2.172805,1.2075111,-0.06432064,-1.7168549,-1.6237634,1.7284849,0.19749312,0.06630958,-0.07124713,1.598366,0.32341835,1.7920147,-0.3502002,-0.25532547,-1.1919851,0.73669875,1.0183297,-0.9559959,0.47450328,-1.6003281,1.1129271,0.60521144,0.9704529,-0.88785785,-0.67660946,0.20401368,0.92732126,0.08722458,0.10555348,-0.6859503,-0.7557584,-0.108810365,-2.71555,0.1491059,-0.12171068,-0.030641569,-1.0116756,-1.7432405,-0.4139969,0.1765181,0.5421829,0.86813843,2.2830324,2.17602,-0.10845189,0.091021255,1.7028924,0.46342763,0.53423023,0.67004925,-0.6282963,1.5108258,-0.7545764,-0.81837195,1.2647028,-0.8021888,0.37020445,-0.9178703,1.67368,-0.57647717,1.2729746,-1.3862264,2.1543546,0.67479557,1.2835424,-0.8096215,-1.4355549,0.36489654,0.063405864,1.086749,-0.6910573,-1.8925982,-1.1237181,0.24876222,-0.9822031,0.42509264,1.6628625,-0.18003972,-0.82666886,-0.015131656,1.2386942,-2.1123972,2.184511,-0.08187582,-0.64686435,-0.9376162,-0.97856647,-0.30144575,0.34240258,0.48382488,1.1075871,1.0035895,1.3804704,-1.7912134,1.36866,-0.30897683,-0.21203333,-1.0295082,-0.10916523,0.21158496,0.6167335,0.43505692,0.033123527,-0.087190926,1.2089525,-1.6635786,-0.5368144,-1.0201524,-0.8941489,0.8359103,0.23625061,-1.6639335,1.2413968,0.30935875,-0.24340445,0.13668457,0.3654117,-0.3381225]'::public.vector) LIMIT '100'::bigint
Contributor guide
Assessment
This issue has not been assessed yet.