Clone Tools
  • last updated 10 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Rewrite SQL++ functions.

-Maps SQL function names to internal names.

-Allows SQL++ builtin functions to be case-insensitive.

-Rewrites SQL-92 global aggregates.

-Refactors SQL++ AST visitors.

-Cleans up semantics of COLL_AGG and SQL-92 AGG.

Change-Id: Idb5a7c6780669b27065b0928bec7e4700cfb53a9

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

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

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

    • -2
    • +2
    ./queries_sqlpp/denorm-cust-order.sqlpp
    • -2
    • +2
    ./queries_sqlpp/distinct_aggregate.sqlpp
    • -1
    • +1
    ./queries_sqlpp/fj-phase2-with-hints.sqlpp
    • -2
    • +2
    ./queries_sqlpp/inlined_q18_large_volume_customer.sqlpp
    • -8
    • +8
    ./queries_sqlpp/q01_pricing_summary_report_nt.sqlpp
    • -1
    • +1
    ./queries_sqlpp/q03_shipping_priority.sqlpp
    • -1
    • +1
    ./queries_sqlpp/q05_local_supplier_volume.sqlpp
  1. … 437 more files in changeset.
Move AsterixDB to Subfolder

    • -71
    • +0
    ./queries/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01.aql
    • -73
    • +0
    ./queries/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02.aql
  1. … 44144 more files in changeset.
ASTERIXDB-1226: implement SQL++ core group-by semantics and syntatic sugars.

-Implmented SQL++ core group-by semantics;

-Implemented SQL++ group-by syntatic sugars for standard SQL;

-Added test cases;

-Fixed column alias rewriter;

-Fixed the variable scoping for joins.

Change-Id: I6e5477d5bf80114cfff49c8ecb163849ee55eba6

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

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

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

    • -11
    • +11
    ./results_parser_sqlpp/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01.ast
    • -13
    • +13
    ./results_parser_sqlpp/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02.ast
    • -8
    • +8
    ./results_parser_sqlpp/btree-index-join/primary-composite-key-prefix-join_01.ast
    • -8
    • +8
    ./results_parser_sqlpp/btree-index-join/primary-composite-key-prefix-join_02.ast
    • -8
    • +8
    ./results_parser_sqlpp/btree-index-join/primary-composite-key-prefix-join_03.ast
    • -8
    • +8
    ./results_parser_sqlpp/btree-index-join/primary-composite-key-prefix-join_04.ast
    • -8
    • +8
    ./results_parser_sqlpp/btree-index-join/primary-composite-key-prefix-join_05.ast
    • -8
    • +8
    ./results_parser_sqlpp/btree-index-join/primary-composite-key-prefix-join_06.ast
    • -10
    • +10
    ./results_parser_sqlpp/btree-index-join/primary-equi-join-multipred.ast
  1. … 1949 more files in changeset.
ASTERIXDB-1359 Removed Project from IntroduceSecondaryIndex Rule

Change-Id: I912e3d56c0b9c2b5b252630acf8b15c54e0f61a1

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

Reviewed-by: Ildar Absalyamov <ildar.absalyamov@gmail.com>

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

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

    • -3
    • +3
    ./results/disjunction-to-join-delete-3.plan
  1. … 1 more file in changeset.
ASTERIXDB-865: fix query compilation for if-else expression.

Change-Id: I80e7995e814180fe567818263c79493901af284c

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

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

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

    • -0
    • +41
    ./queries/query-ASTERIXDB-1203.aql
    • -0
    • +52
    ./queries/query-ASTERIXDB-865.aql
    • -0
    • +36
    ./results/query-ASTERIXDB-1203.plan
    • -0
    • +35
    ./results/query-ASTERIXDB-865.plan
    • -20
    • +22
    ./results/udfs/query-ASTERIXDB-1308-1.plan
    • -32
    • +34
    ./results/udfs/query-ASTERIXDB-1308-2.plan
  1. … 16 more files in changeset.
ASTERIXDB-1343: support queries over nodegroup-based datasets.

Fixed operators to have the right NodeDomain.

Added several regerssion tests.

Change-Id: I776b80e5b824c83bcdf43c95fff99bb151506f84

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

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

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

    • -0
    • +87
    ./queries/query-ASTERIXDB-1343-2.aql
    • -0
    • +87
    ./queries/query-ASTERIXDB-1343-3.aql
    • -0
    • +94
    ./queries/query-ASTERIXDB-1343-4.aql
    • -0
    • +86
    ./queries/query-ASTERIXDB-1343.aql
    • -0
    • +39
    ./results/query-ASTERIXDB-1343-2.plan
    • -0
    • +39
    ./results/query-ASTERIXDB-1343-3.plan
    • -0
    • +46
    ./results/query-ASTERIXDB-1343-4.plan
    • -0
    • +39
    ./results/query-ASTERIXDB-1343.plan
  1. … 29 more files in changeset.
Support Change Feeds and Ingestion of Records with MetaData

This change allows feeds to perform upserts and deletes

in order to perform replication of an external data source.

The change does so by performing the following:

1. The adapter produces [PK][Record]. (Record == null --> delete)

2. The insert is replaced by an upsert operator.

Change-Id: If136a03d424970132dfb09f0dda56e160d4c0078

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

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

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

    • -4
    • +4
    ./results/disjunction-to-join-delete-3.plan
  1. … 270 more files in changeset.
use localfs instead of the class name of the adapter

Change-Id: If0c8fafbbc52bbe0f7ac3ec8b5f23781a8017390

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

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

Reviewed-by: abdullah alamoudi <bamousaa@gmail.com>

    • -1
    • +1
    ./queries/consolidate-selects-complex.aql
    • -1
    • +1
    ./queries/orders-index-search-conjunctive-open_01.aql
    • -1
    • +1
    ./queries/orders-index-search-conjunctive-open_02.aql
    • -1
    • +1
    ./queries/orders-index-search-conjunctive_01.aql
    • -1
    • +1
    ./queries/orders-index-search-conjunctive_02.aql
    • -1
    • +1
    ./queries/q01_pricing_summary_report_nt.aql
    • -1
    • +1
    ./queries/rtree-secondary-index-open.aql
    • -1
    • +1
    ./queries/scan-delete-rtree-secondary-index.aql
    • -1
    • +1
    ./queries_sqlpp/consolidate-selects-complex.sqlpp
    • -1
    • +1
    ./queries_sqlpp/orders-index-search-conjunctive-open_01.sqlpp
    • -1
    • +1
    ./queries_sqlpp/orders-index-search-conjunctive-open_02.sqlpp
  1. … 1136 more files in changeset.
ASTERIXDB-1168: use either primary key or generated id for decorrelation.

Change-Id: Ib5e232f3ba99018cd1aedfa4f8bb2f98affa0f55

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

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

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

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

    • -0
    • +33
    ./queries/query-ASTERIXDB-1168.aql
    • -1
    • +1
    ./queries/udfs/query-ASTERIXDB-1020.aql
    • -30
    • +34
    ./results/external-indexing/leftouterjoin-probe-sidx-with-join-btree-sidx_01.plan
    • -0
    • +31
    ./results/query-ASTERIXDB-1168.plan
    • -39
    • +37
    ./results/udfs/query-ASTERIXDB-1018.plan
    • -39
    • +37
    ./results/udfs/query-ASTERIXDB-1019.plan
    • -48
    • +43
    ./results/udfs/query-ASTERIXDB-1020.plan
  1. … 24 more files in changeset.
Revert "ASTERIXDB-1109: Fixed deletion of records from open secondary index"

This reverts commit a05f71826a4ab2c0e7148009e0b7e269b15e0a2f.

Change-Id: I8fcf41c009f9faf51bc8bccc0c3c7217b7769148

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

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

Reviewed-by: Ildar Absalyamov <ildar.absalyamov@gmail.com>

    • -6
    • +8
    ./results/disjunction-to-join-delete-1.plan
    • -13
    • +16
    ./results/disjunction-to-join-delete-2.plan
    • -12
    • +14
    ./results/disjunction-to-join-delete-3.plan
    • -5
    • +6
    ./results/scan-delete-rtree-secondary-index.plan
    • -5
    • +6
    ./results/skip-index/dont-skip-primary-index-search-in-delete.plan
    • -5
    • +7
    ./results/skip-index/skip-ngram-index-search-in-delete.plan
    • -5
    • +7
    ./results/skip-index/skip-rtree-index-search-in-delete.plan
    • -5
    • +7
    ./results/skip-index/skip-secondary-btree-index-search-in-delete.plan
  1. … 27 more files in changeset.
Added LeftOuterUnnestMap operator.

- Added LeftOuterUnnestMap operator to represent the left-outer-join semantics properly.

Change-Id: I6760319c2d3ff90c8b7d8ddeea3d9dd8f743366b

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

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

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

  1. … 17 more files in changeset.
ASTERIXDB-1127: regression tests.

Change-Id: Ie2d14acd87269ed2f8c28350d13f5510c68058ab

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

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

Reviewed-by: Pouria Pirzadeh <pouria.pirzadeh@gmail.com>

    • -0
    • +89
    ./queries/query-ASTERIXDB-1127.aql
    • -0
    • +74
    ./results/query-ASTERIXDB-1127.plan
    • -7
    • +8
    ./results/udfs/query-ASTERIXDB-1029.plan
    • -7
    • +8
    ./results/udfs/query-ASTERIXDB-1029_2.plan
  1. … 6 more files in changeset.
Supprt querying meta record with meta().

Change-Id: Ie65417b6baf209ca0ab413cfa4a5f7fc5156ca63

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

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

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

    • -0
    • +39
    ./queries/meta/primary_index_with_meta-1.aql
    • -0
    • +39
    ./queries/meta/primary_index_with_meta-2.aql
    • -0
    • +52
    ./queries/meta/primary_index_with_meta_index_join.aql
    • -0
    • +43
    ./queries/meta/primary_index_with_meta_self_index_join.aql
    • -0
    • +8
    ./results/meta/primary_index_with_meta-1.plan
    • -0
    • +8
    ./results/meta/primary_index_with_meta-2.plan
    • -0
    • +17
    ./results/meta/primary_index_with_meta_index_join.plan
    • -0
    • +17
    ./results/meta/primary_index_with_meta_self_index_join.plan
  1. … 57 more files in changeset.
ASTERIXDB-1325, ASTERIXDB-1326: fixed leftouterjoin on an external dataset

- Fixed the issue that optimizer ignores index_nl hint on an index on an external dataset.

- Fixed the issue that index-nested-loop-leftouterjoin on an external dataset returns an empty results.

- Modified OptimizerTest to enable mockup HDFSCluster.

- Added an optimizer test on an external dataset.

Change-Id: I91b2e57f0bd1beaa58dd28a84d8e08d308246b26

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

Reviewed-by: abdullah alamoudi <bamousaa@gmail.com>

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

    • -0
    • +69
    ./queries/external-indexing/leftouterjoin-probe-sidx-with-join-btree-sidx_01.aql
    • -0
    • +41
    ./results/external-indexing/leftouterjoin-probe-sidx-with-join-btree-sidx_01.plan
  1. … 4 more files in changeset.
ASTERIXDB-1322: fix the AQL translator and add tests.

Change-Id: I994bb69ca989c8c9e2ce417d62739a859e5ae94b

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

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

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

    • -0
    • +38
    ./queries/udfs/query-ASTERIXDB-1308-1.aql
    • -0
    • +66
    ./queries/udfs/query-ASTERIXDB-1308-2.aql
    • -0
    • +45
    ./results/udfs/query-ASTERIXDB-1308-1.plan
    • -0
    • +75
    ./results/udfs/query-ASTERIXDB-1308-2.plan
  1. … 10 more files in changeset.
ASTERIXDB-1205: fix union queries.

Fixed the AqlExpressionToPlanTranslator for union expression;

Eliminate shared operator references in translated logical plans;

Removed IntroduceUnionRule;

Fixed tuple source for SQL++ join clause;

Added regression tests.

Change-Id: Ib79a899ec4b35ece6f8f9f59b80126fed0c48851

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

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

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

    • -0
    • +40
    ./queries/union/query-ASTERIXDB-1047.aql
    • -0
    • +28
    ./queries/union/query-ASTERIXDB-1205-2.aql
    • -0
    • +25
    ./queries/union/query-ASTERIXDB-1205-3.aql
    • -0
    • +30
    ./queries/union/query-ASTERIXDB-1205-4.aql
    • -0
    • +29
    ./queries/union/query-ASTERIXDB-1205.aql
    • -0
    • +35
    ./queries/union/union_dataset.aql
    • -0
    • +33
    ./queries/union/union_dataset2.aql
    • -0
    • +35
    ./queries/union/union_dataset3.aql
    • -0
    • +41
    ./queries/union/union_query.aql
    • -5
    • +5
    ./results/q05_local_supplier_volume.plan
    • -131
    • +133
    ./results/split-materialization-above-join.plan
    • -0
    • +19
    ./results/union/query-ASTERIXDB-1047.plan
  1. … 58 more files in changeset.
Intersect the secondary indexes before primary search

Change-Id: Ie167918fb23e39c8728840e4a90c1b85bf1bde85

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

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

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

    • -0
    • +53
    ./queries/multi-indexes/btree-rtree-ngram-intersect.aql
    • -0
    • +50
    ./queries/multi-indexes/two-2nd-btree-intersect.aql
    • -0
    • +45
    ./queries/multi-indexes/two-inverted-index-intersect.aql
    • -0
    • +44
    ./queries/multi-indexes/two-rtree-intersect.aql
    • -0
    • +54
    ./queries/multi-indexes/with-primary-index-intersect.aql
    • -0
    • +37
    ./results/multi-indexes/btree-rtree-ngram-intersect.plan
    • -0
    • +28
    ./results/multi-indexes/two-2nd-btree-intersect.plan
    • -0
    • +26
    ./results/multi-indexes/two-inverted-index-intersect.plan
    • -0
    • +11
    ./results/multi-indexes/with-primary-index-intersect.plan
  1. … 18 more files in changeset.
Fix ASTERIXDB-1298

Handle the case that the original join operator in a subplan

operator is a left-outer join such that no null-check

variable needs to be added.

Change-Id: Ibb594e161d7236131a7a6a0a290e76071d4587f4

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

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

Reviewed-by: Steven Jacobs <sjaco002@ucr.edu>

    • -0
    • +49
    ./queries/udfs/query-ASTERIXDB-1298.aql
    • -0
    • +20
    ./results/udfs/query-ASTERIXDB-1298.plan
  1. … 6 more files in changeset.
ASTERIXDB-1157: Pushdown Limit

- Limit Pushdown into an Order (ExternalSort) operator.

- ConstantFoldingRule is not applied on the record-related operations.

Change-Id: I19aa4ce402b1834d9f68320acb72d7635a41a837

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

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

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

    • -0
    • +62
    ./queries/orderby_limit_01.aql
    • -0
    • +62
    ./queries/orderby_limit_offset_01.aql
    • -0
    • +62
    ./queries/orderby_limit_primary_index_01.aql
    • -0
    • +17
    ./results/btree-index/btree-primary-limit-orderby-01.plan
    • -0
    • +12
    ./results/btree-index/btree-primary-limit-orderby-02.plan
    • -1
    • +1
    ./results/inlined_q18_large_volume_customer.plan
    • -0
    • +17
    ./results/orderby_limit_01.plan
    • -0
    • +17
    ./results/orderby_limit_offset_01.plan
    • -0
    • +12
    ./results/orderby_limit_primary_index_01.plan
  1. … 26 more files in changeset.
Fix for ASTERIXDB-1291: added regression tests.

Change-Id: I1c8bbaf2522d421dff9a22af28c160f406dd2888

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

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

Reviewed-by: Wenhai Li <lwhaymail@yahoo.com>

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

    • -0
    • +84
    ./queries/gby_inline.aql
    • -0
    • +58
    ./results/gby_inline.plan
  1. … 8 more files in changeset.
Fixed ASTERIXDB-1249 and ASTERIXDB-1250: self index-nested-loop join correctly identifies the outer and the inner branch.

The first dataset becomes the outer branch.

The second dataset becomes the inner branch.

The optimizer for index-nested-loop join now only try to use an index from the inner branch.

Change-Id: I0d4291197c2bcfbcdcde998c5952af41960c4ad7

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

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

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

  1. … 260 more files in changeset.
ASTERIXDB-1005, ASTERIXDB-1263: Clean up subplan flattening: 1. Inline NestedTupleSource and remove SubplanOperator for special cases that join operators inside the SubplanOperator can be re-targeted for correlations; 2. Blindly inline NestedTupleSource and remove SubplanOperator for general cases where the condition of the special case is not met.

Change-Id: I4dd130a25f3c81272cc23f844ea20e376e990612

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

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

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

    • -0
    • +79
    ./queries/nested_loj4.aql
    • -0
    • +59
    ./queries/query-ASTERIXDB-1005.aql
    • -0
    • +53
    ./queries/query-ASTERIXDB-1263.aql
    • -33
    • +30
    ./results/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01.plan
    • -33
    • +30
    ./results/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02.plan
    • -71
    • +68
    ./results/inverted-index-join/leftouterjoin-probe-pidx-with-join-edit-distance-check-idx_01.plan
    • -45
    • +42
    ./results/inverted-index-join/leftouterjoin-probe-pidx-with-join-jaccard-check-idx_01.plan
  1. … 70 more files in changeset.
Fix for ASTERIXDB-1018, ASTERIXDB-1017, ASTERIXDB-1019, ASTERIXDB-1020, ASTERIXDB-1029, ASTERIXDB-1030, ASTERIXDB-1034

1. Inline SubplanOperator input and hence remove SubplanOperator.

2. Use boolean return from initFromSubTree to confirm that the

result should actually be used in IntroduceJoinAccessMethodRule

Prevent accidental attempted cast of null variable

in AbstractIntroduceAccessMethodrule.

Change-Id: Ifc1f844ac6e06e00da3f1618235b6ce9bfd48e9f

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

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

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

    • -0
    • +63
    ./queries/udfs/query-ASTERIXDB-1017-2.aql
    • -0
    • +66
    ./queries/udfs/query-ASTERIXDB-1017-recursive-2.aql
    • -0
    • +66
    ./queries/udfs/query-ASTERIXDB-1017-recursive.aql
    • -0
    • +69
    ./queries/udfs/query-ASTERIXDB-1017.aql
    • -0
    • +63
    ./queries/udfs/query-ASTERIXDB-1018.aql
    • -0
    • +75
    ./queries/udfs/query-ASTERIXDB-1019.aql
    • -0
    • +61
    ./queries/udfs/query-ASTERIXDB-1020.aql
    • -0
    • +66
    ./queries/udfs/query-ASTERIXDB-1029.aql
    • -0
    • +66
    ./queries/udfs/query-ASTERIXDB-1029_2.aql
    • -0
    • +46
    ./queries/udfs/query-ASTERIXDB-1030_1034.aql
    • -0
    • +46
    ./queries/udfs/query-ASTERIXDB-1030_1034_2.aql
    • -0
    • +69
    ./results/udfs/query-ASTERIXDB-1017-2.plan
    • -0
    • +69
    ./results/udfs/query-ASTERIXDB-1017-recursive-2.plan
    • -0
    • +76
    ./results/udfs/query-ASTERIXDB-1017-recursive.plan
    • -0
    • +67
    ./results/udfs/query-ASTERIXDB-1017.plan
  1. … 22 more files in changeset.
Run ExecutionTest w/integration test framework

I changed the default local.xml to use 2 NCs with

2 partitions each like AsterixHyracksIntegrationUtil

so that the results will match despite using simple

string compare to determine correctness.

There is also one test in particular (big-object-join)

that I had to add an artificial order by clause to

to deal with different results.

Issues outstanding:

- HDFS in ClusterExecutionIT needs to be thought out

Change-Id: I423f2a7c77839b999d466dd5cace302574d956c0

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

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

Reviewed-by: Chris Hillery <ceej@lambda.nu>

    • -1
    • +1
    ./queries/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01.aql
    • -1
    • +1
    ./queries/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02.aql
  1. … 3852 more files in changeset.
patch 1

  1. … 86 more files in changeset.
ASTERIXDB-1109: Fixed deletion of records from open secondary index - Avoided creating calling record constructor in delete pipeline - Fixed the case when multiple open indexes enforce the type of the same field & covered it with tests

Change-Id: I41bde91401f67918365de7df19dd2f0de20c73d2

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

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

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

    • -8
    • +6
    ./results/disjunction-to-join-delete-1.plan
    • -16
    • +13
    ./results/disjunction-to-join-delete-2.plan
    • -14
    • +12
    ./results/disjunction-to-join-delete-3.plan
    • -6
    • +5
    ./results/scan-delete-rtree-secondary-index.plan
    • -6
    • +5
    ./results/skip-index/dont-skip-primary-index-search-in-delete.plan
    • -7
    • +5
    ./results/skip-index/skip-ngram-index-search-in-delete.plan
    • -7
    • +5
    ./results/skip-index/skip-rtree-index-search-in-delete.plan
    • -7
    • +5
    ./results/skip-index/skip-secondary-btree-index-search-in-delete.plan
  1. … 28 more files in changeset.
SQL++ support in AsterixDB: 1. implemented SQL++ expression to logical plan translator; 2. refactored REST API to be agnostic of query languages; 3. disabled fuzzy join queries for SQL++ runtime tests; 4. fixed several rewriting rules.

Change-Id: I82919c4527b304325059519d819a2c30cf2902a9

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

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

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

    • -8
    • +6
    ./results/disjunction-to-join-delete-1.plan
    • -15
    • +12
    ./results/disjunction-to-join-delete-2.plan
    • -14
    • +12
    ./results/disjunction-to-join-delete-3.plan
    • -6
    • +5
    ./results/scan-delete-rtree-secondary-index.plan
    • -6
    • +5
    ./results/skip-index/dont-skip-primary-index-search-in-delete.plan
    • -7
    • +5
    ./results/skip-index/skip-ngram-index-search-in-delete.plan
    • -7
    • +5
    ./results/skip-index/skip-rtree-index-search-in-delete.plan
    • -7
    • +5
    ./results/skip-index/skip-secondary-btree-index-search-in-delete.plan
    • -2
    • +2
    ./results_parser_sqlpp/consolidate-selects-complex.ast
    • -4
    • +1
    ./results_parser_sqlpp/const-folding.ast
  1. … 1365 more files in changeset.
SQL++ parser: 1. refactored asterix-aql to become asterix-lang-common and asterix-lang-aql, where the former is the common part for different languages; 2. added asterix-lang-sqlpp on top of asterix-lang-common; 3. ported parser tests, optimizer tests and runtime tests in asterix-app to their sql++ version, and added parser tests for all the queries.

Change-Id: Ie5af4e3b692ca017ec047a1ba3b404a51beb3a2e

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

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

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

    • -1
    • +1
    ./queries/skip-index/skip-ngram-index.aql
    • -0
    • +74
    ./queries_sqlpp/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01.sqlpp
    • -0
    • +74
    ./queries_sqlpp/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02.sqlpp
    • -0
    • +45
    ./queries_sqlpp/btree-index-join/primary-composite-key-join_01.sqlpp
    • -0
    • +45
    ./queries_sqlpp/btree-index-join/primary-composite-key-join_02.sqlpp
    • -0
    • +45
    ./queries_sqlpp/btree-index-join/primary-composite-key-join_03.sqlpp
    • -0
    • +45
    ./queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_01.sqlpp
    • -0
    • +45
    ./queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_02.sqlpp
    • -0
    • +45
    ./queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_03.sqlpp
    • -0
    • +45
    ./queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_04.sqlpp
    • -0
    • +45
    ./queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_05.sqlpp
    • -0
    • +45
    ./queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_06.sqlpp
    • -0
    • +73
    ./queries_sqlpp/btree-index-join/primary-equi-join-multipred.sqlpp
    • -0
    • +46
    ./queries_sqlpp/btree-index-join/primary-equi-join-neg_01.sqlpp
    • -0
    • +46
    ./queries_sqlpp/btree-index-join/primary-equi-join-neg_02.sqlpp
  1. … 10209 more files in changeset.
Convert comparisons with current-datetime, current-date, and current-time to applicable index searches as though they were constants

Change-Id: Ied64276873afcfbdd31dac313009e47429d8f9b0

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

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

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

    • -0
    • +43
    ./queries/btree-index/btree-datetime-01.aql
    • -0
    • +42
    ./queries/btree-index/btree-datetime-02.aql
    • -0
    • +41
    ./queries/btree-index/btree-datetime-03.aql
    • -0
    • +40
    ./queries/btree-index/btree-datetime-04.aql
    • -0
    • +11
    ./results/btree-index/btree-datetime-01.plan
    • -0
    • +8
    ./results/btree-index/btree-datetime-02.plan
    • -0
    • +8
    ./results/btree-index/btree-datetime-03.plan
    • -0
    • +8
    ./results/btree-index/btree-datetime-04.plan
  1. … 11 more files in changeset.
ASTERIXDB-221: reduce unneceesary partitioning for hash joins.

Fixed broken optimizer tests

Change-Id: I0c8b4208c095d95e06357af6d2e9e465c74dec19

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

Reviewed-by: Ian Maxon <imaxon@apache.org>

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

  1. … 1 more file in changeset.