blob: 3d6dee45bc43c96b03e67e375928d94bbe534315 [file] [log] [blame]
alexander.behmc576c602012-07-06 02:41:15 +00001drop dataverse test if exists;
2create dataverse test;
3use dataverse test;
4
5create type DBLPType as closed {
6 id: int32,
7 dblpid: string,
8 title: string,
9 authors: string,
10 misc: string
11}
12
13create nodegroup group1 if not exists on nc1, nc2;
14
15create dataset DBLP(DBLPType)
ramangrover29669d8f62013-02-11 06:03:32 +000016 primary key id on group1;
alexander.behmc576c602012-07-06 02:41:15 +000017
18load dataset DBLP
19using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
20(("path"="nc1://data/dblp-small/dblp-small-id.txt"),("format"="delimited-text"),("delimiter"=":")) pre-sorted;
21
22write output to nc1:"rttest/similarity_fuzzyeq-edit-distance.adm";
23
24set simfunction 'edit-distance';
25set simthreshold '2';
26
27for $paper in dataset('DBLP')
28where $paper.authors ~= "Amihay Motro"
29return $paper