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/08/02 01:14:45 UTC
[43/44] asterixdb git commit: Renaming: "table"->"dataset",
"database"->"dataverse".
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/constant-agg.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/constant-agg.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/constant-agg.sqlpp
index b741e47..5ac3b5a 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/constant-agg.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/constant-agg.sqlpp
@@ -17,8 +17,8 @@
* under the License.
*/
-drop database TinySocial if exists;
-create database TinySocial;
+drop dataverse TinySocial if exists;
+create dataverse TinySocial;
use TinySocial;
@@ -42,10 +42,10 @@ create type TinySocial.FacebookMessageType as
`message-id` : int64
}
-create table FacebookUsers(FacebookUserType) primary key id;
-create table FacebookMessages(FacebookMessageType) primary key `message-id`;
-create table TwitterUsers(TwitterUserType) primary key `screen-name`;
-create table TweetMessages(TweetMessageType) primary key tweetid hints (`CARDINALITY`=`100`);
+create dataset FacebookUsers(FacebookUserType) primary key id;
+create dataset FacebookMessages(FacebookMessageType) primary key `message-id`;
+create dataset TwitterUsers(TwitterUserType) primary key `screen-name`;
+create dataset TweetMessages(TweetMessageType) primary key tweetid hints (`CARDINALITY`=`100`);
SELECT COUNT(1) count
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/constant-gby-agg.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/constant-gby-agg.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/constant-gby-agg.sqlpp
index 328f5bf..b9d4972 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/constant-gby-agg.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/constant-gby-agg.sqlpp
@@ -17,8 +17,8 @@
* under the License.
*/
-drop database TinySocial if exists;
-create database TinySocial;
+drop dataverse TinySocial if exists;
+create dataverse TinySocial;
use TinySocial;
@@ -42,10 +42,10 @@ create type TinySocial.FacebookMessageType as
`message-id` : int64
}
-create table FacebookUsers(FacebookUserType) primary key id;
-create table FacebookMessages(FacebookMessageType) primary key `message-id`;
-create table TwitterUsers(TwitterUserType) primary key `screen-name`;
-create table TweetMessages(TweetMessageType) primary key tweetid hints ("CARDINALITY"="100");
+create dataset FacebookUsers(FacebookUserType) primary key id;
+create dataset FacebookMessages(FacebookMessageType) primary key `message-id`;
+create dataset TwitterUsers(TwitterUserType) primary key `screen-name`;
+create dataset TweetMessages(TweetMessageType) primary key tweetid hints ("CARDINALITY"="100");
SELECT alias alias, COUNT(1) count
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries/loj-core.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/loj-core.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/loj-core.sqlpp
index 1e7648a..fdf21bd 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/loj-core.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/loj-core.sqlpp
@@ -17,8 +17,8 @@
* under the License.
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -41,9 +41,9 @@ create type test.CSXType as
misc : string
}
-create table DBLP(DBLPType) primary key id;
+create dataset DBLP(DBLPType) primary key id;
-create table CSX(CSXType) primary key id;
+create dataset CSX(CSXType) primary key id;
SELECT a.id AS aid, b.id AS bid
FROM DBLP AS a
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries/loj-sugar.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/loj-sugar.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/loj-sugar.sqlpp
index 3639205..214dffd 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/loj-sugar.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/loj-sugar.sqlpp
@@ -17,8 +17,8 @@
* under the License.
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -41,9 +41,9 @@ create type test.CSXType as
misc : string
}
-create table DBLP(DBLPType) primary key id;
+create dataset DBLP(DBLPType) primary key id;
-create table CSX(CSXType) primary key id;
+create dataset CSX(CSXType) primary key id;
SELECT a.id AS aid, b.id AS bid
FROM DBLP AS a
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/exists.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/exists.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/exists.sqlpp
index d045b75..020bb1f 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/exists.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/exists.sqlpp
@@ -17,8 +17,8 @@
* under the License.
*/
-DROP DATABASE test IF EXISTS;
-CREATE DATABASE test;
+DROP DATAVERSE test IF EXISTS;
+CREATE DATAVERSE test;
USE test;
@@ -45,11 +45,11 @@ CREATE TYPE CustomerType AS CLOSED {
c_comment: string
}
-CREATE EXTERNAL TABLE Customer(CustomerType) USING `localfs`
+CREATE EXTERNAL DATASET Customer(CustomerType) USING `localfs`
((`path`=`asterix_nc1://data/tpch0.001/customer.tbl`),
(`input-format`=`text-input-format`),(`format`=`delimited-text`),(`delimiter`=`|`));
-CREATE EXTERNAL TABLE Orders(OrderType) USING `localfs`
+CREATE EXTERNAL DATASET Orders(OrderType) USING `localfs`
((`path`=`asterix_nc1://data/tpch0.001/orders.tbl`),
(`input-format`=`text-input-format`),(`format`=`delimited-text`),(`delimiter`=`|`));
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/in.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/in.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/in.sqlpp
index 0920d6d..606aaf1 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/in.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/in.sqlpp
@@ -17,8 +17,8 @@
* under the License.
*/
-DROP DATABASE test IF EXISTS;
-CREATE DATABASE test;
+DROP DATAVERSE test IF EXISTS;
+CREATE DATAVERSE test;
USE test;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/in_correlated.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/in_correlated.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/in_correlated.sqlpp
index df1a526..f994a65 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/in_correlated.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/in_correlated.sqlpp
@@ -18,8 +18,8 @@
*/
-DROP DATABASE test IF EXISTS;
-CREATE DATABASE test;
+DROP DATAVERSE test IF EXISTS;
+CREATE DATAVERSE test;
USE test;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/not_exists.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/not_exists.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/not_exists.sqlpp
index 6c189e2..2f484b8 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/not_exists.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/not_exists.sqlpp
@@ -17,8 +17,8 @@
* under the License.
*/
-DROP DATABASE test IF EXISTS;
-CREATE DATABASE test;
+DROP DATAVERSE test IF EXISTS;
+CREATE DATAVERSE test;
USE test;
@@ -45,11 +45,11 @@ CREATE TYPE CustomerType AS CLOSED {
c_comment: string
}
-CREATE EXTERNAL TABLE Customer(CustomerType) USING `localfs`
+CREATE EXTERNAL DATASET Customer(CustomerType) USING `localfs`
((`path`=`asterix_nc1://data/tpch0.001/customer.tbl`),
(`input-format`=`text-input-format`),(`format`=`delimited-text`),(`delimiter`=`|`));
-CREATE EXTERNAL TABLE Orders(OrderType) USING `localfs`
+CREATE EXTERNAL DATASET Orders(OrderType) USING `localfs`
((`path`=`asterix_nc1://data/tpch0.001/orders.tbl`),
(`input-format`=`text-input-format`),(`format`=`delimited-text`),(`delimiter`=`|`));
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpch/q12_shipping.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpch/q12_shipping.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpch/q12_shipping.sqlpp
index b1a8cc1..d89ecf7 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpch/q12_shipping.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpch/q12_shipping.sqlpp
@@ -18,8 +18,8 @@
*/
-DROP database tpch IF EXISTS;
-CREATE database tpch;
+DROP dataverse tpch IF EXISTS;
+CREATE dataverse tpch;
USE tpch;
@@ -32,9 +32,9 @@ CREATE TYPE OrderType AS {
o_orderkey : int32
}
-CREATE TABLE LineItem(LineItemType) PRIMARY KEY l_linenumber;
+CREATE DATASET LineItem(LineItemType) PRIMARY KEY l_linenumber;
-CREATE TABLE Orders(OrderType) PRIMARY KEY o_orderkey;
+CREATE DATASET Orders(OrderType) PRIMARY KEY o_orderkey;
/** The plan tests that the expression for different switch-case branches are not extracted.*/
SELECT l.l_shipmode,
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01.sqlpp
index 0faf834..2d375a7 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01.sqlpp
@@ -23,8 +23,8 @@
* Date : 8th May 2014
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -51,7 +51,7 @@ create type test.TweetMessageType as
countB : int32
}
-create table TweetMessages(TweetMessageType) primary key tweetid;
+create dataset TweetMessages(TweetMessageType) primary key tweetid;
create index twmSndLocIx on TweetMessages (`sender-location`) type rtree;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02.sqlpp
index c50e26c..758e84c 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02.sqlpp
@@ -23,8 +23,8 @@
* Date : 8th May 2014
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -51,7 +51,7 @@ create type test.TweetMessageType as
countB : int32
}
-create table TweetMessages(TweetMessageType) primary key tweetid;
+create dataset TweetMessages(TweetMessageType) primary key tweetid;
create index twmSndLocIx on TweetMessages (`sender-location`) type rtree;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_01.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_01.sqlpp
index 7a59a4f..7d521a1 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_01.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_01.sqlpp
@@ -23,8 +23,8 @@
* Date : 11th November 2014
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -35,7 +35,7 @@ create type test.Name as
lname : string
}
-create table Names(Name) primary key fname,lname;
+create dataset Names(Name) primary key fname,lname;
write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-join_01.adm"
select element {'emp1':emp1,'emp2':emp2}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_02.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_02.sqlpp
index f3ccc60..00fa3f1 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_02.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_02.sqlpp
@@ -23,8 +23,8 @@
* Date : 11th November 2014
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -35,7 +35,7 @@ create type test.Name as
lname : string
}
-create table Names(Name) primary key fname,lname;
+create dataset Names(Name) primary key fname,lname;
write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-join_02.adm"
select element {'emp1':emp1,'emp2':emp2}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_03.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_03.sqlpp
index d22a7c8..0ed7290 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_03.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_03.sqlpp
@@ -23,8 +23,8 @@
* Date : 11th November 2014
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -35,7 +35,7 @@ create type test.Name as
lname : string
}
-create table Names(Name) primary key fname,lname;
+create dataset Names(Name) primary key fname,lname;
write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-join_03.adm"
select element {'emp1':emp1,'emp2':emp2}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_01.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_01.sqlpp
index 46d90d0..b068383 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_01.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_01.sqlpp
@@ -23,8 +23,8 @@
* Date : 11th November 2014
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -35,7 +35,7 @@ create type test.Name as
lname : string
}
-create table Names(Name) primary key fname,lname;
+create dataset Names(Name) primary key fname,lname;
write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-prefix-join_01.adm"
select element {'emp1':emp1,'emp2':emp2}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_02.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_02.sqlpp
index 8e33971..0ff28d4 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_02.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_02.sqlpp
@@ -23,8 +23,8 @@
* Date : 11th November 2014
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -35,7 +35,7 @@ create type test.Name as
lname : string
}
-create table Names(Name) primary key fname,lname;
+create dataset Names(Name) primary key fname,lname;
write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-prefix-join_02.adm"
select element {'emp1':emp1,'emp2':emp2}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_03.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_03.sqlpp
index 0b0e816..ee75dbe 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_03.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_03.sqlpp
@@ -23,8 +23,8 @@
* Date : 11th November 2014
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -35,7 +35,7 @@ create type test.Name as
lname : string
}
-create table Names(Name) primary key fname,lname;
+create dataset Names(Name) primary key fname,lname;
write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-prefix-join_03.adm"
select element {'emp1':emp1,'emp2':emp2}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_04.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_04.sqlpp
index 5e3e742..e611b42 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_04.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_04.sqlpp
@@ -23,8 +23,8 @@
* Date : 11th November 2014
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -35,7 +35,7 @@ create type test.Name as
lname : string
}
-create table Names(Name) primary key fname,lname;
+create dataset Names(Name) primary key fname,lname;
write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-prefix-join_04.adm"
select element {'emp1':emp1,'emp2':emp2}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_05.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_05.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_05.sqlpp
index dcc9eae..5762a92 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_05.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_05.sqlpp
@@ -23,8 +23,8 @@
* Date : 11th November 2014
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -35,7 +35,7 @@ create type test.Name as
lname : string
}
-create table Names(Name) primary key fname,lname;
+create dataset Names(Name) primary key fname,lname;
write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-prefix-join_05.adm"
select element {'emp1':emp1,'emp2':emp2}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_06.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_06.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_06.sqlpp
index 2fd29a8..cdac8fc 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_06.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_06.sqlpp
@@ -23,8 +23,8 @@
* Date : 11th November 2014
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -35,7 +35,7 @@ create type test.Name as
lname : string
}
-create table Names(Name) primary key fname,lname;
+create dataset Names(Name) primary key fname,lname;
write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-prefix-join_06.adm"
select element {'emp1':emp1,'emp2':emp2}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-multipred.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-multipred.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-multipred.sqlpp
index 1ec079f..cdbab4f 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-multipred.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-multipred.sqlpp
@@ -25,8 +25,8 @@
* Success : Yes
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -61,9 +61,9 @@ create type test.OrderType as
total : float
}
-create table Customers(CustomerType) primary key cid;
+create dataset Customers(CustomerType) primary key cid;
-create table Orders(OrderType) primary key oid;
+create dataset Orders(OrderType) primary key oid;
write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join-multipred.adm"
select element {'customer':c,'order':o}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-neg_01.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-neg_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-neg_01.sqlpp
index 0e0aced..2631181 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-neg_01.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-neg_01.sqlpp
@@ -23,8 +23,8 @@
* Date : 29th November 2012
*/
-drop database test1 if exists;
-create database test1;
+drop dataverse test1 if exists;
+create dataverse test1;
create type test1.TestType as
{
@@ -34,9 +34,9 @@ create type test1.TestType as
lname : string
}
-create table test1.DsOne(TestType) primary key key1;
+create dataset test1.DsOne(TestType) primary key key1;
-create table test1.DsTwo(TestType) primary key key1;
+create dataset test1.DsTwo(TestType) primary key key1;
write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join-neg_01.adm"
select element x
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-neg_02.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-neg_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-neg_02.sqlpp
index 3185cb1..4b82b6f 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-neg_02.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-neg_02.sqlpp
@@ -23,8 +23,8 @@
* Date : 29th November 2012
*/
-drop database test1 if exists;
-create database test1;
+drop dataverse test1 if exists;
+create dataverse test1;
create type test1.TestType as
{
@@ -34,9 +34,9 @@ create type test1.TestType as
lname : string
}
-create table test1.DsOne(TestType) primary key key1;
+create dataset test1.DsOne(TestType) primary key key1;
-create table test1.DsTwo(TestType) primary key key1;
+create dataset test1.DsTwo(TestType) primary key key1;
write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join-neg_02.adm"
select element x
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_01.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_01.sqlpp
index 1c86572..822774a 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_01.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_01.sqlpp
@@ -23,8 +23,8 @@
* Date : 29th November 2012
*/
-drop database test1 if exists;
-create database test1;
+drop dataverse test1 if exists;
+create dataverse test1;
create type test1.TestType as
{
@@ -34,9 +34,9 @@ create type test1.TestType as
lname : string
}
-create table test1.DsOne(TestType) primary key key1;
+create dataset test1.DsOne(TestType) primary key key1;
-create table test1.DsTwo(TestType) primary key key1;
+create dataset test1.DsTwo(TestType) primary key key1;
write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join_01.adm"
select element x
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_02.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_02.sqlpp
index 5234559..2d5436b 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_02.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_02.sqlpp
@@ -23,8 +23,8 @@
* Date : 29th November 2012
*/
-drop database test1 if exists;
-create database test1;
+drop dataverse test1 if exists;
+create dataverse test1;
create type test1.TestType as
{
@@ -34,9 +34,9 @@ create type test1.TestType as
lname : string
}
-create table test1.DsOne(TestType) primary key key1;
+create dataset test1.DsOne(TestType) primary key key1;
-create table test1.DsTwo(TestType) primary key key1;
+create dataset test1.DsTwo(TestType) primary key key1;
write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join_02.adm"
select element x
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_03.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_03.sqlpp
index 5fe0ab9..9b98317 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_03.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_03.sqlpp
@@ -23,8 +23,8 @@
* Success : Yes
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -59,9 +59,9 @@ create type test.OrderType as
total : float
}
-create table Customers(CustomerType) primary key cid;
+create dataset Customers(CustomerType) primary key cid;
-create table Orders(OrderType) primary key oid;
+create dataset Orders(OrderType) primary key oid;
write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join_04.adm"
select element {'customer':c,'order':o}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_04.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_04.sqlpp
index c3194c8..8731122 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_04.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_04.sqlpp
@@ -23,8 +23,8 @@
* Success : Yes
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -59,9 +59,9 @@ create type test.OrderType as
total : float
}
-create table Customers(CustomerType) primary key cid;
+create dataset Customers(CustomerType) primary key cid;
-create table Orders(OrderType) primary key oid;
+create dataset Orders(OrderType) primary key oid;
write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join_05.adm"
select element {'customer':c,'order':o}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_05.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_05.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_05.sqlpp
index 98dfaef..f8e4dc1 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_05.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_05.sqlpp
@@ -23,8 +23,8 @@
* Success : Yes
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -49,7 +49,7 @@ create type test.CustomerType as
}
-create table Customers(CustomerType) primary key cid;
+create dataset Customers(CustomerType) primary key cid;
write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join_06.adm"
select element {'customer1':c1,'customer2':c2}
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-ge-join_01.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-ge-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-ge-join_01.sqlpp
index 8cfac1a..5dac39c 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-ge-join_01.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-ge-join_01.sqlpp
@@ -23,8 +23,8 @@
* Date : 29th November 2012
*/
-drop database test1 if exists;
-create database test1;
+drop dataverse test1 if exists;
+create dataverse test1;
create type test1.TestType as
{
@@ -34,9 +34,9 @@ create type test1.TestType as
lname : string
}
-create table test1.DsOne(TestType) primary key key1;
+create dataset test1.DsOne(TestType) primary key key1;
-create table test1.DsTwo(TestType) primary key key1;
+create dataset test1.DsTwo(TestType) primary key key1;
write output to asterix_nc1:"rttest/btree-index-join_primary-ge-join_01.adm"
select element x
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-ge-join_02.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-ge-join_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-ge-join_02.sqlpp
index 5db135c..2012048 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-ge-join_02.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-ge-join_02.sqlpp
@@ -23,8 +23,8 @@
* Date : 29th November 2012
*/
-drop database test1 if exists;
-create database test1;
+drop dataverse test1 if exists;
+create dataverse test1;
create type test1.TestType as
{
@@ -34,9 +34,9 @@ create type test1.TestType as
lname : string
}
-create table test1.DsOne(TestType) primary key key1;
+create dataset test1.DsOne(TestType) primary key key1;
-create table test1.DsTwo(TestType) primary key key1;
+create dataset test1.DsTwo(TestType) primary key key1;
write output to asterix_nc1:"rttest/btree-index-join_primary-ge-join_02.adm"
select element x
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-gt-join_01.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-gt-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-gt-join_01.sqlpp
index 007ea56..1ab0ff0 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-gt-join_01.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-gt-join_01.sqlpp
@@ -23,8 +23,8 @@
* Date : 29th November 2012
*/
-drop database test1 if exists;
-create database test1;
+drop dataverse test1 if exists;
+create dataverse test1;
create type test1.TestType as
{
@@ -34,9 +34,9 @@ create type test1.TestType as
lname : string
}
-create table test1.DsOne(TestType) primary key key1;
+create dataset test1.DsOne(TestType) primary key key1;
-create table test1.DsTwo(TestType) primary key key1;
+create dataset test1.DsTwo(TestType) primary key key1;
write output to asterix_nc1:"rttest/btree-index-join_primary-gt-join_01.adm"
select element x
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-gt-join_02.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-gt-join_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-gt-join_02.sqlpp
index 6dda3bf..9e92b48 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-gt-join_02.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-gt-join_02.sqlpp
@@ -23,8 +23,8 @@
* Date : 29th November 2012
*/
-drop database test1 if exists;
-create database test1;
+drop dataverse test1 if exists;
+create dataverse test1;
create type test1.TestType as
{
@@ -34,9 +34,9 @@ create type test1.TestType as
lname : string
}
-create table test1.DsOne(TestType) primary key key1;
+create dataset test1.DsOne(TestType) primary key key1;
-create table test1.DsTwo(TestType) primary key key1;
+create dataset test1.DsTwo(TestType) primary key key1;
write output to asterix_nc1:"rttest/btree-index-join_primary-gt-join_02.adm"
select element x
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-le-join_01.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-le-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-le-join_01.sqlpp
index bdeffa5..1c964c6 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-le-join_01.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-le-join_01.sqlpp
@@ -23,8 +23,8 @@
* Date : 29th November 2012
*/
-drop database test1 if exists;
-create database test1;
+drop dataverse test1 if exists;
+create dataverse test1;
create type test1.TestType as
{
@@ -34,9 +34,9 @@ create type test1.TestType as
lname : string
}
-create table test1.DsOne(TestType) primary key key1;
+create dataset test1.DsOne(TestType) primary key key1;
-create table test1.DsTwo(TestType) primary key key1;
+create dataset test1.DsTwo(TestType) primary key key1;
write output to asterix_nc1:"rttest/btree-index-join_primary-le-join_01.adm"
select element x
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-le-join_02.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-le-join_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-le-join_02.sqlpp
index 5174cd2..9a28a54 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-le-join_02.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-le-join_02.sqlpp
@@ -23,8 +23,8 @@
* Date : 29th November 2012
*/
-drop database test1 if exists;
-create database test1;
+drop dataverse test1 if exists;
+create dataverse test1;
create type test1.TestType as
{
@@ -34,9 +34,9 @@ create type test1.TestType as
lname : string
}
-create table test1.DsOne(TestType) primary key key1;
+create dataset test1.DsOne(TestType) primary key key1;
-create table test1.DsTwo(TestType) primary key key1;
+create dataset test1.DsTwo(TestType) primary key key1;
write output to asterix_nc1:"rttest/btree-index-join_primary-le-join_02.adm"
select element x
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-lt-join_01.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-lt-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-lt-join_01.sqlpp
index 516e0f4..927854d 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-lt-join_01.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-lt-join_01.sqlpp
@@ -23,8 +23,8 @@
* Date : 29th November 2012
*/
-drop database test1 if exists;
-create database test1;
+drop dataverse test1 if exists;
+create dataverse test1;
create type test1.TestType as
{
@@ -34,9 +34,9 @@ create type test1.TestType as
lname : string
}
-create table test1.DsOne(TestType) primary key key1;
+create dataset test1.DsOne(TestType) primary key key1;
-create table test1.DsTwo(TestType) primary key key1;
+create dataset test1.DsTwo(TestType) primary key key1;
write output to asterix_nc1:"rttest/btree-index-join_primary-lt-join_01.adm"
select element x
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-lt-join_02.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-lt-join_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-lt-join_02.sqlpp
index bba21b0..d94c653 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-lt-join_02.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-lt-join_02.sqlpp
@@ -23,8 +23,8 @@
* Date : 29th November 2012
*/
-drop database test1 if exists;
-create database test1;
+drop dataverse test1 if exists;
+create dataverse test1;
create type test1.TestType as
{
@@ -34,9 +34,9 @@ create type test1.TestType as
lname : string
}
-create table test1.DsOne(TestType) primary key key1;
+create dataset test1.DsOne(TestType) primary key key1;
-create table test1.DsTwo(TestType) primary key key1;
+create dataset test1.DsTwo(TestType) primary key key1;
write output to asterix_nc1:"rttest/btree-index-join_primary-lt-join_02.adm"
select element x
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join-multiindex.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join-multiindex.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join-multiindex.sqlpp
index 625ee1a..43d7843 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join-multiindex.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join-multiindex.sqlpp
@@ -25,8 +25,8 @@
* Success : Yes
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -61,9 +61,9 @@ create type test.FacebookMessageType as
message : string
}
-create table FacebookUsers(FacebookUserType) primary key id;
+create dataset FacebookUsers(FacebookUserType) primary key id;
-create table FacebookMessages(FacebookMessageType) primary key `message-id`;
+create dataset FacebookMessages(FacebookMessageType) primary key `message-id`;
create index fbmIdxAutId if not exists on FacebookMessages (`author-id-copy`) type btree;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join-multipred.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join-multipred.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join-multipred.sqlpp
index a20d6c5..4972185 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join-multipred.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join-multipred.sqlpp
@@ -25,8 +25,8 @@
* Success : Yes
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -49,9 +49,9 @@ create type test.CSXType as
misc : string
}
-create table DBLP(DBLPType) primary key id;
+create dataset DBLP(DBLPType) primary key id;
-create table CSX(CSXType) primary key id;
+create dataset CSX(CSXType) primary key id;
create index title_index on DBLP (title) type btree;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join_01.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join_01.sqlpp
index 800c22a..1205b85 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join_01.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join_01.sqlpp
@@ -23,8 +23,8 @@
* Success : Yes
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -47,9 +47,9 @@ create type test.CSXType as
misc : string
}
-create table DBLP(DBLPType) primary key id;
+create dataset DBLP(DBLPType) primary key id;
-create table CSX(CSXType) primary key id;
+create dataset CSX(CSXType) primary key id;
create index title_index on DBLP (title) type btree;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join_02.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join_02.sqlpp
index ac7c1c0..82bf7b9 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join_02.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join_02.sqlpp
@@ -23,8 +23,8 @@
* Success : Yes
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -47,9 +47,9 @@ create type test.CSXType as
misc : string
}
-create table DBLP(DBLPType) primary key id;
+create dataset DBLP(DBLPType) primary key id;
-create table CSX(CSXType) primary key id;
+create dataset CSX(CSXType) primary key id;
create index title_index on CSX (title) type btree;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join_03.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join_03.sqlpp
index 1313e86..15e152e 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join_03.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join_03.sqlpp
@@ -23,8 +23,8 @@
* Success : Yes
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -38,7 +38,7 @@ create type test.DBLPType as
misc : string
}
-create table DBLP(DBLPType) primary key id;
+create dataset DBLP(DBLPType) primary key id;
create index title_index on DBLP (title) type btree;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-datetime-01.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-datetime-01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-datetime-01.sqlpp
index 31b4371..67c3f96 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-datetime-01.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-datetime-01.sqlpp
@@ -24,8 +24,8 @@
* Author : Steven Jacobs
*/
-drop database emergencyTest if exists;
-create database emergencyTest;
+drop dataverse emergencyTest if exists;
+create dataverse emergencyTest;
use emergencyTest;
@@ -38,7 +38,7 @@ create type emergencyTest.CHPReport as
message : string
}
-create table CHPReports(CHPReport) primary key timestamp;
+create dataset CHPReports(CHPReport) primary key timestamp;
select element emergency.message
from CHPReports as emergency
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-datetime-02.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-datetime-02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-datetime-02.sqlpp
index 10a1a71..d4b1f1f 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-datetime-02.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-datetime-02.sqlpp
@@ -24,8 +24,8 @@
* Author : Steven Jacobs
*/
-drop database emergencyTest if exists;
-create database emergencyTest;
+drop dataverse emergencyTest if exists;
+create dataverse emergencyTest;
use emergencyTest;
@@ -38,7 +38,7 @@ create type emergencyTest.CHPReport as
message : string
}
-create table CHPReports(CHPReport) primary key timestamp;
+create dataset CHPReports(CHPReport) primary key timestamp;
select element emergency
from CHPReports as emergency
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-datetime-03.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-datetime-03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-datetime-03.sqlpp
index e8dd611..8ba011b 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-datetime-03.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-datetime-03.sqlpp
@@ -24,8 +24,8 @@
* Author : Steven Jacobs
*/
-drop database emergencyTest if exists;
-create database emergencyTest;
+drop dataverse emergencyTest if exists;
+create dataverse emergencyTest;
use emergencyTest;
@@ -38,7 +38,7 @@ create type emergencyTest.CHPReport as
message : string
}
-create table CHPReports(CHPReport) primary key timestamp;
+create dataset CHPReports(CHPReport) primary key timestamp;
select element emergency
from CHPReports as emergency
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-datetime-04.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-datetime-04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-datetime-04.sqlpp
index 5f3876f..dc7fab2 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-datetime-04.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-datetime-04.sqlpp
@@ -23,8 +23,8 @@
* Author : Steven Jacobs
*/
-drop database emergencyTest if exists;
-create database emergencyTest;
+drop dataverse emergencyTest if exists;
+create dataverse emergencyTest;
use emergencyTest;
@@ -37,7 +37,7 @@ create type emergencyTest.CHPReport as
message : string
}
-create table CHPReports(CHPReport) primary key id;
+create dataset CHPReports(CHPReport) primary key id;
select element emergency
from CHPReports as emergency
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-01.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-01.sqlpp
index a8566d0..ff74d80 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-01.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-01.sqlpp
@@ -23,8 +23,8 @@
* Date : 13th Aug 2012
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -36,7 +36,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname,lname;
+create dataset testdst(TestType) primary key fname,lname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-02.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-02.sqlpp
index cd88461..e01e004 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-02.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-02.sqlpp
@@ -23,8 +23,8 @@
* Date : 13th Aug 2012
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -36,7 +36,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname,lname;
+create dataset testdst(TestType) primary key fname,lname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-03.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-03.sqlpp
index fe14eb4..65669d6 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-03.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-03.sqlpp
@@ -23,8 +23,8 @@
* Date : 13th Aug 2012
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -36,7 +36,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname,lname;
+create dataset testdst(TestType) primary key fname,lname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-04.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-04.sqlpp
index cbe71d5..99cd613 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-04.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-04.sqlpp
@@ -23,8 +23,8 @@
* Date : 13th Aug 2012
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -36,7 +36,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname,lname;
+create dataset testdst(TestType) primary key fname,lname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-05.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-05.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-05.sqlpp
index 79072d8..ca375fa 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-05.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-05.sqlpp
@@ -23,8 +23,8 @@
* Date : 13th Aug 2012
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -36,7 +36,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname,lname;
+create dataset testdst(TestType) primary key fname,lname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-06.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-06.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-06.sqlpp
index fe344ba..197fbbc 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-06.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-06.sqlpp
@@ -23,8 +23,8 @@
* Date : 13th Aug 2012
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -36,7 +36,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname,lname;
+create dataset testdst(TestType) primary key fname,lname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-07.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-07.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-07.sqlpp
index 525924f..8527a3e 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-07.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-07.sqlpp
@@ -23,8 +23,8 @@
* Date : 13th Aug 2012
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -36,7 +36,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname,lname;
+create dataset testdst(TestType) primary key fname,lname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-08.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-08.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-08.sqlpp
index 54a0da7..62609e5 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-08.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-08.sqlpp
@@ -22,8 +22,8 @@
* Date : 13th Aug 2012
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -35,7 +35,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname,lname;
+create dataset testdst(TestType) primary key fname,lname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-09.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-09.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-09.sqlpp
index 553c3cf..5832ec4 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-09.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-09.sqlpp
@@ -24,8 +24,8 @@
* Date : 13th Aug 2012
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -37,7 +37,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname,lname;
+create dataset testdst(TestType) primary key fname,lname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-10.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-10.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-10.sqlpp
index 55a8553..0341553 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-10.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-10.sqlpp
@@ -24,8 +24,8 @@
* Date : 13th Aug 2012
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -37,7 +37,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname,lname;
+create dataset testdst(TestType) primary key fname,lname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-11.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-11.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-11.sqlpp
index 83edfdd..8b1f1f3 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-11.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-11.sqlpp
@@ -24,8 +24,8 @@
* Date : 13th Aug 2012
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -37,7 +37,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname,lname;
+create dataset testdst(TestType) primary key fname,lname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-12.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-12.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-12.sqlpp
index 463763d..c48329e 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-12.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-12.sqlpp
@@ -24,8 +24,8 @@
* Date : 13th Aug 2012
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -37,7 +37,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname,lname;
+create dataset testdst(TestType) primary key fname,lname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-13.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-13.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-13.sqlpp
index 70290cd..45d56e9 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-13.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-13.sqlpp
@@ -24,8 +24,8 @@
* Date : 13th Aug 2012
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -37,7 +37,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname,lname;
+create dataset testdst(TestType) primary key fname,lname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-14.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-14.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-14.sqlpp
index 076a3a6..eba848e 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-14.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-14.sqlpp
@@ -24,8 +24,8 @@
* Date : 13th Aug 2012
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -37,7 +37,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname,lname;
+create dataset testdst(TestType) primary key fname,lname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-15.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-15.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-15.sqlpp
index ba83524..71f291d 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-15.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-15.sqlpp
@@ -24,8 +24,8 @@
* Date : 13th Aug 2012
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -37,7 +37,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname,lname;
+create dataset testdst(TestType) primary key fname,lname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-16.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-16.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-16.sqlpp
index 49a5f74..3403716 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-16.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-16.sqlpp
@@ -24,8 +24,8 @@
* Date : 13th Aug 2012
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -37,7 +37,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname,lname;
+create dataset testdst(TestType) primary key fname,lname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-17.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-17.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-17.sqlpp
index 2c9730c..4442669 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-17.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-17.sqlpp
@@ -24,8 +24,8 @@
* Date : 13th Aug 2012
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -37,7 +37,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname,lname;
+create dataset testdst(TestType) primary key fname,lname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-18.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-18.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-18.sqlpp
index 39c773c..149b68c 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-18.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-18.sqlpp
@@ -24,8 +24,8 @@
* Date : 13th Aug 2012
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -37,7 +37,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname,lname;
+create dataset testdst(TestType) primary key fname,lname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-19.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-19.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-19.sqlpp
index 2a87181..a30e6c5 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-19.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-19.sqlpp
@@ -24,8 +24,8 @@
* Date : 13th Aug 2012
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -37,7 +37,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname,lname;
+create dataset testdst(TestType) primary key fname,lname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-20.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-20.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-20.sqlpp
index 4d25a88..3e1eb98 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-20.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-20.sqlpp
@@ -24,8 +24,8 @@
* Date : 13th Aug 2012
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -37,7 +37,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname,lname;
+create dataset testdst(TestType) primary key fname,lname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-21.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-21.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-21.sqlpp
index d8561e3..a37b0dc 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-21.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-21.sqlpp
@@ -24,8 +24,8 @@
* Date : 13th Aug 2012
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -37,7 +37,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname;
+create dataset testdst(TestType) primary key fname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-22.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-22.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-22.sqlpp
index e886317..e9228b8 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-22.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-22.sqlpp
@@ -24,8 +24,8 @@
* Date : 13th Aug 2012
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -37,7 +37,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname;
+create dataset testdst(TestType) primary key fname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-23.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-23.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-23.sqlpp
index 98de9b6..0373513 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-23.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-23.sqlpp
@@ -24,8 +24,8 @@
* Date : 13th Aug 2012
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -37,7 +37,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname;
+create dataset testdst(TestType) primary key fname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-24.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-24.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-24.sqlpp
index bec9ebc..43f65c4 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-24.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-24.sqlpp
@@ -24,8 +24,8 @@
* Date : 13th Aug 2012
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -37,7 +37,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname;
+create dataset testdst(TestType) primary key fname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-25.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-25.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-25.sqlpp
index 9edde6e..c2e881e 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-25.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-25.sqlpp
@@ -24,8 +24,8 @@
* Date : 13th Aug 2012
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -37,7 +37,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname;
+create dataset testdst(TestType) primary key fname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-26.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-26.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-26.sqlpp
index a9a2b87..0e9aaf0 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-26.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-26.sqlpp
@@ -24,8 +24,8 @@
* Date : 13th Aug 2012
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -37,7 +37,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname;
+create dataset testdst(TestType) primary key fname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-27.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-27.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-27.sqlpp
index e3310b8..8a7e358 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-27.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-27.sqlpp
@@ -24,8 +24,8 @@
* Date : 5th Feb 2013
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -37,7 +37,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname,lname;
+create dataset testdst(TestType) primary key fname,lname;
select element emp
from testdst as emp
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d56ff03f/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-28.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-28.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-28.sqlpp
index 48af12c..0e036ba 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-28.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index/btree-primary-28.sqlpp
@@ -24,8 +24,8 @@
* Date : 5th Feb 2013
*/
-drop database test if exists;
-create database test;
+drop dataverse test if exists;
+create dataverse test;
use test;
@@ -37,7 +37,7 @@ create type test.TestType as
lname : string
}
-create table testdst(TestType) primary key fname,lname;
+create dataset testdst(TestType) primary key fname,lname;
select element emp
from testdst as emp