Return-Path: X-Original-To: apmail-asterixdb-commits-archive@minotaur.apache.org Delivered-To: apmail-asterixdb-commits-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id C425017B2F for ; Fri, 24 Apr 2015 18:43:03 +0000 (UTC) Received: (qmail 12064 invoked by uid 500); 24 Apr 2015 18:43:03 -0000 Delivered-To: apmail-asterixdb-commits-archive@asterixdb.apache.org Received: (qmail 12024 invoked by uid 500); 24 Apr 2015 18:43:03 -0000 Mailing-List: contact commits-help@asterixdb.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@asterixdb.incubator.apache.org Delivered-To: mailing list commits@asterixdb.incubator.apache.org Received: (qmail 12011 invoked by uid 99); 24 Apr 2015 18:43:03 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 24 Apr 2015 18:43:03 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [54.191.145.13] (HELO mx1-us-west.apache.org) (54.191.145.13) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 24 Apr 2015 18:42:58 +0000 Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx1-us-west.apache.org (ASF Mail Server at mx1-us-west.apache.org) with SMTP id 9FAE224CC2 for ; Fri, 24 Apr 2015 18:42:27 +0000 (UTC) Received: (qmail 11429 invoked by uid 99); 24 Apr 2015 18:42:27 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 24 Apr 2015 18:42:27 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 7C67EE05E3; Fri, 24 Apr 2015 18:42:27 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: imaxon@apache.org To: commits@asterixdb.incubator.apache.org Date: Fri, 24 Apr 2015 18:42:39 -0000 Message-Id: In-Reply-To: References: X-Mailer: ASF-Git Admin Mailer Subject: [13/58] [abbrv] [partial] incubator-asterixdb git commit: Added support of typed indexes over open fields & indexes over nested fields X-Virus-Checked: Checked by ClamAV on apache.org http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-edit-distance-word-tokens/inverted-index-ngram-edit-distance-word-tokens.3.ddl.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-edit-distance-word-tokens/inverted-index-ngram-edit-distance-word-tokens.3.ddl.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-edit-distance-word-tokens/inverted-index-ngram-edit-distance-word-tokens.3.ddl.aql new file mode 100644 index 0000000..0ed391f --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-edit-distance-word-tokens/inverted-index-ngram-edit-distance-word-tokens.3.ddl.aql @@ -0,0 +1,3 @@ +use dataverse test; + +create index ngram_index on DBLP(title:string) type ngram(3) enforced; http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-edit-distance-word-tokens/inverted-index-ngram-edit-distance-word-tokens.4.query.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-edit-distance-word-tokens/inverted-index-ngram-edit-distance-word-tokens.4.query.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-edit-distance-word-tokens/inverted-index-ngram-edit-distance-word-tokens.4.query.aql new file mode 100644 index 0000000..83e42a2 --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-edit-distance-word-tokens/inverted-index-ngram-edit-distance-word-tokens.4.query.aql @@ -0,0 +1,11 @@ +use dataverse test; + +for $paper in dataset('DBLP') +for $word in word-tokens($paper.title) +where edit-distance-check($word, "Multmedia", 1)[0] +distinct by $paper.id +order by $paper.id +return { + "id" : $paper.id, + "title" : $paper.title +} \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-edit-distance/inverted-index-ngram-edit-distance.1.ddl.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-edit-distance/inverted-index-ngram-edit-distance.1.ddl.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-edit-distance/inverted-index-ngram-edit-distance.1.ddl.aql new file mode 100644 index 0000000..56bcb1c --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-edit-distance/inverted-index-ngram-edit-distance.1.ddl.aql @@ -0,0 +1,25 @@ +drop dataverse test if exists; +create dataverse test; +use dataverse test; + +create type DBLPType as closed { + id: int64, + dblpid: string, + title: string, + authors: string, + misc: string +} + +create type DBLPOpenType as open { + id: int64, + dblpid: string, + title: string, + misc: string +} + +create nodegroup group1 if not exists on nc1, nc2; + +create dataset DBLP(DBLPType) + primary key id on group1; +create dataset DBLPOpen(DBLPOpenType) + primary key id on group1; http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-edit-distance/inverted-index-ngram-edit-distance.2.update.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-edit-distance/inverted-index-ngram-edit-distance.2.update.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-edit-distance/inverted-index-ngram-edit-distance.2.update.aql new file mode 100644 index 0000000..41ae803 --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-edit-distance/inverted-index-ngram-edit-distance.2.update.aql @@ -0,0 +1,22 @@ +use dataverse test; + +load dataset DBLP +using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter" +(("path"="nc1://data/dblp-small/dblp-small-id.txt"),("format"="delimited-text"),("delimiter"=":")) pre-sorted; + +insert into dataset test.DBLPOpen ( + for $x in dataset test.DBLP + where $x.id <= 50 + return $x +); + +insert into dataset test.DBLPOpen ( + for $c in dataset test.DBLP + where $c.id > 50 + return { + "id": $c.id, + "dblpid": $c.dblpid, + "title": $c.title, + "misc": $c.misc + } +); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-edit-distance/inverted-index-ngram-edit-distance.3.ddl.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-edit-distance/inverted-index-ngram-edit-distance.3.ddl.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-edit-distance/inverted-index-ngram-edit-distance.3.ddl.aql new file mode 100644 index 0000000..88f3d5c --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-edit-distance/inverted-index-ngram-edit-distance.3.ddl.aql @@ -0,0 +1,4 @@ + +use dataverse test; + +create index ngram_index on DBLPOpen(authors:string) type ngram(3) enforced; http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-edit-distance/inverted-index-ngram-edit-distance.4.query.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-edit-distance/inverted-index-ngram-edit-distance.4.query.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-edit-distance/inverted-index-ngram-edit-distance.4.query.aql new file mode 100644 index 0000000..6ff7db8 --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-edit-distance/inverted-index-ngram-edit-distance.4.query.aql @@ -0,0 +1,12 @@ +use dataverse test; + +for $o in dataset('DBLPOpen') +let $ed := edit-distance-check($o.authors, "Amihay Motro", 1) +where $ed[0] +return { + "id": $o.id, + "dblpid": $o.dblpid, + "title": $o.title, + "authors": $o.authors, + "misc": $o.misc +} http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-jaccard/inverted-index-ngram-jaccard.1.ddl.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-jaccard/inverted-index-ngram-jaccard.1.ddl.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-jaccard/inverted-index-ngram-jaccard.1.ddl.aql new file mode 100644 index 0000000..9a49a35 --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-jaccard/inverted-index-ngram-jaccard.1.ddl.aql @@ -0,0 +1,27 @@ +drop dataverse test if exists; +create dataverse test; +use dataverse test; + +create type DBLPType as closed { + id: int64, + dblpid: string, + title: string, + authors: string, + misc: string +} + +create type DBLPOpenType as open { + id: int64, + dblpid: string, + authors: string, + misc: string +} + +create nodegroup group1 if not exists on nc1, nc2; + +create dataset DBLP(DBLPType) + primary key id on group1; + +create dataset DBLPOpen(DBLPOpenType) + primary key id on group1; + http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-jaccard/inverted-index-ngram-jaccard.2.update.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-jaccard/inverted-index-ngram-jaccard.2.update.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-jaccard/inverted-index-ngram-jaccard.2.update.aql new file mode 100644 index 0000000..64912ab --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-jaccard/inverted-index-ngram-jaccard.2.update.aql @@ -0,0 +1,22 @@ +use dataverse test; + +load dataset DBLP +using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter" +(("path"="nc1://data/dblp-small/dblp-small-id.txt"),("format"="delimited-text"),("delimiter"=":")) pre-sorted; + +insert into dataset test.DBLPOpen ( + for $x in dataset test.DBLP + where $x.id <= 50 + return $x +); + +insert into dataset test.DBLPOpen ( + for $c in dataset test.DBLP + where $c.id > 50 + return { + "id": $c.id, + "dblpid": $c.dblpid, + "authors": $c.authors, + "misc": $c.misc + } +); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-jaccard/inverted-index-ngram-jaccard.3.ddl.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-jaccard/inverted-index-ngram-jaccard.3.ddl.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-jaccard/inverted-index-ngram-jaccard.3.ddl.aql new file mode 100644 index 0000000..7fcca38 --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-jaccard/inverted-index-ngram-jaccard.3.ddl.aql @@ -0,0 +1,3 @@ +use dataverse test; + +create index ngram_index on DBLPOpen(title:string) type ngram(3) enforced; http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-jaccard/inverted-index-ngram-jaccard.4.query.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-jaccard/inverted-index-ngram-jaccard.4.query.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-jaccard/inverted-index-ngram-jaccard.4.query.aql new file mode 100644 index 0000000..ee51975 --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-ngram-jaccard/inverted-index-ngram-jaccard.4.query.aql @@ -0,0 +1,13 @@ +use dataverse test; +set import-private-functions 'true'; + +for $o in dataset('DBLPOpen') +let $jacc := similarity-jaccard-check(gram-tokens($o.title, 3, false), gram-tokens("Transactions for Cooperative Environments", 3, false), 0.5f) +where $jacc[0] +return { + "id": $o.id, + "dblpid": $o.dblpid, + "title": $o.title, + "authors": $o.authors, + "misc": $o.misc +} http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-contains/inverted-index-word-contains.1.ddl.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-contains/inverted-index-word-contains.1.ddl.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-contains/inverted-index-word-contains.1.ddl.aql new file mode 100644 index 0000000..0706e25 --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-contains/inverted-index-word-contains.1.ddl.aql @@ -0,0 +1,26 @@ +drop dataverse test if exists; +create dataverse test; +use dataverse test; + +create type DBLPType as closed { + id: int64, + dblpid: string, + title: string, + authors: string, + misc: string +} + +create type DBLPOpenType as open { + id: int64, + dblpid: string, + authors: string, + misc: string +} + +create nodegroup group1 if not exists on nc1, nc2; + +create dataset DBLP(DBLPType) + primary key id on group1; + +create dataset DBLPOpen(DBLPOpenType) + primary key id on group1; http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-contains/inverted-index-word-contains.2.update.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-contains/inverted-index-word-contains.2.update.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-contains/inverted-index-word-contains.2.update.aql new file mode 100644 index 0000000..64912ab --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-contains/inverted-index-word-contains.2.update.aql @@ -0,0 +1,22 @@ +use dataverse test; + +load dataset DBLP +using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter" +(("path"="nc1://data/dblp-small/dblp-small-id.txt"),("format"="delimited-text"),("delimiter"=":")) pre-sorted; + +insert into dataset test.DBLPOpen ( + for $x in dataset test.DBLP + where $x.id <= 50 + return $x +); + +insert into dataset test.DBLPOpen ( + for $c in dataset test.DBLP + where $c.id > 50 + return { + "id": $c.id, + "dblpid": $c.dblpid, + "authors": $c.authors, + "misc": $c.misc + } +); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-contains/inverted-index-word-contains.3.ddl.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-contains/inverted-index-word-contains.3.ddl.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-contains/inverted-index-word-contains.3.ddl.aql new file mode 100644 index 0000000..ad750e1 --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-contains/inverted-index-word-contains.3.ddl.aql @@ -0,0 +1,4 @@ +use dataverse test; + +create index keyword_index on DBLPOpen(title:string) type keyword enforced; + http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-contains/inverted-index-word-contains.4.query.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-contains/inverted-index-word-contains.4.query.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-contains/inverted-index-word-contains.4.query.aql new file mode 100644 index 0000000..094538e --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-contains/inverted-index-word-contains.4.query.aql @@ -0,0 +1,12 @@ +use dataverse test; + +for $o in dataset('DBLPOpen') +where contains($o.title, "Multimedia") +order by $o.id +return { + "id": $o.id, + "dblpid": $o.dblpid, + "title": $o.title, + "authors": $o.authors, + "misc": $o.misc +} http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-jaccard/inverted-index-word-jaccard.1.ddl.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-jaccard/inverted-index-word-jaccard.1.ddl.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-jaccard/inverted-index-word-jaccard.1.ddl.aql new file mode 100644 index 0000000..ad95c84 --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-jaccard/inverted-index-word-jaccard.1.ddl.aql @@ -0,0 +1,26 @@ +drop dataverse test if exists; +create dataverse test; +use dataverse test; + +create type DBLPType as closed { + id: int64, + dblpid: string, + title: string, + authors: string, + misc: string +} + +create type DBLPOpenType as open { + id: int64, + dblpid: string, + authors: string, + misc: string +} + +create nodegroup group1 if not exists on nc1, nc2; + +create dataset DBLP(DBLPType) + primary key id on group1; + +create dataset DBLPOpen(DBLPOpenType) + primary key id on group1; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-jaccard/inverted-index-word-jaccard.2.update.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-jaccard/inverted-index-word-jaccard.2.update.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-jaccard/inverted-index-word-jaccard.2.update.aql new file mode 100644 index 0000000..64912ab --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-jaccard/inverted-index-word-jaccard.2.update.aql @@ -0,0 +1,22 @@ +use dataverse test; + +load dataset DBLP +using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter" +(("path"="nc1://data/dblp-small/dblp-small-id.txt"),("format"="delimited-text"),("delimiter"=":")) pre-sorted; + +insert into dataset test.DBLPOpen ( + for $x in dataset test.DBLP + where $x.id <= 50 + return $x +); + +insert into dataset test.DBLPOpen ( + for $c in dataset test.DBLP + where $c.id > 50 + return { + "id": $c.id, + "dblpid": $c.dblpid, + "authors": $c.authors, + "misc": $c.misc + } +); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-jaccard/inverted-index-word-jaccard.3.ddl.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-jaccard/inverted-index-word-jaccard.3.ddl.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-jaccard/inverted-index-word-jaccard.3.ddl.aql new file mode 100644 index 0000000..a5b66d3 --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-jaccard/inverted-index-word-jaccard.3.ddl.aql @@ -0,0 +1,3 @@ +use dataverse test; + +create index keyword_index on DBLPOpen(title:string) type keyword enforced; http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-jaccard/inverted-index-word-jaccard.4.query.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-jaccard/inverted-index-word-jaccard.4.query.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-jaccard/inverted-index-word-jaccard.4.query.aql new file mode 100644 index 0000000..dbc14c6 --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/inverted-index-word-jaccard/inverted-index-word-jaccard.4.query.aql @@ -0,0 +1,13 @@ +use dataverse test; + +for $o in dataset('DBLPOpen') +let $jacc := similarity-jaccard-check(word-tokens($o.title), word-tokens("Transactions for Cooperative Environments"), 0.5f) +where $jacc[0] +return { + "id": $o.id, + "dblpid": $o.dblpid, + "title": $o.title, + "authors": $o.authors, + "misc": $o.misc +} + http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey-conjunctive/orders-index-custkey-conjunctive.1.ddl.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey-conjunctive/orders-index-custkey-conjunctive.1.ddl.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey-conjunctive/orders-index-custkey-conjunctive.1.ddl.aql new file mode 100644 index 0000000..6b20ba7 --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey-conjunctive/orders-index-custkey-conjunctive.1.ddl.aql @@ -0,0 +1,32 @@ +drop dataverse tpch if exists; +create dataverse tpch; +use dataverse tpch; + +create type OrderType as closed { + o_orderkey: int64, + o_custkey: int64, + o_orderstatus: string, + o_totalprice: double, + o_orderdate: string, + o_orderpriority: string, + o_clerk: string, + o_shippriority: int64, + o_comment: string +} + +create type OrderOpenType as open { + o_orderkey: int64, + o_orderstatus: string, + o_totalprice: double, + o_orderdate: string, + o_orderpriority: string, + o_clerk: string, + o_shippriority: int64, + o_comment: string +} + +create dataset Orders(OrderType) + primary key o_orderkey; + +create dataset OrdersOpen(OrderOpenType) + primary key o_orderkey; http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey-conjunctive/orders-index-custkey-conjunctive.2.update.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey-conjunctive/orders-index-custkey-conjunctive.2.update.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey-conjunctive/orders-index-custkey-conjunctive.2.update.aql new file mode 100644 index 0000000..28f3f09 --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey-conjunctive/orders-index-custkey-conjunctive.2.update.aql @@ -0,0 +1,10 @@ +use dataverse tpch; + +load dataset Orders +using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter" +(("path"="nc1://data/tpch0.001/orders.tbl"),("format"="delimited-text"),("delimiter"="|")) pre-sorted; + +insert into dataset OrdersOpen ( + for $x in dataset Orders + return $x +); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey-conjunctive/orders-index-custkey-conjunctive.3.ddl.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey-conjunctive/orders-index-custkey-conjunctive.3.ddl.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey-conjunctive/orders-index-custkey-conjunctive.3.ddl.aql new file mode 100644 index 0000000..1ef65fb --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey-conjunctive/orders-index-custkey-conjunctive.3.ddl.aql @@ -0,0 +1,3 @@ +use dataverse tpch; + +create index idx_Orders_Custkey on OrdersOpen(o_custkey:int32) enforced; http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey-conjunctive/orders-index-custkey-conjunctive.4.query.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey-conjunctive/orders-index-custkey-conjunctive.4.query.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey-conjunctive/orders-index-custkey-conjunctive.4.query.aql new file mode 100644 index 0000000..12dc40f --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey-conjunctive/orders-index-custkey-conjunctive.4.query.aql @@ -0,0 +1,10 @@ +use dataverse tpch; + +for $o in dataset('OrdersOpen') +where + $o.o_custkey = 40 and $o.o_totalprice > 150000.0 +order by $o.o_orderkey +return { + "o_orderkey": $o.o_orderkey, + "o_custkey": $o.o_custkey +} http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey/orders-index-custkey.1.ddl.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey/orders-index-custkey.1.ddl.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey/orders-index-custkey.1.ddl.aql new file mode 100644 index 0000000..6b20ba7 --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey/orders-index-custkey.1.ddl.aql @@ -0,0 +1,32 @@ +drop dataverse tpch if exists; +create dataverse tpch; +use dataverse tpch; + +create type OrderType as closed { + o_orderkey: int64, + o_custkey: int64, + o_orderstatus: string, + o_totalprice: double, + o_orderdate: string, + o_orderpriority: string, + o_clerk: string, + o_shippriority: int64, + o_comment: string +} + +create type OrderOpenType as open { + o_orderkey: int64, + o_orderstatus: string, + o_totalprice: double, + o_orderdate: string, + o_orderpriority: string, + o_clerk: string, + o_shippriority: int64, + o_comment: string +} + +create dataset Orders(OrderType) + primary key o_orderkey; + +create dataset OrdersOpen(OrderOpenType) + primary key o_orderkey; http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey/orders-index-custkey.2.update.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey/orders-index-custkey.2.update.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey/orders-index-custkey.2.update.aql new file mode 100644 index 0000000..28f3f09 --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey/orders-index-custkey.2.update.aql @@ -0,0 +1,10 @@ +use dataverse tpch; + +load dataset Orders +using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter" +(("path"="nc1://data/tpch0.001/orders.tbl"),("format"="delimited-text"),("delimiter"="|")) pre-sorted; + +insert into dataset OrdersOpen ( + for $x in dataset Orders + return $x +); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey/orders-index-custkey.3.ddl.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey/orders-index-custkey.3.ddl.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey/orders-index-custkey.3.ddl.aql new file mode 100644 index 0000000..1ef65fb --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey/orders-index-custkey.3.ddl.aql @@ -0,0 +1,3 @@ +use dataverse tpch; + +create index idx_Orders_Custkey on OrdersOpen(o_custkey:int32) enforced; http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey/orders-index-custkey.4.query.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey/orders-index-custkey.4.query.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey/orders-index-custkey.4.query.aql new file mode 100644 index 0000000..a837a13 --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/orders-index-custkey/orders-index-custkey.4.query.aql @@ -0,0 +1,10 @@ +use dataverse tpch; + +for $o in dataset('OrdersOpen') +where + $o.o_custkey = 40 +order by $o.o_orderkey +return { + "o_orderkey": $o.o_orderkey, + "o_custkey": $o.o_custkey +} http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/range-search/range-search.1.ddl.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/range-search/range-search.1.ddl.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/range-search/range-search.1.ddl.aql new file mode 100644 index 0000000..7f52d91 --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/range-search/range-search.1.ddl.aql @@ -0,0 +1,48 @@ +drop dataverse test if exists; + +create dataverse test; +use dataverse test; + +create type LineItemType as closed { + l_orderkey: int64, + l_partkey: int64, + l_suppkey: int64, + l_linenumber: int64, + l_quantity: double, + l_extendedprice: double, + l_discount: double, + l_tax: double, + l_returnflag: string, + l_linestatus: string, + l_shipdate: string, + l_commitdate: string, + l_receiptdate: string, + l_shipinstruct: string, + l_shipmode: string, + l_comment: string +} + +create type LineItemOpenType as open { + l_orderkey: int64, + l_partkey: int64, + l_linenumber: int64, + l_quantity: double, + l_extendedprice: double, + l_discount: double, + l_tax: double, + l_returnflag: string, + l_linestatus: string, + l_shipdate: string, + l_commitdate: string, + l_receiptdate: string, + l_shipinstruct: string, + l_shipmode: string, + l_comment: string +} + +create dataset LineItem(LineItemType) + primary key l_orderkey, l_linenumber; + +create dataset LineItemOpen(LineItemOpenType) + primary key l_orderkey, l_linenumber; + http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/range-search/range-search.2.update.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/range-search/range-search.2.update.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/range-search/range-search.2.update.aql new file mode 100644 index 0000000..e01878d --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/range-search/range-search.2.update.aql @@ -0,0 +1,33 @@ +use dataverse test; + +load dataset LineItem +using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter" +(("path"="nc1://data/tpch0.001/lineitem.tbl"),("format"="delimited-text"),("delimiter"="|")) pre-sorted; + +insert into dataset test.LineItemOpen ( + for $x in dataset test.LineItem + where $x.l_orderkey < 3000 + return $x +); + +insert into dataset test.LineItemOpen ( + for $x in dataset test.LineItem + where $x.l_orderkey >= 3000 + return { + "l_orderkey": $x.l_orderkey, + "l_partkey": $x.l_partkey, + "l_linenumber": $x.l_linenumber, + "l_quantity": $x.l_quantity, + "l_extendedprice": $x.l_extendedprice, + "l_discount": $x.l_discount, + "l_tax": $x.l_tax, + "l_returnflag": $x.l_returnflag, + "l_linestatus": $x.l_linestatus, + "l_shipdate": $x.l_shipdate, + "l_commitdate": $x.l_commitdate, + "l_receiptdate": $x.l_receiptdate, + "l_shipinstruct": $x.l_shipinstruct, + "l_shipmode": $x.l_shipmode, + "l_comment": $x.l_comment + } +); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/range-search/range-search.3.ddl.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/range-search/range-search.3.ddl.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/range-search/range-search.3.ddl.aql new file mode 100644 index 0000000..98bd7cb --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/range-search/range-search.3.ddl.aql @@ -0,0 +1,3 @@ +use dataverse test; + +create index idx_LineItem_suppkey on LineItemOpen(l_suppkey:int32) enforced; http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/range-search/range-search.4.query.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/range-search/range-search.4.query.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/range-search/range-search.4.query.aql new file mode 100644 index 0000000..fd026e8 --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/range-search/range-search.4.query.aql @@ -0,0 +1,6 @@ +use dataverse test; + +for $c in dataset('LineItemOpen') +where $c.l_suppkey < 100 and $c.l_suppkey>5 +order by $c.l_orderkey, $c.l_linenumber +return $c http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/rtree-secondary-index/rtree-secondary-index.1.ddl.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/rtree-secondary-index/rtree-secondary-index.1.ddl.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/rtree-secondary-index/rtree-secondary-index.1.ddl.aql new file mode 100644 index 0000000..7ea3209 --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/rtree-secondary-index/rtree-secondary-index.1.ddl.aql @@ -0,0 +1,31 @@ +drop dataverse test if exists; +create dataverse test; +use dataverse test; + +create type MyRecord as closed { + id: int64, + point: point, + kwds: string, + line1: line, + line2: line, + poly1: polygon, + poly2: polygon, + rec: rectangle, + circle: circle +} + +create type MyRecordOpen as open { + id: int64, + kwds: string, + line1: line, + line2: line, + poly1: polygon, + poly2: polygon, + rec: rectangle, + circle: circle +} + +create dataset MyData(MyRecord) + primary key id; +create dataset MyDataOpen(MyRecordOpen) + primary key id; http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/rtree-secondary-index/rtree-secondary-index.2.update.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/rtree-secondary-index/rtree-secondary-index.2.update.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/rtree-secondary-index/rtree-secondary-index.2.update.aql new file mode 100644 index 0000000..e32d537 --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/rtree-secondary-index/rtree-secondary-index.2.update.aql @@ -0,0 +1,28 @@ +use dataverse test; + +load dataset MyData +using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter" +(("path"="nc1://data/spatial/spatialData.json"),("format"="adm")); + +insert into dataset MyDataOpen +( + for $c in dataset('MyData') + where $c.id < 15 + return $c +); + +insert into dataset MyDataOpen +( + for $c in dataset('MyData') + where $c.id >= 15 + return { + "id": $c.id, + "kwds": $c.kwds, + "line1": $c.line1, + "line2": $c.line2, + "poly1": $c.poly1, + "poly2": $c.poly2, + "rec": $c.rec, + "circle": $c.circle + } +); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/rtree-secondary-index/rtree-secondary-index.3.ddl.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/rtree-secondary-index/rtree-secondary-index.3.ddl.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/rtree-secondary-index/rtree-secondary-index.3.ddl.aql new file mode 100644 index 0000000..4c63e91 --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/rtree-secondary-index/rtree-secondary-index.3.ddl.aql @@ -0,0 +1,3 @@ +use dataverse test; + +create index rtree_index_point on MyDataOpen(point: point) type rtree enforced; http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/rtree-secondary-index/rtree-secondary-index.4.query.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/rtree-secondary-index/rtree-secondary-index.4.query.aql b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/rtree-secondary-index/rtree-secondary-index.4.query.aql new file mode 100644 index 0000000..0f02e54 --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/open-index-enforced/index-selection/rtree-secondary-index/rtree-secondary-index.4.query.aql @@ -0,0 +1,6 @@ +use dataverse test; + +for $o in dataset('MyDataOpen') +where spatial-intersect($o.point, create-polygon([4.0,1.0,4.0,4.0,12.0,4.0,12.0,1.0])) +order by $o.id +return {"id":$o.id} http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/spatial/create-rtree-index/create-rtree-index.1.ddl.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/spatial/create-rtree-index/create-rtree-index.1.ddl.aql b/asterix-app/src/test/resources/runtimets/queries/spatial/create-rtree-index/create-rtree-index.1.ddl.aql index 21f6f00..9e876c4 100644 --- a/asterix-app/src/test/resources/runtimets/queries/spatial/create-rtree-index/create-rtree-index.1.ddl.aql +++ b/asterix-app/src/test/resources/runtimets/queries/spatial/create-rtree-index/create-rtree-index.1.ddl.aql @@ -18,8 +18,9 @@ create type SpatialType as open { create dataset MyData(SpatialType) primary key id; create index rtree_index1 on MyData(point) type rtree; +/* create index rtree_index2 on MyData(line1) type rtree; create index rtree_index3 on MyData(poly1) type rtree; create index rtree_index5 on MyData(rec) type rtree; create index rtree_index4 on MyData(circle) type rtree; - +*/ http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/types/type_promotion_open_index_enforced/type_promotion_open_index_enforced.1.ddl.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/types/type_promotion_open_index_enforced/type_promotion_open_index_enforced.1.ddl.aql b/asterix-app/src/test/resources/runtimets/queries/types/type_promotion_open_index_enforced/type_promotion_open_index_enforced.1.ddl.aql new file mode 100644 index 0000000..4165f37 --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/types/type_promotion_open_index_enforced/type_promotion_open_index_enforced.1.ddl.aql @@ -0,0 +1,11 @@ +drop dataverse TestDataverse if exists; +create dataverse TestDataverse; +use dataverse TestDataverse; + +create type TestType as { + id: int64, + sec_id: int64 +} + +create dataset TestSet(TestType) +primary key id; http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/types/type_promotion_open_index_enforced/type_promotion_open_index_enforced.2.update.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/types/type_promotion_open_index_enforced/type_promotion_open_index_enforced.2.update.aql b/asterix-app/src/test/resources/runtimets/queries/types/type_promotion_open_index_enforced/type_promotion_open_index_enforced.2.update.aql new file mode 100644 index 0000000..05ffa1d --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/types/type_promotion_open_index_enforced/type_promotion_open_index_enforced.2.update.aql @@ -0,0 +1,23 @@ +use dataverse TestDataverse; + +insert into dataset TestSet ( + let $i08 := int8("100") + let $i16 := int16("10000") + let $i32 := 1000000 + let $i64 := int64("10000000000") + return { + "id": 1, + "int8_u": {{ $i08 }}, + "int8_o": [ $i08 ], + "int16_u": {{ $i08, $i16 }}, + "int16_o": [ $i08, $i16 ], + "int32_u": {{ $i08, $i16, $i32 }}, + "int32_o": [ $i08, $i16, $i32 ], + "int64_u": {{ $i08, $i16, $i32, $i64 }}, + "int64_o": [ $i08, $i16, $i32, $i64 ], + "float_u": {{ $i08, $i16, $i32 }}, + "float_o": [ $i08, $i16, $i32 ], + "double_u": {{ $i08, $i16, $i32, $i64 }}, + "double_o": [ $i08, $i16, $i32, $i64 ] + } +) http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/queries/types/type_promotion_open_index_enforced/type_promotion_open_index_enforced.3.query.aql ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/queries/types/type_promotion_open_index_enforced/type_promotion_open_index_enforced.3.query.aql b/asterix-app/src/test/resources/runtimets/queries/types/type_promotion_open_index_enforced/type_promotion_open_index_enforced.3.query.aql new file mode 100644 index 0000000..137b994 --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/queries/types/type_promotion_open_index_enforced/type_promotion_open_index_enforced.3.query.aql @@ -0,0 +1,4 @@ +use dataverse TestDataverse; + +for $i in dataset TestSet +return $i http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/results/cross-dataverse/cross-dv02/cross-dv02.1.adm ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/results/cross-dataverse/cross-dv02/cross-dv02.1.adm b/asterix-app/src/test/resources/runtimets/results/cross-dataverse/cross-dv02/cross-dv02.1.adm index 139fb76..81e639b 100644 --- a/asterix-app/src/test/resources/runtimets/results/cross-dataverse/cross-dv02/cross-dv02.1.adm +++ b/asterix-app/src/test/resources/runtimets/results/cross-dataverse/cross-dv02/cross-dv02.1.adm @@ -1,5 +1,5 @@ -[ { "DataverseName": "student", "DatasetName": "gdstd", "DataTypeName": "stdType", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ "id" ], "PrimaryKey": [ "id" ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Wed Apr 30 14:23:30 PDT 2014", "DatasetId": 102, "PendingOp": 0 } -, { "DataverseName": "teacher", "DatasetName": "prof", "DataTypeName": "tchrType", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ "id" ], "PrimaryKey": [ "id" ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Wed Apr 30 14:23:30 PDT 2014", "DatasetId": 103, "PendingOp": 0 } -, { "DataverseName": "teacher", "DatasetName": "pstdoc", "DataTypeName": "tchrType", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ "id" ], "PrimaryKey": [ "id" ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Wed Apr 30 14:23:31 PDT 2014", "DatasetId": 104, "PendingOp": 0 } -, { "DataverseName": "student", "DatasetName": "ugdstd", "DataTypeName": "stdType", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ "id" ], "PrimaryKey": [ "id" ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Wed Apr 30 14:23:30 PDT 2014", "DatasetId": 101, "PendingOp": 0 } - ] +[ { "DataverseName": "student", "DatasetName": "gdstd", "DataTypeName": "stdType", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ [ "id" ] ], "PrimaryKey": [ [ "id" ] ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Wed Apr 30 14:23:30 PDT 2014", "DatasetId": 102, "PendingOp": 0 } +, { "DataverseName": "teacher", "DatasetName": "prof", "DataTypeName": "tchrType", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ [ "id" ] ], "PrimaryKey": [ [ "id" ] ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Wed Apr 30 14:23:30 PDT 2014", "DatasetId": 103, "PendingOp": 0 } +, { "DataverseName": "teacher", "DatasetName": "pstdoc", "DataTypeName": "tchrType", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ [ "id" ] ], "PrimaryKey": [ [ "id" ] ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Wed Apr 30 14:23:31 PDT 2014", "DatasetId": 104, "PendingOp": 0 } +, { "DataverseName": "student", "DatasetName": "ugdstd", "DataTypeName": "stdType", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ [ "id" ] ], "PrimaryKey": [ [ "id" ] ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Wed Apr 30 14:23:30 PDT 2014", "DatasetId": 101, "PendingOp": 0 } + ] \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/results/cross-dataverse/cross-dv04/cross-dv04.1.adm ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/results/cross-dataverse/cross-dv04/cross-dv04.1.adm b/asterix-app/src/test/resources/runtimets/results/cross-dataverse/cross-dv04/cross-dv04.1.adm index 139fb76..81e639b 100644 --- a/asterix-app/src/test/resources/runtimets/results/cross-dataverse/cross-dv04/cross-dv04.1.adm +++ b/asterix-app/src/test/resources/runtimets/results/cross-dataverse/cross-dv04/cross-dv04.1.adm @@ -1,5 +1,5 @@ -[ { "DataverseName": "student", "DatasetName": "gdstd", "DataTypeName": "stdType", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ "id" ], "PrimaryKey": [ "id" ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Wed Apr 30 14:23:30 PDT 2014", "DatasetId": 102, "PendingOp": 0 } -, { "DataverseName": "teacher", "DatasetName": "prof", "DataTypeName": "tchrType", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ "id" ], "PrimaryKey": [ "id" ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Wed Apr 30 14:23:30 PDT 2014", "DatasetId": 103, "PendingOp": 0 } -, { "DataverseName": "teacher", "DatasetName": "pstdoc", "DataTypeName": "tchrType", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ "id" ], "PrimaryKey": [ "id" ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Wed Apr 30 14:23:31 PDT 2014", "DatasetId": 104, "PendingOp": 0 } -, { "DataverseName": "student", "DatasetName": "ugdstd", "DataTypeName": "stdType", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ "id" ], "PrimaryKey": [ "id" ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Wed Apr 30 14:23:30 PDT 2014", "DatasetId": 101, "PendingOp": 0 } - ] +[ { "DataverseName": "student", "DatasetName": "gdstd", "DataTypeName": "stdType", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ [ "id" ] ], "PrimaryKey": [ [ "id" ] ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Wed Apr 30 14:23:30 PDT 2014", "DatasetId": 102, "PendingOp": 0 } +, { "DataverseName": "teacher", "DatasetName": "prof", "DataTypeName": "tchrType", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ [ "id" ] ], "PrimaryKey": [ [ "id" ] ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Wed Apr 30 14:23:30 PDT 2014", "DatasetId": 103, "PendingOp": 0 } +, { "DataverseName": "teacher", "DatasetName": "pstdoc", "DataTypeName": "tchrType", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ [ "id" ] ], "PrimaryKey": [ [ "id" ] ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Wed Apr 30 14:23:31 PDT 2014", "DatasetId": 104, "PendingOp": 0 } +, { "DataverseName": "student", "DatasetName": "ugdstd", "DataTypeName": "stdType", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ [ "id" ] ], "PrimaryKey": [ [ "id" ] ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Wed Apr 30 14:23:30 PDT 2014", "DatasetId": 101, "PendingOp": 0 } + ] \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/results/cross-dataverse/cross-dv19/cross-dv19.1.adm ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/results/cross-dataverse/cross-dv19/cross-dv19.1.adm b/asterix-app/src/test/resources/runtimets/results/cross-dataverse/cross-dv19/cross-dv19.1.adm index aa02996..3f69f4f 100644 --- a/asterix-app/src/test/resources/runtimets/results/cross-dataverse/cross-dv19/cross-dv19.1.adm +++ b/asterix-app/src/test/resources/runtimets/results/cross-dataverse/cross-dv19/cross-dv19.1.adm @@ -1,8 +1,8 @@ [ { "DataverseName": "test1", "DatasetName": "TwitterData", "DataTypeName": "Tweet", "DatasetType": "EXTERNAL", "InternalDetails": null, "ExternalDetails": { "DatasourceAdapter": "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter", "Properties": [ { "Name": "path", "Value": "nc1://data/twitter/extrasmalltweets.txt" }, { "Name": "format", "Value": "adm" } ], "GroupName": "DEFAULT_NG_ALL_NODES", "LastRefreshTime": datetime("2014-06-08T20:30:43.724Z"), "TransactionState": 0, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "Hints": {{ }}, "Timestamp": "Sun Jun 08 13:30:43 PDT 2014", "DatasetId": 107, "PendingOp": 0 } -, { "DataverseName": "test1", "DatasetName": "t1", "DataTypeName": "testtype", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ "id" ], "PrimaryKey": [ "id" ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Sun Jun 08 13:30:42 PDT 2014", "DatasetId": 101, "PendingOp": 0 } -, { "DataverseName": "test1", "DatasetName": "t2", "DataTypeName": "testtype", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ "id" ], "PrimaryKey": [ "id" ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Sun Jun 08 13:30:43 PDT 2014", "DatasetId": 104, "PendingOp": 0 } -, { "DataverseName": "test1", "DatasetName": "t3", "DataTypeName": "testtype", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ "id" ], "PrimaryKey": [ "id" ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Sun Jun 08 13:30:43 PDT 2014", "DatasetId": 105, "PendingOp": 0 } -, { "DataverseName": "test2", "DatasetName": "t2", "DataTypeName": "testtype", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ "id" ], "PrimaryKey": [ "id" ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Sun Jun 08 13:30:42 PDT 2014", "DatasetId": 102, "PendingOp": 0 } -, { "DataverseName": "test2", "DatasetName": "t3", "DataTypeName": "testtype", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ "id" ], "PrimaryKey": [ "id" ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Sun Jun 08 13:30:42 PDT 2014", "DatasetId": 103, "PendingOp": 0 } -, { "DataverseName": "test2", "DatasetName": "t4", "DataTypeName": "testtype", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ "id" ], "PrimaryKey": [ "id" ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Sun Jun 08 13:30:43 PDT 2014", "DatasetId": 106, "PendingOp": 0 } - ] +, { "DataverseName": "test1", "DatasetName": "t1", "DataTypeName": "testtype", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ [ "id" ] ], "PrimaryKey": [ [ "id" ] ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Sun Jun 08 13:30:42 PDT 2014", "DatasetId": 101, "PendingOp": 0 } +, { "DataverseName": "test1", "DatasetName": "t2", "DataTypeName": "testtype", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ [ "id" ] ], "PrimaryKey": [ [ "id" ] ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Sun Jun 08 13:30:43 PDT 2014", "DatasetId": 104, "PendingOp": 0 } +, { "DataverseName": "test1", "DatasetName": "t3", "DataTypeName": "testtype", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ [ "id" ] ], "PrimaryKey": [ [ "id" ] ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Sun Jun 08 13:30:43 PDT 2014", "DatasetId": 105, "PendingOp": 0 } +, { "DataverseName": "test2", "DatasetName": "t2", "DataTypeName": "testtype", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ [ "id" ] ], "PrimaryKey": [ [ "id" ] ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Sun Jun 08 13:30:42 PDT 2014", "DatasetId": 102, "PendingOp": 0 } +, { "DataverseName": "test2", "DatasetName": "t3", "DataTypeName": "testtype", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ [ "id" ] ], "PrimaryKey": [ [ "id" ] ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Sun Jun 08 13:30:42 PDT 2014", "DatasetId": 103, "PendingOp": 0 } +, { "DataverseName": "test2", "DatasetName": "t4", "DataTypeName": "testtype", "DatasetType": "INTERNAL", "InternalDetails": { "FileStructure": "BTREE", "PartitioningStrategy": "HASH", "PartitioningKey": [ [ "id" ] ], "PrimaryKey": [ [ "id" ] ], "GroupName": "DEFAULT_NG_ALL_NODES", "Autogenerated": false, "CompactionPolicy": "prefix", "CompactionPolicyProperties": [ { "Name": "max-mergable-component-size", "Value": "1073741824" }, { "Name": "max-tolerance-component-count", "Value": "5" } ] }, "ExternalDetails": null, "Hints": {{ }}, "Timestamp": "Sun Jun 08 13:30:43 PDT 2014", "DatasetId": 106, "PendingOp": 0 } + ] \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/results/dml/drop-empty-secondary-indexes/drop-empty-secondary-indexes.1.adm ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/results/dml/drop-empty-secondary-indexes/drop-empty-secondary-indexes.1.adm b/asterix-app/src/test/resources/runtimets/results/dml/drop-empty-secondary-indexes/drop-empty-secondary-indexes.1.adm index 8859938..ae02b69 100644 --- a/asterix-app/src/test/resources/runtimets/results/dml/drop-empty-secondary-indexes/drop-empty-secondary-indexes.1.adm +++ b/asterix-app/src/test/resources/runtimets/results/dml/drop-empty-secondary-indexes/drop-empty-secondary-indexes.1.adm @@ -1,4 +1,4 @@ -[ { "DataverseName": "Metadata", "DatasetName": "Dataset", "IndexName": "DatatypeName", "IndexStructure": "BTREE", "SearchKey": [ "DataverseName", "DatatypeName", "DatasetName" ], "IsPrimary": false, "Timestamp": "Fri Feb 08 17:57:01 PST 2013" } -, { "DataverseName": "Metadata", "DatasetName": "Dataset", "IndexName": "GroupName", "IndexStructure": "BTREE", "SearchKey": [ "GroupName", "DataverseName", "DatasetName" ], "IsPrimary": false, "Timestamp": "Fri Feb 08 17:57:01 PST 2013" } -, { "DataverseName": "Metadata", "DatasetName": "Datatype", "IndexName": "DatatypeName", "IndexStructure": "BTREE", "SearchKey": [ "DataverseName", "NestedDatatypeName", "TopDatatypeName" ], "IsPrimary": false, "Timestamp": "Fri Feb 08 17:57:01 PST 2013" } - ] +[ { "DataverseName": "Metadata", "DatasetName": "Dataset", "IndexName": "DatatypeName", "IndexStructure": "BTREE", "SearchKey": [ [ "DataverseName" ], [ "DatatypeName" ], [ "DatasetName" ] ], "IsPrimary": false, "Timestamp": "Tue Sep 23 14:44:50 PDT 2014", "PendingOp": 0, "SearchKeyType": [ "null", "null", "null" ] } +, { "DataverseName": "Metadata", "DatasetName": "Dataset", "IndexName": "GroupName", "IndexStructure": "BTREE", "SearchKey": [ [ "GroupName" ], [ "DataverseName" ], [ "DatasetName" ] ], "IsPrimary": false, "Timestamp": "Tue Sep 23 14:44:50 PDT 2014", "PendingOp": 0, "SearchKeyType": [ "null", "null", "null" ] } +, { "DataverseName": "Metadata", "DatasetName": "Datatype", "IndexName": "DatatypeName", "IndexStructure": "BTREE", "SearchKey": [ [ "DataverseName" ], [ "NestedDatatypeName" ], [ "TopDatatypeName" ] ], "IsPrimary": false, "Timestamp": "Tue Sep 23 14:44:50 PDT 2014", "PendingOp": 0, "SearchKeyType": [ "null", "null", "null" ] } + ] \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/04b2b77a/asterix-app/src/test/resources/runtimets/results/dml/insert-and-scan-dataset-with-index-on-open-field/insert-and-scan-dataset-with-index-on-open-field.1.adm ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/runtimets/results/dml/insert-and-scan-dataset-with-index-on-open-field/insert-and-scan-dataset-with-index-on-open-field.1.adm b/asterix-app/src/test/resources/runtimets/results/dml/insert-and-scan-dataset-with-index-on-open-field/insert-and-scan-dataset-with-index-on-open-field.1.adm new file mode 100644 index 0000000..9d5aa40 --- /dev/null +++ b/asterix-app/src/test/resources/runtimets/results/dml/insert-and-scan-dataset-with-index-on-open-field/insert-and-scan-dataset-with-index-on-open-field.1.adm @@ -0,0 +1,120 @@ +{ "id": 101, "lname": "Makuch", "age": 28, "dept": "IT", "fname": "Javier" } +{ "id": 110, "lname": "Piland", "age": 29, "dept": "HR", "fname": "Allan" } +{ "id": 112, "lname": "Aumann", "age": 31, "dept": "Payroll", "fname": "Pearlie" } +{ "id": 113, "lname": "Hase", "age": 34, "dept": "Sales", "fname": "Chandra" } +{ "id": 114, "lname": "Convery", "age": 28, "dept": "HR", "fname": "Christian" } +{ "id": 115, "lname": "Ritch", "age": 26, "dept": "IT", "fname": "Panther" } +{ "id": 116, "lname": "Elsea", "age": 26, "dept": "IT", "fname": "Ted" } +{ "id": 117, "lname": "Bladen", "age": 25, "dept": "HR", "fname": "Tabatha" } +{ "id": 118, "lname": "Oltman", "age": 42, "dept": "Sales", "fname": "Clayton" } +{ "id": 119, "lname": "Darwin", "age": 32, "dept": "Payroll", "fname": "Sharron" } +{ "id": 210, "lname": "Durgin", "age": 52, "dept": "HR", "fname": "Clayton" } +{ "id": 212, "lname": "Chenail", "age": 26, "dept": "Sales", "fname": "Emilia" } +{ "id": 213, "lname": "Almquist", "age": 43, "dept": "Payroll", "fname": "Kenya" } +{ "id": 214, "lname": "Lacefield", "age": 41, "dept": "HR", "fname": "Alejandra" } +{ "id": 215, "lname": "Michelsen", "age": 46, "dept": "IT", "fname": "Karina" } +{ "id": 216, "lname": "Delillo", "age": 36, "dept": "IT", "fname": "Katy" } +{ "id": 217, "lname": "Kleist", "age": 37, "dept": "HR", "fname": "Benita" } +{ "id": 218, "lname": "Paluch", "age": 31, "dept": "IT", "fname": "Earlene" } +{ "id": 219, "lname": "Petermann", "age": 27, "dept": "Payroll", "fname": "Kurt" } +{ "id": 299, "lname": "Iorio", "age": 37, "dept": "IT", "fname": "Julio" } +{ "id": 363, "lname": "Rodreguez", "age": 26, "dept": "IT", "fname": "Cody" } +{ "id": 404, "lname": "Square", "age": 32, "dept": "IT", "fname": "Emilia" } +{ "id": 414, "lname": "Fuschetto", "age": 34, "dept": "HR", "fname": "Mathew" } +{ "id": 424, "lname": "Remus", "age": 32, "dept": "IT", "fname": "Allyson" } +{ "id": 434, "lname": "Linebarger", "age": 26, "dept": "Payroll", "fname": "Earlene" } +{ "id": 444, "lname": "Sick", "age": 29, "dept": "IT", "fname": "Clinton" } +{ "id": 454, "lname": "Caba", "age": 28, "dept": "HR", "fname": "Ted" } +{ "id": 463, "lname": "States", "age": 28, "dept": "IT", "fname": "Marcie" } +{ "id": 464, "lname": "Engelke", "age": 39, "dept": "IT", "fname": "Fernando" } +{ "id": 474, "lname": "Courchesne", "age": 31, "dept": "IT", "fname": "Mathew" } +{ "id": 484, "lname": "Vinyard", "age": 36, "dept": "Payroll", "fname": "Cody" } +{ "id": 494, "lname": "Fravel", "age": 33, "dept": "Sales", "fname": "Benita" } +{ "id": 504, "lname": "Dobek", "age": 29, "dept": "IT", "fname": "Erik" } +{ "id": 514, "lname": "Ruben", "age": 41, "dept": "IT", "fname": "Julio" } +{ "id": 524, "lname": "Maltos", "age": 33, "dept": "IT", "fname": "Benita" } +{ "id": 534, "lname": "Biscoe", "age": 36, "dept": "HR", "fname": "Kurt" } +{ "id": 538, "lname": "Forkey", "age": 34, "dept": "Sales", "fname": "Milagros" } +{ "id": 544, "lname": "Housel", "age": 30, "dept": "Sales", "fname": "Loraine" } +{ "id": 554, "lname": "Rachal", "age": 30, "dept": "IT", "fname": "Jamie" } +{ "id": 564, "lname": "Fredenburg", "age": 37, "dept": "IT", "fname": "Liza" } +{ "id": 574, "lname": "Feldmann", "age": 29, "dept": "Sales", "fname": "Ericka" } +{ "id": 584, "lname": "Dattilo", "age": 32, "dept": "Payroll", "fname": "Dollie" } +{ "id": 589, "lname": "Sharon", "age": 27, "dept": "IT", "fname": "Lorrie" } +{ "id": 594, "lname": "Houghtaling", "age": 40, "dept": "Payroll", "fname": "Roxie" } +{ "id": 601, "lname": "Deforge", "age": 26, "dept": "HR", "fname": "Neil" } +{ "id": 611, "lname": "Marcy", "age": 32, "dept": "IT", "fname": "Earlene" } +{ "id": 621, "lname": "Lechuga", "age": 42, "dept": "Payroll", "fname": "Erik" } +{ "id": 631, "lname": "Holtzclaw", "age": 34, "dept": "Sales", "fname": "Tyrone" } +{ "id": 641, "lname": "Hankey", "age": 35, "dept": "Sales", "fname": "Lance" } +{ "id": 651, "lname": "Gladding", "age": 31, "dept": "HR", "fname": "Mallory" } +{ "id": 661, "lname": "Braaten", "age": 40, "dept": "IT", "fname": "Tia" } +{ "id": 671, "lname": "Vanpatten", "age": 30, "dept": "Payroll", "fname": "Julio" } +{ "id": 681, "lname": "Teachout", "age": 34, "dept": "IT", "fname": "Max" } +{ "id": 691, "lname": "Wingerter", "age": 31, "dept": "IT", "fname": "Karina" } +{ "id": 711, "lname": "Lema", "age": 25, "dept": "HR", "fname": "Hugh" } +{ "id": 721, "lname": "Phil", "age": 34, "dept": "Payroll", "fname": "Schwan" } +{ "id": 732, "lname": "Eacret", "age": 56, "dept": "HR", "fname": "Noemi" } +{ "id": 741, "lname": "Mattocks", "age": 38, "dept": "Sales", "fname": "Julio" } +{ "id": 751, "lname": "Kottke", "age": 34, "dept": "IT", "fname": "Lance" } +{ "id": 761, "lname": "Liz", "age": 32, "dept": "HR", "fname": "Kurt" } +{ "id": 771, "lname": "Barbeau", "age": 45, "dept": "Sales", "fname": "Neva" } +{ "id": 781, "lname": "Tuthill", "age": 46, "dept": "Payroll", "fname": "Karina" } +{ "id": 791, "lname": "Cambron", "age": 36, "dept": "IT", "fname": "Maricela" } +{ "id": 809, "lname": "Delany", "age": 23, "dept": "IT", "fname": "Clayton" } +{ "id": 811, "lname": "Kuhn", "age": 27, "dept": "HR", "fname": "Kubik" } +{ "id": 821, "lname": "Tomes", "age": 29, "dept": "Payroll", "fname": "Allan" } +{ "id": 831, "lname": "Aller", "age": 33, "dept": "Sales", "fname": "Lonnie" } +{ "id": 841, "lname": "Hurrell", "age": 26, "dept": "IT", "fname": "Neil" } +{ "id": 851, "lname": "Engles", "age": 41, "dept": "HR", "fname": "Clayton" } +{ "id": 861, "lname": "Gabrielson", "age": 39, "dept": "Payroll", "fname": "Javier" } +{ "id": 871, "lname": "Alejandre", "age": 48, "dept": "IT", "fname": "Allan" } +{ "id": 881, "lname": "Isa", "age": 38, "dept": "Sales", "fname": "Julio" } +{ "id": 891, "lname": "Simmerman", "age": 31, "dept": "IT", "fname": "Roslyn" } +{ "id": 915, "lname": "Stuart", "age": 25, "dept": "Sales", "fname": "Starner" } +{ "id": 925, "lname": "Cuff", "age": 30, "dept": "HR", "fname": "Sofia" } +{ "id": 935, "lname": "Murguia", "age": 31, "dept": "IT", "fname": "Milagros" } +{ "id": 945, "lname": "Haldeman", "age": 32, "dept": "IT", "fname": "Margery" } +{ "id": 955, "lname": "Mell", "age": 33, "dept": "HR", "fname": "Max" } +{ "id": 965, "lname": "Mercy", "age": 31, "dept": "Payroll", "fname": "Micco" } +{ "id": 975, "lname": "Vangieson", "age": 34, "dept": "IT", "fname": "Clare" } +{ "id": 985, "lname": "Dimauro", "age": 35, "dept": "Sales", "fname": "Elnora" } +{ "id": 995, "lname": "Kocian", "age": 38, "dept": "HR", "fname": "Pearlie" } +{ "id": 1007, "lname": "Bu", "age": 27, "dept": "IT", "fname": "Yingyi" } +{ "id": 1263, "lname": "Loffredo", "age": 25, "dept": "IT", "fname": "Tania" } +{ "id": 1410, "lname": "Fredricks", "age": 34, "dept": "IT", "fname": "Clinton" } +{ "id": 1411, "lname": "Farquhar", "age": 32, "dept": "HR", "fname": "Lance" } +{ "id": 1412, "lname": "Crisler", "age": 33, "dept": "IT", "fname": "Tabatha" } +{ "id": 1413, "lname": "Durney", "age": 29, "dept": "IT", "fname": "Max" } +{ "id": 1414, "lname": "Strauser", "age": 30, "dept": "Payroll", "fname": "Carmella" } +{ "id": 1415, "lname": "Carrales", "age": 40, "dept": "IT", "fname": "Kelly" } +{ "id": 1416, "lname": "Merten", "age": 29, "dept": "Sales", "fname": "Guy" } +{ "id": 1417, "lname": "Ruhland", "age": 29, "dept": "IT", "fname": "Noreen" } +{ "id": 1418, "lname": "Damore", "age": 27, "dept": "Sales", "fname": "Julio" } +{ "id": 1419, "lname": "Truby", "age": 25, "dept": "HR", "fname": "Selena" } +{ "id": 1420, "lname": "Commons", "age": 30, "dept": "Sales", "fname": "Alejandra" } +{ "id": 1421, "lname": "Balk", "age": 30, "dept": "IT", "fname": "Allyson" } +{ "id": 1422, "lname": "Byun", "age": 40, "dept": "Sales", "fname": "Nelson" } +{ "id": 1423, "lname": "Reidhead", "age": 40, "dept": "IT", "fname": "Christian" } +{ "id": 1424, "lname": "Hopkin", "age": 48, "dept": "Payroll", "fname": "Pearlie" } +{ "id": 1425, "lname": "Wohlers", "age": 41, "dept": "HR", "fname": "Nelson" } +{ "id": 1426, "lname": "Rasnake", "age": 42, "dept": "Sales", "fname": "Marcie" } +{ "id": 1427, "lname": "Marshburn", "age": 43, "dept": "Payroll", "fname": "Hugh" } +{ "id": 1428, "lname": "Marasco", "age": 45, "dept": "Sales", "fname": "Mathew" } +{ "id": 1429, "lname": "Veres", "age": 32, "dept": "IT", "fname": "Kurt" } +{ "id": 1430, "lname": "Barkett", "age": 39, "dept": "Sales", "fname": "Julio" } +{ "id": 1863, "lname": "Thorington", "age": 32, "dept": "Sales", "fname": "Darren" } +{ "id": 1999, "lname": "Malaika", "age": 42, "dept": "HR", "fname": "Susan" } +{ "id": 2333, "lname": "Li", "age": 42, "dept": "HR", "fname": "Chen" } +{ "id": 2963, "lname": "Gunnerson", "age": 34, "dept": "IT", "fname": "Neil" } +{ "id": 3563, "lname": "Susan", "age": 29, "dept": "Sales", "fname": "Hazeltine" } +{ "id": 3666, "lname": "Kim", "age": 35, "dept": "Payroll", "fname": "Young Seok" } +{ "id": 4727, "lname": "Carey", "age": 50, "dept": "Payroll", "fname": "Michael" } +{ "id": 5438, "lname": "Quashie", "age": 29, "dept": "HR", "fname": "Lakisha" } +{ "id": 7444, "lname": "Mehrotra", "age": 42, "dept": "Sales", "fname": "Sharad" } +{ "id": 7663, "lname": "Nimmo", "age": 30, "dept": "Payroll", "fname": "Annabelle" } +{ "id": 8301, "lname": "Wallick", "age": 26, "dept": "HR", "fname": "Earlene" } +{ "id": 8338, "lname": "Bosket", "age": 28, "dept": "Payroll", "fname": "Julio" } +{ "id": 9555, "lname": "Givargis", "age": 40, "dept": "Sales", "fname": "Tony" } +{ "id": 9763, "lname": "Saini", "age": 31, "dept": "IT", "fname": "Ted" } +{ "id": 9941, "lname": "Mohammed", "age": 30, "dept": "HR", "fname": "Khurram Faraaz" } \ No newline at end of file