http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_01.sqlpp index b4e46ee..25b6fca 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_01.sqlpp @@ -37,18 +37,18 @@ create type test.DBLPTypetmp as title : 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.authors) type ngram (3); -write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let-panic-nopanic_01.adm" +write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let-panic-nopanic_01.adm"; select element o from DBLP as o with eda as test.`edit-distance-check`(o.nested.authors,'Amihay Motro',3),
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_02.sqlpp index 5ceb1b7..39c1276 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_02.sqlpp @@ -37,18 +37,18 @@ create type test.DBLPTypetmp as title : 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.authors) type ngram (3); -write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let-panic-nopanic_01.adm" +write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let-panic-nopanic_01.adm"; select element o from DBLP as o with edb as test.`edit-distance-check`(o.nested.authors,'Amihay Motro',5), http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-let-panic.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-let-panic.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-let-panic.sqlpp index e5c2b87..b610925 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-let-panic.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-let-panic.sqlpp @@ -36,18 +36,18 @@ create type test.DBLPTypetmp as title : 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.authors) type ngram (3); -write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let-panic.adm" +write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let-panic.adm"; select element o from DBLP as o with ed as test.`edit-distance-check`(o.nested.authors,'Amihay Motro',5) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-let.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-let.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-let.sqlpp index 1c782ed..3a30c4f 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-let.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-let.sqlpp @@ -36,18 +36,18 @@ create type test.DBLPTypetmp as title : 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.authors) type ngram (3); -write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let.adm" +write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let.adm"; select element o from DBLP as o with ed as test.`edit-distance-check`(o.nested.authors,'Amihay Motro',1) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-substring.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-substring.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-substring.sqlpp index 4ccb10b..2adcbb3 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-substring.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-substring.sqlpp @@ -36,18 +36,18 @@ create type test.DBLPNestedType as title : 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) type ngram (3); -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-index/inverted-index-complex/ngram-edit-distance-check-word-tokens.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-word-tokens.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-word-tokens.sqlpp index 28e64bf..16b4f91 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-word-tokens.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-word-tokens.sqlpp @@ -36,18 +36,18 @@ create type test.DBLPNestedType as title : 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) type ngram (3); -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-index/inverted-index-complex/ngram-jaccard-check-let.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-jaccard-check-let.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-jaccard-check-let.sqlpp index 7b95e5a..e1f79cb 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-jaccard-check-let.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-jaccard-check-let.sqlpp @@ -38,18 +38,18 @@ create type test.DBLPTypetmp as title : 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) type ngram (3); -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-index/inverted-index-complex/ngram-jaccard-check-multi-let.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-jaccard-check-multi-let.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-jaccard-check-multi-let.sqlpp index 4e4f40e..db62898 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-jaccard-check-multi-let.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ngram-jaccard-check-multi-let.sqlpp @@ -38,18 +38,18 @@ create type test.DBLPTypetmp as title : 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) type ngram (3); -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-index/inverted-index-complex/olist-edit-distance-check-let-panic.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/olist-edit-distance-check-let-panic.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/olist-edit-distance-check-let-panic.sqlpp index ec06268..fe78dbf 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/olist-edit-distance-check-let-panic.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/olist-edit-distance-check-let-panic.sqlpp @@ -34,7 +34,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerTypetmp as closed { @@ -48,12 +48,12 @@ create type test.CustomerTypetmp as age : integer? } ] -} +}; create type test.CustomerType as closed { nested : CustomerTypetmp -} +}; create dataset Customers(CustomerType) primary key nested.cid; @@ -61,7 +61,7 @@ create dataset Customers2(CustomerType) primary key nested.cid; create index interests_index on Customers (nested.interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-complex_olist-edit-distance-check-let-panic.adm" +write output to asterix_nc1:"rttest/inverted-index-complex_olist-edit-distance-check-let-panic.adm"; select element c from Customers as c with ed as test.`edit-distance-check`(c.nested.interests,['computers','wine','walking'],3) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/olist-edit-distance-check-let.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/olist-edit-distance-check-let.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/olist-edit-distance-check-let.sqlpp index 5dd6b7a..965d567 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/olist-edit-distance-check-let.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/olist-edit-distance-check-let.sqlpp @@ -34,7 +34,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerTypetmp as closed { @@ -48,12 +48,12 @@ create type test.CustomerTypetmp as age : integer? } ] -} +}; create type test.CustomerType as closed { nested : CustomerTypetmp -} +}; create dataset Customers(CustomerType) primary key nested.cid; @@ -61,7 +61,7 @@ create dataset Customers2(CustomerType) primary key nested.cid; create index interests_index on Customers (nested.interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-complex_olist-edit-distance-check-let.adm" +write output to asterix_nc1:"rttest/inverted-index-complex_olist-edit-distance-check-let.adm"; select element c from Customers as c with ed as test.`edit-distance-check`(c.nested.interests,['computers','wine','walking'],1) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/olist-jaccard-check-let.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/olist-jaccard-check-let.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/olist-jaccard-check-let.sqlpp index 1529fcc..fe3f716 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/olist-jaccard-check-let.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/olist-jaccard-check-let.sqlpp @@ -34,7 +34,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerTypetmp as closed { @@ -48,18 +48,18 @@ create type test.CustomerTypetmp as age : integer? } ] -} +}; create type test.CustomerType as closed { nested : CustomerTypetmp -} +}; create dataset Customers(CustomerType) primary key nested.cid; create index interests_index on Customers (nested.interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-complex_olist-jaccard-check-let.adm" +write output to asterix_nc1:"rttest/inverted-index-complex_olist-jaccard-check-let.adm"; select element c from Customers as c with jacc as test.`similarity-jaccard-check`(c.nested.interests,['databases','computers','wine'],0.700000f) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ulist-jaccard-check-let.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ulist-jaccard-check-let.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ulist-jaccard-check-let.sqlpp index bd4a720..af0beed 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ulist-jaccard-check-let.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/ulist-jaccard-check-let.sqlpp @@ -34,7 +34,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerTypetmp as closed { @@ -48,12 +48,12 @@ create type test.CustomerTypetmp as age : integer? } ] -} +}; create type test.CustomerType as closed { nested : CustomerTypetmp -} +}; create dataset Customers(CustomerType) primary key nested.cid; @@ -61,7 +61,7 @@ create dataset Customers2(CustomerType) primary key nested.cid; create index interests_index on Customers (nested.interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-complex_ulist-jaccard-check-let.adm" +write output to asterix_nc1:"rttest/inverted-index-complex_ulist-jaccard-check-let.adm"; select element c from Customers as c with jacc as test.`similarity-jaccard-check`(c.nested.interests,['databases','computers','wine'],0.700000f) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/word-jaccard-check-let.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/word-jaccard-check-let.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/word-jaccard-check-let.sqlpp index 04a897a..6666dca 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/word-jaccard-check-let.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/word-jaccard-check-let.sqlpp @@ -36,18 +36,18 @@ create type test.DBLPTypetmp as title : 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) type keyword; -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-index/inverted-index-complex/word-jaccard-check-multi-let.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/word-jaccard-check-multi-let.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/word-jaccard-check-multi-let.sqlpp index 777d5f1..4bfed40 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/word-jaccard-check-multi-let.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-complex/word-jaccard-check-multi-let.sqlpp @@ -36,18 +36,18 @@ create type test.DBLPTypetmp as title : 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) type keyword; -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-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-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-index/inverted-index-join/leftouterjoin-probe-pidx-with-join-edit-distance-check-idx_01.sqlpp index c704ffc..bd41d46 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-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-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 closed { @@ -49,18 +49,18 @@ create type test.TweetMessageNestedType as `message-text` : string, countA : integer, countB : integer -} +}; create type test.TweetMessageType as closed { nested : TweetMessageNestedType -} +}; create dataset TweetMessages(TweetMessageType) primary key nested.tweetid; create index msgNgramIx on TweetMessages (nested.`message-text`) type ngram (3); -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-index/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/nested-index/inverted-index-join/leftouterjoin-probe-pidx-with-join-jaccard-check-idx_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/leftouterjoin-probe-pidx-with-join-jaccard-check-idx_01.sqlpp index eed2b06..be025d8 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/leftouterjoin-probe-pidx-with-join-jaccard-check-idx_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/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.TweetMessageNestedType as closed { @@ -49,18 +49,18 @@ create type test.TweetMessageNestedType as `message-text` : string, countA : integer, countB : integer -} +}; create type test.TweetMessageType as closed { nested : TweetMessageNestedType -} +}; create dataset TweetMessages(TweetMessageType) primary key nested.tweetid; create index topicKeywordIx on TweetMessages (nested.`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.nested.tweetid,'topics':t1.nested.`referred-topics`},'similar-tweets':( select element {'id':t2.nested.tweetid,'topics':t2.nested.`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/nested-index/inverted-index-join/ngram-edit-distance-check_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-edit-distance-check_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-edit-distance-check_01.sqlpp index 2948b73..5a540ce 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-edit-distance-check_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-edit-distance-check_01.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPTypetmp as title : string, authors : string, misc : string -} +}; create type test.CSXTypetmp as closed { @@ -44,17 +44,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; @@ -62,7 +62,7 @@ create dataset CSX(CSXType) primary key nested.id; create index ngram_index on DBLP (nested.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/nested-index/inverted-index-join/ngram-edit-distance-contains.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-edit-distance-contains.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-edit-distance-contains.sqlpp index 6613d81..0621d0c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-edit-distance-contains.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-edit-distance-contains.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPTypetmp as title : string, authors : string, misc : string -} +}; create type test.CSXTypetmp as closed { @@ -44,17 +44,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; @@ -62,7 +62,7 @@ create dataset CSX(CSXType) primary key nested.id; create index ngram_index on DBLP (nested.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/nested-index/inverted-index-join/ngram-edit-distance-inline.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-edit-distance-inline.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-edit-distance-inline.sqlpp index a202476..4cf643a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-edit-distance-inline.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-edit-distance-inline.sqlpp @@ -37,18 +37,18 @@ create type test.DBLPTypetmp as title : 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.authors) type ngram (3); -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-index/inverted-index-join/ngram-edit-distance_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-edit-distance_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-edit-distance_01.sqlpp index 5f6c6a1..fd7d774 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-edit-distance_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-edit-distance_01.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPTypetmp as title : string, authors : string, misc : string -} +}; create type test.CSXTypetmp as closed { @@ -44,17 +44,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; @@ -62,7 +62,7 @@ create dataset CSX(CSXType) primary key nested.id; create index ngram_index on DBLP (nested.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/nested-index/inverted-index-join/ngram-fuzzyeq-edit-distance_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-fuzzyeq-edit-distance_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-fuzzyeq-edit-distance_01.sqlpp index ac0f9bb..4b9264c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-fuzzyeq-edit-distance_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-fuzzyeq-edit-distance_01.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPTypetmp as title : string, authors : string, misc : string -} +}; create type test.CSXTypetmp as closed { @@ -44,17 +44,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; @@ -62,7 +62,7 @@ create dataset CSX(CSXType) primary key nested.id; create index ngram_index on CSX (nested.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/nested-index/inverted-index-join/ngram-fuzzyeq-jaccard_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-fuzzyeq-jaccard_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-fuzzyeq-jaccard_01.sqlpp index 6ea93b8..b81b98c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-fuzzyeq-jaccard_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-fuzzyeq-jaccard_01.sqlpp @@ -37,7 +37,7 @@ create type test.DBLPTypetmp as title : string, authors : string, misc : string -} +}; create type test.CSXTypetmp as closed { @@ -46,17 +46,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; @@ -64,7 +64,7 @@ create dataset CSX(CSXType) primary key nested.id; create index ngram_index on CSX (nested.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/nested-index/inverted-index-join/ngram-jaccard-check_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-jaccard-check_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-jaccard-check_01.sqlpp index b819bad..17c1b84 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-jaccard-check_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-jaccard-check_01.sqlpp @@ -37,7 +37,7 @@ create type test.DBLPTypetmp as title : string, authors : string, misc : string -} +}; create type test.CSXTypetmp as closed { @@ -46,17 +46,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; @@ -64,7 +64,7 @@ create dataset CSX(CSXType) primary key nested.id; create index ngram_index on CSX (nested.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/nested-index/inverted-index-join/ngram-jaccard-inline.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-jaccard-inline.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-jaccard-inline.sqlpp index 90561a9..2b5099a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-jaccard-inline.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-jaccard-inline.sqlpp @@ -39,18 +39,18 @@ create type test.DBLPTypetmp as title : 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) type ngram (3); -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-index/inverted-index-join/ngram-jaccard_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-jaccard_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-jaccard_01.sqlpp index 0cde139..a400a36 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-jaccard_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ngram-jaccard_01.sqlpp @@ -37,7 +37,7 @@ create type test.DBLPTypetmp as title : string, authors : string, misc : string -} +}; create type test.CSXTypetmp as closed { @@ -46,17 +46,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; @@ -64,7 +64,7 @@ create dataset CSX(CSXType) primary key nested.id; create index ngram_index on CSX (nested.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/nested-index/inverted-index-join/olist-edit-distance-check_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/olist-edit-distance-check_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/olist-edit-distance-check_01.sqlpp index 372ac1a..bf280e1 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/olist-edit-distance-check_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/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.CustomerTypetmp as closed { @@ -47,12 +47,12 @@ create type test.CustomerTypetmp as age : integer? } ] -} +}; create type test.CustomerType as closed { nested : CustomerTypetmp -} +}; create dataset Customers(CustomerType) primary key nested.cid; @@ -60,7 +60,7 @@ create dataset Customers2(CustomerType) primary key nested.cid; create index interests_index on Customers (nested.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/nested-index/inverted-index-join/olist-edit-distance-inline.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/olist-edit-distance-inline.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/olist-edit-distance-inline.sqlpp index 7a9f59f..89626aa 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/olist-edit-distance-inline.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/olist-edit-distance-inline.sqlpp @@ -35,7 +35,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerTypetmp as closed { @@ -49,12 +49,12 @@ create type test.CustomerTypetmp as age : integer? } ] -} +}; create type test.CustomerType as closed { nested : CustomerTypetmp -} +}; create dataset Customers(CustomerType) primary key nested.cid; @@ -62,7 +62,7 @@ create dataset Customers2(CustomerType) primary key nested.cid; create index interests_index on Customers (nested.interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_olist-edit-distance-inline.adm" +write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_olist-edit-distance-inline.adm"; select element {'ainterests':a.nested.interests,'binterests':b.nested.interests,'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/nested-index/inverted-index-join/olist-edit-distance_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/olist-edit-distance_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/olist-edit-distance_01.sqlpp index 522918d..d38f25f 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/olist-edit-distance_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/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.CustomerTypetmp as closed { @@ -47,12 +47,12 @@ create type test.CustomerTypetmp as age : integer? } ] -} +}; create type test.CustomerType as closed { nested : CustomerTypetmp -} +}; create dataset Customers(CustomerType) primary key nested.cid; @@ -60,7 +60,7 @@ create dataset Customers2(CustomerType) primary key nested.cid; create index interests_index on Customers (nested.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/nested-index/inverted-index-join/olist-fuzzyeq-edit-distance_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/olist-fuzzyeq-edit-distance_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/olist-fuzzyeq-edit-distance_01.sqlpp index b7f34a8..7942f82 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/olist-fuzzyeq-edit-distance_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/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.CustomerTypetmp as closed { @@ -47,12 +47,12 @@ create type test.CustomerTypetmp as age : integer? } ] -} +}; create type test.CustomerType as closed { nested : CustomerTypetmp -} +}; create dataset Customers(CustomerType) primary key nested.cid; @@ -60,7 +60,7 @@ create dataset Customers2(CustomerType) primary key nested.cid; create index interests_index on Customers (nested.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/nested-index/inverted-index-join/olist-fuzzyeq-jaccard_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/olist-fuzzyeq-jaccard_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/olist-fuzzyeq-jaccard_01.sqlpp index 8dd5b45..a56ef5c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/olist-fuzzyeq-jaccard_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/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.CustomerTypetmp as closed { @@ -47,12 +47,12 @@ create type test.CustomerTypetmp as age : integer? } ] -} +}; create type test.CustomerType as closed { nested : CustomerTypetmp -} +}; create dataset Customers(CustomerType) primary key nested.cid; @@ -60,7 +60,7 @@ create dataset Customers2(CustomerType) primary key nested.cid; create index interests_index on Customers (nested.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/nested-index/inverted-index-join/olist-jaccard-check_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/olist-jaccard-check_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/olist-jaccard-check_01.sqlpp index b2ef8bf..be86585 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/olist-jaccard-check_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/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.CustomerTypetmp as closed { @@ -47,12 +47,12 @@ create type test.CustomerTypetmp as age : integer? } ] -} +}; create type test.CustomerType as closed { nested : CustomerTypetmp -} +}; create dataset Customers(CustomerType) primary key nested.cid; @@ -60,7 +60,7 @@ create dataset Customers2(CustomerType) primary key nested.cid; create index interests_index on Customers (nested.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/nested-index/inverted-index-join/olist-jaccard-inline.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/olist-jaccard-inline.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/olist-jaccard-inline.sqlpp index 399522c..4131908 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/olist-jaccard-inline.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/olist-jaccard-inline.sqlpp @@ -35,7 +35,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerTypetmp as closed { @@ -49,12 +49,12 @@ create type test.CustomerTypetmp as age : integer? } ] -} +}; create type test.CustomerType as closed { nested : CustomerTypetmp -} +}; create dataset Customers(CustomerType) primary key nested.cid; @@ -62,7 +62,7 @@ create dataset Customers2(CustomerType) primary key nested.cid; create index interests_index on Customers (nested.interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_olist-jaccard-inline.adm" +write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_olist-jaccard-inline.adm"; select element {'ainterests':a.nested.interests,'binterests':b.nested.interests,'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/nested-index/inverted-index-join/olist-jaccard_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/olist-jaccard_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/olist-jaccard_01.sqlpp index 3e46cbc..c860a4a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/olist-jaccard_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/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.CustomerTypetmp as closed { @@ -47,12 +47,12 @@ create type test.CustomerTypetmp as age : integer? } ] -} +}; create type test.CustomerType as closed { nested : CustomerTypetmp -} +}; create dataset Customers(CustomerType) primary key nested.cid; @@ -60,7 +60,7 @@ create dataset Customers2(CustomerType) primary key nested.cid; create index interests_index on Customers (nested.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/nested-index/inverted-index-join/ulist-fuzzyeq-jaccard_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ulist-fuzzyeq-jaccard_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ulist-fuzzyeq-jaccard_01.sqlpp index 53dc5ed..2dffabf 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ulist-fuzzyeq-jaccard_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/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.CustomerTypetmp as closed { @@ -47,12 +47,12 @@ create type test.CustomerTypetmp as age : integer? } ] -} +}; create type test.CustomerType as closed { nested : CustomerTypetmp -} +}; create dataset Customers(CustomerType) primary key nested.cid; @@ -60,7 +60,7 @@ create dataset Customers2(CustomerType) primary key nested.cid; create index interests_index on Customers (nested.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/nested-index/inverted-index-join/ulist-jaccard-check_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ulist-jaccard-check_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ulist-jaccard-check_01.sqlpp index 8bced57..2d4c31f 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ulist-jaccard-check_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/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.CustomerTypetmp as closed { @@ -47,12 +47,12 @@ create type test.CustomerTypetmp as age : integer? } ] -} +}; create type test.CustomerType as closed { nested : CustomerTypetmp -} +}; create dataset Customers(CustomerType) primary key nested.cid; @@ -60,7 +60,7 @@ create dataset Customers2(CustomerType) primary key nested.cid; create index interests_index on Customers (nested.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/nested-index/inverted-index-join/ulist-jaccard-inline.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ulist-jaccard-inline.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ulist-jaccard-inline.sqlpp index c3e5793..6676599 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ulist-jaccard-inline.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ulist-jaccard-inline.sqlpp @@ -35,7 +35,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerTypetmp as closed { @@ -49,12 +49,12 @@ create type test.CustomerTypetmp as age : integer? } ] -} +}; create type test.CustomerType as closed { nested : CustomerTypetmp -} +}; create dataset Customers(CustomerType) primary key nested.cid; @@ -62,7 +62,7 @@ create dataset Customers2(CustomerType) primary key nested.cid; create index interests_index on Customers (nested.interests) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_ulist-jaccard-inline.adm" +write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_ulist-jaccard-inline.adm"; select element {'ainterests':a.nested.interests,'binterests':b.nested.interests,'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/nested-index/inverted-index-join/ulist-jaccard_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ulist-jaccard_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ulist-jaccard_01.sqlpp index b1962ee..45bcd7a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/ulist-jaccard_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/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.CustomerTypetmp as closed { @@ -47,12 +47,12 @@ create type test.CustomerTypetmp as age : integer? } ] -} +}; create type test.CustomerType as closed { nested : CustomerTypetmp -} +}; create dataset Customers(CustomerType) primary key nested.cid; @@ -60,7 +60,7 @@ create dataset Customers2(CustomerType) primary key nested.cid; create index interests_index on Customers (nested.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/nested-index/inverted-index-join/word-fuzzyeq-jaccard_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/word-fuzzyeq-jaccard_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/word-fuzzyeq-jaccard_01.sqlpp index 7a868cf..07402e2 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/word-fuzzyeq-jaccard_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/word-fuzzyeq-jaccard_01.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPTypetmp as title : string, authors : string, misc : string -} +}; create type test.CSXTypetmp as closed { @@ -44,17 +44,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; @@ -62,7 +62,7 @@ create dataset CSX(CSXType) primary key nested.id; create index keyword_index on DBLP (nested.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/nested-index/inverted-index-join/word-jaccard-check-after-btree-access.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/word-jaccard-check-after-btree-access.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/word-jaccard-check-after-btree-access.sqlpp index 5d45bb8..ff005fd 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/word-jaccard-check-after-btree-access.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-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 closed { @@ -50,12 +50,12 @@ create type test.TweetMessageNestedType as `message-text` : string, countA : integer, countB : integer -} +}; create type test.TweetMessageType as closed { nested : TweetMessageNestedType -} +}; create dataset TweetMessages(TweetMessageType) primary key nested.tweetid; @@ -67,7 +67,7 @@ create index msgCountBIx on TweetMessages (nested.countB) type btree; create index msgTextIx on TweetMessages (nested.`message-text`) type keyword; -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-index/inverted-index-join/word-jaccard-check_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/word-jaccard-check_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/word-jaccard-check_01.sqlpp index 5363df8..95e9bbb 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/word-jaccard-check_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/word-jaccard-check_01.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPTypetmp as title : string, authors : string, misc : string -} +}; create type test.CSXTypetmp as closed { @@ -44,17 +44,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; @@ -62,7 +62,7 @@ create dataset CSX(CSXType) primary key nested.id; create index keyword_index on DBLP (nested.title) type keyword; -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-index/inverted-index-join/word-jaccard-inline.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/word-jaccard-inline.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/word-jaccard-inline.sqlpp index 5195eae..4fe09b9 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/word-jaccard-inline.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/word-jaccard-inline.sqlpp @@ -37,18 +37,18 @@ create type test.DBLPTypetmp as title : 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) type keyword; -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-index/inverted-index-join/word-jaccard_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/word-jaccard_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/word-jaccard_01.sqlpp index bb028b4..3b2d0e2 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/word-jaccard_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-join/word-jaccard_01.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPTypetmp as title : string, authors : string, misc : string -} +}; create type test.CSXTypetmp as closed { @@ -44,17 +44,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; @@ -62,7 +62,7 @@ create dataset CSX(CSXType) primary key nested.id; create index keyword_index on DBLP (nested.title) type keyword; -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-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_01.sqlpp index e3e2326..1b3582e 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_01.sqlpp @@ -37,7 +37,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 `message-text` : string, countA : integer, countB : integer -} +}; create type test.TweetMessageType as { 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`) type keyword; -write output to asterix_nc1:"rttest/rtree-index-join_leftouterjoin-probe-pidx-with-join-rtree-sidx_01.adm" +write output to asterix_nc1:"rttest/rtree-index-join_leftouterjoin-probe-pidx-with-join-rtree-sidx_01.adm"; select element {'tweetid1':t1.nested.tweetid,'loc1':t1.nested.`sender-location`,'nearby-message':( select element {'tweetid2':t2.nested.tweetid,'loc2':t2.nested.`sender-location`} 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-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_02.sqlpp index 2803bf6..6adb262 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_02.sqlpp @@ -37,7 +37,7 @@ create type test.TwitterUserType as `statuses-count` : integer, name : string, `followers-count` : integer -} +}; create type test.TweetMessageNestedType as closed { @@ -49,12 +49,12 @@ create type test.TweetMessageNestedType as `message-text` : string, countA : integer, countB : integer -} +}; create type test.TweetMessageType as { 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`) type keyword; -write output to asterix_nc1:"rttest/rtree-index-join_leftouterjoin-probe-pidx-with-join-rtree-sidx_02.adm" +write output to asterix_nc1:"rttest/rtree-index-join_leftouterjoin-probe-pidx-with-join-rtree-sidx_02.adm"; select element {'tweetid1':t1.nested.tweetid,'loc1':t1.nested.`sender-location`,'nearby-message':( select element {'tweetid2':t2.nested.tweetid,'loc2':t2.nested.`sender-location`} 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-index/rtree-index-join/spatial-intersect-point_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/rtree-index-join/spatial-intersect-point_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/rtree-index-join/spatial-intersect-point_01.sqlpp index b38a6e3..75f9de3 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/rtree-index-join/spatial-intersect-point_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/rtree-index-join/spatial-intersect-point_01.sqlpp @@ -39,12 +39,12 @@ create type test.MyRecord as poly1 : polygon, poly2 : polygon, rec : rectangle -} +}; create type test.MyRecordNested as closed { nested : MyRecord -} +}; create dataset MyData1(MyRecordNested) primary key nested.id; @@ -52,7 +52,7 @@ create dataset MyData2(MyRecord) primary key id; create index rtree_index on MyData1 (nested.point) type rtree; -write output to asterix_nc1:"rttest/index-join_rtree-spatial-intersect-point.adm" +write output to asterix_nc1:"rttest/index-join_rtree-spatial-intersect-point.adm"; select element {'a':a,'b':b} from MyData1 as a, MyData2 as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/rtree-index-join/spatial-intersect-point_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/rtree-index-join/spatial-intersect-point_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/rtree-index-join/spatial-intersect-point_02.sqlpp index 67cfc52..9d09f48 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/rtree-index-join/spatial-intersect-point_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/rtree-index-join/spatial-intersect-point_02.sqlpp @@ -39,12 +39,12 @@ create type test.MyRecord as poly1 : polygon, poly2 : polygon, rec : rectangle -} +}; create type test.MyRecordNested as closed { nested : MyRecord -} +}; create dataset MyData1(MyRecordNested) primary key nested.id; @@ -52,7 +52,7 @@ create dataset MyData2(MyRecord) primary key id; create index rtree_index on MyData2 (point) type rtree; -write output to asterix_nc1:"rttest/rtree-index-join_spatial-intersect-point_02.adm" +write output to asterix_nc1:"rttest/rtree-index-join_spatial-intersect-point_02.adm"; select element {'a':a,'b':b} from MyData1 as a, MyData2 as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/rtree-index-join/spatial-intersect-point_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/rtree-index-join/spatial-intersect-point_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/rtree-index-join/spatial-intersect-point_03.sqlpp index 2fc5cc5..fa3ff7b 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/rtree-index-join/spatial-intersect-point_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/rtree-index-join/spatial-intersect-point_03.sqlpp @@ -39,18 +39,18 @@ create type test.MyRecord as poly1 : polygon, poly2 : polygon, rec : rectangle -} +}; create type test.MyRecordNested as closed { nested : MyRecord -} +}; create dataset MyData(MyRecordNested) primary key nested.id; create index rtree_index on MyData (nested.point) type rtree; -write output to asterix_nc1:"rttest/rtree-index-join_spatial-intersect-point_03.adm" +write output to asterix_nc1:"rttest/rtree-index-join_spatial-intersect-point_03.adm"; select element {'a':a,'b':b} from MyData as a, MyData 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/btree-index-join/disjunction-to-join.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/disjunction-to-join.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/disjunction-to-join.sqlpp index 819bdc7..957acfc 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/disjunction-to-join.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/disjunction-to-join.sqlpp @@ -31,14 +31,14 @@ use test; create type test.NestedTestType as { -} +}; create type test.TestType as { id : string, `no-idx` : string, nested : NestedTestType -} +}; create dataset TestSet(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_1.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_1.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_1.sqlpp index c64ab0d..4e597c4 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_1.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_1.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}}, `message-text` : string, countA : integer -} +}; create type test.TweetMessageType as { nested : TweetMessageNestedType -} +}; create dataset TweetMessages(TweetMessageType) primary key nested.tweetid; create index msgCountBIx on TweetMessages (nested.countB:integer?) type btree enforced; -write output to asterix_nc1:"rttest/btree-index-join_leftouterjoin-probe-pidx-with-join-btree-sidx_01.adm" +write output to asterix_nc1:"rttest/btree-index-join_leftouterjoin-probe-pidx-with-join-btree-sidx_01.adm"; select element {'tweetid1':t1.nested.tweetid,'count1':t1.nested.countA,'t2info':( select element {'tweetid2':t2.nested.tweetid,'count2':t2.nested.countB} 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/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_2.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_2.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_2.sqlpp index 95c3d84..a153cd0 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_2.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_2.sqlpp @@ -37,7 +37,7 @@ create type test.TwitterUserType as `statuses-count` : integer, name : string, `followers-count` : integer -} +}; create type test.TweetMessageNestedType as { @@ -47,12 +47,12 @@ create type test.TweetMessageNestedType as `send-time` : datetime, `referred-topics` : {{string}}, `message-text` : string -} +}; create type test.TweetMessageType as { nested : TweetMessageNestedType -} +}; create dataset TweetMessages(TweetMessageType) primary key nested.tweetid; @@ -60,7 +60,7 @@ create index msgCountAIx on TweetMessages (nested.countA:integer?) type btree create index msgCountBIx on TweetMessages (nested.countB:integer?) type btree enforced; -write output to asterix_nc1:"rttest/btree-index-join_leftouterjoin-probe-pidx-with-join-btree-sidx_01.adm" +write output to asterix_nc1:"rttest/btree-index-join_leftouterjoin-probe-pidx-with-join-btree-sidx_01.adm"; select element {'tweetid1':t1.nested.tweetid,'count1':t1.nested.countA,'t2info':( select element {'tweetid2':t2.nested.tweetid,'count2':t2.nested.countB} 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/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_1.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_1.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_1.sqlpp index 51fa7b6..c2ca7ce 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_1.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_1.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}}, `message-text` : string, countA : integer -} +}; create type test.TweetMessageType as { nested : TweetMessageNestedType -} +}; create dataset TweetMessages(TweetMessageType) primary key nested.tweetid; create index msgCountBIx on TweetMessages (nested.countB:integer?) type btree enforced; -write output to asterix_nc1:"rttest/btree-index-join_leftouterjoin-probe-pidx-with-join-btree-sidx_02.adm" +write output to asterix_nc1:"rttest/btree-index-join_leftouterjoin-probe-pidx-with-join-btree-sidx_02.adm"; select element {'tweetid1':t1.nested.tweetid,'count1':t1.nested.countA,'t2info':( select element {'tweetid2':t2.nested.tweetid,'count2':t2.nested.countB} 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/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_2.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_2.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_2.sqlpp index e5387a2..d7a3be3 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_2.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_2.sqlpp @@ -37,7 +37,7 @@ create type test.TwitterUserType as `statuses-count` : integer, name : string, `followers-count` : integer -} +}; create type test.TweetMessageNestedType as { @@ -47,12 +47,12 @@ create type test.TweetMessageNestedType as `send-time` : datetime, `referred-topics` : {{string}}, `message-text` : string -} +}; create type test.TweetMessageType as { nested : TweetMessageNestedType -} +}; create dataset TweetMessages(TweetMessageType) primary key nested.tweetid; @@ -60,7 +60,7 @@ create index msgCountAIx on TweetMessages (nested.countA:integer?) type btree create index msgCountBIx on TweetMessages (nested.countB:integer?) type btree enforced; -write output to asterix_nc1:"rttest/btree-index-join_leftouterjoin-probe-pidx-with-join-btree-sidx_02.adm" +write output to asterix_nc1:"rttest/btree-index-join_leftouterjoin-probe-pidx-with-join-btree-sidx_02.adm"; select element {'tweetid1':t1.nested.tweetid,'count1':t1.nested.countA,'t2info':( select element {'tweetid2':t2.nested.tweetid,'count2':t2.nested.countB} 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/btree-index-join/secondary-composite-key-join_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-join_01.sqlpp index a0f82e5..a7a3c3f 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-join_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-join_01.sqlpp @@ -32,18 +32,18 @@ use test; create type test.Nametmp as { id : integer -} +}; create type test.NameType as { nested : Nametmp -} +}; create dataset Names(NameType) primary key nested.id; create index Name_idx on Names (nested.fname:string?,lnested.name:string?) type btree enforced; -write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-join_01.adm" +write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-join_01.adm"; select element {'emp1':emp1,'emp2':emp2} from Names as emp1, Names as emp2
