br1ghtyang / asterixdb

Automatically exported from code.google.com/p/asterixdb
0 stars 0 forks source link

FuzzyJoinRule is not fired when similarity is retrieved #624

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
FuzzyJoinRule is fired for the query fuzzyjoin/user-lot-aqlplus_1:

use dataverse fuzzyjoin;

set simthreshold '.5f';

for $user in dataset('Users')
for $user2 in dataset('Users')
where $user.lottery_numbers ~= $user2.lottery_numbers and $user.uid < $user2.uid
order by $user.uid, $user2.uid
return { 'user': $user, 'user2': $user2 }

But it is not fired for the query fuzzyjoin/user-lot-aqlplus_1.1:

use dataverse fuzzyjoin;

set simthreshold '.5f';

for $user in dataset('Users')
for $user2 in dataset('Users')
where $user.lottery_numbers ~= $user2.lottery_numbers and $user.uid < $user2.uid
let $sim := similarity-jaccard($user.lottery_numbers, $user2.lottery_numbers)
order by $sim desc, $user.uid, $user2.uid limit 3
return { 'user': $user, 'user2': $user2, 'sim': $sim }

The latter is run as NL join. The main difference is retrieving the similarity 
in the second query.

Original issue reported on code.google.com by icetin...@gmail.com on 30 Aug 2013 at 9:31

GoogleCodeExporter commented 8 years ago

Original comment by icetin...@gmail.com on 30 Aug 2013 at 6:18

GoogleCodeExporter commented 8 years ago

Original comment by icetin...@gmail.com on 26 Sep 2013 at 12:33

GoogleCodeExporter commented 8 years ago

Original comment by icetin...@gmail.com on 26 Sep 2013 at 12:35