You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@asterixdb.apache.org by mb...@apache.org on 2016/06/30 16:55:27 UTC
[6/9] asterixdb git commit: Hard Tabs++
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-join/btree-index-nested-loop-join/btree-index-nested-loop-join.3.query.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-join/btree-index-nested-loop-join/btree-index-nested-loop-join.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-join/btree-index-nested-loop-join/btree-index-nested-loop-join.3.query.aql
index 6356191..ceea899 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-join/btree-index-nested-loop-join/btree-index-nested-loop-join.3.query.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-join/btree-index-nested-loop-join/btree-index-nested-loop-join.3.query.aql
@@ -30,4 +30,4 @@ for $r in dataset results
and
$tm.user /*+ indexnl */ = $tu.screen-name
order by $tm.tweetid
- return $tm.tweetid;
+ return $tm.tweetid;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-leftouterjoin/probe-pidx-with-join-invidx-sidx1/probe-pidx-with-join-invidx-sidx1.3.query.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-leftouterjoin/probe-pidx-with-join-invidx-sidx1/probe-pidx-with-join-invidx-sidx1.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-leftouterjoin/probe-pidx-with-join-invidx-sidx1/probe-pidx-with-join-invidx-sidx1.3.query.aql
index c6c2113..149c4b1 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-leftouterjoin/probe-pidx-with-join-invidx-sidx1/probe-pidx-with-join-invidx-sidx1.3.query.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-leftouterjoin/probe-pidx-with-join-invidx-sidx1/probe-pidx-with-join-invidx-sidx1.3.query.aql
@@ -18,7 +18,7 @@
*/
/*
* Description : Test that left-outer-join may use two available indexes, one for primary index in prob subtree and another for secondary keyword inverted index in index subtree.
- * Issue : 730, 741
+ * Issue : 730, 741
* Expected Res : Success
* Date : 16th May 2014
*/
@@ -29,10 +29,10 @@ for $t1 in dataset('TweetMessages')
where $t1.tweetid > int64("240")
order by $t1.tweetid
return {
- "tweet": {"id": $t1.tweetid, "topics" : $t1.referred-topics} ,
+ "tweet": {"id": $t1.tweetid, "topics" : $t1.referred-topics} ,
"similar-tweets": for $t2 in dataset('TweetMessages')
let $sim := similarity-jaccard-check($t1.referred-topics, $t2.referred-topics, 0.5f)
- where $sim[0] and
+ where $sim[0] and
$t2.tweetid != $t1.tweetid
order by $t2.tweetid
return {"id": $t2.tweetid, "topics" : $t2.referred-topics}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.3.query.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.3.query.aql
index 27c49da..66df3dc 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.3.query.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.3.query.aql
@@ -18,7 +18,7 @@
*/
/*
* Description : Test that left-outer-join may use two available indexes, one for primary index in prob subtree and another for secondary keyword inverted index in index subtree.
- * Issue : 730, 741
+ * Issue : 730, 741
* Expected Res : Success
* Date : 16th May 2014
*/
@@ -29,10 +29,10 @@ for $t1 in dataset('TweetMessages')
where $t1.tweetid > int64("240")
order by $t1.tweetid
return {
- "tweet": {"id": $t1.tweetid, "topics" : $t1.message-text} ,
+ "tweet": {"id": $t1.tweetid, "topics" : $t1.message-text} ,
"similar-tweets": for $t2 in dataset('TweetMessages')
let $sim := edit-distance-check($t1.message-text, $t2.message-text, 7)
- where $sim[0] and
+ where $sim[0] and
$t2.tweetid != $t1.tweetid
order by $t2.tweetid
return {"id": $t2.tweetid, "topics" : $t2.message-text}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.1.ddl.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.1.ddl.aql
index b942d1e..f0f10d1 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.1.ddl.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.1.ddl.aql
@@ -20,7 +20,7 @@
* Description : Test that BTree index is used in query plan
* : define the BTree index on a composite key (fname,lanme)
* : predicate => where $l.fname > "Julio" and $l.lname > "Mattocks" and
- * $l.fname <= "Micco" and $l.lname < "Vangieson"
+ * $l.fname <= "Micco" and $l.lname < "Vangieson"
* Expected Result : Success
* Issue : Issue 174
* Date : 5th Feb, 2013
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.2.update.aql
index 74d65db..584950b 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.2.update.aql
@@ -20,7 +20,7 @@
* Description : Test that BTree index is used in query plan
* : define the BTree index on a composite key (fname,lanme)
* : predicate => where $l.fname > "Julio" and $l.lname > "Mattocks" and
- * $l.fname <= "Micco" and $l.lname < "Vangieson"
+ * $l.fname <= "Micco" and $l.lname < "Vangieson"
* Expected Result : Success
* Issue : Issue 174
* Date : 5th Feb, 2013
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.3.query.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.3.query.aql
index 24d23f7..95af988 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.3.query.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.3.query.aql
@@ -20,7 +20,7 @@
* Description : Test that BTree index is used in query plan
* : define the BTree index on a composite key (fname,lanme)
* : predicate => where $l.fname > "Julio" and $l.lname > "Mattocks" and
- * $l.fname <= "Micco" and $l.lname < "Vangieson"
+ * $l.fname <= "Micco" and $l.lname < "Vangieson"
* Expected Result : Success
* Issue : Issue 174
* Date : 5th Feb, 2013
@@ -29,6 +29,6 @@
use dataverse test;
for $l in dataset('employee')
-where $l.fname > "Julio" and $l.lname > "Mattocks" and $l.fname <= "Micco" and $l.lname < "Vangieson"
+where $l.fname > "Julio" and $l.lname > "Mattocks" and $l.fname <= "Micco" and $l.lname < "Vangieson"
order by $l.id
return $l
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/leftouterjoin/query_issue285-2/query_issue285-2.3.query.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/leftouterjoin/query_issue285-2/query_issue285-2.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/leftouterjoin/query_issue285-2/query_issue285-2.3.query.aql
index 16d9469..dfd8c8a 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/leftouterjoin/query_issue285-2/query_issue285-2.3.query.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/leftouterjoin/query_issue285-2/query_issue285-2.3.query.aql
@@ -18,13 +18,13 @@
*/
/*
* Description : Left-outer joins two datasets, DBLP and CSX, based on their title.
- * DBLP has a secondary btree index on title, and given the 'indexnl' hint
+ * DBLP has a secondary btree index on title, and given the 'indexnl' hint
* we expect the join to be transformed into an indexed nested-loop join.
*
- * TODO(@Sattam): given the 'indexnl' hint
+ * TODO(@Sattam): given the 'indexnl' hint
* we expect the join to be transformed into an indexed nested-loop join.
- *
- * regression test 2 for issue 285--having an order by and limit for the outer loop relation
+ *
+ * regression test 2 for issue 285--having an order by and limit for the outer loop relation
*
* Success : Yes
*/
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/leftouterjoin/query_issue285/query_issue285.3.query.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/leftouterjoin/query_issue285/query_issue285.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/leftouterjoin/query_issue285/query_issue285.3.query.aql
index 6f1b502..ff6015a 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/leftouterjoin/query_issue285/query_issue285.3.query.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/leftouterjoin/query_issue285/query_issue285.3.query.aql
@@ -18,13 +18,13 @@
*/
/*
* Description : Left-outer joins two datasets, DBLP and CSX, based on their title.
- * DBLP has a secondary btree index on title, and given the 'indexnl' hint
+ * DBLP has a secondary btree index on title, and given the 'indexnl' hint
* we expect the join to be transformed into an indexed nested-loop join.
*
- * TODO(@Sattam): given the 'indexnl' hint
+ * TODO(@Sattam): given the 'indexnl' hint
* we expect the join to be transformed into an indexed nested-loop join.
- *
- * regression test for issue 285--having an order by for the outer loop relation
+ *
+ * regression test for issue 285--having an order by for the outer loop relation
* Success : Yes
*/
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/list/query-issue428/query-issue428.3.query.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/list/query-issue428/query-issue428.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/list/query-issue428/query-issue428.3.query.aql
index 4881493..04ef91d 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/list/query-issue428/query-issue428.3.query.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/list/query-issue428/query-issue428.3.query.aql
@@ -18,7 +18,7 @@
*/
/*
* Description : This test case is to verify the fix for issue400
- : https://code.google.com/p/asterixdb/issues/detail?id=400
+ : https://code.google.com/p/asterixdb/issues/detail?id=400
* Expected Res : Success
* Date : 8th May 2013
*/
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/compact-dataset-and-its-indexes/compact-dataset-and-its-indexes.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/compact-dataset-and-its-indexes/compact-dataset-and-its-indexes.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/compact-dataset-and-its-indexes/compact-dataset-and-its-indexes.2.update.aql
index 87422be..49bef11 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/compact-dataset-and-its-indexes/compact-dataset-and-its-indexes.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/compact-dataset-and-its-indexes/compact-dataset-and-its-indexes.2.update.aql
@@ -25,9 +25,9 @@ using localfs
insert into dataset LineItem
(
- for $c in dataset('LineItemtmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('LineItemtmp')
+ return {
+ "nested" : $c
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/drop-index/drop-index.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/drop-index/drop-index.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/drop-index/drop-index.2.update.aql
index 5d4941f..93b6844 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/drop-index/drop-index.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/drop-index/drop-index.2.update.aql
@@ -32,9 +32,9 @@ using localfs
insert into dataset t1
(
- for $c in dataset('t1tmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('t1tmp')
+ return {
+ "nested" : $c
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/nested-uuid-load/nested-uuid-load.1.ddl.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/nested-uuid-load/nested-uuid-load.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/nested-uuid-load/nested-uuid-load.1.ddl.aql
index 4efe3c1..a1104e6 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/nested-uuid-load/nested-uuid-load.1.ddl.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/nested-uuid-load/nested-uuid-load.1.ddl.aql
@@ -28,7 +28,7 @@ create dataverse twitter;
use dataverse twitter;
create type TwitterUserType as open {
- userid: uuid,
+ userid: uuid,
screen-name: string,
lang: string,
friends_count: int64,
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-btree-secondary-index-nullable/scan-delete-btree-secondary-index-nullable.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-btree-secondary-index-nullable/scan-delete-btree-secondary-index-nullable.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-btree-secondary-index-nullable/scan-delete-btree-secondary-index-nullable.2.update.aql
index 42ad8bf..9c4ada9 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-btree-secondary-index-nullable/scan-delete-btree-secondary-index-nullable.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-btree-secondary-index-nullable/scan-delete-btree-secondary-index-nullable.2.update.aql
@@ -32,9 +32,9 @@ using localfs
insert into dataset Customers
(
- for $c in dataset('Customerstmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('Customerstmp')
+ return {
+ "nested" : $c
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-inverted-index-ngram-secondary-index-nullable/scan-delete-inverted-index-ngram-secondary-index-nullable.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-inverted-index-ngram-secondary-index-nullable/scan-delete-inverted-index-ngram-secondary-index-nullable.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-inverted-index-ngram-secondary-index-nullable/scan-delete-inverted-index-ngram-secondary-index-nullable.2.update.aql
index 9f465aa..30cae33 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-inverted-index-ngram-secondary-index-nullable/scan-delete-inverted-index-ngram-secondary-index-nullable.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-inverted-index-ngram-secondary-index-nullable/scan-delete-inverted-index-ngram-secondary-index-nullable.2.update.aql
@@ -31,9 +31,9 @@ load dataset DBLPtmp using localfs
insert into dataset DBLP
(
- for $c in dataset('DBLPtmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('DBLPtmp')
+ return {
+ "nested" : $c
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-inverted-index-ngram-secondary-index/scan-delete-inverted-index-ngram-secondary-index.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-inverted-index-ngram-secondary-index/scan-delete-inverted-index-ngram-secondary-index.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-inverted-index-ngram-secondary-index/scan-delete-inverted-index-ngram-secondary-index.2.update.aql
index a26b415..97df2b1 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-inverted-index-ngram-secondary-index/scan-delete-inverted-index-ngram-secondary-index.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-inverted-index-ngram-secondary-index/scan-delete-inverted-index-ngram-secondary-index.2.update.aql
@@ -31,9 +31,9 @@ load dataset DBLPtmp using localfs
insert into dataset DBLP
(
- for $c in dataset('DBLPtmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('DBLPtmp')
+ return {
+ "nested" : $c
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-inverted-index-word-secondary-index-nullable/scan-delete-inverted-index-word-secondary-index-nullable.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-inverted-index-word-secondary-index-nullable/scan-delete-inverted-index-word-secondary-index-nullable.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-inverted-index-word-secondary-index-nullable/scan-delete-inverted-index-word-secondary-index-nullable.2.update.aql
index 8407e88..afeaa28 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-inverted-index-word-secondary-index-nullable/scan-delete-inverted-index-word-secondary-index-nullable.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-inverted-index-word-secondary-index-nullable/scan-delete-inverted-index-word-secondary-index-nullable.2.update.aql
@@ -31,9 +31,9 @@ load dataset DBLPtmp using localfs
insert into dataset DBLP
(
- for $c in dataset('DBLPtmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('DBLPtmp')
+ return {
+ "nested" : $c
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-inverted-index-word-secondary-index/scan-delete-inverted-index-word-secondary-index.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-inverted-index-word-secondary-index/scan-delete-inverted-index-word-secondary-index.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-inverted-index-word-secondary-index/scan-delete-inverted-index-word-secondary-index.2.update.aql
index 8a1e3a3..ff9bf7c 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-inverted-index-word-secondary-index/scan-delete-inverted-index-word-secondary-index.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-inverted-index-word-secondary-index/scan-delete-inverted-index-word-secondary-index.2.update.aql
@@ -31,9 +31,9 @@ load dataset DBLPtmp using localfs
insert into dataset DBLP
(
- for $c in dataset('DBLPtmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('DBLPtmp')
+ return {
+ "nested" : $c
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-rtree-secondary-index-nullable/scan-delete-rtree-secondary-index-nullable.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-rtree-secondary-index-nullable/scan-delete-rtree-secondary-index-nullable.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-rtree-secondary-index-nullable/scan-delete-rtree-secondary-index-nullable.2.update.aql
index 3d8bc99..9f02346 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-rtree-secondary-index-nullable/scan-delete-rtree-secondary-index-nullable.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-rtree-secondary-index-nullable/scan-delete-rtree-secondary-index-nullable.2.update.aql
@@ -32,9 +32,9 @@ using localfs
insert into dataset MyData
(
- for $c in dataset('MyDatatmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('MyDatatmp')
+ return {
+ "nested" : $c
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-rtree-secondary-index/scan-delete-rtree-secondary-index.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-rtree-secondary-index/scan-delete-rtree-secondary-index.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-rtree-secondary-index/scan-delete-rtree-secondary-index.2.update.aql
index b86ccf5..4dc7308 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-rtree-secondary-index/scan-delete-rtree-secondary-index.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-delete-rtree-secondary-index/scan-delete-rtree-secondary-index.2.update.aql
@@ -25,9 +25,9 @@ using localfs
insert into dataset MyData
(
- for $c in dataset('MyDatatmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('MyDatatmp')
+ return {
+ "nested" : $c
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-btree-secondary-index-nullable/scan-insert-btree-secondary-index-nullable.4.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-btree-secondary-index-nullable/scan-insert-btree-secondary-index-nullable.4.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-btree-secondary-index-nullable/scan-insert-btree-secondary-index-nullable.4.update.aql
index 8f21741..a25f41e 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-btree-secondary-index-nullable/scan-insert-btree-secondary-index-nullable.4.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-btree-secondary-index-nullable/scan-insert-btree-secondary-index-nullable.4.update.aql
@@ -21,26 +21,26 @@ use dataverse test;
insert into dataset CustomersMinitmp
(
- for $c in dataset('Customerstmp')
+ for $c in dataset('Customerstmp')
- where $c.cid < 200
- return {
- "cid": $c.cid,
- "name": $c.name,
- "age": $c.age,
- "address": $c.address,
- "interests": $c.interests,
- "children": $c.children
- }
+ where $c.cid < 200
+ return {
+ "cid": $c.cid,
+ "name": $c.name,
+ "age": $c.age,
+ "address": $c.address,
+ "interests": $c.interests,
+ "children": $c.children
+ }
);
insert into dataset CustomersMini
(
- for $c in dataset('CustomersMinitmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('CustomersMinitmp')
+ return {
+ "nested" : $c
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-inverted-index-ngram-secondary-index-nullable/scan-insert-inverted-index-ngram-secondary-index-nullable.4.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-inverted-index-ngram-secondary-index-nullable/scan-insert-inverted-index-ngram-secondary-index-nullable.4.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-inverted-index-ngram-secondary-index-nullable/scan-insert-inverted-index-ngram-secondary-index-nullable.4.update.aql
index 52fa6a3..8e6a89a 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-inverted-index-ngram-secondary-index-nullable/scan-insert-inverted-index-ngram-secondary-index-nullable.4.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-inverted-index-ngram-secondary-index-nullable/scan-insert-inverted-index-ngram-secondary-index-nullable.4.update.aql
@@ -32,12 +32,12 @@ where contains($o.title, "Multimedia")
order by $o.id
return { "nested" : {
- "id": $o.id,
- "dblpid": $o.dblpid,
- "title": $o.title,
- "authors": $o.authors,
+ "id": $o.id,
+ "dblpid": $o.dblpid,
+ "title": $o.title,
+ "authors": $o.authors,
- "misc": $o.misc }
+ "misc": $o.misc }
- }
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-inverted-index-ngram-secondary-index/scan-insert-inverted-index-ngram-secondary-index.4.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-inverted-index-ngram-secondary-index/scan-insert-inverted-index-ngram-secondary-index.4.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-inverted-index-ngram-secondary-index/scan-insert-inverted-index-ngram-secondary-index.4.update.aql
index acb4457..1cdb83a 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-inverted-index-ngram-secondary-index/scan-insert-inverted-index-ngram-secondary-index.4.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-inverted-index-ngram-secondary-index/scan-insert-inverted-index-ngram-secondary-index.4.update.aql
@@ -32,12 +32,12 @@ where contains($o.title, "Multimedia")
order by $o.id
return { "nested" : {
- "id": $o.id,
- "dblpid": $o.dblpid,
- "title": $o.title,
- "authors": $o.authors,
+ "id": $o.id,
+ "dblpid": $o.dblpid,
+ "title": $o.title,
+ "authors": $o.authors,
- "misc": $o.misc }
+ "misc": $o.misc }
- }
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-inverted-index-word-secondary-index-nullable/scan-insert-inverted-index-word-secondary-index-nullable.4.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-inverted-index-word-secondary-index-nullable/scan-insert-inverted-index-word-secondary-index-nullable.4.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-inverted-index-word-secondary-index-nullable/scan-insert-inverted-index-word-secondary-index-nullable.4.update.aql
index a355b03..39be753 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-inverted-index-word-secondary-index-nullable/scan-insert-inverted-index-word-secondary-index-nullable.4.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-inverted-index-word-secondary-index-nullable/scan-insert-inverted-index-word-secondary-index-nullable.4.update.aql
@@ -31,12 +31,12 @@ for $o in dataset('DBLPtmp')
order by $o.id
return { "nested" : {
- "id": $o.id,
- "dblpid": $o.dblpid,
- "title": $o.title,
- "authors": $o.authors,
+ "id": $o.id,
+ "dblpid": $o.dblpid,
+ "title": $o.title,
+ "authors": $o.authors,
- "misc": $o.misc }
+ "misc": $o.misc }
- }
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-inverted-index-word-secondary-index/scan-insert-inverted-index-word-secondary-index.4.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-inverted-index-word-secondary-index/scan-insert-inverted-index-word-secondary-index.4.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-inverted-index-word-secondary-index/scan-insert-inverted-index-word-secondary-index.4.update.aql
index 8670f9a..22b6d82 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-inverted-index-word-secondary-index/scan-insert-inverted-index-word-secondary-index.4.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-inverted-index-word-secondary-index/scan-insert-inverted-index-word-secondary-index.4.update.aql
@@ -31,12 +31,12 @@ for $o in dataset('DBLPtmp')
order by $o.id
return { "nested" : {
- "id": $o.id,
- "dblpid": $o.dblpid,
- "title": $o.title,
- "authors": $o.authors,
+ "id": $o.id,
+ "dblpid": $o.dblpid,
+ "title": $o.title,
+ "authors": $o.authors,
- "misc": $o.misc }
+ "misc": $o.misc }
- }
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-rtree-secondary-index-nullable/scan-insert-rtree-secondary-index-nullable.4.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-rtree-secondary-index-nullable/scan-insert-rtree-secondary-index-nullable.4.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-rtree-secondary-index-nullable/scan-insert-rtree-secondary-index-nullable.4.update.aql
index 01dbad9..3711fb1 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-rtree-secondary-index-nullable/scan-insert-rtree-secondary-index-nullable.4.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-rtree-secondary-index-nullable/scan-insert-rtree-secondary-index-nullable.4.update.aql
@@ -21,11 +21,11 @@ use dataverse test;
insert into dataset MyMiniData
(
- for $m in dataset('MyDatatmp')
- return { "nested" : {
- "id": $m.id,
- "point": $m.point }
+ for $m in dataset('MyDatatmp')
+ return { "nested" : {
+ "id": $m.id,
+ "point": $m.point }
- }
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-rtree-secondary-index/scan-insert-rtree-secondary-index.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-rtree-secondary-index/scan-insert-rtree-secondary-index.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-rtree-secondary-index/scan-insert-rtree-secondary-index.2.update.aql
index f6205ff..d7d9351 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-rtree-secondary-index/scan-insert-rtree-secondary-index.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-rtree-secondary-index/scan-insert-rtree-secondary-index.2.update.aql
@@ -29,17 +29,17 @@ using localfs
insert into dataset MyData
(
- for $c in dataset('MyDatatmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('MyDatatmp')
+ return {
+ "nested" : $c
+ }
);
insert into dataset MyMiniData
(
- for $c in dataset('MyMiniDatatmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('MyMiniDatatmp')
+ return {
+ "nested" : $c
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-rtree-secondary-index/scan-insert-rtree-secondary-index.4.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-rtree-secondary-index/scan-insert-rtree-secondary-index.4.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-rtree-secondary-index/scan-insert-rtree-secondary-index.4.update.aql
index fb589bb..e8a4e89 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-rtree-secondary-index/scan-insert-rtree-secondary-index.4.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index-dml/scan-insert-rtree-secondary-index/scan-insert-rtree-secondary-index.4.update.aql
@@ -20,12 +20,12 @@ use dataverse test;
insert into dataset MyMiniData
(
- for $m in dataset('MyData')
+ for $m in dataset('MyData')
- return { "nested" : {
- "id": $m.nested.id,
- "point": $m.nested.point }
+ return { "nested" : {
+ "id": $m.nested.id,
+ "point": $m.nested.point }
- }
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/external-indexing/leftouterjoin-rtree/leftouterjoin-rtree.1.ddl.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/external-indexing/leftouterjoin-rtree/leftouterjoin-rtree.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/external-indexing/leftouterjoin-rtree/leftouterjoin-rtree.1.ddl.aql
index 6152f5a..1ff699d 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/external-indexing/leftouterjoin-rtree/leftouterjoin-rtree.1.ddl.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/external-indexing/leftouterjoin-rtree/leftouterjoin-rtree.1.ddl.aql
@@ -18,7 +18,7 @@
*/
/*
* Description : Test that left-outer-join may use two available indexes, one for primary index in prob subtree and another for secondary rtree index in index subtree.
- * Issue : 730, 741
+ * Issue : 730, 741
* Expected Res : Success
* Date : 8th May 2014
*/
@@ -28,23 +28,23 @@ create dataverse test;
use dataverse test;
create type TwitterUserType as closed {
- screen-name: string,
- lang: string,
- friends-count: int64,
- statuses-count: int64,
- name: string,
- followers-count: int64
-}
+ screen-name: string,
+ lang: string,
+ friends-count: int64,
+ statuses-count: int64,
+ name: string,
+ followers-count: int64
+}
create type TweetMessageNestedType as closed {
- tweetid: int64,
+ tweetid: int64,
user: TwitterUserType,
sender-location: point,
- send-time: datetime,
+ send-time: datetime,
referred-topics: {{ string }},
- message-text: string,
- countA: int64,
- countB: int64
+ message-text: string,
+ countA: int64,
+ countB: int64
}
create type TweetMessageType as closed {
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/external-indexing/leftouterjoin/leftouterjoin.1.ddl.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/external-indexing/leftouterjoin/leftouterjoin.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/external-indexing/leftouterjoin/leftouterjoin.1.ddl.aql
index f75db06..7c2b960 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/external-indexing/leftouterjoin/leftouterjoin.1.ddl.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/external-indexing/leftouterjoin/leftouterjoin.1.ddl.aql
@@ -18,7 +18,7 @@
*/
/*
* Description : Test that left-outer-join may use two available indexes, one for primary index in prob subtree and another for secondary btree index in index subtree.
- * Issue : 730, 741
+ * Issue : 730, 741
* Expected Res : Success
* Date : 8th May 2014
*/
@@ -28,23 +28,23 @@ create dataverse test;
use dataverse test;
create type TwitterUserType as closed {
- screen-name: string,
- lang: string,
- friends-count: int64,
- statuses-count: int64,
- name: string,
- followers-count: int64
-}
+ screen-name: string,
+ lang: string,
+ friends-count: int64,
+ statuses-count: int64,
+ name: string,
+ followers-count: int64
+}
create type TweetMessageNestedType as closed {
- tweetid: int64,
+ tweetid: int64,
user: TwitterUserType,
sender-location: point,
- send-time: datetime,
+ send-time: datetime,
referred-topics: {{ string }},
- message-text: string,
- countA: int64,
- countB: int64
+ message-text: string,
+ countA: int64,
+ countB: int64
}
create type TweetMessageType as closed {
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/btree-primary-equi-join/btree-primary-equi-join.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/btree-primary-equi-join/btree-primary-equi-join.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/btree-primary-equi-join/btree-primary-equi-join.2.update.aql
index 2d5f6e0..33857b7 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/btree-primary-equi-join/btree-primary-equi-join.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/btree-primary-equi-join/btree-primary-equi-join.2.update.aql
@@ -35,16 +35,16 @@ using localfs
insert into dataset Orders
(
- for $c in dataset('Orderstmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('Orderstmp')
+ return {
+ "nested" : $c
+ }
);
insert into dataset Customers
(
- for $c in dataset('Customerstmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('Customerstmp')
+ return {
+ "nested" : $c
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/btree-secondary-equi-join/btree-secondary-equi-join.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/btree-secondary-equi-join/btree-secondary-equi-join.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/btree-secondary-equi-join/btree-secondary-equi-join.2.update.aql
index 32c216a..e047b1f 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/btree-secondary-equi-join/btree-secondary-equi-join.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/btree-secondary-equi-join/btree-secondary-equi-join.2.update.aql
@@ -36,16 +36,16 @@ using localfs
insert into dataset DBLP
(
- for $c in dataset('DBLPtmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('DBLPtmp')
+ return {
+ "nested" : $c
+ }
);
insert into dataset CSX
(
- for $c in dataset('CSXtmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('CSXtmp')
+ return {
+ "nested" : $c
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/ngram-edit-distance-inline/ngram-edit-distance-inline.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/ngram-edit-distance-inline/ngram-edit-distance-inline.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/ngram-edit-distance-inline/ngram-edit-distance-inline.2.update.aql
index fc980cc..8229a18 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/ngram-edit-distance-inline/ngram-edit-distance-inline.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/ngram-edit-distance-inline/ngram-edit-distance-inline.2.update.aql
@@ -35,16 +35,16 @@ using localfs
insert into dataset Customers
(
- for $c in dataset('Customerstmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('Customerstmp')
+ return {
+ "nested" : $c
+ }
);
insert into dataset Customers2
(
- for $c in dataset('Customers2tmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('Customers2tmp')
+ return {
+ "nested" : $c
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/ngram-edit-distance/ngram-edit-distance.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/ngram-edit-distance/ngram-edit-distance.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/ngram-edit-distance/ngram-edit-distance.2.update.aql
index ae746fd..5106d74 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/ngram-edit-distance/ngram-edit-distance.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/ngram-edit-distance/ngram-edit-distance.2.update.aql
@@ -34,16 +34,16 @@ using localfs
insert into dataset Customers
(
- for $c in dataset('Customerstmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('Customerstmp')
+ return {
+ "nested" : $c
+ }
);
insert into dataset Customers2
(
- for $c in dataset('Customers2tmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('Customers2tmp')
+ return {
+ "nested" : $c
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/ngram-jaccard-inline/ngram-jaccard-inline.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/ngram-jaccard-inline/ngram-jaccard-inline.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/ngram-jaccard-inline/ngram-jaccard-inline.2.update.aql
index 24fb996..4b85ba8 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/ngram-jaccard-inline/ngram-jaccard-inline.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/ngram-jaccard-inline/ngram-jaccard-inline.2.update.aql
@@ -35,15 +35,15 @@ using localfs
insert into dataset DBLP(
- for $x in dataset DBLPtmp
- return {
- "nested": $x
- }
+ for $x in dataset DBLPtmp
+ return {
+ "nested": $x
+ }
);
insert into dataset CSX(
- for $x in dataset CSXtmp
- return {
- "nested": $x
- }
+ for $x in dataset CSXtmp
+ return {
+ "nested": $x
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/ngram-jaccard/ngram-jaccard.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/ngram-jaccard/ngram-jaccard.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/ngram-jaccard/ngram-jaccard.2.update.aql
index 40dc555..888543c 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/ngram-jaccard/ngram-jaccard.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/ngram-jaccard/ngram-jaccard.2.update.aql
@@ -34,15 +34,15 @@ using localfs
insert into dataset DBLP(
- for $x in dataset DBLPtmp
- return {
- "nested": $x
- }
+ for $x in dataset DBLPtmp
+ return {
+ "nested": $x
+ }
);
insert into dataset CSX(
- for $x in dataset CSXtmp
- return {
- "nested": $x
- }
+ for $x in dataset CSXtmp
+ return {
+ "nested": $x
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/rtree-spatial-intersect-point/rtree-spatial-intersect-point.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/rtree-spatial-intersect-point/rtree-spatial-intersect-point.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/rtree-spatial-intersect-point/rtree-spatial-intersect-point.2.update.aql
index aba44cd..3c87552 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/rtree-spatial-intersect-point/rtree-spatial-intersect-point.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/rtree-spatial-intersect-point/rtree-spatial-intersect-point.2.update.aql
@@ -35,16 +35,16 @@ using localfs
insert into dataset MyData1
(
- for $c in dataset('MyData1tmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('MyData1tmp')
+ return {
+ "nested" : $c
+ }
);
insert into dataset MyData2
(
- for $c in dataset('MyData2tmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('MyData2tmp')
+ return {
+ "nested" : $c
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/word-jaccard-inline/word-jaccard-inline.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/word-jaccard-inline/word-jaccard-inline.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/word-jaccard-inline/word-jaccard-inline.2.update.aql
index 69887cb..f63066b 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/word-jaccard-inline/word-jaccard-inline.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/word-jaccard-inline/word-jaccard-inline.2.update.aql
@@ -35,15 +35,15 @@ using localfs
insert into dataset DBLP(
- for $x in dataset DBLPtmp
- return {
- "nested": $x
- }
+ for $x in dataset DBLPtmp
+ return {
+ "nested": $x
+ }
);
insert into dataset CSX(
- for $x in dataset CSXtmp
- return {
- "nested": $x
- }
+ for $x in dataset CSXtmp
+ return {
+ "nested": $x
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/word-jaccard/word-jaccard.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/word-jaccard/word-jaccard.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/word-jaccard/word-jaccard.2.update.aql
index 16f76d3..ae2fc5f 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/word-jaccard/word-jaccard.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-join/word-jaccard/word-jaccard.2.update.aql
@@ -34,15 +34,15 @@ using localfs
insert into dataset DBLP(
- for $x in dataset DBLPtmp
- return {
- "nested": $x
- }
+ for $x in dataset DBLPtmp
+ return {
+ "nested": $x
+ }
);
insert into dataset CSX(
- for $x in dataset CSXtmp
- return {
- "nested": $x
- }
+ for $x in dataset CSXtmp
+ return {
+ "nested": $x
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.1.ddl.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.1.ddl.aql
index 44e0bc6..0cdc7dd 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.1.ddl.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.1.ddl.aql
@@ -28,27 +28,27 @@ create dataverse test;
use dataverse test;
create type TwitterUserType as closed {
- screen-name: string,
- lang: string,
- friends-count: int64,
- statuses-count: int64,
- name: string,
- followers-count: int64
+ screen-name: string,
+ lang: string,
+ friends-count: int64,
+ statuses-count: int64,
+ name: string,
+ followers-count: int64
}
create type TweetMessageNestedType as closed {
- tweetid: int64,
+ tweetid: int64,
user: TwitterUserType,
sender-location: point,
- send-time: datetime,
+ send-time: datetime,
referred-topics: {{ string }},
- message-text: string,
- countA: int64,
- countB: int64
+ message-text: string,
+ countA: int64,
+ countB: int64
}
create type TweetMessageType as closed {
- nested: TweetMessageNestedType
+ nested: TweetMessageNestedType
}
create dataset TweetMessages(TweetMessageType)
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.2.update.aql
index 81075b7..a964528 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.2.update.aql
@@ -31,8 +31,8 @@ using localfs
insert into dataset TweetMessages
(
- for $c in dataset('TweetMessagesTmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('TweetMessagesTmp')
+ return {
+ "nested" : $c
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx2/probe-pidx-with-join-btree-sidx2.1.ddl.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx2/probe-pidx-with-join-btree-sidx2.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx2/probe-pidx-with-join-btree-sidx2.1.ddl.aql
index 44e0bc6..0cdc7dd 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx2/probe-pidx-with-join-btree-sidx2.1.ddl.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx2/probe-pidx-with-join-btree-sidx2.1.ddl.aql
@@ -28,27 +28,27 @@ create dataverse test;
use dataverse test;
create type TwitterUserType as closed {
- screen-name: string,
- lang: string,
- friends-count: int64,
- statuses-count: int64,
- name: string,
- followers-count: int64
+ screen-name: string,
+ lang: string,
+ friends-count: int64,
+ statuses-count: int64,
+ name: string,
+ followers-count: int64
}
create type TweetMessageNestedType as closed {
- tweetid: int64,
+ tweetid: int64,
user: TwitterUserType,
sender-location: point,
- send-time: datetime,
+ send-time: datetime,
referred-topics: {{ string }},
- message-text: string,
- countA: int64,
- countB: int64
+ message-text: string,
+ countA: int64,
+ countB: int64
}
create type TweetMessageType as closed {
- nested: TweetMessageNestedType
+ nested: TweetMessageNestedType
}
create dataset TweetMessages(TweetMessageType)
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx2/probe-pidx-with-join-btree-sidx2.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx2/probe-pidx-with-join-btree-sidx2.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx2/probe-pidx-with-join-btree-sidx2.2.update.aql
index 81075b7..a964528 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx2/probe-pidx-with-join-btree-sidx2.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx2/probe-pidx-with-join-btree-sidx2.2.update.aql
@@ -31,8 +31,8 @@ using localfs
insert into dataset TweetMessages
(
- for $c in dataset('TweetMessagesTmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('TweetMessagesTmp')
+ return {
+ "nested" : $c
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx1/probe-pidx-with-join-invidx-sidx1.1.ddl.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx1/probe-pidx-with-join-invidx-sidx1.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx1/probe-pidx-with-join-invidx-sidx1.1.ddl.aql
index 9d5b9d3..714ad19 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx1/probe-pidx-with-join-invidx-sidx1.1.ddl.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx1/probe-pidx-with-join-invidx-sidx1.1.ddl.aql
@@ -28,27 +28,27 @@ create dataverse test;
use dataverse test;
create type TwitterUserType as closed {
- screen-name: string,
- lang: string,
- friends-count: int64,
- statuses-count: int64,
- name: string,
- followers-count: int64
+ screen-name: string,
+ lang: string,
+ friends-count: int64,
+ statuses-count: int64,
+ name: string,
+ followers-count: int64
}
create type TweetMessageNestedType as closed {
- tweetid: int64,
+ tweetid: int64,
user: TwitterUserType,
sender-location: point,
- send-time: datetime,
+ send-time: datetime,
referred-topics: {{ string }},
- message-text: string,
- countA: int64,
- countB: int64
+ message-text: string,
+ countA: int64,
+ countB: int64
}
create type TweetMessageType as closed {
- nested: TweetMessageNestedType
+ nested: TweetMessageNestedType
}
create dataset TweetMessages(TweetMessageType)
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx1/probe-pidx-with-join-invidx-sidx1.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx1/probe-pidx-with-join-invidx-sidx1.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx1/probe-pidx-with-join-invidx-sidx1.2.update.aql
index 81075b7..a964528 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx1/probe-pidx-with-join-invidx-sidx1.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx1/probe-pidx-with-join-invidx-sidx1.2.update.aql
@@ -31,8 +31,8 @@ using localfs
insert into dataset TweetMessages
(
- for $c in dataset('TweetMessagesTmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('TweetMessagesTmp')
+ return {
+ "nested" : $c
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx1/probe-pidx-with-join-invidx-sidx1.3.query.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx1/probe-pidx-with-join-invidx-sidx1.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx1/probe-pidx-with-join-invidx-sidx1.3.query.aql
index bf65266..1b9e041 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx1/probe-pidx-with-join-invidx-sidx1.3.query.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx1/probe-pidx-with-join-invidx-sidx1.3.query.aql
@@ -32,7 +32,7 @@ return {
"tweet": {"id": $t1.nested.tweetid, "topics" : $t1.nested.referred-topics} ,
"similar-tweets": for $t2 in dataset('TweetMessages')
let $sim := similarity-jaccard-check($t1.nested.referred-topics, $t2.nested.referred-topics, 0.5f)
- where $sim[0] and
+ where $sim[0] and
$t2.nested.tweetid != $t1.nested.tweetid
order by $t2.nested.tweetid
return {"id": $t2.nested.tweetid, "topics" : $t2.nested.referred-topics}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.1.ddl.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.1.ddl.aql
index 9d5b9d3..714ad19 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.1.ddl.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.1.ddl.aql
@@ -28,27 +28,27 @@ create dataverse test;
use dataverse test;
create type TwitterUserType as closed {
- screen-name: string,
- lang: string,
- friends-count: int64,
- statuses-count: int64,
- name: string,
- followers-count: int64
+ screen-name: string,
+ lang: string,
+ friends-count: int64,
+ statuses-count: int64,
+ name: string,
+ followers-count: int64
}
create type TweetMessageNestedType as closed {
- tweetid: int64,
+ tweetid: int64,
user: TwitterUserType,
sender-location: point,
- send-time: datetime,
+ send-time: datetime,
referred-topics: {{ string }},
- message-text: string,
- countA: int64,
- countB: int64
+ message-text: string,
+ countA: int64,
+ countB: int64
}
create type TweetMessageType as closed {
- nested: TweetMessageNestedType
+ nested: TweetMessageNestedType
}
create dataset TweetMessages(TweetMessageType)
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.2.update.aql
index 81075b7..a964528 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.2.update.aql
@@ -31,8 +31,8 @@ using localfs
insert into dataset TweetMessages
(
- for $c in dataset('TweetMessagesTmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('TweetMessagesTmp')
+ return {
+ "nested" : $c
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.3.query.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.3.query.aql
index 0217932..521fd98 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.3.query.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.3.query.aql
@@ -32,7 +32,7 @@ return {
"tweet": {"id": $t1.nested.tweetid, "topics" : $t1.nested.message-text} ,
"similar-tweets": for $t2 in dataset('TweetMessages')
let $sim := edit-distance-check($t1.nested.message-text, $t2.nested.message-text, 7)
- where $sim[0] and
+ where $sim[0] and
$t2.nested.tweetid != $t1.nested.tweetid
order by $t2.nested.tweetid
return {"id": $t2.nested.tweetid, "topics" : $t2.nested.message-text}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx1/probe-pidx-with-join-rtree-sidx1.1.ddl.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx1/probe-pidx-with-join-rtree-sidx1.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx1/probe-pidx-with-join-rtree-sidx1.1.ddl.aql
index c7faa0d..af761a5 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx1/probe-pidx-with-join-rtree-sidx1.1.ddl.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx1/probe-pidx-with-join-rtree-sidx1.1.ddl.aql
@@ -28,27 +28,27 @@ create dataverse test;
use dataverse test;
create type TwitterUserType as closed {
- screen-name: string,
- lang: string,
- friends-count: int64,
- statuses-count: int64,
- name: string,
- followers-count: int64
+ screen-name: string,
+ lang: string,
+ friends-count: int64,
+ statuses-count: int64,
+ name: string,
+ followers-count: int64
}
create type TweetMessageNestedType as closed {
- tweetid: int64,
+ tweetid: int64,
user: TwitterUserType,
sender-location: point,
- send-time: datetime,
+ send-time: datetime,
referred-topics: {{ string }},
- message-text: string,
- countA: int64,
- countB: int64
+ message-text: string,
+ countA: int64,
+ countB: int64
}
create type TweetMessageType as closed {
- nested: TweetMessageNestedType
+ nested: TweetMessageNestedType
}
create dataset TweetMessages(TweetMessageType)
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx1/probe-pidx-with-join-rtree-sidx1.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx1/probe-pidx-with-join-rtree-sidx1.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx1/probe-pidx-with-join-rtree-sidx1.2.update.aql
index 0223406..5edd0be 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx1/probe-pidx-with-join-rtree-sidx1.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx1/probe-pidx-with-join-rtree-sidx1.2.update.aql
@@ -31,8 +31,8 @@ using localfs
insert into dataset TweetMessages
(
- for $c in dataset('TweetMessagesTmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('TweetMessagesTmp')
+ return {
+ "nested" : $c
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx2/probe-pidx-with-join-rtree-sidx2.1.ddl.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx2/probe-pidx-with-join-rtree-sidx2.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx2/probe-pidx-with-join-rtree-sidx2.1.ddl.aql
index c7faa0d..af761a5 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx2/probe-pidx-with-join-rtree-sidx2.1.ddl.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx2/probe-pidx-with-join-rtree-sidx2.1.ddl.aql
@@ -28,27 +28,27 @@ create dataverse test;
use dataverse test;
create type TwitterUserType as closed {
- screen-name: string,
- lang: string,
- friends-count: int64,
- statuses-count: int64,
- name: string,
- followers-count: int64
+ screen-name: string,
+ lang: string,
+ friends-count: int64,
+ statuses-count: int64,
+ name: string,
+ followers-count: int64
}
create type TweetMessageNestedType as closed {
- tweetid: int64,
+ tweetid: int64,
user: TwitterUserType,
sender-location: point,
- send-time: datetime,
+ send-time: datetime,
referred-topics: {{ string }},
- message-text: string,
- countA: int64,
- countB: int64
+ message-text: string,
+ countA: int64,
+ countB: int64
}
create type TweetMessageType as closed {
- nested: TweetMessageNestedType
+ nested: TweetMessageNestedType
}
create dataset TweetMessages(TweetMessageType)
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx2/probe-pidx-with-join-rtree-sidx2.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx2/probe-pidx-with-join-rtree-sidx2.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx2/probe-pidx-with-join-rtree-sidx2.2.update.aql
index 0223406..5edd0be 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx2/probe-pidx-with-join-rtree-sidx2.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx2/probe-pidx-with-join-rtree-sidx2.2.update.aql
@@ -31,8 +31,8 @@ using localfs
insert into dataset TweetMessages
(
- for $c in dataset('TweetMessagesTmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('TweetMessagesTmp')
+ return {
+ "nested" : $c
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.1.ddl.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.1.ddl.aql
index 1c0bda3..9acdab8 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.1.ddl.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.1.ddl.aql
@@ -20,7 +20,7 @@
* Description : Test that BTree index is used in query plan
* : define the BTree index on a composite key (fname,lanme)
* : predicate => where $l.fname > "Julio" and $l.lname > "Mattocks" and
- * $l.fname <= "Micco" and $l.lname < "Vangieson"
+ * $l.fname <= "Micco" and $l.lname < "Vangieson"
* Expected Result : Success
* Issue : Issue 174
* Date : 5th Feb, 2013
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.2.update.aql
index 683a097..92e4470 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.2.update.aql
@@ -20,7 +20,7 @@
* Description : Test that BTree index is used in query plan
* : define the BTree index on a composite key (fname,lanme)
* : predicate => where $l.fname > "Julio" and $l.lname > "Mattocks" and
- * $l.fname <= "Micco" and $l.lname < "Vangieson"
+ * $l.fname <= "Micco" and $l.lname < "Vangieson"
* Expected Result : Success
* Issue : Issue 174
* Date : 5th Feb, 2013
@@ -35,13 +35,13 @@ using localfs
insert into dataset employee
(
- for $c in dataset('employeeTmp')
- return {
- "nested" : {
- "id": $c.id,
- "fname": $c.fname,
- "lname": $c.lname,
- "age": $c.age,
- "dept": $c.dept }
- }
+ for $c in dataset('employeeTmp')
+ return {
+ "nested" : {
+ "id": $c.id,
+ "fname": $c.fname,
+ "lname": $c.lname,
+ "age": $c.age,
+ "dept": $c.dept }
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.4.query.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.4.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.4.query.aql
index f77ddcd..c46678f 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.4.query.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.4.query.aql
@@ -20,7 +20,7 @@
* Description : Test that BTree index is used in query plan
* : define the BTree index on a composite key (fname,lanme)
* : predicate => where $l.fname > "Julio" and $l.lname > "Mattocks" and
- * $l.fname <= "Micco" and $l.lname < "Vangieson"
+ * $l.fname <= "Micco" and $l.lname < "Vangieson"
* Expected Result : Success
* Issue : Issue 174
* Date : 5th Feb, 2013
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/btree-index-composite-key/btree-index-composite-key.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/btree-index-composite-key/btree-index-composite-key.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/btree-index-composite-key/btree-index-composite-key.2.update.aql
index 029665f..9e564fd 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/btree-index-composite-key/btree-index-composite-key.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/btree-index-composite-key/btree-index-composite-key.2.update.aql
@@ -34,13 +34,13 @@ using localfs
insert into dataset employee
(
- for $c in dataset('employeeTmp')
- return {
- "nested" : {
- "id": $c.id,
- "fname": $c.fname,
- "lname": $c.lname,
- "age": $c.age,
- "dept": $c.dept }
- }
+ for $c in dataset('employeeTmp')
+ return {
+ "nested" : {
+ "id": $c.id,
+ "fname": $c.fname,
+ "lname": $c.lname,
+ "age": $c.age,
+ "dept": $c.dept }
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/btree-index-rewrite-multiple/btree-index-rewrite-multiple.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/btree-index-rewrite-multiple/btree-index-rewrite-multiple.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/btree-index-rewrite-multiple/btree-index-rewrite-multiple.2.update.aql
index 870d66b..fd13049 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/btree-index-rewrite-multiple/btree-index-rewrite-multiple.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/btree-index-rewrite-multiple/btree-index-rewrite-multiple.2.update.aql
@@ -32,9 +32,9 @@ using localfs
insert into dataset Orders
(
- for $c in dataset('Orderstmp')
- return {
- "nested" : {
+ for $c in dataset('Orderstmp')
+ return {
+ "nested" : {
"o_orderkey": $c.o_orderkey,
"o_custkey": $c.o_custkey,
"o_orderstatus": $c.o_orderstatus,
@@ -45,5 +45,5 @@ insert into dataset Orders
"o_shippriority": $c.o_shippriority,
"o_comment": $c.o_comment
}
- }
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/cust-index-age-nullable/cust-index-age-nullable.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/cust-index-age-nullable/cust-index-age-nullable.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/cust-index-age-nullable/cust-index-age-nullable.2.update.aql
index 18fa90a..7a715e2 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/cust-index-age-nullable/cust-index-age-nullable.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/cust-index-age-nullable/cust-index-age-nullable.2.update.aql
@@ -24,8 +24,8 @@ using localfs
insert into dataset Customers
(
- for $c in dataset('Customerstmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('Customerstmp')
+ return {
+ "nested" : $c
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/inverted-index-ngram-contains/inverted-index-ngram-contains.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/inverted-index-ngram-contains/inverted-index-ngram-contains.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/inverted-index-ngram-contains/inverted-index-ngram-contains.2.update.aql
index 0702ddf..18b4bbb 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/inverted-index-ngram-contains/inverted-index-ngram-contains.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/inverted-index-ngram-contains/inverted-index-ngram-contains.2.update.aql
@@ -24,8 +24,8 @@ using localfs
insert into dataset DBLP
(
- for $c in dataset('DBLPtmp')
- return {
- "nested" : $c
- }
+ for $c in dataset('DBLPtmp')
+ return {
+ "nested" : $c
+ }
);
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/inverted-index-ngram-edit-distance-contains/inverted-index-ngram-edit-distance-contains.2.update.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/inverted-index-ngram-edit-distance-contains/inverted-index-ngram-edit-distance-contains.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/inverted-index-ngram-edit-distance-contains/inverted-index-ngram-edit-distance-contains.2.update.aql
index 0619e49..463aa61 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/inverted-index-ngram-edit-distance-contains/inverted-index-ngram-edit-distance-contains.2.update.aql
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-index/index-selection/inverted-index-ngram-edit-distance-contains/inverted-index-ngram-edit-distance-contains.2.update.aql
@@ -23,8 +23,8 @@ using localfs
(("path"="asterix_nc1://data/dblp-small/dblp-small-id.txt"),("format"="delimited-text"),("delimiter"=":")) pre-sorted;
insert into dataset test.DBLP (
- for $x in dataset test.DBLPtmp
- return {
- "nested": $x
- }
+ for $x in dataset test.DBLPtmp
+ return {
+ "nested": $x
+ }
);