Clone Tools
  • last updated 20 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
patch 5

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

    • -3
    • +3
    ./accessors_interval/accessors_interval.3.query.aql
    • -3
    • +3
    ./duration_functions/duration_functions.3.query.aql
    • -6
    • +6
    ./get_overlapping_interval/get_overlapping_interval.3.query.aql
    • -14
    • +14
    ./interval_functions/interval_functions.3.query.aql
    • -3
    • +3
    ./overlap_bins/overlap_bins.3.query.aql
    • -1
    • +1
    ./overlap_bins_gby_3/overlap_bins_gby_3.3.query.aql
  1. … 66 more files in changeset.
patch 3

    • -0
    • +32
    ./interval_joins/interval_before/interval_before.13.query.aql
    • -0
    • +32
    ./interval_joins/interval_before/interval_before.14.query.aql
    • -0
    • +32
    ./interval_joins/interval_before/interval_before.15.query.aql
    • -0
    • +32
    ./interval_joins/interval_before/interval_before.16.query.aql
    • -0
    • +32
    ./interval_joins/interval_covers/interval_covers.13.query.aql
    • -0
    • +32
    ./interval_joins/interval_covers/interval_covers.14.query.aql
    • -0
    • +32
    ./interval_joins/interval_covers/interval_covers.15.query.aql
    • -0
    • +32
    ./interval_joins/interval_covers/interval_covers.16.query.aql
    • -0
    • +32
    ./interval_joins/interval_ends/interval_ends.13.query.aql
    • -0
    • +32
    ./interval_joins/interval_ends/interval_ends.14.query.aql
    • -0
    • +32
    ./interval_joins/interval_ends/interval_ends.15.query.aql
    • -0
    • +32
    ./interval_joins/interval_ends/interval_ends.16.query.aql
    • -0
    • +32
    ./interval_joins/interval_meets/interval_meets.13.query.aql
    • -0
    • +32
    ./interval_joins/interval_meets/interval_meets.14.query.aql
    • -0
    • +32
    ./interval_joins/interval_meets/interval_meets.15.query.aql
  1. … 83 more files in changeset.
patch 2

    • -0
    • +44
    ./interval_joins/interval_before/interval_before.1.ddl.aql
    • -0
    • +32
    ./interval_joins/interval_before/interval_before.10.query.aql
    • -0
    • +32
    ./interval_joins/interval_before/interval_before.11.query.aql
    • -0
    • +32
    ./interval_joins/interval_before/interval_before.12.query.aql
    • -0
    • +31
    ./interval_joins/interval_before/interval_before.2.update.aql
    • -0
    • +32
    ./interval_joins/interval_before/interval_before.3.query.aql
    • -0
    • +32
    ./interval_joins/interval_before/interval_before.4.query.aql
    • -0
    • +32
    ./interval_joins/interval_before/interval_before.5.query.aql
    • -0
    • +32
    ./interval_joins/interval_before/interval_before.6.query.aql
    • -0
    • +32
    ./interval_joins/interval_before/interval_before.7.query.aql
    • -0
    • +32
    ./interval_joins/interval_before/interval_before.8.query.aql
    • -0
    • +32
    ./interval_joins/interval_before/interval_before.9.query.aql
    • -0
    • +32
    ./interval_joins/interval_covers/interval_covers.10.query.aql
    • -0
    • +32
    ./interval_joins/interval_covers/interval_covers.11.query.aql
  1. … 141 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.aql
    • -1
    • +1
    ./insert_from_ext_ds/insert_from_ext_ds.1.ddl.aql
    • -1
    • +1
    ./insert_from_ext_ds_2/insert_from_ext_ds_2.2.update.aql
  1. … 3864 more files in changeset.
patch 1

    • -0
    • +166
    ./TemporalQueries.xml
    • -26
    • +0
    ./interval_functions/interval_functions.1.ddl.aql
    • -0
    • +69
    ./interval_functions/interval_functions.1.query.aql
    • -18
    • +0
    ./interval_functions/interval_functions.2.update.aql
    • -71
    • +0
    ./interval_functions/interval_functions.3.query.aql
    • -0
    • +44
    ./interval_joins/interval_covers/interval_covers.1.ddl.aql
    • -0
    • +31
    ./interval_joins/interval_covers/interval_covers.2.update.aql
    • -0
    • +32
    ./interval_joins/interval_covers/interval_covers.3.query.aql
    • -0
    • +32
    ./interval_joins/interval_covers/interval_covers.4.query.aql
    • -0
    • +32
    ./interval_joins/interval_covers/interval_covers.5.query.aql
    • -0
    • +32
    ./interval_joins/interval_covers/interval_covers.6.query.aql
    • -0
    • +32
    ./interval_joins/interval_covers/interval_covers.7.query.aql
    • -0
    • +32
    ./interval_joins/interval_covers/interval_covers.8.query.aql
    • -0
    • +31
    ./interval_joins/interval_overlapping/interval_overlapping.2.update.aql
  1. … 75 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>

    • -0
    • +1
    ./overlap_bins_gby_0/overlap_bins_gby_0.3.query.aql
  1. … 1379 more files in changeset.
ASTERIXDB-1113, Add ASF license header to AQL files

Change-Id: I462cb156b5cd8507ac0625d4a40863ec9383ce82

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

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

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

    • -1
    • +19
    ./accessors_interval/accessors_interval.1.ddl.aql
    • -0
    • +18
    ./accessors_interval/accessors_interval.2.update.aql
    • -1
    • +19
    ./accessors_interval/accessors_interval.3.query.aql
    • -1
    • +19
    ./accessors_interval_null/accessors_interval_null.1.ddl.aql
    • -0
    • +18
    ./accessors_interval_null/accessors_interval_null.2.update.aql
    • -1
    • +19
    ./accessors_interval_null/accessors_interval_null.3.query.aql
    • -1
    • +19
    ./adjust_timezone/adjust_timezone.1.ddl.aql
    • -0
    • +18
    ./adjust_timezone/adjust_timezone.2.update.aql
    • -1
    • +19
    ./adjust_timezone/adjust_timezone.3.query.aql
  1. … 5758 more files in changeset.
Change Java package from edu.uci.ics to org.apache

Change-Id: I2f01d2b5614e9e9c94fda4bf1294a8eba6a26c54

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

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

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

    • -1
    • +1
    ./insert_from_delimited_ds/insert_from_delimited_ds.2.update.aql
    • -1
    • +1
    ./insert_from_ext_ds/insert_from_ext_ds.1.ddl.aql
  1. … 2603 more files in changeset.
Temporal update based on a merge from an old branch.

Includes the following new functions: overlap-bins, get-overlapping-interval, get-interval-start-date, get-interval-start-datetime, get-interval-start-time, get-interval-end-date, get-interval-end-datetime, get-interval-end-time

Change-Id: Ie15ed39ae7de83ce71c63c4e7490f2ebf5911540

Reviewed-on: http://fulliautomatix.ics.uci.edu:8443/244

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

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

    • -0
    • +15
    ./agg_max/agg_max.1.ddl.aql
    • -0
    • +5
    ./agg_max/agg_max.2.update.aql
    • -0
    • +8
    ./agg_max/agg_max.3.query.aql
    • -0
    • +15
    ./agg_min/agg_min.1.ddl.aql
    • -0
    • +5
    ./agg_min/agg_min.2.update.aql
    • -0
    • +8
    ./agg_min/agg_min.3.query.aql
    • -0
    • +8
    ./duration_functions/duration_functions.1.ddl.aql
    • -0
    • +0
    ./duration_functions/duration_functions.2.update.aql
    • -0
    • +16
    ./duration_functions/duration_functions.3.query.aql
    • -0
    • +0
    ./get_overlapping_interval/get_overlapping_interval.1.ddl.aql
    • -0
    • +0
    ./get_overlapping_interval/get_overlapping_interval.2.update.aql
    • -0
    • +11
    ./get_overlapping_interval/get_overlapping_interval.3.query.aql
    • -0
    • +4
    ./overlap_bins/overlap_bins.1.ddl.aql
    • -0
    • +4
    ./overlap_bins/overlap_bins.2.update.aql
  1. … 94 more files in changeset.
- Fixed Type Casting issue - Reorganized duplicated internal class in the DelimitedDataParser and DelimitedDataParserFactory - Prevented a user from creating an inverted index on a dataset with a variable-length PK - INT64 is now the default type - Issue 852 fixed

Change-Id: I2d71e8a21da4f709c3259a3d3f678c640f9e1160

Reviewed-on: http://fulliautomatix.ics.uci.edu:8443/192

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

Reviewed-by: Till Westmann <westmann@gmail.com>

    • -1
    • +1
    ./interval_bin_gby_0/interval_bin_gby_0.1.ddl.aql
    • -1
    • +1
    ./interval_bin_gby_1/interval_bin_gby_1.1.ddl.aql
  1. … 846 more files in changeset.
Add function for converting unix time in seconds

Change-Id: I96e3b81493058a26787c476a0c6d252e1f6b39a0

Reviewed-on: http://fulliautomatix.ics.uci.edu:8443/224

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

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

    • -1
    • +3
    ./datetime_functions/datetime_functions.3.query.aql
  1. … 5 more files in changeset.
added support for day-of-week and skip in temporal parser

  1. … 2 more files in changeset.
checkpoint: Updated the format-based temporal parsers to support multiple format options; added comments for the parsing class.

  1. … 6 more files in changeset.
checkpoint: added format-based printers for temporal types.

    • -0
    • +7
    ./parse_02/parse_02.1.ddl.aql
    • -0
    • +4
    ./parse_02/parse_02.2.update.aql
    • -0
    • +20
    ./parse_02/parse_02.3.query.aql
  1. … 7 more files in changeset.
checkpoint: added format-based parser; updated the internal representation of timezone field.

    • -0
    • +7
    ./parse_01/parse_01.1.ddl.aql
    • -0
    • +4
    ./parse_01/parse_01.2.update.aql
    • -0
    • +10
    ./parse_01/parse_01.3.query.aql
  1. … 10 more files in changeset.
added day-of-week function

    • -0
    • +7
    ./day_of_week_01/day_of_week_01.1.ddl.aql
    • -0
    • +4
    ./day_of_week_01/day_of_week_01.2.update.aql
    • -0
    • +12
    ./day_of_week_01/day_of_week_01.3.query.aql
  1. … 5 more files in changeset.
added interval-bin function with test cases for issue 546

    • -0
    • +7
    ./interval_bin/interval_bin.1.ddl.aql
    • -0
    • +4
    ./interval_bin/interval_bin.2.update.aql
    • -0
    • +19
    ./interval_bin/interval_bin.3.query.aql
    • -0
    • +16
    ./interval_bin_gby_0/interval_bin_gby_0.1.ddl.aql
    • -0
    • +18
    ./interval_bin_gby_0/interval_bin_gby_0.2.update.aql
    • -0
    • +11
    ./interval_bin_gby_0/interval_bin_gby_0.3.query.aql
    • -0
    • +16
    ./interval_bin_gby_1/interval_bin_gby_1.1.ddl.aql
    • -0
    • +18
    ./interval_bin_gby_1/interval_bin_gby_1.2.update.aql
    • -0
    • +11
    ./interval_bin_gby_1/interval_bin_gby_1.3.query.aql
  1. … 19 more files in changeset.
checkpoint 513#1: fixed temporal arthmetic operations to use symobl-based operations instead of functions.

    • -16
    • +16
    ./calendar_duration/calendar_duration.3.query.aql
    • -10
    • +10
    ./date_functions/date_functions.3.query.aql
    • -7
    • +7
    ./datetime_functions/datetime_functions.3.query.aql
    • -12
    • +12
    ./time_functions/time_functions.3.query.aql
  1. … 32 more files in changeset.
addressed Jimah's comments on un-synced function names

    • -3
    • +3
    ./date_functions/date_functions.3.query.aql
    • -3
    • +3
    ./interval_functions/interval_functions.3.query.aql
    • -3
    • +3
    ./time_functions/time_functions.3.query.aql
  1. … 41 more files in changeset.
fixed an issue reported by Steven on temporal loading issue; rewrote the printers to share the print code

    • -0
    • +25
    ./insert_from_ext_ds_2/insert_from_ext_ds_2.1.ddl.aql
    • -0
    • +4
    ./insert_from_ext_ds_2/insert_from_ext_ds_2.2.update.aql
    • -0
    • +5
    ./insert_from_ext_ds_2/insert_from_ext_ds_2.3.query.aql
  1. … 14 more files in changeset.
merge from master

    • -2
    • +2
    ./duration_comps/duration_comps.3.query.aql
  1. … 6 more files in changeset.
fixed issue 376 Need to classify and properly treat all built-in functions in AQL

    • -0
    • +1
    ./calendar_duration/calendar_duration.3.query.aql
    • -1
    • +2
    ./date_functions/date_functions.3.query.aql
    • -0
    • +1
    ./datetime_functions/datetime_functions.3.query.aql
    • -1
    • +2
    ./duration_comps/duration_comps.3.query.aql
    • -0
    • +1
    ./time_functions/time_functions.3.query.aql
  1. … 98 more files in changeset.
addressed Sattam's comments; added code to enable loading year-month-duration and day-time-duration through external data

    • -1
    • +3
    ./insert_from_ext_ds/insert_from_ext_ds.1.ddl.aql
    • -1
    • +1
    ./insert_from_ext_ds/insert_from_ext_ds.3.query.aql
  1. … 28 more files in changeset.
added get functions for day-time-duration and year-month-duration

    • -2
    • +2
    ./duration_comps/duration_comps.3.query.aql
  1. … 13 more files in changeset.
addressed Sattam's review comments; added the entry for the test case in the test suite (missed for committing in previous revision); added duration-less-than functions based on the greater-than implementations.

    • -1
    • +1
    ./duration_comps/duration_comps.3.query.aql
  1. … 8 more files in changeset.
added functions to support duration comparison

    • -0
    • +8
    ./duration_comps/duration_comps.1.ddl.aql
    • -0
    • +0
    ./duration_comps/duration_comps.2.update.aql
    • -0
    • +11
    ./duration_comps/duration_comps.3.query.aql
  1. … 10 more files in changeset.
updated temporal function test cases for null arguments.

git-svn-id: https://asterixdb.googlecode.com/svn/branches/asterix_lsm_stabilization_interval_leftover@1675 eaa15691-b419-025a-1212-ee371bd00084

    • -1
    • +1
    ./adjust_timezone/adjust_timezone.3.query.aql
    • -1
    • +1
    ./calendar_duration/calendar_duration.3.query.aql
    • -1
    • +7
    ./date_functions/date_functions.3.query.aql
    • -1
    • +8
    ./datetime_functions/datetime_functions.3.query.aql
    • -1
    • +5
    ./interval_functions/interval_functions.3.query.aql
    • -1
    • +7
    ./time_functions/time_functions.3.query.aql
  1. … 8 more files in changeset.
Added interval start and end time accessors, with test cases; minor fix for the other temporal accessors.

git-svn-id: https://asterixdb.googlecode.com/svn/branches/asterix_lsm_stabilization_interval_leftover@1666 eaa15691-b419-025a-1212-ee371bd00084

    • -0
    • +2
    ./accessors_interval/accessors_interval.1.ddl.aql
    • -0
    • +0
    ./accessors_interval/accessors_interval.2.update.aql
    • -0
    • +7
    ./accessors_interval/accessors_interval.3.query.aql
    • -0
    • +2
    ./accessors_interval_null/accessors_interval_null.1.ddl.aql
    • -0
    • +0
    ./accessors_interval_null/accessors_interval_null.2.update.aql
    • -0
    • +3
    ./accessors_interval_null/accessors_interval_null.3.query.aql
  1. … 15 more files in changeset.
Merged asterix_lsm_stabilization upto r1547

git-svn-id: https://asterixdb.googlecode.com/svn/trunk/asterix@1622 eaa15691-b419-025a-1212-ee371bd00084

    • -0
    • +8
    ./adjust_timezone/adjust_timezone.1.ddl.aql
    • -0
    • +0
    ./adjust_timezone/adjust_timezone.2.update.aql
    • -0
    • +7
    ./adjust_timezone/adjust_timezone.3.query.aql
    • -0
    • +8
    ./calendar_duration/calendar_duration.1.ddl.aql
    • -0
    • +0
    ./calendar_duration/calendar_duration.2.update.aql
    • -0
    • +42
    ./calendar_duration/calendar_duration.3.query.aql
    • -0
    • +7
    ./date_functions/date_functions.1.ddl.aql
    • -0
    • +0
    ./date_functions/date_functions.2.update.aql
    • -0
    • +17
    ./date_functions/date_functions.3.query.aql
    • -0
    • +8
    ./datetime_functions/datetime_functions.1.ddl.aql
    • -0
    • +0
    ./datetime_functions/datetime_functions.2.update.aql
    • -0
    • +11
    ./datetime_functions/datetime_functions.3.query.aql
  1. … 6206 more files in changeset.