recdb-postgresql icon indicating copy to clipboard operation
recdb-postgresql copied to clipboard

Explain Analyze breaks with recommendation

Open Sarwat opened this issue 11 years ago • 2 comments

EXPLAIN ANALYZE breaks with a recommendation query. To reproduce the problem, first load the MovieLens dataset and then perform the following queries:

CREATE RECOMMENDER MovieRec ON ml_ratings USERS FROM userid ITEMS FROM itemid EVENTS FROM ratingval USING itemcoscf;

Then execute the following:

EXPLAIN ANALYZE SELECT * FROM ml_ratings RECOMMEND itemid TO userid ON ratingval USING itemcoscf WHERE userid = 1 ORDER BY ratingval LIMIT 10;

The back-end ends unexpectedly and returns a segmentation fault.

Note that EXPLAIN alone works just fine.

Sarwat avatar Nov 26 '13 02:11 Sarwat

This is an unexpected side effect of the latest optimization (enhanced user filtering). Working on a fix.

TheSoundDefense avatar Nov 27 '13 06:11 TheSoundDefense

@TheSoundDefense Any update on this? Kudos on your great work!

jmealo avatar May 24 '16 16:05 jmealo