Clone Tools
  • last updated 26 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>

    • -1
    • +1
    ./overlap_bins_gby_1/overlap_bins_gby_1.3.query.sqlpp
    • -2
    • +2
    ./overlap_bins_gby_3/overlap_bins_gby_3.3.query.sqlpp
  1. … 448 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
    ./insert_from_delimited_ds/insert_from_delimited_ds.2.update.sqlpp
    • -1
    • +1
    ./insert_from_ext_ds/insert_from_ext_ds.1.ddl.sqlpp
  1. … 1149 more files in changeset.
interval test was merge correctly.

    • -3
    • +3
    ./interval_functions/interval_functions.3.query.sqlpp
  1. … 2 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. … 4 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
    • +6
    ./accessors_interval/accessors_interval.3.query.sqlpp
    • -1
    • +3
    ./duration_functions/duration_functions.3.query.sqlpp
    • -1
    • +6
    ./get_overlapping_interval/get_overlapping_interval.3.query.sqlpp
    • -14
    • +14
    ./interval_functions/interval_functions.3.query.sqlpp
    • -1
    • +4
    ./overlap_bins/overlap_bins.3.query.sqlpp
    • -1
    • +1
    ./overlap_bins_gby_3/overlap_bins_gby_3.3.query.sqlpp
  1. … 66 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
    ./insert_from_delimited_ds/insert_from_delimited_ds.2.update.sqlpp
    • -1
    • +1
    ./insert_from_ext_ds/insert_from_ext_ds.1.ddl.sqlpp
    • -1
    • +1
    ./insert_from_ext_ds_2/insert_from_ext_ds_2.2.update.sqlpp
  1. … 3864 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>

    • -12
    • +12
    ./interval_bin_gby_0/interval_bin_gby_0.2.update.sqlpp
    • -3
    • +53
    ./interval_functions/interval_functions.3.query.sqlpp
    • -4
    • +4
    ./overlap_bins_gby_0/overlap_bins_gby_0.3.query.sqlpp
  1. … 1377 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
    • +22
    ./accessors/accessors.1.ddl.sqlpp
    • -0
    • +19
    ./accessors/accessors.2.update.sqlpp
    • -0
    • +23
    ./accessors/accessors.3.query.sqlpp
    • -0
    • +22
    ./accessors_interval/accessors_interval.1.ddl.sqlpp
    • -0
    • +19
    ./accessors_interval/accessors_interval.2.update.sqlpp
    • -0
    • +23
    ./accessors_interval/accessors_interval.3.query.sqlpp
    • -0
    • +22
    ./accessors_interval_null/accessors_interval_null.1.ddl.sqlpp
    • -0
    • +19
    ./accessors_interval_null/accessors_interval_null.2.update.sqlpp
    • -0
    • +23
    ./accessors_interval_null/accessors_interval_null.3.query.sqlpp
    • -0
    • +27
    ./adjust_timezone/adjust_timezone.1.ddl.sqlpp
    • -0
    • +19
    ./adjust_timezone/adjust_timezone.2.update.sqlpp
    • -0
    • +23
    ./adjust_timezone/adjust_timezone.3.query.sqlpp
    • -0
    • +37
    ./agg_max/agg_max.1.ddl.sqlpp
    • -0
    • +28
    ./agg_max/agg_max.2.update.sqlpp
    • -0
    • +38
    ./agg_max/agg_max.3.query.sqlpp
  1. … 10209 more files in changeset.