You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@asterixdb.apache.org by bu...@apache.org on 2016/09/23 03:14:56 UTC
[14/51] [partial] asterixdb git commit: ASTERIXDB-1539: add aliases
for several builtin types and builtin functions.
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
}