VARBYTE Example - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-01-20
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantageā„¢

InputTable

DROP TABLE input_table_varbyte;
CREATE MULTISET TABLE input_table_varbyte(id INTEGER, array_col Varbyte(32000)) PRIMARY INDEX ( id );
INSERT INTO input_table_varbyte values(1, '000000000000F03F000000000000F03F'XB);
INSERT INTO input_table_varbyte values(2, '00000000000000400000000000000040'XB);
INSERT INTO input_table_varbyte values(3, '00000000000020400000000000002040'XB);
INSERT INTO input_table_varbyte values(4, '00000000000022400000000000002240'XB);
id array_col
1 000000000000F03F000000000000F03F
2 00000000000000400000000000000040
3 00000000000020400000000000002040
4 00000000000022400000000000002240

Output: kmeans_model_udt (Generated using TD_KMeans)

td_clusterid_kmeans array_col td_size_kmeans td_withinss_kmeans id td_modelinfo_kmeans
0 000000000000F83F000000000000F83F 2 1.000000000000000E 000 NULL NULL
1 00000000000021400000000000002140 2 1.000000000000000E 000 NULL NULL
NULL NULL NULL NULL NULL Converged: true
NULL NULL NULL NULL NULL Number of Iterations: 2
NULL NULL NULL NULL NULL Number of Clusters: 2
NULL NULL NULL NULL NULL Total_WithinSS : 2.00000000000000E+00
NULL NULL NULL NULL NULL Between_SS : 9.80000000000000E+01
NULL NULL NULL NULL NULL Method for InitialCentroids: Random

Query

SELECT * FROM TD_KMeansPredict (
ON input_table_varbyte as InputTable
ON kmeans_model_varbyte as ModelTable DIMENSION
USING
OutputDistance('true')
Accumulate('array_col')
)as dt;

Output

id td_clusterid_kmeans td_distance_kmeans array_col
1 0 0.707106781 000000000000F03F000000000000F03F
2 0 0.707106781 00000000000000400000000000000040
3 1 0.707106781 00000000000020400000000000002040
4 1 0.707106781 00000000000022400000000000002240