select
*
from mldb.ONNXEmbeddings(
on (SELECT CAST(rev_id AS VARCHAR(21)) AS rev_id, rev_text AS txt FROM amazon_reviews_25)
on (select model_id, model from onnx_models where model_id = 'bge-small-en-v1.5') DIMENSION
on (select tokenizer from embeddings_tokenizers where model_id = 'bge-small-en-v1.5') DIMENSION
USING
Accumulate('rev_id')
ModelOutputTensor('sentence_embedding')
OutputFormat('BLOB(1536)')
) a
;
*** Query completed. 25 rows found. 2 columns returned.
*** Total elapsed time was 1 second.
The following example is a snippet of the total output:
rev_id sentence_embedding ------------------------------------------------------------------------------------------------------------------------------ A3V1MKC2BVWY48 DD6D293CE936223D4377A63C60558C3CAB4C453A6D7B43BBF132AC3DDE138FBD4D04983A475589BDF55D2CBDA701923B6712533DE9171C3DB9C5D7BBA694283CF3B2043DCBF6D83C274959BD3 A26GKZPS079GFF B9AC08BDBF59593C1D48233D353D003DC97626BCA4950D3B0490123DAA4A41BB17131F3D7664D4BC2D26A93C6D522ABC2D2EBB3AB5E379BC2AACAB3C8959153D79664ABC0C68913CF67C01BE7 AUTNO7VDY4H4A 8A0D42BC8926B63C311AB2BBD7C3C23C5FB338BCF02CE2BA30598E3C2B1BAB3C5A1436BC617B9ABDBC81283CD31A573DEE212ABB01922D3D360082BC69FE4EBC6FAD143D816AC93CDD5393BD3 A2S166WSCFIFP5 04273B3BC1DD6BBCC6E588BC52EE0DBC1D1E2CBC472C563DA9A6153D470DB8BA907B483D57451BBDCBB001BC970E66BC9BCD033BB40D263D2116283DD32069392182FEBB74B0C23C6F18E6BD2 A5E9TSD20U9PR 163AD1BCA9CE2D3DD6497D3B03B2CB3C21A5073CFF762C3CE6E9673D6F1BB43CD64ED2BC50B37EBD6E0168BD45110E3D231A5D3CD6B6013C9B23A33C87BD34BC0CABE5BC2CAC933D1EAF81BDF A27ZH1AQORJ1L 346F85BBC9D6FF3C85A6603DCDC9CA3C49FBCDBC0097C8BCEE952F3DDCC271BC9042C9BB9EBDBABC43D4AABB5E4D9F394195FF3C2BC8453DBCA833BCBA10E53CADEC653C80FC4E3D929CD6BDC A1BM81XB4QHOA3C 7DC2DBDE222A13C711CED3C7CC139BDEA5CA33B4098603D7E4EE43D2D5BE03CA4D492BCF47607BDAA7B613C378CD13CA782013C709AC93C328395BB4FA10E3D97420FBD9B5C863DDBD780BD6 A1340OFLZBW5NG 941BBFBCD17CAF3C4877A4BC75DE2BBC48150D3CB9D8DCBBE433123D8F3A94BC22C1233C421C14BDC9F51ABCBA84B23D5B82C3BC7386743C3C93C9BC2A529CBCED79343BEE508B3A1FBA9BBDA A10000012B7CGYKOMPQ4L C474233CB06E283D007888BCBF6236BDD9750C3D8C88183D25EA5E3DD15D833CA1F2B23B0A58A6BCCFA22C3D698C92BC3435DDBCD7EDDD3AB4B6013D621820BBB0B6443CDCC4C73DA28924BE1 A2WVHIRDMLM82E 2789443C545D07B872D8E4BBB9C7B339C2FECCBBA4813C3C7BB7F03D12AAF5BC297B183CEBD441BD3DC5ED3BB255003DDF6E0EBC0083A23C4F00083B9DAC383CB7B6373B689912BCBFF8EEBD1 A3FI0744PG1WYG 248C0E399327B23CB308F83CB3E1123CAD857F3CE7A1DC3CCE18803DBE6BB83C8D150E3B09AF72BD68DA88BBB718BABBF7BF3B3D470D393DE1F8F23BCF9557BB112C65BC4A7AA03D179054BB2 ...