Skip to content

UNWIND , batch and vector, still getting Expected float array or ComparableVector as key for vector index, got class java.lang.String #3211

@ExtReMLapin

Description

@ExtReMLapin

Hello,

Seems to be similar to #3154 (same error)

Not sure which commit was reverted 😕

Query :

UNWIND $batch AS BatchEntry
MATCH (b:CHUNK) WHERE ID(b) = BatchEntry.destRID
CREATE (p:CHUNK_EMBEDDING {vector: BatchEntry.vector})
CREATE (p)-[:embb]->(b)        

Batch sample :

{"batch": [{"vector": [-0.01425933837890625, 0.016937255859375, -0.037384033203125, -0.0006160736083984375, 7.736682891845703e-05, -0.054443359375, 0.0250244140625, 0.034576416015625, -0.021942138671875, 0.0187530517578125, -0.0009484291076660156, 0.01401519775390625, -0.0269775390625, 0.0217132568359375, 0.0184783935546875, 0.027130126953125, -0.00872039794921875, -0.0010538101196289062, 0.01274871826171875, -0.03857421875, -0.045440673828125, -0.0200958251953125, 0.001613616943359375, 0.0301513671875, 0.0159912109375, 0.032989501953125, 0.0199432373046875, -0.0171051025390625, 0.0029201507568359375, 0.025604248046875, -0.05157470703125, 0.010650634765625, -0.047760009765625, -0.0307464599609375, 0.0114593505859375, 0.011627197265625, 0.028289794921875, 0.0161285400390625, -0.0228271484375, 0.0030040740966796875, 0.034515380859375, -0.007053375244140625, 0.007183074951171875, -0.0247039794921875, 0.05230712890625, -0.0305938720703125, -0.036773681640625, -0.0238494873046875, 0.0020751953125, -0.079345703125, -0.01230621337890625, -0.0190277099609375, -0.01020050048828125, 0.00855255126953125, 0.061187744140625, 0.0085296630859375, -0.03607177734375, -0.01062774658203125, -0.084716796875, 0.03192138671875, -0.02081298828125, 0.021392822265625, -0.005794525146484375, -0.0286865234375, 0.033447265625, 0.039520263671875, 0.0036773681640625, -0.0129547119140625, -0.00943756103515625, -0.00875091552734375, 0.00641632080078125, 0.04217529296875, -0.0313720703125, -0.07403564453125, -0.060516357421875, -0.01100921630859375, 0.035736083984375, 0.01235198974609375, 0.03009033203125, -0.00902557373046875, -0.00820159912109375, -0.0204315185546875, -0.048583984375, 0.00782012939453125, -0.021881103515625, 5.53131103515625e-05, -0.0394287109375, 0.04962158203125, 0.012725830078125, -0.042266845703125, -0.047210693359375, -0.01392364501953125, -0.0273590087890625, -0.0246124267578125, -0.0004703998565673828, -0.01367950439453125, -0.05133056640625, 0.017852783203125, 0.016937255859375, -0.0017614364624023438, -0.0055694580078125, 0.0185089111328125, 0.0226898193359375, -0.0134735107421875, -0.0200958251953125, -0.038726806640625, -0.02606201171875, 0.01267242431640625, -0.0237579345703125, -0.027313232421875, -0.00530242919921875, 0.01312255859375, 0.0223541259765625, 0.0142822265625, -0.0285797119140625, 0.0014467239379882812, 0.0330810546875, -0.036285400390625, 0.0280914306640625, -0.0010623931884765625, -0.011077880859375, -0.0266265869140625, 0.0266571044921875, -0.0166015625, 0.002094268798828125, -0.0237274169921875, 0.0268707275390625, 0.0235137939453125, -0.0272216796875, 0.01320648193359375, 0.0117034912109375, -0.025299072265625, -0.06463623046875, 0.034027099609375, -0.07562255859375, -0.03131103515625, 0.0239105224609375, 0.0019006729125976562, -0.010833740234375, -0.034393310546875, 0.031463623046875, 0.0599365234375, -0.04876708984375, -0.00199127197265625, 0.015899658203125, 0.0229644775390625, 0.03887939453125, -0.006252288818359375, 0.010986328125, 0.036224365234375, 0.0161590576171875, 0.0196380615234375, 0.00708770751953125, 0.0304107666015625, 0.0074920654296875, 0.041473388671875, -0.01690673828125, 0.005767822265625, -0.07391357421875, 0.00051116943359375, 0.0097198486328125, 0.029632568359375, -0.00962066650390625, -0.00426483154296875, 0.0166168212890625, 0.01398468017578125, -0.03173828125, 0.00984954833984375, -0.020965576171875, 0.042449951171875, 0.04083251953125, -0.0030994415283203125, -0.0191192626953125, -0.03076171875, -0.004730224609375, 0.01549530029296875, 0.06512451171875, 0.0082550048828125, -0.03515625, -0.0540771484375, -0.053955078125, -0.000560760498046875, 0.0031414031982421875, -0.02667236328125, -0.0303802490234375, 0.000217437744140625, -0.0009026527404785156, -0.033172607421875, -0.0307769775390625, 0.03277587890625, -0.0016031265258789062, -0.03314208984375, 0.00958251953125, 0.021148681640625, 0.0168609619140625, 0.00449371337890625, -0.007656097412109375, -0.05523681640625, 0.0110321044921875, -0.031036376953125, -0.05694580078125, -0.00518798828125, -3.1828880310058594e-05, 0.035003662109375, -0.029388427734375, -0.0160064697265625, -0.0128326416015625, -0.0158843994140625, -0.0732421875, -0.0240478515625, 0.03173828125, -0.0233306884765625, -0.002414703369140625, -0.02349853515625, -0.06951904296875, 0.052703857421875, -0.00139617919921875, -0.02557373046875, 0.032745361328125, -0.07720947265625, -0.039093017578125, 0.038116455078125, -0.00310516357421875, 0.0045928955078125, 0.02117919921875, 0.0240020751953125, 0.0163116455078125, 0.033294677734375, 0.0465087890625, -0.006298065185546875, -0.018524169921875, 0.007495880126953125, -0.018585205078125, -0.003643035888671875, 0.0498046875, 0.01094818115234375, -0.01271820068359375, 0.0211334228515625, 0.025421142578125, -0.03564453125, 0.0014791488647460938, -0.042938232421875, 0.003116607666015625, 0.00823211669921875, -0.0225982666015625, 0.047271728515625, 0.00457000732421875, -0.0008883476257324219, -0.023834228515625, -0.0097198486328125, 0.01538848876953125, 0.017120361328125, -0.05316162109375, 0.036285400390625, 0.0032825469970703125, -0.0007686614990234375, 0.022430419921875, -0.00893402099609375, -0.0162200927734375, -0.0067901611328125, -0.0254669189453125, 0.026824951171875, 0.01555633544921875, 0.02081298828125, 0.01155853271484375, -0.0306243896484375, -0.02545166015625, 0.00649261474609375, 0.029937744140625, 0.048126220703125, -0.020660400390625, 0.022552490234375, 0.01416015625, 0.0120849609375, -0.0228729248046875, 0.041961669921875, 0.0011920928955078125, 0.003643035888671875, 0.0709228515625, 0.004970550537109375, -0.0021686553955078125, 0.027130126953125, 0.0288238525390625, -0.0413818359375, 0.05987548828125, -0.004116058349609375, -0.064208984375, -0.0167694091796875, 0.01032257080078125, -0.0404052734375, -0.01468658447265625, -0.042816162109375, 0.07989501953125, -0.0024623870849609375, -0.0022735595703125, 0.032989501953125, 0.00727081298828125, -0.1572265625, -0.072021484375, 0.00396728515625, 0.015289306640625, 0.007389068603515625, 0.0029811859130859375, -0.01406097412109375, 0.00421142578125, -0.0229949951171875, -0.02020263671875, -0.0728759765625, -0.06353759765625, -0.02874755859375, -0.00740814208984375, -0.003444671630859375, -0.0247802734375, 0.02532958984375, 0.01312255859375, 0.03265380859375, -0.01959228515625, -0.01194000244140625, -0.0259246826171875, 0.068115234375, -0.05413818359375, 0.019317626953125, -0.00514984130859375, -0.0281524658203125, 0.01326751708984375, -0.03289794921875, -0.04461669921875, -0.01238250732421875, 0.00240325927734375, -0.00893402099609375, 0.045684814453125, 0.0244903564453125, 0.004283905029296875, 0.0297393798828125, -0.055511474609375, -0.016693115234375, 0.046051025390625, 0.03338623046875, -0.0020160675048828125, -0.0084075927734375, -0.01483154296875, -0.01971435546875, 0.0216522216796875, 0.0008015632629394531, 0.022552490234375, -0.050048828125, -0.0009851455688476562, -0.01032257080078125, -0.002838134765625, 0.00797271728515625, -0.014739990234375, -0.0095367431640625, -0.05755615234375, 0.030120849609375, 0.05908203125, -0.006381988525390625, -0.08258056640625, 0.024200439453125, -0.031219482421875, -0.0255889892578125, -0.046875, -0.030029296875, -0.004947662353515625, 0.052825927734375, -0.0218963623046875, -0.00836944580078125, -0.03240966796875, 0.0195465087890625, 0.00420379638671875, -0.01910400390625, 0.0123138427734375, -0.010772705078125, 0.08209228515625, -0.04791259765625, -0.0241241455078125, -0.012908935546875, -0.1112060546875, 0.006496429443359375, 0.0013761520385742188, 0.033721923828125, 0.0418701171875, -0.001312255859375, 0.0034847259521484375, 0.029876708984375, 0.0018463134765625, 0.041168212890625, 0.28466796875, -0.04522705078125, 0.023468017578125, -0.01018524169921875, 0.01715087890625, -0.03118896484375, 0.041015625, 0.00746917724609375, 0.022674560546875, 0.006420135498046875, -0.0099029541015625, 0.025054931640625, 0.033294677734375, 0.03985595703125, -0.0095672607421875, -0.0242156982421875, -0.01456451416015625, 0.03692626953125, 0.0753173828125, -0.01529693603515625, 0.0137786865234375, -0.01380157470703125, -0.04119873046875, 0.0231475830078125, -0.03424072265625, -0.032806396484375, -0.01306915283203125, 0.0020046234130859375, -0.002323150634765625, 0.03369140625, -0.00838470458984375, -0.01678466796875, 0.0266265869140625, -0.01476287841796875, -0.03173828125, -0.0001518726348876953, 0.004070281982421875, 0.023529052734375, 0.0202484130859375, -0.00714111328125, -0.042938232421875, -0.034637451171875, 0.01425933837890625, 0.014404296875, 0.06134033203125, -0.0011310577392578125, 0.0077667236328125, 0.00757598876953125, -0.0231170654296875, 0.0345458984375, -0.0305938720703125, 0.0079345703125, -0.0188751220703125, 0.00897216796875, 0.027587890625, -0.03265380859375, -0.04339599609375, -0.006351470947265625, 0.005252838134765625, -0.007381439208984375, 0.056396484375, -0.01444244384765625, -0.051788330078125, 0.026458740234375, -0.0233154296875, 0.0011682510375976562, -0.0026950836181640625, -0.0216217041015625, -0.003910064697265625, -0.017242431640625, 0.039520263671875, 0.04229736328125, 0.0243377685546875, 0.0305023193359375, 0.0249481201171875, -0.013397216796875, 0.042755126953125, 0.036712646484375, 0.0190887451171875, 0.0128936767578125, -0.05474853515625, -0.03863525390625, -0.01470184326171875, -0.01641845703125, 0.01145172119140625, -0.0152587890625, -0.0302734375, 0.031768798828125, 0.0049896240234375, -0.010589599609375, -0.0229339599609375, -0.002368927001953125, 0.044403076171875, 0.007221221923828125, 0.00846099853515625, 0.0006933212280273438, 0.050445556640625, -0.0244140625, -0.0021152496337890625, 0.01012420654296875, 0.0159759521484375, 0.0244903564453125, 0.002048492431640625, -0.023590087890625, 0.009063720703125, 0.0157318115234375, 0.006977081298828125, 0.001041412353515625, -0.0025424957275390625, 0.028045654296875, -0.037017822265625, 0.02423095703125, 0.01009368896484375, 0.01407623291015625, 0.01535797119140625, -0.0134735107421875, -0.016571044921875, 0.0728759765625, 0.0157318115234375, 0.0256805419921875, -0.03863525390625, -0.0179443359375, -0.00839996337890625, 0.00646209716796875, 0.01296234130859375, -0.044891357421875, 0.018402099609375, -0.04058837890625, 0.030364990234375, 0.056304931640625, 0.0024318695068359375, -0.02593994140625, 0.032501220703125, -0.0045166015625, 0.0256195068359375, 0.004680633544921875, -0.03582763671875, 0.00856781005859375, 0.056304931640625, 0.027679443359375, -0.0335693359375, 0.019683837890625, -0.0479736328125, -0.039947509765625, -0.00582122802734375, 0.0225830078125, 0.00806427001953125, 0.0167083740234375, 0.0081329345703125, 0.019073486328125, 0.0035800933837890625, 0.0272369384765625, 0.013397216796875, -0.056427001953125, 0.00734710693359375, -0.04669189453125, -0.0025501251220703125, -0.02899169921875, -0.0311737060546875, -0.007610321044921875, -0.01131439208984375, 0.0185546875, 0.0321044921875, 0.089111328125, -0.0010862350463867188, 0.050048828125, 0.01021575927734375, 0.04107666015625, 0.055572509765625, -0.0190887451171875, -0.014007568359375, -0.042510986328125, -0.032501220703125, 0.019439697265625, -0.01666259765625, -0.004573822021484375, -0.040008544921875, 0.0295867919921875, -0.0149688720703125, 0.0252532958984375, 0.047149658203125, 0.03076171875, 0.005741119384765625, 0.003116607666015625, 0.01898193359375, 0.038543701171875, 0.0196533203125, -0.0181884765625, 0.010772705078125, -0.0201568603515625, 0.036407470703125, 0.00994110107421875, 0.00395965576171875, 0.0025959014892578125, 0.07098388671875, 0.036773681640625, 0.0406494140625, 0.0027065277099609375, 0.0248565673828125, 0.015777587890625, -0.0135345458984375, 0.0268096923828125, 0.04571533203125, -0.0208892822265625, 0.0029659271240234375, -0.01470184326171875, -0.0137176513671875, -0.004764556884765625, 0.02532958984375, -0.005397796630859375, 0.012908935546875, 0.0129241943359375, -0.03314208984375, 0.02496337890625, -0.0211334228515625, -0.025360107421875, -0.01122283935546875, 0.00424957275390625, 0.00949859619140625, -0.03582763671875, -0.00865936279296875, -0.00765228271484375, 0.0258941650390625, -0.051513671875, -0.00899505615234375, 0.037078857421875, -0.0024852752685546875, -0.049072265625, -0.0170135498046875, 0.01207733154296875, 0.007171630859375, -0.00832366943359375, 0.01275634765625, -0.0325927734375, -0.00860595703125, 0.004398345947265625, -3.6716461181640625e-05, 0.0743408203125, 0.009033203125, 0.0081787109375, -0.0380859375, -0.028900146484375, -0.0086669921875, 0.0521240234375, 0.0263824462890625, 0.06756591796875, -0.0157318115234375, -0.0160369873046875, 0.044677734375, 0.0300445556640625, 0.04962158203125, 0.009552001953125, -0.005290985107421875, -0.006221771240234375, 0.0104217529296875, -0.007080078125, -0.0201568603515625, 0.02252197265625, -0.01123809814453125, -0.01617431640625, -0.0543212890625, 0.0277099609375, 0.02923583984375, -0.00921630859375, -0.0380859375, -0.0367431640625, 0.00746917724609375, 0.04022216796875, -0.00506591796875, -0.01329803466796875, -0.0117950439453125, -0.0046539306640625, -0.050323486328125, -0.01203155517578125, -0.01477813720703125, -0.01995849609375, 0.01087188720703125, 0.005916595458984375, -0.0289306640625, 0.0270538330078125, 0.04229736328125, -0.046173095703125, 0.04827880859375, 0.026885986328125, -0.0248870849609375, -0.0037517547607421875, 0.020111083984375, 0.0296173095703125, 0.01065826416015625, -0.010650634765625, 0.0604248046875, 0.003055572509765625, -0.0352783203125, 0.0290985107421875, -0.0092620849609375, 0.002956390380859375, -0.029052734375, 0.022430419921875, -0.007171630859375, -0.00384521484375, 0.0010404586791992188, 0.01538848876953125, 0.006458282470703125, -0.0181884765625, -0.0008902549743652344, -0.00168609619140625, 0.018402099609375, -0.0416259765625, -0.0018815994262695312, -0.00769805908203125, -0.031951904296875, -0.04315185546875, 0.0019989013671875, 0.01239776611328125, 0.0158538818359375, -0.01413726806640625, 0.044921875, -0.0075836181640625, 0.00555419921875, -0.006336212158203125, -0.0115203857421875, -0.0036563873291015625, -0.04144287109375, 0.0311431884765625, -0.035491943359375, 0.0026950836181640625, -0.0184326171875, -0.0128021240234375, -0.068115234375, 0.01432037353515625, -0.00922393798828125, -0.00597381591796875, -0.0408935546875, -0.0560302734375, 0.055206298828125, -0.0211029052734375, 0.019805908203125, 0.022308349609375, 0.03167724609375, -0.0129241943359375, -0.04241943359375, -0.05157470703125, 0.09710693359375, 0.005908966064453125, 0.02752685546875, -0.015869140625, -0.0184173583984375, -0.01280975341796875, 0.0243072509765625, -0.0011186599731445312, 0.020172119140625, -0.0256195068359375, 0.0134429931640625, -0.0667724609375, 0.036224365234375, -0.0098876953125, 0.00627899169921875, -0.0016851425170898438, 0.0017042160034179688, -0.015716552734375, -0.0008535385131835938, 0.0256805419921875, 0.01446533203125, 0.036865234375, 0.0186004638671875, -0.0081787109375, 0.01444244384765625, -0.0252227783203125, 0.032684326171875, -0.023284912109375, 0.0083465576171875, 0.0112152099609375, -0.05059814453125, -0.0005779266357421875, -0.00887298583984375, 0.035430908203125, -0.01163482666015625, 0.0013866424560546875, 0.033782958984375, 0.0094757080078125, 0.0082855224609375, -0.029937744140625, -0.048736572265625, -0.0167236328125, -0.02044677734375, 0.006092071533203125, -0.009735107421875, 0.025299072265625, -0.001312255859375, 0.002338409423828125, 0.00525665283203125, -0.0280914306640625, -0.06939697265625, -0.01494598388671875, -0.1259765625, 0.024383544921875, -0.0120849609375, -0.032440185546875, -0.0267486572265625, 0.01983642578125, 0.00469970703125, -0.007259368896484375, 0.035552978515625, -0.0112152099609375, -0.01416778564453125, -0.00846099853515625, 0.0202178955078125, -0.0102081298828125, 0.019622802734375, 0.036346435546875, -0.0279388427734375, -0.0162200927734375, 0.0268707275390625, 0.044036865234375, 1.8358230590820312e-05, -0.0103607177734375, 0.028594970703125, 0.00652313232421875, 0.0489501953125, -0.021697998046875, -0.0203399658203125, 0.032012939453125, -0.0010995864868164062, -0.01538848876953125, 0.025360107421875, 0.01239776611328125, 0.013214111328125, 0.0194091796875, 0.0218048095703125, 0.035400390625, -0.0015859603881835938, -0.035430908203125, -0.039398193359375, 0.0280303955078125, -0.0201873779296875, -0.01126861572265625, -0.0458984375, 0.00870513916015625, -0.046051025390625, 0.0447998046875, -0.02734375, -0.023040771484375, -0.076904296875, 0.0007081031799316406, -0.00513458251953125, 0.09539794921875, -0.01367950439453125, 0.00788116455078125, 0.0171051025390625, -0.00811767578125, -0.0309906005859375, 0.029693603515625, -0.0175018310546875, 0.05279541015625, -0.0418701171875, -0.004215240478515625, -0.0439453125, -0.0501708984375, -0.020843505859375, -0.0030117034912109375, -0.083251953125, 0.0271148681640625, 0.0259246826171875, 0.03143310546875, -0.0059814453125, -0.054901123046875, 0.0196990966796875, 0.032928466796875, 0.049560546875, 0.0140228271484375, -0.0012807846069335938, 0.006160736083984375, 0.007274627685546875, -0.0212554931640625, -0.0214996337890625, -0.035980224609375, -0.0041351318359375, 0.0258636474609375, 0.0276336669921875, 0.00827789306640625, 0.00579833984375, -0.036041259765625, -0.01092529296875, 0.0286102294921875, -0.0616455078125, -0.037017822265625, -0.0257568359375, -0.00211334228515625, -0.08013916015625, 0.0290374755859375, -0.042633056640625, -0.028045654296875, -0.006496429443359375, -0.016326904296875, -0.043426513671875, 0.034698486328125, -0.0032806396484375, -0.03192138671875, 0.0204010009765625, -0.03704833984375, 0.03057861328125, -0.034698486328125, 0.0426025390625, -0.004589080810546875, -0.026397705078125, 0.00897216796875, -0.0382080078125, 0.005283355712890625, -0.0145416259765625, 0.02142333984375, -0.0145416259765625, -0.00489044189453125, -0.045379638671875, -0.0211334228515625, 0.007144927978515625, 0.006313323974609375, -0.014495849609375, -0.01000213623046875, -0.0295257568359375, -0.00714874267578125, 0.040557861328125, 0.0010023117065429688, 0.01727294921875, -0.0069580078125, 0.035675048828125, -0.039947509765625, -0.06402587890625, 0.002208709716796875, 0.0694580078125, 0.03167724609375, -0.002605438232421875, 0.028472900390625, -0.013702392578125, -0.0777587890625, -0.044586181640625, 0.00824737548828125, -0.001739501953125, -0.0004305839538574219, -0.0005097389221191406, -0.0147705078125, 0.04766845703125, 0.006244659423828125, 0.00804901123046875, -0.0096282958984375, -0.01161956787109375, 0.0057525634765625, -0.0085601806640625, -0.0001513957977294922, -0.0260772705078125, 0.005626678466796875, -0.01053619384765625, -0.0042724609375, -0.005428314208984375, 0.0894775390625, 0.0030765533447265625, -0.076416015625, -0.037017822265625, -0.0153045654296875, -0.0190277099609375, 0.002399444580078125, 0.00141143798828125, -0.0181732177734375, -0.01312255859375, -0.027130126953125, -0.0250091552734375, 0.023468017578125, -0.0207366943359375, -0.0229949951171875, 0.0264129638671875, 0.01416015625, 0.021942138671875, 0.029815673828125, 0.0396728515625, -0.0129852294921875, 0.0184783935546875, 0.0098419189453125, 0.041534423828125, 0.006656646728515625, -0.0259857177734375, -0.00923919677734375, 0.0043792724609375, 0.00789642333984375, 0.01325225830078125, -0.022857666015625, -0.0180206298828125, -0.009857177734375, -0.0268402099609375, -0.022125244140625, 0.081298828125, 0.06268310546875, 0.027801513671875, 0.03387451171875, -0.012298583984375, 0.07464599609375, -0.002227783203125, 0.00603485107421875, 0.0177764892578125, -0.02984619140625, -0.0579833984375, -0.005123138427734375, 0.007965087890625, -0.0007829666137695312, -0.038787841796875, 0.016387939453125, 0.0014820098876953125, 9.995698928833008e-05, 0.026397705078125, 0.0221099853515625, -0.0118408203125, 0.02655029296875, 0.0189971923828125, -0.00553131103515625, 0.0257568359375, -0.002117156982421875, -0.0165557861328125, -0.0120697021484375, -0.0112762451171875, -0.038543701171875, 0.032806396484375, -0.023223876953125, 0.0118255615234375, -0.006866455078125, 0.0005888938903808594, -0.0078125, 0.0276336669921875, 0.04559326171875, 0.01953125, 0.0660400390625, -0.01006317138671875, 0.01751708984375, 0.03106689453125, -0.0019435882568359375, 0.011993408203125, -0.040313720703125, 0.00038623809814453125, -0.0084991455078125, 0.008697509765625, -0.0148162841796875], "destRID": "#1:0"}]}

Database dump :

ORANOOO-backup-20260123-195826576.zip

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions