http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/issue741.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/issue741.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/issue741.sqlpp index 66c5fb9..5a312b3 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/issue741.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/issue741.sqlpp @@ -37,7 +37,7 @@ create type test.TwitterUserType as statuses_count : integer, name : string, followers_count : integer -} +}; create type test.TweetMessageType as { @@ -47,13 +47,13 @@ create type test.TweetMessageType as send_time : datetime, referred_topics : {{string}}, message_text : string -} +}; create dataset TweetMessages(TweetMessageType) primary key tweetid; create index topicIIx on TweetMessages (referred_topics) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_issue741.adm" +write output to asterix_nc1:"rttest/inverted-index-join_issue741.adm"; select element {'tweet':t.tweetid,'similar-tweets':( select element t2.tweetid from TweetMessages as t2
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/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/inverted-index-join/leftouterjoin-probe-pidx-with-join-edit-distance-check-idx_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/leftouterjoin-probe-pidx-with-join-edit-distance-check-idx_01.sqlpp index e66adef..8c2869f 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/leftouterjoin-probe-pidx-with-join-edit-distance-check-idx_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/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 closed { @@ -49,7 +49,7 @@ create type test.TweetMessageType as `message-text` : string, countA : integer, countB : integer -} +}; create dataset TweetMessages(TweetMessageType) primary key tweetid; @@ -65,7 +65,7 @@ create index msgNgramIx on TweetMessages (`message-text`) type ngram (3); create index topicKeywordIx on TweetMessages (`referred-topics`) type keyword; -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/inverted-index-join/leftouterjoin-probe-pidx-with-join-jaccard-check-idx_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/leftouterjoin-probe-pidx-with-join-jaccard-check-idx_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/leftouterjoin-probe-pidx-with-join-jaccard-check-idx_01.sqlpp index f3981f9..9db0bd7 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/leftouterjoin-probe-pidx-with-join-jaccard-check-idx_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/leftouterjoin-probe-pidx-with-join-jaccard-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 closed { @@ -49,7 +49,7 @@ create type test.TweetMessageType as `message-text` : string, countA : integer, countB : integer -} +}; create dataset TweetMessages(TweetMessageType) primary key tweetid; @@ -65,7 +65,7 @@ create index msgNgramIx on TweetMessages (`message-text`) type ngram (3); create index topicKeywordIx on TweetMessages (`referred-topics`) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_leftouterjoin-probe-pidx-with-join-jaccard-check_idx_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_leftouterjoin-probe-pidx-with-join-jaccard-check_idx_01.adm"; select element {'tweet':{'id':t1.tweetid,'topics':t1.`referred-topics`},'similar-tweets':( select element {'id':t2.tweetid,'topics':t2.`referred-topics`} from TweetMessages as t2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-contains.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-contains.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-contains.sqlpp index a17a215..ebec6c0 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-contains.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-contains.sqlpp @@ -35,13 +35,13 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (title) type ngram (3); -write output to asterix_nc1:"rttest/inverted-index-join_ngram-contains.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ngram-contains.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/inverted-index-join/ngram-edit-distance-check_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance-check_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance-check_01.sqlpp index 836e150..04cc151 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance-check_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance-check_01.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -44,7 +44,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -52,7 +52,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on DBLP (authors) type ngram (3); -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/inverted-index-join/ngram-edit-distance-check_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance-check_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance-check_02.sqlpp index 162ad16..a6ade32 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance-check_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/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 closed { @@ -44,7 +44,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -52,7 +52,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on CSX (authors) type ngram (3); -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/inverted-index-join/ngram-edit-distance-check_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance-check_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance-check_03.sqlpp index c371ca3..ed8d6b6 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance-check_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance-check_03.sqlpp @@ -35,13 +35,13 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (authors) type ngram (3); -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/inverted-index-join/ngram-edit-distance-check_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance-check_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance-check_04.sqlpp index ae96014..7a24772 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance-check_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance-check_04.sqlpp @@ -36,13 +36,13 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (authors) type ngram (3); -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/inverted-index-join/ngram-edit-distance-contains.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance-contains.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance-contains.sqlpp index 3ebcdb1..ec44939 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance-contains.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance-contains.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -44,7 +44,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -52,7 +52,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on DBLP (authors) type ngram (3); -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/inverted-index-join/ngram-edit-distance_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance_01.sqlpp index 277d76b..e2b15f4 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance_01.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -44,7 +44,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -52,7 +52,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on DBLP (authors) type ngram (3); -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/inverted-index-join/ngram-edit-distance_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance_02.sqlpp index e76e0b9..950a058 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/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 closed { @@ -44,7 +44,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -52,7 +52,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on CSX (authors) type ngram (3); -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/inverted-index-join/ngram-edit-distance_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance_03.sqlpp index 7cf62b8..dc8ca3c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance_03.sqlpp @@ -35,13 +35,13 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (authors) type ngram (3); -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/inverted-index-join/ngram-edit-distance_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance_04.sqlpp index f0f6f65..0284ff4 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-edit-distance_04.sqlpp @@ -36,13 +36,13 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (authors) type ngram (3); -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/inverted-index-join/ngram-fuzzyeq-edit-distance_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-fuzzyeq-edit-distance_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-fuzzyeq-edit-distance_01.sqlpp index a73585e..2021605 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-fuzzyeq-edit-distance_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/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 closed { @@ -44,7 +44,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -52,7 +52,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on CSX (authors) type ngram (3); -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/inverted-index-join/ngram-fuzzyeq-edit-distance_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-fuzzyeq-edit-distance_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-fuzzyeq-edit-distance_02.sqlpp index f6912de..89f1354 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-fuzzyeq-edit-distance_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-fuzzyeq-edit-distance_02.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -44,7 +44,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -52,7 +52,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on DBLP (authors) type ngram (3); -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/inverted-index-join/ngram-fuzzyeq-edit-distance_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-fuzzyeq-edit-distance_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-fuzzyeq-edit-distance_03.sqlpp index 6255c8c..d900a72 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-fuzzyeq-edit-distance_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-fuzzyeq-edit-distance_03.sqlpp @@ -35,13 +35,13 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (authors) type ngram (3); -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/inverted-index-join/ngram-fuzzyeq-jaccard_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-fuzzyeq-jaccard_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-fuzzyeq-jaccard_01.sqlpp index 2116e22..7c08462 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-fuzzyeq-jaccard_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-fuzzyeq-jaccard_01.sqlpp @@ -37,7 +37,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -46,7 +46,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -54,7 +54,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on DBLP (title) type ngram (3); -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/inverted-index-join/ngram-fuzzyeq-jaccard_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-fuzzyeq-jaccard_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-fuzzyeq-jaccard_02.sqlpp index 9d3623b..aac9ca7 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-fuzzyeq-jaccard_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/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 closed { @@ -46,7 +46,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -54,7 +54,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on CSX (title) type ngram (3); -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/inverted-index-join/ngram-fuzzyeq-jaccard_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-fuzzyeq-jaccard_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-fuzzyeq-jaccard_03.sqlpp index fc02f8b..d3bcd49 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-fuzzyeq-jaccard_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-fuzzyeq-jaccard_03.sqlpp @@ -37,13 +37,13 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (title) type ngram (3); -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/inverted-index-join/ngram-jaccard-check_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard-check_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard-check_01.sqlpp index c4a99f8..60a1d7e 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard-check_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard-check_01.sqlpp @@ -37,7 +37,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -46,7 +46,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -54,7 +54,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on DBLP (title) type ngram (3); -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/inverted-index-join/ngram-jaccard-check_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard-check_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard-check_02.sqlpp index 3590c5b..460f1cc 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard-check_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/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 closed { @@ -46,7 +46,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -54,7 +54,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on CSX (title) type ngram (3); -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/inverted-index-join/ngram-jaccard-check_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard-check_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard-check_03.sqlpp index 6e4e9c6..5e180f2 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard-check_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard-check_03.sqlpp @@ -37,13 +37,13 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (title) type ngram (3); -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/inverted-index-join/ngram-jaccard-check_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard-check_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard-check_04.sqlpp index b97087b..2b9aa31 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard-check_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard-check_04.sqlpp @@ -38,13 +38,13 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (title) type ngram (3); -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/inverted-index-join/ngram-jaccard_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard_01.sqlpp index 72ed597..0057551 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard_01.sqlpp @@ -37,7 +37,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -46,7 +46,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -54,7 +54,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on DBLP (title) type ngram (3); -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/inverted-index-join/ngram-jaccard_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard_02.sqlpp index 826466c..a2dc8f2 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/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 closed { @@ -46,7 +46,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -54,7 +54,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on CSX (title) type ngram (3); -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/inverted-index-join/ngram-jaccard_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard_03.sqlpp index 7ebf65c..fbc230c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard_03.sqlpp @@ -37,13 +37,13 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (title) type ngram (3); -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/inverted-index-join/ngram-jaccard_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard_04.sqlpp index 3d24090..5265874 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ngram-jaccard_04.sqlpp @@ -38,13 +38,13 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (title) type ngram (3); -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/inverted-index-join/olist-edit-distance-check_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance-check_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance-check_01.sqlpp index f3936c2..c14501c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance-check_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance-check_01.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,7 +47,7 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; @@ -55,7 +55,7 @@ create dataset Customers2(CustomerType) primary key cid; create index interests_index on Customers (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_olist-edit-distance-check_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_olist-edit-distance-check_01.adm"; select element {'arec':a,'brec':b} from Customers as a, Customers2 as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance-check_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance-check_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance-check_02.sqlpp index 2afae71..f7e6047 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance-check_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance-check_02.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,7 +47,7 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; @@ -55,7 +55,7 @@ create dataset Customers2(CustomerType) primary key cid; create index interests_index on Customers2 (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_olist-edit-distance-check_02.adm" +write output to asterix_nc1:"rttest/inverted-index-join_olist-edit-distance-check_02.adm"; select element {'arec':a,'brec':b} from Customers as a, Customers2 as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance-check_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance-check_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance-check_03.sqlpp index c91bfe8..6435990 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance-check_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance-check_03.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,13 +47,13 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; create index interests_index on Customers (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_olist-edit-distance-check_03.adm" +write output to asterix_nc1:"rttest/inverted-index-join_olist-edit-distance-check_03.adm"; select element {'arec':a,'brec':b} from Customers as a, Customers as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance-check_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance-check_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance-check_04.sqlpp index 4b53454..9f14368 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance-check_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance-check_04.sqlpp @@ -34,7 +34,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -48,13 +48,13 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; create index interests_index on Customers (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_olist-edit-distance-check_04.adm" +write output to asterix_nc1:"rttest/inverted-index-join_olist-edit-distance-check_04.adm"; select element {'arec':a,'brec':b,'ed':ed[1]} from Customers as a, Customers as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance_01.sqlpp index 723baa7..719314e 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance_01.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,7 +47,7 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; @@ -55,7 +55,7 @@ create dataset Customers2(CustomerType) primary key cid; create index interests_index on Customers (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_olist-edit-distance_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_olist-edit-distance_01.adm"; select element {'arec':a,'brec':b} from Customers as a, Customers2 as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance_02.sqlpp index 80a0c53..5ebb518 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance_02.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,7 +47,7 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; @@ -55,7 +55,7 @@ create dataset Customers2(CustomerType) primary key cid; create index interests_index on Customers2 (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_olist-edit-distance_02.adm" +write output to asterix_nc1:"rttest/inverted-index-join_olist-edit-distance_02.adm"; select element {'arec':a,'brec':b} from Customers as a, Customers2 as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance_03.sqlpp index fad377a..ac7e6ba 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance_03.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,13 +47,13 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; create index interests_index on Customers (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_olist-edit-distance_03.adm" +write output to asterix_nc1:"rttest/inverted-index-join_olist-edit-distance_03.adm"; select element {'arec':a,'brec':b} from Customers as a, Customers as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance_04.sqlpp index d64739d..0655746 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-edit-distance_04.sqlpp @@ -34,7 +34,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -48,13 +48,13 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; create index interests_index on Customers (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_olist-edit-distance_04.adm" +write output to asterix_nc1:"rttest/inverted-index-join_olist-edit-distance_04.adm"; select element {'arec':a,'brec':b,'ed':ed} from Customers as a, Customers as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-edit-distance_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-edit-distance_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-edit-distance_01.sqlpp index 1fbf49b..cecfbc9 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-edit-distance_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-edit-distance_01.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,7 +47,7 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; @@ -55,7 +55,7 @@ create dataset Customers2(CustomerType) primary key cid; create index interests_index on Customers (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_olist-fuzzyeq-jaccard_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_olist-fuzzyeq-jaccard_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/inverted-index-join/olist-fuzzyeq-edit-distance_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-edit-distance_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-edit-distance_02.sqlpp index d26182d..cd3d74f 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-edit-distance_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-edit-distance_02.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,7 +47,7 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; @@ -55,7 +55,7 @@ create dataset Customers2(CustomerType) primary key cid; create index interests_index on Customers2 (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_olist-fuzzyeq-jaccard_02.adm" +write output to asterix_nc1:"rttest/inverted-index-join_olist-fuzzyeq-jaccard_02.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/inverted-index-join/olist-fuzzyeq-edit-distance_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-edit-distance_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-edit-distance_03.sqlpp index a77750c..a184602 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-edit-distance_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-edit-distance_03.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,13 +47,13 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; create index interests_index on Customers (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_olist-fuzzyeq-jaccard_03.adm" +write output to asterix_nc1:"rttest/inverted-index-join_olist-fuzzyeq-jaccard_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/inverted-index-join/olist-fuzzyeq-jaccard_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-jaccard_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-jaccard_01.sqlpp index 098fa68..39dde72 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-jaccard_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-jaccard_01.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,7 +47,7 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; @@ -55,7 +55,7 @@ create dataset Customers2(CustomerType) primary key cid; create index interests_index on Customers (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_olist-fuzzyeq-jaccard_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_olist-fuzzyeq-jaccard_01.adm"; set `simfunction` `jaccard`; set `simthreshold` `0.7f`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-jaccard_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-jaccard_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-jaccard_02.sqlpp index e01c162..c1f3af7 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-jaccard_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-jaccard_02.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,7 +47,7 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; @@ -55,7 +55,7 @@ create dataset Customers2(CustomerType) primary key cid; create index interests_index on Customers2 (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_olist-fuzzyeq-jaccard_02.adm" +write output to asterix_nc1:"rttest/inverted-index-join_olist-fuzzyeq-jaccard_02.adm"; set `simfunction` `jaccard`; set `simthreshold` `0.7f`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-jaccard_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-jaccard_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-jaccard_03.sqlpp index 5287ad7..573f5e2 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-jaccard_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-fuzzyeq-jaccard_03.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,13 +47,13 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; create index interests_index on Customers (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_olist-fuzzyeq-jaccard_03.adm" +write output to asterix_nc1:"rttest/inverted-index-join_olist-fuzzyeq-jaccard_03.adm"; set `simfunction` `jaccard`; set `simthreshold` `0.7f`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard-check_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard-check_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard-check_01.sqlpp index f27f727..b67a1af 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard-check_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard-check_01.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,7 +47,7 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; @@ -55,7 +55,7 @@ create dataset Customers2(CustomerType) primary key cid; create index interests_index on Customers (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_olist-jaccard-check_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_olist-jaccard-check_01.adm"; select element {'arec':a,'brec':b} from Customers as a, Customers2 as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard-check_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard-check_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard-check_02.sqlpp index eb5a9fa..c9cbd1c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard-check_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard-check_02.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,7 +47,7 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; @@ -55,7 +55,7 @@ create dataset Customers2(CustomerType) primary key cid; create index interests_index on Customers2 (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_olist-jaccard-check_02.adm" +write output to asterix_nc1:"rttest/inverted-index-join_olist-jaccard-check_02.adm"; select element {'arec':a,'brec':b} from Customers as a, Customers2 as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard-check_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard-check_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard-check_03.sqlpp index c13123e..6364474 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard-check_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard-check_03.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,13 +47,13 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; create index interests_index on Customers (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_olist-jaccard-check_03.adm" +write output to asterix_nc1:"rttest/inverted-index-join_olist-jaccard-check_03.adm"; select element {'arec':a,'brec':b} from Customers as a, Customers as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard-check_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard-check_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard-check_04.sqlpp index 4a54031..bd84396 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard-check_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard-check_04.sqlpp @@ -34,7 +34,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -48,13 +48,13 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; create index interests_index on Customers (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_olist-jaccard-check_04.adm" +write output to asterix_nc1:"rttest/inverted-index-join_olist-jaccard-check_04.adm"; select element {'arec':a,'brec':b,'jacc':jacc[1]} from Customers as a, Customers as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard_01.sqlpp index 214185f..deaecd7 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard_01.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,7 +47,7 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; @@ -55,7 +55,7 @@ create dataset Customers2(CustomerType) primary key cid; create index interests_index on Customers (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_olist-jaccard_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_olist-jaccard_01.adm"; select element {'arec':a,'brec':b} from Customers as a, Customers2 as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard_02.sqlpp index dcbb3fb..b6bea6a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard_02.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,7 +47,7 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; @@ -55,7 +55,7 @@ create dataset Customers2(CustomerType) primary key cid; create index interests_index on Customers2 (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_olist-jaccard_02.adm" +write output to asterix_nc1:"rttest/inverted-index-join_olist-jaccard_02.adm"; select element {'arec':a,'brec':b} from Customers as a, Customers2 as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard_03.sqlpp index 87a6ae1..3359746 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard_03.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,13 +47,13 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; create index interests_index on Customers (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_olist-jaccard_03.adm" +write output to asterix_nc1:"rttest/inverted-index-join_olist-jaccard_03.adm"; select element {'arec':a,'brec':b} from Customers as a, Customers as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard_04.sqlpp index 3c65c4d..941d506 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/olist-jaccard_04.sqlpp @@ -34,7 +34,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -48,13 +48,13 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; create index interests_index on Customers (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_olist-jaccard_04.adm" +write output to asterix_nc1:"rttest/inverted-index-join_olist-jaccard_04.adm"; select element {'arec':a,'brec':b,'jacc':jacc} from Customers as a, Customers as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-fuzzyeq-jaccard_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-fuzzyeq-jaccard_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-fuzzyeq-jaccard_01.sqlpp index ffc00f3..2b42131 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-fuzzyeq-jaccard_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-fuzzyeq-jaccard_01.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,7 +47,7 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; @@ -55,7 +55,7 @@ create dataset Customers2(CustomerType) primary key cid; create index interests_index on Customers (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_ulist-fuzzyeq-jaccard_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ulist-fuzzyeq-jaccard_01.adm"; set `simfunction` `jaccard`; set `simthreshold` `0.7f`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-fuzzyeq-jaccard_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-fuzzyeq-jaccard_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-fuzzyeq-jaccard_02.sqlpp index 1aa1e88..5c46ddc 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-fuzzyeq-jaccard_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-fuzzyeq-jaccard_02.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,7 +47,7 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; @@ -55,7 +55,7 @@ create dataset Customers2(CustomerType) primary key cid; create index interests_index on Customers2 (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_ulist-fuzzyeq-jaccard_02.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ulist-fuzzyeq-jaccard_02.adm"; set `simfunction` `jaccard`; set `simthreshold` `0.7f`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-fuzzyeq-jaccard_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-fuzzyeq-jaccard_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-fuzzyeq-jaccard_03.sqlpp index 639277b..b874be2 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-fuzzyeq-jaccard_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-fuzzyeq-jaccard_03.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,13 +47,13 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; create index interests_index on Customers (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_ulist-fuzzyeq-jaccard_03.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ulist-fuzzyeq-jaccard_03.adm"; set `simfunction` `jaccard`; set `simthreshold` `0.7f`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard-check_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard-check_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard-check_01.sqlpp index 063b175..66ac460 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard-check_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard-check_01.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,7 +47,7 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; @@ -55,7 +55,7 @@ create dataset Customers2(CustomerType) primary key cid; create index interests_index on Customers (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_ulist-jaccard-check_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ulist-jaccard-check_01.adm"; select element {'arec':a,'brec':b} from Customers as a, Customers2 as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard-check_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard-check_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard-check_02.sqlpp index 0ff2274..2a771e3 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard-check_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard-check_02.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,7 +47,7 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; @@ -55,7 +55,7 @@ create dataset Customers2(CustomerType) primary key cid; create index interests_index on Customers2 (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_ulist-jaccard-check_02.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ulist-jaccard-check_02.adm"; select element {'arec':a,'brec':b} from Customers as a, Customers2 as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard-check_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard-check_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard-check_03.sqlpp index 33af845..8d71bb6 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard-check_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard-check_03.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,13 +47,13 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; create index interests_index on Customers (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_ulist-jaccard-check_03.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ulist-jaccard-check_03.adm"; select element {'arec':a,'brec':b} from Customers as a, Customers as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard-check_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard-check_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard-check_04.sqlpp index 86abbd1..476db19 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard-check_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard-check_04.sqlpp @@ -34,7 +34,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -48,13 +48,13 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; create index interests_index on Customers (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_ulist-jaccard-check_04.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ulist-jaccard-check_04.adm"; select element {'arec':a,'brec':b,'jacc':jacc[1]} from Customers as a, Customers as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard_01.sqlpp index f9868c4..a2fd26d 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard_01.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,7 +47,7 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; @@ -55,7 +55,7 @@ create dataset Customers2(CustomerType) primary key cid; create index interests_index on Customers (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_ulist-jaccard_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ulist-jaccard_01.adm"; select element {'arec':a,'brec':b} from Customers as a, Customers2 as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard_02.sqlpp index ff32984..287ef06 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard_02.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,7 +47,7 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; @@ -55,7 +55,7 @@ create dataset Customers2(CustomerType) primary key cid; create index interests_index on Customers2 (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_ulist-jaccard_02.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ulist-jaccard_02.adm"; select element {'arec':a,'brec':b} from Customers as a, Customers2 as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard_03.sqlpp index 44c325e..bc7b1cd 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard_03.sqlpp @@ -33,7 +33,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,13 +47,13 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; create index interests_index on Customers (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_ulist-jaccard_03.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ulist-jaccard_03.adm"; select element {'arec':a,'brec':b} from Customers as a, Customers as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard_04.sqlpp index b95c2d1..77c26cf 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/ulist-jaccard_04.sqlpp @@ -34,7 +34,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -48,13 +48,13 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; create index interests_index on Customers (interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_ulist-jaccard_04.adm" +write output to asterix_nc1:"rttest/inverted-index-join_ulist-jaccard_04.adm"; select element {'arec':a,'brec':b,'jacc':jacc} from Customers as a, Customers as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-fuzzyeq-jaccard_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-fuzzyeq-jaccard_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-fuzzyeq-jaccard_01.sqlpp index c37c670..33e781d 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-fuzzyeq-jaccard_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-fuzzyeq-jaccard_01.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -44,7 +44,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -52,7 +52,7 @@ create dataset CSX(CSXType) primary key id; create index keyword_index on DBLP (title) type keyword; -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/inverted-index-join/word-fuzzyeq-jaccard_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-fuzzyeq-jaccard_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-fuzzyeq-jaccard_02.sqlpp index ead8c37..e2158e1 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-fuzzyeq-jaccard_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-fuzzyeq-jaccard_02.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -44,7 +44,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -52,7 +52,7 @@ create dataset CSX(CSXType) primary key id; create index keyword_index on CSX (title) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_word-fuzzyeq-jaccard_02.adm" +write output to asterix_nc1:"rttest/inverted-index-join_word-fuzzyeq-jaccard_02.adm"; set `simfunction` `jaccard`; set `simthreshold` `0.5f`;