SELECT userid, itemid, prediction::VARCHAR(4) AS prediction FROM KnnRecommenderPredict ( ON (SELECT * FROM ml_ratings WHERE userid <= 10) AS ratings PARTITION BY userid ON ml_bias AS bias DIMENSION ON ml_weights AS weights DIMENSION TOPK(5) ) ORDER BY 1, 3 DESC;