push-limit-to-primary-scan-select

Clone Tools
  • last updated 25 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
[ASTERIXDB-2488][COMP] Support aggregate window functions

- user model changes: yes

- storage format changes: no

- interface changes: no

Details:

- Implement aggregate window functions:

agg_func() OVER (frame_var AS)? (PARTITION BY ... ORDER BY ... frame_spec)

- Where agg_func is a SQL/SQL++ aggregate function

- Fix percent_rank() to always return 0 for the first tuple

- Fix ntile() to handle NULL argument

- Log query after each rewrite rule in SqlppQueryRewriter

- Implement toString() for ADayTimeDuration, fix it for AYearMonthDuration

- Add seek() method to RunFileReader

Change-Id: If0f71118a04c2dbd3462070673d52e67f076b7e1

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

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

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

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

Reviewed-by: Ali Alsuliman <ali.al.solaiman@gmail.com>

    • -2
    • +2
    ./push-limit-to-primary-scan-select.3.adm
    • -19
    • +19
    ./push-limit-to-primary-scan-select.5.adm
    • -8
    • +8
    ./push-limit-to-primary-scan-select.6.adm
    • -8
    • +8
    ./push-limit-to-primary-scan-select.8.adm
  1. … 851 more files in changeset.
[ASTERIXDB-2448][COMP] Fix NullPointerException in IntroduceSelectAccessMethodRule

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

- Fixed NPE when intersecting two indexes and predicate containing

between operator:

a) If index intersection plan is not possible then exit the rule

b) Rewrite between operator into ge/le pair instead of le/le pair

Change-Id: I34d4cde6adf3785feb6a8280fcdb964a5fb72803

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

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: Till Westmann <tillw@apache.org>

    • -1
    • +1
    ./push-limit-to-primary-scan-select.8.adm
  1. … 10 more files in changeset.
[ASTERIXDB-2438][COMP] Allow assigns when pushing limit into data scan

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

- Handle assign operators between select and data scan

when pushing limit into data scan

Change-Id: I3b68890d034dded3db7572462f47161721aa18fa

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

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

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

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

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

    • -0
    • +28
    ./push-limit-to-primary-scan-select.6.adm
    • -0
    • +1
    ./push-limit-to-primary-scan-select.7.adm
    • -0
    • +28
    ./push-limit-to-primary-scan-select.8.adm
    • -0
    • +2
    ./push-limit-to-primary-scan-select.9.adm
  1. … 14 more files in changeset.
[ASTERIXDB-2424][COMP] No limit pushdown if multiple limit clauses

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

- CopyLimitDownRule should not stop at the first limit clause it processes

Change-Id: Id92bb99c57d1363740b0ccbb09bceb59da968ca0

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

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: Taewoo Kim <wangsaeu@gmail.com>

    • -0
    • +64
    ./push-limit-to-primary-scan-select.5.adm
  1. … 2 more files in changeset.
[ASTERIXDB-2344] LIMIT pushdown for primary index

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

-Implement LIMIT pushdown for primary index scan/lookup. In case of

a select operator, we also push the select condition to the priamry

search operator to ensure correctness.

Change-Id: I824fcad79995325e12a1a81d629160025294b915

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

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
    • +20
    ./push-limit-to-primary-scan-select.3.adm
    • -0
    • +5
    ./push-limit-to-primary-scan-select.4.adm
  1. … 52 more files in changeset.