asterixdb-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Wenhai Li (Code Review)" <do-not-re...@asterixdb.incubator.apache.org>
Subject Change in asterixdb[master]: Equivalence induced operations and the testCases The followi...
Date Fri, 11 Mar 2016 23:18:35 GMT
Hello Jenkins,

I'd like you to reexamine a change.  Please visit

    https://asterix-gerrit.ics.uci.edu/428

to look at the new patch set (#16).

Change subject: Equivalence induced operations and the testCases The following commits from
your working branch will be included: exchange optimization for lookup and delete when the
search condition is merely composed of the single primary key.
......................................................................

Equivalence induced operations and the testCases
The following commits from your working branch will be included:
exchange optimization for lookup and delete when the search condition is merely composed of
the single primary key.

commit 68704b9dd1afc477929339d1b453fbb2f548804d
Author: Michael <lwhaymail@yahoo.com>
Date:   Fri Oct 2 00:01:16 2015 -0700

    exchange optimization for lookup and delete

The following examples should INCLUDE ONLY ONE PARTITION in the constraint.

drop dataverse twitter if exists;
create dataverse twitter;
use dataverse twitter;
create type TweetMessageType as closed {
        id: string,
        message-text: string
}
create type nest as closed{
nid:string?,
nested1 : TweetMessageType,
nested2 : TweetMessageType
}
create type doublenest as closed{
nested1:nest,
nested2:nest
}
create dataset doublenests(doublenest)
primary key nested1.nested1.id, nested1.nested2.id, nested2.nested2.message-text;
create index n2n1mt on doublenests(nested2.nested1.id)

use dataverse twitter;
insert into dataset doublenests(
{
"nested2":{"nid":"mi","nested2":{"id":"ok","message-text":"hello"},"nested1":{"id":"ok","message-text":"hello"}},
"nested1":{"nested1":{"id":"ok","message-text":"hello"},"nested2":{"id":"ok","message-text":"hello"},"nid":"mi"}
});

use dataverse twitter;
insert into dataset doublenests(
{
"nested1":{"nid":"mi","nested1":{"id":"ok","message-text":"hello"},"nested2":{"id":"ok","message-text":"hello"}},
"nested2":{"nid":"mi","nested1":{"id":"ok","message-text":"hello"},"nested2":{"id":"ok","message-text":"hello"}}
});

use dataverse twitter;
delete $d from dataset doublenests
where $d.nested1.nested1.id = "ok" 
and $d.nested1.nested2.id = "ok" 
and $d.nested1.nested2.message-text = "hello" 
and $d.nested2.nested2.message-text = "hello"

use dataverse twitter;
for $d in dataset doublenests
where $d.nested1.nested1.id = "ok" 
and $d.nested1.nested2.id = "ok" 
and $d.nested1.nested2.message-text = "hello" 
and $d.nested2.nested2.message-text = "hello"
return $d

Change-Id: Iaad567eecc4c91019ecba56cca085acde34d5196
---
M asterix-algebra/src/main/java/org/apache/asterix/algebra/operators/physical/BTreeSearchPOperator.java
M asterix-algebra/src/main/java/org/apache/asterix/optimizer/base/AnalysisUtil.java
M asterix-algebra/src/main/java/org/apache/asterix/optimizer/base/RuleCollections.java
M asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/AddEquivalenceClassForRecordConstructorRule.java
A asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/PreComputePartitionIdForAtomicOperationRule.java
M asterix-algebra/src/main/java/org/apache/asterix/optimizer/rules/util/EquivalenceClassUtils.java
M asterix-app/src/test/resources/optimizerts/results/query_issue849-2.plan
M asterix-app/src/test/resources/optimizerts/results/query_issue849.plan
M asterix-metadata/src/main/java/org/apache/asterix/metadata/declared/AqlMetadataProvider.java
9 files changed, 1,436 insertions(+), 340 deletions(-)


  git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb refs/changes/28/428/16
-- 
To view, visit https://asterix-gerrit.ics.uci.edu/428
To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings

Gerrit-MessageType: newpatchset
Gerrit-Change-Id: Iaad567eecc4c91019ecba56cca085acde34d5196
Gerrit-PatchSet: 16
Gerrit-Project: asterixdb
Gerrit-Branch: master
Gerrit-Owner: Wenhai Li <lwhaymail@yahoo.com>
Gerrit-Reviewer: Ildar Absalyamov <ildar.absalyamov@gmail.com>
Gerrit-Reviewer: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
Gerrit-Reviewer: Jianfeng Jia <jianfeng.jia@gmail.com>
Gerrit-Reviewer: Steven Jacobs <sjaco002@ucr.edu>
Gerrit-Reviewer: Till Westmann <tillw@apache.org>
Gerrit-Reviewer: Wenhai Li <lwhaymail@yahoo.com>
Gerrit-Reviewer: Yingyi Bu <buyingyi@gmail.com>

Mime
View raw message