http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-fuzzyeq-jaccard_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-fuzzyeq-jaccard_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-fuzzyeq-jaccard_03.sqlpp index 1e3fa3d..c6c38b7 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-fuzzyeq-jaccard_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-fuzzyeq-jaccard_03.sqlpp @@ -35,13 +35,13 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index keyword_index on DBLP (title) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_word-fuzzyeq-jaccard_03.adm" +write output to asterix_nc1:"rttest/inverted-index-join_word-fuzzyeq-jaccard_03.adm"; set `simfunction` `jaccard`; set `simthreshold` `0.5f`;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard-check-after-btree-access.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard-check-after-btree-access.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard-check-after-btree-access.sqlpp index b6569e4..50d2442 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard-check-after-btree-access.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/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.TweetMessageType as closed { @@ -50,7 +50,7 @@ create type test.TweetMessageType as `message-text` : string, countA : integer, countB : integer -} +}; create dataset TweetMessages(TweetMessageType) primary key tweetid; @@ -62,7 +62,7 @@ create index msgCountBIx on TweetMessages (countB) type btree; create index msgTextIx on TweetMessages (`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.tweetid,'t2':t2.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/inverted-index-join/word-jaccard-check_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard-check_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard-check_01.sqlpp index df82121..79d4834 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard-check_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard-check_01.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -44,7 +44,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -52,7 +52,7 @@ create dataset CSX(CSXType) primary key id; create index keyword_index on DBLP (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/inverted-index-join/word-jaccard-check_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard-check_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard-check_02.sqlpp index 0e6da99..0c2890a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard-check_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard-check_02.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -44,7 +44,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -52,7 +52,7 @@ create dataset CSX(CSXType) primary key id; create index keyword_index on CSX (title) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard-check_02.adm" +write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard-check_02.adm"; select element {'arec':a,'brec':b} from DBLP as a, CSX as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard-check_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard-check_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard-check_03.sqlpp index 391d7ad..fdf6235 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard-check_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard-check_03.sqlpp @@ -35,13 +35,13 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index keyword_index on DBLP (title) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard-check_03.adm" +write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard-check_03.adm"; select element {'arec':a,'brec':b} from DBLP as a, DBLP as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard-check_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard-check_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard-check_04.sqlpp index 5332721..8eb16d7 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard-check_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard-check_04.sqlpp @@ -36,13 +36,13 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index keyword_index on DBLP (title) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard-check_04.adm" +write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard-check_04.adm"; select element {'arec':a,'brec':b,'jacc':jacc[1]} from DBLP as a, DBLP as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard_01.sqlpp index 2670fd7..50e657a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard_01.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -44,7 +44,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -52,7 +52,7 @@ create dataset CSX(CSXType) primary key id; create index keyword_index on DBLP (title) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_word-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/inverted-index-join/word-jaccard_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard_02.sqlpp index b5e307c..b943eec 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard_02.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -44,7 +44,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -52,7 +52,7 @@ create dataset CSX(CSXType) primary key id; create index keyword_index on CSX (title) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard_02.adm" +write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard_02.adm"; select element {'arec':a,'brec':b} from DBLP as a, CSX as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard_03.sqlpp index 1bb7c3c..37a119b 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard_03.sqlpp @@ -35,13 +35,13 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index keyword_index on DBLP (title) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard_03.adm" +write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard_03.adm"; select element {'arec':a,'brec':b} from DBLP as a, DBLP as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard_04.sqlpp index 0d4848a..584522a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/inverted-index-join/word-jaccard_04.sqlpp @@ -36,13 +36,13 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index keyword_index on DBLP (title) type keyword; -write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard_04.adm" +write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard_04.adm"; select element {'arec':a,'brec':b,'jacc':jacc} from DBLP as a, DBLP as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/join-super-key_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/join-super-key_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/join-super-key_01.sqlpp index edcfdda..0e7fc0b 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/join-super-key_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/join-super-key_01.sqlpp @@ -32,7 +32,7 @@ create type `join-super-key_1`.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type `join-super-key_1`.NationType as closed { @@ -40,7 +40,7 @@ create type `join-super-key_1`.NationType as n_name : string, n_regionkey : integer, n_comment : string -} +}; create type `join-super-key_1`.LineItemType as closed { @@ -60,7 +60,7 @@ create type `join-super-key_1`.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type `join-super-key_1`.PartType as closed { @@ -73,7 +73,7 @@ create type `join-super-key_1`.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type `join-super-key_1`.PartSuppType as closed { @@ -82,13 +82,13 @@ create type `join-super-key_1`.PartSuppType as ps_availqty : integer, ps_supplycost : double, ps_comment : string -} +}; create nodegroup group1 if not exists on asterix_nc1, asterix_nc2 ; -write output to asterix_nc1:"/tmp/join-super-key_01.adm" +write output to asterix_nc1:"/tmp/join-super-key_01.adm"; create dataset LineItems(LineItemType) primary key l_partkey,l_linenumber on group1; create dataset PartSupp(PartSuppType) primary key ps_partkey,ps_suppkey on group1; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/join-super-key_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/join-super-key_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/join-super-key_02.sqlpp index 99330f9..7247cdc 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/join-super-key_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/join-super-key_02.sqlpp @@ -32,7 +32,7 @@ create type `join-super-key_01`.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type `join-super-key_01`.NationType as closed { @@ -40,7 +40,7 @@ create type `join-super-key_01`.NationType as n_name : string, n_regionkey : integer, n_comment : string -} +}; create type `join-super-key_01`.LineItemType as closed { @@ -60,7 +60,7 @@ create type `join-super-key_01`.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type `join-super-key_01`.PartType as closed { @@ -73,7 +73,7 @@ create type `join-super-key_01`.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type `join-super-key_01`.PartSuppType as closed { @@ -82,13 +82,13 @@ create type `join-super-key_01`.PartSuppType as ps_availqty : integer, ps_supplycost : double, ps_comment : string -} +}; create nodegroup group1 if not exists on asterix_nc1, asterix_nc2 ; -write output to asterix_nc1:"/tmp/join-super-key_01.adm" +write output to asterix_nc1:"/tmp/join-super-key_01.adm"; create dataset LineItems(LineItemType) primary key l_partkey,l_linenumber on group1; create dataset PartSupp(PartSuppType) primary key ps_partkey,ps_suppkey on group1; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/limit-issue353.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/limit-issue353.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/limit-issue353.sqlpp index 12d0d0c..86ce33b 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/limit-issue353.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/limit-issue353.sqlpp @@ -47,11 +47,11 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; -write output to asterix_nc1:"/tmp/push_limit.adm" +write output to asterix_nc1:"/tmp/push_limit.adm"; select element {'l_returnflag':l.l_returnflag,'l_linestatus':l.l_linestatus,'l_shipmode':l.l_shipmode} from LineItem as l limit 2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/loj-super-key_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/loj-super-key_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/loj-super-key_01.sqlpp index 05e1ef4..38bd3e3 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/loj-super-key_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/loj-super-key_01.sqlpp @@ -32,7 +32,7 @@ create type `loj-super-key_01`.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type `loj-super-key_01`.NationType as closed { @@ -40,7 +40,7 @@ create type `loj-super-key_01`.NationType as n_name : string, n_regionkey : integer, n_comment : string -} +}; create type `loj-super-key_01`.LineItemType as closed { @@ -60,7 +60,7 @@ create type `loj-super-key_01`.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type `loj-super-key_01`.PartType as closed { @@ -73,7 +73,7 @@ create type `loj-super-key_01`.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type `loj-super-key_01`.PartSuppType as closed { @@ -82,13 +82,13 @@ create type `loj-super-key_01`.PartSuppType as ps_availqty : integer, ps_supplycost : double, ps_comment : string -} +}; create nodegroup group1 if not exists on asterix_nc1, asterix_nc2 ; -write output to asterix_nc1:"/tmp/loj-super-key_01.adm" +write output to asterix_nc1:"/tmp/loj-super-key_01.adm"; create dataset LineItems(LineItemType) primary key l_partkey,l_linenumber on group1; create dataset PartSupp(PartSuppType) primary key ps_partkey,ps_suppkey on group1; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/loj-super-key_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/loj-super-key_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/loj-super-key_02.sqlpp index 3c90742..9705785 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/loj-super-key_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/loj-super-key_02.sqlpp @@ -32,7 +32,7 @@ create type `loj-super-key_02`.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type `loj-super-key_02`.NationType as closed { @@ -40,7 +40,7 @@ create type `loj-super-key_02`.NationType as n_name : string, n_regionkey : integer, n_comment : string -} +}; create type `loj-super-key_02`.LineItemType as closed { @@ -60,7 +60,7 @@ create type `loj-super-key_02`.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type `loj-super-key_02`.PartType as closed { @@ -73,7 +73,7 @@ create type `loj-super-key_02`.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type `loj-super-key_02`.PartSuppType as closed { @@ -82,13 +82,13 @@ create type `loj-super-key_02`.PartSuppType as ps_availqty : integer, ps_supplycost : double, ps_comment : string -} +}; create nodegroup group1 if not exists on asterix_nc1, asterix_nc2 ; -write output to asterix_nc1:"/tmp/loj-super-key_01.adm" +write output to asterix_nc1:"/tmp/loj-super-key_01.adm"; create dataset LineItems(LineItemType) primary key l_partkey,l_linenumber on group1; create dataset PartSupp(PartSuppType) primary key ps_partkey,ps_suppkey on group1; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nest_aggregate.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nest_aggregate.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nest_aggregate.sqlpp index 1c2e4c9..174856f 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nest_aggregate.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nest_aggregate.sqlpp @@ -40,7 +40,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : integer, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -52,7 +52,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -63,7 +63,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -71,14 +71,14 @@ create type tpch.NationType as n_name : string, n_regionkey : integer, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : integer, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -91,7 +91,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -100,7 +100,7 @@ create type tpch.PartSuppType as ps_availqty : integer, ps_supplycost : double, ps_comment : string -} +}; create dataset Orders(OrderType) primary key o_orderkey; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/disjunction-to-join.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/disjunction-to-join.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/disjunction-to-join.sqlpp index edfef0c..a20c847 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/disjunction-to-join.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/disjunction-to-join.sqlpp @@ -31,14 +31,14 @@ use test; create type test.NestedTestType as { idx : string -} +}; 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-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01.sqlpp index e43686a..b6d1a58 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-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 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 msgCountBIx on TweetMessages (nested.countB) type btree; -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-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02.sqlpp index c1a5d31..c92304a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-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,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 msgCountBIx on TweetMessages (nested.countB) type btree; -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-index/btree-index-join/primary-composite-key-join_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-join_01.sqlpp index f98bbe4..4e864f4 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-join_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-join_01.sqlpp @@ -33,16 +33,16 @@ create type test.Nametmp as { fname : string, lname : string -} +}; create type test.Name as { nested : Nametmp -} +}; create dataset Names(Name) primary key nested.fname,nested.lname; -write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-join_01.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-join_01.adm"; select element {'emp1':emp1,'emp2':emp2} from Names as emp1, Names as emp2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-join_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-join_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-join_02.sqlpp index e258bed..bf04345 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-join_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-join_02.sqlpp @@ -33,16 +33,16 @@ create type test.Nametmp as { fname : string, lname : string -} +}; create type test.Name as { nested : Nametmp -} +}; create dataset Names(Name) primary key nested.fname,nested.lname; -write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-join_02.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-join_02.adm"; select element {'emp1':emp1,'emp2':emp2} from Names as emp1, Names as emp2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-join_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-join_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-join_03.sqlpp index 88a49e4..c3c074a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-join_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-join_03.sqlpp @@ -33,16 +33,16 @@ create type test.Nametmp as { fname : string, lname : string -} +}; create type test.Name as { nested : Nametmp -} +}; create dataset Names(Name) primary key nested.fname,nested.lname; -write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-join_03.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-join_03.adm"; select element {'emp1':emp1,'emp2':emp2} from Names as emp1, Names as emp2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_01.sqlpp index 1256c80..79a5709 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_01.sqlpp @@ -33,16 +33,16 @@ create type test.Nametmp as { fname : string, lname : string -} +}; create type test.Name as { nested : Nametmp -} +}; create dataset Names(Name) primary key nested.fname,nested.lname; -write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-prefix-join_01.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-prefix-join_01.adm"; select element {'emp1':emp1,'emp2':emp2} from Names as emp1, Names as emp2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_02.sqlpp index a974c25..824f076 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_02.sqlpp @@ -33,16 +33,16 @@ create type test.Nametmp as { fname : string, lname : string -} +}; create type test.Name as { nested : Nametmp -} +}; create dataset Names(Name) primary key nested.fname,nested.lname; -write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-prefix-join_02.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-prefix-join_02.adm"; select element {'emp1':emp1,'emp2':emp2} from Names as emp1, Names as emp2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_03.sqlpp index 4725180..eff456b 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_03.sqlpp @@ -33,16 +33,16 @@ create type test.Nametmp as { fname : string, lname : string -} +}; create type test.Name as { nested : Nametmp -} +}; create dataset Names(Name) primary key nested.fname,nested.lname; -write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-prefix-join_03.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-prefix-join_03.adm"; select element {'emp1':emp1,'emp2':emp2} from Names as emp1, Names as emp2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_04.sqlpp index f2d0a26..726b78e 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_04.sqlpp @@ -33,16 +33,16 @@ create type test.Nametmp as { fname : string, lname : string -} +}; create type test.Name as { nested : Nametmp -} +}; create dataset Names(Name) primary key nested.fname,nested.lname; -write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-prefix-join_04.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-prefix-join_04.adm"; select element {'emp1':emp1,'emp2':emp2} from Names as emp1, Names as emp2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_05.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_05.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_05.sqlpp index c46863d..2841b8d 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_05.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_05.sqlpp @@ -33,16 +33,16 @@ create type test.Nametmp as { fname : string, lname : string -} +}; create type test.Name as { nested : Nametmp -} +}; create dataset Names(Name) primary key nested.fname,nested.lname; -write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-prefix-join_05.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-prefix-join_05.adm"; select element {'emp1':emp1,'emp2':emp2} from Names as emp1, Names as emp2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_06.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_06.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_06.sqlpp index f98307f..dc9beef 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_06.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-composite-key-prefix-join_06.sqlpp @@ -33,16 +33,16 @@ create type test.Nametmp as { fname : string, lname : string -} +}; create type test.Name as { nested : Nametmp -} +}; create dataset Names(Name) primary key nested.fname,nested.lname; -write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-prefix-join_06.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-prefix-join_06.adm"; select element {'emp1':emp1,'emp2':emp2} from Names as emp1, Names as emp2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join-multipred.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join-multipred.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join-multipred.sqlpp index 681a955..5d3c7ab 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join-multipred.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join-multipred.sqlpp @@ -36,7 +36,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerTypetmp as closed { @@ -49,7 +49,7 @@ create type test.CustomerTypetmp as total : float } -} +}; create type test.OrderTypetmp as closed { @@ -59,23 +59,23 @@ create type test.OrderTypetmp as orderpriority : string, clerk : string, total : float -} +}; create type test.CustomerType as closed { nested : CustomerTypetmp -} +}; create type test.OrderType as closed { nested : OrderTypetmp -} +}; create dataset Customers(CustomerType) primary key nested.cid; create dataset Orders(OrderType) primary key nested.oid; -write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join-multipred.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join-multipred.adm"; select element {'customer':c.nested,'order':o.nested} from Customers as c, Orders as o http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join-neg_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join-neg_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join-neg_01.sqlpp index 2f2d30b..3debb01 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join-neg_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join-neg_01.sqlpp @@ -32,18 +32,18 @@ create type test1.TestTypetmp as key2 : integer, fname : string, lname : string -} +}; create type test1.TestType as { nested : TestTypetmp -} +}; create dataset test1.DsOne(TestType) primary key nested.key1; create dataset test1.DsTwo(TestType) primary key nested.key1; -write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join-neg_01.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join-neg_01.adm"; select element x from `test1.DsOne` as x, `test1.DsTwo` as y http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join_01.sqlpp index 793ca8e..7ed0a41 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join_01.sqlpp @@ -32,18 +32,18 @@ create type test1.TestTypetmp as key2 : integer, fname : string, lname : string -} +}; create type test1.TestType as { nested : TestTypetmp -} +}; create dataset test1.DsOne(TestType) primary key nested.key1; create dataset test1.DsTwo(TestType) primary key nested.key1; -write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join_01.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join_01.adm"; select element x from `test1.DsOne` as x, `test1.DsTwo` as y http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join_02.sqlpp index 4606a4b..421b65d 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join_02.sqlpp @@ -32,18 +32,18 @@ create type test1.TestTypetmp as key2 : integer, fname : string, lname : string -} +}; create type test1.TestType as { nested : TestTypetmp -} +}; create dataset test1.DsOne(TestType) primary key nested.key1; create dataset test1.DsTwo(TestType) primary key nested.key1; -write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join_02.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join_02.adm"; select element x from `test1.DsOne` as x, `test1.DsTwo` as y http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join_03.sqlpp index e786edb..3c73233 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join_03.sqlpp @@ -34,7 +34,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerTypetmp as closed { @@ -47,7 +47,7 @@ create type test.CustomerTypetmp as total : float } -} +}; create type test.OrderTypetmp as closed { @@ -57,23 +57,23 @@ create type test.OrderTypetmp as orderpriority : string, clerk : string, total : float -} +}; create type test.CustomerType as closed { nested : CustomerTypetmp -} +}; create type test.OrderType as closed { nested : OrderTypetmp -} +}; create dataset Customers(CustomerType) primary key nested.cid; create dataset Orders(OrderType) primary key nested.oid; -write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join_04.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join_04.adm"; select element {'customer':c.nested,'order':o.nested} from Customers as c, Orders as o http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join_04.sqlpp index fc552b1..67e874c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join_04.sqlpp @@ -34,7 +34,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerTypetmp as closed { @@ -47,7 +47,7 @@ create type test.CustomerTypetmp as total : float } -} +}; create type test.OrderTypetmp as closed { @@ -57,23 +57,23 @@ create type test.OrderTypetmp as orderpriority : string, clerk : string, total : float -} +}; create type test.CustomerType as closed { nested : CustomerTypetmp -} +}; create type test.OrderType as closed { nested : OrderTypetmp -} +}; create dataset Customers(CustomerType) primary key nested.cid; create dataset Orders(OrderType) primary key nested.oid; -write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join_05.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join_05.adm"; select element {'customer':c.nested,'order':o.nested} from Orders as o, Customers as c http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join_05.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join_05.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join_05.sqlpp index 35a3754..32be61e 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join_05.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-equi-join_05.sqlpp @@ -34,7 +34,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerTypetmp as closed { @@ -47,16 +47,16 @@ create type test.CustomerTypetmp as total : float } -} +}; create type test.CustomerType as closed { nested : CustomerTypetmp -} +}; create dataset Customers(CustomerType) primary key nested.cid; -write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join_06.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join_06.adm"; select element {'customer1':c1.nested,'customer2':c2.nested} from Customers as c1, Customers as c2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-ge-join_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-ge-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-ge-join_01.sqlpp index 9777a43..434c47d 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-ge-join_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-ge-join_01.sqlpp @@ -32,18 +32,18 @@ create type test1.TestTypetmp as key2 : integer, fname : string, lname : string -} +}; create type test1.TestType as { nested : TestTypetmp -} +}; create dataset test1.DsOne(TestType) primary key nested.key1; create dataset test1.DsTwo(TestType) primary key nested.key1; -write output to asterix_nc1:"rttest/btree-index-join_primary-ge-join_01.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-ge-join_01.adm"; select element x from `test1.DsOne` as x, `test1.DsTwo` as y http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-gt-join_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-gt-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-gt-join_01.sqlpp index ede66d5..45827bf 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-gt-join_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-gt-join_01.sqlpp @@ -32,18 +32,18 @@ create type test1.TestTypetmp as key2 : integer, fname : string, lname : string -} +}; create type test1.TestType as { nested : TestTypetmp -} +}; create dataset test1.DsOne(TestType) primary key nested.key1; create dataset test1.DsTwo(TestType) primary key nested.key1; -write output to asterix_nc1:"rttest/btree-index-join_primary-gt-join_01.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-gt-join_01.adm"; select element x from `test1.DsOne` as x, `test1.DsTwo` as y http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-le-join_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-le-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-le-join_01.sqlpp index 82775e7..a2029f3 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-le-join_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-le-join_01.sqlpp @@ -32,18 +32,18 @@ create type test1.TestTypetmp as key2 : integer, fname : string, lname : string -} +}; create type test1.TestType as { nested : TestTypetmp -} +}; create dataset test1.DsOne(TestType) primary key nested.key1; create dataset test1.DsTwo(TestType) primary key nested.key1; -write output to asterix_nc1:"rttest/btree-index-join_primary-le-join_01.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-le-join_01.adm"; select element x from `test1.DsOne` as x, `test1.DsTwo` as y http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-lt-join_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-lt-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-lt-join_01.sqlpp index 039fa07..20e535f 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-lt-join_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/primary-lt-join_01.sqlpp @@ -32,18 +32,18 @@ create type test1.TestTypetmp as key2 : integer, fname : string, lname : string -} +}; create type test1.TestType as { nested : TestTypetmp -} +}; create dataset test1.DsOne(TestType) primary key nested.key1; create dataset test1.DsTwo(TestType) primary key nested.key1; -write output to asterix_nc1:"rttest/btree-index-join_primary-lt-join_01.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-lt-join_01.adm"; select element x from `test1.DsOne` as x, `test1.DsTwo` as y http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/secondary-equi-join-multiindex.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/secondary-equi-join-multiindex.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/secondary-equi-join-multiindex.sqlpp index aac2e50..3bbf0e0 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/secondary-equi-join-multiindex.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/secondary-equi-join-multiindex.sqlpp @@ -36,7 +36,7 @@ create type test.EmploymentType as `organization-name` : string, `start-date` : date, `end-date` : date? -} +}; create type test.FacebookUserTypetmp as closed { @@ -48,7 +48,7 @@ create type test.FacebookUserTypetmp as `user-since-copy` : datetime, `friend-ids` : {{integer}}, employment : [EmploymentType] -} +}; create type test.FacebookMessageTypetmp as closed { @@ -59,17 +59,17 @@ create type test.FacebookMessageTypetmp as `in-response-to` : integer?, `sender-location` : point?, message : string -} +}; create type test.FacebookUserType as closed { nested : FacebookUserTypetmp -} +}; create type test.FacebookMessageType as closed { nested : FacebookMessageTypetmp -} +}; create dataset FacebookUsers(FacebookUserType) primary key nested.id; @@ -77,7 +77,7 @@ create dataset FacebookMessages(FacebookMessageType) primary key nested.`messag create index fbmIdxAutId if not exists on FacebookMessages (nested.`author-id-copy`) type btree; -write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join-multiindex.adm" +write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join-multiindex.adm"; select element {'fbu-ID':user.nested.id,'fbm-auth-ID':message.nested.`author-id`,'uname':user.nested.name,'message':message.nested.message} from FacebookUsers as user, FacebookMessages as message http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/secondary-equi-join-multipred.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/secondary-equi-join-multipred.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/secondary-equi-join-multipred.sqlpp index 2963a26..2c0a77f 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/secondary-equi-join-multipred.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/secondary-equi-join-multipred.sqlpp @@ -38,7 +38,7 @@ create type test.DBLPTypetmp as title : string, authors : string, misc : string -} +}; create type test.CSXTypetmp as closed { @@ -47,17 +47,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; @@ -65,7 +65,7 @@ create dataset CSX(CSXType) primary key nested.id; create index title_index on DBLP (nested.title) type btree; -write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join-multipred.adm" +write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join-multipred.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/btree-index-join/secondary-equi-join_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/secondary-equi-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/secondary-equi-join_01.sqlpp index eeddff9..67c5afb 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/secondary-equi-join_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index-join/secondary-equi-join_01.sqlpp @@ -36,7 +36,7 @@ create type test.DBLPTypetmp as title : string, authors : string, misc : string -} +}; create type test.CSXTypetmp as closed { @@ -45,17 +45,17 @@ create type test.CSXTypetmp as title : string, authors : string, misc : string -} +}; create type test.DBLPType as closed { nested : DBLPTypetmp -} +}; create type test.CSXType as closed { nested : CSXTypetmp -} +}; create dataset DBLP(DBLPType) primary key nested.id; @@ -63,7 +63,7 @@ create dataset CSX(CSXType) primary key nested.id; create index title_index on DBLP (nested.title) type btree; -write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join_01.adm" +write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join_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/btree-index/btree-primary-01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-01.sqlpp index 60d8cca..af9ce63 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-01.sqlpp @@ -29,17 +29,17 @@ create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index_btree-primary-01.adm" +write output to asterix_nc1:"rttest/btree-index_btree-primary-01.adm"; create type test.TestTypetmp as { fname : string, lname : string -} +}; create type test.TestType as { nested : TestTypetmp -} +}; create dataset testdst(TestType) primary key nested.fname,nested.lname; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-02.sqlpp index d760d38..c653731 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-02.sqlpp @@ -29,17 +29,17 @@ create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index_btree-primary-02.adm" +write output to asterix_nc1:"rttest/btree-index_btree-primary-02.adm"; create type test.TestTypetmp as { fname : string, lname : string -} +}; create type test.TestType as { nested : TestTypetmp -} +}; create dataset testdst(TestType) primary key nested.fname,nested.lname; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-03.sqlpp index 690d5d0..689b3d7 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-03.sqlpp @@ -29,17 +29,17 @@ create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index_btree-primary-03.adm" +write output to asterix_nc1:"rttest/btree-index_btree-primary-03.adm"; create type test.TestTypetmp as { fname : string, lname : string -} +}; create type test.TestType as { nested : TestTypetmp -} +}; create dataset testdst(TestType) primary key nested.fname,nested.lname; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-04.sqlpp index ecbeda5..56b6f37 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-04.sqlpp @@ -29,17 +29,17 @@ create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index_btree-primary-04.adm" +write output to asterix_nc1:"rttest/btree-index_btree-primary-04.adm"; create type test.TestTypetmp as { fname : string, lname : string -} +}; create type test.TestType as { nested : TestTypetmp -} +}; create dataset testdst(TestType) primary key nested.fname,nested.lname; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-05.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-05.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-05.sqlpp index cc25e32..1223043 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-05.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-05.sqlpp @@ -29,17 +29,17 @@ create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index_btree-primary-05.adm" +write output to asterix_nc1:"rttest/btree-index_btree-primary-05.adm"; create type test.TestTypetmp as { fname : string, lname : string -} +}; create type test.TestType as { nested : TestTypetmp -} +}; create dataset testdst(TestType) primary key nested.fname,nested.lname; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-06.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-06.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-06.sqlpp index 62f0504..d530d0e 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-06.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-06.sqlpp @@ -29,17 +29,17 @@ create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index_btree-primary-06.adm" +write output to asterix_nc1:"rttest/btree-index_btree-primary-06.adm"; create type test.TestTypetmp as { fname : string, lname : string -} +}; create type test.TestType as { nested : TestTypetmp -} +}; create dataset testdst(TestType) primary key nested.fname,nested.lname; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-07.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-07.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-07.sqlpp index dc2d7f1..deee36b 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-07.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-07.sqlpp @@ -29,17 +29,17 @@ create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index_btree-primary-07.adm" +write output to asterix_nc1:"rttest/btree-index_btree-primary-07.adm"; create type test.TestTypetmp as { fname : string, lname : string -} +}; create type test.TestType as { nested : TestTypetmp -} +}; create dataset testdst(TestType) primary key nested.fname,nested.lname; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-08.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-08.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-08.sqlpp index 68df4c2..0c21eaa 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-08.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-08.sqlpp @@ -28,17 +28,17 @@ create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index_btree-primary-08.adm" +write output to asterix_nc1:"rttest/btree-index_btree-primary-08.adm"; create type test.TestTypetmp as { fname : string, lname : string -} +}; create type test.TestType as { nested : TestTypetmp -} +}; create dataset testdst(TestType) primary key nested.fname,nested.lname; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-09.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-09.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-09.sqlpp index abc28e6..f343db9 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-09.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-09.sqlpp @@ -30,17 +30,17 @@ create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index_btree-primary-09.adm" +write output to asterix_nc1:"rttest/btree-index_btree-primary-09.adm"; create type test.TestTypetmp as { fname : string, lname : string -} +}; create type test.TestType as { nested : TestTypetmp -} +}; create dataset testdst(TestType) primary key nested.fname,nested.lname; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-10.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-10.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-10.sqlpp index 23ead3b..dedde55 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-10.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-10.sqlpp @@ -30,17 +30,17 @@ create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index_btree-primary-10.adm" +write output to asterix_nc1:"rttest/btree-index_btree-primary-10.adm"; create type test.TestTypetmp as { fname : string, lname : string -} +}; create type test.TestType as { nested : TestTypetmp -} +}; create dataset testdst(TestType) primary key nested.fname,nested.lname; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-11.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-11.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-11.sqlpp index ba77a69..2efc179 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-11.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-11.sqlpp @@ -30,17 +30,17 @@ create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index_btree-primary-11.adm" +write output to asterix_nc1:"rttest/btree-index_btree-primary-11.adm"; create type test.TestTypetmp as { fname : string, lname : string -} +}; create type test.TestType as { nested : TestTypetmp -} +}; create dataset testdst(TestType) primary key nested.fname,nested.lname; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-12.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-12.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-12.sqlpp index a9d6e6e..8f61a7f 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-12.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-12.sqlpp @@ -30,17 +30,17 @@ create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index_btree-primary-12.adm" +write output to asterix_nc1:"rttest/btree-index_btree-primary-12.adm"; create type test.TestTypetmp as { fname : string, lname : string -} +}; create type test.TestType as { nested : TestTypetmp -} +}; create dataset testdst(TestType) primary key nested.fname,nested.lname; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-13.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-13.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-13.sqlpp index 24719f2..85c6606 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-13.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-13.sqlpp @@ -30,17 +30,17 @@ create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index_btree-primary-13.adm" +write output to asterix_nc1:"rttest/btree-index_btree-primary-13.adm"; create type test.TestTypetmp as { fname : string, lname : string -} +}; create type test.TestType as { nested : TestTypetmp -} +}; create dataset testdst(TestType) primary key nested.fname,nested.lname; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-14.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-14.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-14.sqlpp index aa557e9..8662c7b 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-14.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-14.sqlpp @@ -30,17 +30,17 @@ create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index_btree-primary-14.adm" +write output to asterix_nc1:"rttest/btree-index_btree-primary-14.adm"; create type test.TestTypetmp as { fname : string, lname : string -} +}; create type test.TestType as { nested : TestTypetmp -} +}; create dataset testdst(TestType) primary key nested.fname,nested.lname; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-15.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-15.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-15.sqlpp index ec6394c..4222b7f 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-15.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-15.sqlpp @@ -30,17 +30,17 @@ create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index_btree-primary-15.adm" +write output to asterix_nc1:"rttest/btree-index_btree-primary-15.adm"; create type test.TestTypetmp as { fname : string, lname : string -} +}; create type test.TestType as { nested : TestTypetmp -} +}; create dataset testdst(TestType) primary key nested.fname,nested.lname; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-16.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-16.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-16.sqlpp index d556e6b..63a6221 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-16.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-16.sqlpp @@ -30,17 +30,17 @@ create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index_btree-primary-16.adm" +write output to asterix_nc1:"rttest/btree-index_btree-primary-16.adm"; create type test.TestTypetmp as { fname : string, lname : string -} +}; create type test.TestType as { nested : TestTypetmp -} +}; create dataset testdst(TestType) primary key nested.fname,nested.lname; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-17.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-17.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-17.sqlpp index bcfcf58..e41e972 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-17.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-17.sqlpp @@ -30,17 +30,17 @@ create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index_btree-primary-17.adm" +write output to asterix_nc1:"rttest/btree-index_btree-primary-17.adm"; create type test.TestTypetmp as { fname : string, lname : string -} +}; create type test.TestType as { nested : TestTypetmp -} +}; create dataset testdst(TestType) primary key nested.fname,nested.lname; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-18.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-18.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-18.sqlpp index 075f684..33bd030 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-18.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-18.sqlpp @@ -30,17 +30,17 @@ create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index_btree-primary-18.adm" +write output to asterix_nc1:"rttest/btree-index_btree-primary-18.adm"; create type test.TestTypetmp as { fname : string, lname : string -} +}; create type test.TestType as { nested : TestTypetmp -} +}; create dataset testdst(TestType) primary key nested.fname,nested.lname; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-19.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-19.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-19.sqlpp index 4741ac6..886da30 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-19.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-19.sqlpp @@ -30,17 +30,17 @@ create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index_btree-primary-19.adm" +write output to asterix_nc1:"rttest/btree-index_btree-primary-19.adm"; create type test.TestTypetmp as { fname : string, lname : string -} +}; create type test.TestType as { nested : TestTypetmp -} +}; create dataset testdst(TestType) primary key nested.fname,nested.lname; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-20.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-20.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-20.sqlpp index e9c7e32..88f8290 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-20.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-20.sqlpp @@ -30,17 +30,17 @@ create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index_btree-primary-20.adm" +write output to asterix_nc1:"rttest/btree-index_btree-primary-20.adm"; create type test.TestTypetmp as { fname : string, lname : string -} +}; create type test.TestType as { nested : TestTypetmp -} +}; create dataset testdst(TestType) primary key nested.fname,nested.lname; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-21.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-21.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-21.sqlpp index 2b39082..818f373 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-21.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-21.sqlpp @@ -30,17 +30,17 @@ create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index_btree-primary-21.adm" +write output to asterix_nc1:"rttest/btree-index_btree-primary-21.adm"; create type test.TestTypetmp as { fname : string, lname : string -} +}; create type test.TestType as { nested : TestTypetmp -} +}; create dataset testdst(TestType) primary key nested.fname;
