1.1 - 8.10 - KNNRecommenderPredict Syntax Elements - 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)
UserIDColumn
[Optional] Specify the Ratings column that contains the user IDs.
Specify either all or none of UserIDColumn, ItemIDColumn, and RatingColumn. If you specified them in the KNNRecommender call that created the weights and bias tables that the KNNRecommenderPredict call uses, specify them in the KNNRecommenderPredict call, with the same values.
Default: First Ratings column
ItemIDColumn
[Optional] Specify the Ratings column that contains the item IDs.
Default: Second Ratings column
RatingColumn
[Optional] Specify the Ratings column that contains the ratings.
Default: Third Ratings column
TopK
[Optional] Specify the number of items to recommend for each user. The function recommends the top_k_recommendations highest-rated items.
Default: 3
ShowAll
[Optional] Specify whether to output more than top_k_recommendations items when multiple items have the same predicted rating.
If you specify 'true', and multiple items have the same predicted rating, the function outputs all these items, regardless of the value of top_k_recommendations. Otherwise, the function outputs at most top_k_recommendations items.
Default: 'false'