Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 46CA8200B9A for ; Fri, 23 Sep 2016 05:14:49 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 45446160AE2; Fri, 23 Sep 2016 03:14:49 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 7B45E160AAD for ; Fri, 23 Sep 2016 05:14:47 +0200 (CEST) Received: (qmail 69239 invoked by uid 500); 23 Sep 2016 03:14:45 -0000 Mailing-List: contact commits-help@asterixdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@asterixdb.apache.org Delivered-To: mailing list commits@asterixdb.apache.org Received: (qmail 68359 invoked by uid 99); 23 Sep 2016 03:14:43 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 23 Sep 2016 03:14:43 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 7E842EF7C3; Fri, 23 Sep 2016 03:14:43 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: buyingyi@apache.org To: commits@asterixdb.apache.org Date: Fri, 23 Sep 2016 03:14:56 -0000 Message-Id: <384cd7c6031249fa8db282eba52bb1e1@git.apache.org> In-Reply-To: <2e4bc886f7a64bdbb5b33e6b1e1c7269@git.apache.org> References: <2e4bc886f7a64bdbb5b33e6b1e1c7269@git.apache.org> X-Mailer: ASF-Git Admin Mailer Subject: [14/51] [partial] asterixdb git commit: ASTERIXDB-1539: add aliases for several builtin types and builtin functions. archived-at: Fri, 23 Sep 2016 03:14:49 -0000 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q17_large_gby_variant/q17_large_gby_variant.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q17_large_gby_variant/q17_large_gby_variant.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q17_large_gby_variant/q17_large_gby_variant.3.query.sqlpp index 2e057d7..9316156 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q17_large_gby_variant/q17_large_gby_variant.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q17_large_gby_variant/q17_large_gby_variant.3.query.sqlpp @@ -20,34 +20,34 @@ use tpch; -select element {'t_partkey':l_partkey,'t_count':tpch.count(l),'t_avg_quantity':(0.2 * tpch.coll_avg(( +select element {'t_partkey':l_partkey,'t_count':tpch.count(l),'t_avg_quantity':(0.2 * tpch.array_avg(( select element i.l_quantity from l as i - ))),'t_max_suppkey':tpch.coll_max(( + ))),'t_max_suppkey':tpch.array_max(( select element i.l_suppkey from l as i - )),'t_max_linenumber':tpch.coll_max(( + )),'t_max_linenumber':tpch.array_max(( select element i.l_linenumber from l as i - )),'t_avg_extendedprice':tpch.coll_avg(( + )),'t_avg_extendedprice':tpch.array_avg(( select element i.l_extendedprice from l as i - )),'t_avg_discount':tpch.coll_avg(( + )),'t_avg_discount':tpch.array_avg(( select element i.l_discount from l as i - )),'t_avg_tax':tpch.coll_avg(( + )),'t_avg_tax':tpch.array_avg(( select element i.l_tax from l as i - )),'t_max_shipdate':tpch.coll_max(( + )),'t_max_shipdate':tpch.array_max(( select element i.l_shipdate from l as i - )),'t_min_commitdate':tpch.coll_min(( + )),'t_min_commitdate':tpch.array_min(( select element i.l_commitdate from l as i - )),'t_min_receiptdate':tpch.coll_min(( + )),'t_min_receiptdate':tpch.array_min(( select element i.l_receiptdate from l as i - )),'t_max_comment':tpch.coll_max(( + )),'t_max_comment':tpch.array_max(( select element i.l_comment from l as i ))} http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/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-sql-like/q17_small_quantity_order_revenue/q17_small_quantity_order_revenue.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q17_small_quantity_order_revenue/q17_small_quantity_order_revenue.1.ddl.sqlpp index bf4e637..b055e7c 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q17_small_quantity_order_revenue/q17_small_quantity_order_revenue.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q17_small_quantity_order_revenue/q17_small_quantity_order_revenue.1.ddl.sqlpp @@ -25,11 +25,11 @@ use tpch; create type tpch.LineItemType as closed { - l_orderkey : int64, - l_partkey : int64, - l_suppkey : int64, - l_linenumber : int64, - l_quantity : int64, + l_orderkey : bigint, + l_partkey : bigint, + l_suppkey : bigint, + l_linenumber : bigint, + l_quantity : bigint, l_extendedprice : double, l_discount : double, l_tax : double, @@ -45,23 +45,23 @@ create type tpch.LineItemType as create type tpch.OrderType as closed { - o_orderkey : int64, - o_custkey : int64, + o_orderkey : bigint, + o_custkey : bigint, o_orderstatus : string, o_totalprice : double, o_orderdate : string, o_orderpriority : string, o_clerk : string, - o_shippriority : int64, + o_shippriority : bigint, o_comment : string } create type tpch.CustomerType as closed { - c_custkey : int64, + c_custkey : bigint, c_name : string, c_address : string, - c_nationkey : int64, + c_nationkey : bigint, c_phone : string, c_acctbal : double, c_mktsegment : string, @@ -70,10 +70,10 @@ create type tpch.CustomerType as create type tpch.SupplierType as closed { - s_suppkey : int64, + s_suppkey : bigint, s_name : string, s_address : string, - s_nationkey : int64, + s_nationkey : bigint, s_phone : string, s_acctbal : double, s_comment : string @@ -81,27 +81,27 @@ create type tpch.SupplierType as create type tpch.NationType as closed { - n_nationkey : int64, + n_nationkey : bigint, n_name : string, - n_regionkey : int64, + n_regionkey : bigint, n_comment : string } create type tpch.RegionType as closed { - r_regionkey : int64, + r_regionkey : bigint, r_name : string, r_comment : string } create type tpch.PartType as closed { - p_partkey : int64, + p_partkey : bigint, p_name : string, p_mfgr : string, p_brand : string, p_type : string, - p_size : int64, + p_size : bigint, p_container : string, p_retailprice : double, p_comment : string @@ -109,9 +109,9 @@ create type tpch.PartType as create type tpch.PartSuppType as closed { - ps_partkey : int64, - ps_suppkey : int64, - ps_availqty : int64, + ps_partkey : bigint, + ps_suppkey : bigint, + ps_availqty : bigint, ps_supplycost : double, ps_comment : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q17_small_quantity_order_revenue/q17_small_quantity_order_revenue.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q17_small_quantity_order_revenue/q17_small_quantity_order_revenue.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q17_small_quantity_order_revenue/q17_small_quantity_order_revenue.3.query.sqlpp index 2f48cf3..5f089a2 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q17_small_quantity_order_revenue/q17_small_quantity_order_revenue.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q17_small_quantity_order_revenue/q17_small_quantity_order_revenue.3.query.sqlpp @@ -22,7 +22,7 @@ use tpch; declare function tmp() { ( - select element {'t_partkey':l_partkey,'t_avg_quantity':(0.2 * COLL_AVG(( + select element {'t_partkey':l_partkey,'t_avg_quantity':(0.2 * ARRAY_AVG(( select element i.l_quantity from l as i )))} @@ -31,7 +31,7 @@ declare function tmp() { ) }; -select element (COLL_SUM(( +select element (ARRAY_SUM(( select element l.l_extendedprice from LineItem as l, Part as p, http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q18_large_volume_customer/q18_large_volume_customer.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q18_large_volume_customer/q18_large_volume_customer.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q18_large_volume_customer/q18_large_volume_customer.1.ddl.sqlpp index bf4e637..b055e7c 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q18_large_volume_customer/q18_large_volume_customer.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q18_large_volume_customer/q18_large_volume_customer.1.ddl.sqlpp @@ -25,11 +25,11 @@ use tpch; create type tpch.LineItemType as closed { - l_orderkey : int64, - l_partkey : int64, - l_suppkey : int64, - l_linenumber : int64, - l_quantity : int64, + l_orderkey : bigint, + l_partkey : bigint, + l_suppkey : bigint, + l_linenumber : bigint, + l_quantity : bigint, l_extendedprice : double, l_discount : double, l_tax : double, @@ -45,23 +45,23 @@ create type tpch.LineItemType as create type tpch.OrderType as closed { - o_orderkey : int64, - o_custkey : int64, + o_orderkey : bigint, + o_custkey : bigint, o_orderstatus : string, o_totalprice : double, o_orderdate : string, o_orderpriority : string, o_clerk : string, - o_shippriority : int64, + o_shippriority : bigint, o_comment : string } create type tpch.CustomerType as closed { - c_custkey : int64, + c_custkey : bigint, c_name : string, c_address : string, - c_nationkey : int64, + c_nationkey : bigint, c_phone : string, c_acctbal : double, c_mktsegment : string, @@ -70,10 +70,10 @@ create type tpch.CustomerType as create type tpch.SupplierType as closed { - s_suppkey : int64, + s_suppkey : bigint, s_name : string, s_address : string, - s_nationkey : int64, + s_nationkey : bigint, s_phone : string, s_acctbal : double, s_comment : string @@ -81,27 +81,27 @@ create type tpch.SupplierType as create type tpch.NationType as closed { - n_nationkey : int64, + n_nationkey : bigint, n_name : string, - n_regionkey : int64, + n_regionkey : bigint, n_comment : string } create type tpch.RegionType as closed { - r_regionkey : int64, + r_regionkey : bigint, r_name : string, r_comment : string } create type tpch.PartType as closed { - p_partkey : int64, + p_partkey : bigint, p_name : string, p_mfgr : string, p_brand : string, p_type : string, - p_size : int64, + p_size : bigint, p_container : string, p_retailprice : double, p_comment : string @@ -109,9 +109,9 @@ create type tpch.PartType as create type tpch.PartSuppType as closed { - ps_partkey : int64, - ps_suppkey : int64, - ps_availqty : int64, + ps_partkey : bigint, + ps_suppkey : bigint, + ps_availqty : bigint, ps_supplycost : double, ps_comment : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q18_large_volume_customer/q18_large_volume_customer.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q18_large_volume_customer/q18_large_volume_customer.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q18_large_volume_customer/q18_large_volume_customer.3.query.sqlpp index 5215013..56ec95c 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q18_large_volume_customer/q18_large_volume_customer.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q18_large_volume_customer/q18_large_volume_customer.3.query.sqlpp @@ -20,14 +20,14 @@ use tpch; -select element {'c_name':c_name,'c_custkey':c_custkey,'o_orderkey':o_orderkey,'o_orderdate':o_orderdate,'o_totalprice':o_totalprice,'sum_quantity':COLL_SUM(( +select element {'c_name':c_name,'c_custkey':c_custkey,'o_orderkey':o_orderkey,'o_orderdate':o_orderdate,'o_totalprice':o_totalprice,'sum_quantity':ARRAY_SUM(( select element j.l_quantity from l as j ))} from Customer as c, Orders as o, ( - select element {'l_orderkey':l_orderkey,'t_sum_quantity':COLL_SUM(( + select element {'l_orderkey':l_orderkey,'t_sum_quantity':ARRAY_SUM(( select element i.l_quantity from l as i ))} http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q19_discounted_revenue/q19_discounted_revenue.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q19_discounted_revenue/q19_discounted_revenue.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q19_discounted_revenue/q19_discounted_revenue.1.ddl.sqlpp index bf4e637..b055e7c 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q19_discounted_revenue/q19_discounted_revenue.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q19_discounted_revenue/q19_discounted_revenue.1.ddl.sqlpp @@ -25,11 +25,11 @@ use tpch; create type tpch.LineItemType as closed { - l_orderkey : int64, - l_partkey : int64, - l_suppkey : int64, - l_linenumber : int64, - l_quantity : int64, + l_orderkey : bigint, + l_partkey : bigint, + l_suppkey : bigint, + l_linenumber : bigint, + l_quantity : bigint, l_extendedprice : double, l_discount : double, l_tax : double, @@ -45,23 +45,23 @@ create type tpch.LineItemType as create type tpch.OrderType as closed { - o_orderkey : int64, - o_custkey : int64, + o_orderkey : bigint, + o_custkey : bigint, o_orderstatus : string, o_totalprice : double, o_orderdate : string, o_orderpriority : string, o_clerk : string, - o_shippriority : int64, + o_shippriority : bigint, o_comment : string } create type tpch.CustomerType as closed { - c_custkey : int64, + c_custkey : bigint, c_name : string, c_address : string, - c_nationkey : int64, + c_nationkey : bigint, c_phone : string, c_acctbal : double, c_mktsegment : string, @@ -70,10 +70,10 @@ create type tpch.CustomerType as create type tpch.SupplierType as closed { - s_suppkey : int64, + s_suppkey : bigint, s_name : string, s_address : string, - s_nationkey : int64, + s_nationkey : bigint, s_phone : string, s_acctbal : double, s_comment : string @@ -81,27 +81,27 @@ create type tpch.SupplierType as create type tpch.NationType as closed { - n_nationkey : int64, + n_nationkey : bigint, n_name : string, - n_regionkey : int64, + n_regionkey : bigint, n_comment : string } create type tpch.RegionType as closed { - r_regionkey : int64, + r_regionkey : bigint, r_name : string, r_comment : string } create type tpch.PartType as closed { - p_partkey : int64, + p_partkey : bigint, p_name : string, p_mfgr : string, p_brand : string, p_type : string, - p_size : int64, + p_size : bigint, p_container : string, p_retailprice : double, p_comment : string @@ -109,9 +109,9 @@ create type tpch.PartType as create type tpch.PartSuppType as closed { - ps_partkey : int64, - ps_suppkey : int64, - ps_availqty : int64, + ps_partkey : bigint, + ps_suppkey : bigint, + ps_availqty : bigint, ps_supplycost : double, ps_comment : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q19_discounted_revenue/q19_discounted_revenue.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q19_discounted_revenue/q19_discounted_revenue.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q19_discounted_revenue/q19_discounted_revenue.3.query.sqlpp index 9057ccb..c6a2b67 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q19_discounted_revenue/q19_discounted_revenue.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q19_discounted_revenue/q19_discounted_revenue.3.query.sqlpp @@ -22,7 +22,7 @@ use tpch; set `import-private-functions` `true`; -select element coll_sum(( +select element array_sum(( select element (l.l_extendedprice * (1 - l.l_discount)) from LineItem as l, Part as p http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q20_potential_part_promotion/q20_potential_part_promotion.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q20_potential_part_promotion/q20_potential_part_promotion.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q20_potential_part_promotion/q20_potential_part_promotion.1.ddl.sqlpp index bf4e637..b055e7c 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q20_potential_part_promotion/q20_potential_part_promotion.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q20_potential_part_promotion/q20_potential_part_promotion.1.ddl.sqlpp @@ -25,11 +25,11 @@ use tpch; create type tpch.LineItemType as closed { - l_orderkey : int64, - l_partkey : int64, - l_suppkey : int64, - l_linenumber : int64, - l_quantity : int64, + l_orderkey : bigint, + l_partkey : bigint, + l_suppkey : bigint, + l_linenumber : bigint, + l_quantity : bigint, l_extendedprice : double, l_discount : double, l_tax : double, @@ -45,23 +45,23 @@ create type tpch.LineItemType as create type tpch.OrderType as closed { - o_orderkey : int64, - o_custkey : int64, + o_orderkey : bigint, + o_custkey : bigint, o_orderstatus : string, o_totalprice : double, o_orderdate : string, o_orderpriority : string, o_clerk : string, - o_shippriority : int64, + o_shippriority : bigint, o_comment : string } create type tpch.CustomerType as closed { - c_custkey : int64, + c_custkey : bigint, c_name : string, c_address : string, - c_nationkey : int64, + c_nationkey : bigint, c_phone : string, c_acctbal : double, c_mktsegment : string, @@ -70,10 +70,10 @@ create type tpch.CustomerType as create type tpch.SupplierType as closed { - s_suppkey : int64, + s_suppkey : bigint, s_name : string, s_address : string, - s_nationkey : int64, + s_nationkey : bigint, s_phone : string, s_acctbal : double, s_comment : string @@ -81,27 +81,27 @@ create type tpch.SupplierType as create type tpch.NationType as closed { - n_nationkey : int64, + n_nationkey : bigint, n_name : string, - n_regionkey : int64, + n_regionkey : bigint, n_comment : string } create type tpch.RegionType as closed { - r_regionkey : int64, + r_regionkey : bigint, r_name : string, r_comment : string } create type tpch.PartType as closed { - p_partkey : int64, + p_partkey : bigint, p_name : string, p_mfgr : string, p_brand : string, p_type : string, - p_size : int64, + p_size : bigint, p_container : string, p_retailprice : double, p_comment : string @@ -109,9 +109,9 @@ create type tpch.PartType as create type tpch.PartSuppType as closed { - ps_partkey : int64, - ps_suppkey : int64, - ps_availqty : int64, + ps_partkey : bigint, + ps_suppkey : bigint, + ps_availqty : bigint, ps_supplycost : double, ps_comment : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q20_potential_part_promotion/q20_potential_part_promotion.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q20_potential_part_promotion/q20_potential_part_promotion.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q20_potential_part_promotion/q20_potential_part_promotion.3.query.sqlpp index 82e38bf..bcc2099 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q20_potential_part_promotion/q20_potential_part_promotion.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q20_potential_part_promotion/q20_potential_part_promotion.3.query.sqlpp @@ -24,7 +24,7 @@ select element {'s_name':t4.s_name,'s_address':t4.s_address} from ( select distinct element {'ps_suppkey':pst1.ps_suppkey} from ( - select element {'l_partkey':l_partkey,'l_suppkey':l_suppkey,'sum_quantity':(0.5 * tpch.coll_sum(( + select element {'l_partkey':l_partkey,'l_suppkey':l_suppkey,'sum_quantity':(0.5 * tpch.array_sum(( select element i.l_quantity from l as i )))} http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/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-sql-like/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-sql-like/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.1.ddl.sqlpp index bf4e637..b055e7c 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/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-sql-like/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.1.ddl.sqlpp @@ -25,11 +25,11 @@ use tpch; create type tpch.LineItemType as closed { - l_orderkey : int64, - l_partkey : int64, - l_suppkey : int64, - l_linenumber : int64, - l_quantity : int64, + l_orderkey : bigint, + l_partkey : bigint, + l_suppkey : bigint, + l_linenumber : bigint, + l_quantity : bigint, l_extendedprice : double, l_discount : double, l_tax : double, @@ -45,23 +45,23 @@ create type tpch.LineItemType as create type tpch.OrderType as closed { - o_orderkey : int64, - o_custkey : int64, + o_orderkey : bigint, + o_custkey : bigint, o_orderstatus : string, o_totalprice : double, o_orderdate : string, o_orderpriority : string, o_clerk : string, - o_shippriority : int64, + o_shippriority : bigint, o_comment : string } create type tpch.CustomerType as closed { - c_custkey : int64, + c_custkey : bigint, c_name : string, c_address : string, - c_nationkey : int64, + c_nationkey : bigint, c_phone : string, c_acctbal : double, c_mktsegment : string, @@ -70,10 +70,10 @@ create type tpch.CustomerType as create type tpch.SupplierType as closed { - s_suppkey : int64, + s_suppkey : bigint, s_name : string, s_address : string, - s_nationkey : int64, + s_nationkey : bigint, s_phone : string, s_acctbal : double, s_comment : string @@ -81,27 +81,27 @@ create type tpch.SupplierType as create type tpch.NationType as closed { - n_nationkey : int64, + n_nationkey : bigint, n_name : string, - n_regionkey : int64, + n_regionkey : bigint, n_comment : string } create type tpch.RegionType as closed { - r_regionkey : int64, + r_regionkey : bigint, r_name : string, r_comment : string } create type tpch.PartType as closed { - p_partkey : int64, + p_partkey : bigint, p_name : string, p_mfgr : string, p_brand : string, p_type : string, - p_size : int64, + p_size : bigint, p_container : string, p_retailprice : double, p_comment : string @@ -109,9 +109,9 @@ create type tpch.PartType as create type tpch.PartSuppType as closed { - ps_partkey : int64, - ps_suppkey : int64, - ps_availqty : int64, + ps_partkey : bigint, + ps_suppkey : bigint, + ps_availqty : bigint, ps_supplycost : double, ps_comment : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.3.query.sqlpp index 578d72e..c80b8f3 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.3.query.sqlpp @@ -22,10 +22,10 @@ use tpch; declare function tmp1() { ( - select element {'l_orderkey':l_orderkey,'count_suppkey':COLL_COUNT(( + select element {'l_orderkey':l_orderkey,'count_suppkey':ARRAY_COUNT(( select element i.l_suppkey from l2 as i - )),'max_suppkey':tpch.coll_max(( + )),'max_suppkey':tpch.array_max(( select element i.l_suppkey from l2 as i ))} @@ -39,10 +39,10 @@ declare function tmp1() { }; declare function tmp2() { ( - select element {'l_orderkey':l_orderkey,'count_suppkey':COLL_COUNT(( + select element {'l_orderkey':l_orderkey,'count_suppkey':ARRAY_COUNT(( select element i.l_suppkey from l2 as i - )),'max_suppkey':COLL_MAX(( + )),'max_suppkey':ARRAY_MAX(( select element i.l_suppkey from l2 as i ))} @@ -75,6 +75,6 @@ from ( where ((t2.count_suppkey >= 0) and (t3.l_orderkey = t2.l_orderkey)) ) as t4 group by t4.s_name as s_name -with numwait as COLL_COUNT(t4) +with numwait as ARRAY_COUNT(t4) order by numwait desc,s_name ; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q22_global_sales_opportunity/q22_global_sales_opportunity.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q22_global_sales_opportunity/q22_global_sales_opportunity.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q22_global_sales_opportunity/q22_global_sales_opportunity.1.ddl.sqlpp index bf4e637..b055e7c 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q22_global_sales_opportunity/q22_global_sales_opportunity.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q22_global_sales_opportunity/q22_global_sales_opportunity.1.ddl.sqlpp @@ -25,11 +25,11 @@ use tpch; create type tpch.LineItemType as closed { - l_orderkey : int64, - l_partkey : int64, - l_suppkey : int64, - l_linenumber : int64, - l_quantity : int64, + l_orderkey : bigint, + l_partkey : bigint, + l_suppkey : bigint, + l_linenumber : bigint, + l_quantity : bigint, l_extendedprice : double, l_discount : double, l_tax : double, @@ -45,23 +45,23 @@ create type tpch.LineItemType as create type tpch.OrderType as closed { - o_orderkey : int64, - o_custkey : int64, + o_orderkey : bigint, + o_custkey : bigint, o_orderstatus : string, o_totalprice : double, o_orderdate : string, o_orderpriority : string, o_clerk : string, - o_shippriority : int64, + o_shippriority : bigint, o_comment : string } create type tpch.CustomerType as closed { - c_custkey : int64, + c_custkey : bigint, c_name : string, c_address : string, - c_nationkey : int64, + c_nationkey : bigint, c_phone : string, c_acctbal : double, c_mktsegment : string, @@ -70,10 +70,10 @@ create type tpch.CustomerType as create type tpch.SupplierType as closed { - s_suppkey : int64, + s_suppkey : bigint, s_name : string, s_address : string, - s_nationkey : int64, + s_nationkey : bigint, s_phone : string, s_acctbal : double, s_comment : string @@ -81,27 +81,27 @@ create type tpch.SupplierType as create type tpch.NationType as closed { - n_nationkey : int64, + n_nationkey : bigint, n_name : string, - n_regionkey : int64, + n_regionkey : bigint, n_comment : string } create type tpch.RegionType as closed { - r_regionkey : int64, + r_regionkey : bigint, r_name : string, r_comment : string } create type tpch.PartType as closed { - p_partkey : int64, + p_partkey : bigint, p_name : string, p_mfgr : string, p_brand : string, p_type : string, - p_size : int64, + p_size : bigint, p_container : string, p_retailprice : double, p_comment : string @@ -109,9 +109,9 @@ create type tpch.PartType as create type tpch.PartSuppType as closed { - ps_partkey : int64, - ps_suppkey : int64, - ps_availqty : int64, + ps_partkey : bigint, + ps_suppkey : bigint, + ps_availqty : bigint, ps_supplycost : double, ps_comment : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q22_global_sales_opportunity/q22_global_sales_opportunity.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q22_global_sales_opportunity/q22_global_sales_opportunity.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q22_global_sales_opportunity/q22_global_sales_opportunity.3.query.sqlpp index 328c753..c64a54c 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q22_global_sales_opportunity/q22_global_sales_opportunity.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/q22_global_sales_opportunity/q22_global_sales_opportunity.3.query.sqlpp @@ -26,12 +26,12 @@ declare function q22_customer_tmp() { from Customer as c ) }; -with avg as tpch.coll_avg(( +with avg as tpch.array_avg(( select element c.c_acctbal from Customer as c where (c.c_acctbal > 0.0) )) -select element {'cntrycode':cntrycode,'numcust':tpch.count(ct),'totacctbal':tpch.coll_sum(( +select element {'cntrycode':cntrycode,'numcust':tpch.count(ct),'totacctbal':tpch.array_sum(( select element i.c_acctbal from ct as i ))} http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue601/query-issue601.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue601/query-issue601.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue601/query-issue601.1.ddl.sqlpp index 81d1a24..b906c60 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue601/query-issue601.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue601/query-issue601.1.ddl.sqlpp @@ -31,10 +31,10 @@ use tpch; create type tpch.LineItemType as closed { - l_orderkey : int64, - l_partkey : int64, - l_suppkey : int64, - l_linenumber : int64, + l_orderkey : bigint, + l_partkey : bigint, + l_suppkey : bigint, + l_linenumber : bigint, l_quantity : double, l_extendedprice : double, l_discount : double, http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue601/query-issue601.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue601/query-issue601.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue601/query-issue601.3.query.sqlpp index 733924e..89cfd2a 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue601/query-issue601.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue601/query-issue601.3.query.sqlpp @@ -26,7 +26,7 @@ use tpch; -select element {'l_linenumber':l_linenumber,'count_order':COLL_COUNT(l)} +select element {'l_linenumber':l_linenumber,'count_order':ARRAY_COUNT(l)} from LineItem as l group by l.l_linenumber as l_linenumber ; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue638/query-issue638.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue638/query-issue638.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue638/query-issue638.1.ddl.sqlpp index 6eaf580..327f1cd 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue638/query-issue638.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue638/query-issue638.1.ddl.sqlpp @@ -31,11 +31,11 @@ use tpch; create type tpch.LineItemType as closed { - l_orderkey : int64, - l_partkey : int64, - l_suppkey : int64, - l_linenumber : int64, - l_quantity : int64, + l_orderkey : bigint, + l_partkey : bigint, + l_suppkey : bigint, + l_linenumber : bigint, + l_quantity : bigint, l_extendedprice : double, l_discount : double, l_tax : double, @@ -51,23 +51,23 @@ create type tpch.LineItemType as create type tpch.OrderType as closed { - o_orderkey : int64, - o_custkey : int64, + o_orderkey : bigint, + o_custkey : bigint, o_orderstatus : string, o_totalprice : double, o_orderdate : string, o_orderpriority : string, o_clerk : string, - o_shippriority : int64, + o_shippriority : bigint, o_comment : string } create type tpch.CustomerType as closed { - c_custkey : int64, + c_custkey : bigint, c_name : string, c_address : string, - c_nationkey : int64, + c_nationkey : bigint, c_phone : string, c_acctbal : double, c_mktsegment : string, @@ -76,10 +76,10 @@ create type tpch.CustomerType as create type tpch.SupplierType as closed { - s_suppkey : int64, + s_suppkey : bigint, s_name : string, s_address : string, - s_nationkey : int64, + s_nationkey : bigint, s_phone : string, s_acctbal : double, s_comment : string @@ -87,27 +87,27 @@ create type tpch.SupplierType as create type tpch.NationType as closed { - n_nationkey : int64, + n_nationkey : bigint, n_name : string, - n_regionkey : int64, + n_regionkey : bigint, n_comment : string } create type tpch.RegionType as closed { - r_regionkey : int64, + r_regionkey : bigint, r_name : string, r_comment : string } create type tpch.PartType as closed { - p_partkey : int64, + p_partkey : bigint, p_name : string, p_mfgr : string, p_brand : string, p_type : string, - p_size : int64, + p_size : bigint, p_container : string, p_retailprice : double, p_comment : string @@ -115,9 +115,9 @@ create type tpch.PartType as create type tpch.PartSuppType as closed { - ps_partkey : int64, - ps_suppkey : int64, - ps_availqty : int64, + ps_partkey : bigint, + ps_suppkey : bigint, + ps_availqty : bigint, ps_supplycost : double, ps_comment : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue638/query-issue638.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue638/query-issue638.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue638/query-issue638.3.query.sqlpp index 3507b9f..fd99362 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue638/query-issue638.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue638/query-issue638.3.query.sqlpp @@ -26,7 +26,7 @@ use tpch; -select element {'nation':nation,'o_year':o_year,'sum_profit':COLL_SUM(( +select element {'nation':nation,'o_year':o_year,'sum_profit':ARRAY_SUM(( select element pr.amount from profit as pr ))} http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue785-2/query-issue785-2.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue785-2/query-issue785-2.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue785-2/query-issue785-2.1.ddl.sqlpp index cb254c3..bd0e8f5 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue785-2/query-issue785-2.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue785-2/query-issue785-2.1.ddl.sqlpp @@ -31,23 +31,23 @@ use tpch; create type tpch.OrderType as closed { - o_orderkey : int64, - o_custkey : int64, + o_orderkey : bigint, + o_custkey : bigint, o_orderstatus : string, o_totalprice : double, o_orderdate : string, o_orderpriority : string, o_clerk : string, - o_shippriority : int64, + o_shippriority : bigint, o_comment : string } create type tpch.CustomerType as closed { - c_custkey : int64, + c_custkey : bigint, c_name : string, c_address : string, - c_nationkey : int64, + c_nationkey : bigint, c_phone : string, c_acctbal : double, c_mktsegment : string, @@ -56,10 +56,10 @@ create type tpch.CustomerType as create type tpch.SupplierType as closed { - s_suppkey : int64, + s_suppkey : bigint, s_name : string, s_address : string, - s_nationkey : int64, + s_nationkey : bigint, s_phone : string, s_acctbal : double, s_comment : string @@ -67,15 +67,15 @@ create type tpch.SupplierType as create type tpch.NationType as closed { - n_nationkey : int64, + n_nationkey : bigint, n_name : string, - n_regionkey : int64, + n_regionkey : bigint, n_comment : string } create type tpch.RegionType as closed { - r_regionkey : int64, + r_regionkey : bigint, r_name : string, r_comment : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue785-2/query-issue785-2.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue785-2/query-issue785-2.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue785-2/query-issue785-2.3.query.sqlpp index 0127261..71d2bad 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue785-2/query-issue785-2.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue785-2/query-issue785-2.3.query.sqlpp @@ -39,7 +39,7 @@ with t as ( Orders as orders where ((orders.o_custkey = customer.c_custkey) and (customer.c_nationkey = n.n_nationkey)) group by orders.o_orderdate as orderdate,n.n_nationkey as nation_key - with sum as COLL_SUM(( + with sum as ARRAY_SUM(( select element o.o_totalprice from orders as o )) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue785/query-issue785.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue785/query-issue785.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue785/query-issue785.1.ddl.sqlpp index cb254c3..bd0e8f5 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue785/query-issue785.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue785/query-issue785.1.ddl.sqlpp @@ -31,23 +31,23 @@ use tpch; create type tpch.OrderType as closed { - o_orderkey : int64, - o_custkey : int64, + o_orderkey : bigint, + o_custkey : bigint, o_orderstatus : string, o_totalprice : double, o_orderdate : string, o_orderpriority : string, o_clerk : string, - o_shippriority : int64, + o_shippriority : bigint, o_comment : string } create type tpch.CustomerType as closed { - c_custkey : int64, + c_custkey : bigint, c_name : string, c_address : string, - c_nationkey : int64, + c_nationkey : bigint, c_phone : string, c_acctbal : double, c_mktsegment : string, @@ -56,10 +56,10 @@ create type tpch.CustomerType as create type tpch.SupplierType as closed { - s_suppkey : int64, + s_suppkey : bigint, s_name : string, s_address : string, - s_nationkey : int64, + s_nationkey : bigint, s_phone : string, s_acctbal : double, s_comment : string @@ -67,15 +67,15 @@ create type tpch.SupplierType as create type tpch.NationType as closed { - n_nationkey : int64, + n_nationkey : bigint, n_name : string, - n_regionkey : int64, + n_regionkey : bigint, n_comment : string } create type tpch.RegionType as closed { - r_regionkey : int64, + r_regionkey : bigint, r_name : string, r_comment : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue785/query-issue785.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue785/query-issue785.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue785/query-issue785.3.query.sqlpp index db98f32..b65aa21 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue785/query-issue785.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue785/query-issue785.3.query.sqlpp @@ -30,7 +30,7 @@ select element {'nation_key':nation_key,'sum_price':( select element {'orderdate':od,'sum_price':sum} from x as i group by i.order_date as od - with sum as COLL_SUM(( + with sum as ARRAY_SUM(( select element s.sum_price from i as s )) @@ -38,7 +38,7 @@ select element {'nation_key':nation_key,'sum_price':( limit 3 )} from ( - select element {'nation_key':nation_key,'order_date':orderdate,'sum_price':COLL_SUM(( + select element {'nation_key':nation_key,'order_date':orderdate,'sum_price':ARRAY_SUM(( select element o.o_totalprice from orders as o ))} http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue786/query-issue786.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue786/query-issue786.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue786/query-issue786.1.ddl.sqlpp index 997b4e9..c20e577 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue786/query-issue786.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue786/query-issue786.1.ddl.sqlpp @@ -31,23 +31,23 @@ use tpch; create type tpch.OrderType as closed { - o_orderkey : int32, - o_custkey : int32, + o_orderkey : integer, + o_custkey : integer, o_orderstatus : string, o_totalprice : double, o_orderdate : string, o_orderpriority : string, o_clerk : string, - o_shippriority : int32, + o_shippriority : integer, o_comment : string } create type tpch.CustomerType as closed { - c_custkey : int32, + c_custkey : integer, c_name : string, c_address : string, - c_nationkey : int32, + c_nationkey : integer, c_phone : string, c_acctbal : double, c_mktsegment : string, @@ -56,10 +56,10 @@ create type tpch.CustomerType as create type tpch.SupplierType as closed { - s_suppkey : int32, + s_suppkey : integer, s_name : string, s_address : string, - s_nationkey : int32, + s_nationkey : integer, s_phone : string, s_acctbal : double, s_comment : string @@ -67,15 +67,15 @@ create type tpch.SupplierType as create type tpch.NationType as closed { - n_nationkey : int32, + n_nationkey : integer, n_name : string, - n_regionkey : int32, + n_regionkey : integer, n_comment : string } create type tpch.RegionType as closed { - r_regionkey : int32, + r_regionkey : integer, r_name : string, r_comment : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue786/query-issue786.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue786/query-issue786.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue786/query-issue786.3.query.sqlpp index 7098a55..0064600 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue786/query-issue786.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-like/query-issue786/query-issue786.3.query.sqlpp @@ -32,7 +32,7 @@ select element {'nation_key':nation.n_nationkey,'name':nation.n_name,'aggregates Customer as customer where ((orders.o_custkey = customer.c_custkey) and (customer.c_nationkey = nation.n_nationkey)) group by orders.o_orderdate as orderdate - with sum as COLL_SUM(( + with sum as ARRAY_SUM(( select element o.o_totalprice from orders as o )) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/distinct_by/distinct_by.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/distinct_by/distinct_by.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/distinct_by/distinct_by.1.ddl.sqlpp index 4d4bd1c..d50dd81 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/distinct_by/distinct_by.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/distinct_by/distinct_by.1.ddl.sqlpp @@ -25,10 +25,10 @@ use tpch; create type tpch.LineItemType as closed { - l_orderkey : int32, - l_partkey : int32, - l_suppkey : int32, - l_linenumber : int32, + l_orderkey : integer, + l_partkey : integer, + l_suppkey : integer, + l_linenumber : integer, l_quantity : double, l_extendedprice : double, l_discount : double, http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/group_no_agg/group_no_agg.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/group_no_agg/group_no_agg.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/group_no_agg/group_no_agg.1.ddl.sqlpp index fbf62ab..3cbe494 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/group_no_agg/group_no_agg.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/group_no_agg/group_no_agg.1.ddl.sqlpp @@ -25,7 +25,7 @@ use tpch; create type tpch.RegionType as closed { - r_regionkey : int32, + r_regionkey : integer, r_name : string, r_comment : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/nest_aggregate/nest_aggregate.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/nest_aggregate/nest_aggregate.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/nest_aggregate/nest_aggregate.1.ddl.sqlpp index 52678df..089efc3 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/nest_aggregate/nest_aggregate.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/nest_aggregate/nest_aggregate.1.ddl.sqlpp @@ -31,23 +31,23 @@ use tpch; create type tpch.OrderType as closed { - o_orderkey : int64, - o_custkey : int64, + o_orderkey : bigint, + o_custkey : bigint, o_orderstatus : string, o_totalprice : double, o_orderdate : string, o_orderpriority : string, o_clerk : string, - o_shippriority : int64, + o_shippriority : bigint, o_comment : string } create type tpch.CustomerType as closed { - c_custkey : int64, + c_custkey : bigint, c_name : string, c_address : string, - c_nationkey : int64, + c_nationkey : bigint, c_phone : string, c_acctbal : double, c_mktsegment : string, @@ -56,10 +56,10 @@ create type tpch.CustomerType as create type tpch.SupplierType as closed { - s_suppkey : int64, + s_suppkey : bigint, s_name : string, s_address : string, - s_nationkey : int64, + s_nationkey : bigint, s_phone : string, s_acctbal : double, s_comment : string @@ -67,15 +67,15 @@ create type tpch.SupplierType as create type tpch.NationType as closed { - n_nationkey : int64, + n_nationkey : bigint, n_name : string, - n_regionkey : int64, + n_regionkey : bigint, n_comment : string } create type tpch.RegionType as closed { - r_regionkey : int64, + r_regionkey : bigint, r_name : string, r_comment : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/nest_aggregate2/nest_aggregate2.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/nest_aggregate2/nest_aggregate2.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/nest_aggregate2/nest_aggregate2.1.ddl.sqlpp index 52678df..089efc3 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/nest_aggregate2/nest_aggregate2.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/nest_aggregate2/nest_aggregate2.1.ddl.sqlpp @@ -31,23 +31,23 @@ use tpch; create type tpch.OrderType as closed { - o_orderkey : int64, - o_custkey : int64, + o_orderkey : bigint, + o_custkey : bigint, o_orderstatus : string, o_totalprice : double, o_orderdate : string, o_orderpriority : string, o_clerk : string, - o_shippriority : int64, + o_shippriority : bigint, o_comment : string } create type tpch.CustomerType as closed { - c_custkey : int64, + c_custkey : bigint, c_name : string, c_address : string, - c_nationkey : int64, + c_nationkey : bigint, c_phone : string, c_acctbal : double, c_mktsegment : string, @@ -56,10 +56,10 @@ create type tpch.CustomerType as create type tpch.SupplierType as closed { - s_suppkey : int64, + s_suppkey : bigint, s_name : string, s_address : string, - s_nationkey : int64, + s_nationkey : bigint, s_phone : string, s_acctbal : double, s_comment : string @@ -67,15 +67,15 @@ create type tpch.SupplierType as create type tpch.NationType as closed { - n_nationkey : int64, + n_nationkey : bigint, n_name : string, - n_regionkey : int64, + n_regionkey : bigint, n_comment : string } create type tpch.RegionType as closed { - r_regionkey : int64, + r_regionkey : bigint, r_name : string, r_comment : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q01_pricing_summary_report_2/q01_pricing_summary_report_2.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q01_pricing_summary_report_2/q01_pricing_summary_report_2.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q01_pricing_summary_report_2/q01_pricing_summary_report_2.1.ddl.sqlpp index 211ef99..92698ab 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q01_pricing_summary_report_2/q01_pricing_summary_report_2.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q01_pricing_summary_report_2/q01_pricing_summary_report_2.1.ddl.sqlpp @@ -25,10 +25,10 @@ use tpch; create type tpch.LineItemType as closed { - l_orderkey : int64, - l_partkey : int64, - l_suppkey : int64, - l_linenumber : int64, + l_orderkey : bigint, + l_partkey : bigint, + l_suppkey : bigint, + l_linenumber : bigint, l_quantity : double, l_extendedprice : double, l_discount : double, http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/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-sql-sugar/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.1.ddl.sqlpp index 211ef99..92698ab 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.1.ddl.sqlpp @@ -25,10 +25,10 @@ use tpch; create type tpch.LineItemType as closed { - l_orderkey : int64, - l_partkey : int64, - l_suppkey : int64, - l_linenumber : int64, + l_orderkey : bigint, + l_partkey : bigint, + l_suppkey : bigint, + l_linenumber : bigint, l_quantity : double, l_extendedprice : double, l_discount : double, http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q02_minimum_cost_supplier/q02_minimum_cost_supplier.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q02_minimum_cost_supplier/q02_minimum_cost_supplier.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q02_minimum_cost_supplier/q02_minimum_cost_supplier.1.ddl.sqlpp index 3e3f696..6cbdf11 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q02_minimum_cost_supplier/q02_minimum_cost_supplier.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q02_minimum_cost_supplier/q02_minimum_cost_supplier.1.ddl.sqlpp @@ -25,11 +25,11 @@ use tpch; create type tpch.LineItemType as closed { - l_orderkey : int64, - l_partkey : int64, - l_suppkey : int64, - l_linenumber : int64, - l_quantity : int64, + l_orderkey : bigint, + l_partkey : bigint, + l_suppkey : bigint, + l_linenumber : bigint, + l_quantity : bigint, l_extendedprice : double, l_discount : double, l_tax : double, @@ -45,23 +45,23 @@ create type tpch.LineItemType as create type tpch.OrderType as closed { - o_orderkey : int64, - o_custkey : int64, + o_orderkey : bigint, + o_custkey : bigint, o_orderstatus : string, o_totalprice : double, o_orderdate : string, o_orderpriority : string, o_clerk : string, - o_shippriority : int64, + o_shippriority : bigint, o_comment : string } create type tpch.CustomerType as closed { - c_custkey : int64, + c_custkey : bigint, c_name : string, c_address : string, - c_nationkey : int64, + c_nationkey : bigint, c_phone : string, c_acctbal : double, c_mktsegment : string, @@ -70,10 +70,10 @@ create type tpch.CustomerType as create type tpch.SupplierType as closed { - s_suppkey : int64, + s_suppkey : bigint, s_name : string, s_address : string, - s_nationkey : int64, + s_nationkey : bigint, s_phone : string, s_acctbal : double, s_comment : string @@ -81,27 +81,27 @@ create type tpch.SupplierType as create type tpch.NationType as closed { - n_nationkey : int64, + n_nationkey : bigint, n_name : string, - n_regionkey : int64, + n_regionkey : bigint, n_comment : string } create type tpch.RegionType as closed { - r_regionkey : int64, + r_regionkey : bigint, r_name : string, r_comment : string } create type tpch.PartType as closed { - p_partkey : int64, + p_partkey : bigint, p_name : string, p_mfgr : string, p_brand : string, p_type : string, - p_size : int64, + p_size : bigint, p_container : string, p_retailprice : double, p_comment : string @@ -109,9 +109,9 @@ create type tpch.PartType as create type tpch.PartSuppType as closed { - ps_partkey : int64, - ps_suppkey : int64, - ps_availqty : int64, + ps_partkey : bigint, + ps_suppkey : bigint, + ps_availqty : bigint, ps_supplycost : double, ps_comment : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q03_shipping_priority_nt/q03_shipping_priority_nt.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q03_shipping_priority_nt/q03_shipping_priority_nt.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q03_shipping_priority_nt/q03_shipping_priority_nt.1.ddl.sqlpp index 3e3f696..6cbdf11 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q03_shipping_priority_nt/q03_shipping_priority_nt.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q03_shipping_priority_nt/q03_shipping_priority_nt.1.ddl.sqlpp @@ -25,11 +25,11 @@ use tpch; create type tpch.LineItemType as closed { - l_orderkey : int64, - l_partkey : int64, - l_suppkey : int64, - l_linenumber : int64, - l_quantity : int64, + l_orderkey : bigint, + l_partkey : bigint, + l_suppkey : bigint, + l_linenumber : bigint, + l_quantity : bigint, l_extendedprice : double, l_discount : double, l_tax : double, @@ -45,23 +45,23 @@ create type tpch.LineItemType as create type tpch.OrderType as closed { - o_orderkey : int64, - o_custkey : int64, + o_orderkey : bigint, + o_custkey : bigint, o_orderstatus : string, o_totalprice : double, o_orderdate : string, o_orderpriority : string, o_clerk : string, - o_shippriority : int64, + o_shippriority : bigint, o_comment : string } create type tpch.CustomerType as closed { - c_custkey : int64, + c_custkey : bigint, c_name : string, c_address : string, - c_nationkey : int64, + c_nationkey : bigint, c_phone : string, c_acctbal : double, c_mktsegment : string, @@ -70,10 +70,10 @@ create type tpch.CustomerType as create type tpch.SupplierType as closed { - s_suppkey : int64, + s_suppkey : bigint, s_name : string, s_address : string, - s_nationkey : int64, + s_nationkey : bigint, s_phone : string, s_acctbal : double, s_comment : string @@ -81,27 +81,27 @@ create type tpch.SupplierType as create type tpch.NationType as closed { - n_nationkey : int64, + n_nationkey : bigint, n_name : string, - n_regionkey : int64, + n_regionkey : bigint, n_comment : string } create type tpch.RegionType as closed { - r_regionkey : int64, + r_regionkey : bigint, r_name : string, r_comment : string } create type tpch.PartType as closed { - p_partkey : int64, + p_partkey : bigint, p_name : string, p_mfgr : string, p_brand : string, p_type : string, - p_size : int64, + p_size : bigint, p_container : string, p_retailprice : double, p_comment : string @@ -109,9 +109,9 @@ create type tpch.PartType as create type tpch.PartSuppType as closed { - ps_partkey : int64, - ps_suppkey : int64, - ps_availqty : int64, + ps_partkey : bigint, + ps_suppkey : bigint, + ps_availqty : bigint, ps_supplycost : double, ps_comment : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q04_order_priority/q04_order_priority.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q04_order_priority/q04_order_priority.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q04_order_priority/q04_order_priority.1.ddl.sqlpp index 3e3f696..6cbdf11 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q04_order_priority/q04_order_priority.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q04_order_priority/q04_order_priority.1.ddl.sqlpp @@ -25,11 +25,11 @@ use tpch; create type tpch.LineItemType as closed { - l_orderkey : int64, - l_partkey : int64, - l_suppkey : int64, - l_linenumber : int64, - l_quantity : int64, + l_orderkey : bigint, + l_partkey : bigint, + l_suppkey : bigint, + l_linenumber : bigint, + l_quantity : bigint, l_extendedprice : double, l_discount : double, l_tax : double, @@ -45,23 +45,23 @@ create type tpch.LineItemType as create type tpch.OrderType as closed { - o_orderkey : int64, - o_custkey : int64, + o_orderkey : bigint, + o_custkey : bigint, o_orderstatus : string, o_totalprice : double, o_orderdate : string, o_orderpriority : string, o_clerk : string, - o_shippriority : int64, + o_shippriority : bigint, o_comment : string } create type tpch.CustomerType as closed { - c_custkey : int64, + c_custkey : bigint, c_name : string, c_address : string, - c_nationkey : int64, + c_nationkey : bigint, c_phone : string, c_acctbal : double, c_mktsegment : string, @@ -70,10 +70,10 @@ create type tpch.CustomerType as create type tpch.SupplierType as closed { - s_suppkey : int64, + s_suppkey : bigint, s_name : string, s_address : string, - s_nationkey : int64, + s_nationkey : bigint, s_phone : string, s_acctbal : double, s_comment : string @@ -81,27 +81,27 @@ create type tpch.SupplierType as create type tpch.NationType as closed { - n_nationkey : int64, + n_nationkey : bigint, n_name : string, - n_regionkey : int64, + n_regionkey : bigint, n_comment : string } create type tpch.RegionType as closed { - r_regionkey : int64, + r_regionkey : bigint, r_name : string, r_comment : string } create type tpch.PartType as closed { - p_partkey : int64, + p_partkey : bigint, p_name : string, p_mfgr : string, p_brand : string, p_type : string, - p_size : int64, + p_size : bigint, p_container : string, p_retailprice : double, p_comment : string @@ -109,9 +109,9 @@ create type tpch.PartType as create type tpch.PartSuppType as closed { - ps_partkey : int64, - ps_suppkey : int64, - ps_availqty : int64, + ps_partkey : bigint, + ps_suppkey : bigint, + ps_availqty : bigint, ps_supplycost : double, ps_comment : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q05_local_supplier_volume/q05_local_supplier_volume.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q05_local_supplier_volume/q05_local_supplier_volume.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q05_local_supplier_volume/q05_local_supplier_volume.1.ddl.sqlpp index 1871e19..0db8d36 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q05_local_supplier_volume/q05_local_supplier_volume.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q05_local_supplier_volume/q05_local_supplier_volume.1.ddl.sqlpp @@ -25,11 +25,11 @@ use tpch; create type tpch.LineItemType as closed { - l_orderkey : int32, - l_partkey : int32, - l_suppkey : int32, - l_linenumber : int32, - l_quantity : int32, + l_orderkey : integer, + l_partkey : integer, + l_suppkey : integer, + l_linenumber : integer, + l_quantity : integer, l_extendedprice : double, l_discount : double, l_tax : double, @@ -45,23 +45,23 @@ create type tpch.LineItemType as create type tpch.OrderType as closed { - o_orderkey : int32, - o_custkey : int32, + o_orderkey : integer, + o_custkey : integer, o_orderstatus : string, o_totalprice : double, o_orderdate : string, o_orderpriority : string, o_clerk : string, - o_shippriority : int32, + o_shippriority : integer, o_comment : string } create type tpch.CustomerType as closed { - c_custkey : int32, + c_custkey : integer, c_name : string, c_address : string, - c_nationkey : int32, + c_nationkey : integer, c_phone : string, c_acctbal : double, c_mktsegment : string, @@ -70,10 +70,10 @@ create type tpch.CustomerType as create type tpch.SupplierType as closed { - s_suppkey : int32, + s_suppkey : integer, s_name : string, s_address : string, - s_nationkey : int32, + s_nationkey : integer, s_phone : string, s_acctbal : double, s_comment : string @@ -81,27 +81,27 @@ create type tpch.SupplierType as create type tpch.NationType as closed { - n_nationkey : int32, + n_nationkey : integer, n_name : string, - n_regionkey : int32, + n_regionkey : integer, n_comment : string } create type tpch.RegionType as closed { - r_regionkey : int32, + r_regionkey : integer, r_name : string, r_comment : string } create type tpch.PartType as closed { - p_partkey : int32, + p_partkey : integer, p_name : string, p_mfgr : string, p_brand : string, p_type : string, - p_size : int32, + p_size : integer, p_container : string, p_retailprice : double, p_comment : string @@ -109,9 +109,9 @@ create type tpch.PartType as create type tpch.PartSuppType as closed { - ps_partkey : int32, - ps_suppkey : int32, - ps_availqty : int32, + ps_partkey : integer, + ps_suppkey : integer, + ps_availqty : integer, ps_supplycost : double, ps_comment : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q06_forecast_revenue_change/q06_forecast_revenue_change.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q06_forecast_revenue_change/q06_forecast_revenue_change.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q06_forecast_revenue_change/q06_forecast_revenue_change.1.ddl.sqlpp index 1871e19..0db8d36 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q06_forecast_revenue_change/q06_forecast_revenue_change.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q06_forecast_revenue_change/q06_forecast_revenue_change.1.ddl.sqlpp @@ -25,11 +25,11 @@ use tpch; create type tpch.LineItemType as closed { - l_orderkey : int32, - l_partkey : int32, - l_suppkey : int32, - l_linenumber : int32, - l_quantity : int32, + l_orderkey : integer, + l_partkey : integer, + l_suppkey : integer, + l_linenumber : integer, + l_quantity : integer, l_extendedprice : double, l_discount : double, l_tax : double, @@ -45,23 +45,23 @@ create type tpch.LineItemType as create type tpch.OrderType as closed { - o_orderkey : int32, - o_custkey : int32, + o_orderkey : integer, + o_custkey : integer, o_orderstatus : string, o_totalprice : double, o_orderdate : string, o_orderpriority : string, o_clerk : string, - o_shippriority : int32, + o_shippriority : integer, o_comment : string } create type tpch.CustomerType as closed { - c_custkey : int32, + c_custkey : integer, c_name : string, c_address : string, - c_nationkey : int32, + c_nationkey : integer, c_phone : string, c_acctbal : double, c_mktsegment : string, @@ -70,10 +70,10 @@ create type tpch.CustomerType as create type tpch.SupplierType as closed { - s_suppkey : int32, + s_suppkey : integer, s_name : string, s_address : string, - s_nationkey : int32, + s_nationkey : integer, s_phone : string, s_acctbal : double, s_comment : string @@ -81,27 +81,27 @@ create type tpch.SupplierType as create type tpch.NationType as closed { - n_nationkey : int32, + n_nationkey : integer, n_name : string, - n_regionkey : int32, + n_regionkey : integer, n_comment : string } create type tpch.RegionType as closed { - r_regionkey : int32, + r_regionkey : integer, r_name : string, r_comment : string } create type tpch.PartType as closed { - p_partkey : int32, + p_partkey : integer, p_name : string, p_mfgr : string, p_brand : string, p_type : string, - p_size : int32, + p_size : integer, p_container : string, p_retailprice : double, p_comment : string @@ -109,9 +109,9 @@ create type tpch.PartType as create type tpch.PartSuppType as closed { - ps_partkey : int32, - ps_suppkey : int32, - ps_availqty : int32, + ps_partkey : integer, + ps_suppkey : integer, + ps_availqty : integer, ps_supplycost : double, ps_comment : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q07_volume_shipping/q07_volume_shipping.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q07_volume_shipping/q07_volume_shipping.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q07_volume_shipping/q07_volume_shipping.1.ddl.sqlpp index 1871e19..0db8d36 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q07_volume_shipping/q07_volume_shipping.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q07_volume_shipping/q07_volume_shipping.1.ddl.sqlpp @@ -25,11 +25,11 @@ use tpch; create type tpch.LineItemType as closed { - l_orderkey : int32, - l_partkey : int32, - l_suppkey : int32, - l_linenumber : int32, - l_quantity : int32, + l_orderkey : integer, + l_partkey : integer, + l_suppkey : integer, + l_linenumber : integer, + l_quantity : integer, l_extendedprice : double, l_discount : double, l_tax : double, @@ -45,23 +45,23 @@ create type tpch.LineItemType as create type tpch.OrderType as closed { - o_orderkey : int32, - o_custkey : int32, + o_orderkey : integer, + o_custkey : integer, o_orderstatus : string, o_totalprice : double, o_orderdate : string, o_orderpriority : string, o_clerk : string, - o_shippriority : int32, + o_shippriority : integer, o_comment : string } create type tpch.CustomerType as closed { - c_custkey : int32, + c_custkey : integer, c_name : string, c_address : string, - c_nationkey : int32, + c_nationkey : integer, c_phone : string, c_acctbal : double, c_mktsegment : string, @@ -70,10 +70,10 @@ create type tpch.CustomerType as create type tpch.SupplierType as closed { - s_suppkey : int32, + s_suppkey : integer, s_name : string, s_address : string, - s_nationkey : int32, + s_nationkey : integer, s_phone : string, s_acctbal : double, s_comment : string @@ -81,27 +81,27 @@ create type tpch.SupplierType as create type tpch.NationType as closed { - n_nationkey : int32, + n_nationkey : integer, n_name : string, - n_regionkey : int32, + n_regionkey : integer, n_comment : string } create type tpch.RegionType as closed { - r_regionkey : int32, + r_regionkey : integer, r_name : string, r_comment : string } create type tpch.PartType as closed { - p_partkey : int32, + p_partkey : integer, p_name : string, p_mfgr : string, p_brand : string, p_type : string, - p_size : int32, + p_size : integer, p_container : string, p_retailprice : double, p_comment : string @@ -109,9 +109,9 @@ create type tpch.PartType as create type tpch.PartSuppType as closed { - ps_partkey : int32, - ps_suppkey : int32, - ps_availqty : int32, + ps_partkey : integer, + ps_suppkey : integer, + ps_availqty : integer, ps_supplycost : double, ps_comment : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q08_national_market_share/q08_national_market_share.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q08_national_market_share/q08_national_market_share.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q08_national_market_share/q08_national_market_share.1.ddl.sqlpp index 1871e19..0db8d36 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q08_national_market_share/q08_national_market_share.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q08_national_market_share/q08_national_market_share.1.ddl.sqlpp @@ -25,11 +25,11 @@ use tpch; create type tpch.LineItemType as closed { - l_orderkey : int32, - l_partkey : int32, - l_suppkey : int32, - l_linenumber : int32, - l_quantity : int32, + l_orderkey : integer, + l_partkey : integer, + l_suppkey : integer, + l_linenumber : integer, + l_quantity : integer, l_extendedprice : double, l_discount : double, l_tax : double, @@ -45,23 +45,23 @@ create type tpch.LineItemType as create type tpch.OrderType as closed { - o_orderkey : int32, - o_custkey : int32, + o_orderkey : integer, + o_custkey : integer, o_orderstatus : string, o_totalprice : double, o_orderdate : string, o_orderpriority : string, o_clerk : string, - o_shippriority : int32, + o_shippriority : integer, o_comment : string } create type tpch.CustomerType as closed { - c_custkey : int32, + c_custkey : integer, c_name : string, c_address : string, - c_nationkey : int32, + c_nationkey : integer, c_phone : string, c_acctbal : double, c_mktsegment : string, @@ -70,10 +70,10 @@ create type tpch.CustomerType as create type tpch.SupplierType as closed { - s_suppkey : int32, + s_suppkey : integer, s_name : string, s_address : string, - s_nationkey : int32, + s_nationkey : integer, s_phone : string, s_acctbal : double, s_comment : string @@ -81,27 +81,27 @@ create type tpch.SupplierType as create type tpch.NationType as closed { - n_nationkey : int32, + n_nationkey : integer, n_name : string, - n_regionkey : int32, + n_regionkey : integer, n_comment : string } create type tpch.RegionType as closed { - r_regionkey : int32, + r_regionkey : integer, r_name : string, r_comment : string } create type tpch.PartType as closed { - p_partkey : int32, + p_partkey : integer, p_name : string, p_mfgr : string, p_brand : string, p_type : string, - p_size : int32, + p_size : integer, p_container : string, p_retailprice : double, p_comment : string @@ -109,9 +109,9 @@ create type tpch.PartType as create type tpch.PartSuppType as closed { - ps_partkey : int32, - ps_suppkey : int32, - ps_availqty : int32, + ps_partkey : integer, + ps_suppkey : integer, + ps_availqty : integer, ps_supplycost : double, ps_comment : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/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-sql-sugar/q09_product_type_profit_nt/q09_product_type_profit_nt.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q09_product_type_profit_nt/q09_product_type_profit_nt.1.ddl.sqlpp index 1871e19..0db8d36 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q09_product_type_profit_nt/q09_product_type_profit_nt.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q09_product_type_profit_nt/q09_product_type_profit_nt.1.ddl.sqlpp @@ -25,11 +25,11 @@ use tpch; create type tpch.LineItemType as closed { - l_orderkey : int32, - l_partkey : int32, - l_suppkey : int32, - l_linenumber : int32, - l_quantity : int32, + l_orderkey : integer, + l_partkey : integer, + l_suppkey : integer, + l_linenumber : integer, + l_quantity : integer, l_extendedprice : double, l_discount : double, l_tax : double, @@ -45,23 +45,23 @@ create type tpch.LineItemType as create type tpch.OrderType as closed { - o_orderkey : int32, - o_custkey : int32, + o_orderkey : integer, + o_custkey : integer, o_orderstatus : string, o_totalprice : double, o_orderdate : string, o_orderpriority : string, o_clerk : string, - o_shippriority : int32, + o_shippriority : integer, o_comment : string } create type tpch.CustomerType as closed { - c_custkey : int32, + c_custkey : integer, c_name : string, c_address : string, - c_nationkey : int32, + c_nationkey : integer, c_phone : string, c_acctbal : double, c_mktsegment : string, @@ -70,10 +70,10 @@ create type tpch.CustomerType as create type tpch.SupplierType as closed { - s_suppkey : int32, + s_suppkey : integer, s_name : string, s_address : string, - s_nationkey : int32, + s_nationkey : integer, s_phone : string, s_acctbal : double, s_comment : string @@ -81,27 +81,27 @@ create type tpch.SupplierType as create type tpch.NationType as closed { - n_nationkey : int32, + n_nationkey : integer, n_name : string, - n_regionkey : int32, + n_regionkey : integer, n_comment : string } create type tpch.RegionType as closed { - r_regionkey : int32, + r_regionkey : integer, r_name : string, r_comment : string } create type tpch.PartType as closed { - p_partkey : int32, + p_partkey : integer, p_name : string, p_mfgr : string, p_brand : string, p_type : string, - p_size : int32, + p_size : integer, p_container : string, p_retailprice : double, p_comment : string @@ -109,9 +109,9 @@ create type tpch.PartType as create type tpch.PartSuppType as closed { - ps_partkey : int32, - ps_suppkey : int32, - ps_availqty : int32, + ps_partkey : integer, + ps_suppkey : integer, + ps_availqty : integer, ps_supplycost : double, ps_comment : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q10_returned_item/q10_returned_item.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q10_returned_item/q10_returned_item.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q10_returned_item/q10_returned_item.1.ddl.sqlpp index 1871e19..0db8d36 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q10_returned_item/q10_returned_item.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q10_returned_item/q10_returned_item.1.ddl.sqlpp @@ -25,11 +25,11 @@ use tpch; create type tpch.LineItemType as closed { - l_orderkey : int32, - l_partkey : int32, - l_suppkey : int32, - l_linenumber : int32, - l_quantity : int32, + l_orderkey : integer, + l_partkey : integer, + l_suppkey : integer, + l_linenumber : integer, + l_quantity : integer, l_extendedprice : double, l_discount : double, l_tax : double, @@ -45,23 +45,23 @@ create type tpch.LineItemType as create type tpch.OrderType as closed { - o_orderkey : int32, - o_custkey : int32, + o_orderkey : integer, + o_custkey : integer, o_orderstatus : string, o_totalprice : double, o_orderdate : string, o_orderpriority : string, o_clerk : string, - o_shippriority : int32, + o_shippriority : integer, o_comment : string } create type tpch.CustomerType as closed { - c_custkey : int32, + c_custkey : integer, c_name : string, c_address : string, - c_nationkey : int32, + c_nationkey : integer, c_phone : string, c_acctbal : double, c_mktsegment : string, @@ -70,10 +70,10 @@ create type tpch.CustomerType as create type tpch.SupplierType as closed { - s_suppkey : int32, + s_suppkey : integer, s_name : string, s_address : string, - s_nationkey : int32, + s_nationkey : integer, s_phone : string, s_acctbal : double, s_comment : string @@ -81,27 +81,27 @@ create type tpch.SupplierType as create type tpch.NationType as closed { - n_nationkey : int32, + n_nationkey : integer, n_name : string, - n_regionkey : int32, + n_regionkey : integer, n_comment : string } create type tpch.RegionType as closed { - r_regionkey : int32, + r_regionkey : integer, r_name : string, r_comment : string } create type tpch.PartType as closed { - p_partkey : int32, + p_partkey : integer, p_name : string, p_mfgr : string, p_brand : string, p_type : string, - p_size : int32, + p_size : integer, p_container : string, p_retailprice : double, p_comment : string @@ -109,9 +109,9 @@ create type tpch.PartType as create type tpch.PartSuppType as closed { - ps_partkey : int32, - ps_suppkey : int32, - ps_availqty : int32, + ps_partkey : integer, + ps_suppkey : integer, + ps_availqty : integer, ps_supplycost : double, ps_comment : string } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q10_returned_item_int64/q10_returned_item_int64.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q10_returned_item_int64/q10_returned_item_int64.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q10_returned_item_int64/q10_returned_item_int64.1.ddl.sqlpp index 3e3f696..6cbdf11 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q10_returned_item_int64/q10_returned_item_int64.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpch-sql-sugar/q10_returned_item_int64/q10_returned_item_int64.1.ddl.sqlpp @@ -25,11 +25,11 @@ use tpch; create type tpch.LineItemType as closed { - l_orderkey : int64, - l_partkey : int64, - l_suppkey : int64, - l_linenumber : int64, - l_quantity : int64, + l_orderkey : bigint, + l_partkey : bigint, + l_suppkey : bigint, + l_linenumber : bigint, + l_quantity : bigint, l_extendedprice : double, l_discount : double, l_tax : double, @@ -45,23 +45,23 @@ create type tpch.LineItemType as create type tpch.OrderType as closed { - o_orderkey : int64, - o_custkey : int64, + o_orderkey : bigint, + o_custkey : bigint, o_orderstatus : string, o_totalprice : double, o_orderdate : string, o_orderpriority : string, o_clerk : string, - o_shippriority : int64, + o_shippriority : bigint, o_comment : string } create type tpch.CustomerType as closed { - c_custkey : int64, + c_custkey : bigint, c_name : string, c_address : string, - c_nationkey : int64, + c_nationkey : bigint, c_phone : string, c_acctbal : double, c_mktsegment : string, @@ -70,10 +70,10 @@ create type tpch.CustomerType as create type tpch.SupplierType as closed { - s_suppkey : int64, + s_suppkey : bigint, s_name : string, s_address : string, - s_nationkey : int64, + s_nationkey : bigint, s_phone : string, s_acctbal : double, s_comment : string @@ -81,27 +81,27 @@ create type tpch.SupplierType as create type tpch.NationType as closed { - n_nationkey : int64, + n_nationkey : bigint, n_name : string, - n_regionkey : int64, + n_regionkey : bigint, n_comment : string } create type tpch.RegionType as closed { - r_regionkey : int64, + r_regionkey : bigint, r_name : string, r_comment : string } create type tpch.PartType as closed { - p_partkey : int64, + p_partkey : bigint, p_name : string, p_mfgr : string, p_brand : string, p_type : string, - p_size : int64, + p_size : bigint, p_container : string, p_retailprice : double, p_comment : string @@ -109,9 +109,9 @@ create type tpch.PartType as create type tpch.PartSuppType as closed { - ps_partkey : int64, - ps_suppkey : int64, - ps_availqty : int64, + ps_partkey : bigint, + ps_suppkey : bigint, + ps_availqty : bigint, ps_supplycost : double, ps_comment : string }