Clone Tools
  • last updated 19 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
[ASTERIXDB-1972][COMP][RT][TX] index-only plan

- user model changes: no

- storage format changes: no

- interface changes: IAccessMethod, ILSMIndexOperationContext,

IIndexAccessor

Details:

- Implement an index-only plan

- Add a SET option that disables the index-only plan

Change-Id: Ifd5c9ab1cf2e4bedb7d8db582441919875e74d51

Reviewed-on: https://asterix-gerrit.ics.uci.edu/1866

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Contrib: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Taewoo Kim <wangsaeu@gmail.com>

    • -0
    • +2
    ./btree-secondary-composite-index-indexonly-plan-01/btree-secondary-composite-index-indexonly-plan-01.1.adm
    • -0
    • +2
    ./btree-secondary-composite-index-indexonly-plan-02/btree-secondary-composite-index-indexonly-plan-02.1.adm
    • -0
    • +2
    ./btree-secondary-composite-index-indexonly-plan-03/btree-secondary-composite-index-indexonly-plan-03.1.adm
    • -0
    • +1
    ./btree-secondary-index-indexonly-plan-01/btree-secondary-index-indexonly-plan-01.10.adm
    • -0
    • +2
    ./btree-secondary-index-indexonly-plan-01/btree-secondary-index-indexonly-plan-01.3.adm
    • -0
    • +2
    ./btree-secondary-index-indexonly-plan-01/btree-secondary-index-indexonly-plan-01.4.adm
    • -0
    • +2
    ./btree-secondary-index-indexonly-plan-01/btree-secondary-index-indexonly-plan-01.5.adm
    • -0
    • +1
    ./btree-secondary-index-indexonly-plan-01/btree-secondary-index-indexonly-plan-01.6.adm
    • -0
    • +1
    ./btree-secondary-index-indexonly-plan-01/btree-secondary-index-indexonly-plan-01.7.adm
    • -0
    • +1
    ./btree-secondary-index-indexonly-plan-01/btree-secondary-index-indexonly-plan-01.8.adm
    • -0
    • +1
    ./btree-secondary-index-indexonly-plan-01/btree-secondary-index-indexonly-plan-01.9.adm
    • -0
    • +1
    ./btree-secondary-index-non-indexonly-plan-01/btree-secondary-index-non-indexonly-plan-01.1.adm
    • -0
    • +1
    ./rtree-secondary-index-indexonly-plan-01/rtree-secondary-index-indexonly-plan-01.10.adm
    • -0
    • +30
    ./rtree-secondary-index-indexonly-plan-01/rtree-secondary-index-indexonly-plan-01.11.adm
    • -0
    • +1
    ./rtree-secondary-index-indexonly-plan-01/rtree-secondary-index-indexonly-plan-01.3.adm
  1. … 410 more files in changeset.
[ASTERIXDB-2015][IDX] Introduce Primary Index Optimization Rule

- user model changes: no

- storage format changes: no

- interface changes: no

details:

This is the optimization rule that will optimize aggregation queries

when only PKs are involved. The rule will use the primary index and

replace the dataset scan or unnest-map operator.

Change-Id: I3bbb2b5e1f25e61928d73b866e91c592ce0bf954

Reviewed-on: https://asterix-gerrit.ics.uci.edu/2111

Sonar-Qube: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Contrib: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Dmitry Lychagin <dmitry.lychagin@couchbase.com>

    • -0
    • +1
    ./btree-sec-primary-index-01/btree-sec-primary-index-01.3.adm
    • -0
    • +1
    ./btree-sec-primary-index-02/btree-sec-primary-index-02.3.adm
    • -0
    • +1
    ./btree-sec-primary-index-03/btree-sec-primary-index-03.3.adm
    • -0
    • +1
    ./btree-sec-primary-index-04/btree-sec-primary-index-04.3.adm
  1. … 30 more files in changeset.
[ASTERIXDB-2015][IDX] Introduce Secondary Primary Index

- user model changes: yes. CREATE PRIMARY INDEX

- storage format changes: no

- interface changes: no

details:

- enable the creation of secondary primary indexes storing only PKs

- change the grammar to allow the creation of secondary primary index

- introduce a new rule to fix the outputs of the replicate operator

to match its parents in the final plan

- disallow creating an enforced index on a closed-type field

- disallow creating an index with repeating keys

Change-Id: I59725425ba7c5fe438507dc900f83eaab239d296

Reviewed-on: https://asterix-gerrit.ics.uci.edu/1916

Sonar-Qube: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Contrib: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Dmitry Lychagin <dmitry.lychagin@couchbase.com>

    • -0
    • +10
    ./btree-sec-primary-index/btree-sec-primary-index.4.adm
  1. … 89 more files in changeset.
Change logical plan to apply filter from 2ndary index

- Changes the IntroduceLSMComponentFilterRule to

replace the constant filter value from the query to the value

carried from 2ndary index search.

- Can use 2ndary index filter even the query doens't contain

any filter related condition.

Change-Id: I0e2fe0208662e5dcd49d1a22bfb58f96533e9497

Reviewed-on: https://asterix-gerrit.ics.uci.edu/1727

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

BAD: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Yingyi Bu <buyingyi@gmail.com>

    • -0
    • +1
    ./intersection-with-filter/intersection.1.adm
  1. … 84 more files in changeset.
ASTERIXDB-1700: fixed multiple same type of index application error on the same field

- Fixed an issue that multiple same type of indexes can be applied for the same field.

For this situation, applying only one index will be enough.

(e.g., 2-gram and 3-gram index on the same field)

Change-Id: I450f3adb20c777d5b9a8f638e010076b9d817942

Reviewed-on: https://asterix-gerrit.ics.uci.edu/1307

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Jianfeng Jia <jianfeng.jia@gmail.com>

    • -0
    • +1
    ./inverted-index-ngram-edit-distance-with-two-ngram-index/inverted-index-ngram-edit-distance-with-two-ngram-index.1.adm
  1. … 6 more files in changeset.
ASTERIXDB-1186: fixed a composite primary index search issue.

- Providing only one field to a composite primary index search

now works properly by broadcasting search predicates to all nodes.

Change-Id: I0f75229ea804a02e7cacd04f7269a4907668eab0

Reviewed-on: https://asterix-gerrit.ics.uci.edu/1094

Sonar-Qube: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Taewoo Kim <wangsaeu@yahoo.com>

    • -0
    • +6005
    ./btree-index-composite-key-02/btree-index-composite-key-02.3.adm
    • -0
    • +6005
    ./btree-index-composite-key-02/btree-index-composite-key-02.4.adm
  1. … 18 more files in changeset.
Update adm.grammar and printers for double/float

adm.grammar was not accepting suffixed doubles. This was breaking

a lot of round-trip ADM cases. I also changed the default print for

float and double to not have a suffix, because this makes the output

very odd (NaNd, NaNf, -Infinityf). The print mode for integers

has also been changed to omit the suffix, but, similarly the old

format is still accepted.

Change-Id: I6164d74f6c286fa160a30cff9ad47e97a30e0770

Reviewed-on: https://asterix-gerrit.ics.uci.edu/932

Reviewed-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Michael Blow <michael.blow@couchbase.com>

    • -2978
    • +2978
    ./range-search-open/range-search-open.1.adm
    • -2978
    • +2978
    ./range-search/range-search.1.adm
  1. … 500 more files in changeset.
Supports Left Outer Join and Left Outer Unnest in SQL++.

- change record format to allow MISSING value for an optional field;

- support roundtrips of MISSING valued closed fields for load and insert;

- suppress fields with MISSING values in result printer;

- fix ByNameToByIndexFieldAccessRule and LoadRecordFieldsRule;

- update test queries and results.

Change-Id: Ie0caea9c1842d93541b067a1193d117af30d8dfc

Reviewed-on: https://asterix-gerrit.ics.uci.edu/899

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Till Westmann <tillw@apache.org>

    • -1
    • +1
    ./cust-index-age-nullable/cust-index-age-nullable.1.adm
    • -707
    • +707
    ./inverted-index-olist-edit-distance-panic/inverted-index-olist-edit-distance-panic.1.adm
    • -5
    • +5
    ./inverted-index-olist-edit-distance/inverted-index-olist-edit-distance.1.adm
  1. … 583 more files in changeset.