You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@asterixdb.apache.org by mh...@apache.org on 2017/08/22 10:15:02 UTC
[07/32] asterixdb git commit: [ASTERIXDB-2050][SQL] Enforce a
Semicolon After Each SQL++ Statement
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/empty-load-with-index/empty-load-with-index.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/empty-load-with-index/empty-load-with-index.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/empty-load-with-index/empty-load-with-index.1.ddl.sqlpp
index ef45232..d51ed99 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/empty-load-with-index/empty-load-with-index.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/empty-load-with-index/empty-load-with-index.1.ddl.sqlpp
@@ -46,7 +46,7 @@ create type test.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create temporary dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/insert-and-scan-dataset-with-correlated-index/insert-and-scan-dataset-with-correlated-index.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/insert-and-scan-dataset-with-correlated-index/insert-and-scan-dataset-with-correlated-index.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/insert-and-scan-dataset-with-correlated-index/insert-and-scan-dataset-with-correlated-index.1.ddl.sqlpp
index c591a8e..6c1595d 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/insert-and-scan-dataset-with-correlated-index/insert-and-scan-dataset-with-correlated-index.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/insert-and-scan-dataset-with-correlated-index/insert-and-scan-dataset-with-correlated-index.1.ddl.sqlpp
@@ -34,7 +34,7 @@ create type test.Emp as
lname : string,
age : bigint,
dept : string
-}
+};
create temporary dataset test.employee(Emp) primary key id
using compaction policy `correlated-prefix`
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/insert-and-scan-dataset-with-index/insert-and-scan-dataset-with-index.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/insert-and-scan-dataset-with-index/insert-and-scan-dataset-with-index.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/insert-and-scan-dataset-with-index/insert-and-scan-dataset-with-index.1.ddl.sqlpp
index 4532f3c..ac3d7da 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/insert-and-scan-dataset-with-index/insert-and-scan-dataset-with-index.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/insert-and-scan-dataset-with-index/insert-and-scan-dataset-with-index.1.ddl.sqlpp
@@ -33,7 +33,7 @@ create type test.Emp as
lname : string,
age : bigint,
dept : string
-}
+};
create temporary dataset test.employee(Emp) primary key id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/insert-and-scan-dataset/insert-and-scan-dataset.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/insert-and-scan-dataset/insert-and-scan-dataset.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/insert-and-scan-dataset/insert-and-scan-dataset.1.ddl.sqlpp
index 46fcd68..c716bbe 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/insert-and-scan-dataset/insert-and-scan-dataset.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/insert-and-scan-dataset/insert-and-scan-dataset.1.ddl.sqlpp
@@ -32,7 +32,7 @@ use test;
create type test.myDataType as
{
id : bigint
-}
+};
create temporary dataset myData(myDataType) primary key id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/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/temp-dataset/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.1.ddl.sqlpp
index d14c703..45cde93 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/q01_pricing_summary_report_nt/q01_pricing_summary_report_nt.1.ddl.sqlpp
@@ -46,7 +46,7 @@ create type tpch.LineItemType as
l_shipinstruct : string,
l_shipmode : string,
l_comment : string
-}
+};
create temporary dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/scan-delete-rtree-secondary-index/scan-delete-rtree-secondary-index.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/scan-delete-rtree-secondary-index/scan-delete-rtree-secondary-index.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/scan-delete-rtree-secondary-index/scan-delete-rtree-secondary-index.1.ddl.sqlpp
index 6fe3764..7e0f9cc 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/scan-delete-rtree-secondary-index/scan-delete-rtree-secondary-index.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/scan-delete-rtree-secondary-index/scan-delete-rtree-secondary-index.1.ddl.sqlpp
@@ -39,7 +39,7 @@ create type test.MyRecord as
poly2 : polygon,
rec : rectangle,
circle : circle
-}
+};
create temporary dataset MyData(MyRecord) primary key id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/scan-insert-persistent-to-temp/scan-insert-persistent-to-temp.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/scan-insert-persistent-to-temp/scan-insert-persistent-to-temp.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/scan-insert-persistent-to-temp/scan-insert-persistent-to-temp.1.ddl.sqlpp
index 88b957e..b352768 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/scan-insert-persistent-to-temp/scan-insert-persistent-to-temp.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/scan-insert-persistent-to-temp/scan-insert-persistent-to-temp.1.ddl.sqlpp
@@ -40,13 +40,13 @@ create type test.MyRecord as
poly2 : polygon,
rec : rectangle,
circle : circle
-}
+};
create type test.MyMiniRecord as
closed {
id : bigint,
point : point
-}
+};
create dataset MyData(MyRecord) primary key id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/scan-insert-rtree-secondary-index/scan-insert-rtree-secondary-index.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/scan-insert-rtree-secondary-index/scan-insert-rtree-secondary-index.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/scan-insert-rtree-secondary-index/scan-insert-rtree-secondary-index.1.ddl.sqlpp
index e41796b..8d1110a 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/scan-insert-rtree-secondary-index/scan-insert-rtree-secondary-index.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/scan-insert-rtree-secondary-index/scan-insert-rtree-secondary-index.1.ddl.sqlpp
@@ -40,13 +40,13 @@ create type test.MyRecord as
poly2 : polygon,
rec : rectangle,
circle : circle
-}
+};
create type test.MyMiniRecord as
closed {
id : bigint,
point : point
-}
+};
create temporary dataset MyData(MyRecord) primary key id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/scan-insert-temp-to-persistent/scan-insert-temp-to-persistent.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/scan-insert-temp-to-persistent/scan-insert-temp-to-persistent.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/scan-insert-temp-to-persistent/scan-insert-temp-to-persistent.1.ddl.sqlpp
index 41c192c..f7e32ab 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/scan-insert-temp-to-persistent/scan-insert-temp-to-persistent.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temp-dataset/scan-insert-temp-to-persistent/scan-insert-temp-to-persistent.1.ddl.sqlpp
@@ -40,13 +40,13 @@ create type test.MyRecord as
poly2 : polygon,
rec : rectangle,
circle : circle
-}
+};
create type test.MyMiniRecord as
closed {
id : bigint,
point : point
-}
+};
create temporary dataset MyData(MyRecord) primary key id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/agg_max/agg_max.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/agg_max/agg_max.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/agg_max/agg_max.1.ddl.sqlpp
index 64e6570..df469e8 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/agg_max/agg_max.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/agg_max/agg_max.1.ddl.sqlpp
@@ -31,7 +31,7 @@ create type test.Schema as
datetime : datetime,
dtduration : `day_time_duration`,
ymduration : `year_month_duration`
-}
+};
create dataset tsdata(Schema) primary key id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/agg_min/agg_min.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/agg_min/agg_min.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/agg_min/agg_min.1.ddl.sqlpp
index 64e6570..df469e8 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/agg_min/agg_min.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/temporal/agg_min/agg_min.1.ddl.sqlpp
@@ -31,7 +31,7 @@ create type test.Schema as
datetime : datetime,
dtduration : `day_time_duration`,
ymduration : `year_month_duration`
-}
+};
create dataset tsdata(Schema) primary key id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/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 10c6d29..8044b38 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
@@ -38,7 +38,7 @@ create type testdvt.testtype as
intervalField : interval?,
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/dc77522b/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 0ad459c..1496279 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
@@ -39,7 +39,7 @@ create type timeTest.timesType as
`date-interval` : interval,
`time-interval` : interval,
`datetime-interval` : interval
-}
+};
create dataset timeData(timesType) primary key date;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/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 8bd2355..c8b923b 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
@@ -31,7 +31,7 @@ create type test.Schema as
closed {
id : bigint,
timestamp : datetime
-}
+};
create dataset tsdata(Schema) primary key id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/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 8bd2355..c8b923b 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
@@ -31,7 +31,7 @@ create type test.Schema as
closed {
id : bigint,
timestamp : datetime
-}
+};
create dataset tsdata(Schema) primary key id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/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 c2e083b..f94a8eb 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
@@ -32,7 +32,7 @@ create type test.Schema as
id : integer,
time : time,
duration : `day_time_duration`
-}
+};
create dataset tsdata(Schema) primary key id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/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 c2e083b..f94a8eb 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
@@ -32,7 +32,7 @@ create type test.Schema as
id : integer,
time : time,
duration : `day_time_duration`
-}
+};
create dataset tsdata(Schema) primary key id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/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 275df35..e6ecbed 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
@@ -33,7 +33,7 @@ create type multitask.LogType as
time : time,
duration : integer,
app : string
-}
+};
create dataset logs(LogType) primary key row_id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/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 7b30331..8ad21d7 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
@@ -26,19 +26,19 @@ use TinySocial;
create type TinySocial.TwitterUserType as
{
`screen-name` : string
-}
+};
create type TinySocial.TweetMessageType as {
tweetid : string
-}
+};
create type TinySocial.FacebookUserType as
open {
id : bigint
-}
+};
create type TinySocial.FacebookMessageType as
open {
`message-id` : bigint
-}
+};
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/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 1de9aa5..2f937cf 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
@@ -31,7 +31,7 @@ create type TinySocial.TwitterUserType as
statuses_count : bigint,
name : string,
followers_count : bigint
-}
+};
create type TinySocial.TweetMessageType as
closed {
@@ -41,14 +41,14 @@ create type TinySocial.TweetMessageType as
`send-time` : datetime,
`referred-topics` : {{string}},
`message-text` : string
-}
+};
create type TinySocial.EmploymentType as
{
`organization-name` : string,
`start-date` : date,
`end-date` : date?
-}
+};
create type TinySocial.FacebookUserType as
closed {
@@ -58,7 +58,7 @@ create type TinySocial.FacebookUserType as
`user-since` : datetime,
`friend-ids` : {{bigint}},
employment : [EmploymentType]
-}
+};
create type TinySocial.FacebookMessageType as
closed {
@@ -67,5 +67,5 @@ create type TinySocial.FacebookMessageType as
`in-response-to` : bigint?,
`sender-location` : point?,
message : string
-}
+};
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q01/q01.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q01/q01.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q01/q01.1.ddl.sqlpp
index 46c5073..769c5e7 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q01/q01.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q01/q01.1.ddl.sqlpp
@@ -45,7 +45,7 @@ create type tpcds.store_returns_type as
sr_reversed_charge : double?,
sr_store_credit : double?,
sr_net_loss : double?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -77,7 +77,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.store_type as
closed {
@@ -110,7 +110,7 @@ create type tpcds.store_type as
s_country : string?,
s_gmt_offset : double?,
s_tax_precentage : double?
-}
+};
create type tpcds.customer_type as
closed {
@@ -132,7 +132,7 @@ create type tpcds.customer_type as
c_login : string?,
c_email_address : string?,
c_last_review_date : string?
-}
+};
create dataset store_returns (store_returns_type) primary key sr_item_sk, sr_ticket_number;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q03/q03.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q03/q03.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q03/q03.1.ddl.sqlpp
index acd3953..5ed28b5 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q03/q03.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q03/q03.1.ddl.sqlpp
@@ -47,7 +47,7 @@ create type tpcds.item_type as
i_container : string?,
i_manager_id : bigint?,
i_product_name : string?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -79,7 +79,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.store_sales_type as
closed {
@@ -106,7 +106,7 @@ create type tpcds.store_sales_type as
ss_net_paid: double?,
ss_net_paid_inc_tax: double?,
ss_net_profit: double?
-}
+};
create dataset item (item_type) primary key i_item_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q07/q07.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q07/q07.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q07/q07.1.ddl.sqlpp
index 5b5281f..9d41280 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q07/q07.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q07/q07.1.ddl.sqlpp
@@ -47,7 +47,7 @@ create type tpcds.item_type as
i_container : string?,
i_manager_id : bigint?,
i_product_name : string?
-}
+};
create type tpcds.customer_demographics_type as
closed {
@@ -60,7 +60,7 @@ create type tpcds.customer_demographics_type as
cd_dep_count : bigint?,
cd_dep_employed_count : bigint?,
cd_dep_college_count : bigint?
-}
+};
create type tpcds.store_sales_type as
closed {
@@ -87,7 +87,7 @@ create type tpcds.store_sales_type as
ss_net_paid: double?,
ss_net_paid_inc_tax: double?,
ss_net_profit: double?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -119,7 +119,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.promotion_type as
closed {
@@ -142,7 +142,7 @@ create type tpcds.promotion_type as
p_channel_details : string?,
p_purpose : string?,
p_discount_active : string?
-}
+};
create dataset item (item_type) primary key i_item_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q09/q09.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q09/q09.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q09/q09.1.ddl.sqlpp
index 9dd7f40..b885dff 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q09/q09.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q09/q09.1.ddl.sqlpp
@@ -28,7 +28,7 @@ create type tpcds.reason_type as
r_reason_sk : int64,
r_reason_id : string,
r_reason_desc : string?
-}
+};
create type tpcds.store_sales_type as
closed {
ss_sold_date_sk: int64?,
@@ -54,8 +54,8 @@ create type tpcds.store_sales_type as
ss_net_paid: double?,
ss_net_paid_inc_tax: double?,
ss_net_profit: double?
-}
+};
-create dataset reason(reason_type) primary key r_reason_sk
+create dataset reason(reason_type) primary key r_reason_sk;
create dataset store_sales (store_sales_type) primary key ss_item_sk, ss_ticket_number;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q09/q09.3.query.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q09/q09.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q09/q09.3.query.sqlpp
index e0ae61c..41c02ce 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q09/q09.3.query.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q09/q09.3.query.sqlpp
@@ -20,8 +20,8 @@
use tpcds;
-set `compiler.joinmemory` "4MB"
-set `compiler.groupmemory` "4MB"
+set `compiler.joinmemory` "4MB";
+set `compiler.groupmemory` "4MB";
select case when (select value count(ss)
from store_sales ss
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q15/q15.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q15/q15.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q15/q15.1.ddl.sqlpp
index 5a9dea9..3c40721 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q15/q15.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q15/q15.1.ddl.sqlpp
@@ -38,7 +38,7 @@ create type tpcds.customer_address_type as closed {
ca_country : string?,
ca_gmt_offset : double?,
ca_location_type : string?
- }
+ };
create type tpcds.catalog_sales_type as
closed {
@@ -75,7 +75,7 @@ create type tpcds.catalog_sales_type as
cs_net_paid_inc_ship: double?,
cs_net_paid_inc_ship_tax: double?,
cs_net_profit: double?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -107,7 +107,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.customer_type as
closed {
@@ -129,7 +129,7 @@ create type tpcds.customer_type as
c_login : string?,
c_email_address : string?,
c_last_review_date : string?
-}
+};
create dataset customer_address(customer_address_type) primary key ca_address_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q19/q19.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q19/q19.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q19/q19.1.ddl.sqlpp
index 1b30bcd..b2c6e40 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q19/q19.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q19/q19.1.ddl.sqlpp
@@ -38,7 +38,7 @@ create type tpcds.customer_address_type as closed {
ca_country : string?,
ca_gmt_offset : double?,
ca_location_type : string?
- }
+ };
create type tpcds.item_type as
closed {
@@ -64,7 +64,7 @@ create type tpcds.item_type as
i_container : string?,
i_manager_id : bigint?,
i_product_name : string?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -96,7 +96,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.store_sales_type as
closed {
@@ -123,7 +123,7 @@ create type tpcds.store_sales_type as
ss_net_paid: double?,
ss_net_paid_inc_tax: double?,
ss_net_profit: double?
-}
+};
create type tpcds.store_type as
closed {
@@ -156,7 +156,7 @@ create type tpcds.store_type as
s_country : string?,
s_gmt_offset : double?,
s_tax_precentage : double?
-}
+};
create type tpcds.customer_type as
closed {
@@ -178,7 +178,7 @@ create type tpcds.customer_type as
c_login : string?,
c_email_address : string?,
c_last_review_date : string?
-}
+};
create dataset customer_address(customer_address_type) primary key ca_address_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q21/q21.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q21/q21.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q21/q21.1.ddl.sqlpp
index de454ba..083f081 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q21/q21.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q21/q21.1.ddl.sqlpp
@@ -47,7 +47,7 @@ create type tpcds.item_type as
i_container : string?,
i_manager_id : bigint?,
i_product_name : string?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -79,7 +79,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.inventory_type as
closed {
@@ -87,7 +87,7 @@ create type tpcds.inventory_type as
inv_item_sk : bigint,
inv_warehouse_sk : bigint,
inv_quantity_on_hand : bigint?
-}
+};
create type tpcds.warehouse_type as
closed {
@@ -105,7 +105,7 @@ create type tpcds.warehouse_type as
w_zip : string?,
w_country : string?,
w_gmt_offset : double?
-}
+};
create dataset item (item_type) primary key i_item_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q24a/q24a.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q24a/q24a.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q24a/q24a.1.ddl.sqlpp
index b7b449f..4b879c0 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q24a/q24a.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q24a/q24a.1.ddl.sqlpp
@@ -38,7 +38,7 @@ create type tpcds.customer_address_type as closed {
ca_country : string?,
ca_gmt_offset : double?,
ca_location_type : string?
- }
+ };
create type tpcds.item_type as
closed {
@@ -64,7 +64,7 @@ create type tpcds.item_type as
i_container : string?,
i_manager_id : bigint?,
i_product_name : string?
-}
+};
create type tpcds.store_returns_type as
closed {
@@ -88,7 +88,7 @@ create type tpcds.store_returns_type as
sr_reversed_charge : double?,
sr_store_credit : double?,
sr_net_loss : double?
-}
+};
create type tpcds.store_sales_type as
closed {
@@ -115,7 +115,7 @@ create type tpcds.store_sales_type as
ss_net_paid: double?,
ss_net_paid_inc_tax: double?,
ss_net_profit: double?
-}
+};
create type tpcds.store_type as
closed {
@@ -148,7 +148,7 @@ create type tpcds.store_type as
s_country : string?,
s_gmt_offset : double?,
s_tax_precentage : double?
-}
+};
create type tpcds.customer_type as
closed {
@@ -170,7 +170,7 @@ create type tpcds.customer_type as
c_login : string?,
c_email_address : string?,
c_last_review_date : string?
-}
+};
create dataset customer_address(customer_address_type) primary key ca_address_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q24b/q24b.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q24b/q24b.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q24b/q24b.1.ddl.sqlpp
index b7b449f..4b879c0 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q24b/q24b.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q24b/q24b.1.ddl.sqlpp
@@ -38,7 +38,7 @@ create type tpcds.customer_address_type as closed {
ca_country : string?,
ca_gmt_offset : double?,
ca_location_type : string?
- }
+ };
create type tpcds.item_type as
closed {
@@ -64,7 +64,7 @@ create type tpcds.item_type as
i_container : string?,
i_manager_id : bigint?,
i_product_name : string?
-}
+};
create type tpcds.store_returns_type as
closed {
@@ -88,7 +88,7 @@ create type tpcds.store_returns_type as
sr_reversed_charge : double?,
sr_store_credit : double?,
sr_net_loss : double?
-}
+};
create type tpcds.store_sales_type as
closed {
@@ -115,7 +115,7 @@ create type tpcds.store_sales_type as
ss_net_paid: double?,
ss_net_paid_inc_tax: double?,
ss_net_profit: double?
-}
+};
create type tpcds.store_type as
closed {
@@ -148,7 +148,7 @@ create type tpcds.store_type as
s_country : string?,
s_gmt_offset : double?,
s_tax_precentage : double?
-}
+};
create type tpcds.customer_type as
closed {
@@ -170,7 +170,7 @@ create type tpcds.customer_type as
c_login : string?,
c_email_address : string?,
c_last_review_date : string?
-}
+};
create dataset customer_address(customer_address_type) primary key ca_address_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q25/q25.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q25/q25.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q25/q25.1.ddl.sqlpp
index 418a756..8391405 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q25/q25.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q25/q25.1.ddl.sqlpp
@@ -47,7 +47,7 @@ create type tpcds.item_type as
i_container : string?,
i_manager_id : bigint?,
i_product_name : string?
-}
+};
create type tpcds.store_returns_type as
closed {
@@ -71,7 +71,7 @@ create type tpcds.store_returns_type as
sr_reversed_charge : double?,
sr_store_credit : double?,
sr_net_loss : double?
-}
+};
create type tpcds.store_sales_type as
closed {
@@ -98,7 +98,7 @@ create type tpcds.store_sales_type as
ss_net_paid: double?,
ss_net_paid_inc_tax: double?,
ss_net_profit: double?
-}
+};
create type tpcds.catalog_sales_type as
closed {
@@ -135,7 +135,7 @@ create type tpcds.catalog_sales_type as
cs_net_paid_inc_ship: double?,
cs_net_paid_inc_ship_tax: double?,
cs_net_profit: double?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -167,7 +167,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.store_type as
closed {
@@ -200,7 +200,7 @@ create type tpcds.store_type as
s_country : string?,
s_gmt_offset : double?,
s_tax_precentage : double?
-}
+};
create dataset item (item_type) primary key i_item_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q26/q26.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q26/q26.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q26/q26.1.ddl.sqlpp
index 2a668dd..1320742 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q26/q26.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q26/q26.1.ddl.sqlpp
@@ -47,7 +47,7 @@ create type tpcds.item_type as
i_container : string?,
i_manager_id : bigint?,
i_product_name : string?
-}
+};
create type tpcds.customer_demographics_type as
closed {
@@ -60,7 +60,7 @@ create type tpcds.customer_demographics_type as
cd_dep_count : bigint?,
cd_dep_employed_count : bigint?,
cd_dep_college_count : bigint?
-}
+};
create type tpcds.catalog_sales_type as
closed {
cs_sold_date_sk: bigint?,
@@ -96,7 +96,7 @@ create type tpcds.catalog_sales_type as
cs_net_paid_inc_ship: double?,
cs_net_paid_inc_ship_tax: double?,
cs_net_profit: double?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -128,7 +128,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.promotion_type as
closed {
@@ -151,7 +151,7 @@ create type tpcds.promotion_type as
p_channel_details : string?,
p_purpose : string?,
p_discount_active : string?
-}
+};
create dataset item (item_type) primary key i_item_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q29/q29.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q29/q29.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q29/q29.1.ddl.sqlpp
index 418a756..8391405 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q29/q29.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q29/q29.1.ddl.sqlpp
@@ -47,7 +47,7 @@ create type tpcds.item_type as
i_container : string?,
i_manager_id : bigint?,
i_product_name : string?
-}
+};
create type tpcds.store_returns_type as
closed {
@@ -71,7 +71,7 @@ create type tpcds.store_returns_type as
sr_reversed_charge : double?,
sr_store_credit : double?,
sr_net_loss : double?
-}
+};
create type tpcds.store_sales_type as
closed {
@@ -98,7 +98,7 @@ create type tpcds.store_sales_type as
ss_net_paid: double?,
ss_net_paid_inc_tax: double?,
ss_net_profit: double?
-}
+};
create type tpcds.catalog_sales_type as
closed {
@@ -135,7 +135,7 @@ create type tpcds.catalog_sales_type as
cs_net_paid_inc_ship: double?,
cs_net_paid_inc_ship_tax: double?,
cs_net_profit: double?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -167,7 +167,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.store_type as
closed {
@@ -200,7 +200,7 @@ create type tpcds.store_type as
s_country : string?,
s_gmt_offset : double?,
s_tax_precentage : double?
-}
+};
create dataset item (item_type) primary key i_item_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q30/q30.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q30/q30.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q30/q30.1.ddl.sqlpp
index 86c6792..1b494b0 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q30/q30.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q30/q30.1.ddl.sqlpp
@@ -38,7 +38,7 @@ create type tpcds.customer_address_type as closed {
ca_country : string?,
ca_gmt_offset : double?,
ca_location_type : string?
- }
+ };
create type tpcds.date_dim_type as
closed {
@@ -70,7 +70,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.web_returns_type as
closed {
@@ -98,7 +98,7 @@ create type tpcds.web_returns_type as
wr_reversed_charge: double?,
wr_account_credit: double?,
wr_net_loss: double?
-}
+};
create type tpcds.customer_type as
closed {
@@ -120,7 +120,7 @@ create type tpcds.customer_type as
c_login : string?,
c_email_address : string?,
c_last_review_date : string?
-}
+};
create dataset customer_address(customer_address_type) primary key ca_address_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q31/q31.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q31/q31.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q31/q31.1.ddl.sqlpp
index 3762222..ba20f6e 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q31/q31.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q31/q31.1.ddl.sqlpp
@@ -38,7 +38,7 @@ create type tpcds.customer_address_type as closed {
ca_country : string?,
ca_gmt_offset : double?,
ca_location_type : string?
- }
+ };
create type tpcds.web_sales_type as
closed {
@@ -76,7 +76,7 @@ create type tpcds.web_sales_type as
ws_net_paid_inc_ship : double?,
ws_net_paid_inc_ship_tax : double?,
ws_net_profit : double?
-}
+};
create type tpcds.store_sales_type as
closed {
@@ -103,7 +103,7 @@ create type tpcds.store_sales_type as
ss_net_paid: double?,
ss_net_paid_inc_tax: double?,
ss_net_profit: double?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -135,7 +135,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create dataset customer_address(customer_address_type) primary key ca_address_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q34/q34.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q34/q34.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q34/q34.1.ddl.sqlpp
index f7a6453..b7e5750 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q34/q34.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q34/q34.1.ddl.sqlpp
@@ -30,7 +30,7 @@ create type tpcds.household_demographics_type as
hd_buy_potential : string?,
hd_dep_count : bigint?,
hd_vehicle_count : bigint?
-}
+};
create type tpcds.store_sales_type as
closed {
ss_sold_date_sk: bigint?,
@@ -56,7 +56,7 @@ create type tpcds.store_sales_type as
ss_net_paid: double?,
ss_net_paid_inc_tax: double?,
ss_net_profit: double?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -88,7 +88,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.store_type as
closed {
@@ -121,7 +121,7 @@ create type tpcds.store_type as
s_country : string?,
s_gmt_offset : double?,
s_tax_precentage : double?
-}
+};
create type tpcds.customer_type as
closed {
@@ -143,7 +143,7 @@ create type tpcds.customer_type as
c_login : string?,
c_email_address : string?,
c_last_review_date : string?
-}
+};
create dataset household_demographics (household_demographics_type) primary key hd_demo_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q37/q37.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q37/q37.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q37/q37.1.ddl.sqlpp
index cb90a52..24cbaa4 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q37/q37.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q37/q37.1.ddl.sqlpp
@@ -47,7 +47,7 @@ create type tpcds.item_type as
i_container : string?,
i_manager_id : bigint?,
i_product_name : string?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -79,7 +79,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.catalog_sales_type as
closed {
@@ -116,7 +116,7 @@ create type tpcds.catalog_sales_type as
cs_net_paid_inc_ship: double?,
cs_net_paid_inc_ship_tax: double?,
cs_net_profit: double?
-}
+};
create type tpcds.inventory_type as
closed {
@@ -124,7 +124,7 @@ create type tpcds.inventory_type as
inv_item_sk : bigint,
inv_warehouse_sk : bigint,
inv_quantity_on_hand : bigint?
-}
+};
create dataset item (item_type) primary key i_item_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q41/q41.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q41/q41.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q41/q41.1.ddl.sqlpp
index 8bc86f0..067995f 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q41/q41.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q41/q41.1.ddl.sqlpp
@@ -47,6 +47,6 @@ create type tpcds.item_type as
i_container : string?,
i_manager_id : bigint?,
i_product_name : string?
-}
+};
create dataset item (item_type) primary key i_item_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q42/q42.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q42/q42.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q42/q42.1.ddl.sqlpp
index acd3953..5ed28b5 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q42/q42.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q42/q42.1.ddl.sqlpp
@@ -47,7 +47,7 @@ create type tpcds.item_type as
i_container : string?,
i_manager_id : bigint?,
i_product_name : string?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -79,7 +79,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.store_sales_type as
closed {
@@ -106,7 +106,7 @@ create type tpcds.store_sales_type as
ss_net_paid: double?,
ss_net_paid_inc_tax: double?,
ss_net_profit: double?
-}
+};
create dataset item (item_type) primary key i_item_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q43/q43.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q43/q43.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q43/q43.1.ddl.sqlpp
index 1c86ec3..5692658 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q43/q43.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q43/q43.1.ddl.sqlpp
@@ -53,7 +53,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.store_sales_type as
closed {
@@ -80,7 +80,7 @@ create type tpcds.store_sales_type as
ss_net_paid: double?,
ss_net_paid_inc_tax: double?,
ss_net_profit: double?
-}
+};
create type tpcds.store_type as
closed {
@@ -113,7 +113,7 @@ create type tpcds.store_type as
s_country : string?,
s_gmt_offset : double?,
s_tax_precentage : double?
-}
+};
create dataset date_dim(date_dim_type) primary key d_date_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q45/q45.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q45/q45.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q45/q45.1.ddl.sqlpp
index 4eebc51..fbc86c2 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q45/q45.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q45/q45.1.ddl.sqlpp
@@ -38,7 +38,7 @@ create type tpcds.customer_address_type as closed {
ca_country : string?,
ca_gmt_offset : double?,
ca_location_type : string?
- }
+ };
create type tpcds.item_type as
closed {
@@ -64,7 +64,7 @@ create type tpcds.item_type as
i_container : string?,
i_manager_id : bigint?,
i_product_name : string?
-}
+};
create type tpcds.web_sales_type as
closed {
@@ -102,7 +102,7 @@ create type tpcds.web_sales_type as
ws_net_paid_inc_ship : double?,
ws_net_paid_inc_ship_tax : double?,
ws_net_profit : double?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -134,7 +134,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.customer_type as
closed {
@@ -156,7 +156,7 @@ create type tpcds.customer_type as
c_login : string?,
c_email_address : string?,
c_last_review_date : string?
-}
+};
create dataset customer_address(customer_address_type) primary key ca_address_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q46/q46.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q46/q46.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q46/q46.1.ddl.sqlpp
index 67e2de3..37e2b15 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q46/q46.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q46/q46.1.ddl.sqlpp
@@ -38,7 +38,7 @@ create type tpcds.customer_address_type as closed {
ca_country : string?,
ca_gmt_offset : double?,
ca_location_type : string?
- }
+ };
create type tpcds.household_demographics_type as
closed {
@@ -47,7 +47,7 @@ create type tpcds.household_demographics_type as
hd_buy_potential : string?,
hd_dep_count : bigint?,
hd_vehicle_count : bigint?
-}
+};
create type tpcds.store_sales_type as
closed {
@@ -74,7 +74,7 @@ create type tpcds.store_sales_type as
ss_net_paid: double?,
ss_net_paid_inc_tax: double?,
ss_net_profit: double?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -106,7 +106,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.store_type as
closed {
@@ -139,7 +139,7 @@ create type tpcds.store_type as
s_country : string?,
s_gmt_offset : double?,
s_tax_precentage : double?
-}
+};
create type tpcds.customer_type as
closed {
@@ -161,7 +161,7 @@ create type tpcds.customer_type as
c_login : string?,
c_email_address : string?,
c_last_review_date : string?
-}
+};
create dataset customer_address(customer_address_type) primary key ca_address_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q50/q50.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q50/q50.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q50/q50.1.ddl.sqlpp
index 8779419..058a5dd 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q50/q50.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q50/q50.1.ddl.sqlpp
@@ -45,7 +45,7 @@ create type tpcds.store_returns_type as
sr_reversed_charge : double?,
sr_store_credit : double?,
sr_net_loss : double?
-}
+};
create type tpcds.store_sales_type as
closed {
@@ -72,7 +72,7 @@ create type tpcds.store_sales_type as
ss_net_paid: double?,
ss_net_paid_inc_tax: double?,
ss_net_profit: double?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -104,7 +104,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.store_type as
closed {
@@ -137,7 +137,7 @@ create type tpcds.store_type as
s_country : string?,
s_gmt_offset : double?,
s_tax_precentage : double?
-}
+};
create dataset store_returns (store_returns_type) primary key sr_item_sk, sr_ticket_number;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q52/q52.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q52/q52.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q52/q52.1.ddl.sqlpp
index acd3953..5ed28b5 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q52/q52.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q52/q52.1.ddl.sqlpp
@@ -47,7 +47,7 @@ create type tpcds.item_type as
i_container : string?,
i_manager_id : bigint?,
i_product_name : string?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -79,7 +79,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.store_sales_type as
closed {
@@ -106,7 +106,7 @@ create type tpcds.store_sales_type as
ss_net_paid: double?,
ss_net_paid_inc_tax: double?,
ss_net_profit: double?
-}
+};
create dataset item (item_type) primary key i_item_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q55/q55.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q55/q55.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q55/q55.1.ddl.sqlpp
index acd3953..5ed28b5 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q55/q55.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q55/q55.1.ddl.sqlpp
@@ -47,7 +47,7 @@ create type tpcds.item_type as
i_container : string?,
i_manager_id : bigint?,
i_product_name : string?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -79,7 +79,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.store_sales_type as
closed {
@@ -106,7 +106,7 @@ create type tpcds.store_sales_type as
ss_net_paid: double?,
ss_net_paid_inc_tax: double?,
ss_net_profit: double?
-}
+};
create dataset item (item_type) primary key i_item_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q59/q59.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q59/q59.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q59/q59.1.ddl.sqlpp
index fb4779f..dcf5df0 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q59/q59.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q59/q59.1.ddl.sqlpp
@@ -48,7 +48,7 @@ create type tpcds.store_sales_type as
ss_net_paid: double?,
ss_net_paid_inc_tax: double?,
ss_net_profit: double?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -80,7 +80,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.store_type as
closed {
@@ -113,7 +113,7 @@ create type tpcds.store_type as
s_country : string?,
s_gmt_offset : double?,
s_tax_precentage : double?
-}
+};
create dataset store_sales (store_sales_type) primary key ss_item_sk, ss_ticket_number;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q62/q62.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q62/q62.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q62/q62.1.ddl.sqlpp
index f9d0500..a870454 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q62/q62.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q62/q62.1.ddl.sqlpp
@@ -59,7 +59,7 @@ create type tpcds.web_sales_type as
ws_net_paid_inc_ship : double?,
ws_net_paid_inc_ship_tax : double?,
ws_net_profit : double?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -91,7 +91,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.web_site_type as
closed {
@@ -121,7 +121,7 @@ create type tpcds.web_site_type as
web_country: string?,
web_gmt_offset: double?,
web_tax_percentage: double?
-}
+};
create type tpcds.warehouse_type as
closed {
@@ -139,7 +139,7 @@ create type tpcds.warehouse_type as
w_zip : string?,
w_country : string?,
w_gmt_offset : double?
-}
+};
create type tpcds.ship_mode_type as
closed {
@@ -149,7 +149,7 @@ create type tpcds.ship_mode_type as
sm_code : string?,
sm_carrier : string?,
sm_contract : string?
-}
+};
create dataset web_sales (web_sales_type) primary key ws_item_sk, ws_order_number;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q68/q68.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q68/q68.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q68/q68.1.ddl.sqlpp
index 3d99b67..7bf7b35 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q68/q68.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q68/q68.1.ddl.sqlpp
@@ -38,7 +38,7 @@ create type tpcds.customer_address_type as closed {
ca_country : string?,
ca_gmt_offset : double?,
ca_location_type : string?
- }
+ };
create type tpcds.household_demographics_type as
closed {
@@ -47,7 +47,7 @@ create type tpcds.household_demographics_type as
hd_buy_potential : string?,
hd_dep_count : bigint?,
hd_vehicle_count : bigint?
-}
+};
create type tpcds.store_sales_type as
closed {
ss_sold_date_sk: bigint?,
@@ -73,7 +73,7 @@ create type tpcds.store_sales_type as
ss_net_paid: double?,
ss_net_paid_inc_tax: double?,
ss_net_profit: double?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -105,7 +105,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.store_type as
closed {
@@ -138,7 +138,7 @@ create type tpcds.store_type as
s_country : string?,
s_gmt_offset : double?,
s_tax_precentage : double?
-}
+};
create type tpcds.customer_type as
closed {
@@ -160,7 +160,7 @@ create type tpcds.customer_type as
c_login : string?,
c_email_address : string?,
c_last_review_date : string?
-}
+};
create dataset customer_address(customer_address_type) primary key ca_address_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q73/q73.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q73/q73.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q73/q73.1.ddl.sqlpp
index f7a6453..b7e5750 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q73/q73.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q73/q73.1.ddl.sqlpp
@@ -30,7 +30,7 @@ create type tpcds.household_demographics_type as
hd_buy_potential : string?,
hd_dep_count : bigint?,
hd_vehicle_count : bigint?
-}
+};
create type tpcds.store_sales_type as
closed {
ss_sold_date_sk: bigint?,
@@ -56,7 +56,7 @@ create type tpcds.store_sales_type as
ss_net_paid: double?,
ss_net_paid_inc_tax: double?,
ss_net_profit: double?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -88,7 +88,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.store_type as
closed {
@@ -121,7 +121,7 @@ create type tpcds.store_type as
s_country : string?,
s_gmt_offset : double?,
s_tax_precentage : double?
-}
+};
create type tpcds.customer_type as
closed {
@@ -143,7 +143,7 @@ create type tpcds.customer_type as
c_login : string?,
c_email_address : string?,
c_last_review_date : string?
-}
+};
create dataset household_demographics (household_demographics_type) primary key hd_demo_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q79/q79.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q79/q79.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q79/q79.1.ddl.sqlpp
index f7a6453..b7e5750 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q79/q79.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q79/q79.1.ddl.sqlpp
@@ -30,7 +30,7 @@ create type tpcds.household_demographics_type as
hd_buy_potential : string?,
hd_dep_count : bigint?,
hd_vehicle_count : bigint?
-}
+};
create type tpcds.store_sales_type as
closed {
ss_sold_date_sk: bigint?,
@@ -56,7 +56,7 @@ create type tpcds.store_sales_type as
ss_net_paid: double?,
ss_net_paid_inc_tax: double?,
ss_net_profit: double?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -88,7 +88,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.store_type as
closed {
@@ -121,7 +121,7 @@ create type tpcds.store_type as
s_country : string?,
s_gmt_offset : double?,
s_tax_precentage : double?
-}
+};
create type tpcds.customer_type as
closed {
@@ -143,7 +143,7 @@ create type tpcds.customer_type as
c_login : string?,
c_email_address : string?,
c_last_review_date : string?
-}
+};
create dataset household_demographics (household_demographics_type) primary key hd_demo_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q81/q81.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q81/q81.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q81/q81.1.ddl.sqlpp
index 724dde8..1928fe7 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q81/q81.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q81/q81.1.ddl.sqlpp
@@ -38,7 +38,7 @@ create type tpcds.customer_address_type as closed {
ca_country : string?,
ca_gmt_offset : double?,
ca_location_type : string?
- }
+ };
create type tpcds.date_dim_type as
closed {
@@ -70,7 +70,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.catalog_returns_type as
closed {
@@ -101,7 +101,7 @@ create type tpcds.catalog_returns_type as
cr_reversed_charge : double?,
cr_store_credit : double?,
cr_net_loss : double?
-}
+};
create type tpcds.customer_type as
closed {
@@ -123,7 +123,7 @@ create type tpcds.customer_type as
c_login : string?,
c_email_address : string?,
c_last_review_date : string?
-}
+};
create dataset customer_address(customer_address_type) primary key ca_address_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q82/q82.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q82/q82.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q82/q82.1.ddl.sqlpp
index c2cc51b..7e9fb67 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q82/q82.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q82/q82.1.ddl.sqlpp
@@ -47,7 +47,7 @@ create type tpcds.item_type as
i_container : string?,
i_manager_id : bigint?,
i_product_name : string?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -79,7 +79,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.store_sales_type as
closed {
@@ -106,7 +106,7 @@ create type tpcds.store_sales_type as
ss_net_paid: double?,
ss_net_paid_inc_tax: double?,
ss_net_profit: double?
-}
+};
create type tpcds.inventory_type as
closed {
@@ -114,7 +114,7 @@ create type tpcds.inventory_type as
inv_item_sk : bigint,
inv_warehouse_sk : bigint,
inv_quantity_on_hand : bigint?
-}
+};
create dataset item (item_type) primary key i_item_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q85/q85.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q85/q85.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q85/q85.1.ddl.sqlpp
index 2354901..c235423 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q85/q85.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q85/q85.1.ddl.sqlpp
@@ -39,7 +39,7 @@ create type tpcds.web_page_type as
wp_link_count : int64?,
wp_image_count : int64?,
wp_max_ad_count : int64?
-}
+};
create type tpcds.customer_address_type as closed {
@@ -56,14 +56,14 @@ create type tpcds.customer_address_type as closed {
ca_country : string?,
ca_gmt_offset : double?,
ca_location_type : string?
- }
+ };
create type tpcds.reason_type as
closed {
r_reason_sk : int64,
r_reason_id : string,
r_reason_desc : string?
-}
+};
create type tpcds.customer_demographics_type as
closed {
@@ -76,7 +76,7 @@ create type tpcds.customer_demographics_type as
cd_dep_count : int64?,
cd_dep_employed_count : int64?,
cd_dep_college_count : int64?
-}
+};
create type tpcds.web_sales_type as
closed {
@@ -114,7 +114,7 @@ create type tpcds.web_sales_type as
ws_net_paid_inc_ship : double?,
ws_net_paid_inc_ship_tax : double?,
ws_net_profit : double?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -146,7 +146,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.web_returns_type as
closed {
@@ -174,13 +174,13 @@ create type tpcds.web_returns_type as
wr_reversed_charge: double?,
wr_account_credit: double?,
wr_net_loss: double?
-}
+};
create dataset web_page (web_page_type) primary key wp_web_page_sk;
create dataset customer_address(customer_address_type) primary key ca_address_sk;
-create dataset reason(reason_type) primary key r_reason_sk
+create dataset reason(reason_type) primary key r_reason_sk;
create dataset customer_demographics(customer_demographics_type) primary key cd_demo_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q88/q88.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q88/q88.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q88/q88.1.ddl.sqlpp
index 342fecd..1751318 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q88/q88.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q88/q88.1.ddl.sqlpp
@@ -30,7 +30,7 @@ create type tpcds.household_demographics_type as
hd_buy_potential : string?,
hd_dep_count : bigint?,
hd_vehicle_count : bigint?
-}
+};
create type tpcds.time_dim_type as
closed {
t_time_sk : bigint,
@@ -43,7 +43,7 @@ create type tpcds.time_dim_type as
t_shift : string?,
t_sub_shift : string?,
t_meal_time : string?
-}
+};
create type tpcds.store_sales_type as
closed {
ss_sold_date_sk: bigint?,
@@ -69,7 +69,7 @@ create type tpcds.store_sales_type as
ss_net_paid: double?,
ss_net_paid_inc_tax: double?,
ss_net_profit: double?
-}
+};
create type tpcds.store_type as
closed {
@@ -102,11 +102,11 @@ create type tpcds.store_type as
s_country : string?,
s_gmt_offset : double?,
s_tax_precentage : double?
-}
+};
create dataset household_demographics (household_demographics_type) primary key hd_demo_sk;
-create dataset tpcds.time_dim(time_dim_type) primary key t_time_sk
+create dataset tpcds.time_dim(time_dim_type) primary key t_time_sk;
create dataset store_sales (store_sales_type) primary key ss_item_sk, ss_ticket_number;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q90/q90.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q90/q90.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q90/q90.1.ddl.sqlpp
index f6cc711..ba0dbf1 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q90/q90.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q90/q90.1.ddl.sqlpp
@@ -39,7 +39,7 @@ create type tpcds.web_page_type as
wp_link_count : int64?,
wp_image_count : int64?,
wp_max_ad_count : int64?
-}
+};
create type tpcds.household_demographics_type as
closed {
@@ -48,7 +48,7 @@ create type tpcds.household_demographics_type as
hd_buy_potential : string?,
hd_dep_count : int64?,
hd_vehicle_count : int64?
-}
+};
create type tpcds.time_dim_type as
closed {
t_time_sk : int64,
@@ -61,7 +61,7 @@ create type tpcds.time_dim_type as
t_shift : string?,
t_sub_shift : string?,
t_meal_time : string?
-}
+};
create type tpcds.web_sales_type as
closed {
ws_sold_date_sk : int64?,
@@ -98,12 +98,12 @@ create type tpcds.web_sales_type as
ws_net_paid_inc_ship : double?,
ws_net_paid_inc_ship_tax : double?,
ws_net_profit : double?
-}
+};
create dataset web_page (web_page_type) primary key wp_web_page_sk;
create dataset household_demographics (household_demographics_type) primary key hd_demo_sk;
-create dataset tpcds.time_dim(time_dim_type) primary key t_time_sk
+create dataset tpcds.time_dim(time_dim_type) primary key t_time_sk;
create dataset web_sales (web_sales_type) primary key ws_item_sk, ws_order_number;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q91/q91.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q91/q91.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q91/q91.1.ddl.sqlpp
index 5497be1..7ab4ec6 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q91/q91.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q91/q91.1.ddl.sqlpp
@@ -38,7 +38,7 @@ create type tpcds.customer_address_type as closed {
ca_country : string?,
ca_gmt_offset : double?,
ca_location_type : string?
- }
+ };
create type tpcds.call_center_type as
closed {
@@ -73,7 +73,7 @@ create type tpcds.call_center_type as
cc_country : string?,
cc_gmt_offset : double?,
cc_tax_percentage : double?
-}
+};
create type tpcds.household_demographics_type as
closed {
@@ -82,7 +82,7 @@ create type tpcds.household_demographics_type as
hd_buy_potential : string?,
hd_dep_count : bigint?,
hd_vehicle_count : bigint?
-}
+};
create type tpcds.customer_demographics_type as
closed {
cd_demo_sk : bigint,
@@ -94,7 +94,7 @@ create type tpcds.customer_demographics_type as
cd_dep_count : bigint?,
cd_dep_employed_count : bigint?,
cd_dep_college_count : bigint?
-}
+};
create type tpcds.date_dim_type as
closed {
d_date_sk : bigint,
@@ -125,7 +125,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.catalog_returns_type as
closed {
@@ -156,7 +156,7 @@ create type tpcds.catalog_returns_type as
cr_reversed_charge : double?,
cr_store_credit : double?,
cr_net_loss : double?
-}
+};
create type tpcds.customer_type as
closed {
@@ -178,7 +178,7 @@ create type tpcds.customer_type as
c_login : string?,
c_email_address : string?,
c_last_review_date : string?
-}
+};
create dataset customer_address(customer_address_type) primary key ca_address_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q92/q92.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q92/q92.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q92/q92.1.ddl.sqlpp
index bc536d6..18972cd 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q92/q92.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q92/q92.1.ddl.sqlpp
@@ -47,7 +47,7 @@ create type tpcds.item_type as
i_container : string?,
i_manager_id : int64?,
i_product_name : string?
-}
+};
create type tpcds.web_sales_type as
closed {
@@ -85,7 +85,7 @@ create type tpcds.web_sales_type as
ws_net_paid_inc_ship : double?,
ws_net_paid_inc_ship_tax : double?,
ws_net_profit : double?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -117,7 +117,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create dataset item (item_type) primary key i_item_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q94/q94.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q94/q94.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q94/q94.1.ddl.sqlpp
index 027a556..806c5b8 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q94/q94.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q94/q94.1.ddl.sqlpp
@@ -38,7 +38,7 @@ create type tpcds.customer_address_type as closed {
ca_country : string?,
ca_gmt_offset : double?,
ca_location_type : string?
- }
+ };
create type tpcds.web_sales_type as
closed {
@@ -76,7 +76,7 @@ create type tpcds.web_sales_type as
ws_net_paid_inc_ship : double?,
ws_net_paid_inc_ship_tax : double?,
ws_net_profit : double?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -108,7 +108,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.web_returns_type as
closed {
@@ -136,7 +136,7 @@ create type tpcds.web_returns_type as
wr_reversed_charge: double?,
wr_account_credit: double?,
wr_net_loss: double?
-}
+};
create type tpcds.web_site_type as
closed {
@@ -166,7 +166,7 @@ create type tpcds.web_site_type as
web_country: string?,
web_gmt_offset: double?,
web_tax_percentage: double?
-}
+};
create dataset customer_address(customer_address_type) primary key ca_address_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q95/q95.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q95/q95.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q95/q95.1.ddl.sqlpp
index 027a556..806c5b8 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q95/q95.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q95/q95.1.ddl.sqlpp
@@ -38,7 +38,7 @@ create type tpcds.customer_address_type as closed {
ca_country : string?,
ca_gmt_offset : double?,
ca_location_type : string?
- }
+ };
create type tpcds.web_sales_type as
closed {
@@ -76,7 +76,7 @@ create type tpcds.web_sales_type as
ws_net_paid_inc_ship : double?,
ws_net_paid_inc_ship_tax : double?,
ws_net_profit : double?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -108,7 +108,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create type tpcds.web_returns_type as
closed {
@@ -136,7 +136,7 @@ create type tpcds.web_returns_type as
wr_reversed_charge: double?,
wr_account_credit: double?,
wr_net_loss: double?
-}
+};
create type tpcds.web_site_type as
closed {
@@ -166,7 +166,7 @@ create type tpcds.web_site_type as
web_country: string?,
web_gmt_offset: double?,
web_tax_percentage: double?
-}
+};
create dataset customer_address(customer_address_type) primary key ca_address_sk;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q96/q96.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q96/q96.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q96/q96.1.ddl.sqlpp
index 342fecd..1751318 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q96/q96.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q96/q96.1.ddl.sqlpp
@@ -30,7 +30,7 @@ create type tpcds.household_demographics_type as
hd_buy_potential : string?,
hd_dep_count : bigint?,
hd_vehicle_count : bigint?
-}
+};
create type tpcds.time_dim_type as
closed {
t_time_sk : bigint,
@@ -43,7 +43,7 @@ create type tpcds.time_dim_type as
t_shift : string?,
t_sub_shift : string?,
t_meal_time : string?
-}
+};
create type tpcds.store_sales_type as
closed {
ss_sold_date_sk: bigint?,
@@ -69,7 +69,7 @@ create type tpcds.store_sales_type as
ss_net_paid: double?,
ss_net_paid_inc_tax: double?,
ss_net_profit: double?
-}
+};
create type tpcds.store_type as
closed {
@@ -102,11 +102,11 @@ create type tpcds.store_type as
s_country : string?,
s_gmt_offset : double?,
s_tax_precentage : double?
-}
+};
create dataset household_demographics (household_demographics_type) primary key hd_demo_sk;
-create dataset tpcds.time_dim(time_dim_type) primary key t_time_sk
+create dataset tpcds.time_dim(time_dim_type) primary key t_time_sk;
create dataset store_sales (store_sales_type) primary key ss_item_sk, ss_ticket_number;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q98/q98.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q98/q98.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q98/q98.1.ddl.sqlpp
index 4769c9c..ca9625c 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q98/q98.1.ddl.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/q98/q98.1.ddl.sqlpp
@@ -47,7 +47,7 @@ create type tpcds.item_type as
i_container : string?,
i_manager_id : bigint?,
i_product_name : string?
-}
+};
create type tpcds.store_sales_type as
closed {
@@ -74,7 +74,7 @@ create type tpcds.store_sales_type as
ss_net_paid: double?,
ss_net_paid_inc_tax: double?,
ss_net_profit: double?
-}
+};
create type tpcds.date_dim_type as
closed {
@@ -106,7 +106,7 @@ create type tpcds.date_dim_type as
d_current_month : string?,
d_current_quarter : string?,
d_current_year : string?
-}
+};
create dataset item (item_type) primary key i_item_sk;