| drop dataverse fuzzyjoin if exists; |
| create dataverse fuzzyjoin; |
| use dataverse fuzzyjoin; |
| |
| create type UserType as open { |
| uid: int32, |
| name: string, |
| lottery_numbers: [int32], |
| interests: <string> |
| } |
| |
| create dataset Users(UserType) partitioned by key uid; |
| |
| load dataset Users from nc1:'data/users-visitors-small/users.json'; |
| |
| write output to nc1:'rttest/fuzzyjoin_user-lot-aqlplus_2.adm'; |
| |
| set simthreshold '.5f'; |
| |
| for $user2 in dataset('Users') |
| for $user 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 } |