>From Preetham Poluparthi <[email protected]>:
Preetham Poluparthi has uploaded this change for review. (
https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/20396?usp=email )
Change subject: test change
......................................................................
test change
Change-Id: I344b74cb67656d8848c5855fa9c4842cd6d1cd90
---
M
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/index-advisor/array-simple-advise/array-simple-advise.2.update.sqlpp
A
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/index-advisor/array-simple-advise/array-simple-advise.9.query.sqlpp
M
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/index-advisor/nested-array-index/nested-array-index.2.update.sqlpp
M
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/index-advisor/nested-array-index/nested-array-index.6.query.sqlpp
A
asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/index-advisor/array-simple-advise/array-simple-advise.9.adm
M
asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/index-advisor/nested-array-index/nested-array-index.8.adm
M
asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/index-advisor/nested-array-index/nested-array-index.9.adm
7 files changed, 128 insertions(+), 10 deletions(-)
git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb
refs/changes/96/20396/1
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/index-advisor/array-simple-advise/array-simple-advise.2.update.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/index-advisor/array-simple-advise/array-simple-advise.2.update.sqlpp
index cbb5fbb..162e934 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/index-advisor/array-simple-advise/array-simple-advise.2.update.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/index-advisor/array-simple-advise/array-simple-advise.2.update.sqlpp
@@ -22,8 +22,8 @@
INSERT INTO A(
SELECT VALUE {"a_0": i, "a_1": i%20 , "a_2" : i , "categories":
["Drink"],
- "items" : [ { "qty" : 80 , "price" : 6.0 } ]
-
+ "items" : [ { "qty" : 80 , "price" : 6.0 } ],
+ "orders": [ { "delivery_time": 1 }, { "delivery_time": 2 } , {
"delivery_time": 3 } , { "delivery_time": 4 } , { "delivery_time": 5 } ]
}
FROM range(1, 1000) i
);
@@ -31,8 +31,8 @@
INSERT INTO A(
SELECT VALUE {"a_0": i, "a_1": i%20 , "a_2" : i , "categories":
["Food"],
- "items" : [ { "qty" : 120 , "price" : 2.0 } ]
-
+ "items" : [ { "qty" : 120 , "price" : 2.0 } ],
+ "orders": [ { "delivery_time": 6 }, { "delivery_time": 7 } , {
"delivery_time": 8 } , { "delivery_time": 9 } , { "delivery_time": 10 }, {
"delivery_time": 11 } ]
}
FROM range(1001, 1003) i
);
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/index-advisor/array-simple-advise/array-simple-advise.9.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/index-advisor/array-simple-advise/array-simple-advise.9.query.sqlpp
new file mode 100644
index 0000000..9836c80
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/index-advisor/array-simple-advise/array-simple-advise.9.query.sqlpp
@@ -0,0 +1,29 @@
+
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use test;
+
+
+
+
+ADVISE
+SELECT count(*)
+FROM A a, a.orders o
+WHERE o.delivery_time >= 7 AND o.delivery_time <= 9;
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/index-advisor/nested-array-index/nested-array-index.2.update.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/index-advisor/nested-array-index/nested-array-index.2.update.sqlpp
index 7dab0fd..c7cf550 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/index-advisor/nested-array-index/nested-array-index.2.update.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/index-advisor/nested-array-index/nested-array-index.2.update.sqlpp
@@ -21,7 +21,95 @@
use test;
INSERT INTO A(
- SELECT VALUE {"a_0": i, "a_1": i%20 , "a_2" : i ,"a":{ "b" :{ "c" :
["Drink"]}} }
+ SELECT VALUE {"a_0": i, "a_1": i%20 , "a_2" : i ,"a":{ "b" :{ "c" :
["Drink"]}}
+
+ ,
+ "n1": [
+ {
+ "n2": [
+ {
+ "n3": [
+ {
+ "n4": [
+ "Drink"
+ ]
+ }
+ ]
+ }
+ ]
+ }
+ ],
+ "f1": {
+ "f2": {
+ "f3": [
+ {
+ "f4": {
+ "f5": [{
+ "categories": [
+ "Drink"
+ ]
+ }]
+ }
+ }
+ ]
+ }
+ },
+ "g1": {
+ "g2": [
+ {
+ "g3": [
+ {
+ "items": [
+ {
+ "qty": 80,
+ "price": 6.0
+ }
+ ]
+ }
+ ]
+ }
+ ]
+ },
+ "h1": {
+ "h2": {
+ "h3": [
+ {
+ "h4": {
+ "h5": [
+ {
+ "categories": [
+ "Drink"
+ ]
+ }
+ ]
+ }
+ }
+ ]
+ }
+ },
+
+ "k1": {
+ "k2": [
+ {
+ "k3": {
+ "k4": [
+ {
+ "k5": {
+ "k6": [
+ {
+ "qty": 80,
+ "price": 6.0
+ }
+ ]
+ }
+ }
+ ]
+ }
+ }
+ ]
+ }
+
+ }
FROM range(1, 1000) i
);
@@ -58,11 +146,11 @@
"f3": [
{
"f4": {
- "f5": {
+ "f5": [{
"categories": [
"Food"
]
- }
+ }]
}
}
]
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/index-advisor/nested-array-index/nested-array-index.6.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/index-advisor/nested-array-index/nested-array-index.6.query.sqlpp
index fe03a10..89d4344 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/index-advisor/nested-array-index/nested-array-index.6.query.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/cbo-join/index-advisor/nested-array-index/nested-array-index.6.query.sqlpp
@@ -44,6 +44,6 @@
ADVISE
-SELECT p
+SELECT *
FROM A p, p.f1.f2.f3 n1, n1.f4.f5 n2
WHERE SOME c IN n2.categories SATISFIES c = "Food";
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/index-advisor/array-simple-advise/array-simple-advise.9.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/index-advisor/array-simple-advise/array-simple-advise.9.adm
new file mode 100644
index 0000000..a2c5132
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/index-advisor/array-simple-advise/array-simple-advise.9.adm
@@ -0,0 +1 @@
+[{"#operator":"Advise","advice":{"#operator":"IndexAdvice","adviseinfo":{"current_indexes":[],"recommended_indexes":{"indexes":[{"index_statement":"CREATE
INDEX array_idx_orders ON `Default`.`test`.`A`(UNNEST `orders` SELECT
`delivery_time`: bigint);"}]}}}}]
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/index-advisor/nested-array-index/nested-array-index.8.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/index-advisor/nested-array-index/nested-array-index.8.adm
index b5d479a..095e268 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/index-advisor/nested-array-index/nested-array-index.8.adm
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/index-advisor/nested-array-index/nested-array-index.8.adm
@@ -1 +1 @@
-[{"#operator":"Advise","advice":{"#operator":"IndexAdvice","adviseinfo":{"current_indexes":[],"recommended_indexes":{"indexes":[]}}}}]
\ No newline at end of file
+[{"#operator":"Advise","advice":{"#operator":"IndexAdvice","adviseinfo":{"current_indexes":[],"recommended_indexes":{"indexes":[{"index_statement":"CREATE
INDEX array_idx_h1_h2_h3_h4_h5_categories ON `Default`.`test`.`A`(UNNEST
`h1`.`h2`.`h3` UNNEST `h4`.`h5` UNNEST `categories` : string);"}]}}}}]
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/index-advisor/nested-array-index/nested-array-index.9.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/index-advisor/nested-array-index/nested-array-index.9.adm
index b5d479a..fb5edaa 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/index-advisor/nested-array-index/nested-array-index.9.adm
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/cbo-join/index-advisor/nested-array-index/nested-array-index.9.adm
@@ -1 +1 @@
-[{"#operator":"Advise","advice":{"#operator":"IndexAdvice","adviseinfo":{"current_indexes":[],"recommended_indexes":{"indexes":[]}}}}]
\ No newline at end of file
+[{"#operator":"Advise","advice":{"#operator":"IndexAdvice","adviseinfo":{"current_indexes":[],"recommended_indexes":{"indexes":[{"index_statement":"CREATE
INDEX array_idx_k1_k2_k3_k4_k5_k6 ON `Default`.`test`.`A`(UNNEST `k1`.`k2`
UNNEST `k3`.`k4` UNNEST `k5`.`k6` SELECT `qty`: bigint, SELECT `price`:
double);"}]}}}}]
\ No newline at end of file
--
To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/20396?usp=email
To unsubscribe, or for help writing mail filters, visit
https://asterix-gerrit.ics.uci.edu/settings?usp=email
Gerrit-MessageType: newchange
Gerrit-Project: asterixdb
Gerrit-Branch: master
Gerrit-Change-Id: I344b74cb67656d8848c5855fa9c4842cd6d1cd90
Gerrit-Change-Number: 20396
Gerrit-PatchSet: 1
Gerrit-Owner: Preetham Poluparthi <[email protected]>
