7.00.02 - KNNRecommenderTrain Arguments - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Last Update
2018-04-17
RatingTable
Specifies the name of the user rating table.
UserIDColumn
[Optional] Specifies the user_rating_table column that contains the user IDs. Default: First user_rating_table column.
You must specify either all or none of UserIDColumn, ItemIDColumn, and RatingColumn.
ItemIDColumn
[Optional] Specifies the user_rating_table column that contains the item IDs. Default: Second user_rating_table column.
RatingColumn
[Optional] Specifies the user_rating_table column that contains the ratings. Default: Third user_rating_table column.
WeightModelTable
Specifies the name for the output table of interpolation weights.
BiasModelTable
Specifies the name for the output table of global, user, and item bias statistics.
NearestItemsTable
[Optional] Specifies the name for the output table of nearest neighbors for each item.

If you omit this argument, the function does not output the NearestNeighbors table.

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

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

K
[Optional] Specifies the number of nearest neighbors with which to calculate the interpolation weights. Default: 20.
LearningRate
[Optional] Specifies 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] Specifies the maximum number of iterations. Default: 10.
Threshold
[Optional] Specifies the RMSE below which the function stops. Default: 0.0002.
ItemSimilarity
[Optional] Specifies the method for calculating item similarity:
  • 'pearson': Pearson correlation coefficient (Default)


  • 'adjustedcosine': adjusted cosine similarity