http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-edit-distance-check.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-edit-distance-check.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-edit-distance-check.sqlpp index 7a7fec0..01183f7 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-edit-distance-check.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-edit-distance-check.sqlpp @@ -34,13 +34,13 @@ create type test.DBLPType as dblpid : string, title : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (authors:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-basic_ngram-edit-distance-check.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_ngram-edit-distance-check.adm"; select element o from DBLP as o where test.`edit-distance-check`(o.authors,'Amihay Motro',1)[0]
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-edit-distance-panic.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-edit-distance-panic.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-edit-distance-panic.sqlpp index 4159d34..dbb5814 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-edit-distance-panic.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-edit-distance-panic.sqlpp @@ -34,13 +34,13 @@ create type test.DBLPType as dblpid : string, title : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (authors:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-basic_ngram-edit-distance-panic.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_ngram-edit-distance-panic.adm"; select element o from DBLP as o where (test.`edit-distance`(o.authors,'Amihay Motro') <= 5) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-edit-distance.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-edit-distance.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-edit-distance.sqlpp index 99dc892..4c3ca04 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-edit-distance.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-edit-distance.sqlpp @@ -34,13 +34,13 @@ create type test.DBLPType as dblpid : string, title : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (authors:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-basic_ngram-edit-distance.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_ngram-edit-distance.adm"; select element o from DBLP as o where (test.`edit-distance`(o.authors,'Amihay Motro') <= 1) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-fuzzyeq-edit-distance.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-fuzzyeq-edit-distance.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-fuzzyeq-edit-distance.sqlpp index 1fa7390..4da110a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-fuzzyeq-edit-distance.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-fuzzyeq-edit-distance.sqlpp @@ -34,13 +34,13 @@ create type test.DBLPType as dblpid : string, title : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (authors:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-basic_ngram-fuzzyeq-edit-distance.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_ngram-fuzzyeq-edit-distance.adm"; set `simfunction` `edit-distance`; set `simthreshold` `1`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-fuzzyeq-jaccard.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-fuzzyeq-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-fuzzyeq-jaccard.sqlpp index 07a919f..7c488d1 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-fuzzyeq-jaccard.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-fuzzyeq-jaccard.sqlpp @@ -36,13 +36,13 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (title:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-basic_ngram-fuzzyeq-jaccard.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_ngram-fuzzyeq-jaccard.adm"; set `simfunction` `jaccard`; set `simthreshold` `0.8f`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-jaccard-check.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-jaccard-check.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-jaccard-check.sqlpp index 3fe77a2..240f372 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-jaccard-check.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-jaccard-check.sqlpp @@ -36,13 +36,13 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (title:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-basic_ngram-jaccard-check.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_ngram-jaccard-check.adm"; select element o from DBLP as o where test.`similarity-jaccard-check`(test.`gram-tokens`(o.title,3,false),test.`gram-tokens`('Transactions for Cooperative Environments',3,false),0.500000f)[0] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-jaccard.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-jaccard.sqlpp index b5f5b47..28af41e 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-jaccard.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-jaccard.sqlpp @@ -36,13 +36,13 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (title:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-basic_ngram-jaccard.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_ngram-jaccard.adm"; select element o from DBLP as o where (test.`similarity-jaccard`(test.`gram-tokens`(o.title,3,false),test.`gram-tokens`('Transactions for Cooperative Environments',3,false)) >= 0.500000f) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/word-contains.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/word-contains.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/word-contains.sqlpp index d835866..2e26b98 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/word-contains.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/word-contains.sqlpp @@ -34,13 +34,13 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index keyword_index on DBLP (title:string?) type keyword enforced; -write output to asterix_nc1:"rttest/inverted-index-basic_word-contains.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_word-contains.adm"; select element o from DBLP as o where test.contains(o.title,'Multimedia') http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/word-fuzzyeq-jaccard.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/word-fuzzyeq-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/word-fuzzyeq-jaccard.sqlpp index 7ca803d..c905a53 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/word-fuzzyeq-jaccard.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/word-fuzzyeq-jaccard.sqlpp @@ -34,13 +34,13 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index keyword_index on DBLP (title:string?) type keyword enforced; -write output to asterix_nc1:"rttest/inverted-index-basic_word-fuzzyeq-jaccard.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_word-fuzzyeq-jaccard.adm"; set `simfunction` `jaccard`; set `simthreshold` `0.5f`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/word-jaccard-check.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/word-jaccard-check.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/word-jaccard-check.sqlpp index f3720d6..fd0a151 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/word-jaccard-check.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/word-jaccard-check.sqlpp @@ -34,13 +34,13 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index keyword_index on DBLP (title:string?) type keyword enforced; -write output to asterix_nc1:"rttest/inverted-index-basic_word-jaccard-check.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_word-jaccard-check.adm"; select element o from DBLP as o where test.`similarity-jaccard-check`(test.`word-tokens`(o.title),test.`word-tokens`('Transactions for Cooperative Environments'),0.500000f)[0] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/word-jaccard.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/word-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/word-jaccard.sqlpp index f2539ec..b3ef666 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/word-jaccard.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/word-jaccard.sqlpp @@ -34,13 +34,13 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index keyword_index on DBLP (title:string?) type keyword enforced; -write output to asterix_nc1:"rttest/inverted-index-basic_word-jaccard.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_word-jaccard.adm"; select element o from DBLP as o where (test.`similarity-jaccard`(test.`word-tokens`(o.title),test.`word-tokens`('Transactions for Cooperative Environments')) >= 0.500000f) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_01.sqlpp index b132947..e569be8 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_01.sqlpp @@ -36,13 +36,13 @@ create type test.DBLPType as dblpid : string, title : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (authors:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let-panic-nopanic_01.adm" +write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let-panic-nopanic_01.adm"; select element o from DBLP as o with eda as test.`edit-distance-check`(o.authors,'Amihay Motro',3), http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_02.sqlpp index e5d3e0c..c2402bc 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_02.sqlpp @@ -36,13 +36,13 @@ create type test.DBLPType as dblpid : string, title : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (authors:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let-panic-nopanic_01.adm" +write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let-panic-nopanic_01.adm"; select element o from DBLP as o with edb as test.`edit-distance-check`(o.authors,'Amihay Motro',5), http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-let-panic.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-let-panic.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-let-panic.sqlpp index 7c3359a..30f29e2 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-let-panic.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-let-panic.sqlpp @@ -35,13 +35,13 @@ create type test.DBLPType as dblpid : string, title : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (authors:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let-panic.adm" +write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let-panic.adm"; select element o from DBLP as o with ed as test.`edit-distance-check`(o.authors,'Amihay Motro',5) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-let.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-let.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-let.sqlpp index 73b651d..bbb060d 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-let.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-let.sqlpp @@ -35,13 +35,13 @@ create type test.DBLPType as dblpid : string, title : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (authors:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let.adm" +write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let.adm"; select element o from DBLP as o with ed as test.`edit-distance-check`(o.authors,'Amihay Motro',1) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-substring.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-substring.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-substring.sqlpp index 9dcef5f..0b6b09c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-substring.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-substring.sqlpp @@ -35,13 +35,13 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (title:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-substring.adm" +write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-substring.adm"; select element {'id':paper.id,'title':paper.title} from DBLP as paper where test.`edit-distance-check`(test.substring(paper.title,0,8),'datbase',1)[0] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-word-tokens.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-word-tokens.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-word-tokens.sqlpp index 7c7134e..dec3c89 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-word-tokens.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-edit-distance-check-word-tokens.sqlpp @@ -35,13 +35,13 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (title:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-word-tokens.adm" +write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-word-tokens.adm"; select element {'id':paper.id,'title':paper.title} from DBLP as paper, test.`word-tokens`(paper.title) as word http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-jaccard-check-let.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-jaccard-check-let.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-jaccard-check-let.sqlpp index 1079aea..8e726f1 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-jaccard-check-let.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-jaccard-check-let.sqlpp @@ -37,13 +37,13 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (title:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-complex_ngram-jaccard-check-let.adm" +write output to asterix_nc1:"rttest/inverted-index-complex_ngram-jaccard-check-let.adm"; select element o from DBLP as o with jacc as test.`similarity-jaccard-check`(test.`gram-tokens`(o.title,3,false),test.`gram-tokens`('Transactions for Cooperative Environments',3,false),0.500000f) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-jaccard-check-multi-let.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-jaccard-check-multi-let.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-jaccard-check-multi-let.sqlpp index 3c33a4d..9353af4 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-jaccard-check-multi-let.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/ngram-jaccard-check-multi-let.sqlpp @@ -37,13 +37,13 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (title:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-complex_ngram-jaccard-check-multi-let.adm" +write output to asterix_nc1:"rttest/inverted-index-complex_ngram-jaccard-check-multi-let.adm"; select element {'Paper':paper_tokens,'Query':query_tokens} from DBLP as paper with paper_tokens as test.`gram-tokens`(paper.title,3,false), http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/word-jaccard-check-let.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/word-jaccard-check-let.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/word-jaccard-check-let.sqlpp index 3dfa3d6..992bf64 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/word-jaccard-check-let.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/word-jaccard-check-let.sqlpp @@ -35,13 +35,13 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index keyword_index on DBLP (title:string?) type keyword enforced; -write output to asterix_nc1:"rttest/inverted-index-complex_word-jaccard-check-let.adm" +write output to asterix_nc1:"rttest/inverted-index-complex_word-jaccard-check-let.adm"; select element o from DBLP as o with jacc as test.`similarity-jaccard-check`(test.`word-tokens`(o.title),test.`word-tokens`('Transactions for Cooperative Environments'),0.500000f) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/word-jaccard-check-multi-let.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/word-jaccard-check-multi-let.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/word-jaccard-check-multi-let.sqlpp index 42a3228..168e1d3 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/word-jaccard-check-multi-let.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-complex/word-jaccard-check-multi-let.sqlpp @@ -35,13 +35,13 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index keyword_index on DBLP (title:string?) type keyword enforced; -write output to asterix_nc1:"rttest/inverted-index-complex_word-jaccard-check-multi-let.adm" +write output to asterix_nc1:"rttest/inverted-index-complex_word-jaccard-check-multi-let.adm"; select element {'Paper':paper_tokens,'Query':query_tokens} from DBLP as paper with paper_tokens as test.`word-tokens`(paper.title), http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/leftouterjoin-probe-pidx-with-join-edit-distance-check-idx_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/leftouterjoin-probe-pidx-with-join-edit-distance-check-idx_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/leftouterjoin-probe-pidx-with-join-edit-distance-check-idx_01.sqlpp index 19fe8d7..34e2503 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/leftouterjoin-probe-pidx-with-join-edit-distance-check-idx_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/leftouterjoin-probe-pidx-with-join-edit-distance-check-idx_01.sqlpp @@ -37,7 +37,7 @@ create type test.TwitterUserType as `statuses-count` : integer, name : string, `followers-count` : integer -} +}; create type test.TweetMessageType as { @@ -48,13 +48,13 @@ create type test.TweetMessageType as `referred-topics` : {{string}}, countA : integer, countB : integer -} +}; create dataset TweetMessages(TweetMessageType) primary key tweetid; create index msgNgramIx on TweetMessages (`message-text`:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_leftouterjoin-probe-pidx-with-join-edit-distance-check_idx_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_leftouterjoin-probe-pidx-with-join-edit-distance-check_idx_01.adm"; select element {'tweet':{'id':t1.tweetid,'topics':t1.`message-text`},'similar-tweets':( select element {'id':t2.tweetid,'topics':t2.`message-text`} from TweetMessages as t2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-contains_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-contains_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-contains_01.sqlpp index 8116300..cae1003 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-contains_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-contains_01.sqlpp @@ -33,7 +33,7 @@ create type test.DBLPType as id : integer, dblpid : string, misc : string -} +}; create type test.CSXType as closed { @@ -42,7 +42,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -50,7 +50,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on DBLP (title:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-contains-01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-contains-01.adm"; select element {'title1':o1.title,'title2':o2.title} from DBLP as o1, CSX as o2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-contains_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-contains_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-contains_02.sqlpp index cf22b7b..2ee4da7 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-contains_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-contains_02.sqlpp @@ -34,7 +34,7 @@ create type test.DBLPType as dblpid : string, title : string, misc : string -} +}; create type test.CSXType as { @@ -42,7 +42,7 @@ create type test.CSXType as csxid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -50,7 +50,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on CSX (title:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-contains-02.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-contains-02.adm"; select element {'title1':o1.title,'title2':o2.title} from DBLP as o1, CSX as o2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-contains_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-contains_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-contains_03.sqlpp index 056eed9..a489041 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-contains_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-contains_03.sqlpp @@ -34,13 +34,13 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (title:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-contains-03.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-contains-03.adm"; select element {'title1':o1.title,'title2':o2.title} from DBLP as o1, DBLP as o2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-contains_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-contains_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-contains_04.sqlpp index bb9ceac..2bc986c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-contains_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-contains_04.sqlpp @@ -33,7 +33,7 @@ create type test.DBLPType as id : integer, dblpid : string, misc : string -} +}; create type test.CSXType as { @@ -41,7 +41,7 @@ create type test.CSXType as csxid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -51,7 +51,7 @@ create index ngram_index_DBLP on DBLP (title:string?) type ngram (3) enforced; create index ngram_index_CSX on CSX (title:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-contains-04.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-contains-04.adm"; select element {'title1':o1.title,'title2':o2.title} from DBLP as o1, CSX as o2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_01.sqlpp index 6e8947b..48ad150 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_01.sqlpp @@ -34,7 +34,7 @@ create type test.DBLPType as dblpid : string, title : string, misc : string -} +}; create type test.CSXType as closed { @@ -43,7 +43,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -51,7 +51,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on DBLP (authors:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-edit-distance-check_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-edit-distance-check_01.adm"; select element {'arec':a,'brec':b} from DBLP as a, CSX as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_02.sqlpp index 626043f..c07a2f3 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_02.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as { @@ -43,7 +43,7 @@ create type test.CSXType as csxid : string, title : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -51,7 +51,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on CSX (authors:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-edit-distance-check_02.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-edit-distance-check_02.adm"; select element {'arec':a,'brec':b} from DBLP as a, CSX as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_03.sqlpp index e3fab46..82cff81 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_03.sqlpp @@ -34,13 +34,13 @@ create type test.DBLPType as dblpid : string, title : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (authors:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-edit-distance-check_03.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-edit-distance-check_03.adm"; select element {'arec':a,'brec':b} from DBLP as a, DBLP as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_04.sqlpp index 6712b47..c01b607 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_04.sqlpp @@ -34,7 +34,7 @@ create type test.DBLPType as dblpid : string, title : string, misc : string -} +}; create type test.CSXType as { @@ -42,7 +42,7 @@ create type test.CSXType as csxid : string, title : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -52,7 +52,7 @@ create index ngram_index_DBLP on DBLP (authors:string?) type ngram (3) enforce create index ngram_index_CSX on CSX (authors:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-edit-distance-check_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-edit-distance-check_01.adm"; select element {'arec':a,'brec':b} from DBLP as a, CSX as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_05.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_05.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_05.sqlpp index e4dcbf4..3d1c52d 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_05.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_05.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPType as dblpid : string, title : string, misc : string -} +}; create type test.CSXType as { @@ -43,7 +43,7 @@ create type test.CSXType as csxid : string, title : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -51,7 +51,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on DBLP (authors:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-edit-distance-check_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-edit-distance-check_01.adm"; select element {'arec':a,'brec':b} from DBLP as a, CSX as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_inline_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_inline_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_inline_03.sqlpp index be26ff3..1c0104c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_inline_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-check_inline_03.sqlpp @@ -35,13 +35,13 @@ create type test.DBLPType as dblpid : string, title : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (authors:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-edit-distance-check_04.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-edit-distance-check_04.adm"; select element {'arec':a,'brec':b,'ed':ed[1]} from DBLP as a, DBLP as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-contains.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-contains.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-contains.sqlpp index 6b776b2..aabfef6 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-contains.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance-contains.sqlpp @@ -34,7 +34,7 @@ create type test.DBLPType as dblpid : string, title : string, misc : string -} +}; create type test.CSXType as closed { @@ -43,7 +43,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -51,7 +51,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on DBLP (authors:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-edit-distance-contains.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-edit-distance-contains.adm"; select element {'arec':a,'brec':b} from DBLP as a, CSX as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_01.sqlpp index 6dbd135..9d83f4b 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_01.sqlpp @@ -34,7 +34,7 @@ create type test.DBLPType as dblpid : string, title : string, misc : string -} +}; create type test.CSXType as closed { @@ -43,7 +43,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -51,7 +51,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on DBLP (authors:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-edit-distance_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-edit-distance_01.adm"; select element {'arec':a,'brec':b} from DBLP as a, CSX as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_02.sqlpp index 3dd2a00..0a6952c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_02.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as { @@ -43,7 +43,7 @@ create type test.CSXType as csxid : string, title : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -51,7 +51,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on CSX (authors:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-edit-distance_02.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-edit-distance_02.adm"; select element {'arec':a,'brec':b} from DBLP as a, CSX as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_03.sqlpp index e30c47e..e2ac1bb 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_03.sqlpp @@ -34,13 +34,13 @@ create type test.DBLPType as dblpid : string, title : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (authors:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-edit-distance_03.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-edit-distance_03.adm"; select element {'arec':a,'brec':b} from DBLP as a, DBLP as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_04.sqlpp index 444e12d..bcdebcb 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_04.sqlpp @@ -34,7 +34,7 @@ create type test.DBLPType as dblpid : string, title : string, misc : string -} +}; create type test.CSXType as { @@ -42,7 +42,7 @@ create type test.CSXType as csxid : string, title : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -52,7 +52,7 @@ create index ngram_index_DBLP on DBLP (authors:string?) type ngram (3) enforce create index ngram_index_CSX on CSX (authors:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-edit-distance_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-edit-distance_01.adm"; select element {'arec':a,'brec':b} from DBLP as a, CSX as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_05.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_05.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_05.sqlpp index 58370e9..f4d260c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_05.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_05.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPType as dblpid : string, title : string, misc : string -} +}; create type test.CSXType as { @@ -43,7 +43,7 @@ create type test.CSXType as csxid : string, title : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -51,7 +51,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on DBLP (authors:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-edit-distance_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-edit-distance_01.adm"; select element {'arec':a,'brec':b} from DBLP as a, CSX as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_inline_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_inline_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_inline_03.sqlpp index 56ff49e..800cf0c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_inline_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-edit-distance_inline_03.sqlpp @@ -35,13 +35,13 @@ create type test.DBLPType as dblpid : string, title : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (authors:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-edit-distance_03.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-edit-distance_03.adm"; select element {'arec':a,'brec':b,'ed':ed} from DBLP as a, DBLP as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-edit-distance_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-edit-distance_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-edit-distance_01.sqlpp index 6f75efe..c1c1ecb 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-edit-distance_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-edit-distance_01.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as { @@ -43,7 +43,7 @@ create type test.CSXType as csxid : string, title : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -51,7 +51,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on CSX (authors:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-fuzzyeq-edit-distance_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-fuzzyeq-edit-distance_01.adm"; set `simfunction` `edit-distance`; set `simthreshold` `3`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-edit-distance_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-edit-distance_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-edit-distance_02.sqlpp index d8cda0e..1f12373 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-edit-distance_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-edit-distance_02.sqlpp @@ -34,7 +34,7 @@ create type test.DBLPType as dblpid : string, title : string, misc : string -} +}; create type test.CSXType as closed { @@ -43,7 +43,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -51,7 +51,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on DBLP (authors:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-fuzzyeq-edit-distance_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-fuzzyeq-edit-distance_01.adm"; set `simfunction` `edit-distance`; set `simthreshold` `3`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-edit-distance_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-edit-distance_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-edit-distance_03.sqlpp index 1f24f2b..92eb730 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-edit-distance_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-edit-distance_03.sqlpp @@ -34,13 +34,13 @@ create type test.DBLPType as dblpid : string, title : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (authors:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-fuzzyeq-edit-distance_03.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-fuzzyeq-edit-distance_03.adm"; set `simfunction` `edit-distance`; set `simthreshold` `3`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-edit-distance_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-edit-distance_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-edit-distance_04.sqlpp index a45d6cf..f370d4f 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-edit-distance_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-edit-distance_04.sqlpp @@ -34,7 +34,7 @@ create type test.DBLPType as dblpid : string, title : string, misc : string -} +}; create type test.CSXType as { @@ -42,7 +42,7 @@ create type test.CSXType as csxid : string, title : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -52,7 +52,7 @@ create index ngram_index_DBLP on DBLP (authors:string?) type ngram (3) enforce create index ngram_index_CSX on CSX (authors:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-fuzzyeq-edit-distance_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-fuzzyeq-edit-distance_01.adm"; set `simfunction` `edit-distance`; set `simthreshold` `3`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-edit-distance_05.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-edit-distance_05.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-edit-distance_05.sqlpp index a5c2550..36a0d94 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-edit-distance_05.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-edit-distance_05.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPType as dblpid : string, title : string, misc : string -} +}; create type test.CSXType as { @@ -43,7 +43,7 @@ create type test.CSXType as csxid : string, title : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -51,7 +51,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on DBLP (authors:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-fuzzyeq-edit-distance_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-fuzzyeq-edit-distance_01.adm"; set `simfunction` `edit-distance`; set `simthreshold` `3`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-jaccard_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-jaccard_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-jaccard_01.sqlpp index 6366cf5..ada10dc 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-jaccard_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-jaccard_01.sqlpp @@ -36,7 +36,7 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -45,7 +45,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -53,7 +53,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on DBLP (title:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-fuzzyeq-jaccard_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-fuzzyeq-jaccard_01.adm"; set `simfunction` `jaccard`; set `simthreshold` `0.5f`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-jaccard_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-jaccard_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-jaccard_02.sqlpp index 8d39eff..597c77e 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-jaccard_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-jaccard_02.sqlpp @@ -37,7 +37,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as { @@ -45,7 +45,7 @@ create type test.CSXType as csxid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -53,7 +53,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on CSX (title:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-fuzzyeq-jaccard_02.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-fuzzyeq-jaccard_02.adm"; set `simfunction` `jaccard`; set `simthreshold` `0.5f`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-jaccard_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-jaccard_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-jaccard_03.sqlpp index c091978..74bb1a3 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-jaccard_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-jaccard_03.sqlpp @@ -36,13 +36,13 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (title:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-fuzzyeq-jaccard_03.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-fuzzyeq-jaccard_03.adm"; set `simfunction` `jaccard`; set `simthreshold` `0.5f`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-jaccard_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-jaccard_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-jaccard_04.sqlpp index 34206bf..e7d9c64 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-jaccard_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-fuzzyeq-jaccard_04.sqlpp @@ -36,7 +36,7 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create type test.CSXType as { @@ -44,7 +44,7 @@ create type test.CSXType as csxid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -54,7 +54,7 @@ create index ngram_index_DBLP on DBLP (title:string?) type ngram (3) enforced; create index ngram_index_CSX on CSX (title:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-fuzzyeq-jaccard_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-fuzzyeq-jaccard_01.adm"; set `simfunction` `jaccard`; set `simthreshold` `0.5f`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard-check_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard-check_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard-check_01.sqlpp index aef97a9..611df16 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard-check_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard-check_01.sqlpp @@ -36,7 +36,7 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -45,7 +45,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -53,7 +53,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on DBLP (title:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard-check_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard-check_01.adm"; select element {'arec':a,'brec':b} from DBLP as a, CSX as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard-check_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard-check_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard-check_02.sqlpp index ed2277b..eabf59e 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard-check_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard-check_02.sqlpp @@ -37,7 +37,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as { @@ -45,7 +45,7 @@ create type test.CSXType as csxid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -53,7 +53,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on CSX (title:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard-check_02.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard-check_02.adm"; select element {'arec':a,'brec':b} from DBLP as a, CSX as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard-check_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard-check_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard-check_03.sqlpp index 13b3126..0f1ab7d 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard-check_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard-check_03.sqlpp @@ -36,13 +36,13 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (title:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard-check_03.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard-check_03.adm"; select element {'arec':a,'brec':b} from DBLP as a, DBLP as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard-check_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard-check_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard-check_04.sqlpp index 49f4a14..813e661 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard-check_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard-check_04.sqlpp @@ -36,7 +36,7 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create type test.CSXType as { @@ -44,7 +44,7 @@ create type test.CSXType as csxid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -54,7 +54,7 @@ create index ngram_index_DBLP on DBLP (title:string?) type ngram (3) enforced; create index ngram_index_CSX on CSX (title:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard-check_02.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard-check_02.adm"; select element {'arec':a,'brec':b} from DBLP as a, CSX as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard-check_inline_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard-check_inline_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard-check_inline_03.sqlpp index c01ad52..8715f04 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard-check_inline_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard-check_inline_03.sqlpp @@ -37,13 +37,13 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (title:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard-check_04.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard-check_04.adm"; select element {'arec':a,'brec':b,'jacc':jacc[1]} from DBLP as a, DBLP as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard_01.sqlpp index 633fe4c..bf74a6f 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard_01.sqlpp @@ -36,7 +36,7 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -45,7 +45,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -53,7 +53,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on DBLP (title:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard_01.adm"; select element {'arec':a,'brec':b} from DBLP as a, CSX as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard_02.sqlpp index fb3274c..6b88146 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard_02.sqlpp @@ -37,7 +37,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as { @@ -45,7 +45,7 @@ create type test.CSXType as csxid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -53,7 +53,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on CSX (title:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard_02.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard_02.adm"; select element {'arec':a,'brec':b} from DBLP as a, CSX as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard_03.sqlpp index 4c34aef..bbfc778 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard_03.sqlpp @@ -36,13 +36,13 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (title:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard_03.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard_03.adm"; select element {'arec':a,'brec':b} from DBLP as a, DBLP as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard_04.sqlpp index 2aa1c1f..c7b2921 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard_04.sqlpp @@ -36,7 +36,7 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create type test.CSXType as { @@ -44,7 +44,7 @@ create type test.CSXType as csxid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -54,7 +54,7 @@ create index ngram_index_DBLP on DBLP (title:string?) type ngram (3) enforced; create index ngram_index_CSX on CSX (title:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard_02.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard_02.adm"; select element {'arec':a,'brec':b} from DBLP as a, CSX as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard_inline_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard_inline_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard_inline_03.sqlpp index 1da54bd..f87cc2b 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard_inline_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/ngram-jaccard_inline_03.sqlpp @@ -37,13 +37,13 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (title:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard_04.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard_04.adm"; select element {'arec':a,'brec':b,'jacc':jacc} from DBLP as a, DBLP as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/word-fuzzyeq-jaccard_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/word-fuzzyeq-jaccard_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/word-fuzzyeq-jaccard_01.sqlpp index 4f80369..2965d41 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/word-fuzzyeq-jaccard_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-join/word-fuzzyeq-jaccard_01.sqlpp @@ -34,7 +34,7 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -43,7 +43,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -51,7 +51,7 @@ create dataset CSX(CSXType) primary key id; create index keyword_index on DBLP (title:string?) type keyword enforced; -write output to asterix_nc1:"rttest/inverted-index-join_word-fuzzyeq-jaccard_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_word-fuzzyeq-jaccard_01.adm"; set `simfunction` `jaccard`; set `simthreshold` `0.5f`;