KNNRecommender Syntax Elements - 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ā„¢
WeightModelTable
Specify the name for the output table of interpolation weights.
BiasModelTable
Specify the name for the output table of global, user, and item bias statistics.
NearestItemsTable
[Optional] Specify the name for the output table of nearest neighbors for each item.

If you omit this syntax element, the function does not output this table.

If you specify this syntax element, and a table named item_neighbors_table exists, the function uses the existing table to train the model.

If you specify this syntax element, and no table named item_neighbors_table exists, the function creates a table with that name.

UserIDColumn
[Optional] Specify the InputTable column that contains the user IDs.
You must specify either all or none of UserIDColumn, ItemIDColumn, and RatingColumn.
Default: First InputTable column
ItemIDColumn
[Optional] Specify the InputTable column that contains the item IDs.
Default: Second InputTable column
RatingColumn
[Optional] Specify the InputTable column that contains the ratings.
Default: Third InputTable column
K
[Optional] Specify the number of nearest neighbors with which to calculate the interpolation weights.
Default: 20
LearningRate
[Optional] Specify the initial learning rate. The learning rate adjusts automatically during training based on changes in the root-mean-square error (RMSE).
Default: 0.001
MaxIterNum
[Optional] Specify the maximum number of iterations.
Default: 10
StopThreshold
[Optional] Specify the RMSE below which the function stops.
Default: 0.0002
SimilarityMethod
[Optional] Specify the method for calculating item similarity:
Option Description
'pearson' (Default) Pearson correlation coefficient:

Formula for Pearson correlation coefficient used by SimilarityMethod syntax element in Machine Learning Engine function KNNRecommender
'adjustedcosine' Adjusted cosine similarity:

Formula for adjusted cosine similarity used by SimilarityMethod syntax element in Machine Learning Engine function KNNRecommender