KNNRecommender Output - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.00
1.0
Published
May 2019
Language
English (United States)
Last Update
2019-11-22
dita:mapPath
blj1506016597986.ditamap
dita:ditavalPath
blj1506016597986.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 VARBYTE(n) Interpolation weights for item, in compressed binary format.
Column size depends on RatingTable size and may be very large. If any cell of this column exceeds 64 KB, you cannot use WeightModelTable with KNNRecommenderPredict function.

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 argument.

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.