1.1 - 8.10 - KNNRecommender Output - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

Output Table Schema

Column Data Type Description
iternum INTEGER Iteration number. NULL for baseline rmse.
rmse DOUBLE PRECISION Root mean square error after iteration.

WeightModelTable Schema

Column Data Type Description
itemid INTEGER Item identifier.
weights BLOB Interpolation weights for item, in compressed binary format.

BiasModelTable Schema

Column Data Type Description
label CHARACTER(1) One of the following values:
label Meaning
U User statistics
I Item statistics
G Global statistics
id INTEGER Item identifier or user identifier.
value DOUBLE PRECISION One of the following values:
label value
U Average rating across all users for item.
I Average rating across all items from user.
G Global average rating across all users and all items.

NearestItemsTable Schema

This table appears only with the NearestItemsTable syntax element.

Column Data Type Description
itemi INTEGER Item identifier of item i.
itemj INTEGER Item identifier of item j.
sij DOUBLE PRECISION Calculated similarity between item i and item j.