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 }