ONNXEmbeddings Example: OutputFormat VECTOR - Teradata Vantage

           create table vector_out as (
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('VECTOR')
) a
) with data
;
 
*** Table has been created.
*** Total elapsed time was 12 seconds.
 
select rev_id, cast(sentence_embedding as varchar(2000)) as sentence_embedding from VECTOR_out;
 
 *** Query completed. 25 rows found. 2 columns returned.
*** Total elapsed time was 1 second.

rev_id           sentence_embedding
---------------- -------------------------------------------------------------------------------------------------
A10000012B7CGYKOMPQ4L 0.00997656956315041,0.0411211848258972,-0.0166587829589844,-0.0445277653634548,0.0342920757830143,0.037239596247673,0.0544225163757801,0.016035946086049
A26GKZPS079GFF        -0.0333678461611271,0.0132660260424018,0.0398636944591999,0.0313083715736866,-0.0101601565256715,0.00216040853410959,0.0357818752527237,-0.0029493966139
A2KU9IU07LOJS1        -0.0222496222704649,0.00189995812252164,0.0475357286632061,0.00651146285235882,-0.033984612673521,0.0229498147964478,0.0401160344481468,-0.0119090275838
A1MOSTXNIO5MPJ        -0.0143990078940988,0.0509085543453693,0.0506686754524708,0.039501279592514,0.0300292801111937,0.0203872565180063,0.0396121442317963,-0.0222862232476473
A1BM81XB4QHOA3        -0.0424468778073788,0.0196699537336826,0.0289442259818316,-0.0453505367040634,0.0049854414537549,0.0548326969146729,0.111477836966515,0.0273872260004282
A5E9TSD20U9PR         -0.0255403928458691,0.0424334146082401,0.00386487459763885,0.0248651560395956,0.00827911589294672,0.0105264177545905,0.0566195473074913,0.02198573760688
A3FFNE1DR5SI1W        0.0137435495853424,0.0115852048620582,0.0503500923514366,0.0116866426542401,0.0294459443539381,0.00616754684597254,0.0559656880795956,0.0296828206628561
A1340OFLZBW5NG        -0.0233285799622536,0.0214218217879534,-0.0200764089822769,-0.0104900496080518,0.00861103087663651,-0.00673970254138112,0.0356940180063248,-0.0180943291
A3FI0744PG1WYG        0.00013594381744042,0.0217473860830069,0.0302775856107473,0.00896494369953871,0.0155958356335759,0.0269326698035002,0.0625473111867905,0.022512312978506
A2S166WSCFIFP5        0.00285571906715631,-0.0143961319699883,-0.0167111270129681,-0.00866277702152729,-0.0105052264407277,0.0522883199155331,0.0365358926355839,-0.0014042042
A12387207U8U24        0.0307121239602566,0.0181475188583136,0.0518252588808537,0.0677928403019905,0.0222439896315336,0.00885061267763376,0.0482156835496426,-0.020694771781563
A19N3FCQCLJYUA        -0.013282529078424,-0.00433016428723931,-0.0159286614507437,0.00776459788903594,-0.0188744068145752,-0.00595402996987104,0.0264451019465923,-0.012750329
A3V1MKC2BVWY48        0.0103411348536611,0.0396031476557255,0.0203205402940512,0.0171305537223816,0.000752637803088874,-0.00298282061703503,0.0840815380215645,-0.069862112402
A1KQ80Y692CDOI        -0.00455766404047608,0.0145535385236144,-0.0220069233328104,0.0535601861774921,0.028609000146389,-0.0364201553165913,-0.0045784511603415,-0.011482371017
A2XQ5LZHTD4AFT        -0.028551984578371,0.0509975738823414,0.0165442153811455,-0.00985018443316221,0.00175124278757721,0.00872122496366501,-0.00199082540348172,-0.0320860557
A2WVHIRDMLM82E        0.0119955902919173,-3.227342676837e-05,-0.00698381010442972,0.00034290345502086,-0.00625595543533564,0.0115055181086063,0.117537461221218,-0.02998832240
A29TRDMK51GKZR        -0.0256531052291393,0.0151859754696488,0.0409550219774246,0.00182179780676961,-0.0145536605268717,0.0115372128784657,0.0348192863166332,-0.0050678290426
A2X4HE21JTAL98        -0.0131139131262898,-0.0202683880925179,0.0499096550047398,0.0147197777405381,0.027145754545927,0.019993469119072,0.0452845469117165,-0.0024131275713443
AUTNO7VDY4H4A         -0.0118440482765436,0.0222351718693972,-0.0054352511651814,0.0237750243395567,-0.0112732341513038,-0.0017255824059248,0.0173765122890472,0.0208869781345
A2I35JB67U20C0        -0.0315844938158989,0.0417253412306309,-0.0216604750603437,0.0203826203942299,0.0248195510357618,-0.0123208872973919,-0.0289674457162619,0.0150979124009
AENNW2G826191         0.00835240352898836,0.0482446812093258,0.0108612049371004,-0.00595423020422459,-0.0189047735184431,0.0645788237452507,-0.00520633859559894,-0.0063536996
...