You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@asterixdb.apache.org by mh...@apache.org on 2017/08/22 10:15:18 UTC
[23/32] asterixdb git commit: [ASTERIXDB-2050][SQL] Enforce a
Semicolon After Each SQL++ Statement
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-substring.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-substring.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-substring.sqlpp
index 4b3d37f..d202b43 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-substring.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-substring.sqlpp
@@ -35,18 +35,18 @@ create type test.DBLPNestedType as
dblpid : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPNestedType
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index ngram_index on DBLP (nested.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.nested.id,'title':paper.nested.title}
from DBLP as paper
where test.`edit-distance-check`(test.substring(paper.nested.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/nested-open-index/inverted-index-complex/ngram-edit-distance-check-word-tokens.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-word-tokens.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-word-tokens.sqlpp
index 455e063..c37ebfd 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-word-tokens.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-word-tokens.sqlpp
@@ -35,18 +35,18 @@ create type test.DBLPNestedType as
dblpid : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPNestedType
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index ngram_index on DBLP (nested.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.nested.id,'title':paper.nested.title}
from DBLP as paper,
test.`word-tokens`(paper.nested.title) as word
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-jaccard-check-let.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-jaccard-check-let.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-jaccard-check-let.sqlpp
index 682e0a3..5ff344c 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-jaccard-check-let.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-jaccard-check-let.sqlpp
@@ -37,18 +37,18 @@ create type test.DBLPTypetmp as
dblpid : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index ngram_index on DBLP (nested.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.nested.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/nested-open-index/inverted-index-complex/ngram-jaccard-check-multi-let.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-jaccard-check-multi-let.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-jaccard-check-multi-let.sqlpp
index e278a98..964dfc0 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-jaccard-check-multi-let.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-jaccard-check-multi-let.sqlpp
@@ -37,18 +37,18 @@ create type test.DBLPTypetmp as
dblpid : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index ngram_index on DBLP (nested.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.nested.title,3,false),
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/word-jaccard-check-let.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/word-jaccard-check-let.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/word-jaccard-check-let.sqlpp
index dc37aec..19dd76d 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/word-jaccard-check-let.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/word-jaccard-check-let.sqlpp
@@ -35,18 +35,18 @@ create type test.DBLPTypetmp as
dblpid : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index keyword_index on DBLP (nested.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.nested.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/nested-open-index/inverted-index-complex/word-jaccard-check-multi-let.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/word-jaccard-check-multi-let.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/word-jaccard-check-multi-let.sqlpp
index f329a09..0a0abb2 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/word-jaccard-check-multi-let.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/word-jaccard-check-multi-let.sqlpp
@@ -35,18 +35,18 @@ create type test.DBLPTypetmp as
dblpid : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index keyword_index on DBLP (nested.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.nested.title),
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/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/nested-open-index/inverted-index-join/leftouterjoin-probe-pidx-with-join-edit-distance-check-idx_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/leftouterjoin-probe-pidx-with-join-edit-distance-check-idx_01.sqlpp
index d95919f..70e727e 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/leftouterjoin-probe-pidx-with-join-edit-distance-check-idx_01.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/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.TweetMessageNestedType as
{
@@ -48,18 +48,18 @@ create type test.TweetMessageNestedType as
`referred-topics` : {{string}},
countA : integer,
countB : integer
-}
+};
create type test.TweetMessageType as
{
nested : TweetMessageNestedType
-}
+};
create dataset TweetMessages(TweetMessageType) primary key nested.tweetid;
create index msgNgramIx on TweetMessages (nested.`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.nested.tweetid,'topics':t1.nested.`message-text`},'similar-tweets':(
select element {'id':t2.nested.tweetid,'topics':t2.nested.`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/nested-open-index/inverted-index-join/ngram-contains_01.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-contains_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-contains_01.sqlpp
index 8116300..cae1003 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-contains_01.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/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/nested-open-index/inverted-index-join/ngram-contains_02.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-contains_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-contains_02.sqlpp
index aa7515a..9d87160 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-contains_02.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/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 CSX 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/nested-open-index/inverted-index-join/ngram-contains_03.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-contains_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-contains_03.sqlpp
index 056eed9..a489041 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-contains_03.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/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/nested-open-index/inverted-index-join/ngram-contains_04.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-contains_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-contains_04.sqlpp
index bb9ceac..2bc986c 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-contains_04.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/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/nested-open-index/inverted-index-join/ngram-edit-distance-check_01.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-check_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-check_01.sqlpp
index 419f425..f4074f2 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-check_01.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-check_01.sqlpp
@@ -34,7 +34,7 @@ create type test.DBLPTypetmp as
dblpid : string,
title : string,
misc : string
-}
+};
create type test.CSXTypetmp as
closed {
@@ -43,17 +43,17 @@ create type test.CSXTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -61,7 +61,7 @@ create dataset CSX(CSXType) primary key nested.id;
create index ngram_index on DBLP (nested.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/nested-open-index/inverted-index-join/ngram-edit-distance-check_02.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-check_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-check_02.sqlpp
index ea0b7fc..9f3f5c5 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-check_02.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-check_02.sqlpp
@@ -35,7 +35,7 @@ create type test.DBLPTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.CSXTypetmp as
{
@@ -43,17 +43,17 @@ create type test.CSXTypetmp as
csxid : string,
title : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -61,7 +61,7 @@ create dataset CSX(CSXType) primary key nested.id;
create index ngram_index on CSX (nested.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 CSX 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/nested-open-index/inverted-index-join/ngram-edit-distance-check_03.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-check_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-check_03.sqlpp
index ebf9c02..0fbc905 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-check_03.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-check_03.sqlpp
@@ -34,18 +34,18 @@ create type test.DBLPTypetmp as
dblpid : string,
title : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index ngram_index on DBLP (nested.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,
DBLP as b
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-check_04.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-check_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-check_04.sqlpp
index 1011a44..87ece5a 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-check_04.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-check_04.sqlpp
@@ -34,7 +34,7 @@ create type test.DBLPTypetmp as
dblpid : string,
title : string,
misc : string
-}
+};
create type test.CSXTypetmp as
{
@@ -42,17 +42,17 @@ create type test.CSXTypetmp as
csxid : string,
title : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -62,7 +62,7 @@ create index ngram_index_DBLP on DBLP (nested.authors:string?) type ngram (3)
create index ngram_index_CSX on CSX (nested.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/nested-open-index/inverted-index-join/ngram-edit-distance-check_05.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-check_05.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-check_05.sqlpp
index 9775659..c8add3e 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-check_05.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-check_05.sqlpp
@@ -34,7 +34,7 @@ create type test.DBLPTypetmp as
dblpid : string,
title : string,
misc : string
-}
+};
create type test.CSXTypetmp as
{
@@ -42,17 +42,17 @@ create type test.CSXTypetmp as
csxid : string,
title : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -60,7 +60,7 @@ create dataset CSX(CSXType) primary key nested.id;
create index ngram_index on DBLP (nested.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/nested-open-index/inverted-index-join/ngram-edit-distance-contains.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-contains.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-contains.sqlpp
index 2373007..6bf1c72 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-contains.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-contains.sqlpp
@@ -34,7 +34,7 @@ create type test.DBLPTypetmp as
dblpid : string,
title : string,
misc : string
-}
+};
create type test.CSXTypetmp as
closed {
@@ -43,17 +43,17 @@ create type test.CSXTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -61,7 +61,7 @@ create dataset CSX(CSXType) primary key nested.id;
create index ngram_index on DBLP (nested.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/nested-open-index/inverted-index-join/ngram-edit-distance-inline.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-inline.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-inline.sqlpp
index 4d6eed2..0b7f72f 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-inline.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance-inline.sqlpp
@@ -36,18 +36,18 @@ create type test.DBLPTypetmp as
dblpid : string,
title : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index ngram_index on DBLP (nested.authors:string?) type ngram (3) enforced;
-write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_ngram-edit-distance-inline.adm"
+write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_ngram-edit-distance-inline.adm";
select element {'aauthors':a.nested.authors,'bauthors':b.nested.authors,'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/nested-open-index/inverted-index-join/ngram-edit-distance_01.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance_01.sqlpp
index 0c2a41e..661e010 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance_01.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance_01.sqlpp
@@ -34,7 +34,7 @@ create type test.DBLPTypetmp as
dblpid : string,
title : string,
misc : string
-}
+};
create type test.CSXTypetmp as
closed {
@@ -43,17 +43,17 @@ create type test.CSXTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -61,7 +61,7 @@ create dataset CSX(CSXType) primary key nested.id;
create index ngram_index on DBLP (nested.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/nested-open-index/inverted-index-join/ngram-edit-distance_02.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance_02.sqlpp
index 9e46270..3c4e9fe 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance_02.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance_02.sqlpp
@@ -35,7 +35,7 @@ create type test.DBLPTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.CSXTypetmp as
{
@@ -43,17 +43,17 @@ create type test.CSXTypetmp as
csxid : string,
title : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -61,7 +61,7 @@ create dataset CSX(CSXType) primary key nested.id;
create index ngram_index on CSX (nested.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 CSX 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/nested-open-index/inverted-index-join/ngram-edit-distance_03.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance_03.sqlpp
index 0a1bcf7..e4d138e 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance_03.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance_03.sqlpp
@@ -34,18 +34,18 @@ create type test.DBLPTypetmp as
dblpid : string,
title : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index ngram_index on DBLP (nested.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,
DBLP as b
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance_04.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance_04.sqlpp
index 8c2b515..08d9808 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance_04.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance_04.sqlpp
@@ -34,7 +34,7 @@ create type test.DBLPTypetmp as
dblpid : string,
title : string,
misc : string
-}
+};
create type test.CSXTypetmp as
{
@@ -42,17 +42,17 @@ create type test.CSXTypetmp as
csxid : string,
title : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -62,7 +62,7 @@ create index ngram_index_DBLP on DBLP (nested.authors:string?) type ngram (3)
create index ngram_index_CSX on CSX (nested.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/nested-open-index/inverted-index-join/ngram-edit-distance_05.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance_05.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance_05.sqlpp
index 9b68a89..19132a1 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance_05.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-edit-distance_05.sqlpp
@@ -34,7 +34,7 @@ create type test.DBLPTypetmp as
dblpid : string,
title : string,
misc : string
-}
+};
create type test.CSXTypetmp as
{
@@ -42,17 +42,17 @@ create type test.CSXTypetmp as
csxid : string,
title : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -60,7 +60,7 @@ create dataset CSX(CSXType) primary key nested.id;
create index ngram_index on DBLP (nested.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/nested-open-index/inverted-index-join/ngram-fuzzyeq-edit-distance_01.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-edit-distance_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-edit-distance_01.sqlpp
index 9e2c69f..a6f12a1 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-edit-distance_01.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-edit-distance_01.sqlpp
@@ -34,7 +34,7 @@ create type test.DBLPTypetmp as
dblpid : string,
title : string,
misc : string
-}
+};
create type test.CSXTypetmp as
closed {
@@ -43,17 +43,17 @@ create type test.CSXTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -61,7 +61,7 @@ create dataset CSX(CSXType) primary key nested.id;
create index ngram_index on DBLP (nested.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/nested-open-index/inverted-index-join/ngram-fuzzyeq-edit-distance_02.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-edit-distance_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-edit-distance_02.sqlpp
index 5eb7f01..5326185 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-edit-distance_02.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-edit-distance_02.sqlpp
@@ -35,7 +35,7 @@ create type test.DBLPTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.CSXTypetmp as
{
@@ -43,17 +43,17 @@ create type test.CSXTypetmp as
csxid : string,
title : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -61,7 +61,7 @@ create dataset CSX(CSXType) primary key nested.id;
create index ngram_index on CSX (nested.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/nested-open-index/inverted-index-join/ngram-fuzzyeq-edit-distance_03.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-edit-distance_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-edit-distance_03.sqlpp
index e5b4b83..a2af936 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-edit-distance_03.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-edit-distance_03.sqlpp
@@ -34,18 +34,18 @@ create type test.DBLPTypetmp as
dblpid : string,
title : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index ngram_index on DBLP (nested.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/nested-open-index/inverted-index-join/ngram-fuzzyeq-edit-distance_04.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-edit-distance_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-edit-distance_04.sqlpp
index 61df0a5..68c4619 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-edit-distance_04.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-edit-distance_04.sqlpp
@@ -34,7 +34,7 @@ create type test.DBLPTypetmp as
dblpid : string,
title : string,
misc : string
-}
+};
create type test.CSXTypetmp as
{
@@ -42,17 +42,17 @@ create type test.CSXTypetmp as
csxid : string,
title : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -62,7 +62,7 @@ create index ngram_index_DBLP on DBLP (nested.authors:string?) type ngram (3)
create index ngram_index_CSX on CSX (nested.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/nested-open-index/inverted-index-join/ngram-fuzzyeq-edit-distance_05.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-edit-distance_05.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-edit-distance_05.sqlpp
index 83fd6bd..d8d417b 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-edit-distance_05.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-edit-distance_05.sqlpp
@@ -34,7 +34,7 @@ create type test.DBLPTypetmp as
dblpid : string,
title : string,
misc : string
-}
+};
create type test.CSXTypetmp as
{
@@ -42,17 +42,17 @@ create type test.CSXTypetmp as
csxid : string,
title : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -60,7 +60,7 @@ create dataset CSX(CSXType) primary key nested.id;
create index ngram_index on CSX (nested.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/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_01.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_01.sqlpp
index 27dfe8c..51da2ab 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_01.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_01.sqlpp
@@ -36,7 +36,7 @@ create type test.DBLPTypetmp as
dblpid : string,
authors : string,
misc : string
-}
+};
create type test.CSXTypetmp as
closed {
@@ -45,17 +45,17 @@ create type test.CSXTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -63,7 +63,7 @@ create dataset CSX(CSXType) primary key nested.id;
create index ngram_index on DBLP (nested.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/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_02.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_02.sqlpp
index 7038239..efe0ae7 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_02.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_02.sqlpp
@@ -37,7 +37,7 @@ create type test.DBLPTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.CSXTypetmp as
{
@@ -45,17 +45,17 @@ create type test.CSXTypetmp as
csxid : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -63,7 +63,7 @@ create dataset CSX(CSXType) primary key nested.id;
create index ngram_index on CSX (nested.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/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_03.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_03.sqlpp
index 7313ef2..ccec588 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_03.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_03.sqlpp
@@ -36,18 +36,18 @@ create type test.DBLPTypetmp as
dblpid : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index ngram_index on DBLP (nested.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/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_04.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_04.sqlpp
index 3ea7aca..379b7eb 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_04.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_04.sqlpp
@@ -36,7 +36,7 @@ create type test.DBLPTypetmp as
dblpid : string,
authors : string,
misc : string
-}
+};
create type test.CSXTypetmp as
{
@@ -44,17 +44,17 @@ create type test.CSXTypetmp as
csxid : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -64,7 +64,7 @@ create index ngram_index_DBLP on DBLP (nested.title:string?) type ngram (3) en
create index ngram_index_CSX on CSX (nested.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/nested-open-index/inverted-index-join/ngram-jaccard-check_01.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard-check_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard-check_01.sqlpp
index 199c3c5..f1d7467 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard-check_01.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard-check_01.sqlpp
@@ -36,7 +36,7 @@ create type test.DBLPTypetmp as
dblpid : string,
authors : string,
misc : string
-}
+};
create type test.CSXTypetmp as
closed {
@@ -45,17 +45,17 @@ create type test.CSXTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -63,7 +63,7 @@ create dataset CSX(CSXType) primary key nested.id;
create index ngram_index on DBLP (nested.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/nested-open-index/inverted-index-join/ngram-jaccard-check_02.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard-check_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard-check_02.sqlpp
index 057b5dc..6a3ade7 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard-check_02.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard-check_02.sqlpp
@@ -37,7 +37,7 @@ create type test.DBLPTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.CSXTypetmp as
{
@@ -45,17 +45,17 @@ create type test.CSXTypetmp as
csxid : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -63,7 +63,7 @@ create dataset CSX(CSXType) primary key nested.id;
create index ngram_index on CSX (nested.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 CSX 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/nested-open-index/inverted-index-join/ngram-jaccard-check_03.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard-check_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard-check_03.sqlpp
index 3feddf8..cb5c545 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard-check_03.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard-check_03.sqlpp
@@ -36,18 +36,18 @@ create type test.DBLPTypetmp as
dblpid : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index ngram_index on DBLP (nested.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,
DBLP as b
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard-check_04.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard-check_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard-check_04.sqlpp
index 9f255b7..204f77e 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard-check_04.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard-check_04.sqlpp
@@ -36,7 +36,7 @@ create type test.DBLPTypetmp as
dblpid : string,
authors : string,
misc : string
-}
+};
create type test.CSXTypetmp as
{
@@ -44,17 +44,17 @@ create type test.CSXTypetmp as
csxid : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -64,7 +64,7 @@ create index ngram_index_DBLP on DBLP (nested.title:string?) type ngram (3) en
create index ngram_index_CSX on CSX (nested.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/nested-open-index/inverted-index-join/ngram-jaccard-inline.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard-inline.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard-inline.sqlpp
index 0b34fd8..288be03 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard-inline.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard-inline.sqlpp
@@ -38,18 +38,18 @@ create type test.DBLPTypetmp as
dblpid : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index ngram_index on DBLP (nested.title:string?) type ngram (3) enforced;
-write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_ngram-jaccard-inline.adm"
+write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_ngram-jaccard-inline.adm";
select element {'atitle':a.nested.title,'btitle':b.nested.title,'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/nested-open-index/inverted-index-join/ngram-jaccard_01.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard_01.sqlpp
index ad47867..dc85897 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard_01.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard_01.sqlpp
@@ -36,7 +36,7 @@ create type test.DBLPTypetmp as
dblpid : string,
authors : string,
misc : string
-}
+};
create type test.CSXTypetmp as
closed {
@@ -45,17 +45,17 @@ create type test.CSXTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -63,7 +63,7 @@ create dataset CSX(CSXType) primary key nested.id;
create index ngram_index on DBLP (nested.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/nested-open-index/inverted-index-join/ngram-jaccard_02.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard_02.sqlpp
index 42ecfd0..2360a60 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard_02.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard_02.sqlpp
@@ -37,7 +37,7 @@ create type test.DBLPTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.CSXTypetmp as
{
@@ -45,17 +45,17 @@ create type test.CSXTypetmp as
csxid : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -63,7 +63,7 @@ create dataset CSX(CSXType) primary key nested.id;
create index ngram_index on CSX (nested.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 CSX 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/nested-open-index/inverted-index-join/ngram-jaccard_03.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard_03.sqlpp
index d57230e..c65fe7f 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard_03.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard_03.sqlpp
@@ -36,18 +36,18 @@ create type test.DBLPTypetmp as
dblpid : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index ngram_index on DBLP (nested.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,
DBLP as b
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard_04.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard_04.sqlpp
index 7cc7819..bbbcada 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard_04.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/ngram-jaccard_04.sqlpp
@@ -36,7 +36,7 @@ create type test.DBLPTypetmp as
dblpid : string,
authors : string,
misc : string
-}
+};
create type test.CSXTypetmp as
{
@@ -44,17 +44,17 @@ create type test.CSXTypetmp as
csxid : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -64,7 +64,7 @@ create index ngram_index_DBLP on DBLP (nested.title:string?) type ngram (3) en
create index ngram_index_CSX on CSX (nested.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/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_01.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_01.sqlpp
index 396ed40..dcd9bf9 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_01.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_01.sqlpp
@@ -34,7 +34,7 @@ create type test.DBLPTypetmp as
dblpid : string,
authors : string,
misc : string
-}
+};
create type test.CSXTypetmp as
closed {
@@ -43,17 +43,17 @@ create type test.CSXTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -61,7 +61,7 @@ create dataset CSX(CSXType) primary key nested.id;
create index keyword_index on DBLP (nested.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`;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_02.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_02.sqlpp
index 14ac42b..f469132 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_02.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_02.sqlpp
@@ -35,7 +35,7 @@ create type test.DBLPTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.CSXTypetmp as
{
@@ -43,17 +43,17 @@ create type test.CSXTypetmp as
csxid : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -61,7 +61,7 @@ create dataset CSX(CSXType) primary key nested.id;
create index keyword_index on CSX (nested.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`;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_03.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_03.sqlpp
index e12c6d9..f3fbf21 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_03.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_03.sqlpp
@@ -34,18 +34,18 @@ create type test.DBLPTypetmp as
dblpid : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index keyword_index on DBLP (nested.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`;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_04.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_04.sqlpp
index 265af81..f63503d 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_04.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_04.sqlpp
@@ -34,7 +34,7 @@ create type test.DBLPTypetmp as
dblpid : string,
authors : string,
misc : string
-}
+};
create type test.CSXTypetmp as
{
@@ -42,17 +42,17 @@ create type test.CSXTypetmp as
csxid : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -62,7 +62,7 @@ create index keyword_index_DBLP on DBLP (nested.title:string?) type keyword en
create index keyword_index_CSX on CSX (nested.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`;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard-check-after-btree-access.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard-check-after-btree-access.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard-check-after-btree-access.sqlpp
index 13c2eab..6896d96 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard-check-after-btree-access.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard-check-after-btree-access.sqlpp
@@ -38,7 +38,7 @@ create type test.TwitterUserType as
`statuses-count` : integer,
name : string,
`followers-count` : integer
-}
+};
create type test.TweetMessageNestedType as
{
@@ -49,12 +49,12 @@ create type test.TweetMessageNestedType as
`referred-topics` : {{string}},
countA : integer,
countB : integer
-}
+};
create type test.TweetMessageType as
closed {
nested : TweetMessageNestedType
-}
+};
create dataset TweetMessages(TweetMessageType) primary key nested.tweetid;
@@ -66,7 +66,7 @@ create index msgCountBIx on TweetMessages (nested.countB) type btree;
create index msgTextIx on TweetMessages (nested.`message-text`:string?) type keyword enforced;
-write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard-check-after-btree-access.adm"
+write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard-check-after-btree-access.adm";
select element {'t1':t1.nested.tweetid,'t2':t2.nested.tweetid,'sim':sim[1]}
from TweetMessages as t1,
TweetMessages as t2
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard-check_01.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard-check_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard-check_01.sqlpp
index 1ddd310..86aeb19 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard-check_01.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard-check_01.sqlpp
@@ -34,7 +34,7 @@ create type test.DBLPTypetmp as
dblpid : string,
authors : string,
misc : string
-}
+};
create type test.CSXTypetmp as
closed {
@@ -43,17 +43,17 @@ create type test.CSXTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -61,7 +61,7 @@ create dataset CSX(CSXType) primary key nested.id;
create index keyword_index on DBLP (nested.title:string?) type keyword enforced;
-write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard-check_01.adm"
+write output to asterix_nc1:"rttest/inverted-index-join_word-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/nested-open-index/inverted-index-join/word-jaccard-check_02.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard-check_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard-check_02.sqlpp
index 5b17582..2f0c0ae 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard-check_02.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard-check_02.sqlpp
@@ -35,7 +35,7 @@ create type test.DBLPTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.CSXTypetmp as
{
@@ -43,17 +43,17 @@ create type test.CSXTypetmp as
csxid : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -61,7 +61,7 @@ create dataset CSX(CSXType) primary key nested.id;
create index keyword_index on CSX (nested.title:string?) type keyword enforced;
-write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard-check_01.adm"
+write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard-check_01.adm";
select element {'arec':a,'brec':b}
from CSX 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/nested-open-index/inverted-index-join/word-jaccard-check_03.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard-check_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard-check_03.sqlpp
index e47df3f..e4974c1 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard-check_03.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard-check_03.sqlpp
@@ -34,18 +34,18 @@ create type test.DBLPTypetmp as
dblpid : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index keyword_index_DBLP on DBLP (nested.title:string?) type keyword enforced;
-write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard-check_01.adm"
+write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard-check_01.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/nested-open-index/inverted-index-join/word-jaccard-check_04.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard-check_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard-check_04.sqlpp
index f3a42fb..c7a5c1a 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard-check_04.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard-check_04.sqlpp
@@ -34,7 +34,7 @@ create type test.DBLPTypetmp as
dblpid : string,
authors : string,
misc : string
-}
+};
create type test.CSXTypetmp as
{
@@ -42,17 +42,17 @@ create type test.CSXTypetmp as
dblpid : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -62,7 +62,7 @@ create index keyword_index on DBLP (nested.title:string?) type keyword enforce
create index keyword_index on CSX (nested.title:string?) type keyword enforced;
-write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard-check_01.adm"
+write output to asterix_nc1:"rttest/inverted-index-join_word-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/nested-open-index/inverted-index-join/word-jaccard-inline.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard-inline.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard-inline.sqlpp
index a8fac65..bacc15e 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard-inline.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard-inline.sqlpp
@@ -36,18 +36,18 @@ create type test.DBLPTypetmp as
dblpid : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index keyword_index on DBLP (nested.title:string?) type keyword enforced;
-write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_word-jaccard-inline.adm"
+write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_word-jaccard-inline.adm";
select element {'atitle':a.nested.title,'btitle':b.nested.title,'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/nested-open-index/inverted-index-join/word-jaccard_01.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard_01.sqlpp
index e08b76b..f9a31b3 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard_01.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard_01.sqlpp
@@ -34,7 +34,7 @@ create type test.DBLPTypetmp as
dblpid : string,
authors : string,
misc : string
-}
+};
create type test.CSXTypetmp as
closed {
@@ -43,17 +43,17 @@ create type test.CSXTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -61,7 +61,7 @@ create dataset CSX(CSXType) primary key nested.id;
create index keyword_index on DBLP (nested.title:string?) type keyword enforced;
-write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard_01.adm"
+write output to asterix_nc1:"rttest/inverted-index-join_word-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/nested-open-index/inverted-index-join/word-jaccard_02.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard_02.sqlpp
index 827fc48..e696010 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard_02.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard_02.sqlpp
@@ -35,7 +35,7 @@ create type test.DBLPTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.CSXTypetmp as
{
@@ -43,17 +43,17 @@ create type test.CSXTypetmp as
csxid : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create type test.CSXType as
closed {
nested : CSXTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
@@ -61,7 +61,7 @@ create dataset CSX(CSXType) primary key nested.id;
create index keyword_index on CSX (nested.title:string?) type keyword enforced;
-write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard_01.adm"
+write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard_01.adm";
select element {'arec':a,'brec':b}
from CSX 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/nested-open-index/inverted-index-join/word-jaccard_03.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard_03.sqlpp
index a93396f..745949e 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard_03.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard_03.sqlpp
@@ -34,18 +34,18 @@ create type test.DBLPTypetmp as
dblpid : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index keyword_index on DBLP (nested.title:string?) type keyword enforced;
-write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard_01.adm"
+write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard_01.adm";
select element {'arec':a,'brec':b}
from DBLP as a,
DBLP as b