WSRecommender version 1.2, WSRecommenderReduce version 1.2
SELECT * FROM WSRecommender
ON (
SELECT * FROM WSRecommenderReduce (
ON item_table AS item_table PARTITION BY item1_column
ON user_table AS user_table PARTITION BY item_column
[ USING
[ Item1 ('item1_column') ]
[ Item2 ('item2_column') ]
[ ItemSimilarity ('similarity_column') ]
[ UserItem ('item_column') ]
[ UserID ('user_column') ]
[ UserPref ('preference_column') ]
[ AccumulateItem ({ 'accumulate_item_column' | accumulate_item_column_range }[,...]) ]
[ AccumulateUser ({ 'accumulate_user_column' | accumulate_user_column_range }[,...]) ]
]
) AS alias_1
) AS temporary_table PARTITION BY usr, col1_item2
) AS alias_2;