http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/fj-phase2-with-hints.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/fj-phase2-with-hints.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/fj-phase2-with-hints.sqlpp index 4ecffb6..f8c55e0 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/fj-phase2-with-hints.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/fj-phase2-with-hints.sqlpp @@ -30,7 +30,7 @@ create type fuzzyjoin_078.DBLPType as title : string, authors : string, misc : string -} +}; create nodegroup group1 if not exists on asterix_nc1, @@ -38,7 +38,7 @@ create nodegroup group1 if not exists on ; create dataset DBLP_fuzzyjoin_078(DBLPType) primary key id on group1; -write output to asterix_nc1:"rttest/fuzzyjoin_078.adm" +write output to asterix_nc1:"rttest/fuzzyjoin_078.adm"; select element {'id':paperDBLP.id,'tokens':tokensDBLP} from DBLP_fuzzyjoin_078 as paperDBLP with unrankedTokensDBLP as fuzzyjoin_078.`counthashed-word-tokens`(paperDBLP.title),
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/hashjoin-with-unnest.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/hashjoin-with-unnest.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/hashjoin-with-unnest.sqlpp index 609a478..4f5263c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/hashjoin-with-unnest.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/hashjoin-with-unnest.sqlpp @@ -32,13 +32,13 @@ create type test.TestType as { id : integer, name : string -} +}; create dataset t1(TestType) primary key id; create dataset t2(TestType) primary key id; -write output to asterix_nc1:"rttest/hahsjoin-with-unnest.adm" +write output to asterix_nc1:"rttest/hahsjoin-with-unnest.adm"; select element {'t1':m,'t2':n} from t1 as m, t2 as n, http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inline-funs.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inline-funs.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inline-funs.sqlpp index 9302058..720108a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inline-funs.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inline-funs.sqlpp @@ -23,7 +23,7 @@ create dataverse test; use test; -write output to asterix_nc1:"/tmp/inline_funs.adm" +write output to asterix_nc1:"/tmp/inline_funs.adm"; declare function f1() { (1 + test.f2()) }; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inlined_q18_large_volume_customer.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inlined_q18_large_volume_customer.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inlined_q18_large_volume_customer.sqlpp index 16b9c89..7819959 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inlined_q18_large_volume_customer.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inlined_q18_large_volume_customer.sqlpp @@ -41,7 +41,7 @@ create type inlined_q18_large_volume_customer.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type inlined_q18_large_volume_customer.OrderType as closed { @@ -54,7 +54,7 @@ create type inlined_q18_large_volume_customer.OrderType as o_clerk : string, o_shippriority : integer, o_comment : string -} +}; create type inlined_q18_large_volume_customer.CustomerType as closed { @@ -66,7 +66,7 @@ create type inlined_q18_large_volume_customer.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create nodegroup group1 if not exists on asterix_nc1, @@ -78,7 +78,7 @@ create dataset Orders(OrderType) primary key o_orderkey on group1; create dataset Customers(CustomerType) primary key c_custkey on group1; -write output to asterix_nc1:"/tmp/inlined_q18_large_volume_customer.adm" +write output to asterix_nc1:"/tmp/inlined_q18_large_volume_customer.adm"; select element {'c_name':c_name,'c_custkey':c_custkey,'o_orderkey':o_orderkey,'o_orderdate':o_orderdate,'o_totalprice':o_totalprice,'sum_quantity':inlined_q18_large_volume_customer.coll_sum(( select element j.l_quantity from l as j http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/insert-and-scan-dataset-with-index.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/insert-and-scan-dataset-with-index.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/insert-and-scan-dataset-with-index.sqlpp index ec2c0ce..615710f 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/insert-and-scan-dataset-with-index.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/insert-and-scan-dataset-with-index.sqlpp @@ -34,7 +34,7 @@ create type test.Emp as lname : string, age : integer, dept : string -} +}; create dataset test.employee(Emp) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/insert-and-scan-dataset.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/insert-and-scan-dataset.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/insert-and-scan-dataset.sqlpp index fdbaec9..5566eaf 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/insert-and-scan-dataset.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/insert-and-scan-dataset.sqlpp @@ -33,7 +33,7 @@ use test; create type test.myDataType as { id : integer -} +}; create dataset myData(myDataType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/insert-and-scan-joined-datasets.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/insert-and-scan-joined-datasets.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/insert-and-scan-joined-datasets.sqlpp index 01498f4..4618aa2 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/insert-and-scan-joined-datasets.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/insert-and-scan-joined-datasets.sqlpp @@ -29,14 +29,14 @@ use test; create type test.myDataType as { id : integer -} +}; create dataset myData(myDataType) primary key id; create dataset myData2(myDataType) primary key id; insert into myData -select element {'id':(x.id + 1)} +select element {'id':(x.id + 1)}; from myData2 as x, myData as y where (x.id = y.id) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/introhashpartitionmerge.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/introhashpartitionmerge.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/introhashpartitionmerge.sqlpp index b177c77..103aae8 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/introhashpartitionmerge.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/introhashpartitionmerge.sqlpp @@ -27,7 +27,7 @@ create type fuzzyjoin.TOKENSRANKEDADMType as closed { token : integer, rank : integer -} +}; create nodegroup group1 if not exists on asterix_nc1, @@ -35,7 +35,7 @@ create nodegroup group1 if not exists on ; create dataset TOKENSRANKEDADM(TOKENSRANKEDADMType) primary key rank on group1; -write output to asterix_nc1:"rttest/introhashpartitionmerge.adm" +write output to asterix_nc1:"rttest/introhashpartitionmerge.adm"; select element token2.rank from TOKENSRANKEDADM as token1, ( http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-contains-panic.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-contains-panic.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-contains-panic.sqlpp index e4dff38..e13305d 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-contains-panic.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-contains-panic.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-basic_ngram-contains-panic.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_ngram-contains-panic.adm"; select element o from DBLP as o where test.contains(o.title,'Mu') http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-contains.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-contains.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-contains.sqlpp index ec01cd2..e5b4885 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-contains.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/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-basic_ngram-contains.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_ngram-contains.adm"; select element o from DBLP as o where test.contains(o.title,'Multimedia') http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-edit-distance-check-panic.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-edit-distance-check-panic.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-edit-distance-check-panic.sqlpp index a61bd39..1f04301 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-edit-distance-check-panic.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-edit-distance-check-panic.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-basic_ngram-edit-distance-check-panic.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_ngram-edit-distance-check-panic.adm"; select element o from DBLP as o with ed as test.`edit-distance-check`(o.authors,'Amihay Motro',5) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-edit-distance-check.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-edit-distance-check.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-edit-distance-check.sqlpp index ee6bc26..da55c99 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-edit-distance-check.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-edit-distance-check.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-basic_ngram-edit-distance-check.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_ngram-edit-distance-check.adm"; select element o from DBLP as o where test.`edit-distance-check`(o.authors,'Amihay Motro',1)[0] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-edit-distance-panic.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-edit-distance-panic.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-edit-distance-panic.sqlpp index cace337..84eae49 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-edit-distance-panic.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-edit-distance-panic.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-basic_ngram-edit-distance-panic.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_ngram-edit-distance-panic.adm"; select element o from DBLP as o where (test.`edit-distance`(o.authors,'Amihay Motro') <= 5) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-edit-distance.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-edit-distance.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-edit-distance.sqlpp index 3e01e68..91a809b 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-edit-distance.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-edit-distance.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-basic_ngram-edit-distance.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_ngram-edit-distance.adm"; select element o from DBLP as o where (test.`edit-distance`(o.authors,'Amihay Motro') <= 1) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-fuzzyeq-edit-distance.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-fuzzyeq-edit-distance.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-fuzzyeq-edit-distance.sqlpp index e35ebfc..d684f0c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-fuzzyeq-edit-distance.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-fuzzyeq-edit-distance.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-basic_ngram-fuzzyeq-edit-distance.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_ngram-fuzzyeq-edit-distance.adm"; set `simfunction` `edit-distance`; set `simthreshold` `1`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-fuzzyeq-jaccard.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-fuzzyeq-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-fuzzyeq-jaccard.sqlpp index 3f92588..5adcda0 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-fuzzyeq-jaccard.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-fuzzyeq-jaccard.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-basic_ngram-fuzzyeq-jaccard.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_ngram-fuzzyeq-jaccard.adm"; set `simfunction` `jaccard`; set `simthreshold` `0.8f`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-jaccard-check.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-jaccard-check.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-jaccard-check.sqlpp index 3b83894..5b564db 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-jaccard-check.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-jaccard-check.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-basic_ngram-jaccard-check.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_ngram-jaccard-check.adm"; select element o from DBLP as o where test.`similarity-jaccard-check`(test.`gram-tokens`(o.title,3,false),test.`gram-tokens`('Transactions for Cooperative Environments',3,false),0.500000f)[0] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-jaccard.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-jaccard.sqlpp index 1d5ee5e..3e024a0 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-jaccard.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ngram-jaccard.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-basic_ngram-jaccard.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_ngram-jaccard.adm"; select element o from DBLP as o where (test.`similarity-jaccard`(test.`gram-tokens`(o.title,3,false),test.`gram-tokens`('Transactions for Cooperative Environments',3,false)) >= 0.500000f) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-edit-distance-check-panic.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-edit-distance-check-panic.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-edit-distance-check-panic.sqlpp index 19a340f..41ceade 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-edit-distance-check-panic.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-edit-distance-check-panic.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-basic_olist-edit-distance-check-panic.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_olist-edit-distance-check-panic.adm"; select element c from Customers as c where test.`edit-distance-check`(c.interests,['computers','wine','walking'],3)[0] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-edit-distance-check.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-edit-distance-check.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-edit-distance-check.sqlpp index 7af452f..0ca8b00 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-edit-distance-check.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-edit-distance-check.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-basic_olist-edit-distance-check.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_olist-edit-distance-check.adm"; select element c from Customers as c where test.`edit-distance-check`(c.interests,['computers','wine','walking'],1)[0] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-edit-distance-panic.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-edit-distance-panic.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-edit-distance-panic.sqlpp index 17f4e64..0f2fcf4 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-edit-distance-panic.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-edit-distance-panic.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-basic_olist-edit-distance-panic.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_olist-edit-distance-panic.adm"; select element c from Customers as c where (test.`edit-distance`(c.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/inverted-index-basic/olist-edit-distance.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-edit-distance.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-edit-distance.sqlpp index 9149bea..a4114d0 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-edit-distance.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-edit-distance.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-basic_olist-edit-distance.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_olist-edit-distance.adm"; select element c from Customers as c where (test.`edit-distance`(c.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/inverted-index-basic/olist-fuzzyeq-edit-distance.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-fuzzyeq-edit-distance.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-fuzzyeq-edit-distance.sqlpp index 6ccb3de..1bfd5f9 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-fuzzyeq-edit-distance.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-fuzzyeq-edit-distance.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-basic_olist-fuzzyeq-edit-distance.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_olist-fuzzyeq-edit-distance.adm"; set `simfunction` `edit-distance`; set `simthreshold` `1`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-fuzzyeq-jaccard.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-fuzzyeq-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-fuzzyeq-jaccard.sqlpp index c7c3aea..a1372d9 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-fuzzyeq-jaccard.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-fuzzyeq-jaccard.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-basic_olist-fuzzyeq-jaccard.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_olist-fuzzyeq-jaccard.adm"; set `simfunction` `jaccard`; set `simthreshold` `0.8f`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-jaccard-check.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-jaccard-check.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-jaccard-check.sqlpp index bc4eda9..89a3eb8 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-jaccard-check.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-jaccard-check.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-basic_olist-jaccard-check.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_olist-jaccard-check.adm"; select element c from Customers as c where test.`similarity-jaccard-check`(c.interests,['databases','computers','wine'],0.700000f)[0] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-jaccard.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-jaccard.sqlpp index 0722bda..d13c98b 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-jaccard.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/olist-jaccard.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-basic_olist-jaccard.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_olist-jaccard.adm"; select element c from Customers as c where (test.`similarity-jaccard`(c.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/inverted-index-basic/ulist-fuzzyeq-jaccard.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ulist-fuzzyeq-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ulist-fuzzyeq-jaccard.sqlpp index 2d40687..d32a8f4 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ulist-fuzzyeq-jaccard.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ulist-fuzzyeq-jaccard.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-basic_ulist-fuzzyeq-jaccard.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_ulist-fuzzyeq-jaccard.adm"; set `simfunction` `jaccard`; set `simthreshold` `0.8f`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ulist-jaccard-check.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ulist-jaccard-check.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ulist-jaccard-check.sqlpp index 93d4790..25568e0 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ulist-jaccard-check.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ulist-jaccard-check.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-basic_ulist-jaccard.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_ulist-jaccard.adm"; select element c from Customers as c where test.`similarity-jaccard-check`(c.interests,{{'computers','wine','databases'}},0.700000f)[0] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ulist-jaccard.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ulist-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ulist-jaccard.sqlpp index 504c812..2a26ee9 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ulist-jaccard.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/ulist-jaccard.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-basic_ulist-jaccard.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_ulist-jaccard.adm"; select element c from Customers as c where (test.`similarity-jaccard`(c.interests,{{'computers','databases','wine'}}) >= 0.700000f) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/word-contains.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/word-contains.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/word-contains.sqlpp index e553db1..2a1db6d 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/word-contains.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/word-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 keyword_index on DBLP (title) type keyword; -write output to asterix_nc1:"rttest/inverted-index-basic_word-contains.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_word-contains.adm"; select element o from DBLP as o where test.contains(o.title,'Multimedia') http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/word-fuzzyeq-jaccard.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/word-fuzzyeq-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/word-fuzzyeq-jaccard.sqlpp index 60e77b4..6157fde 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/word-fuzzyeq-jaccard.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/word-fuzzyeq-jaccard.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 keyword_index on DBLP (title) type keyword; -write output to asterix_nc1:"rttest/inverted-index-basic_word-fuzzyeq-jaccard.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_word-fuzzyeq-jaccard.adm"; set `simfunction` `jaccard`; set `simthreshold` `0.5f`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/word-jaccard-check.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/word-jaccard-check.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/word-jaccard-check.sqlpp index a309084..b0dc05a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/word-jaccard-check.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/word-jaccard-check.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 keyword_index on DBLP (title) type keyword; -write output to asterix_nc1:"rttest/inverted-index-basic_word-jaccard-check.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_word-jaccard-check.adm"; select element o from DBLP as o where test.`similarity-jaccard-check`(test.`word-tokens`(o.title),test.`word-tokens`('Transactions for Cooperative Environments'),0.500000f)[0] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/word-jaccard.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/word-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/word-jaccard.sqlpp index d2b2be5..eb96ddd 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/word-jaccard.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-basic/word-jaccard.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 keyword_index on DBLP (title) type keyword; -write output to asterix_nc1:"rttest/inverted-index-basic_word-jaccard.adm" +write output to asterix_nc1:"rttest/inverted-index-basic_word-jaccard.adm"; select element o from DBLP as o where (test.`similarity-jaccard`(test.`word-tokens`(o.title),test.`word-tokens`('Transactions for Cooperative Environments')) >= 0.500000f) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_01.sqlpp index 86a0bb4..c60c8fd 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_01.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 (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.authors,'Amihay Motro',3), http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_02.sqlpp index f563500..8a5d1d6 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_02.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 (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.authors,'Amihay Motro',5), http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-let-panic.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-let-panic.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-let-panic.sqlpp index ec39482..2cce890 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-let-panic.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-let-panic.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-complex_ngram-edit-distance-check-let-panic.adm" +write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let-panic.adm"; select element o from DBLP as o with ed as test.`edit-distance-check`(o.authors,'Amihay Motro',5) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-let.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-let.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-let.sqlpp index 97c0a7c..1f725d6 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-let.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-let.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-complex_ngram-edit-distance-check-let.adm" +write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let.adm"; select element o from DBLP as o with ed as test.`edit-distance-check`(o.authors,'Amihay Motro',1) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-substring.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-substring.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-substring.sqlpp index b18608e..d2e3888 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-substring.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-substring.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 (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.id,'title':paper.title} from DBLP as paper where test.`edit-distance-check`(test.substring(paper.title,0,8),'datbase',1)[0] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-word-tokens.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-word-tokens.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-word-tokens.sqlpp index 1919c83..ea53884 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-word-tokens.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-edit-distance-check-word-tokens.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 (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.id,'title':paper.title} from DBLP as paper, test.`word-tokens`(paper.title) as word http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-jaccard-check-let.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-jaccard-check-let.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-jaccard-check-let.sqlpp index a0f7048..248c243 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-jaccard-check-let.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-jaccard-check-let.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-complex_ngram-jaccard-check-let.adm" +write output to asterix_nc1:"rttest/inverted-index-complex_ngram-jaccard-check-let.adm"; select element o from DBLP as o with jacc as test.`similarity-jaccard-check`(test.`gram-tokens`(o.title,3,false),test.`gram-tokens`('Transactions for Cooperative Environments',3,false),0.500000f) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-jaccard-check-multi-let.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-jaccard-check-multi-let.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-jaccard-check-multi-let.sqlpp index 412566c..8be4caa 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-jaccard-check-multi-let.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ngram-jaccard-check-multi-let.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-complex_ngram-jaccard-check-multi-let.adm" +write output to asterix_nc1:"rttest/inverted-index-complex_ngram-jaccard-check-multi-let.adm"; select element {'Paper':paper_tokens,'Query':query_tokens} from DBLP as paper with paper_tokens as test.`gram-tokens`(paper.title,3,false), http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/olist-edit-distance-check-let-panic.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/olist-edit-distance-check-let-panic.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/olist-edit-distance-check-let-panic.sqlpp index a4e05cc..68106a5 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/olist-edit-distance-check-let-panic.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/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.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-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.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/inverted-index-complex/olist-edit-distance-check-let.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/olist-edit-distance-check-let.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/olist-edit-distance-check-let.sqlpp index 5f12771..7083657 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/olist-edit-distance-check-let.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/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.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-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.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/inverted-index-complex/olist-jaccard-check-let.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/olist-jaccard-check-let.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/olist-jaccard-check-let.sqlpp index 19fcbdb..a04a8ef 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/olist-jaccard-check-let.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/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.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-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.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/inverted-index-complex/ulist-jaccard-check-let.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ulist-jaccard-check-let.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ulist-jaccard-check-let.sqlpp index 137e22e..ceac8c6 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/ulist-jaccard-check-let.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/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.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-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.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/inverted-index-complex/word-jaccard-check-let.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/word-jaccard-check-let.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/word-jaccard-check-let.sqlpp index bc56cf9..e4f3b8d 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/word-jaccard-check-let.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/word-jaccard-check-let.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 keyword_index on DBLP (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.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/inverted-index-complex/word-jaccard-check-multi-let.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/word-jaccard-check-multi-let.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/word-jaccard-check-multi-let.sqlpp index 9b9dea9..56ede6d 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/word-jaccard-check-multi-let.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-complex/word-jaccard-check-multi-let.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 keyword_index on DBLP (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.title), http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ngram-edit-distance-inline.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ngram-edit-distance-inline.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ngram-edit-distance-inline.sqlpp index 5e9e9ff..c29de43 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ngram-edit-distance-inline.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ngram-edit-distance-inline.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 (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.authors,'bauthors':b.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/inverted-index-join-noeqjoin/ngram-edit-distance.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ngram-edit-distance.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ngram-edit-distance.sqlpp index bc82244..767f6f5 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ngram-edit-distance.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ngram-edit-distance.sqlpp @@ -36,7 +36,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -45,7 +45,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -53,7 +53,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on DBLP (authors) type ngram (3); -write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_ngram-edit-distance.adm" +write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_ngram-edit-distance.adm"; select element {'aauthors':a.authors,'bauthors':b.authors} 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-noeqjoin/ngram-fuzzyeq-edit-distance.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ngram-fuzzyeq-edit-distance.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ngram-fuzzyeq-edit-distance.sqlpp index 803a965..1234824 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ngram-fuzzyeq-edit-distance.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ngram-fuzzyeq-edit-distance.sqlpp @@ -36,7 +36,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -45,7 +45,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -53,7 +53,7 @@ create dataset CSX(CSXType) primary key id; create index ngram_index on CSX (authors) type ngram (3); -write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_ngram-fuzzyeq-edit-distance.adm" +write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_ngram-fuzzyeq-edit-distance.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-noeqjoin/ngram-fuzzyeq-jaccard.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ngram-fuzzyeq-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ngram-fuzzyeq-jaccard.sqlpp index 4f9465c..c050bc9 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ngram-fuzzyeq-jaccard.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ngram-fuzzyeq-jaccard.sqlpp @@ -38,7 +38,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -47,7 +47,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -55,7 +55,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-noeqjoin_ngram-fuzzyeq-jaccard.adm" +write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_ngram-fuzzyeq-jaccard.adm"; set `simfunction` `jaccard`; set `simthreshold` `0.5f`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ngram-jaccard-inline.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ngram-jaccard-inline.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ngram-jaccard-inline.sqlpp index 80491ee..4fdc637 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ngram-jaccard-inline.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ngram-jaccard-inline.sqlpp @@ -39,13 +39,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-noeqjoin_ngram-jaccard-inline.adm" +write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_ngram-jaccard-inline.adm"; select element {'atitle':a.title,'btitle':b.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/inverted-index-join-noeqjoin/ngram-jaccard.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ngram-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ngram-jaccard.sqlpp index 11984de..ca001a0 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ngram-jaccard.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ngram-jaccard.sqlpp @@ -38,7 +38,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -47,7 +47,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -55,7 +55,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-noeqjoin_ngram-jaccard.adm" +write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_ngram-jaccard.adm"; select element {'atitle':a.title,'btitle':b.title} 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-noeqjoin/olist-edit-distance-inline.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/olist-edit-distance-inline.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/olist-edit-distance-inline.sqlpp index 1957b02..40c8c5f 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/olist-edit-distance-inline.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/olist-edit-distance-inline.sqlpp @@ -35,7 +35,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -49,13 +49,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-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.interests,'binterests':b.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/inverted-index-join-noeqjoin/olist-edit-distance.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/olist-edit-distance.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/olist-edit-distance.sqlpp index 5f8c125..38c3cb9 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/olist-edit-distance.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/olist-edit-distance.sqlpp @@ -34,7 +34,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -48,7 +48,7 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; @@ -56,7 +56,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-noeqjoin_olist-edit-distance.adm" +write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_olist-edit-distance.adm"; select element {'ainterests':a.interests,'binterests':b.interests} 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-noeqjoin/olist-fuzzyeq-edit-distance.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/olist-fuzzyeq-edit-distance.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/olist-fuzzyeq-edit-distance.sqlpp index 32a875b..4d8cfaa 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/olist-fuzzyeq-edit-distance.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/olist-fuzzyeq-edit-distance.sqlpp @@ -34,7 +34,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -48,7 +48,7 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; @@ -56,7 +56,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-noeqjoin_olist-fuzzyeq-edit-distance.adm" +write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_olist-fuzzyeq-edit-distance.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-noeqjoin/olist-fuzzyeq-jaccard.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/olist-fuzzyeq-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/olist-fuzzyeq-jaccard.sqlpp index 3bd074d..6ce100b 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/olist-fuzzyeq-jaccard.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/olist-fuzzyeq-jaccard.sqlpp @@ -34,7 +34,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -48,7 +48,7 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; @@ -56,7 +56,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-noeqjoin_olist-fuzzyeq-jaccard.adm" +write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_olist-fuzzyeq-jaccard.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-noeqjoin/olist-jaccard-inline.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/olist-jaccard-inline.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/olist-jaccard-inline.sqlpp index c3020ff..a003dee 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/olist-jaccard-inline.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/olist-jaccard-inline.sqlpp @@ -35,7 +35,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -49,13 +49,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-noeqjoin_olist-jaccard-inline.adm" +write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_olist-jaccard-inline.adm"; select element {'ainterests':a.interests,'binterests':b.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/inverted-index-join-noeqjoin/olist-jaccard.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/olist-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/olist-jaccard.sqlpp index 06ba548..e0a1a64 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/olist-jaccard.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/olist-jaccard.sqlpp @@ -34,7 +34,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -48,7 +48,7 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; @@ -56,7 +56,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-noeqjoin_olist-jaccard.adm" +write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_olist-jaccard.adm"; select element {'ainterests':a.interests,'binterests':b.interests} 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-noeqjoin/ulist-fuzzyeq-jaccard.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ulist-fuzzyeq-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ulist-fuzzyeq-jaccard.sqlpp index e6a6290..4a1bf06 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ulist-fuzzyeq-jaccard.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ulist-fuzzyeq-jaccard.sqlpp @@ -34,7 +34,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -48,7 +48,7 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; @@ -56,7 +56,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-noeqjoin_ulist-fuzzyeq-jaccard.adm" +write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_ulist-fuzzyeq-jaccard.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-noeqjoin/ulist-jaccard-inline.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ulist-jaccard-inline.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ulist-jaccard-inline.sqlpp index fd530b0..1372490 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ulist-jaccard-inline.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ulist-jaccard-inline.sqlpp @@ -35,7 +35,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -49,13 +49,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-noeqjoin_ulist-jaccard-inline.adm" +write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_ulist-jaccard-inline.adm"; select element {'ainterests':a.interests,'binterests':b.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/inverted-index-join-noeqjoin/ulist-jaccard.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ulist-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ulist-jaccard.sqlpp index 0a1c11d..788c90f 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ulist-jaccard.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/ulist-jaccard.sqlpp @@ -34,7 +34,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -48,7 +48,7 @@ create type test.CustomerType as age : integer? } ] -} +}; create dataset Customers(CustomerType) primary key cid; @@ -56,7 +56,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-noeqjoin_ulist-jaccard.adm" +write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_ulist-jaccard.adm"; select element {'ainterests':a.interests,'binterests':b.interests} 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-noeqjoin/word-fuzzyeq-jaccard.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/word-fuzzyeq-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/word-fuzzyeq-jaccard.sqlpp index f2f32c7..d5f0a42 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/word-fuzzyeq-jaccard.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/word-fuzzyeq-jaccard.sqlpp @@ -36,7 +36,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -45,7 +45,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -53,7 +53,7 @@ create dataset CSX(CSXType) primary key id; create index keyword_index on DBLP (title) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_word-fuzzyeq-jaccard.adm" +write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_word-fuzzyeq-jaccard.adm"; set `simfunction` `jaccard`; set `simthreshold` `0.5f`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/word-jaccard-inline.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/word-jaccard-inline.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/word-jaccard-inline.sqlpp index 98636bc..9530163 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/word-jaccard-inline.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/word-jaccard-inline.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 keyword_index on DBLP (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.title,'btitle':b.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/inverted-index-join-noeqjoin/word-jaccard.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/word-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/word-jaccard.sqlpp index 7119e1c..89305c3 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/word-jaccard.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join-noeqjoin/word-jaccard.sqlpp @@ -36,7 +36,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -45,7 +45,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -53,7 +53,7 @@ create dataset CSX(CSXType) primary key id; create index keyword_index on DBLP (title) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_word-jaccard.adm" +write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_word-jaccard.adm"; select element {'atitle':a.title,'btitle':b.title} from DBLP as a, CSX as b
