sample_vector_search.md

SELECT
    url,
    caption,
    L2Distance(image_embedding, [0.5736792683601379, 0.2516227662563324, 0.08648405969142914, -0.3087577521800995, 0.16166526079177856, -0.007050537504255772, -0.18505804240703583, -0.4547903835773468, -0.27521055936813354, -0.14916469156742096, -0.3867589235305786, -0.6603131294250488, -0.12612514197826385, 0.0861508697271347, -0.3013170063495636, -0.18740114569664001, -0.47240784764289856, 0.23528385162353516, 0.2165445238351822, -0.14971637725830078, -0.11677167564630508, 0.16455139219760895, 0.6751934885978699, 0.48457151651382446, -0.6089483499526978, 0.1328628659248352, 0.1305725872516632, -0.27523916959762573, 0.6474258899688721, 0.6060798764228821, 0.09428835660219193, -0.059794556349515915, -0.17287959158420563, 0.03964110463857651, -0.223852276802063, -0.026328448206186295, 0.16255885362625122, 0.39999595284461975, -0.2318170964717865, 0.5195636749267578, 0.35400936007499695, -0.3005162477493286, 0.581500768661499, -0.08902442455291748, -0.09745857864618301, -0.32712841033935547, 0.13228611648082733, 0.0717654898762703, -0.37283459305763245, 0.6159988641738892, -0.24333281815052032, 0.4546511471271515, 0.03613923117518425, 0.13219040632247925, -0.24418064951896667, 0.5877178907394409, 0.930475115776062, 0.25811201333999634, 0.13669642806053162, 0.49047181010246277, -0.5271645784378052, 0.04648108407855034, -0.11476162075996399, -0.35707059502601624, -0.10261011123657227, -0.12435944378376007, 0.001063611707650125, 0.32515063881874084, 0.4756675958633423, 0.042789243161678314, -0.2224169820547104, -0.25802674889564514, -0.05000738799571991, -0.25770291686058044, -0.7123655676841736, 0.28696873784065247, -0.31521040201187134, 0.08271954208612442, 0.16194860637187958, -0.3367091119289398, -0.10167212784290314, -0.5984204411506653, 0.8994238376617432, 0.05902006849646568, -0.9020736217498779, 0.16353605687618256, -0.40625813603401184, 0.47185277938842773, -0.45855656266212463, 0.21842990815639496, -0.1884566992521286, -0.2931573688983917, 0.29293256998062134, 0.29556703567504883, -1.1466610431671143, 0.22055834531784058, -0.5825557112693787, -0.06565725058317184, 0.003453108947724104, 1.1247153282165527, 0.10964179784059525, 0.2419600486755371, 0.35060563683509827, -0.17308901250362396, 0.261470764875412, -0.12980201840400696, -0.3077021837234497, -0.6832928657531738, -0.3733452260494232, -0.24896042048931122, 0.010491622611880302, 0.031307268887758255, 0.350431889295578, -0.08460874855518341, 0.3638524115085602, -0.09141530841588974, -0.864806056022644, 0.32942062616348267, 0.3023653030395508, 0.18829138576984406, -0.3240868151187897, 0.2358824759721756, 0.11740778386592865, 0.2846210300922394, 0.15817150473594666, 0.8961158394813538, 0.18137355148792267, -0.15807504951953888, -0.4143732190132141, 0.2257978618144989, 0.08396509289741516, 0.43877872824668884, 1.178699016571045, 0.045933570712804794, -0.11930932849645615, 0.849953830242157, -0.20386996865272522, -0.26638931035995483, 0.10202968865633011, -0.7463532090187073, 0.09804084151983261, 0.47768351435661316, 0.3720879554748535, 0.42462852597236633, -0.1094551607966423, -0.10398229211568832, -0.2502498924732208, -0.08622598648071289, -0.3504970371723175, 0.44897934794425964, 0.3201915919780731, 0.00882873497903347, -0.1265089064836502, 0.047599270939826965, -0.3733806908130646, -0.29240477085113525, -0.2704653739929199, 0.31432846188545227, -0.3244221806526184, -0.3161085546016693, -0.13530293107032776, 0.1334027796983719, 0.2910098135471344, 0.74266117811203, -0.3552386462688446, 0.6687818765640259, -0.6257489919662476, -0.058997366577386856, 0.3483811020851135, -0.22351820766925812, 0.12492111325263977, 0.26201313734054565, 0.27309104800224304, -0.13630543649196625, 0.750457227230072, 0.10393509268760681, -0.32359302043914795, 0.10567403584718704, -0.11756537109613419, -0.539837121963501, -1.1537935733795166, -0.046400927007198334, -0.565078854560852, 0.41068336367607117, 0.07511556148529053, 0.393510639667511, 0.7082415223121643, 0.1750856637954712, -0.06458261609077454, 0.6491838097572327, 0.7731428742408752, 0.16943000257015228, 0.4206690788269043, 0.021168021485209465, -0.089565709233284, -0.09364893287420273, 0.29987984895706177, -0.22465576231479645, 0.22288347780704498, 0.2811132073402405, -0.01632346399128437, 0.45323699712753296, 0.374523788690567, -0.3167989253997803, 0.06267768144607544, -0.008575329557061195, -0.16332419216632843, -0.28799185156822205, 0.3678578734397888, 0.5180135369300842, -0.20468206703662872, 0.4123481810092926, 0.16486504673957825, -0.3731846213340759, -0.385470986366272, 0.14856170117855072, 0.04995891824364662, 0.3739645481109619, -0.039961110800504684, -0.24296283721923828, 0.07008025795221329, -0.12417717278003693, -0.11277354508638382, -0.16930942237377167, -0.6543769240379333, 0.0043347785249352455, 0.23815855383872986, -0.30090874433517456, 0.719680666923523, 0.07860274612903595, 0.3258296549320221, 0.39363646507263184, -0.5220146775245667, 0.5368829965591431, -0.34117916226387024, 0.07126159965991974, -0.4307872951030731, -0.06340049207210541, 0.36449334025382996, -0.501372754573822, 0.18675996363162994, 0.40650883316993713, -0.11818332970142365, -0.46876031160354614, 0.09888676553964615, 0.14233078062534332, 0.24003425240516663, 0.32950758934020996, -0.13409604132175446, 0.2449733018875122, -0.05554376170039177, -1.247779369354248, 0.46574312448501587, -0.14327093958854675, -0.15899047255516052, 0.37814199924468994, 0.8298718333244324, 0.3572831451892853, 0.1080116257071495, 0.2603447437286377, 0.23327431082725525, 0.06344874203205109, 0.65654456615448, -0.16531415283679962, 0.0574643537402153, 0.11943373084068298, 0.30008262395858765, 0.3595537543296814, 0.5320783257484436, -0.049707721918821335, 0.17389820516109467, -1.1206984519958496, 0.26264041662216187, 0.08618581295013428, 0.5470103025436401, 0.26326900720596313, -0.20884157717227936, -0.2885894477367401, 0.01739729568362236, -0.15311020612716675, 0.04795599356293678, 0.23506562411785126, -0.2375275194644928, -0.19682566821575165, 0.12070832401514053, -0.7479842305183411, -0.6691840887069702, -0.3648638129234314, 0.9399546384811401, 0.5174998044967651, 0.28099650144577026, -0.8271012306213379, 0.10525085031986237, 0.10520746558904648, 0.13558429479599, 0.19579851627349854, 0.025176143273711205, 0.28896528482437134, -0.029451731592416763, -0.20488519966602325, 0.033878542482852936, -0.012544015422463417, -0.49961382150650024, 0.5389449000358582, -0.18157820403575897, -0.81558758020401, 0.5121064186096191, -0.6828938722610474, -0.22890593111515045, -0.07038900256156921, 0.23647604882717133, -0.3767947852611542, 0.3421240746974945, 0.34177374839782715, -0.004080563317984343, -0.23387768864631653, -3.389676809310913, -0.6017138957977295, -0.015869585797190666, -0.4483930170536041, -0.195700004696846, -1.1332448720932007, 0.47417134046554565, -0.007905126549303532, -0.15475071966648102, -0.0006712540052831173, 0.16749252378940582, -0.34878337383270264, -0.5212125778198242, 0.8025888204574585, 0.04655668884515762, 0.10715827345848083, -0.10235893726348877, 0.5659040212631226, -0.05889851972460747, -0.08546612411737442, 0.5130725502967834, -0.4297076165676117, 0.0524735264480114, -0.07485725730657578, 0.7388529181480408, -0.7617440223693848, 0.20678555965423584, 0.6377627849578857, 0.320684015750885, -0.30359771847724915, -0.5718344449996948, 0.5737001299858093, -0.10041160136461258, 0.08555349707603455, 0.6644882559776306, 0.3963106572628021, 0.36012977361679077, -0.4152145981788635, -0.695792019367218, 0.26394355297088623, 0.053919047117233276, -0.7449325323104858, 0.5643223524093628, -0.335702121257782, -0.04484717920422554, -0.26660796999931335, 0.31918543577194214, -0.6814120411872864, 0.6323763728141785, -0.743065357208252, 0.8307150602340698, 0.4832249879837036, 0.3425973653793335, 0.14145620167255402, -0.3564773201942444, -0.03913262486457825, 0.13192181289196014, -0.30096569657325745, 0.2687165141105652, 0.3472670614719391, -0.042171869426965714, -0.4384234547615051, 0.22197234630584717, 0.3043672442436218, 0.5945850610733032, 1.1234639883041382, 0.030093025416135788, 0.4049448072910309, 0.13427749276161194, -0.14136642217636108, 0.44628143310546875, 0.4897344708442688, -0.17173781991004944, 0.3644489049911499, 0.07148954272270203, -0.1039309874176979, -0.22506201267242432, -0.3712325394153595, -0.6704292893409729, -0.19157668948173523, -0.08454981446266174, 0.5075961351394653, 0.1292497217655182, 0.17989693582057953, 0.06804223358631134, -0.5330897569656372, 0.28737518191337585, 0.03205382823944092, 0.14850027859210968, -0.5499801635742188, 0.5231298804283142, 0.48203039169311523, -0.055828601121902466, 0.13416147232055664, -0.4979003071784973, -0.025278810411691666, -0.5627450346946716, -0.28639695048332214, -0.07369939982891083, 0.26448604464530945, 0.7209868431091309, -0.7478218078613281, -0.2082175463438034, -0.4246862232685089, -0.009073205292224884, -0.6011278629302979, -0.15520817041397095, 0.6392089128494263, 0.24302472174167633, 0.0892399325966835, -0.6487816572189331, -0.4368150532245636, -0.6278078556060791, 0.20101472735404968, -0.5842503309249878, 0.4618176817893982, -0.119196817278862, 0.5417092442512512, 0.9985178112983704, 0.9649063348770142, -0.368293821811676, 0.2202652245759964, -0.11403479427099228, 0.5496392250061035, 3.931293249130249, -0.8089114427566528, 0.4177452325820923, 0.077632836997509, -0.25931546092033386, 0.2234729379415512, 0.5299463272094727, 0.17196537554264069, 0.17638477683067322, -0.1720736175775528, -0.17075924575328827, -0.2542872130870819, 0.3676776885986328, -0.4698643684387207, 0.3839576840400696, 0.06834131479263306, -0.5129624009132385, 0.36260300874710083, 0.20629090070724487, -0.1842903345823288, 0.4200690686702728, -0.4029404819011688, -0.12785480916500092, 1.0919631719589233, -0.30988699197769165, -0.5643569827079773, -0.16286155581474304, -0.162000373005867, -0.2934841811656952, -0.9768706560134888, 0.26425570249557495, -0.9055514931678772, -0.04050668329000473, 0.30976036190986633, -0.3124285340309143, -0.06002332642674446, 0.13938094675540924, -0.30110734701156616, -0.6880031228065491, -0.05507902801036835, -0.1283186972141266, -0.0827331393957138, 0.2595963180065155, -0.7715180516242981, 0.1212955042719841, -0.02500208653509617, 0.15097032487392426, -0.0010188152082264423, -0.019633298739790916, 0.2716677784919739, -0.37994131445884705, 0.5217325687408447, -0.4813377559185028, -0.13336136937141418, -0.1989738643169403, 0.5565735697746277, 0.3963857889175415, 0.06555487215518951, 0.42752978205680847, -0.31704384088516235, -0.11296233534812927, -0.11580384522676468, 0.01745489239692688, 0.22503410279750824, -0.4362608790397644, 0.24717341363430023, -0.31521761417388916, 0.6580991148948669, 0.025356866419315338, 0.905048668384552, -1.0845947265625, -0.10092025250196457, -0.10219485312700272, -0.39323893189430237, 0.17986907064914703, -0.0005253722192719579, 0.400244802236557, 0.2298341542482376, 0.03089481219649315, -0.7984074950218201, -0.2824764847755432, 0.2428266406059265, 0.28830304741859436, -0.5594909191131592, -0.17702682316303253, -0.5368986129760742, 0.4408899247646332, -0.09295434504747391, 0.19821111857891083, 0.04798731580376625, 0.29364779591560364, 0.21933050453662872, -0.25843146443367004, -0.07262055575847626, 0.30278053879737854, 0.21530568599700928, -0.3828478157520294, -0.3154189884662628, 0.3228239417076111, 0.3294614255428314, -0.2678069472312927, 0.809098482131958, 0.623188853263855, 0.10616777837276459, -0.36337751150131226, 0.19683940708637238, 0.16792002320289612, -0.660940408706665, 0.9717456102371216, 0.6394895315170288, -0.389558881521225, -0.37625017762184143, 0.11583875864744186, 0.08218356221914291, 0.07690403610467911, 0.3261025547981262, -0.5817825794219971, -0.13140101730823517, -0.14653262495994568, -0.29950276017189026, -0.32179540395736694, -0.5825444459915161, 0.7498044967651367, -0.6928675174713135, -0.1182321310043335, 0.045157454907894135, 0.7218300700187683, 0.35035768151283264, -0.1972586214542389, 0.0473826564848423, -0.5677235126495361, 0.19336667656898499, -0.08349063247442245, -0.543570339679718, -0.20594710111618042, -0.19555766880512238, -0.2630766034126282, 0.22483286261558533, 0.325666606426239, -0.3323376476764679, -0.011692985892295837, 0.13194909691810608, -0.33425605297088623, 0.6341844201087952, -0.17485511302947998, 0.46118444204330444, -0.23818883299827576, 0.07849233597517014, -0.597026526927948, -0.1994803547859192, -0.2171500325202942, -0.030448008328676224, -0.23074287176132202, 0.6736528873443604, 0.3761519491672516, -0.401989609003067, 0.09250962734222412, 0.04292292520403862, -0.20467501878738403, 0.03881390020251274, 0.1783163696527481, 0.312533438205719, -0.27093786001205444, -0.17982204258441925, 0.3258679509162903, -1.1922630071640015, -0.6665837168693542, 0.4448508024215698, -0.28121212124824524, -0.2790326178073883, 0.08248843997716904, 0.19633956253528595, 0.6847585439682007, 0.4677676558494568, 0.6970640420913696, -0.5271233320236206, -0.19788552820682526, -0.53803551197052, 0.5560391545295715, 0.7638247609138489, -0.30298176407814026, 0.20320415496826172, 0.2937774658203125, 0.7301904559135437, -0.10325276851654053, 0.7817620635032654, -0.41128280758857727, 0.07158760726451874, -0.2061823606491089, 0.13006293773651123, 0.1883631944656372, 0.3575541377067566, 0.39175134897232056, 0.0025125702377408743, 0.5297117829322815, 1.4004430770874023, 0.3934791684150696, 0.6284257769584656, -0.3017585277557373, 0.0908612385392189, 0.44125646352767944, -0.40296486020088196, 0.07582617551088333, -0.037808552384376526, 0.28359296917915344, 0.09561911225318909, 0.7289270162582397, 0.28178921341896057, -0.1489703208208084, -0.16811390221118927, -0.11583846807479858, 0.34433817863464355, 0.47637125849723816, 0.5153834819793701, 0.05780421569943428, 0.5628756284713745, -0.0916205570101738, -0.5208988189697266, 0.46403148770332336, 1.1680787801742554, -0.5474284887313843, 0.18975040316581726, -0.2493000477552414, -0.446697473526001, 0.3048820197582245, -0.17809408903121948, 0.28748124837875366, 0.5313965082168579, 0.26017042994499207, 0.6217883229255676, -0.2691025137901306, 0.23821526765823364, -0.275251179933548, 0.17988789081573486, 0.05091235786676407, -0.0844835564494133, 0.0788668543100357, 0.5680525302886963, -0.5342708826065063, -0.07615059614181519, 0.011078712530434132, -0.5736539363861084, 0.027743052691221237, 0.37907347083091736, -0.31440451741218567, 0.5288978219032288, 0.07463307678699493, -0.23496504127979279, -0.15553715825080872, -0.46176642179489136, 0.3887990713119507, -0.762833297252655, 0.8452372550964355, 0.5787439346313477, -0.230514794588089, 0.6281166672706604, -0.01802879385650158, -0.06158141419291496, 0.6075667142868042, 0.03433690965175629, -0.5171605348587036, 0.39488160610198975, -0.27687376737594604, -0.9373763799667358, -0.1067076101899147, 0.14499002695083618, 0.2953783869743347, -0.0985950380563736, -0.5834875106811523, 0.32227835059165955, 0.17612014710903168, 0.03368888422846794, 0.252971351146698, 0.08998814225196838, 0.06696229428052902, 0.5110899209976196, -0.12352050095796585, 0.46068504452705383, 0.382085919380188, 0.30136632919311523, -0.49248215556144714, 0.4925352931022644, 0.11050108820199966, 0.015959206968545914, 0.7372257113456726, -0.48233479261398315, -0.7625815272331238, -0.42193862795829773, -0.1759042590856552, 0.023319104686379433, 0.015190765261650085, -0.36765143275260925, -0.42389214038848877, -0.04336070641875267, 0.23593485355377197, -0.12517619132995605, -0.07363094389438629, -0.11842958629131317, -0.4115673899650574, -0.5975258946418762, -0.6743490099906921, -0.7053169012069702, 0.48596352338790894, -0.17420880496501923, 0.15561604499816895, -0.10937431454658508, 0.23185639083385468, 0.6967896819114685, 0.08920053392648697, -0.18628302216529846, -0.2848503589630127, -0.3306224048137665, 0.30152344703674316, 0.10383736342191696, 0.45198139548301697, -0.809867262840271, -0.16949588060379028, 1.1253684759140015, -0.4034988284111023, 1.1489253044128418, -0.19471344351768494, 0.1054810881614685, 0.4361441731452942, 0.2590048015117645, -0.37032783031463623, -0.39060279726982117, -0.406968355178833, -0.6825606822967529]) AS score,
    image_embedding
FROM laion_100m
ORDER BY score ASC
LIMIT 10
FORMAT `Null`