Hi, everyone!
Thanks for such an interesting implementation as recdb.
I tried to play with different options and successfully applied item-item recommenders.
But, got this problem using UserPearCF and UserCosCF recommenders
I created a rating table
createtableratings
(
record_id bigserialnot nullconstraint ratings_users_pk
primary key,
user_id integernot null,
story_id integernot null,
rating integernot null
);
createunique indexratings_record_id_uindexon ratings (record_id);
createindexratings_story_id_indexon ratings (story_id);
createindexratings_user_id_indexon ratings (user_id);
Then, I created a recommender for this
CREATE RECOMMENDER UserRec ON ratings
USERS FROM user_id
ITEMS FROM story_id
EVENTS FROM rating
USING userpearcf;
Trying to execute a query similar to the example
SELECTR.story_id, R.ratingFROM ratings R RECOMMEND R.story_id TO R.user_idONR.rating USING UserPearCF
WHERER.user_id=1000ORDER BYR.ratingDESC
Got this error:
ERROR: type mismatch in getTupleFloat()
Hi, everyone!
Thanks for such an interesting implementation as recdb.
I tried to play with different options and successfully applied item-item recommenders.
But, got this problem using UserPearCF and UserCosCF recommenders
I created a rating table
Then, I created a recommender for this
Trying to execute a query similar to the example
Got this error:
ERROR: type mismatch in getTupleFloat()