asterix-app/src/test/resources/optimizerts/queries/push-project-through-group.aql

drop dataverse fuzzyjoin_080 if exists;

create dataverse fuzzyjoin_080;

use dataverse fuzzyjoin_080;

create type DBLPType as open {
  id: int32, 
  dblpid: string,
  title: string,
  authors: string,
  misc: string
}

create nodegroup group1 if not exists on nc1, nc2;

create dataset DBLP(DBLPType) 
  partitioned by key id on group1;


write output to nc1:'rttest/fuzzyjoin_080.adm';

    for $paperDBLP in dataset('DBLP')
    let $matches :=
            for $paper in dataset('DBLP')
            where $paper.authors = $paperDBLP.authors        
            return $paper.title
    return {'id': $paperDBLP.id, 'matches':$matches}