BYTE Example - Analytics Database

Input

DROP TABLE TargetTable_byte;
CREATE MULTISET TABLE TargetTable_byte(id integer, array_col BYTE(24)) NO PRIMARY INDEX;
INSERT INTO TargetTable_byte values(1, '01B8A3497375013F9A9999999999C93F9A9999999999B93F'XB);
INSERT INTO TargetTable_byte values(2, '000000000000E03F9A9999999999D93F9A9999999999D93F'XB);
INSERT INTO TargetTable_byte values(3, '000000000000F03F9A9999999999E93FCDCCCCCCCCCCEC3F'XB);
INSERT INTO TargetTable_byte values(4, '7B14AE47E17A843F9A9999999999D93F9A9999999999C93F'XB);
 
DROP TABLE RefTable_byte;
CREATE MULTISET TABLE RefTable_byte(id integer, array_col BYTE(24)) NO PRIMARY INDEX;
INSERT INTO into RefTable_byte values(5, 'C3F5285C8FC2ED3F9A9999999999D93F666666666666E63F'XB);
INSERT INTO RefTable_byte values(6, '8FC2F5285C8FEA3F333333333333D33F333333333333E33F'XB);
INSERT INTO RefTable_byte values(7, '5C8FC2F5285CE73F000000000000E03F666666666666E63F'XB);

Query

SELECT target_id, reference_id, distancetype, cast(distance as decimal(36,15)) as distance FROM TD_VECTORDISTANCE (
ON TargetTable_byte as TargetTable
ON RefTable_byte as ReferenceTable Dimension
USING
TargetIDColumn('id')
TargetFeatureColumns('array_col')
RefIDColumn('id')
RefFeatureColumns('array_col')
DistanceMeasure('euclidean','cosine','manhattan')
topk(2)
EmbeddingSize(3)
) as dt order by 3,1,2,4;

Output