Clone Tools
  • last updated a few minutes ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Move merged files

    • -51
    • +0
    ./global-aggregate/q01/q01.1.ddl.sqlpp
    • -30
    • +0
    ./global-aggregate/q01/q01.2.update.sqlpp
    • -23
    • +0
    ./global-aggregate/q01/q01.3.query.sqlpp
    • -51
    • +0
    ./global-aggregate/q02/q02.1.ddl.sqlpp
    • -30
    • +0
    ./global-aggregate/q02/q02.2.update.sqlpp
    • -23
    • +0
    ./global-aggregate/q02/q02.3.query.sqlpp
    • -51
    • +0
    ./global-aggregate/q03/q03.1.ddl.sqlpp
    • -30
    • +0
    ./global-aggregate/q03/q03.2.update.sqlpp
    • -23
    • +0
    ./global-aggregate/q03/q03.3.query.sqlpp
    • -51
    • +0
    ./global-aggregate/q04/q04.1.ddl.sqlpp
    • -30
    • +0
    ./global-aggregate/q04/q04.2.update.sqlpp
    • -23
    • +0
    ./global-aggregate/q04/q04.3.query.sqlpp
    • -30
    • +0
    ./global-aggregate/q05_error/q05_error.2.update.sqlpp
  1. … 149 more files in changeset.
ASTERIXDB-1388: fix typos in test queries

Change-Id: Id60d7a6a383010e4930b491a7fb066efbea6e985

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

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

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

    • -1
    • +1
    ./global-aggregate/q01/q01.3.query.sqlpp
    • -1
    • +1
    ./global-aggregate/q02/q02.3.query.sqlpp
    • -2
    • +3
    ./global-aggregate/q08/q08.3.query.sqlpp
  1. … 1 more file in changeset.
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>

  1. … 437 more files in changeset.
ASTERIXDB-1360 Fix Error Message for Unknown Format

This change includes some refactoring for external

data. This refactoring makes the code less error prone

and separate data source selection from data parser

selection. It also fixes issue ASTERIXDB-1366 and adds

a test case for it as well.

Change-Id: Ib4aac833e30bd7c5a7706f5c8116383c2362c964

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

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

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

  1. … 33 more files in changeset.
Move AsterixDB to Subfolder

  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>

    • -0
    • +29
    ./group-by/core-01/core-01.1.ddl.sqlpp
    • -0
    • +32
    ./group-by/core-01/core-01.2.update.sqlpp
    • -0
    • +29
    ./group-by/core-01/core-01.3.query.sqlpp
    • -0
    • +40
    ./group-by/core-02/core-02.1.ddl.sqlpp
    • -0
    • +42
    ./group-by/core-02/core-02.2.update.sqlpp
    • -0
    • +30
    ./group-by/core-02/core-02.3.query.sqlpp
    • -0
    • +40
    ./group-by/core-03/core-02.1.ddl.sqlpp
    • -0
    • +42
    ./group-by/core-03/core-02.2.update.sqlpp
    • -0
    • +40
    ./group-by/core-03/core-02.3.query.sqlpp
    • -0
    • +40
    ./group-by/core-04/core-04.1.ddl.sqlpp
    • -0
    • +55
    ./group-by/core-04/core-04.2.update.sqlpp
    • -0
    • +38
    ./group-by/core-04/core-04.3.query.sqlpp
    • -0
    • +35
    ./group-by/core-05/core-05.1.ddl.sqlpp
    • -0
    • +59
    ./group-by/core-05/core-05.2.update.sqlpp
    • -0
    • +47
    ./group-by/core-05/core-05.3.query.sqlpp
  1. … 1949 more files in changeset.
Add "collection" as a synonym to "table" in SQL++.

Change-Id: I95f87a1b6e8365f2148afdfb86f942a5dfef0dc9

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

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

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

  1. … 43 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>

  1. … 33 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>

  1. … 256 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. … 1136 more files in changeset.
ASTERIXDB-1128: add TPC-H queries with secondary indices into build tests.

Change-Id: I4237ca17d5e334959a320ed92fcdccf51cc4856d

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

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

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

    • -0
    • +52
    ./tpch-with-index/distinct_by/distinct_by.1.ddl.sqlpp
    • -0
    • +24
    ./tpch-with-index/distinct_by/distinct_by.2.update.sqlpp
    • -0
    • +26
    ./tpch-with-index/distinct_by/distinct_by.3.query.sqlpp
    • -0
    • +99
    ./tpch-with-index/nest_aggregate/nest_aggregate.1.ddl.sqlpp
    • -0
    • +40
    ./tpch-with-index/nest_aggregate/nest_aggregate.2.update.sqlpp
    • -0
    • +46
    ./tpch-with-index/nest_aggregate/nest_aggregate.3.query.sqlpp
    • -0
    • +99
    ./tpch-with-index/nest_aggregate2/nest_aggregate2.1.ddl.sqlpp
    • -0
    • +40
    ./tpch-with-index/nest_aggregate2/nest_aggregate2.2.update.sqlpp
    • -0
    • +46
    ./tpch-with-index/nest_aggregate2/nest_aggregate2.3.query.sqlpp
  1. … 135 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>

  1. … 22 more files in changeset.
interval test was merge correctly.

  1. … 2 more files in changeset.
ASTERIXDB-1331: fix the type computer for string-length.

Change-Id: Ia21a29049364bd2f99bfd766efdd1518aeffe79f

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

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

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

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

    • -0
    • +28
    ./tinysocial/tinysocial-suite/tinysocial-suite.25.query.sqlpp
  1. … 5 more files in changeset.
ASTERIXDB-1329: fix substring type computer for arguments with ANY type.

Added a TinySocial test suite for open datasets.

Change-Id: I23b7d2865cf0bc58b9f402ea602969b326d46d93

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

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

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

  1. … 60 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
    • +1
    ./custord/join_q_04/join_q_04.1.ddl.sqlpp
    • -0
    • +61
    ./custord/join_q_05/join_q_05.1.ddl.sqlpp
    • -0
    • +20
    ./custord/join_q_05/join_q_05.2.update.sqlpp
    • -0
    • +31
    ./custord/join_q_05/join_q_05.3.query.sqlpp
    • -0
    • +47
    ./custord/join_q_06/join_q_06.1.ddl.sqlpp
    • -0
    • +20
    ./custord/join_q_06/join_q_06.2.update.sqlpp
    • -0
    • +30
    ./custord/join_q_06/join_q_06.3.query.sqlpp
    • -0
    • +47
    ./custord/join_q_07/join_q_07.1.ddl.sqlpp
    • -0
    • +20
    ./custord/join_q_07/join_q_07.2.update.sqlpp
    • -0
    • +35
    ./custord/join_q_07/join_q_07.3.query.sqlpp
  1. … 63 more files in changeset.
Fix ASTERIXDB-1292

Change-Id: Iee8e9b87145d9b3511874cd11d61ae87acdc94c7

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

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

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

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

    • -1
    • +1
    ./temporal/parse_02/parse_02.3.query.sqlpp
  1. … 4 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
    • +55
    ./subquery/gby_inline/gby_inline.1.ddl.sqlpp
    • -0
    • +18
    ./subquery/gby_inline/gby_inline.2.update.sqlpp
    • -0
    • +32
    ./subquery/gby_inline/gby_inline.3.query.sqlpp
  1. … 7 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. … 271 more files in changeset.
ASTERIXDB-1281 - Interval format update to AQL and ADM

The new interval format takes a more generic approach to representing intervals.

Here is an example for a date interval:

interval(date("2012-01-01”), date(”2013-04-01”))

Note that the interval type is defined by the arguments to the interval expression.

Currently only date, time, and datetime types are supported for intervals. The new

format is used for ADM and AQL.

In addition to the format change, the internal byte structure of an interval has been

updated. The format looks like the following:

byte tag, T start, T end (where T is a date, time or datetime type)

Note how the tag has been moved to the front. Also with the new sturcture, an

interval is variable length, not fixed length as before.

Change-Id: I009c71b7a445d141e228ba15d56d0b6cf3c8a3f5

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

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

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

  1. … 63 more files in changeset.
Some exception cleanup

- Use HyracksDataException and IOException for errors ingesting external

data (instead of a mixture of AlgebricksException, AsterixException, and

HyracksDataException).

- Avoid unnecessary wrapping of exceptions.

- Wrap exception at boundaries (e.g. HiveRecordParser)

- ADMLexerException and ADMDataParser.ParseException extend

HyracksDataException

- Tighter exception declarations and handling for internal methods.

Change-Id: Icf9591046c44f5fa2281874ff0c98d780e741267

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

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

Reviewed-by: Murtadha Hubail <hubailmor@gmail.com>

  1. … 64 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
    • +30
    ./tinysocial/tinysocial-suite/query-ASTERIXDB-1063.23.query.sqlpp
  1. … 78 more files in changeset.
ASTERIXDB-1258, ASTERIXDB-1259: fix test queries.

Change-Id: I6b3a7d26a1931e4ec146e243f2b89d2586996b75

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

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

Reviewed-by: Murtadha Hubail <hubailmor@gmail.com>

  1. … 1 more file in changeset.
Enabled Datasets to use Datatypes from foreign Dataverses

Removed broken Metadata Secondary Indexes

Added DatatypeDataverse field to Dataset

Cleaned up Metadata Tests

Added tests for dropping used Datatypes

User-facing changes are:

1) Allow qualified datatype when creating dataset

2) Metadata queries for datasets will now

include the type dataverse

Change-Id: I24dbc04dcb2a4126fc8361ebe3104877a0d1f2bb

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

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

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

  1. … 136 more files in changeset.
Improve the Testing Framework

This change includes the following improvements to the test framework

1. Checking each expected failure against the failure exception.

2. Checking against multiple causes of failure in case of multiple

expected errors.

3. Check if a test that is expected to fail pass.

4. Make temp datasets use different storage path.

Change-Id: I957ecf19bf7209981e010e0e50fb882442a525dd

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

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

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

  1. … 23 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>

  1. … 36 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. … 3852 more files in changeset.
ASTERIXDB-1159: make ARecordType read-only and separate its mutable state to RuntimeRecordTypeInfo.

Change-Id: Ibbfa73907ae9422a4ad85dc4db5fa568855beb17

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

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

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

  1. … 21 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>

    • -1
    • +1
    ./aggregate/droptype/droptype.1.ddl.sqlpp
  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>

    • -0
    • +24
    ./aggregate-sql/agg_null/agg_null.1.ddl.sqlpp
    • -0
    • +19
    ./aggregate-sql/agg_null/agg_null.2.update.sqlpp
    • -0
    • +25
    ./aggregate-sql/agg_null/agg_null.3.query.sqlpp
    • -0
    • +38
    ./aggregate-sql/agg_null_rec/agg_null_rec.1.ddl.sqlpp
    • -0
    • +33
    ./aggregate-sql/agg_null_rec/agg_null_rec.2.update.sqlpp
    • -0
    • +43
    ./aggregate-sql/agg_null_rec/agg_null_rec.3.query.sqlpp
    • -0
    • +38
    ./aggregate-sql/agg_null_rec_1/agg_null_rec_1.1.ddl.sqlpp
    • -0
    • +33
    ./aggregate-sql/agg_null_rec_1/agg_null_rec_1.2.update.sqlpp
    • -0
    • +55
    ./aggregate-sql/agg_null_rec_1/agg_null_rec_1.3.query.sqlpp
    • -0
    • +24
    ./aggregate-sql/agg_number/agg_number.1.ddl.sqlpp
    • -0
    • +19
    ./aggregate-sql/agg_number/agg_number.2.update.sqlpp
    • -0
    • +25
    ./aggregate-sql/agg_number/agg_number.3.query.sqlpp
    • -0
    • +38
    ./aggregate-sql/agg_number_rec/agg_number_rec.1.ddl.sqlpp
    • -0
    • +33
    ./aggregate-sql/agg_number_rec/agg_number_rec.2.update.sqlpp
    • -0
    • +43
    ./aggregate-sql/agg_number_rec/agg_number_rec.3.query.sqlpp
  1. … 10209 more files in changeset.