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

    • -27
    • +0
    ./q06_forecast_revenue_change/q06_forecast_revenue_change.4.query.sqlpp
  1. … 163 more files 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
    • +1
    ./nest_aggregate/nest_aggregate.3.query.sqlpp
    • -1
    • +1
    ./nest_aggregate2/nest_aggregate2.3.query.sqlpp
    • -7
    • +7
    ./q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.3.query.sqlpp
    • -1
    • +1
    ./q02_minimum_cost_supplier/q02_minimum_cost_supplier.3.query.sqlpp
    • -1
    • +1
    ./q03_shipping_priority_nt/q03_shipping_priority_nt.3.query.sqlpp
    • -1
    • +1
    ./q05_local_supplier_volume/q05_local_supplier_volume.3.query.sqlpp
    • -5
    • +5
    ./q06_forecast_revenue_change/q06_forecast_revenue_change.3.query.sqlpp
    • -0
    • +27
    ./q06_forecast_revenue_change/q06_forecast_revenue_change.4.query.sqlpp
    • -1
    • +1
    ./q07_volume_shipping/q07_volume_shipping.3.query.sqlpp
    • -2
    • +2
    ./q08_national_market_share/q08_national_market_share.3.query.sqlpp
    • -1
    • +1
    ./q09_product_type_profit_nt/q09_product_type_profit_nt.3.query.sqlpp
    • -1
    • +1
    ./q10_returned_item/q10_returned_item.3.query.sqlpp
    • -1
    • +1
    ./q10_returned_item_int64/q10_returned_item_int64.3.query.sqlpp
    • -2
    • +2
    ./q11_important_stock/q11_important_stock.3.query.sqlpp
    • -2
    • +2
    ./q12_shipping/q12_shipping.3.query.sqlpp
  1. … 437 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>

    • -2
    • +3
    ./q14_promotion_effect/q14_promotion_effect.3.query.sqlpp
  1. … 1963 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
    ./distinct_by/distinct_by.2.update.sqlpp
    • -1
    • +1
    ./group_no_agg/group_no_agg.2.update.sqlpp
    • -6
    • +6
    ./nest_aggregate/nest_aggregate.2.update.sqlpp
    • -6
    • +6
    ./nest_aggregate2/nest_aggregate2.2.update.sqlpp
    • -1
    • +1
    ./q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.2.update.sqlpp
    • -8
    • +8
    ./q02_minimum_cost_supplier/q02_minimum_cost_supplier.2.update.sqlpp
    • -3
    • +3
    ./q03_shipping_priority_nt/q03_shipping_priority_nt.2.update.sqlpp
    • -8
    • +8
    ./q04_order_priority/q04_order_priority.2.update.sqlpp
    • -8
    • +8
    ./q05_local_supplier_volume/q05_local_supplier_volume.2.update.sqlpp
    • -8
    • +8
    ./q06_forecast_revenue_change/q06_forecast_revenue_change.2.update.sqlpp
    • -8
    • +8
    ./q07_volume_shipping/q07_volume_shipping.2.update.sqlpp
    • -8
    • +8
    ./q08_national_market_share/q08_national_market_share.2.update.sqlpp
    • -8
    • +8
    ./q09_product_type_profit_nt/q09_product_type_profit_nt.2.update.sqlpp
    • -8
    • +8
    ./q10_returned_item/q10_returned_item.2.update.sqlpp
    • -8
    • +8
    ./q10_returned_item_int64/q10_returned_item_int64.2.update.sqlpp
  1. … 1136 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
    • +94
    ./nest_aggregate2/nest_aggregate2.1.ddl.sqlpp
    • -0
    • +40
    ./nest_aggregate2/nest_aggregate2.2.update.sqlpp
    • -0
    • +46
    ./nest_aggregate2/nest_aggregate2.3.query.sqlpp
  1. … 82 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
    ./distinct_by/distinct_by.2.update.sqlpp
    • -1
    • +1
    ./group_no_agg/group_no_agg.2.update.sqlpp
    • -6
    • +6
    ./nest_aggregate/nest_aggregate.2.update.sqlpp
    • -1
    • +1
    ./q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.2.update.sqlpp
    • -8
    • +8
    ./q02_minimum_cost_supplier/q02_minimum_cost_supplier.2.update.sqlpp
    • -3
    • +3
    ./q03_shipping_priority_nt/q03_shipping_priority_nt.2.update.sqlpp
    • -8
    • +8
    ./q04_order_priority/q04_order_priority.2.update.sqlpp
    • -8
    • +8
    ./q05_local_supplier_volume/q05_local_supplier_volume.2.update.sqlpp
    • -8
    • +8
    ./q06_forecast_revenue_change/q06_forecast_revenue_change.2.update.sqlpp
    • -8
    • +8
    ./q07_volume_shipping/q07_volume_shipping.2.update.sqlpp
    • -8
    • +8
    ./q08_national_market_share/q08_national_market_share.2.update.sqlpp
    • -8
    • +8
    ./q09_product_type_profit_nt/q09_product_type_profit_nt.2.update.sqlpp
    • -8
    • +8
    ./q10_returned_item/q10_returned_item.2.update.sqlpp
    • -8
    • +8
    ./q10_returned_item_int64/q10_returned_item_int64.2.update.sqlpp
    • -8
    • +8
    ./q11_important_stock/q11_important_stock.2.update.sqlpp
  1. … 3852 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
    ./distinct_by/distinct_by.3.query.sqlpp
    • -1
    • +2
    ./nest_aggregate/nest_aggregate.3.query.sqlpp
    • -5
    • +5
    ./q04_order_priority/q04_order_priority.3.query.sqlpp
    • -6
    • +6
    ./q09_product_type_profit_nt/q09_product_type_profit_nt.3.query.sqlpp
    • -4
    • +5
    ./q17_small_quantity_order_revenue/q17_small_quantity_order_revenue.3.query.sqlpp
    • -1
    • +1
    ./q18_large_volume_customer/q18_large_volume_customer.3.query.sqlpp
    • -2
    • +2
    ./q20_potential_part_promotion/q20_potential_part_promotion.3.query.sqlpp
    • -12
    • +12
    ./q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.3.query.sqlpp
  1. … 1372 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
    • +47
    ./distinct_by/distinct_by.1.ddl.sqlpp
    • -0
    • +24
    ./distinct_by/distinct_by.2.update.sqlpp
    • -0
    • +26
    ./distinct_by/distinct_by.3.query.sqlpp
    • -0
    • +34
    ./group_no_agg/group_no_agg.1.ddl.sqlpp
    • -0
    • +24
    ./group_no_agg/group_no_agg.2.update.sqlpp
    • -0
    • +27
    ./group_no_agg/group_no_agg.3.query.sqlpp
    • -0
    • +94
    ./nest_aggregate/nest_aggregate.1.ddl.sqlpp
    • -0
    • +40
    ./nest_aggregate/nest_aggregate.2.update.sqlpp
    • -0
    • +45
    ./nest_aggregate/nest_aggregate.3.query.sqlpp
    • -0
    • +47
    ./q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.1.ddl.sqlpp
    • -0
    • +24
    ./q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.2.update.sqlpp
    • -0
    • +52
    ./q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.3.query.sqlpp
    • -0
    • +134
    ./q02_minimum_cost_supplier/q02_minimum_cost_supplier.1.ddl.sqlpp
    • -0
    • +38
    ./q02_minimum_cost_supplier/q02_minimum_cost_supplier.2.update.sqlpp
    • -0
    • +80
    ./q02_minimum_cost_supplier/q02_minimum_cost_supplier.3.query.sqlpp
  1. … 10209 more files in changeset.