>From Ian Maxon <[email protected]>:
Ian Maxon has uploaded this change for review. (
https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21960?usp=email )
Change subject: [ASTERIXDB-3577][TEST] Add column and cloud plans for new CBO
steps
......................................................................
[ASTERIXDB-3577][TEST] Add column and cloud plans for new CBO steps
- user model changes: no
- storage format changes: no
- interface changes: no
Details:
The single-collection-queries steps added for the 0.0 doc-size fix
had no expected plans under results_column or results_cloud, so those
suites fell back to the row-format plans and failed on cost and
sample-estimate differences. As with the test's earlier steps, column
storage also pushes the projection into the scan.
Generated-by: Claude Opus 5.5
Change-Id: I9ab7536a7df9b26cb75d3b5f4c338662ea156045
---
A
asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.10.plan
A
asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.11.plan
A
asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.12.plan
A
asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.13.plan
A
asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.14.plan
A
asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.15.plan
A
asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.17.plan
A
asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.9.plan
A
asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.10.plan
A
asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.11.plan
A
asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.12.plan
A
asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.13.plan
A
asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.14.plan
A
asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.15.plan
A
asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.17.plan
A
asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.9.plan
16 files changed, 300 insertions(+), 0 deletions(-)
git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb
refs/changes/60/21960/1
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.10.plan
b/asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.10.plan
new file mode 100644
index 0000000..fbb5366
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.10.plan
@@ -0,0 +1,18 @@
+distribute result [$$19] [cardinality: 1495.77, doc-size: 12.0, op-cost: 0.0,
total-cost: 750.83]
+-- DISTRIBUTE_RESULT |PARTITIONED|
+ exchange [cardinality: 1495.77, doc-size: 12.0, op-cost: 0.0, total-cost:
750.83]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ assign [$$19] <- [{"o_orderdate": $$o.getField(4)}] project: [$$19]
[cardinality: 1495.77, doc-size: 12.0, op-cost: 0.0, total-cost: 750.83]
+ -- ASSIGN |PARTITIONED|
+ project ([$$o]) [cardinality: 1495.77, doc-size: 12.0, op-cost: 0.0,
total-cost: 750.83]
+ -- STREAM_PROJECT |PARTITIONED|
+ exchange [cardinality: 1495.77, doc-size: 12.0, op-cost: 0.0,
total-cost: 750.83]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ unnest-map [$$20, $$o] <- index-search("Orders", 0, "Default",
"tpch", "Orders", false, false, 1, $$23, 0, false, true, false) [cardinality:
1495.77, doc-size: 12.0, op-cost: 0.0, total-cost: 750.83]
+ -- BTREE_SEARCH |PARTITIONED|
+ exchange [cardinality: 0.0, doc-size: 0.0, op-cost: 0.0,
total-cost: 0.0]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ assign [$$23] <- [5] [cardinality: 0.0, doc-size: 0.0, op-cost:
0.0, total-cost: 0.0]
+ -- ASSIGN |PARTITIONED|
+ empty-tuple-source [cardinality: 0.0, doc-size: 0.0, op-cost:
0.0, total-cost: 0.0]
+ -- EMPTY_TUPLE_SOURCE |PARTITIONED|
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.11.plan
b/asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.11.plan
new file mode 100644
index 0000000..fa7d517
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.11.plan
@@ -0,0 +1,14 @@
+distribute result [$$o] [cardinality: 1500.0, doc-size: 152.94, op-cost: 0.0,
total-cost: 752.24]
+-- DISTRIBUTE_RESULT |PARTITIONED|
+ exchange [cardinality: 1500.0, doc-size: 152.94, op-cost: 0.0, total-cost:
752.24]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ project ([$$o]) [cardinality: 1500.0, doc-size: 152.94, op-cost: 0.0,
total-cost: 752.24]
+ -- STREAM_PROJECT |PARTITIONED|
+ exchange [cardinality: 1500.0, doc-size: 152.94, op-cost: 0.0,
total-cost: 752.24]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ data-scan []<-[$$15, $$o] <- tpch.Orders [cardinality: 1500.0,
doc-size: 152.94, op-cost: 0.0, total-cost: 752.24]
+ -- DATASOURCE_SCAN |PARTITIONED|
+ exchange [cardinality: 0.0, doc-size: 0.0, op-cost: 0.0, total-cost:
0.0]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ empty-tuple-source [cardinality: 0.0, doc-size: 0.0, op-cost: 0.0,
total-cost: 0.0]
+ -- EMPTY_TUPLE_SOURCE |PARTITIONED|
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.12.plan
b/asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.12.plan
new file mode 100644
index 0000000..bbda63f
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.12.plan
@@ -0,0 +1,16 @@
+distribute result [$$16] [cardinality: 1500.0, doc-size: 12.0, op-cost: 0.0,
total-cost: 752.24]
+-- DISTRIBUTE_RESULT |PARTITIONED|
+ exchange [cardinality: 1500.0, doc-size: 12.0, op-cost: 0.0, total-cost:
752.24]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ assign [$$16] <- [$$o.getField(4)] project: [$$16] [cardinality: 1500.0,
doc-size: 12.0, op-cost: 0.0, total-cost: 752.24]
+ -- ASSIGN |PARTITIONED|
+ project ([$$o]) [cardinality: 1500.0, doc-size: 12.0, op-cost: 0.0,
total-cost: 752.24]
+ -- STREAM_PROJECT |PARTITIONED|
+ exchange [cardinality: 1500.0, doc-size: 12.0, op-cost: 0.0,
total-cost: 752.24]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ data-scan []<-[$$17, $$o] <- tpch.Orders [cardinality: 1500.0,
doc-size: 12.0, op-cost: 0.0, total-cost: 752.24]
+ -- DATASOURCE_SCAN |PARTITIONED|
+ exchange [cardinality: 0.0, doc-size: 0.0, op-cost: 0.0,
total-cost: 0.0]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ empty-tuple-source [cardinality: 0.0, doc-size: 0.0, op-cost:
0.0, total-cost: 0.0]
+ -- EMPTY_TUPLE_SOURCE |PARTITIONED|
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.13.plan
b/asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.13.plan
new file mode 100644
index 0000000..a18b136
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.13.plan
@@ -0,0 +1,38 @@
+distribute result [$$52] [cardinality: 4.0, doc-size: 3.0, op-cost: 0.0,
total-cost: 1151.59]
+-- DISTRIBUTE_RESULT |PARTITIONED|
+ exchange [cardinality: 4.0, doc-size: 3.0, op-cost: 0.0, total-cost: 1151.59]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ assign [$$52] <- [{"o_orderstatus": $$o_orderstatus, "cnt": $$55}]
project: [$$52] [cardinality: 4.0, doc-size: 3.0, op-cost: 0.0, total-cost:
1151.59]
+ -- ASSIGN |PARTITIONED|
+ exchange [cardinality: 4.0, doc-size: 3.0, op-cost: 0.0, total-cost:
1151.59]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ group by ([$$o_orderstatus := $$57]) decor ([]) {
+ aggregate [$$55] <- [sql-sum-serial($$56)] [cardinality:
0.0, doc-size: 0.0, op-cost: 0.0, total-cost: 0.0]
+ -- AGGREGATE |LOCAL|
+ nested tuple source [cardinality: 0.0, doc-size: 0.0,
op-cost: 0.0, total-cost: 0.0]
+ -- NESTED_TUPLE_SOURCE |LOCAL|
+ } [cardinality: 4.0, doc-size: 3.0, op-cost: 20.0, total-cost:
1151.59]
+ -- EXTERNAL_GROUP_BY[$$57] |PARTITIONED|
+ exchange [cardinality: 4.0, doc-size: 3.0, op-cost: 0.0, total-cost:
1131.59]
+ -- HASH_PARTITION_EXCHANGE [$$57] |PARTITIONED|
+ group by ([$$57 := $$53]) decor ([]) {
+ aggregate [$$56] <- [sql-count-serial(1)] [cardinality:
0.0, doc-size: 0.0, op-cost: 0.0, total-cost: 0.0]
+ -- AGGREGATE |LOCAL|
+ nested tuple source [cardinality: 0.0, doc-size: 0.0,
op-cost: 0.0, total-cost: 0.0]
+ -- NESTED_TUPLE_SOURCE |LOCAL|
+ } [cardinality: 4.0, doc-size: 3.0, op-cost: 379.35,
total-cost: 1131.59]
+ -- EXTERNAL_GROUP_BY[$$53] |PARTITIONED|
+ exchange [cardinality: 1500.0, doc-size: 3.0, op-cost: 0.0,
total-cost: 752.24]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ assign [$$53] <- [$$o.getField(2)] project: [$$53]
[cardinality: 1500.0, doc-size: 3.0, op-cost: 0.0, total-cost: 752.24]
+ -- ASSIGN |PARTITIONED|
+ project ([$$o]) [cardinality: 1500.0, doc-size: 3.0,
op-cost: 0.0, total-cost: 752.24]
+ -- STREAM_PROJECT |PARTITIONED|
+ exchange [cardinality: 1500.0, doc-size: 3.0, op-cost:
0.0, total-cost: 752.24]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ data-scan []<-[$$54, $$o] <- tpch.Orders [cardinality:
1500.0, doc-size: 3.0, op-cost: 0.0, total-cost: 752.24]
+ -- DATASOURCE_SCAN |PARTITIONED|
+ exchange [cardinality: 0.0, doc-size: 0.0, op-cost:
0.0, total-cost: 0.0]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ empty-tuple-source [cardinality: 0.0, doc-size: 0.0,
op-cost: 0.0, total-cost: 0.0]
+ -- EMPTY_TUPLE_SOURCE |PARTITIONED|
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.14.plan
b/asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.14.plan
new file mode 100644
index 0000000..9a5bac5
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.14.plan
@@ -0,0 +1,16 @@
+distribute result [$$18] [cardinality: 1500.0, doc-size: 9.0, op-cost: 0.0,
total-cost: 752.24]
+-- DISTRIBUTE_RESULT |PARTITIONED|
+ exchange [cardinality: 1500.0, doc-size: 9.0, op-cost: 0.0, total-cost:
752.24]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ assign [$$18] <- [{"doubled": numeric-multiply($$o.getField(3), 2)}]
project: [$$18] [cardinality: 1500.0, doc-size: 9.0, op-cost: 0.0, total-cost:
752.24]
+ -- ASSIGN |PARTITIONED|
+ project ([$$o]) [cardinality: 1500.0, doc-size: 9.0, op-cost: 0.0,
total-cost: 752.24]
+ -- STREAM_PROJECT |PARTITIONED|
+ exchange [cardinality: 1500.0, doc-size: 9.0, op-cost: 0.0,
total-cost: 752.24]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ data-scan []<-[$$19, $$o] <- tpch.Orders [cardinality: 1500.0,
doc-size: 9.0, op-cost: 0.0, total-cost: 752.24]
+ -- DATASOURCE_SCAN |PARTITIONED|
+ exchange [cardinality: 0.0, doc-size: 0.0, op-cost: 0.0,
total-cost: 0.0]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ empty-tuple-source [cardinality: 0.0, doc-size: 0.0, op-cost:
0.0, total-cost: 0.0]
+ -- EMPTY_TUPLE_SOURCE |PARTITIONED|
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.15.plan
b/asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.15.plan
new file mode 100644
index 0000000..7815a8b
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.15.plan
@@ -0,0 +1,14 @@
+distribute result [$$32] [cardinality: 6005.0, doc-size: 142.41, op-cost: 0.0,
total-cost: 3014.04]
+-- DISTRIBUTE_RESULT |PARTITIONED|
+ exchange [cardinality: 6005.0, doc-size: 142.41, op-cost: 0.0, total-cost:
3014.04]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ assign [$$32] <- [{"l_orderkey": $$33, "l_partkey": $$l.getField(1),
"l_suppkey": $$l.getField(2), "l_linenumber": $$34, "l_quantity":
$$l.getField(4), "l_extendedprice": $$l.getField(5), "l_discount":
$$l.getField(6), "l_tax": $$l.getField(7), "l_returnflag": $$l.getField(8),
"l_linestatus": $$l.getField(9), "l_shipdate": $$l.getField(10),
"l_commitdate": $$l.getField(11), "l_receiptdate": $$l.getField(12),
"l_shipinstruct": $$l.getField(13), "l_shipmode": $$l.getField(14),
"l_comment": $$l.getField(15)}] project: [$$32] [cardinality: 6005.0, doc-size:
142.41, op-cost: 0.0, total-cost: 3014.04]
+ -- ASSIGN |PARTITIONED|
+ exchange [cardinality: 6005.0, doc-size: 142.41, op-cost: 0.0,
total-cost: 3014.04]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ data-scan []<-[$$33, $$34, $$l] <- tpch.LineItem [cardinality: 6005.0,
doc-size: 142.41, op-cost: 0.0, total-cost: 3014.04]
+ -- DATASOURCE_SCAN |PARTITIONED|
+ exchange [cardinality: 0.0, doc-size: 0.0, op-cost: 0.0, total-cost:
0.0]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ empty-tuple-source [cardinality: 0.0, doc-size: 0.0, op-cost: 0.0,
total-cost: 0.0]
+ -- EMPTY_TUPLE_SOURCE |PARTITIONED|
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.17.plan
b/asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.17.plan
new file mode 100644
index 0000000..2480d63
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.17.plan
@@ -0,0 +1,18 @@
+distribute result [$$18] [cardinality: 1501.41, doc-size: 12.0, op-cost: 0.0,
total-cost: 752.24]
+-- DISTRIBUTE_RESULT |PARTITIONED|
+ exchange [cardinality: 1501.41, doc-size: 12.0, op-cost: 0.0, total-cost:
752.24]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ select (gt($$o.getField(1), 0)) project: [$$18] [cardinality: 1501.41,
doc-size: 12.0, op-cost: 0.0, total-cost: 752.24]
+ -- STREAM_SELECT |PARTITIONED|
+ assign [$$18] <- [$$o.getField(4)] [cardinality: 1500.0, doc-size: 12.0,
op-cost: 0.0, total-cost: 752.24]
+ -- ASSIGN |PARTITIONED|
+ project ([$$o]) [cardinality: 1500.0, doc-size: 12.0, op-cost: 0.0,
total-cost: 752.24]
+ -- STREAM_PROJECT |PARTITIONED|
+ exchange [cardinality: 1500.0, doc-size: 12.0, op-cost: 0.0,
total-cost: 752.24]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ data-scan []<-[$$19, $$o] <- tpch.Orders [cardinality: 1500.0,
doc-size: 12.0, op-cost: 0.0, total-cost: 752.24]
+ -- DATASOURCE_SCAN |PARTITIONED|
+ exchange [cardinality: 0.0, doc-size: 0.0, op-cost: 0.0,
total-cost: 0.0]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ empty-tuple-source [cardinality: 0.0, doc-size: 0.0, op-cost:
0.0, total-cost: 0.0]
+ -- EMPTY_TUPLE_SOURCE |PARTITIONED|
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.9.plan
b/asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.9.plan
new file mode 100644
index 0000000..6350eaf
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results_cloud/cardinality-estimation/single-collection-queries/single-collection-queries.9.plan
@@ -0,0 +1,16 @@
+distribute result [$$17] [cardinality: 1500.0, doc-size: 12.0, op-cost: 0.0,
total-cost: 752.24]
+-- DISTRIBUTE_RESULT |PARTITIONED|
+ exchange [cardinality: 1500.0, doc-size: 12.0, op-cost: 0.0, total-cost:
752.24]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ assign [$$17] <- [{"o_orderdate": $$o.getField(4)}] project: [$$17]
[cardinality: 1500.0, doc-size: 12.0, op-cost: 0.0, total-cost: 752.24]
+ -- ASSIGN |PARTITIONED|
+ project ([$$o]) [cardinality: 1500.0, doc-size: 12.0, op-cost: 0.0,
total-cost: 752.24]
+ -- STREAM_PROJECT |PARTITIONED|
+ exchange [cardinality: 1500.0, doc-size: 12.0, op-cost: 0.0,
total-cost: 752.24]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ data-scan []<-[$$18, $$o] <- tpch.Orders [cardinality: 1500.0,
doc-size: 12.0, op-cost: 0.0, total-cost: 752.24]
+ -- DATASOURCE_SCAN |PARTITIONED|
+ exchange [cardinality: 0.0, doc-size: 0.0, op-cost: 0.0,
total-cost: 0.0]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ empty-tuple-source [cardinality: 0.0, doc-size: 0.0, op-cost:
0.0, total-cost: 0.0]
+ -- EMPTY_TUPLE_SOURCE |PARTITIONED|
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.10.plan
b/asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.10.plan
new file mode 100644
index 0000000..5eca872
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.10.plan
@@ -0,0 +1,18 @@
+distribute result [$$19] [cardinality: 1497.18, doc-size: 12.0, op-cost: 0.0,
total-cost: 749.35]
+-- DISTRIBUTE_RESULT |PARTITIONED|
+ exchange [cardinality: 1497.18, doc-size: 12.0, op-cost: 0.0, total-cost:
749.35]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ assign [$$19] <- [{"o_orderdate": $$o.getField(4)}] project: [$$19]
[cardinality: 1497.18, doc-size: 12.0, op-cost: 0.0, total-cost: 749.35]
+ -- ASSIGN |PARTITIONED|
+ project ([$$o]) [cardinality: 1497.18, doc-size: 12.0, op-cost: 0.0,
total-cost: 749.35]
+ -- STREAM_PROJECT |PARTITIONED|
+ exchange [cardinality: 1497.18, doc-size: 12.0, op-cost: 0.0,
total-cost: 749.35]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ unnest-map [$$20, $$o] <- index-search("Orders", 0, "Default",
"tpch", "Orders", false, false, 1, $$23, 0, false, true, false) project
({o_orderdate:any}) [cardinality: 1497.18, doc-size: 12.0, op-cost: 0.0,
total-cost: 749.35]
+ -- BTREE_SEARCH |PARTITIONED|
+ exchange [cardinality: 0.0, doc-size: 0.0, op-cost: 0.0,
total-cost: 0.0]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ assign [$$23] <- [5] [cardinality: 0.0, doc-size: 0.0, op-cost:
0.0, total-cost: 0.0]
+ -- ASSIGN |PARTITIONED|
+ empty-tuple-source [cardinality: 0.0, doc-size: 0.0, op-cost:
0.0, total-cost: 0.0]
+ -- EMPTY_TUPLE_SOURCE |PARTITIONED|
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.11.plan
b/asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.11.plan
new file mode 100644
index 0000000..daaef7a
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.11.plan
@@ -0,0 +1,14 @@
+distribute result [$$o] [cardinality: 1500.0, doc-size: 152.61, op-cost: 0.0,
total-cost: 752.16]
+-- DISTRIBUTE_RESULT |PARTITIONED|
+ exchange [cardinality: 1500.0, doc-size: 152.61, op-cost: 0.0, total-cost:
752.16]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ project ([$$o]) [cardinality: 1500.0, doc-size: 152.61, op-cost: 0.0,
total-cost: 752.16]
+ -- STREAM_PROJECT |PARTITIONED|
+ exchange [cardinality: 1500.0, doc-size: 152.61, op-cost: 0.0,
total-cost: 752.16]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ data-scan []<-[$$15, $$o] <- tpch.Orders [cardinality: 1500.0,
doc-size: 152.61, op-cost: 0.0, total-cost: 752.16]
+ -- DATASOURCE_SCAN |PARTITIONED|
+ exchange [cardinality: 0.0, doc-size: 0.0, op-cost: 0.0, total-cost:
0.0]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ empty-tuple-source [cardinality: 0.0, doc-size: 0.0, op-cost: 0.0,
total-cost: 0.0]
+ -- EMPTY_TUPLE_SOURCE |PARTITIONED|
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.12.plan
b/asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.12.plan
new file mode 100644
index 0000000..74fb489
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.12.plan
@@ -0,0 +1,16 @@
+distribute result [$$16] [cardinality: 1500.0, doc-size: 12.0, op-cost: 0.0,
total-cost: 750.41]
+-- DISTRIBUTE_RESULT |PARTITIONED|
+ exchange [cardinality: 1500.0, doc-size: 12.0, op-cost: 0.0, total-cost:
750.41]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ assign [$$16] <- [$$o.getField(4)] project: [$$16] [cardinality: 1500.0,
doc-size: 12.0, op-cost: 0.0, total-cost: 750.41]
+ -- ASSIGN |PARTITIONED|
+ project ([$$o]) [cardinality: 1500.0, doc-size: 12.0, op-cost: 0.0,
total-cost: 750.41]
+ -- STREAM_PROJECT |PARTITIONED|
+ exchange [cardinality: 1500.0, doc-size: 12.0, op-cost: 0.0,
total-cost: 750.41]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ data-scan []<-[$$17, $$o] <- tpch.Orders project ({o_orderdate:any})
[cardinality: 1500.0, doc-size: 12.0, op-cost: 0.0, total-cost: 750.41]
+ -- DATASOURCE_SCAN |PARTITIONED|
+ exchange [cardinality: 0.0, doc-size: 0.0, op-cost: 0.0,
total-cost: 0.0]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ empty-tuple-source [cardinality: 0.0, doc-size: 0.0, op-cost:
0.0, total-cost: 0.0]
+ -- EMPTY_TUPLE_SOURCE |PARTITIONED|
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.13.plan
b/asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.13.plan
new file mode 100644
index 0000000..9a30acb
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.13.plan
@@ -0,0 +1,38 @@
+distribute result [$$52] [cardinality: 4.0, doc-size: 3.0, op-cost: 0.0,
total-cost: 1149.76]
+-- DISTRIBUTE_RESULT |PARTITIONED|
+ exchange [cardinality: 4.0, doc-size: 3.0, op-cost: 0.0, total-cost: 1149.76]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ assign [$$52] <- [{"o_orderstatus": $$o_orderstatus, "cnt": $$55}]
project: [$$52] [cardinality: 4.0, doc-size: 3.0, op-cost: 0.0, total-cost:
1149.76]
+ -- ASSIGN |PARTITIONED|
+ exchange [cardinality: 4.0, doc-size: 3.0, op-cost: 0.0, total-cost:
1149.76]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ group by ([$$o_orderstatus := $$57]) decor ([]) {
+ aggregate [$$55] <- [sql-sum-serial($$56)] [cardinality:
0.0, doc-size: 0.0, op-cost: 0.0, total-cost: 0.0]
+ -- AGGREGATE |LOCAL|
+ nested tuple source [cardinality: 0.0, doc-size: 0.0,
op-cost: 0.0, total-cost: 0.0]
+ -- NESTED_TUPLE_SOURCE |LOCAL|
+ } [cardinality: 4.0, doc-size: 3.0, op-cost: 20.0, total-cost:
1149.76]
+ -- EXTERNAL_GROUP_BY[$$57] |PARTITIONED|
+ exchange [cardinality: 4.0, doc-size: 3.0, op-cost: 0.0, total-cost:
1129.76]
+ -- HASH_PARTITION_EXCHANGE [$$57] |PARTITIONED|
+ group by ([$$57 := $$53]) decor ([]) {
+ aggregate [$$56] <- [sql-count-serial(1)] [cardinality:
0.0, doc-size: 0.0, op-cost: 0.0, total-cost: 0.0]
+ -- AGGREGATE |LOCAL|
+ nested tuple source [cardinality: 0.0, doc-size: 0.0,
op-cost: 0.0, total-cost: 0.0]
+ -- NESTED_TUPLE_SOURCE |LOCAL|
+ } [cardinality: 4.0, doc-size: 3.0, op-cost: 379.35,
total-cost: 1129.76]
+ -- EXTERNAL_GROUP_BY[$$53] |PARTITIONED|
+ exchange [cardinality: 1500.0, doc-size: 3.0, op-cost: 0.0,
total-cost: 750.41]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ assign [$$53] <- [$$o.getField(2)] project: [$$53]
[cardinality: 1500.0, doc-size: 3.0, op-cost: 0.0, total-cost: 750.41]
+ -- ASSIGN |PARTITIONED|
+ project ([$$o]) [cardinality: 1500.0, doc-size: 3.0,
op-cost: 0.0, total-cost: 750.41]
+ -- STREAM_PROJECT |PARTITIONED|
+ exchange [cardinality: 1500.0, doc-size: 3.0, op-cost:
0.0, total-cost: 750.41]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ data-scan []<-[$$54, $$o] <- tpch.Orders project
({o_orderstatus:any}) [cardinality: 1500.0, doc-size: 3.0, op-cost: 0.0,
total-cost: 750.41]
+ -- DATASOURCE_SCAN |PARTITIONED|
+ exchange [cardinality: 0.0, doc-size: 0.0, op-cost:
0.0, total-cost: 0.0]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ empty-tuple-source [cardinality: 0.0, doc-size: 0.0,
op-cost: 0.0, total-cost: 0.0]
+ -- EMPTY_TUPLE_SOURCE |PARTITIONED|
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.14.plan
b/asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.14.plan
new file mode 100644
index 0000000..3fe3e33
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.14.plan
@@ -0,0 +1,16 @@
+distribute result [$$18] [cardinality: 1500.0, doc-size: 9.0, op-cost: 0.0,
total-cost: 750.41]
+-- DISTRIBUTE_RESULT |PARTITIONED|
+ exchange [cardinality: 1500.0, doc-size: 9.0, op-cost: 0.0, total-cost:
750.41]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ assign [$$18] <- [{"doubled": numeric-multiply($$o.getField(3), 2)}]
project: [$$18] [cardinality: 1500.0, doc-size: 9.0, op-cost: 0.0, total-cost:
750.41]
+ -- ASSIGN |PARTITIONED|
+ project ([$$o]) [cardinality: 1500.0, doc-size: 9.0, op-cost: 0.0,
total-cost: 750.41]
+ -- STREAM_PROJECT |PARTITIONED|
+ exchange [cardinality: 1500.0, doc-size: 9.0, op-cost: 0.0,
total-cost: 750.41]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ data-scan []<-[$$19, $$o] <- tpch.Orders project
({o_totalprice:any}) [cardinality: 1500.0, doc-size: 9.0, op-cost: 0.0,
total-cost: 750.41]
+ -- DATASOURCE_SCAN |PARTITIONED|
+ exchange [cardinality: 0.0, doc-size: 0.0, op-cost: 0.0,
total-cost: 0.0]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ empty-tuple-source [cardinality: 0.0, doc-size: 0.0, op-cost:
0.0, total-cost: 0.0]
+ -- EMPTY_TUPLE_SOURCE |PARTITIONED|
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.15.plan
b/asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.15.plan
new file mode 100644
index 0000000..7842160
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.15.plan
@@ -0,0 +1,14 @@
+distribute result [$$32] [cardinality: 5981.0, doc-size: 142.58, op-cost: 0.0,
total-cost: 3001.47]
+-- DISTRIBUTE_RESULT |PARTITIONED|
+ exchange [cardinality: 5981.0, doc-size: 142.58, op-cost: 0.0, total-cost:
3001.47]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ assign [$$32] <- [{"l_orderkey": $$33, "l_partkey": $$l.getField(1),
"l_suppkey": $$l.getField(2), "l_linenumber": $$34, "l_quantity":
$$l.getField(4), "l_extendedprice": $$l.getField(5), "l_discount":
$$l.getField(6), "l_tax": $$l.getField(7), "l_returnflag": $$l.getField(8),
"l_linestatus": $$l.getField(9), "l_shipdate": $$l.getField(10),
"l_commitdate": $$l.getField(11), "l_receiptdate": $$l.getField(12),
"l_shipinstruct": $$l.getField(13), "l_shipmode": $$l.getField(14),
"l_comment": $$l.getField(15)}] project: [$$32] [cardinality: 5981.0, doc-size:
142.58, op-cost: 0.0, total-cost: 3001.47]
+ -- ASSIGN |PARTITIONED|
+ exchange [cardinality: 5981.0, doc-size: 142.58, op-cost: 0.0,
total-cost: 3001.47]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ data-scan []<-[$$33, $$34, $$l] <- tpch.LineItem project
({l_returnflag:any,l_receiptdate:any,l_tax:any,l_shipmode:any,l_suppkey:any,l_shipdate:any,l_commitdate:any,l_partkey:any,l_quantity:any,l_linestatus:any,l_comment:any,l_extendedprice:any,l_discount:any,l_shipinstruct:any})
[cardinality: 5981.0, doc-size: 142.58, op-cost: 0.0, total-cost: 3001.47]
+ -- DATASOURCE_SCAN |PARTITIONED|
+ exchange [cardinality: 0.0, doc-size: 0.0, op-cost: 0.0, total-cost:
0.0]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ empty-tuple-source [cardinality: 0.0, doc-size: 0.0, op-cost: 0.0,
total-cost: 0.0]
+ -- EMPTY_TUPLE_SOURCE |PARTITIONED|
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.17.plan
b/asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.17.plan
new file mode 100644
index 0000000..f83a1ed
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.17.plan
@@ -0,0 +1,18 @@
+distribute result [$$18] [cardinality: 1501.41, doc-size: 12.0, op-cost: 0.0,
total-cost: 750.6]
+-- DISTRIBUTE_RESULT |PARTITIONED|
+ exchange [cardinality: 1501.41, doc-size: 12.0, op-cost: 0.0, total-cost:
750.6]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ select (gt($$o.getField(1), 0)) project: [$$18] [cardinality: 1501.41,
doc-size: 12.0, op-cost: 0.0, total-cost: 750.6]
+ -- STREAM_SELECT |PARTITIONED|
+ assign [$$18] <- [$$o.getField(4)] [cardinality: 1500.0, doc-size: 12.0,
op-cost: 0.0, total-cost: 750.6]
+ -- ASSIGN |PARTITIONED|
+ project ([$$o]) [cardinality: 1500.0, doc-size: 12.0, op-cost: 0.0,
total-cost: 750.6]
+ -- STREAM_PROJECT |PARTITIONED|
+ exchange [cardinality: 1500.0, doc-size: 12.0, op-cost: 0.0,
total-cost: 750.6]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ data-scan []<-[$$19, $$o] <- tpch.Orders project
({o_orderdate:any,o_custkey:any}) filter on: gt($$o.getField(1), 0)
range-filter on: gt($$o.getField(1), 0) [cardinality: 1500.0, doc-size: 12.0,
op-cost: 0.0, total-cost: 750.6]
+ -- DATASOURCE_SCAN |PARTITIONED|
+ exchange [cardinality: 0.0, doc-size: 0.0, op-cost: 0.0,
total-cost: 0.0]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ empty-tuple-source [cardinality: 0.0, doc-size: 0.0, op-cost:
0.0, total-cost: 0.0]
+ -- EMPTY_TUPLE_SOURCE |PARTITIONED|
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.9.plan
b/asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.9.plan
new file mode 100644
index 0000000..7155d41
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results_column/cardinality-estimation/single-collection-queries/single-collection-queries.9.plan
@@ -0,0 +1,16 @@
+distribute result [$$17] [cardinality: 1500.0, doc-size: 12.0, op-cost: 0.0,
total-cost: 750.41]
+-- DISTRIBUTE_RESULT |PARTITIONED|
+ exchange [cardinality: 1500.0, doc-size: 12.0, op-cost: 0.0, total-cost:
750.41]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ assign [$$17] <- [{"o_orderdate": $$o.getField(4)}] project: [$$17]
[cardinality: 1500.0, doc-size: 12.0, op-cost: 0.0, total-cost: 750.41]
+ -- ASSIGN |PARTITIONED|
+ project ([$$o]) [cardinality: 1500.0, doc-size: 12.0, op-cost: 0.0,
total-cost: 750.41]
+ -- STREAM_PROJECT |PARTITIONED|
+ exchange [cardinality: 1500.0, doc-size: 12.0, op-cost: 0.0,
total-cost: 750.41]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ data-scan []<-[$$18, $$o] <- tpch.Orders project ({o_orderdate:any})
[cardinality: 1500.0, doc-size: 12.0, op-cost: 0.0, total-cost: 750.41]
+ -- DATASOURCE_SCAN |PARTITIONED|
+ exchange [cardinality: 0.0, doc-size: 0.0, op-cost: 0.0,
total-cost: 0.0]
+ -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
+ empty-tuple-source [cardinality: 0.0, doc-size: 0.0, op-cost:
0.0, total-cost: 0.0]
+ -- EMPTY_TUPLE_SOURCE |PARTITIONED|
--
To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21960?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: I9ab7536a7df9b26cb75d3b5f4c338662ea156045
Gerrit-Change-Number: 21960
Gerrit-PatchSet: 1
Gerrit-Owner: Ian Maxon <[email protected]>
