Skip to content

Missing images when vector neighbors query #3722

@lekmaneb

Description

@lekmaneb

Hi,

Query:

SELECT 
    distance AS distance,
    `record`.out('embb')[0].asRID() AS rid
FROM (
    SELECT expand( vectorNeighbors('IMAGE_EMBEDDING[vector]', [-0.3439592719078064, 0.8689714670181274, -0.07070887088775635, -0.17598800361156464, 0.2103438526391983, -0.005513310432434082, -0.2633509933948517, 0.05464223399758339, -0.2979792356491089, 0.5492081642150879, 0.2713794708251953, -0.11183928698301315, 0.31026020646095276, 0.6625640392303467, -0.0129319429397583, 0.8724806308746338, -0.3895851969718933, -0.2665085196495056, 0.5776162147521973, 0.13952350616455078, -0.3825160264968872, -0.8105723857879639, -0.21816542744636536, -0.23582729697227478, 0.23476570844650269, -0.44949907064437866, -0.5908327102661133, -0.12507548928260803, 0.1574351191520691, -0.04480357468128204, 0.8365467190742493, -0.010131865739822388, -0.08627051115036011, 0.040800631046295166, -0.36013951897621155, 0.14764389395713806, 0.3693684935569763, -0.18450406193733215, -0.5863384008407593, 0.36368328332901, -0.20553618669509888, -0.1522054672241211, -0.28659185767173767, -0.4076916575431824, 0.014624863862991333, -0.12073357403278351, -0.12492595613002777, -0.4102570414543152, -0.3618227243423462, 0.5658597946166992, 0.08592881262302399, 0.565794825553894, 0.23902127146720886, -0.32276299595832825, 0.03685140609741211, -0.12058491259813309, 0.06806203722953796, 0.6361866593360901, 0.08728128671646118, 0.3504260778427124, 0.18662318587303162, 0.41685426235198975, -0.0706598162651062, -0.25484034419059753, 0.6421497464179993, 0.06695395708084106, -0.2624000310897827, -0.5039805769920349, -0.16406701505184174, -0.3363783359527588, -0.9284369945526123, -0.1410328596830368, 0.3969174027442932, -0.6447762846946716, 0.06784048676490784, 0.24071049690246582, 0.2523535192012787, 0.8186347484588623, -0.1212935820221901, 0.16107475757598877, 0.4184904396533966, -0.33500492572784424, 0.034971773624420166, 0.3398829400539398, 0.03839629888534546, -0.5781883001327515, 0.09188501536846161, 1.4869085550308228, -0.3493293523788452, 0.2666727304458618, -1.1138700246810913, 0.14735069870948792, -0.14360520243644714, -0.7410010695457458, 0.5046179890632629, 0.20676904916763306, -0.4086468815803528, 0.1142115443944931, -0.5140969753265381, -0.2146662473678589, -0.2100561559200287, 0.034808218479156494, 0.7444692850112915, -0.20178914070129395, -0.1770966649055481, -0.0654018223285675, 0.5535322427749634, 0.9413946866989136, -0.6097471117973328, -0.5820671319961548, -0.09098172187805176, 0.11930081248283386, 0.3748977780342102, 0.27461376786231995, 0.5580922365188599, 0.3853468894958496, 0.49474918842315674, 0.9330242872238159, 0.6065036058425903, -0.6974952220916748, 0.08012242615222931, -0.13995477557182312, 0.10647537559270859, 0.08994007110595703, 0.06401924788951874, -0.03977826237678528, 0.6210392713546753, 0.32715877890586853, 0.3029067814350128, -0.001236550509929657, 0.05021730065345764, 0.40403488278388977, 0.4335644245147705, 0.5382290482521057, 0.3462480306625366, 1.335766315460205, -0.17377915978431702, 1.0863754749298096, -0.1269313097000122, -0.22512897849082947, -0.20633772015571594, -0.20935368537902832, -0.21291905641555786, -0.4491814970970154, 0.4111410677433014, -0.43062639236450195, -0.6475576162338257, -0.34590181708335876, -0.2992151975631714, -0.16856321692466736, -0.20222806930541992, -0.4221881628036499, -0.03543583303689957, -0.2476702183485031, -0.14348886907100677, 0.02014636993408203, 0.1488613784313202, -0.29709678888320923, 0.7276175618171692, 0.23311927914619446, 0.08276331424713135, 0.27586472034454346, 0.558316171169281, -0.03144979476928711, 1.2579567432403564, 0.6414195895195007, 0.3900490999221802, 0.36004000902175903, 0.5993500351905823, -0.7176754474639893, 0.5423276424407959, -0.11086171865463257, -0.26742056012153625, 0.42801928520202637, -0.2993900179862976, -0.2527463734149933, -0.0560540109872818, -0.8175253868103027, -0.06480389833450317, -0.8415294289588928, -0.48212069272994995, -0.3116183280944824, -0.20689910650253296, 0.2836228609085083, -0.3356996774673462, 0.9835032820701599, -0.9860135912895203, 0.12640470266342163, -0.23634886741638184, -0.29899558424949646, -0.6699099540710449, -0.2444271743297577, -0.7414114475250244, -0.6617727279663086, -0.20781978964805603, -0.9038515090942383, 0.23538407683372498, -0.6330813765525818, 0.37558895349502563, -0.172737255692482, -0.1735468953847885, 0.6663916707038879, 0.05800133943557739, 0.29873839020729065, -0.33511725068092346, -0.383386492729187, -0.3275209069252014, 0.28694263100624084, 0.7009039521217346, 0.13838177919387817, -0.21556946635246277, -0.09448399394750595, -0.44749903678894043, -0.044922202825546265, -0.27993690967559814, -0.09524257481098175, 0.20497405529022217, -0.21993780136108398, 0.17792917788028717, -0.08557344973087311, 0.20082424581050873, -0.4024556279182434, 0.6586324572563171, -0.21048110723495483, -0.24985243380069733, 0.19094376266002655, 0.340758740901947, -0.327776700258255, -0.10424698889255524, -0.37495630979537964, 0.49140843749046326, 0.26810500025749207, -0.31610754132270813, -0.4836346209049225, -0.03322461247444153, -0.23778687417507172, -0.19667835533618927, -0.08057855069637299, 0.33828991651535034, -0.04756355285644531, -0.37149253487586975, 0.03060232102870941, -0.678799033164978, 0.7830412983894348, 0.33192306756973267, 1.1400525569915771, -0.1923978477716446, -0.0220012366771698, 0.15785570442676544, 0.26218393445014954, -0.08906105160713196, -0.4626118540763855, 0.014056779444217682, -0.22877703607082367, 0.016481034457683563, -0.08886627852916718, -0.3760700821876526, -0.3657726049423218, 0.5451086759567261, 0.4651079773902893, -0.6288659572601318, -0.17737534642219543, -0.06491134315729141, -0.8831807374954224, -0.6249670386314392, -0.3780745565891266, 0.9885119795799255, 0.19557484984397888, 0.21448704600334167, 0.45385682582855225, 0.1450820416212082, 0.27432432770729065, -0.18540053069591522, -0.2525932192802429, 0.11184674501419067, -0.4773105978965759, 0.38399070501327515, 0.3232077658176422, -0.03177914023399353, 0.23298804461956024, 0.14560675621032715, -0.053430765867233276, -0.5174142122268677, 0.2054164856672287, -0.17147168517112732, -0.6399428844451904, -0.145906001329422, -0.23409633338451385, -0.7932881116867065, -0.08821205794811249, -0.5815083980560303, -0.30545201897621155, 0.1112251877784729, 0.1147674173116684, 0.18420185148715973, 0.2379869520664215, -0.47951602935791016, -0.13272301852703094, 0.2913955748081207, 0.0049591027200222015, 0.06059814989566803, 0.14851734042167664, 0.2133789360523224, 0.31326210498809814, 0.8889416456222534, -0.1924450397491455, -0.4263158440589905, -0.47573092579841614, -0.12449038028717041, -0.5007845163345337, -0.47632163763046265, -0.4691007137298584, 0.5776649713516235, 0.46865105628967285, -1.0736262798309326, -0.22147798538208008, -6.227913856506348, 0.741277813911438, -0.060939475893974304, -0.22666244208812714, 0.11847324669361115, 0.3279620409011841, -0.019428767263889313, -0.452764630317688, -0.3621848225593567, -0.2037816047668457, -0.717634916305542, 0.6255617141723633, -0.14013999700546265, 0.3386109471321106, 0.6148892641067505, -0.08003485202789307, 0.5097681283950806, -0.38811686635017395, -0.13992184400558472, 0.3639049530029297, -0.004992693662643433, 0.31880903244018555, 0.15375888347625732, -1.0495821237564087, 0.1976223886013031, 0.15872883796691895, -0.11203157901763916, 0.35668662190437317, 0.2615744471549988, 0.1695818454027176, -0.044191472232341766, -0.39627909660339355, 0.2758823037147522, 0.08519972860813141, -0.09996507316827774, 0.20120221376419067, 0.06060981750488281, 0.015388384461402893, -0.03387872874736786, -0.05836831033229828, 0.7630171179771423, -0.3747327923774719, -0.0310676172375679, 0.1389344185590744, 0.6988417506217957, 0.004194468259811401, -0.10019922256469727, -0.46107351779937744, -0.1776791661977768, -0.3210645020008087, 0.28418922424316406, -0.2036425769329071, -0.330485075712204, -0.658820390701294, 0.4165673851966858, 0.08596349507570267, 0.18235830962657928, -0.4919544458389282, 0.2646445333957672, -0.28652867674827576, 0.050786323845386505, -0.13455183804035187, 0.6348673701286316, -0.822406530380249, 0.21566417813301086, -0.01952836662530899, -0.12376944720745087, 0.41698580980300903, 0.08577807247638702, -0.941198468208313, -0.1374581903219223, -0.17526428401470184, -0.12310579419136047, -0.27738404273986816, -0.22818370163440704, -0.004416629672050476, 0.08922682702541351, -0.001139819622039795, -0.09950703382492065, -0.5845205783843994, -0.05858907848596573, -0.27399981021881104, 0.048975735902786255, -0.2885873317718506, -0.23948810994625092, 0.06867020577192307, 0.578123927116394, -0.3231275677680969, -0.3601946532726288, -0.29070812463760376, 0.3940027356147766, 0.055019259452819824, 0.0093458890914917, -0.020400241017341614, 0.14541417360305786, 0.2117750197649002, 0.36193716526031494, -1.0289655923843384, -0.778938889503479, -0.1455729901790619, 0.2703617215156555, 0.17728549242019653, -0.1313120424747467, -0.292472243309021, -0.15390509366989136, -0.0018446296453475952, -0.09058815240859985, 0.23537345230579376, 0.13938018679618835, 0.010493919253349304, -0.002329498529434204, -0.11675996333360672, 0.28776904940605164, -0.2688046395778656, -0.23687997460365295, 0.490190327167511, 0.1128656417131424, -0.009805232286453247, 0.06712706387042999, -0.5148985385894775, 0.15053623914718628, 0.15762484073638916, -0.5091781616210938, -0.7204508781433105, 5.502152442932129, 0.010160401463508606, 0.35550254583358765, 0.4338251054286957, 0.16813890635967255, 0.17268052697181702, -0.33544883131980896, 0.5874345898628235, 0.24016499519348145, 0.0021542347967624664, -0.09250754117965698, 0.5941398739814758, 0.7513722777366638, -0.22066913545131683, -0.5317343473434448, 0.39931297302246094, -0.15835100412368774, -0.12894141674041748, -0.6815187335014343, 0.1478239893913269, -0.11009523272514343, -0.3330119252204895, 0.31199637055397034, 0.8788061141967773, -0.7432130575180054, -0.5358655452728271, -0.1121794581413269, 0.29758480191230774, 0.5706663131713867, 0.2972185015678406, -0.14716191589832306, 0.4289906620979309, -0.5155995488166809, 0.24786368012428284, 0.16142171621322632, 0.118995800614357, 0.2921396791934967, -0.11585614085197449, -0.7136932611465454, 0.32431086897850037, 0.061599284410476685, -0.21554231643676758, 0.014309659600257874, 0.3441043198108673, 0.37539589405059814, -0.30689626932144165, 0.4297108054161072, 0.3837847113609314, -0.6008304357528687, -0.5796870589256287, 0.1194794625043869, -0.09868314862251282, -0.031751036643981934, 0.10549597442150116, -0.5957346558570862, -0.6077545881271362, -0.4626261591911316, 0.19891536235809326, 0.02813097834587097, -0.0557837188243866, -0.038988806307315826, 0.13564975559711456, 0.12273389101028442, 0.7889106869697571, -0.18241459131240845, 0.04076465964317322, 0.30461758375167847, -0.005353584885597229, 0.062474340200424194, 0.06702752411365509, -0.8627201318740845, -0.217428058385849, 0.639191746711731, 0.5083045959472656, 0.35661572217941284, -0.08581937104463577, 0.2168886661529541, -0.17386868596076965, 0.5449098348617554, 0.024119675159454346, 0.7485440969467163, -0.10988068580627441, 0.11266733705997467, 0.22417306900024414, 0.6184589862823486, -0.07649365067481995, -0.0898699164390564, 0.0869532898068428, -0.7516775131225586, -0.2174905240535736, -0.07516790926456451, 0.18436050415039062, -0.04379831254482269, 0.07691548764705658, 0.16427654027938843, -0.0022492632269859314, -0.15555457770824432, 0.16488942503929138, -0.19438812136650085, -0.04297378659248352, -0.024153530597686768, 0.3000417649745941, -0.5152572393417358, 0.4069264531135559, 0.3619649410247803, 0.42315995693206787, -0.453255832195282, 0.22287648916244507, -0.44409066438674927, 0.15431934595108032, 0.15337783098220825, -0.5897214412689209, 0.4383906126022339, 0.40853339433670044, -0.10730103403329849, 0.3991272747516632, 0.018171116709709167, 0.23196929693222046, -0.5454457402229309, 0.1497841477394104, -0.9773745536804199, -0.19330182671546936, 0.5209312438964844, 0.08524797856807709, 0.5452251434326172, 0.6318149566650391, -0.016325831413269043, -0.14565886557102203, -0.18943028151988983, -0.1116102933883667, -0.11202460527420044, 0.11339336633682251, 0.17346665263175964, -0.27088701725006104, 0.10323905944824219, 0.07619649171829224, 0.2957322895526886, 0.23459865152835846, 0.7840715646743774, -0.15473367273807526, 0.005733862519264221, 0.4708624482154846, -0.08283361047506332, 0.1004224643111229, -0.1116819977760315, 0.6499497294425964, -0.624549388885498, 0.30323782563209534, -0.3916172981262207, -0.30161231756210327, -0.044566091150045395, 0.41105031967163086, 0.28991007804870605, 0.06283412873744965, 0.4213145971298218, 0.43974781036376953, 0.5535284876823425, 0.5916473269462585, -0.11760547757148743, -0.04174773395061493, -0.2897488474845886, 0.23138463497161865, 0.2327980101108551, -0.1233014389872551, -0.2739783525466919, -0.17664697766304016, 0.8750036358833313, -0.35280734300613403, -1.492159128189087, -0.15158313512802124, 0.10254336893558502, 0.22005851566791534, -0.09121215343475342, -0.08784258365631104, -0.16483767330646515, -1.0360952615737915, -0.03163060545921326, 0.42347458004951477, 0.7396206855773926, -0.03497820347547531, 0.7322121262550354, -0.5370216369628906, 0.19397315382957458, 0.4725240468978882, 0.0681043490767479, 0.17937909066677094, 0.001985684037208557, 0.22743436694145203, 0.0636504665017128, -0.20145860314369202, -0.5249719023704529, 0.46249639987945557, 0.1965489685535431, -0.7246929407119751, -0.14455139636993408, 0.6038461923599243, -0.10027820616960526, 0.5462239384651184, -0.186122328042984, -0.22815939784049988, -0.44288820028305054, 0.20495754480361938, 0.5379592180252075, 0.4518734812736511, 1.0470472574234009, 0.02965278923511505, -0.20469880104064941, 0.3697800040245056, -0.4273923933506012, 0.017052054405212402, -0.2170415222644806, -0.776897668838501, -0.32577764987945557, -0.1630266010761261, -0.24831542372703552, -0.26238420605659485, -0.265863835811615, -0.12293708324432373, -0.06076826900243759, 0.7216302156448364, -0.2625408470630646, 0.2832218408584595, -0.04880629479885101, 0.0933307558298111, 0.020623378455638885, -0.1872914731502533, -0.3256486654281616, 0.40975236892700195, -0.18170318007469177, 0.09300899505615234, 0.23112452030181885, -0.34494948387145996, 0.435444176197052, -0.29157981276512146, 0.2723769545555115, -0.04716622829437256, -0.22729209065437317, 0.4869919419288635, -0.3512362241744995, 0.05156078189611435, -0.3194379210472107, -0.09713064134120941, -0.40555286407470703, -0.054358020424842834, 0.8083945512771606, 0.7715775966644287, -0.3767358660697937, 0.6457363963127136, -0.22005917131900787, -0.2239246666431427, 0.21162305772304535, -0.2916091978549957, 0.24743491411209106, -0.2771029472351074, -0.053424157202243805, -0.8115078210830688, -0.440018892288208, -0.19674760103225708, -0.3992446959018707, -0.8728715181350708, -0.06080671399831772, -0.08043600618839264, -0.5070414543151855, -0.42907053232192993, -0.11290430277585983, -0.04375872015953064, -0.40224698185920715, -0.014667555689811707, 0.038599222898483276, -0.19796448945999146, -0.040547892451286316, 0.699669599533081, 0.005168437957763672, 0.6070209741592407, -0.3908332586288452, -0.16409090161323547, -0.07798305153846741, 0.22906950116157532, -0.0679522156715393, 0.027373790740966797, -0.33858370780944824, -0.07469302415847778, 0.47379568219184875, 0.18674960732460022, 0.7005369663238525, 1.170763611793518, -0.14304322004318237, -0.2139596790075302, -0.10239200294017792, 0.18566302955150604, -0.4894340932369232, 0.1422339826822281, -0.11191749572753906, -0.20199446380138397, -0.19012856483459473, 0.1133338212966919, 0.0489158034324646, 0.6693487167358398, -0.5157361030578613, 0.5905629396438599, 0.6759467124938965, -0.5872715711593628, -0.5401033163070679, -0.48865655064582825, 0.45145291090011597, 0.28772592544555664, 0.24416610598564148, 0.24400490522384644, 0.057284627109766006, -0.4967511296272278, -0.22366759181022644, -0.08600286394357681, 0.1787208467721939, 0.26199856400489807, 0.2695147395133972, -0.8311117887496948, 0.16165457665920258, -0.5131175518035889, 0.23000040650367737, 0.05697646737098694, 0.5379619002342224, 0.13269713521003723, 0.5559608936309814, 0.2657599449157715, -0.1969456970691681, -0.6963782906532288, 0.17113928496837616, -0.6900923252105713], 500) )
)

This returns 66 distances and ids. The problem is that i got 546 image embeddings in the database i'm using so it should return 500 distances.
But after rebuilding index using

REBUILD INDEX `IMAGE_EMBEDDING[vector]`

its working.

Backupdb : vrroummmmmm

Best regards,

Malek

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions