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:58 UTC
[16/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/temporal/insert_from_ext_ds/insert_from_ext_ds.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/insert_from_ext_ds/insert_from_ext_ds.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/insert_from_ext_ds/insert_from_ext_ds.1.ddl.sqlpp
index 07e19b4..10c6d29 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/insert_from_ext_ds/insert_from_ext_ds.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/insert_from_ext_ds/insert_from_ext_ds.1.ddl.sqlpp
@@ -36,8 +36,8 @@ create type testdvt.testtype as
datetimeField : datetime?,
durationField : duration?,
intervalField : interval?,
- yearMonthDurationField : `year-month-duration`?,
- dayTimeDurationField : `day-time-duration`?
+ yearMonthDurationField : `year_month_duration`?,
+ dayTimeDurationField : `day_time_duration`?
}
create external dataset testds(testtype) using localfs((`path`=`asterix_nc1://data/temporal/temporalData.json`),(`format`=`adm`));
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/insert_from_ext_ds_2/insert_from_ext_ds_2.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/insert_from_ext_ds_2/insert_from_ext_ds_2.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/insert_from_ext_ds_2/insert_from_ext_ds_2.1.ddl.sqlpp
index 5a0bebb..0ad459c 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/insert_from_ext_ds_2/insert_from_ext_ds_2.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/insert_from_ext_ds_2/insert_from_ext_ds_2.1.ddl.sqlpp
@@ -34,8 +34,8 @@ create type timeTest.timesType as
time : time,
datetime : datetime,
duration : duration,
- `year-month-duration` : `year-month-duration`,
- `day-time-duration` : `day-time-duration`,
+ `year-month-duration` : `year_month_duration`,
+ `day-time-duration` : `day_time_duration`,
`date-interval` : interval,
`time-interval` : interval,
`datetime-interval` : interval
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/interval_bin/interval_bin.3.query.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/interval_bin/interval_bin.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/interval_bin/interval_bin.3.query.sqlpp
index 1798d59..9c9caaa 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/interval_bin/interval_bin.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/interval_bin/interval_bin.3.query.sqlpp
@@ -24,4 +24,4 @@
use test;
-{'bin1':test.`interval-bin`(test.date('2010-10-30'),test.date('1990-01-01'),test.`year-month-duration`('P1Y')),'bin2':test.`interval-bin`(test.date('2010-10-30'),test.date('-1990-01-01'),test.`year-month-duration`('P1Y')),'bin3':test.`interval-bin`(test.datetime('-1987-11-19T23:49:23.938'),test.datetime('1990-01-01T00:00:00.000Z'),test.`year-month-duration`('P6M')),'bin4':test.`interval-bin`(test.datetime('-1987-11-19T23:49:23.938'),test.datetime('-1990-01-01T00:00:00.000Z'),test.`day-time-duration`('PT12H')),'bin5':test.`interval-bin`(test.time('12:23:34.930+07:00'),test.time('12:00:00'),test.`day-time-duration`('PT2H')),'bin6':test.`interval-bin`(null,test.date('-0023-01-01'),test.`year-month-duration`('P6M')),'bin7':test.`interval-bin`(test.date('2010-10-30'),null,test.`year-month-duration`('P6M')),'bin8':test.`interval-bin`(test.date('2010-10-30'),test.date('-0023-01-01'),null)};
+{'bin1':test.`interval-bin`(test.date('2010-10-30'),test.date('1990-01-01'),test.`year_month_duration`('P1Y')),'bin2':test.`interval-bin`(test.date('2010-10-30'),test.date('-1990-01-01'),test.`year_month_duration`('P1Y')),'bin3':test.`interval-bin`(test.datetime('-1987-11-19T23:49:23.938'),test.datetime('1990-01-01T00:00:00.000Z'),test.`year_month_duration`('P6M')),'bin4':test.`interval-bin`(test.datetime('-1987-11-19T23:49:23.938'),test.datetime('-1990-01-01T00:00:00.000Z'),test.`day_time_duration`('PT12H')),'bin5':test.`interval-bin`(test.time('12:23:34.930+07:00'),test.time('12:00:00'),test.`day_time_duration`('PT2H')),'bin6':test.`interval-bin`(null,test.date('-0023-01-01'),test.`year_month_duration`('P6M')),'bin7':test.`interval-bin`(test.date('2010-10-30'),null,test.`year_month_duration`('P6M')),'bin8':test.`interval-bin`(test.date('2010-10-30'),test.date('-0023-01-01'),null)};
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/interval_bin_gby_0/interval_bin_gby_0.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/interval_bin_gby_0/interval_bin_gby_0.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/interval_bin_gby_0/interval_bin_gby_0.1.ddl.sqlpp
index 250a836..8bd2355 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/interval_bin_gby_0/interval_bin_gby_0.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/interval_bin_gby_0/interval_bin_gby_0.1.ddl.sqlpp
@@ -29,7 +29,7 @@ use test;
create type test.Schema as
closed {
- id : int64,
+ id : bigint,
timestamp : datetime
}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/interval_bin_gby_0/interval_bin_gby_0.3.query.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/interval_bin_gby_0/interval_bin_gby_0.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/interval_bin_gby_0/interval_bin_gby_0.3.query.sqlpp
index 884ded4..bebc724 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/interval_bin_gby_0/interval_bin_gby_0.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/interval_bin_gby_0/interval_bin_gby_0.3.query.sqlpp
@@ -26,6 +26,6 @@ use test;
select element {'tbin':d,'count':test.count(i)}
from tsdata as i
-group by test.`interval-bin`(i.timestamp,test.datetime('1990-01-01T00:00:00.000Z'),test.`year-month-duration`('P20Y')) as d
+group by test.`interval-bin`(i.timestamp,test.datetime('1990-01-01T00:00:00.000Z'),test.`year_month_duration`('P20Y')) as d
order by test.`get-interval-start`(d)
;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/interval_bin_gby_1/interval_bin_gby_1.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/interval_bin_gby_1/interval_bin_gby_1.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/interval_bin_gby_1/interval_bin_gby_1.1.ddl.sqlpp
index 250a836..8bd2355 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/interval_bin_gby_1/interval_bin_gby_1.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/interval_bin_gby_1/interval_bin_gby_1.1.ddl.sqlpp
@@ -29,7 +29,7 @@ use test;
create type test.Schema as
closed {
- id : int64,
+ id : bigint,
timestamp : datetime
}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/interval_bin_gby_1/interval_bin_gby_1.3.query.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/interval_bin_gby_1/interval_bin_gby_1.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/interval_bin_gby_1/interval_bin_gby_1.3.query.sqlpp
index 8c4934c..03984ae 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/interval_bin_gby_1/interval_bin_gby_1.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/interval_bin_gby_1/interval_bin_gby_1.3.query.sqlpp
@@ -26,6 +26,6 @@ use test;
select element {'tbin':d,'count':test.count(i)}
from tsdata as i
-group by test.`interval-bin`(test.`get-time-from-datetime`(i.timestamp),test.time('00:00:00.000Z'),test.`day-time-duration`('PT10M')) as d
+group by test.`interval-bin`(test.`get-time-from-datetime`(i.timestamp),test.time('00:00:00.000Z'),test.`day_time_duration`('PT10M')) as d
order by test.`get-interval-start`(d)
;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins/overlap_bins.3.query.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins/overlap_bins.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins/overlap_bins.3.query.sqlpp
index 90cd95e..2568918 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins/overlap_bins.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins/overlap_bins.3.query.sqlpp
@@ -21,7 +21,7 @@
* Expected result: success
**/
-{ 'timebins':`overlap-bins`(interval(time('17:23:37'),time('18:30:21')),time('00:00:00'),`day-time-duration`('PT30M')),
- 'datebins':`overlap-bins`(interval(date('1984-03-17'),date('2013-08-22')),date('1990-01-01'),`year-month-duration`('P10Y')),
+{ 'timebins':`overlap-bins`(interval(time('17:23:37'),time('18:30:21')),time('00:00:00'),`day_time_duration`('PT30M')),
+ 'datebins':`overlap-bins`(interval(date('1984-03-17'),date('2013-08-22')),date('1990-01-01'),`year_month_duration`('P10Y')),
'datetimebins':`overlap-bins`(interval(datetime('1800-01-01T23:59:48.938'),datetime('2015-07-26T13:28:30.218')),datetime('1900-01-01T00:00:00.000'),
- `year-month-duration`('P100Y'))};
+ `year_month_duration`('P100Y'))};
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_0/overlap_bins_gby_0.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_0/overlap_bins_gby_0.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_0/overlap_bins_gby_0.1.ddl.sqlpp
index 8fe76df..c2e083b 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_0/overlap_bins_gby_0.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_0/overlap_bins_gby_0.1.ddl.sqlpp
@@ -29,9 +29,9 @@ use test;
create type test.Schema as
closed {
- id : int32,
+ id : integer,
time : time,
- duration : `day-time-duration`
+ duration : `day_time_duration`
}
create dataset tsdata(Schema) primary key id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_0/overlap_bins_gby_0.2.update.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_0/overlap_bins_gby_0.2.update.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_0/overlap_bins_gby_0.2.update.sqlpp
index a302aaa..5c8348a 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_0/overlap_bins_gby_0.2.update.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_0/overlap_bins_gby_0.2.update.sqlpp
@@ -25,24 +25,24 @@ use test;
insert into tsdata
-select element {'id':1,'time':test.time('23:49:23.938'),'duration':test.`day-time-duration`('PT5M')};
+select element {'id':1,'time':test.time('23:49:23.938'),'duration':test.`day_time_duration`('PT5M')};
insert into tsdata
-select element {'id':2,'time':test.time('00:27:13.432'),'duration':test.`day-time-duration`('PT1H')};
+select element {'id':2,'time':test.time('00:27:13.432'),'duration':test.`day_time_duration`('PT1H')};
insert into tsdata
-select element {'id':3,'time':test.time('18:00:00'),'duration':test.`day-time-duration`('PT2H')};
+select element {'id':3,'time':test.time('18:00:00'),'duration':test.`day_time_duration`('PT2H')};
insert into tsdata
-select element {'id':4,'time':test.time('234933938'),'duration':test.`day-time-duration`('PT30S')};
+select element {'id':4,'time':test.time('234933938'),'duration':test.`day_time_duration`('PT30S')};
insert into tsdata
-select element {'id':5,'time':test.time('23:58:17.038'),'duration':test.`day-time-duration`('PT39.382S')};
+select element {'id':5,'time':test.time('23:58:17.038'),'duration':test.`day_time_duration`('PT39.382S')};
insert into tsdata
-select element {'id':6,'time':test.time('23:30:00'),'duration':test.`day-time-duration`('PT2M')};
+select element {'id':6,'time':test.time('23:30:00'),'duration':test.`day_time_duration`('PT2M')};
insert into tsdata
-select element {'id':7,'time':test.time('23:22:38'),'duration':test.`day-time-duration`('PT20M')};
+select element {'id':7,'time':test.time('23:22:38'),'duration':test.`day_time_duration`('PT20M')};
insert into tsdata
-select element {'id':8,'time':test.time('17:28:13.900'),'duration':test.`day-time-duration`('PT19S')};
+select element {'id':8,'time':test.time('17:28:13.900'),'duration':test.`day_time_duration`('PT19S')};
insert into tsdata
-select element {'id':9,'time':test.time('07:49:23.938'),'duration':test.`day-time-duration`('PT3H')};
+select element {'id':9,'time':test.time('07:49:23.938'),'duration':test.`day_time_duration`('PT3H')};
insert into tsdata
-select element {'id':10,'time':test.time('09:35:28.039'),'duration':test.`day-time-duration`('PT10H50M')};
+select element {'id':10,'time':test.time('09:35:28.039'),'duration':test.`day_time_duration`('PT10H50M')};
insert into tsdata
-select element {'id':11,'time':test.time('12:49:23.938'),'duration':test.`day-time-duration`('PT3H')};
+select element {'id':11,'time':test.time('12:49:23.938'),'duration':test.`day_time_duration`('PT3H')};
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_0/overlap_bins_gby_0.3.query.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_0/overlap_bins_gby_0.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_0/overlap_bins_gby_0.3.query.sqlpp
index 42ca67b..40fcaea 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_0/overlap_bins_gby_0.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_0/overlap_bins_gby_0.3.query.sqlpp
@@ -28,7 +28,7 @@ select element {'tbin':gen0.bin,'interval':itv,'overlap':test.`get-overlapping-i
from
( select element {'bin':bin,'i':i}
from (select element i from tsdata as i order by i.time) as i,
- test.`overlap-bins`(test.`interval-start-from-time`(i.time,i.duration),test.time('00:00:00'),test.`day-time-duration`('PT1H30M')) as j
+ test.`overlap-bins`(test.`interval-start-from-time`(i.time,i.duration),test.time('00:00:00'),test.`day_time_duration`('PT1H30M')) as j
group by j as bin
order by `get-interval-start`(bin)
) as gen0,
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_1/overlap_bins_gby_1.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_1/overlap_bins_gby_1.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_1/overlap_bins_gby_1.1.ddl.sqlpp
index 8fe76df..c2e083b 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_1/overlap_bins_gby_1.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_1/overlap_bins_gby_1.1.ddl.sqlpp
@@ -29,9 +29,9 @@ use test;
create type test.Schema as
closed {
- id : int32,
+ id : integer,
time : time,
- duration : `day-time-duration`
+ duration : `day_time_duration`
}
create dataset tsdata(Schema) primary key id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_1/overlap_bins_gby_1.2.update.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_1/overlap_bins_gby_1.2.update.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_1/overlap_bins_gby_1.2.update.sqlpp
index a302aaa..5c8348a 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_1/overlap_bins_gby_1.2.update.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_1/overlap_bins_gby_1.2.update.sqlpp
@@ -25,24 +25,24 @@ use test;
insert into tsdata
-select element {'id':1,'time':test.time('23:49:23.938'),'duration':test.`day-time-duration`('PT5M')};
+select element {'id':1,'time':test.time('23:49:23.938'),'duration':test.`day_time_duration`('PT5M')};
insert into tsdata
-select element {'id':2,'time':test.time('00:27:13.432'),'duration':test.`day-time-duration`('PT1H')};
+select element {'id':2,'time':test.time('00:27:13.432'),'duration':test.`day_time_duration`('PT1H')};
insert into tsdata
-select element {'id':3,'time':test.time('18:00:00'),'duration':test.`day-time-duration`('PT2H')};
+select element {'id':3,'time':test.time('18:00:00'),'duration':test.`day_time_duration`('PT2H')};
insert into tsdata
-select element {'id':4,'time':test.time('234933938'),'duration':test.`day-time-duration`('PT30S')};
+select element {'id':4,'time':test.time('234933938'),'duration':test.`day_time_duration`('PT30S')};
insert into tsdata
-select element {'id':5,'time':test.time('23:58:17.038'),'duration':test.`day-time-duration`('PT39.382S')};
+select element {'id':5,'time':test.time('23:58:17.038'),'duration':test.`day_time_duration`('PT39.382S')};
insert into tsdata
-select element {'id':6,'time':test.time('23:30:00'),'duration':test.`day-time-duration`('PT2M')};
+select element {'id':6,'time':test.time('23:30:00'),'duration':test.`day_time_duration`('PT2M')};
insert into tsdata
-select element {'id':7,'time':test.time('23:22:38'),'duration':test.`day-time-duration`('PT20M')};
+select element {'id':7,'time':test.time('23:22:38'),'duration':test.`day_time_duration`('PT20M')};
insert into tsdata
-select element {'id':8,'time':test.time('17:28:13.900'),'duration':test.`day-time-duration`('PT19S')};
+select element {'id':8,'time':test.time('17:28:13.900'),'duration':test.`day_time_duration`('PT19S')};
insert into tsdata
-select element {'id':9,'time':test.time('07:49:23.938'),'duration':test.`day-time-duration`('PT3H')};
+select element {'id':9,'time':test.time('07:49:23.938'),'duration':test.`day_time_duration`('PT3H')};
insert into tsdata
-select element {'id':10,'time':test.time('09:35:28.039'),'duration':test.`day-time-duration`('PT10H50M')};
+select element {'id':10,'time':test.time('09:35:28.039'),'duration':test.`day_time_duration`('PT10H50M')};
insert into tsdata
-select element {'id':11,'time':test.time('12:49:23.938'),'duration':test.`day-time-duration`('PT3H')};
+select element {'id':11,'time':test.time('12:49:23.938'),'duration':test.`day_time_duration`('PT3H')};
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_1/overlap_bins_gby_1.3.query.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_1/overlap_bins_gby_1.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_1/overlap_bins_gby_1.3.query.sqlpp
index 32b10c8..1974f18 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_1/overlap_bins_gby_1.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_1/overlap_bins_gby_1.3.query.sqlpp
@@ -24,16 +24,16 @@
use test;
-select element {'timebin':bin,'count':test.count(i2),'total_ms':test.coll_sum((
- select element test.`ms-from-day-time-duration`(test.`duration-from-interval`(test.`get-overlapping-interval`(bin,i3.interval)))
+select element {'timebin':bin,'count':count(i2),'total_ms':array_sum((
+ select element `ms_from_day_time_duration`(`duration-from-interval`(`get-overlapping-interval`(bin,i3.interval)))
from i2 as i3
))}
from (
- select element {'interval':test.`interval-start-from-time`(i1.time,i1.duration)}
+ select element {'interval':`interval-start-from-time`(i1.time,i1.duration)}
from tsdata as i1
order by i1.time
) as i2,
- test.`overlap-bins`(i2.interval,test.time('00:00:00'),test.`day-time-duration`('PT1H30M')) as j
+ `overlap-bins`(i2.interval,time('00:00:00'),`day_time_duration`('PT1H30M')) as j
group by j as bin
-order by test.`get-interval-start`(bin)
+order by `get-interval-start`(bin)
;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_3/overlap_bins_gby_3.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_3/overlap_bins_gby_3.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_3/overlap_bins_gby_3.1.ddl.sqlpp
index 9352ae3..275df35 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_3/overlap_bins_gby_3.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_3/overlap_bins_gby_3.1.ddl.sqlpp
@@ -29,9 +29,9 @@ use multitask;
create type multitask.LogType as
closed {
- row_id : int32,
+ row_id : integer,
time : time,
- duration : int32,
+ duration : integer,
app : string
}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_3/overlap_bins_gby_3.3.query.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_3/overlap_bins_gby_3.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_3/overlap_bins_gby_3.3.query.sqlpp
index 4a0d468..368484e 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_3/overlap_bins_gby_3.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/overlap_bins_gby_3/overlap_bins_gby_3.3.query.sqlpp
@@ -27,12 +27,12 @@ select element {'timebin':bin,'subgroups':(
group by i.app as subgid
order by subgid,multitask.count(i)
)}
-from multitask.`overlap-bins`(multitask.interval(multitask.coll_min((
+from multitask.`overlap-bins`(multitask.interval(multitask.array_min((
select element i.time
from logs as i
-)),multitask.coll_max((
+)),multitask.array_max((
select element (i.time + multitask.`duration-from-ms`((i.duration * 1000)))
from logs as i
-))),multitask.time('00:00:00.000'),multitask.`day-time-duration`('PT1M')) as bin
+))),multitask.time('00:00:00.000'),multitask.`day_time_duration`('PT1M')) as bin
order by multitask.`get-interval-start`(bin)
;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/time_functions/time_functions.3.query.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/time_functions/time_functions.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/time_functions/time_functions.3.query.sqlpp
index c24a431..b3ac853 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/time_functions/time_functions.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/time_functions/time_functions.3.query.sqlpp
@@ -25,18 +25,18 @@ set `import-private-functions` `true`;
{ 'time1' : test.`time-from-unix-time-in-ms`(1560074)
, 'time2' : test.`get-time-from-datetime`(test.datetime('1327-12-02T23:35:49.938Z'))
, 'time3' : test.`get-time-from-datetime`(test.datetime('2012-10-11T02:30:23+03:00'))
-, 'time4' : (test.`time-from-unix-time-in-ms`(1560074) + test.`day-time-duration`('-PT30H'))
-, 'time5' : (test.`get-time-from-datetime`(test.datetime('1327-12-02T23:35:49.938Z')) + test.`day-time-duration`('PT36M'))
+, 'time4' : (test.`time-from-unix-time-in-ms`(1560074) + test.`day_time_duration`('-PT30H'))
+, 'time5' : (test.`get-time-from-datetime`(test.datetime('1327-12-02T23:35:49.938Z')) + test.`day_time_duration`('PT36M'))
, 'unix1' : test.`unix-time-from-time-in-ms`(test.`time-from-unix-time-in-ms`(1560074))
-, 'duration1' : ((test.`get-time-from-datetime`(test.datetime('1327-12-02T23:35:49.938Z')) + test.`day-time-duration`('PT36M')) - test.`get-time-from-datetime`(test.datetime('1327-12-02T23:35:49.938Z')))
-, 'duration2' : ((test.`time-from-unix-time-in-ms`(1560074) + test.`day-time-duration`('-PT30H')) - test.`time-from-unix-time-in-ms`(1560074))
-, 'c1' : (test.`time-from-unix-time-in-ms`(1560074) = ((test.`time-from-unix-time-in-ms`(1560074) - (test.`time-from-unix-time-in-ms`(1560074) + test.`day-time-duration`('-PT30H'))) + (test.`time-from-unix-time-in-ms`(1560074) + test.`day-time-duration`('-PT30H'))))
-, 'c2' : (test.`get-time-from-datetime`(test.datetime('1327-12-02T23:35:49.938Z')) = ((test.`get-time-from-datetime`(test.datetime('1327-12-02T23:35:49.938Z')) + test.`day-time-duration`('PT36M')) + (test.`get-time-from-datetime`(test.datetime('1327-12-02T23:35:49.938Z')) - (test.`get-time-from-datetime`(test.datetime('1327-12-02T23:35:49.938Z')) + test.`day-time-duration`('PT36M')))))
+, 'duration1' : ((test.`get-time-from-datetime`(test.datetime('1327-12-02T23:35:49.938Z')) + test.`day_time_duration`('PT36M')) - test.`get-time-from-datetime`(test.datetime('1327-12-02T23:35:49.938Z')))
+, 'duration2' : ((test.`time-from-unix-time-in-ms`(1560074) + test.`day_time_duration`('-PT30H')) - test.`time-from-unix-time-in-ms`(1560074))
+, 'c1' : (test.`time-from-unix-time-in-ms`(1560074) = ((test.`time-from-unix-time-in-ms`(1560074) - (test.`time-from-unix-time-in-ms`(1560074) + test.`day_time_duration`('-PT30H'))) + (test.`time-from-unix-time-in-ms`(1560074) + test.`day_time_duration`('-PT30H'))))
+, 'c2' : (test.`get-time-from-datetime`(test.datetime('1327-12-02T23:35:49.938Z')) = ((test.`get-time-from-datetime`(test.datetime('1327-12-02T23:35:49.938Z')) + test.`day_time_duration`('PT36M')) + (test.`get-time-from-datetime`(test.datetime('1327-12-02T23:35:49.938Z')) - (test.`get-time-from-datetime`(test.datetime('1327-12-02T23:35:49.938Z')) + test.`day_time_duration`('PT36M')))))
, 'null1' : test.`time-from-unix-time-in-ms`(null)
, 'nullunix1' : test.`unix-time-from-time-in-ms`(null)
, 'null2' : test.`get-time-from-datetime`(null)
-, 'null3' : (null + test.`day-time-duration`('-PT30H'))
+, 'null3' : (null + test.`day_time_duration`('-PT30H'))
, 'null4' : (test.`time-from-unix-time-in-ms`(1560074) + null)
, 'null5' : (null - test.`time-from-unix-time-in-ms`(1560074))
-, 'null6' : ((test.`time-from-unix-time-in-ms`(1560074) + test.`day-time-duration`('-PT30H')) - null)
+, 'null6' : ((test.`time-from-unix-time-in-ms`(1560074) + test.`day_time_duration`('-PT30H')) - null)
};
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/query-ASTERIXDB-1331.25.query.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/query-ASTERIXDB-1331.25.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/query-ASTERIXDB-1331.25.query.sqlpp
index 85a66f2..cee64cc 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/query-ASTERIXDB-1331.25.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/query-ASTERIXDB-1331.25.query.sqlpp
@@ -21,7 +21,7 @@
USE TinySocial;
-SELECT ELEMENT coll_avg((
+SELECT ELEMENT array_avg((
select element LENGTH(message.message)
FROM FacebookMessages AS message
WHERE message.`in-response-to` >= 1 and
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/tinysocial-suite.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/tinysocial-suite.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/tinysocial-suite.1.ddl.sqlpp
index c210744..7b30331 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/tinysocial-suite.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/tinysocial-suite.1.ddl.sqlpp
@@ -34,11 +34,11 @@ create type TinySocial.TweetMessageType as {
create type TinySocial.FacebookUserType as
open {
- id : int64
+ id : bigint
}
create type TinySocial.FacebookMessageType as
open {
- `message-id` : int64
+ `message-id` : bigint
}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/tinysocial-suite.14.query.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/tinysocial-suite.14.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/tinysocial-suite.14.query.sqlpp
index 7ca10bd..89ee2f8 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/tinysocial-suite.14.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/tinysocial-suite.14.query.sqlpp
@@ -23,7 +23,7 @@
use TinySocial;
-select element coll_count((
+select element array_count((
select element fbu
from FacebookUsers as fbu
));
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/tinysocial-suite.2.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/tinysocial-suite.2.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/tinysocial-suite.2.ddl.sqlpp
index 2c41b64..22ba0f7 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/tinysocial-suite.2.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/tinysocial-suite.2.ddl.sqlpp
@@ -30,5 +30,5 @@ create dataset TweetMessages(TweetMessageType) primary key tweetid hints (`CARD
create index fbUserSinceIdx on FacebookUsers (`user-since`:datetime?) type btree enforced;
-create index fbAuthorIdx on FacebookMessages (`author-id`:int64?) type btree enforced;
+create index fbAuthorIdx on FacebookMessages (`author-id`:bigint?) type btree enforced;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/tinysocial-suite.22.query.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/tinysocial-suite.22.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/tinysocial-suite.22.query.sqlpp
index ac378d0..7724e57 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/tinysocial-suite.22.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite-open/tinysocial-suite.22.query.sqlpp
@@ -23,7 +23,7 @@
use TinySocial;
-select element coll_count((
+select element array_count((
select element t
from TweetMessages as t
where (t.tweetid = '13')
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite/tinysocial-suite.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite/tinysocial-suite.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite/tinysocial-suite.1.ddl.sqlpp
index d6fa514..1de9aa5 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite/tinysocial-suite.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite/tinysocial-suite.1.ddl.sqlpp
@@ -27,10 +27,10 @@ create type TinySocial.TwitterUserType as
{
`screen-name` : string,
lang : string,
- friends_count : int64,
- statuses_count : int64,
+ friends_count : bigint,
+ statuses_count : bigint,
name : string,
- followers_count : int64
+ followers_count : bigint
}
create type TinySocial.TweetMessageType as
@@ -52,19 +52,19 @@ create type TinySocial.EmploymentType as
create type TinySocial.FacebookUserType as
closed {
- id : int64,
+ id : bigint,
alias : string,
name : string,
`user-since` : datetime,
- `friend-ids` : {{int64}},
+ `friend-ids` : {{bigint}},
employment : [EmploymentType]
}
create type TinySocial.FacebookMessageType as
closed {
- `message-id` : int64,
- `author-id` : int64,
- `in-response-to` : int64?,
+ `message-id` : bigint,
+ `author-id` : bigint,
+ `in-response-to` : bigint?,
`sender-location` : point?,
message : string
}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite/tinysocial-suite.14.query.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite/tinysocial-suite.14.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite/tinysocial-suite.14.query.sqlpp
index 7ca10bd..89ee2f8 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite/tinysocial-suite.14.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite/tinysocial-suite.14.query.sqlpp
@@ -23,7 +23,7 @@
use TinySocial;
-select element coll_count((
+select element array_count((
select element fbu
from FacebookUsers as fbu
));
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite/tinysocial-suite.22.query.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite/tinysocial-suite.22.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite/tinysocial-suite.22.query.sqlpp
index ac378d0..7724e57 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite/tinysocial-suite.22.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite/tinysocial-suite.22.query.sqlpp
@@ -23,7 +23,7 @@
use TinySocial;
-select element coll_count((
+select element array_count((
select element t
from TweetMessages as t
where (t.tweetid = '13')
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite/tinysocial-suite.25.query.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite/tinysocial-suite.25.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite/tinysocial-suite.25.query.sqlpp
index fa84678..4bf2b61 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite/tinysocial-suite.25.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tinysocial/tinysocial-suite/tinysocial-suite.25.query.sqlpp
@@ -19,7 +19,7 @@
USE TinySocial;
-SELECT ELEMENT coll_avg((
+SELECT ELEMENT array_avg((
select element LENGTH(message.message)
FROM FacebookMessages AS message
WHERE message.`in-response-to` >= 1 and
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1580/query-ASTERIXDB-1580.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1580/query-ASTERIXDB-1580.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1580/query-ASTERIXDB-1580.1.ddl.sqlpp
index fb600d2..52b0a89 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1580/query-ASTERIXDB-1580.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1580/query-ASTERIXDB-1580.1.ddl.sqlpp
@@ -23,7 +23,7 @@ create dataverse tpcds;
use tpcds;
create type tpcds.customer_address_type as closed {
- ca_address_sk: int64,
+ ca_address_sk: bigint,
ca_address_id: string,
ca_street_number: string?,
ca_street_name: string?,
@@ -39,20 +39,20 @@ create type tpcds.customer_address_type as closed {
}
create type tpcds.customer_type as closed {
- c_customer_sk: int64,
+ c_customer_sk: bigint,
c_customer_id: string,
- c_current_cdemo_sk: int64?,
- c_current_hdemo_sk: int64?,
- c_current_addr_sk: int64?,
- c_first_shipto_date_sk: int64?,
- c_first_sales_date_sk: int64?,
+ c_current_cdemo_sk: bigint?,
+ c_current_hdemo_sk: bigint?,
+ c_current_addr_sk: bigint?,
+ c_first_shipto_date_sk: bigint?,
+ c_first_sales_date_sk: bigint?,
c_salutation: string?,
c_first_name: string?,
c_last_name: string?,
c_preferred_cust_flag: string?,
- c_birth_day: int64?,
- c_birth_month: int64?,
- c_birth_year: int64?,
+ c_birth_day: bigint?,
+ c_birth_month: bigint?,
+ c_birth_year: bigint?,
c_birth_country: string?,
c_login: string?,
c_email_address: string?,
@@ -60,17 +60,17 @@ create type tpcds.customer_type as closed {
}
create type tpcds.store_sales_type as closed {
- ss_sold_date_sk: int64?,
- ss_sold_time_sk: int64?,
- ss_item_sk: int64,
- ss_customer_sk: int64?,
- ss_cdemo_sk: int64?,
- ss_hdemo_sk: int64?,
- ss_addr_sk: int64?,
- ss_store_sk: int64?,
- ss_promo_sk: int64?,
- ss_ticket_number: int64,
- ss_quantity: int64?,
+ ss_sold_date_sk: bigint?,
+ ss_sold_time_sk: bigint?,
+ ss_item_sk: bigint,
+ ss_customer_sk: bigint?,
+ ss_cdemo_sk: bigint?,
+ ss_hdemo_sk: bigint?,
+ ss_addr_sk: bigint?,
+ ss_store_sk: bigint?,
+ ss_promo_sk: bigint?,
+ ss_ticket_number: bigint,
+ ss_quantity: bigint?,
ss_wholesale_cost: double?,
ss_list_price: double?,
ss_sales_price: double?,
@@ -86,29 +86,29 @@ create type tpcds.store_sales_type as closed {
}
create type tpcds.date_dim_type as closed {
- d_date_sk: int64,
+ d_date_sk: bigint,
d_date_id: string,
d_date: string? ,
- d_month_seq: int64?,
- d_week_seq: int64?,
- d_quarter_seq: int64?,
- d_year: int64?,
- d_dow: int64?,
- d_moy: int64?,
- d_dom: int64?,
- d_qoy: int64?,
- d_fy_year: int64?,
- d_fy_quarter_seq: int64?,
- d_fy_week_seq: int64?,
+ d_month_seq: bigint?,
+ d_week_seq: bigint?,
+ d_quarter_seq: bigint?,
+ d_year: bigint?,
+ d_dow: bigint?,
+ d_moy: bigint?,
+ d_dom: bigint?,
+ d_qoy: bigint?,
+ d_fy_year: bigint?,
+ d_fy_quarter_seq: bigint?,
+ d_fy_week_seq: bigint?,
d_day_name: string?,
d_quarter_name: string?,
d_holiday: string?,
d_weekend: string?,
d_following_holiday: string?,
- d_first_dom: int64?,
- d_last_dom: int64?,
- d_same_day_ly: int64?,
- d_same_day_lq: int64?,
+ d_first_dom: bigint?,
+ d_last_dom: bigint?,
+ d_same_day_ly: bigint?,
+ d_same_day_lq: bigint?,
d_current_day: string?,
d_current_week: string?,
d_current_month: string?,
@@ -117,27 +117,27 @@ create type tpcds.date_dim_type as closed {
}
create type tpcds.item_type as closed {
- i_item_sk: int64,
+ i_item_sk: bigint,
i_item_id: string,
i_rec_start_date: string?,
i_rec_end_date: string?,
i_item_desc: string?,
i_current_price: double?,
i_wholesale_cost: double?,
- i_brand_id: int64? ,
+ i_brand_id: bigint? ,
i_brand: string?,
- i_class_id: int64? ,
+ i_class_id: bigint? ,
i_class: string?,
- i_category_id: int64? ,
+ i_category_id: bigint? ,
i_category: string?,
- i_manufact_id: int64? ,
+ i_manufact_id: bigint? ,
i_manufact: string?,
i_size: string?,
i_formulation: string?,
i_color: string?,
i_units: string?,
i_container: string?,
- i_manager_id: int64?,
+ i_manager_id: bigint?,
i_product_name: string?
}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1580/query-ASTERIXDB-1580.3.query.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1580/query-ASTERIXDB-1580.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1580/query-ASTERIXDB-1580.3.query.sqlpp
index c13f668..f3d80e5 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1580/query-ASTERIXDB-1580.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1580/query-ASTERIXDB-1580.3.query.sqlpp
@@ -30,6 +30,6 @@ where a.ca_address_sk = c.c_current_addr_sk
and s.ss_sold_date_sk = d.d_date_sk
and s.ss_item_sk = i.i_item_sk
group by a.ca_state group as stategrp
-having coll_count((select value a from stategrp)) >= 10
+having array_count((select value a from stategrp)) >= 10
order by cnt
limit 100;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-2/query-ASTERIXDB-1581-2.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-2/query-ASTERIXDB-1581-2.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-2/query-ASTERIXDB-1581-2.1.ddl.sqlpp
index 2e4844e..23b6fa3 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-2/query-ASTERIXDB-1581-2.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-2/query-ASTERIXDB-1581-2.1.ddl.sqlpp
@@ -24,17 +24,17 @@ create dataverse tpcds;
use tpcds;
create type tpcds.store_sales_type as closed {
- ss_sold_date_sk: int64?,
- ss_sold_time_sk: int64?,
- ss_item_sk: int64,
- ss_customer_sk: int64?,
- ss_cdemo_sk: int64?,
- ss_hdemo_sk: int64?,
- ss_addr_sk: int64?,
- ss_store_sk: int64?,
- ss_promo_sk: int64?,
- ss_ticket_number: int64,
- ss_quantity: int64?,
+ ss_sold_date_sk: bigint?,
+ ss_sold_time_sk: bigint?,
+ ss_item_sk: bigint,
+ ss_customer_sk: bigint?,
+ ss_cdemo_sk: bigint?,
+ ss_hdemo_sk: bigint?,
+ ss_addr_sk: bigint?,
+ ss_store_sk: bigint?,
+ ss_promo_sk: bigint?,
+ ss_ticket_number: bigint,
+ ss_quantity: bigint?,
ss_wholesale_cost: double?,
ss_list_price: double?,
ss_sales_price: double?,
@@ -51,27 +51,27 @@ create type tpcds.store_sales_type as closed {
create type tpcds.item_type as closed {
- i_item_sk: int64,
+ i_item_sk: bigint,
i_item_id: string,
i_rec_start_date: string?,
i_rec_end_date: string?,
i_item_desc: string?,
i_current_price: double?,
i_wholesale_cost: double?,
- i_brand_id: int64? ,
+ i_brand_id: bigint? ,
i_brand: string?,
- i_class_id: int64? ,
+ i_class_id: bigint? ,
i_class: string?,
- i_category_id: int64? ,
+ i_category_id: bigint? ,
i_category: string?,
- i_manufact_id: int64? ,
+ i_manufact_id: bigint? ,
i_manufact: string?,
i_size: string?,
i_formulation: string?,
i_color: string?,
i_units: string?,
i_container: string?,
- i_manager_id: int64?,
+ i_manager_id: bigint?,
i_product_name: string?
}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-3/query-ASTERIXDB-1581-3.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-3/query-ASTERIXDB-1581-3.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-3/query-ASTERIXDB-1581-3.1.ddl.sqlpp
index 2e4844e..23b6fa3 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-3/query-ASTERIXDB-1581-3.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-3/query-ASTERIXDB-1581-3.1.ddl.sqlpp
@@ -24,17 +24,17 @@ create dataverse tpcds;
use tpcds;
create type tpcds.store_sales_type as closed {
- ss_sold_date_sk: int64?,
- ss_sold_time_sk: int64?,
- ss_item_sk: int64,
- ss_customer_sk: int64?,
- ss_cdemo_sk: int64?,
- ss_hdemo_sk: int64?,
- ss_addr_sk: int64?,
- ss_store_sk: int64?,
- ss_promo_sk: int64?,
- ss_ticket_number: int64,
- ss_quantity: int64?,
+ ss_sold_date_sk: bigint?,
+ ss_sold_time_sk: bigint?,
+ ss_item_sk: bigint,
+ ss_customer_sk: bigint?,
+ ss_cdemo_sk: bigint?,
+ ss_hdemo_sk: bigint?,
+ ss_addr_sk: bigint?,
+ ss_store_sk: bigint?,
+ ss_promo_sk: bigint?,
+ ss_ticket_number: bigint,
+ ss_quantity: bigint?,
ss_wholesale_cost: double?,
ss_list_price: double?,
ss_sales_price: double?,
@@ -51,27 +51,27 @@ create type tpcds.store_sales_type as closed {
create type tpcds.item_type as closed {
- i_item_sk: int64,
+ i_item_sk: bigint,
i_item_id: string,
i_rec_start_date: string?,
i_rec_end_date: string?,
i_item_desc: string?,
i_current_price: double?,
i_wholesale_cost: double?,
- i_brand_id: int64? ,
+ i_brand_id: bigint? ,
i_brand: string?,
- i_class_id: int64? ,
+ i_class_id: bigint? ,
i_class: string?,
- i_category_id: int64? ,
+ i_category_id: bigint? ,
i_category: string?,
- i_manufact_id: int64? ,
+ i_manufact_id: bigint? ,
i_manufact: string?,
i_size: string?,
i_formulation: string?,
i_color: string?,
i_units: string?,
i_container: string?,
- i_manager_id: int64?,
+ i_manager_id: bigint?,
i_product_name: string?
}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-4/query-ASTERIXDB-1581-4.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-4/query-ASTERIXDB-1581-4.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-4/query-ASTERIXDB-1581-4.1.ddl.sqlpp
index 2e4844e..23b6fa3 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-4/query-ASTERIXDB-1581-4.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-4/query-ASTERIXDB-1581-4.1.ddl.sqlpp
@@ -24,17 +24,17 @@ create dataverse tpcds;
use tpcds;
create type tpcds.store_sales_type as closed {
- ss_sold_date_sk: int64?,
- ss_sold_time_sk: int64?,
- ss_item_sk: int64,
- ss_customer_sk: int64?,
- ss_cdemo_sk: int64?,
- ss_hdemo_sk: int64?,
- ss_addr_sk: int64?,
- ss_store_sk: int64?,
- ss_promo_sk: int64?,
- ss_ticket_number: int64,
- ss_quantity: int64?,
+ ss_sold_date_sk: bigint?,
+ ss_sold_time_sk: bigint?,
+ ss_item_sk: bigint,
+ ss_customer_sk: bigint?,
+ ss_cdemo_sk: bigint?,
+ ss_hdemo_sk: bigint?,
+ ss_addr_sk: bigint?,
+ ss_store_sk: bigint?,
+ ss_promo_sk: bigint?,
+ ss_ticket_number: bigint,
+ ss_quantity: bigint?,
ss_wholesale_cost: double?,
ss_list_price: double?,
ss_sales_price: double?,
@@ -51,27 +51,27 @@ create type tpcds.store_sales_type as closed {
create type tpcds.item_type as closed {
- i_item_sk: int64,
+ i_item_sk: bigint,
i_item_id: string,
i_rec_start_date: string?,
i_rec_end_date: string?,
i_item_desc: string?,
i_current_price: double?,
i_wholesale_cost: double?,
- i_brand_id: int64? ,
+ i_brand_id: bigint? ,
i_brand: string?,
- i_class_id: int64? ,
+ i_class_id: bigint? ,
i_class: string?,
- i_category_id: int64? ,
+ i_category_id: bigint? ,
i_category: string?,
- i_manufact_id: int64? ,
+ i_manufact_id: bigint? ,
i_manufact: string?,
i_size: string?,
i_formulation: string?,
i_color: string?,
i_units: string?,
i_container: string?,
- i_manager_id: int64?,
+ i_manager_id: bigint?,
i_product_name: string?
}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-5/query-ASTERIXDB-1581-5.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-5/query-ASTERIXDB-1581-5.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-5/query-ASTERIXDB-1581-5.1.ddl.sqlpp
index 2e4844e..23b6fa3 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-5/query-ASTERIXDB-1581-5.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-5/query-ASTERIXDB-1581-5.1.ddl.sqlpp
@@ -24,17 +24,17 @@ create dataverse tpcds;
use tpcds;
create type tpcds.store_sales_type as closed {
- ss_sold_date_sk: int64?,
- ss_sold_time_sk: int64?,
- ss_item_sk: int64,
- ss_customer_sk: int64?,
- ss_cdemo_sk: int64?,
- ss_hdemo_sk: int64?,
- ss_addr_sk: int64?,
- ss_store_sk: int64?,
- ss_promo_sk: int64?,
- ss_ticket_number: int64,
- ss_quantity: int64?,
+ ss_sold_date_sk: bigint?,
+ ss_sold_time_sk: bigint?,
+ ss_item_sk: bigint,
+ ss_customer_sk: bigint?,
+ ss_cdemo_sk: bigint?,
+ ss_hdemo_sk: bigint?,
+ ss_addr_sk: bigint?,
+ ss_store_sk: bigint?,
+ ss_promo_sk: bigint?,
+ ss_ticket_number: bigint,
+ ss_quantity: bigint?,
ss_wholesale_cost: double?,
ss_list_price: double?,
ss_sales_price: double?,
@@ -51,27 +51,27 @@ create type tpcds.store_sales_type as closed {
create type tpcds.item_type as closed {
- i_item_sk: int64,
+ i_item_sk: bigint,
i_item_id: string,
i_rec_start_date: string?,
i_rec_end_date: string?,
i_item_desc: string?,
i_current_price: double?,
i_wholesale_cost: double?,
- i_brand_id: int64? ,
+ i_brand_id: bigint? ,
i_brand: string?,
- i_class_id: int64? ,
+ i_class_id: bigint? ,
i_class: string?,
- i_category_id: int64? ,
+ i_category_id: bigint? ,
i_category: string?,
- i_manufact_id: int64? ,
+ i_manufact_id: bigint? ,
i_manufact: string?,
i_size: string?,
i_formulation: string?,
i_color: string?,
i_units: string?,
i_container: string?,
- i_manager_id: int64?,
+ i_manager_id: bigint?,
i_product_name: string?
}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-6/query-ASTERIXDB-1581-6.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-6/query-ASTERIXDB-1581-6.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-6/query-ASTERIXDB-1581-6.1.ddl.sqlpp
index 2e4844e..23b6fa3 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-6/query-ASTERIXDB-1581-6.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-6/query-ASTERIXDB-1581-6.1.ddl.sqlpp
@@ -24,17 +24,17 @@ create dataverse tpcds;
use tpcds;
create type tpcds.store_sales_type as closed {
- ss_sold_date_sk: int64?,
- ss_sold_time_sk: int64?,
- ss_item_sk: int64,
- ss_customer_sk: int64?,
- ss_cdemo_sk: int64?,
- ss_hdemo_sk: int64?,
- ss_addr_sk: int64?,
- ss_store_sk: int64?,
- ss_promo_sk: int64?,
- ss_ticket_number: int64,
- ss_quantity: int64?,
+ ss_sold_date_sk: bigint?,
+ ss_sold_time_sk: bigint?,
+ ss_item_sk: bigint,
+ ss_customer_sk: bigint?,
+ ss_cdemo_sk: bigint?,
+ ss_hdemo_sk: bigint?,
+ ss_addr_sk: bigint?,
+ ss_store_sk: bigint?,
+ ss_promo_sk: bigint?,
+ ss_ticket_number: bigint,
+ ss_quantity: bigint?,
ss_wholesale_cost: double?,
ss_list_price: double?,
ss_sales_price: double?,
@@ -51,27 +51,27 @@ create type tpcds.store_sales_type as closed {
create type tpcds.item_type as closed {
- i_item_sk: int64,
+ i_item_sk: bigint,
i_item_id: string,
i_rec_start_date: string?,
i_rec_end_date: string?,
i_item_desc: string?,
i_current_price: double?,
i_wholesale_cost: double?,
- i_brand_id: int64? ,
+ i_brand_id: bigint? ,
i_brand: string?,
- i_class_id: int64? ,
+ i_class_id: bigint? ,
i_class: string?,
- i_category_id: int64? ,
+ i_category_id: bigint? ,
i_category: string?,
- i_manufact_id: int64? ,
+ i_manufact_id: bigint? ,
i_manufact: string?,
i_size: string?,
i_formulation: string?,
i_color: string?,
i_units: string?,
i_container: string?,
- i_manager_id: int64?,
+ i_manager_id: bigint?,
i_product_name: string?
}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-correlated-2/query-ASTERIXDB-1581-correlated-2.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-correlated-2/query-ASTERIXDB-1581-correlated-2.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-correlated-2/query-ASTERIXDB-1581-correlated-2.1.ddl.sqlpp
index 2e4844e..23b6fa3 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-correlated-2/query-ASTERIXDB-1581-correlated-2.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-correlated-2/query-ASTERIXDB-1581-correlated-2.1.ddl.sqlpp
@@ -24,17 +24,17 @@ create dataverse tpcds;
use tpcds;
create type tpcds.store_sales_type as closed {
- ss_sold_date_sk: int64?,
- ss_sold_time_sk: int64?,
- ss_item_sk: int64,
- ss_customer_sk: int64?,
- ss_cdemo_sk: int64?,
- ss_hdemo_sk: int64?,
- ss_addr_sk: int64?,
- ss_store_sk: int64?,
- ss_promo_sk: int64?,
- ss_ticket_number: int64,
- ss_quantity: int64?,
+ ss_sold_date_sk: bigint?,
+ ss_sold_time_sk: bigint?,
+ ss_item_sk: bigint,
+ ss_customer_sk: bigint?,
+ ss_cdemo_sk: bigint?,
+ ss_hdemo_sk: bigint?,
+ ss_addr_sk: bigint?,
+ ss_store_sk: bigint?,
+ ss_promo_sk: bigint?,
+ ss_ticket_number: bigint,
+ ss_quantity: bigint?,
ss_wholesale_cost: double?,
ss_list_price: double?,
ss_sales_price: double?,
@@ -51,27 +51,27 @@ create type tpcds.store_sales_type as closed {
create type tpcds.item_type as closed {
- i_item_sk: int64,
+ i_item_sk: bigint,
i_item_id: string,
i_rec_start_date: string?,
i_rec_end_date: string?,
i_item_desc: string?,
i_current_price: double?,
i_wholesale_cost: double?,
- i_brand_id: int64? ,
+ i_brand_id: bigint? ,
i_brand: string?,
- i_class_id: int64? ,
+ i_class_id: bigint? ,
i_class: string?,
- i_category_id: int64? ,
+ i_category_id: bigint? ,
i_category: string?,
- i_manufact_id: int64? ,
+ i_manufact_id: bigint? ,
i_manufact: string?,
i_size: string?,
i_formulation: string?,
i_color: string?,
i_units: string?,
i_container: string?,
- i_manager_id: int64?,
+ i_manager_id: bigint?,
i_product_name: string?
}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-correlated/query-ASTERIXDB-1581-correlated.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-correlated/query-ASTERIXDB-1581-correlated.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-correlated/query-ASTERIXDB-1581-correlated.1.ddl.sqlpp
index 2e4844e..23b6fa3 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-correlated/query-ASTERIXDB-1581-correlated.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-correlated/query-ASTERIXDB-1581-correlated.1.ddl.sqlpp
@@ -24,17 +24,17 @@ create dataverse tpcds;
use tpcds;
create type tpcds.store_sales_type as closed {
- ss_sold_date_sk: int64?,
- ss_sold_time_sk: int64?,
- ss_item_sk: int64,
- ss_customer_sk: int64?,
- ss_cdemo_sk: int64?,
- ss_hdemo_sk: int64?,
- ss_addr_sk: int64?,
- ss_store_sk: int64?,
- ss_promo_sk: int64?,
- ss_ticket_number: int64,
- ss_quantity: int64?,
+ ss_sold_date_sk: bigint?,
+ ss_sold_time_sk: bigint?,
+ ss_item_sk: bigint,
+ ss_customer_sk: bigint?,
+ ss_cdemo_sk: bigint?,
+ ss_hdemo_sk: bigint?,
+ ss_addr_sk: bigint?,
+ ss_store_sk: bigint?,
+ ss_promo_sk: bigint?,
+ ss_ticket_number: bigint,
+ ss_quantity: bigint?,
ss_wholesale_cost: double?,
ss_list_price: double?,
ss_sales_price: double?,
@@ -51,27 +51,27 @@ create type tpcds.store_sales_type as closed {
create type tpcds.item_type as closed {
- i_item_sk: int64,
+ i_item_sk: bigint,
i_item_id: string,
i_rec_start_date: string?,
i_rec_end_date: string?,
i_item_desc: string?,
i_current_price: double?,
i_wholesale_cost: double?,
- i_brand_id: int64? ,
+ i_brand_id: bigint? ,
i_brand: string?,
- i_class_id: int64? ,
+ i_class_id: bigint? ,
i_class: string?,
- i_category_id: int64? ,
+ i_category_id: bigint? ,
i_category: string?,
- i_manufact_id: int64? ,
+ i_manufact_id: bigint? ,
i_manufact: string?,
i_size: string?,
i_formulation: string?,
i_color: string?,
i_units: string?,
i_container: string?,
- i_manager_id: int64?,
+ i_manager_id: bigint?,
i_product_name: string?
}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581/query-ASTERIXDB-1581.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581/query-ASTERIXDB-1581.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581/query-ASTERIXDB-1581.1.ddl.sqlpp
index 2e4844e..23b6fa3 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581/query-ASTERIXDB-1581.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581/query-ASTERIXDB-1581.1.ddl.sqlpp
@@ -24,17 +24,17 @@ create dataverse tpcds;
use tpcds;
create type tpcds.store_sales_type as closed {
- ss_sold_date_sk: int64?,
- ss_sold_time_sk: int64?,
- ss_item_sk: int64,
- ss_customer_sk: int64?,
- ss_cdemo_sk: int64?,
- ss_hdemo_sk: int64?,
- ss_addr_sk: int64?,
- ss_store_sk: int64?,
- ss_promo_sk: int64?,
- ss_ticket_number: int64,
- ss_quantity: int64?,
+ ss_sold_date_sk: bigint?,
+ ss_sold_time_sk: bigint?,
+ ss_item_sk: bigint,
+ ss_customer_sk: bigint?,
+ ss_cdemo_sk: bigint?,
+ ss_hdemo_sk: bigint?,
+ ss_addr_sk: bigint?,
+ ss_store_sk: bigint?,
+ ss_promo_sk: bigint?,
+ ss_ticket_number: bigint,
+ ss_quantity: bigint?,
ss_wholesale_cost: double?,
ss_list_price: double?,
ss_sales_price: double?,
@@ -51,27 +51,27 @@ create type tpcds.store_sales_type as closed {
create type tpcds.item_type as closed {
- i_item_sk: int64,
+ i_item_sk: bigint,
i_item_id: string,
i_rec_start_date: string?,
i_rec_end_date: string?,
i_item_desc: string?,
i_current_price: double?,
i_wholesale_cost: double?,
- i_brand_id: int64? ,
+ i_brand_id: bigint? ,
i_brand: string?,
- i_class_id: int64? ,
+ i_class_id: bigint? ,
i_class: string?,
- i_category_id: int64? ,
+ i_category_id: bigint? ,
i_category: string?,
- i_manufact_id: int64? ,
+ i_manufact_id: bigint? ,
i_manufact: string?,
i_size: string?,
i_formulation: string?,
i_color: string?,
i_units: string?,
i_container: string?,
- i_manager_id: int64?,
+ i_manager_id: bigint?,
i_product_name: string?
}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/3b063f06/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1591/query-ASTERIXDB-1591.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1591/query-ASTERIXDB-1591.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1591/query-ASTERIXDB-1591.1.ddl.sqlpp
index c0e9f7c..6ee8559 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1591/query-ASTERIXDB-1591.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1591/query-ASTERIXDB-1591.1.ddl.sqlpp
@@ -23,7 +23,7 @@ create dataverse tpcds;
use tpcds;
create type customer_address_type as closed {
- ca_address_sk: int64,
+ ca_address_sk: bigint,
ca_address_id: string,
ca_street_number: string?,
ca_street_name: string?,
@@ -39,20 +39,20 @@ create type customer_address_type as closed {
}
create type customer_type as closed {
- c_customer_sk: int64,
+ c_customer_sk: bigint,
c_customer_id: string,
- c_current_cdemo_sk: int64?,
- c_current_hdemo_sk: int64?,
- c_current_addr_sk: int64?,
- c_first_shipto_date_sk: int64?,
- c_first_sales_date_sk: int64?,
+ c_current_cdemo_sk: bigint?,
+ c_current_hdemo_sk: bigint?,
+ c_current_addr_sk: bigint?,
+ c_first_shipto_date_sk: bigint?,
+ c_first_sales_date_sk: bigint?,
c_salutation: string?,
c_first_name: string?,
c_last_name: string?,
c_preferred_cust_flag: string?,
- c_birth_day: int64?,
- c_birth_month: int64?,
- c_birth_year: int64?,
+ c_birth_day: bigint?,
+ c_birth_month: bigint?,
+ c_birth_year: bigint?,
c_birth_country: string?,
c_login: string?,
c_email_address: string?,
@@ -60,17 +60,17 @@ create type customer_type as closed {
}
create type store_sales_type as closed {
- ss_sold_date_sk: int64?,
- ss_sold_time_sk: int64?,
- ss_item_sk: int64,
- ss_customer_sk: int64?,
- ss_cdemo_sk: int64?,
- ss_hdemo_sk: int64?,
- ss_addr_sk: int64?,
- ss_store_sk: int64?,
- ss_promo_sk: int64?,
- ss_ticket_number: int64,
- ss_quantity: int64?,
+ ss_sold_date_sk: bigint?,
+ ss_sold_time_sk: bigint?,
+ ss_item_sk: bigint,
+ ss_customer_sk: bigint?,
+ ss_cdemo_sk: bigint?,
+ ss_hdemo_sk: bigint?,
+ ss_addr_sk: bigint?,
+ ss_store_sk: bigint?,
+ ss_promo_sk: bigint?,
+ ss_ticket_number: bigint,
+ ss_quantity: bigint?,
ss_wholesale_cost: double?,
ss_list_price: double?,
ss_sales_price: double?,
@@ -86,25 +86,25 @@ create type store_sales_type as closed {
}
create type catalog_sales_type as closed {
- cs_sold_date_sk: int64?,
- cs_sold_time_sk: int64?,
- cs_ship_date_sk: int64?,
- cs_bill_customer_sk: int64?,
- cs_bill_cdemo_sk: int64?,
- cs_bill_hdemo_sk: int64?,
- cs_bill_addr_sk: int64?,
- cs_ship_customer_sk: int64?,
- cs_ship_cdemo_sk: int64?,
- cs_ship_hdemo_sk: int64?,
- cs_ship_addr_sk: int64?,
- cs_call_center_sk: int64?,
- cs_catalog_page_sk: int64?,
- cs_ship_mode_sk: int64?,
- cs_warehouse_sk: int64?,
- cs_item_sk: int64,
- cs_promo_sk: int64?,
- cs_order_number: int64,
- cs_quantity: int64?,
+ cs_sold_date_sk: bigint?,
+ cs_sold_time_sk: bigint?,
+ cs_ship_date_sk: bigint?,
+ cs_bill_customer_sk: bigint?,
+ cs_bill_cdemo_sk: bigint?,
+ cs_bill_hdemo_sk: bigint?,
+ cs_bill_addr_sk: bigint?,
+ cs_ship_customer_sk: bigint?,
+ cs_ship_cdemo_sk: bigint?,
+ cs_ship_hdemo_sk: bigint?,
+ cs_ship_addr_sk: bigint?,
+ cs_call_center_sk: bigint?,
+ cs_catalog_page_sk: bigint?,
+ cs_ship_mode_sk: bigint?,
+ cs_warehouse_sk: bigint?,
+ cs_item_sk: bigint,
+ cs_promo_sk: bigint?,
+ cs_order_number: bigint,
+ cs_quantity: bigint?,
cs_wholesale_cost: double?,
cs_list_price: double?,
cs_sales_price: double?,
@@ -123,24 +123,24 @@ create type catalog_sales_type as closed {
}
create type catalog_returns_type as closed {
- cr_returned_date_sk: int64?,
- cr_returned_time_sk: int64?,
- cr_item_sk: int64,
- cr_refunded_customer_sk: int64?,
- cr_refunded_cdemo_sk: int64?,
- cr_refunded_hdemo_sk: int64?,
- cr_refunded_addr_sk: int64?,
- cr_returning_customer_sk: int64?,
- cr_returning_cdemo_sk: int64?,
- cr_returning_hdemo_sk: int64?,
- cr_returning_addr_sk: int64?,
- cr_call_center_sk: int64?,
- cr_catalog_page_sk: int64?,
- cr_ship_mode_sk: int64?,
- cr_warehouse_sk: int64?,
- cr_reason_sk: int64?,
- cr_order_number: int64,
- cr_return_quantity: int64?,
+ cr_returned_date_sk: bigint?,
+ cr_returned_time_sk: bigint?,
+ cr_item_sk: bigint,
+ cr_refunded_customer_sk: bigint?,
+ cr_refunded_cdemo_sk: bigint?,
+ cr_refunded_hdemo_sk: bigint?,
+ cr_refunded_addr_sk: bigint?,
+ cr_returning_customer_sk: bigint?,
+ cr_returning_cdemo_sk: bigint?,
+ cr_returning_hdemo_sk: bigint?,
+ cr_returning_addr_sk: bigint?,
+ cr_call_center_sk: bigint?,
+ cr_catalog_page_sk: bigint?,
+ cr_ship_mode_sk: bigint?,
+ cr_warehouse_sk: bigint?,
+ cr_reason_sk: bigint?,
+ cr_order_number: bigint,
+ cr_return_quantity: bigint?,
cr_return_amount: double?,
cr_return_tax: double?,
cr_return_amt_inc_tax: double?,
@@ -153,29 +153,29 @@ create type catalog_returns_type as closed {
}
create type tpcds.date_dim_type as closed {
- d_date_sk: int64,
+ d_date_sk: bigint,
d_date_id: string,
d_date: string? ,
- d_month_seq: int64?,
- d_week_seq: int64?,
- d_quarter_seq: int64?,
- d_year: int64?,
- d_dow: int64?,
- d_moy: int64?,
- d_dom: int64?,
- d_qoy: int64?,
- d_fy_year: int64?,
- d_fy_quarter_seq: int64?,
- d_fy_week_seq: int64?,
+ d_month_seq: bigint?,
+ d_week_seq: bigint?,
+ d_quarter_seq: bigint?,
+ d_year: bigint?,
+ d_dow: bigint?,
+ d_moy: bigint?,
+ d_dom: bigint?,
+ d_qoy: bigint?,
+ d_fy_year: bigint?,
+ d_fy_quarter_seq: bigint?,
+ d_fy_week_seq: bigint?,
d_day_name: string?,
d_quarter_name: string?,
d_holiday: string?,
d_weekend: string?,
d_following_holiday: string?,
- d_first_dom: int64?,
- d_last_dom: int64?,
- d_same_day_ly: int64?,
- d_same_day_lq: int64?,
+ d_first_dom: bigint?,
+ d_last_dom: bigint?,
+ d_same_day_ly: bigint?,
+ d_same_day_lq: bigint?,
d_current_day: string?,
d_current_week: string?,
d_current_month: string?,
@@ -184,50 +184,50 @@ create type tpcds.date_dim_type as closed {
}
create type item_type as closed {
- i_item_sk: int64,
+ i_item_sk: bigint,
i_item_id: string,
i_rec_start_date: string?,
i_rec_end_date: string?,
i_item_desc: string?,
i_current_price: double?,
i_wholesale_cost: double?,
- i_brand_id: int64? ,
+ i_brand_id: bigint? ,
i_brand: string?,
- i_class_id: int64? ,
+ i_class_id: bigint? ,
i_class: string?,
- i_category_id: int64? ,
+ i_category_id: bigint? ,
i_category: string?,
- i_manufact_id: int64? ,
+ i_manufact_id: bigint? ,
i_manufact: string?,
i_size: string?,
i_formulation: string?,
i_color: string?,
i_units: string?,
i_container: string?,
- i_manager_id: int64?,
+ i_manager_id: bigint?,
i_product_name: string?
}
create type web_sales_type as closed {
- ws_sold_date_sk: int64?,
- ws_sold_time_sk: int64?,
- ws_ship_date_sk: int64?,
- ws_item_sk: int64,
- ws_bill_customer_sk: int64?,
- ws_bill_cdemo_sk: int64?,
- ws_bill_hdemo_sk: int64?,
- ws_bill_addr_sk: int64?,
- ws_ship_customer_sk: int64?,
- ws_ship_cdemo_sk: int64?,
- ws_ship_hdemo_sk: int64?,
- ws_ship_addr_sk: int64?,
- ws_web_page_sk: int64?,
- ws_web_site_sk: int64?,
- ws_ship_mode_sk: int64?,
- ws_warehouse_sk: int64?,
- ws_promo_sk: int64?,
- ws_order_number: int64,
- ws_quantity: int64?,
+ ws_sold_date_sk: bigint?,
+ ws_sold_time_sk: bigint?,
+ ws_ship_date_sk: bigint?,
+ ws_item_sk: bigint,
+ ws_bill_customer_sk: bigint?,
+ ws_bill_cdemo_sk: bigint?,
+ ws_bill_hdemo_sk: bigint?,
+ ws_bill_addr_sk: bigint?,
+ ws_ship_customer_sk: bigint?,
+ ws_ship_cdemo_sk: bigint?,
+ ws_ship_hdemo_sk: bigint?,
+ ws_ship_addr_sk: bigint?,
+ ws_web_page_sk: bigint?,
+ ws_web_site_sk: bigint?,
+ ws_ship_mode_sk: bigint?,
+ ws_warehouse_sk: bigint?,
+ ws_promo_sk: bigint?,
+ ws_order_number: bigint,
+ ws_quantity: bigint?,
ws_wholesale_cost: double?,
ws_list_price: double?,
ws_sales_price: double?,