Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
>From Vijay Sarathy :
Vijay Sarathy has submitted this change. (
https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 )
Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there
are multiple join predicates.
..
[ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are
multiple join predicates.
Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196
Integration-Tests: Jenkins
Tested-by: Jenkins
Reviewed-by:
Reviewed-by: Vijay Sarathy
---
M
asterixdb/asterix-app/src/test/resources/runtimets/results_cbo/join/hash-join-with-redundant-variable/hash-join-with-redundant-variable.06.plan
M
asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/PlanNode.java
M
asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/cost/CostMethods.java
M
asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/am/AbstractIntroduceAccessMethodRule.java
M
asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/am/IntroduceJoinAccessMethodRule.java
A
asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/open-index-enforced/inverted-index-join/ngram-contains_01_ps.plan
A
asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/btree-index-join/hints-indexnl-params/hints-indexnl-params-4.plan
A
asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/nested-open-index/inverted-index-join/ngram-contains_02_ps.plan
M
asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/JoinEnum.java
A
asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/nested-open-index/inverted-index-join/ngram-contains_01_ps.plan
M
asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/JoinNode.java
M
asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/EnumerateJoinsRule.java
M
asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/cost/ICostMethods.java
13 files changed, 319 insertions(+), 91 deletions(-)
Approvals:
murali.kris...@couchbase.com: Looks good to me, but someone else must approve
Vijay Sarathy: Looks good to me, approved
Jenkins: Verified; Verified
diff --git
a/asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/cost/CostMethods.java
b/asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/cost/CostMethods.java
index 3de972a..71e9b3c 100644
---
a/asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/cost/CostMethods.java
+++
b/asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/cost/CostMethods.java
@@ -22,6 +22,7 @@
import java.util.Map;
import org.apache.asterix.metadata.declared.MetadataProvider;
+import org.apache.asterix.metadata.entities.Index;
import org.apache.asterix.optimizer.rules.cbo.JoinNode;
import org.apache.hyracks.algebricks.common.utils.Pair;
import org.apache.hyracks.algebricks.core.algebra.base.ILogicalOperator;
@@ -129,7 +130,7 @@
return new Cost(DOP * rightJn.getCardinality());
}
-public Cost costIndexNLJoin(JoinNode jn) {
+public Cost costIndexNLJoin(JoinNode jn, Index index) {
JoinNode leftJn = jn.getLeftJn();
JoinNode rightJn = jn.getRightJn();
double origRightCard = rightJn.getOrigCardinality();
diff --git
a/asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/cost/ICostMethods.java
b/asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/cost/ICostMethods.java
index a1dd374..d8dd77f 100644
---
a/asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/cost/ICostMethods.java
+++
b/asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/cost/ICostMethods.java
@@ -19,6 +19,7 @@
package org.apache.asterix.optimizer.cost;
+import org.apache.asterix.metadata.entities.Index;
import org.apache.asterix.optimizer.rules.cbo.JoinNode;
import org.apache.hyracks.algebricks.core.algebra.base.IOptimizationContext;
import
org.apache.hyracks.algebricks.core.algebra.operators.logical.DistinctOperator;
@@ -36,7 +37,7 @@
Cost costBroadcastHashJoin(JoinNode currentJn);
-Cost costIndexNLJoin(JoinNode currentJn);
+Cost costIndexNLJoin(JoinNode currentJn, Index index);
Cost costCartesianProductJoin(JoinNode currentJn);
diff --git
a/asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/am/AbstractIntroduceAccessMethodRule.java
b/asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/am/AbstractIntroduceAccessMethodRule.java
index 4eb7ff3..b5041f0 100644
---
a/asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/am/AbstractIntroduceAccessMethodRule.java
+++
b/asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/am/AbstractIntroduceAccessMethodRule.java
@@
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
>From Vijay Sarathy : Vijay Sarathy has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 ) Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates. .. Patch Set 14: Code-Review+2 -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 14 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Vijay Sarathy Gerrit-Reviewer: murali.kris...@couchbase.com Gerrit-Comment-Date: Fri, 10 May 2024 15:45:19 + Gerrit-HasComments: No Gerrit-Has-Labels: Yes Gerrit-MessageType: comment
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
>From : Attention is currently required from: Vijay Sarathy. murali.kris...@couchbase.com has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 ) Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates. .. Patch Set 14: Code-Review+1 -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 14 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Vijay Sarathy Gerrit-Reviewer: murali.kris...@couchbase.com Gerrit-Attention: Vijay Sarathy Gerrit-Comment-Date: Fri, 10 May 2024 15:43:37 + Gerrit-HasComments: No Gerrit-Has-Labels: Yes Gerrit-MessageType: comment
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
>From Vijay Sarathy : Attention is currently required from: murali.kris...@couchbase.com. Vijay Sarathy has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 ) Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates. .. Patch Set 14: Code-Review+1 -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 14 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Vijay Sarathy Gerrit-Reviewer: murali.kris...@couchbase.com Gerrit-Attention: murali.kris...@couchbase.com Gerrit-Comment-Date: Fri, 10 May 2024 13:48:01 + Gerrit-HasComments: No Gerrit-Has-Labels: Yes Gerrit-MessageType: comment
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
>From Jenkins : Attention is currently required from: Vijay Sarathy. Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 ) Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates. .. Patch Set 14: Integration-Tests+1 Integration Tests Successful https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-trigger/522/ : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 14 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-Comment-Date: Fri, 10 May 2024 02:04:39 + Gerrit-HasComments: No Gerrit-Has-Labels: Yes Gerrit-MessageType: comment
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
>From Vijay Sarathy : Attention is currently required from: Vijay Sarathy. Hello Jenkins, Anon. E. Moose #1000171, I'd like you to reexamine a change. Please visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 to look at the new patch set (#14). Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates. .. [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates. Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 --- M asterixdb/asterix-app/src/test/resources/runtimets/results_cbo/join/hash-join-with-redundant-variable/hash-join-with-redundant-variable.06.plan M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/PlanNode.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/cost/CostMethods.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/am/AbstractIntroduceAccessMethodRule.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/am/IntroduceJoinAccessMethodRule.java A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/open-index-enforced/inverted-index-join/ngram-contains_01_ps.plan A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/btree-index-join/hints-indexnl-params/hints-indexnl-params-4.plan A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/nested-open-index/inverted-index-join/ngram-contains_02_ps.plan M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/JoinEnum.java A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/nested-open-index/inverted-index-join/ngram-contains_01_ps.plan M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/JoinNode.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/EnumerateJoinsRule.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/cost/ICostMethods.java 13 files changed, 314 insertions(+), 91 deletions(-) git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb refs/changes/96/18196/14 -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 14 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-MessageType: newpatchset
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
Attention is currently required from: Vijay Sarathy. Anon. E. Moose #1000171 has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 ) Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. Patch Set 13: Contrib-2 Analytics Compatibility Compilation Failed https://cbjenkins.page.link/ymSpdrXR7TmJbYAJ6 : UNSTABLE -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 13 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-Comment-Date: Fri, 10 May 2024 01:00:45 + Gerrit-HasComments: No Gerrit-Has-Labels: Yes Gerrit-MessageType: comment
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
>From Vijay Sarathy : Attention is currently required from: Vijay Sarathy. Hello Jenkins, Anon. E. Moose #1000171, I'd like you to reexamine a change. Please visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 to look at the new patch set (#13). Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 --- M asterixdb/asterix-app/src/test/resources/runtimets/results_cbo/join/hash-join-with-redundant-variable/hash-join-with-redundant-variable.06.plan M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/PlanNode.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/cost/CostMethods.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/am/AbstractIntroduceAccessMethodRule.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/am/IntroduceJoinAccessMethodRule.java A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/open-index-enforced/inverted-index-join/ngram-contains_01_ps.plan A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/btree-index-join/hints-indexnl-params/hints-indexnl-params-4.plan A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/nested-open-index/inverted-index-join/ngram-contains_02_ps.plan M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/JoinEnum.java A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/nested-open-index/inverted-index-join/ngram-contains_01_ps.plan M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/JoinNode.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/EnumerateJoinsRule.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/cost/ICostMethods.java 13 files changed, 313 insertions(+), 91 deletions(-) git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb refs/changes/96/18196/13 -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 13 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-MessageType: newpatchset
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
Attention is currently required from: Vijay Sarathy. Anon. E. Moose #1000171 has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 ) Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. Patch Set 12: Contrib-2 Analytics Compatibility Tests Failed https://cbjenkins.page.link/fHRKNCaA56sYyoKc6 : UNSTABLE -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 12 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-Comment-Date: Thu, 09 May 2024 21:57:48 + Gerrit-HasComments: No Gerrit-Has-Labels: Yes Gerrit-MessageType: comment
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
>From Jenkins : Attention is currently required from: Vijay Sarathy. Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 ) Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. Patch Set 12: Integration-Tests+1 Integration Tests Successful https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-trigger/517/ : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 12 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-Comment-Date: Thu, 09 May 2024 20:31:32 + Gerrit-HasComments: No Gerrit-Has-Labels: Yes Gerrit-MessageType: comment
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
Attention is currently required from: Vijay Sarathy. Anon. E. Moose #1000171 has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 ) Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. Patch Set 12: Analytics Compatibility Compilation Successful https://cbjenkins.page.link/QVXSjyo7Hp1kYerDA : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 12 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-Comment-Date: Thu, 09 May 2024 18:49:05 + Gerrit-HasComments: No Gerrit-Has-Labels: No Gerrit-MessageType: comment
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
Attention is currently required from: Vijay Sarathy. Anon. E. Moose #1000171 has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 ) Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. Patch Set 11: Contrib+1 Analytics Compatibility Tests Successful https://cbjenkins.page.link/7oaUXZuJPQLFQygh9 : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 11 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-Comment-Date: Wed, 08 May 2024 23:37:24 + Gerrit-HasComments: No Gerrit-Has-Labels: Yes Gerrit-MessageType: comment
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
>From Jenkins : Attention is currently required from: Vijay Sarathy. Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 ) Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. Patch Set 11: Integration-Tests-1 Integration Tests Failed https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-trigger/504/ : UNSTABLE -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 11 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-Comment-Date: Wed, 08 May 2024 22:27:35 + Gerrit-HasComments: No Gerrit-Has-Labels: Yes Gerrit-MessageType: comment
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
Attention is currently required from: Vijay Sarathy. Anon. E. Moose #1000171 has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 ) Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. Patch Set 11: Analytics Compatibility Compilation Successful https://cbjenkins.page.link/cvL62KVQiAnAZ6pBA : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 11 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-Comment-Date: Wed, 08 May 2024 21:29:42 + Gerrit-HasComments: No Gerrit-Has-Labels: No Gerrit-MessageType: comment
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
>From Vijay Sarathy : Attention is currently required from: Vijay Sarathy. Hello Jenkins, Anon. E. Moose #1000171, I'd like you to reexamine a change. Please visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 to look at the new patch set (#11). Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 --- M asterixdb/asterix-app/src/test/resources/runtimets/results_cbo/join/hash-join-with-redundant-variable/hash-join-with-redundant-variable.06.plan M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/PlanNode.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/am/AbstractIntroduceAccessMethodRule.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/am/IntroduceJoinAccessMethodRule.java A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/open-index-enforced/inverted-index-join/ngram-contains_01_ps.plan A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/btree-index-join/hints-indexnl-params/hints-indexnl-params-4.plan A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/nested-open-index/inverted-index-join/ngram-contains_02_ps.plan M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/JoinEnum.java A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/nested-open-index/inverted-index-join/ngram-contains_01_ps.plan M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/JoinNode.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/EnumerateJoinsRule.java 11 files changed, 311 insertions(+), 89 deletions(-) git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb refs/changes/96/18196/11 -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 11 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-MessageType: newpatchset
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
>From Jenkins : Attention is currently required from: Vijay Sarathy. Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 ) Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. Patch Set 10: Integration-Tests+1 Integration Tests Successful https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-trigger/423/ : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 10 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-Comment-Date: Wed, 01 May 2024 00:44:46 + Gerrit-HasComments: No Gerrit-Has-Labels: Yes Gerrit-MessageType: comment
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
Attention is currently required from: Vijay Sarathy. Anon. E. Moose #1000171 has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 ) Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. Patch Set 10: Contrib+1 Analytics Compatibility Tests Successful https://cbjenkins.page.link/9n3AGUsutpkKYox86 : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 10 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-Comment-Date: Tue, 30 Apr 2024 21:59:22 + Gerrit-HasComments: No Gerrit-Has-Labels: Yes Gerrit-MessageType: comment
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
Attention is currently required from: Vijay Sarathy. Anon. E. Moose #1000171 has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 ) Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. Patch Set 10: Analytics Compatibility Compilation Successful https://cbjenkins.page.link/LP3cYFc7uy2DrkTx8 : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 10 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-Comment-Date: Tue, 30 Apr 2024 19:52:54 + Gerrit-HasComments: No Gerrit-Has-Labels: No Gerrit-MessageType: comment
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
>From Vijay Sarathy : Attention is currently required from: Vijay Sarathy. Hello Jenkins, Anon. E. Moose #1000171, I'd like you to reexamine a change. Please visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 to look at the new patch set (#10). Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 --- M asterixdb/asterix-app/src/test/resources/runtimets/results_cbo/join/hash-join-with-redundant-variable/hash-join-with-redundant-variable.06.plan A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/open-index-enforced/inverted-index-join/ngram-contains_01_ps.plan A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/btree-index-join/hints-indexnl-params/hints-indexnl-params-4.plan A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/nested-open-index/inverted-index-join/ngram-contains_02_ps.plan M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/JoinEnum.java A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/nested-open-index/inverted-index-join/ngram-contains_01_ps.plan M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/JoinNode.java 7 files changed, 235 insertions(+), 65 deletions(-) git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb refs/changes/96/18196/10 -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 10 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-MessageType: newpatchset
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
>From Vijay Sarathy : Attention is currently required from: Vijay Sarathy. Hello Jenkins, Anon. E. Moose #1000171, I'd like you to reexamine a change. Please visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 to look at the new patch set (#9). Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates. .. [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates. Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 --- M asterixdb/asterix-app/src/test/resources/runtimets/results_cbo/join/hash-join-with-redundant-variable/hash-join-with-redundant-variable.06.plan A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/open-index-enforced/inverted-index-join/ngram-contains_01_ps.plan A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/btree-index-join/hints-indexnl-params/hints-indexnl-params-4.plan A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/nested-open-index/inverted-index-join/ngram-contains_02_ps.plan M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/JoinEnum.java A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/nested-open-index/inverted-index-join/ngram-contains_01_ps.plan M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/JoinNode.java 7 files changed, 237 insertions(+), 65 deletions(-) git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb refs/changes/96/18196/9 -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 9 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-MessageType: newpatchset
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
>From Vijay Sarathy : Attention is currently required from: Vijay Sarathy. Vijay Sarathy has removed a vote from this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 ) Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. Removed Verified+1 by Jenkins -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 8 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-MessageType: deleteVote
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
Attention is currently required from: Vijay Sarathy. Anon. E. Moose #1000171 has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 ) Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. Patch Set 8: Contrib+1 Analytics Compatibility Tests Successful https://cbjenkins.page.link/yqEziQojityAx2V76 : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 8 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-Comment-Date: Tue, 30 Apr 2024 17:14:36 + Gerrit-HasComments: No Gerrit-Has-Labels: Yes Gerrit-MessageType: comment
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
>From Jenkins : Attention is currently required from: Vijay Sarathy. Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 ) Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. Patch Set 8: Integration-Tests+1 Integration Tests Successful https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-trigger/416/ : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 8 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-Comment-Date: Tue, 30 Apr 2024 15:40:18 + Gerrit-HasComments: No Gerrit-Has-Labels: Yes Gerrit-MessageType: comment
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
Attention is currently required from: Vijay Sarathy. Anon. E. Moose #1000171 has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 ) Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. Patch Set 8: Analytics Compatibility Compilation Successful https://cbjenkins.page.link/3EvrKutXaCjAtCiB7 : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 8 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-Comment-Date: Tue, 30 Apr 2024 15:05:47 + Gerrit-HasComments: No Gerrit-Has-Labels: No Gerrit-MessageType: comment
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
>From Vijay Sarathy : Attention is currently required from: Vijay Sarathy. Hello Jenkins, Anon. E. Moose #1000171, I'd like you to reexamine a change. Please visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 to look at the new patch set (#8). Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 --- M asterixdb/asterix-app/src/test/resources/runtimets/results_cbo/join/hash-join-with-redundant-variable/hash-join-with-redundant-variable.06.plan A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/open-index-enforced/inverted-index-join/ngram-contains_01_ps.plan A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/btree-index-join/hints-indexnl-params/hints-indexnl-params-4.plan A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/nested-open-index/inverted-index-join/ngram-contains_02_ps.plan M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/JoinEnum.java A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/nested-open-index/inverted-index-join/ngram-contains_01_ps.plan M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/JoinNode.java 7 files changed, 237 insertions(+), 65 deletions(-) git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb refs/changes/96/18196/8 -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 8 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-MessageType: newpatchset
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
>From Jenkins : Attention is currently required from: Vijay Sarathy. Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 ) Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. Patch Set 7: Integration-Tests+1 Integration Tests Successful https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-trigger/410/ : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 7 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-Comment-Date: Tue, 30 Apr 2024 03:06:11 + Gerrit-HasComments: No Gerrit-Has-Labels: Yes Gerrit-MessageType: comment
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
Attention is currently required from: Vijay Sarathy. Anon. E. Moose #1000171 has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 ) Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. Patch Set 7: Contrib+1 Analytics Compatibility Tests Successful https://cbjenkins.page.link/Cz81NaKf6DmXWfHM8 : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 7 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-Comment-Date: Tue, 30 Apr 2024 02:32:23 + Gerrit-HasComments: No Gerrit-Has-Labels: Yes Gerrit-MessageType: comment
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
Attention is currently required from: Vijay Sarathy. Anon. E. Moose #1000171 has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 ) Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. Patch Set 7: Analytics Compatibility Compilation Successful https://cbjenkins.page.link/X5pvaPZQNzengYuZ6 : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 7 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-Comment-Date: Tue, 30 Apr 2024 00:22:29 + Gerrit-HasComments: No Gerrit-Has-Labels: No Gerrit-MessageType: comment
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
>From Vijay Sarathy : Attention is currently required from: Vijay Sarathy. Hello Jenkins, Anon. E. Moose #1000171, I'd like you to reexamine a change. Please visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 to look at the new patch set (#7). Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 --- M asterixdb/asterix-app/src/test/resources/runtimets/results_cbo/join/hash-join-with-redundant-variable/hash-join-with-redundant-variable.06.plan A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/open-index-enforced/inverted-index-join/ngram-contains_01_ps.plan A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/btree-index-join/hints-indexnl-params/hints-indexnl-params-4.plan A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/nested-open-index/inverted-index-join/ngram-contains_02_ps.plan M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/JoinEnum.java A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/nested-open-index/inverted-index-join/ngram-contains_01_ps.plan M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/JoinNode.java 7 files changed, 229 insertions(+), 60 deletions(-) git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb refs/changes/96/18196/7 -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 7 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-MessageType: newpatchset
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
>From Jenkins : Attention is currently required from: Vijay Sarathy. Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 ) Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. Patch Set 6: Integration-Tests+1 Integration Tests Successful https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-trigger/404/ : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 6 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-Comment-Date: Mon, 29 Apr 2024 21:50:30 + Gerrit-HasComments: No Gerrit-Has-Labels: Yes Gerrit-MessageType: comment
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
Attention is currently required from: Vijay Sarathy. Anon. E. Moose #1000171 has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 ) Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. Patch Set 6: Analytics Compatibility Compilation Successful https://cbjenkins.page.link/4UG2655HMUMGwir86 : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 6 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-Comment-Date: Mon, 29 Apr 2024 20:12:23 + Gerrit-HasComments: No Gerrit-Has-Labels: No Gerrit-MessageType: comment
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
>From Vijay Sarathy : Attention is currently required from: Vijay Sarathy. Hello Jenkins, Anon. E. Moose #1000171, I'd like you to reexamine a change. Please visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 to look at the new patch set (#6). Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 --- A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/btree-index-join/hints-indexnl-params/hints-indexnl-params-4.plan M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/JoinEnum.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/JoinNode.java 3 files changed, 68 insertions(+), 19 deletions(-) git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb refs/changes/96/18196/6 -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 6 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-MessageType: newpatchset
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
>From Vijay Sarathy : Attention is currently required from: Vijay Sarathy. Hello Jenkins, Anon. E. Moose #1000171, I'd like you to reexamine a change. Please visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 to look at the new patch set (#4). Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates. Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 .. [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates. Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 --- A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/btree-index-join/hints-indexnl-params/hints-indexnl-params-4.plan M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/JoinEnum.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/JoinNode.java 3 files changed, 68 insertions(+), 19 deletions(-) git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb refs/changes/96/18196/4 -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 4 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-MessageType: newpatchset
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
>From Vijay Sarathy : Attention is currently required from: Vijay Sarathy. Hello Jenkins, Anon. E. Moose #1000171, I'd like you to reexamine a change. Please visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 to look at the new patch set (#5). Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates. .. [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates. Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 --- A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/btree-index-join/hints-indexnl-params/hints-indexnl-params-4.plan M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/JoinEnum.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/JoinNode.java 3 files changed, 69 insertions(+), 19 deletions(-) git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb refs/changes/96/18196/5 -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 5 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-MessageType: newpatchset
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
>From Vijay Sarathy : Attention is currently required from: Vijay Sarathy. Hello Jenkins, Anon. E. Moose #1000171, I'd like you to reexamine a change. Please visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 to look at the new patch set (#3). Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 --- A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/btree-index-join/hints-indexnl-params/hints-indexnl-params-4.plan M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/JoinEnum.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/JoinNode.java 3 files changed, 69 insertions(+), 19 deletions(-) git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb refs/changes/96/18196/3 -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 3 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-MessageType: newpatchset
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
>From Vijay Sarathy : Attention is currently required from: Vijay Sarathy. Hello Jenkins, Anon. E. Moose #1000171, I'd like you to reexamine a change. Please visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 to look at the new patch set (#2). Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 --- A asterixdb/asterix-app/src/test/resources/optimizerts/results_cbo/btree-index-join/hints-indexnl-params/hints-indexnl-params-4.plan M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/JoinEnum.java M asterixdb/asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/cbo/JoinNode.java 3 files changed, 70 insertions(+), 20 deletions(-) git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb refs/changes/96/18196/2 -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 2 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-MessageType: newpatchset
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
Attention is currently required from: Vijay Sarathy. Anon. E. Moose #1000171 has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 ) Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. Patch Set 1: Contrib+1 Analytics Compatibility Tests Successful https://cbjenkins.page.link/mJbzPKHX85coGVfp7 : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 1 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-Attention: Vijay Sarathy Gerrit-Comment-Date: Sat, 09 Mar 2024 03:08:17 + Gerrit-HasComments: No Gerrit-Has-Labels: Yes Gerrit-MessageType: comment
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
>From Jenkins : Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 ) Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. Patch Set 1: Integration-Tests+1 Integration Tests Successful https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-trigger/205/ : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 1 Gerrit-Owner: Vijay Sarathy Gerrit-Reviewer: Jenkins Gerrit-CC: Anon. E. Moose #1000171 Gerrit-Comment-Date: Sat, 09 Mar 2024 01:45:11 + Gerrit-HasComments: No Gerrit-Has-Labels: Yes Gerrit-MessageType: comment
Change in asterixdb[master]: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are m...
Anon. E. Moose #1000171 has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 ) Change subject: [ASTERIXDB-3363][COMP] CBO not choosing indexnl join when there are multiple join predicates .. Patch Set 1: Analytics Compatibility Compilation Successful https://cbjenkins.page.link/CSH6q6g5TNYpVUrC8 : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18196 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ic32b6a5d7b3c7b336d0f8aa2ee5add5d6cda59b8 Gerrit-Change-Number: 18196 Gerrit-PatchSet: 1 Gerrit-Owner: Vijay Sarathy Gerrit-CC: Anon. E. Moose #1000171 Gerrit-CC: Jenkins Gerrit-Comment-Date: Sat, 09 Mar 2024 00:36:50 + Gerrit-HasComments: No Gerrit-Has-Labels: No Gerrit-MessageType: comment
