KNNRecommender Output - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.10
1.1
Published
October 2019
Language
English (United States)
Last Update
2019-12-31
dita:mapPath
ima1540829771750.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.