http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q09_product_type_profit_nt/q09_product_type_profit_nt.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q09_product_type_profit_nt/q09_product_type_profit_nt.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q09_product_type_profit_nt/q09_product_type_profit_nt.1.ddl.sqlpp index 4e176f4..d3189b8 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q09_product_type_profit_nt/q09_product_type_profit_nt.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q09_product_type_profit_nt/q09_product_type_profit_nt.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : integer, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : integer, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : integer, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : integer, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q10_returned_item/q10_returned_item.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q10_returned_item/q10_returned_item.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q10_returned_item/q10_returned_item.1.ddl.sqlpp index 4e176f4..d3189b8 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q10_returned_item/q10_returned_item.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q10_returned_item/q10_returned_item.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : integer, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : integer, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : integer, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : integer, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q10_returned_item_int64/q10_returned_item_int64.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q10_returned_item_int64/q10_returned_item_int64.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q10_returned_item_int64/q10_returned_item_int64.1.ddl.sqlpp index 56612a4..472c27e 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q10_returned_item_int64/q10_returned_item_int64.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q10_returned_item_int64/q10_returned_item_int64.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : bigint, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : bigint, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : bigint, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : bigint, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q11_important_stock/q11_important_stock.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q11_important_stock/q11_important_stock.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q11_important_stock/q11_important_stock.1.ddl.sqlpp index 56612a4..472c27e 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q11_important_stock/q11_important_stock.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q11_important_stock/q11_important_stock.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : bigint, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : bigint, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : bigint, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : bigint, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q12_shipping/q12_shipping.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q12_shipping/q12_shipping.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q12_shipping/q12_shipping.1.ddl.sqlpp index 4e176f4..d3189b8 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q12_shipping/q12_shipping.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q12_shipping/q12_shipping.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : integer, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : integer, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : integer, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : integer, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q12_shipping/q12_shipping.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q12_shipping/q12_shipping.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q12_shipping/q12_shipping.3.query.sqlpp index e8097c0..b5390d4 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q12_shipping/q12_shipping.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q12_shipping/q12_shipping.3.query.sqlpp @@ -17,7 +17,7 @@ * under the License. */ -use tpch +use tpch; select element {'l_shipmode':l_shipmode,'high_line_count':tpch.coll_sum(( select element case http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q13_customer_distribution/q13_customer_distribution.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q13_customer_distribution/q13_customer_distribution.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q13_customer_distribution/q13_customer_distribution.1.ddl.sqlpp index 56612a4..472c27e 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q13_customer_distribution/q13_customer_distribution.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q13_customer_distribution/q13_customer_distribution.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : bigint, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : bigint, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : bigint, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : bigint, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q14_promotion_effect/q14_promotion_effect.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q14_promotion_effect/q14_promotion_effect.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q14_promotion_effect/q14_promotion_effect.1.ddl.sqlpp index 4e176f4..d3189b8 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q14_promotion_effect/q14_promotion_effect.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q14_promotion_effect/q14_promotion_effect.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : integer, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : integer, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : integer, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : integer, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q15_top_supplier/q15_top_supplier.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q15_top_supplier/q15_top_supplier.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q15_top_supplier/q15_top_supplier.1.ddl.sqlpp index 56612a4..472c27e 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q15_top_supplier/q15_top_supplier.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q15_top_supplier/q15_top_supplier.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : bigint, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : bigint, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : bigint, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : bigint, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q16_parts_supplier_relationship/q16_parts_supplier_relationship.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q16_parts_supplier_relationship/q16_parts_supplier_relationship.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q16_parts_supplier_relationship/q16_parts_supplier_relationship.1.ddl.sqlpp index 56612a4..472c27e 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q16_parts_supplier_relationship/q16_parts_supplier_relationship.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q16_parts_supplier_relationship/q16_parts_supplier_relationship.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : bigint, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : bigint, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : bigint, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : bigint, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q17_large_gby_variant/q17_large_gby_variant.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q17_large_gby_variant/q17_large_gby_variant.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q17_large_gby_variant/q17_large_gby_variant.1.ddl.sqlpp index 56612a4..472c27e 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q17_large_gby_variant/q17_large_gby_variant.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q17_large_gby_variant/q17_large_gby_variant.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : bigint, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : bigint, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : bigint, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : bigint, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q17_small_quantity_order_revenue/q17_small_quantity_order_revenue.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q17_small_quantity_order_revenue/q17_small_quantity_order_revenue.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q17_small_quantity_order_revenue/q17_small_quantity_order_revenue.1.ddl.sqlpp index 4e176f4..d3189b8 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q17_small_quantity_order_revenue/q17_small_quantity_order_revenue.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q17_small_quantity_order_revenue/q17_small_quantity_order_revenue.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : integer, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : integer, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : integer, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : integer, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q18_large_volume_customer/q18_large_volume_customer.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q18_large_volume_customer/q18_large_volume_customer.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q18_large_volume_customer/q18_large_volume_customer.1.ddl.sqlpp index 56612a4..472c27e 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q18_large_volume_customer/q18_large_volume_customer.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q18_large_volume_customer/q18_large_volume_customer.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : bigint, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : bigint, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : bigint, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : bigint, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q19_discounted_revenue/q19_discounted_revenue.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q19_discounted_revenue/q19_discounted_revenue.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q19_discounted_revenue/q19_discounted_revenue.1.ddl.sqlpp index 4e176f4..d3189b8 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q19_discounted_revenue/q19_discounted_revenue.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q19_discounted_revenue/q19_discounted_revenue.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : integer, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : integer, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : integer, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : integer, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q20_potential_part_promotion/q20_potential_part_promotion.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q20_potential_part_promotion/q20_potential_part_promotion.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q20_potential_part_promotion/q20_potential_part_promotion.1.ddl.sqlpp index 4e176f4..d3189b8 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q20_potential_part_promotion/q20_potential_part_promotion.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q20_potential_part_promotion/q20_potential_part_promotion.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : integer, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : integer, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : integer, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : integer, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.1.ddl.sqlpp index 56612a4..472c27e 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : bigint, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : bigint, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : bigint, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : bigint, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q22_global_sales_opportunity/q22_global_sales_opportunity.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q22_global_sales_opportunity/q22_global_sales_opportunity.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q22_global_sales_opportunity/q22_global_sales_opportunity.1.ddl.sqlpp index 4e176f4..d3189b8 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q22_global_sales_opportunity/q22_global_sales_opportunity.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/q22_global_sales_opportunity/q22_global_sales_opportunity.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : integer, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : integer, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : integer, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : integer, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue562/query-issue562.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue562/query-issue562.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue562/query-issue562.1.ddl.sqlpp index e29de08..75a1427 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue562/query-issue562.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue562/query-issue562.1.ddl.sqlpp @@ -47,7 +47,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -60,7 +60,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : integer, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -72,7 +72,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -83,7 +83,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -91,14 +91,14 @@ create type tpch.NationType as n_name : string, n_regionkey : integer, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : integer, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -111,7 +111,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -120,7 +120,7 @@ create type tpch.PartSuppType as ps_availqty : integer, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue601/query-issue601.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue601/query-issue601.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue601/query-issue601.1.ddl.sqlpp index 8ef90ac..cac5f70 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue601/query-issue601.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue601/query-issue601.1.ddl.sqlpp @@ -47,7 +47,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue785-2/query-issue785-2.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue785-2/query-issue785-2.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue785-2/query-issue785-2.1.ddl.sqlpp index c214fc2..42ecced 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue785-2/query-issue785-2.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue785-2/query-issue785-2.1.ddl.sqlpp @@ -40,7 +40,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : bigint, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -52,7 +52,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -63,7 +63,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -71,14 +71,14 @@ create type tpch.NationType as n_name : string, n_regionkey : bigint, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : bigint, r_name : string, r_comment : string -} +}; create dataset Orders(OrderType) primary key o_orderkey; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue785/query-issue785.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue785/query-issue785.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue785/query-issue785.1.ddl.sqlpp index c214fc2..42ecced 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue785/query-issue785.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue785/query-issue785.1.ddl.sqlpp @@ -40,7 +40,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : bigint, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -52,7 +52,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -63,7 +63,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -71,14 +71,14 @@ create type tpch.NationType as n_name : string, n_regionkey : bigint, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : bigint, r_name : string, r_comment : string -} +}; create dataset Orders(OrderType) primary key o_orderkey; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue786/query-issue786.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue786/query-issue786.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue786/query-issue786.1.ddl.sqlpp index 3d09e2a..9dd8f84 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue786/query-issue786.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue786/query-issue786.1.ddl.sqlpp @@ -40,7 +40,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : integer, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -52,7 +52,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -63,7 +63,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -71,14 +71,14 @@ create type tpch.NationType as n_name : string, n_regionkey : integer, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : integer, r_name : string, r_comment : string -} +}; create dataset Orders(OrderType) primary key o_orderkey; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue810-2/query-issue810-2.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue810-2/query-issue810-2.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue810-2/query-issue810-2.1.ddl.sqlpp index b3e0cc5..22a7bb2 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue810-2/query-issue810-2.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue810-2/query-issue810-2.1.ddl.sqlpp @@ -47,7 +47,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue810-3/query-issue810-3.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue810-3/query-issue810-3.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue810-3/query-issue810-3.1.ddl.sqlpp index b3e0cc5..22a7bb2 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue810-3/query-issue810-3.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue810-3/query-issue810-3.1.ddl.sqlpp @@ -47,7 +47,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue810/query-issue810.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue810/query-issue810.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue810/query-issue810.1.ddl.sqlpp index b3e0cc5..22a7bb2 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue810/query-issue810.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue810/query-issue810.1.ddl.sqlpp @@ -47,7 +47,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue827-2/query-issue827-2.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue827-2/query-issue827-2.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue827-2/query-issue827-2.1.ddl.sqlpp index efec413..5c049cb 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue827-2/query-issue827-2.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue827-2/query-issue827-2.1.ddl.sqlpp @@ -47,7 +47,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue827/query-issue827.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue827/query-issue827.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue827/query-issue827.1.ddl.sqlpp index efec413..5c049cb 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue827/query-issue827.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-with-index/query-issue827/query-issue827.1.ddl.sqlpp @@ -47,7 +47,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/distinct_by/distinct_by.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/distinct_by/distinct_by.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/distinct_by/distinct_by.1.ddl.sqlpp index d50dd81..95afadd 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/distinct_by/distinct_by.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/distinct_by/distinct_by.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/group_no_agg/group_no_agg.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/group_no_agg/group_no_agg.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/group_no_agg/group_no_agg.1.ddl.sqlpp index 3cbe494..9ee2e7f 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/group_no_agg/group_no_agg.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/group_no_agg/group_no_agg.1.ddl.sqlpp @@ -28,7 +28,7 @@ create type tpch.RegionType as r_regionkey : integer, r_name : string, r_comment : string -} +}; create dataset Regions_group_no_agg(RegionType) primary key r_regionkey; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/nest_aggregate/nest_aggregate.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/nest_aggregate/nest_aggregate.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/nest_aggregate/nest_aggregate.1.ddl.sqlpp index 089efc3..ac5b5fc 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/nest_aggregate/nest_aggregate.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/nest_aggregate/nest_aggregate.1.ddl.sqlpp @@ -40,7 +40,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : bigint, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -52,7 +52,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -63,7 +63,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -71,14 +71,14 @@ create type tpch.NationType as n_name : string, n_regionkey : bigint, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : bigint, r_name : string, r_comment : string -} +}; create dataset Orders(OrderType) primary key o_orderkey; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/nest_aggregate2/nest_aggregate2.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/nest_aggregate2/nest_aggregate2.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/nest_aggregate2/nest_aggregate2.1.ddl.sqlpp index 089efc3..ac5b5fc 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/nest_aggregate2/nest_aggregate2.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/nest_aggregate2/nest_aggregate2.1.ddl.sqlpp @@ -40,7 +40,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : bigint, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -52,7 +52,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -63,7 +63,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -71,14 +71,14 @@ create type tpch.NationType as n_name : string, n_regionkey : bigint, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : bigint, r_name : string, r_comment : string -} +}; create dataset Orders(OrderType) primary key o_orderkey; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.1.ddl.sqlpp index 9d41f77..4e82d90 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.3.query.sqlpp index e42ce21..f47341a 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.3.query.sqlpp @@ -19,7 +19,7 @@ use tpch; -set hash_merge "true" +set hash_merge "true"; select element {'l_returnflag':l_returnflag,'l_linestatus':l_linestatus,'sum_qty':COLL_SUM(( select element i.l.l_quantity http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q02_minimum_cost_supplier/q02_minimum_cost_supplier.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q02_minimum_cost_supplier/q02_minimum_cost_supplier.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q02_minimum_cost_supplier/q02_minimum_cost_supplier.1.ddl.sqlpp index 6cbdf11..ef52df8 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q02_minimum_cost_supplier/q02_minimum_cost_supplier.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q02_minimum_cost_supplier/q02_minimum_cost_supplier.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : bigint, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : bigint, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : bigint, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : bigint, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q03_shipping_priority_nt/q03_shipping_priority_nt.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q03_shipping_priority_nt/q03_shipping_priority_nt.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q03_shipping_priority_nt/q03_shipping_priority_nt.1.ddl.sqlpp index 6cbdf11..ef52df8 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q03_shipping_priority_nt/q03_shipping_priority_nt.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q03_shipping_priority_nt/q03_shipping_priority_nt.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : bigint, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : bigint, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : bigint, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : bigint, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q04_order_priority/q04_order_priority.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q04_order_priority/q04_order_priority.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q04_order_priority/q04_order_priority.1.ddl.sqlpp index 6cbdf11..ef52df8 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q04_order_priority/q04_order_priority.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q04_order_priority/q04_order_priority.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : bigint, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : bigint, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : bigint, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : bigint, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q05_local_supplier_volume/q05_local_supplier_volume.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q05_local_supplier_volume/q05_local_supplier_volume.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q05_local_supplier_volume/q05_local_supplier_volume.1.ddl.sqlpp index 0db8d36..4ba3bef 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q05_local_supplier_volume/q05_local_supplier_volume.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q05_local_supplier_volume/q05_local_supplier_volume.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : integer, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : integer, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : integer, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : integer, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q06_forecast_revenue_change/q06_forecast_revenue_change.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q06_forecast_revenue_change/q06_forecast_revenue_change.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q06_forecast_revenue_change/q06_forecast_revenue_change.1.ddl.sqlpp index 0db8d36..4ba3bef 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q06_forecast_revenue_change/q06_forecast_revenue_change.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q06_forecast_revenue_change/q06_forecast_revenue_change.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : integer, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : integer, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : integer, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : integer, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q07_volume_shipping/q07_volume_shipping.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q07_volume_shipping/q07_volume_shipping.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q07_volume_shipping/q07_volume_shipping.1.ddl.sqlpp index 0db8d36..4ba3bef 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q07_volume_shipping/q07_volume_shipping.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q07_volume_shipping/q07_volume_shipping.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : integer, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : integer, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : integer, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : integer, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q08_national_market_share/q08_national_market_share.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q08_national_market_share/q08_national_market_share.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q08_national_market_share/q08_national_market_share.1.ddl.sqlpp index 0db8d36..4ba3bef 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q08_national_market_share/q08_national_market_share.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q08_national_market_share/q08_national_market_share.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : integer, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : integer, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : integer, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : integer, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q09_product_type_profit_nt/q09_product_type_profit_nt.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q09_product_type_profit_nt/q09_product_type_profit_nt.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q09_product_type_profit_nt/q09_product_type_profit_nt.1.ddl.sqlpp index 0db8d36..4ba3bef 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q09_product_type_profit_nt/q09_product_type_profit_nt.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q09_product_type_profit_nt/q09_product_type_profit_nt.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : integer, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : integer, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : integer, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : integer, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q10_returned_item/q10_returned_item.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q10_returned_item/q10_returned_item.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q10_returned_item/q10_returned_item.1.ddl.sqlpp index 0db8d36..4ba3bef 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q10_returned_item/q10_returned_item.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q10_returned_item/q10_returned_item.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : integer, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : integer, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : integer, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : integer, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q10_returned_item_int64/q10_returned_item_int64.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q10_returned_item_int64/q10_returned_item_int64.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q10_returned_item_int64/q10_returned_item_int64.1.ddl.sqlpp index 6cbdf11..ef52df8 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q10_returned_item_int64/q10_returned_item_int64.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q10_returned_item_int64/q10_returned_item_int64.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : bigint, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : bigint, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : bigint, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : bigint, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q11_important_stock/q11_important_stock.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q11_important_stock/q11_important_stock.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q11_important_stock/q11_important_stock.1.ddl.sqlpp index 6cbdf11..ef52df8 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q11_important_stock/q11_important_stock.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q11_important_stock/q11_important_stock.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : bigint, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : bigint, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : bigint, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : bigint, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q12_shipping/q12_shipping.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q12_shipping/q12_shipping.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q12_shipping/q12_shipping.1.ddl.sqlpp index 0db8d36..4ba3bef 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q12_shipping/q12_shipping.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q12_shipping/q12_shipping.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : integer, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : integer, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : integer, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : integer, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q13_customer_distribution/q13_customer_distribution.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q13_customer_distribution/q13_customer_distribution.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q13_customer_distribution/q13_customer_distribution.1.ddl.sqlpp index 6cbdf11..ef52df8 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q13_customer_distribution/q13_customer_distribution.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q13_customer_distribution/q13_customer_distribution.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : bigint, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : bigint, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : bigint, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : bigint, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q14_promotion_effect/q14_promotion_effect.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q14_promotion_effect/q14_promotion_effect.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q14_promotion_effect/q14_promotion_effect.1.ddl.sqlpp index 0db8d36..4ba3bef 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q14_promotion_effect/q14_promotion_effect.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch/q14_promotion_effect/q14_promotion_effect.1.ddl.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : integer, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.SupplierType as closed { @@ -77,7 +77,7 @@ create type tpch.SupplierType as s_phone : string, s_acctbal : double, s_comment : string -} +}; create type tpch.NationType as closed { @@ -85,14 +85,14 @@ create type tpch.NationType as n_name : string, n_regionkey : integer, n_comment : string -} +}; create type tpch.RegionType as closed { r_regionkey : integer, r_name : string, r_comment : string -} +}; create type tpch.PartType as closed { @@ -105,7 +105,7 @@ create type tpch.PartType as p_container : string, p_retailprice : double, p_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -114,7 +114,7 @@ create type tpch.PartSuppType as ps_availqty : integer, ps_supplycost : double, ps_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
