You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by jc...@apache.org on 2018/05/25 00:58:09 UTC
[37/58] [abbrv] [partial] hive git commit: HIVE-19617: Rename test
tables to avoid collisions during execution in batches (Jesus Camacho
Rodriguez, reviewed by Gunther Hagleitner)
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/enforce_constraint_notnull.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/enforce_constraint_notnull.q b/ql/src/test/queries/clientpositive/enforce_constraint_notnull.q
index 2aa4665..e7d031b 100644
--- a/ql/src/test/queries/clientpositive/enforce_constraint_notnull.q
+++ b/ql/src/test/queries/clientpositive/enforce_constraint_notnull.q
@@ -1,108 +1,108 @@
-- SIMPLE TABLE
-- create table with first and last column with not null
-CREATE TABLE table1 (a STRING NOT NULL ENFORCED, b STRING, c STRING NOT NULL ENFORCED);
+CREATE TABLE table1_n7 (a STRING NOT NULL ENFORCED, b STRING, c STRING NOT NULL ENFORCED);
-- insert value tuples
-explain INSERT INTO table1 values('not', 'null', 'constraint');
-INSERT INTO table1 values('not', 'null', 'constraint');
-SELECT * FROM table1;
+explain INSERT INTO table1_n7 values('not', 'null', 'constraint');
+INSERT INTO table1_n7 values('not', 'null', 'constraint');
+SELECT * FROM table1_n7;
-- insert with column specified
-explain insert into table1(a,c) values('1','2');
-insert into table1(a,c) values('1','2');
+explain insert into table1_n7(a,c) values('1','2');
+insert into table1_n7(a,c) values('1','2');
-- insert from select
-explain INSERT INTO table1 select key, src.value, value from src;
-INSERT INTO table1 select key, src.value, value from src;
-SELECT * FROM table1;
+explain INSERT INTO table1_n7 select key, src.value, value from src;
+INSERT INTO table1_n7 select key, src.value, value from src;
+SELECT * FROM table1_n7;
-- insert overwrite
-explain INSERT OVERWRITE TABLE table1 select src.*, value from src;
-INSERT OVERWRITE TABLE table1 select src.*, value from src;
-SELECT * FROM table1;
+explain INSERT OVERWRITE TABLE table1_n7 select src.*, value from src;
+INSERT OVERWRITE TABLE table1_n7 select src.*, value from src;
+SELECT * FROM table1_n7;
-- insert overwrite with if not exists
-explain INSERT OVERWRITE TABLE table1 if not exists select src.key, src.key, src.value from src;
-INSERT OVERWRITE TABLE table1 if not exists select src.key, src.key, src.value from src;
-SELECT * FROM table1;
+explain INSERT OVERWRITE TABLE table1_n7 if not exists select src.key, src.key, src.value from src;
+INSERT OVERWRITE TABLE table1_n7 if not exists select src.key, src.key, src.value from src;
+SELECT * FROM table1_n7;
-DROP TABLE table1;
+DROP TABLE table1_n7;
-- multi insert
-create table src_multi1 (a STRING NOT NULL ENFORCED, b STRING);
-create table src_multi2 (i STRING, j STRING NOT NULL ENABLE);
+create table src_multi1_n0 (a STRING NOT NULL ENFORCED, b STRING);
+create table src_multi2_n1 (i STRING, j STRING NOT NULL ENABLE);
explain
from src
-insert overwrite table src_multi1 select * where key < 10
-insert overwrite table src_multi2 select * where key > 10 and key < 20;
+insert overwrite table src_multi1_n0 select * where key < 10
+insert overwrite table src_multi2_n1 select * where key > 10 and key < 20;
from src
-insert overwrite table src_multi1 select * where key < 10
-insert overwrite table src_multi2 select * where key > 10 and key < 20;
+insert overwrite table src_multi1_n0 select * where key < 10
+insert overwrite table src_multi2_n1 select * where key > 10 and key < 20;
explain
from src
-insert into table src_multi1 select * where src.key < 10
-insert into table src_multi2 select src.* where key > 10 and key < 20;
+insert into table src_multi1_n0 select * where src.key < 10
+insert into table src_multi2_n1 select src.* where key > 10 and key < 20;
from src
-insert into table src_multi1 select * where src.key < 10
-insert into table src_multi2 select src.* where key > 10 and key < 20;
+insert into table src_multi1_n0 select * where src.key < 10
+insert into table src_multi2_n1 select src.* where key > 10 and key < 20;
-- ACID TABLE
set hive.support.concurrency=true;
set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
-- SORT_QUERY_RESULTS
-create table acid_uami(i int,
+create table acid_uami_n1(i int,
de decimal(5,2) constraint nn1 not null enforced,
vc varchar(128) constraint nn2 not null enforced) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true');
-- insert into values
-explain insert into table acid_uami values
+explain insert into table acid_uami_n1 values
(1, 109.23, 'mary had a little lamb'),
(6553, 923.19, 'its fleece was white as snow');
-insert into table acid_uami values
+insert into table acid_uami_n1 values
(1, 109.23, 'mary had a little lamb'),
(6553, 923.19, 'its fleece was white as snow');
-select * from acid_uami;
+select * from acid_uami_n1;
--insert into select
-explain insert into table acid_uami select cast(key as int), cast (key as decimal(5,2)), value from src;
-insert into table acid_uami select cast(key as int), cast (key as decimal(5,2)), value from src;
+explain insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src;
+insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src;
-- select with limit
-explain insert into table acid_uami select cast(key as int), cast (key as decimal(5,2)), value from src limit 2;
+explain insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src limit 2;
-- select with order by
-explain insert into table acid_uami select cast(key as int), cast (key as decimal(5,2)), value from src
+explain insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src
order by key limit 2;
-- select with group by
-explain insert into table acid_uami select cast(key as int), cast (key as decimal(5,2)), value from src
+explain insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src
group by key, value order by key limit 2;
--overwrite
-explain insert into table acid_uami select cast(key as int), cast (key as decimal(5,2)), value from src;
-insert into table acid_uami select cast(key as int), cast (key as decimal(5,2)), value from src;
+explain insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src;
+insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src;
-- update
-explain update acid_uami set de = 3.14 where de = 109.23 or de = 119.23;
-update acid_uami set de = 3.14 where de = 109.23 or de = 119.23;
+explain update acid_uami_n1 set de = 3.14 where de = 109.23 or de = 119.23;
+update acid_uami_n1 set de = 3.14 where de = 109.23 or de = 119.23;
-ALTER table acid_uami drop constraint nn1;
-ALTER table acid_uami CHANGE i i int constraint nn0 not null enforced;
+ALTER table acid_uami_n1 drop constraint nn1;
+ALTER table acid_uami_n1 CHANGE i i int constraint nn0 not null enforced;
-explain update acid_uami set de = 3.14159 where de = 3.14 ;
-update acid_uami set de = 3.14159 where de = 3.14 ;
+explain update acid_uami_n1 set de = 3.14159 where de = 3.14 ;
+update acid_uami_n1 set de = 3.14159 where de = 3.14 ;
-- multi insert
explain
from src
-insert overwrite table acid_uami select cast(key as int), cast(key as decimal(5,2)), value where key < 10
-insert overwrite table src_multi2 select * where key > 10 and key < 20;
+insert overwrite table acid_uami_n1 select cast(key as int), cast(key as decimal(5,2)), value where key < 10
+insert overwrite table src_multi2_n1 select * where key > 10 and key < 20;
set hive.exec.dynamic.partition.mode=nonstrict;
-- Table with partition
@@ -123,58 +123,58 @@ select * from tablePartitioned;
explain
from src
INSERT INTO tablePartitioned partition(p1, p2) select key, value, value, 'yesterday' as p1, 3 as p2
-insert overwrite table src_multi2 select * where key > 10 and key < 20;
+insert overwrite table src_multi2_n1 select * where key > 10 and key < 20;
-DROP TABLE src_multi1;
-DROP TABLE src_multi2;
-DROP TABLE acid_uami;
+DROP TABLE src_multi1_n0;
+DROP TABLE src_multi2_n1;
+DROP TABLE acid_uami_n1;
-- MERGE statements
set hive.mapred.mode=nonstrict;
set hive.support.concurrency=true;
set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
-create table nonacid (key int, a1 string, value string) stored as orc;
+create table nonacid_n2 (key int, a1 string, value string) stored as orc;
-create table masking_test (key int NOT NULL enable, a1 string, value string)
+create table masking_test_n4 (key int NOT NULL enable, a1 string, value string)
clustered by (value) into 2 buckets stored as orc
tblproperties ("transactional"="true");
-- with cardinality check off
set hive.merge.cardinality.check=false;
-explain MERGE INTO masking_test as t using nonacid as s ON t.key = s.key
+explain MERGE INTO masking_test_n4 as t using nonacid_n2 as s ON t.key = s.key
WHEN MATCHED AND s.key < 5 THEN DELETE
WHEN MATCHED AND s.key < 3 THEN UPDATE set a1 = '1'
WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value);
-- with cardinality check on
set hive.merge.cardinality.check=true;
-explain MERGE INTO masking_test as t using nonacid as s ON t.key = s.key
+explain MERGE INTO masking_test_n4 as t using nonacid_n2 as s ON t.key = s.key
WHEN MATCHED AND s.key < 5 THEN DELETE
WHEN MATCHED AND s.key < 3 THEN UPDATE set a1 = '1'
WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value);
-explain MERGE INTO masking_test as t using nonacid as s ON t.key = s.key
+explain MERGE INTO masking_test_n4 as t using nonacid_n2 as s ON t.key = s.key
WHEN MATCHED AND s.key < 5 THEN DELETE
WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value);
-explain MERGE INTO masking_test as t using nonacid as s ON t.key = s.key
+explain MERGE INTO masking_test_n4 as t using nonacid_n2 as s ON t.key = s.key
WHEN MATCHED AND s.key < 3 THEN UPDATE set a1 = '1'
WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value);
-- shouldn't have constraint enforcement
-explain MERGE INTO masking_test as t using nonacid as s ON t.key = s.key
+explain MERGE INTO masking_test_n4 as t using nonacid_n2 as s ON t.key = s.key
WHEN MATCHED AND s.key < 5 THEN DELETE;
-DROP TABLE masking_test;
-DROP TABLE nonacid;
+DROP TABLE masking_test_n4;
+DROP TABLE nonacid_n2;
-- Test drop constraint
-create table table2(i int constraint nn5 not null enforced, j int);
-explain insert into table2 values(2, 3);
-alter table table2 drop constraint nn5;
-explain insert into table2 values(2, 3);
-DROP TABLE table2;
+create table table2_n3(i int constraint nn5 not null enforced, j int);
+explain insert into table2_n3 values(2, 3);
+alter table table2_n3 drop constraint nn5;
+explain insert into table2_n3 values(2, 3);
+DROP TABLE table2_n3;
-- temporary table
create temporary table tttemp(i int not null enforced);
@@ -187,10 +187,10 @@ set hive.create.as.insert.only=true;
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.support.concurrency=true;
set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
-create table part_mm(key int not null enforced) partitioned by (key_mm int) stored as orc tblproperties ("transactional"="true", "transactional_properties"="insert_only");
-explain insert into table part_mm partition(key_mm=455) select key from src order by value limit 3;
-insert into table part_mm partition(key_mm=455) select key from src order by value limit 3;
+create table part_mm_n1(key int not null enforced) partitioned by (key_mm int) stored as orc tblproperties ("transactional"="true", "transactional_properties"="insert_only");
+explain insert into table part_mm_n1 partition(key_mm=455) select key from src order by value limit 3;
+insert into table part_mm_n1 partition(key_mm=455) select key from src order by value limit 3;
select key from src order by value limit 3;
-select * from part_mm;
-drop table part_mm;
+select * from part_mm_n1;
+drop table part_mm_n1;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/escape1.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/escape1.q b/ql/src/test/queries/clientpositive/escape1.q
index ac499e3..668df2c 100644
--- a/ql/src/test/queries/clientpositive/escape1.q
+++ b/ql/src/test/queries/clientpositive/escape1.q
@@ -4,17 +4,17 @@ set hive.exec.dynamic.partition=true;
set hive.exec.max.dynamic.partitions.pernode=200;
DROP TABLE escape1;
-DROP TABLE escape_raw;
+DROP TABLE escape_raw_n0;
-CREATE TABLE escape_raw (s STRING) STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../../data/files/escapetest.txt' INTO TABLE escape_raw;
+CREATE TABLE escape_raw_n0 (s STRING) STORED AS TEXTFILE;
+LOAD DATA LOCAL INPATH '../../data/files/escapetest.txt' INTO TABLE escape_raw_n0;
-SELECT count(*) from escape_raw;
-SELECT * from escape_raw;
+SELECT count(*) from escape_raw_n0;
+SELECT * from escape_raw_n0;
CREATE TABLE escape1 (a STRING) PARTITIONED BY (ds STRING, part STRING);
INSERT OVERWRITE TABLE escape1 PARTITION (ds='1', part) SELECT '1', s from
-escape_raw;
+escape_raw_n0;
SELECT count(*) from escape1;
SELECT * from escape1;
@@ -24,4 +24,4 @@ ALTER TABLE escape1 DROP PARTITION (ds='1');
SHOW PARTITIONS escape1;
DROP TABLE escape1;
-DROP TABLE escape_raw;
+DROP TABLE escape_raw_n0;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/escape_crlf.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/escape_crlf.q b/ql/src/test/queries/clientpositive/escape_crlf.q
index 46c3605..0b7b77c 100644
--- a/ql/src/test/queries/clientpositive/escape_crlf.q
+++ b/ql/src/test/queries/clientpositive/escape_crlf.q
@@ -2,22 +2,22 @@
set hive.vectorized.execution.enabled=false;
set hive.test.vectorized.execution.enabled.override=disable;
-DROP TABLE IF EXISTS base_tab;
-CREATE TABLE base_tab(a STRING, b STRING)
+DROP TABLE IF EXISTS base_tab_n0;
+CREATE TABLE base_tab_n0(a STRING, b STRING)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '|';
-DESCRIBE EXTENDED base_tab;
+DESCRIBE EXTENDED base_tab_n0;
-LOAD DATA LOCAL INPATH '../../data/files/escape_crlf.txt' OVERWRITE INTO TABLE base_tab;
+LOAD DATA LOCAL INPATH '../../data/files/escape_crlf.txt' OVERWRITE INTO TABLE base_tab_n0;
-- No crlf escaping
-SELECT * FROM base_tab;
+SELECT * FROM base_tab_n0;
-- Crlf escaping
-ALTER TABLE base_tab SET SERDEPROPERTIES ('escape.delim'='\\', 'serialization.escape.crlf'='true');
-SELECT * FROM base_tab;
+ALTER TABLE base_tab_n0 SET SERDEPROPERTIES ('escape.delim'='\\', 'serialization.escape.crlf'='true');
+SELECT * FROM base_tab_n0;
SET hive.fetch.task.conversion=none;
-- Make sure intermediate serde works correctly
-SELECT * FROM base_tab;
+SELECT * FROM base_tab_n0;
-DROP TABLE base_tab;
+DROP TABLE base_tab_n0;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/except_all.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/except_all.q b/ql/src/test/queries/clientpositive/except_all.q
index 3b62459..65829cf 100644
--- a/ql/src/test/queries/clientpositive/except_all.q
+++ b/ql/src/test/queries/clientpositive/except_all.q
@@ -1,49 +1,49 @@
set hive.mapred.mode=nonstrict;
set hive.cbo.enable=true;
-create table a(key int);
+create table a_n15(key int);
-insert into table a values (0),(1),(2),(2),(2),(2),(3),(NULL),(NULL);
+insert into table a_n15 values (0),(1),(2),(2),(2),(2),(3),(NULL),(NULL);
-create table b(key bigint);
+create table b_n11(key bigint);
-insert into table b values (1),(2),(2),(3),(5),(5),(NULL),(NULL),(NULL);
+insert into table b_n11 values (1),(2),(2),(3),(5),(5),(NULL),(NULL),(NULL);
-select * from a except all select * from b;
+select * from a_n15 except all select * from b_n11;
-drop table a;
+drop table a_n15;
-drop table b;
+drop table b_n11;
-create table a(key int, value int);
+create table a_n15(key int, value int);
-insert into table a values (1,2),(1,2),(1,3),(2,3),(2,2);
+insert into table a_n15 values (1,2),(1,2),(1,3),(2,3),(2,2);
-create table b(key int, value int);
+create table b_n11(key int, value int);
-insert into table b values (1,2),(2,3),(2,2),(2,2),(2,20);
+insert into table b_n11 values (1,2),(2,3),(2,2),(2,2),(2,20);
-select * from a except all select * from b;
+select * from a_n15 except all select * from b_n11;
-select * from b except all select * from a;
+select * from b_n11 except all select * from a_n15;
-select * from b except all select * from a intersect distinct select * from b;
+select * from b_n11 except all select * from a_n15 intersect distinct select * from b_n11;
-select * from b except all select * from a except distinct select * from b;
+select * from b_n11 except all select * from a_n15 except distinct select * from b_n11;
-select * from a except all select * from b union all select * from a except distinct select * from b;
+select * from a_n15 except all select * from b_n11 union all select * from a_n15 except distinct select * from b_n11;
-select * from a except all select * from b union select * from a except distinct select * from b;
+select * from a_n15 except all select * from b_n11 union select * from a_n15 except distinct select * from b_n11;
-select * from a except all select * from b except distinct select * from a except distinct select * from b;
+select * from a_n15 except all select * from b_n11 except distinct select * from a_n15 except distinct select * from b_n11;
-select * from (select a.key, b.value from a join b on a.key=b.key)sub1
+select * from (select a_n15.key, b_n11.value from a_n15 join b_n11 on a_n15.key=b_n11.key)sub1
except all
-select * from (select a.key, b.value from a join b on a.key=b.key)sub2;
+select * from (select a_n15.key, b_n11.value from a_n15 join b_n11 on a_n15.key=b_n11.key)sub2;
-select * from (select a.key, b.value from a join b on a.key=b.key)sub1
+select * from (select a_n15.key, b_n11.value from a_n15 join b_n11 on a_n15.key=b_n11.key)sub1
except all
-select * from (select b.value as key, a.key as value from a join b on a.key=b.key)sub2;
+select * from (select b_n11.value as key, a_n15.key as value from a_n15 join b_n11 on a_n15.key=b_n11.key)sub2;
explain select * from src except all select * from src;
@@ -53,6 +53,6 @@ explain select * from src except all select * from src except distinct select *
select * from src except all select * from src except distinct select * from src except distinct select * from src;
-explain select value from a group by value except distinct select key from b group by key;
+explain select value from a_n15 group by value except distinct select key from b_n11 group by key;
-select value from a group by value except distinct select key from b group by key;
+select value from a_n15 group by value except distinct select key from b_n11 group by key;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/except_distinct.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/except_distinct.q b/ql/src/test/queries/clientpositive/except_distinct.q
index 9991447..b5e7e6e 100644
--- a/ql/src/test/queries/clientpositive/except_distinct.q
+++ b/ql/src/test/queries/clientpositive/except_distinct.q
@@ -1,49 +1,49 @@
set hive.mapred.mode=nonstrict;
set hive.cbo.enable=true;
-create table a(key int);
+create table a_n16(key int);
-insert into table a values (0),(1),(2),(2),(2),(2),(3),(NULL),(NULL);
+insert into table a_n16 values (0),(1),(2),(2),(2),(2),(3),(NULL),(NULL);
-create table b(key bigint);
+create table b_n12(key bigint);
-insert into table b values (1),(2),(2),(3),(5),(5),(NULL),(NULL),(NULL);
+insert into table b_n12 values (1),(2),(2),(3),(5),(5),(NULL),(NULL),(NULL);
-select * from a except distinct select * from b;
+select * from a_n16 except distinct select * from b_n12;
-drop table a;
+drop table a_n16;
-drop table b;
+drop table b_n12;
-create table a(key int, value int);
+create table a_n16(key int, value int);
-insert into table a values (1,2),(1,2),(1,3),(2,3),(2,2);
+insert into table a_n16 values (1,2),(1,2),(1,3),(2,3),(2,2);
-create table b(key int, value int);
+create table b_n12(key int, value int);
-insert into table b values (1,2),(2,3),(2,2),(2,2),(2,20);
+insert into table b_n12 values (1,2),(2,3),(2,2),(2,2),(2,20);
-select * from a except distinct select * from b;
+select * from a_n16 except distinct select * from b_n12;
-select * from b except distinct select * from a;
+select * from b_n12 except distinct select * from a_n16;
-select * from b except distinct select * from a intersect distinct select * from b;
+select * from b_n12 except distinct select * from a_n16 intersect distinct select * from b_n12;
-select * from b except distinct select * from a except distinct select * from b;
+select * from b_n12 except distinct select * from a_n16 except distinct select * from b_n12;
-select * from a except distinct select * from b union all select * from a except distinct select * from b;
+select * from a_n16 except distinct select * from b_n12 union all select * from a_n16 except distinct select * from b_n12;
-select * from a except distinct select * from b union select * from a except distinct select * from b;
+select * from a_n16 except distinct select * from b_n12 union select * from a_n16 except distinct select * from b_n12;
-select * from a except distinct select * from b except distinct select * from a except distinct select * from b;
+select * from a_n16 except distinct select * from b_n12 except distinct select * from a_n16 except distinct select * from b_n12;
-select * from (select a.key, b.value from a join b on a.key=b.key)sub1
+select * from (select a_n16.key, b_n12.value from a_n16 join b_n12 on a_n16.key=b_n12.key)sub1
except distinct
-select * from (select a.key, b.value from a join b on a.key=b.key)sub2;
+select * from (select a_n16.key, b_n12.value from a_n16 join b_n12 on a_n16.key=b_n12.key)sub2;
-select * from (select a.key, b.value from a join b on a.key=b.key)sub1
+select * from (select a_n16.key, b_n12.value from a_n16 join b_n12 on a_n16.key=b_n12.key)sub1
except distinct
-select * from (select b.value as key, a.key as value from a join b on a.key=b.key)sub2;
+select * from (select b_n12.value as key, a_n16.key as value from a_n16 join b_n12 on a_n16.key=b_n12.key)sub2;
explain select * from src except distinct select * from src;
@@ -53,6 +53,6 @@ explain select * from src except distinct select * from src except distinct sele
select * from src except distinct select * from src except distinct select * from src except distinct select * from src;
-explain select value from a group by value except distinct select key from b group by key;
+explain select value from a_n16 group by value except distinct select key from b_n12 group by key;
-select value from a group by value except distinct select key from b group by key;
+select value from a_n16 group by value except distinct select key from b_n12 group by key;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/exchange_partition3.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/exchange_partition3.q b/ql/src/test/queries/clientpositive/exchange_partition3.q
index 7c076ce..26af541 100644
--- a/ql/src/test/queries/clientpositive/exchange_partition3.q
+++ b/ql/src/test/queries/clientpositive/exchange_partition3.q
@@ -1,15 +1,15 @@
-CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING, hr STRING);
-CREATE TABLE exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING, hr STRING);
-SHOW PARTITIONS exchange_part_test1;
-SHOW PARTITIONS exchange_part_test2;
+CREATE TABLE exchange_part_test1_n0 (f1 string) PARTITIONED BY (ds STRING, hr STRING);
+CREATE TABLE exchange_part_test2_n0 (f1 string) PARTITIONED BY (ds STRING, hr STRING);
+SHOW PARTITIONS exchange_part_test1_n0;
+SHOW PARTITIONS exchange_part_test2_n0;
-ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2014-01-03', hr='1');
-ALTER TABLE exchange_part_test2 ADD PARTITION (ds='2013-04-05', hr='1');
-ALTER TABLE exchange_part_test2 ADD PARTITION (ds='2013-04-05', hr='2');
-SHOW PARTITIONS exchange_part_test1;
-SHOW PARTITIONS exchange_part_test2;
+ALTER TABLE exchange_part_test1_n0 ADD PARTITION (ds='2014-01-03', hr='1');
+ALTER TABLE exchange_part_test2_n0 ADD PARTITION (ds='2013-04-05', hr='1');
+ALTER TABLE exchange_part_test2_n0 ADD PARTITION (ds='2013-04-05', hr='2');
+SHOW PARTITIONS exchange_part_test1_n0;
+SHOW PARTITIONS exchange_part_test2_n0;
-- This will exchange both partitions hr=1 and hr=2
-ALTER TABLE exchange_part_test1 EXCHANGE PARTITION (ds='2013-04-05') WITH TABLE exchange_part_test2;
-SHOW PARTITIONS exchange_part_test1;
-SHOW PARTITIONS exchange_part_test2;
+ALTER TABLE exchange_part_test1_n0 EXCHANGE PARTITION (ds='2013-04-05') WITH TABLE exchange_part_test2_n0;
+SHOW PARTITIONS exchange_part_test1_n0;
+SHOW PARTITIONS exchange_part_test2_n0;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/exchgpartition2lel.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/exchgpartition2lel.q b/ql/src/test/queries/clientpositive/exchgpartition2lel.q
index b009897..567ff8a 100644
--- a/ql/src/test/queries/clientpositive/exchgpartition2lel.q
+++ b/ql/src/test/queries/clientpositive/exchgpartition2lel.q
@@ -1,32 +1,33 @@
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-DROP TABLE IF EXISTS t3;
-DROP TABLE IF EXISTS t4;
+--! qt:dataset:src
+DROP TABLE IF EXISTS t1_n72;
+DROP TABLE IF EXISTS t2_n44;
+DROP TABLE IF EXISTS t3_n15;
+DROP TABLE IF EXISTS t4_n7;
-CREATE TABLE t1 (a int) PARTITIONED BY (d1 int);
-CREATE TABLE t2 (a int) PARTITIONED BY (d1 int);
-CREATE TABLE t3 (a int) PARTITIONED BY (d1 int, d2 int);
-CREATE TABLE t4 (a int) PARTITIONED BY (d1 int, d2 int);
-CREATE TABLE t5 (a int) PARTITIONED BY (d1 int, d2 int, d3 int);
-CREATE TABLE t6 (a int) PARTITIONED BY (d1 int, d2 int, d3 int);
+CREATE TABLE t1_n72 (a int) PARTITIONED BY (d1 int);
+CREATE TABLE t2_n44 (a int) PARTITIONED BY (d1 int);
+CREATE TABLE t3_n15 (a int) PARTITIONED BY (d1 int, d2 int);
+CREATE TABLE t4_n7 (a int) PARTITIONED BY (d1 int, d2 int);
+CREATE TABLE t5_n3 (a int) PARTITIONED BY (d1 int, d2 int, d3 int);
+CREATE TABLE t6_n2 (a int) PARTITIONED BY (d1 int, d2 int, d3 int);
set hive.mapred.mode=nonstrict;
-INSERT OVERWRITE TABLE t1 PARTITION (d1 = 1) SELECT key FROM src where key = 100 limit 1;
-INSERT OVERWRITE TABLE t3 PARTITION (d1 = 1, d2 = 1) SELECT key FROM src where key = 100 limit 1;
-INSERT OVERWRITE TABLE t5 PARTITION (d1 = 1, d2 = 1, d3=1) SELECT key FROM src where key = 100 limit 1;
+INSERT OVERWRITE TABLE t1_n72 PARTITION (d1 = 1) SELECT key FROM src where key = 100 limit 1;
+INSERT OVERWRITE TABLE t3_n15 PARTITION (d1 = 1, d2 = 1) SELECT key FROM src where key = 100 limit 1;
+INSERT OVERWRITE TABLE t5_n3 PARTITION (d1 = 1, d2 = 1, d3=1) SELECT key FROM src where key = 100 limit 1;
-SELECT * FROM t1;
+SELECT * FROM t1_n72;
-SELECT * FROM t3;
+SELECT * FROM t3_n15;
-ALTER TABLE t2 EXCHANGE PARTITION (d1 = 1) WITH TABLE t1;
-SELECT * FROM t1;
-SELECT * FROM t2;
+ALTER TABLE t2_n44 EXCHANGE PARTITION (d1 = 1) WITH TABLE t1_n72;
+SELECT * FROM t1_n72;
+SELECT * FROM t2_n44;
-ALTER TABLE t4 EXCHANGE PARTITION (d1 = 1, d2 = 1) WITH TABLE t3;
-SELECT * FROM t3;
-SELECT * FROM t4;
+ALTER TABLE t4_n7 EXCHANGE PARTITION (d1 = 1, d2 = 1) WITH TABLE t3_n15;
+SELECT * FROM t3_n15;
+SELECT * FROM t4_n7;
-ALTER TABLE t6 EXCHANGE PARTITION (d1 = 1, d2 = 1, d3 = 1) WITH TABLE t5;
-SELECT * FROM t5;
-SELECT * FROM t6;
+ALTER TABLE t6_n2 EXCHANGE PARTITION (d1 = 1, d2 = 1, d3 = 1) WITH TABLE t5_n3;
+SELECT * FROM t5_n3;
+SELECT * FROM t6_n2;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/exec_parallel_column_stats.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/exec_parallel_column_stats.q b/ql/src/test/queries/clientpositive/exec_parallel_column_stats.q
index a89b707..d1d860b 100644
--- a/ql/src/test/queries/clientpositive/exec_parallel_column_stats.q
+++ b/ql/src/test/queries/clientpositive/exec_parallel_column_stats.q
@@ -1,7 +1,7 @@
set hive.exec.parallel=true;
-create table t as select * from src;
+create table t_n25 as select * from src;
-explain analyze table t compute statistics for columns;
+explain analyze table t_n25 compute statistics for columns;
-analyze table t compute statistics for columns;
+analyze table t_n25 compute statistics for columns;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/exim_00_nonpart_empty.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/exim_00_nonpart_empty.q b/ql/src/test/queries/clientpositive/exim_00_nonpart_empty.q
index 8288bbf..e2c1a3f 100644
--- a/ql/src/test/queries/clientpositive/exim_00_nonpart_empty.q
+++ b/ql/src/test/queries/clientpositive/exim_00_nonpart_empty.q
@@ -3,24 +3,24 @@ set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.Sessi
set hive.test.mode=true;
set hive.test.mode.prefix=;
-set hive.test.mode.nosamplelist=exim_department,exim_employee;
+set hive.test.mode.nosamplelist=exim_department_n0,exim_employee;
-create table exim_department ( dep_id int comment "department id")
+create table exim_department_n0 ( dep_id int comment "department id")
stored as textfile
tblproperties("creator"="krishna");
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/exports/exim_department/temp;
dfs -rmr target/tmp/ql/test/data/exports/exim_department;
-export table exim_department to 'ql/test/data/exports/exim_department';
-drop table exim_department;
+export table exim_department_n0 to 'ql/test/data/exports/exim_department';
+drop table exim_department_n0;
create database importer;
use importer;
import from 'ql/test/data/exports/exim_department';
-describe extended exim_department;
-show table extended like exim_department;
+describe extended exim_department_n0;
+show table extended like exim_department_n0;
dfs -rmr target/tmp/ql/test/data/exports/exim_department;
-select * from exim_department;
-drop table exim_department;
+select * from exim_department_n0;
+drop table exim_department_n0;
drop database importer;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/exim_01_nonpart.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/exim_01_nonpart.q b/ql/src/test/queries/clientpositive/exim_01_nonpart.q
index 1e2eed8..85ff811 100644
--- a/ql/src/test/queries/clientpositive/exim_01_nonpart.q
+++ b/ql/src/test/queries/clientpositive/exim_01_nonpart.q
@@ -1,24 +1,24 @@
set hive.test.mode=true;
set hive.test.mode.prefix=;
-set hive.test.mode.nosamplelist=exim_department,exim_employee;
+set hive.test.mode.nosamplelist=exim_department_n7,exim_employee;
-create table exim_department ( dep_id int comment "department id")
+create table exim_department_n7 ( dep_id int comment "department id")
stored as textfile
tblproperties("creator"="krishna");
-load data local inpath "../../data/files/test.dat" into table exim_department;
+load data local inpath "../../data/files/test.dat" into table exim_department_n7;
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/exports/exim_department/temp;
dfs -rmr target/tmp/ql/test/data/exports/exim_department;
-export table exim_department to 'ql/test/data/exports/exim_department';
-drop table exim_department;
+export table exim_department_n7 to 'ql/test/data/exports/exim_department';
+drop table exim_department_n7;
create database importer;
use importer;
import from 'ql/test/data/exports/exim_department';
-describe extended exim_department;
-show table extended like exim_department;
+describe extended exim_department_n7;
+show table extended like exim_department_n7;
dfs -rmr target/tmp/ql/test/data/exports/exim_department;
-select * from exim_department;
-drop table exim_department;
+select * from exim_department_n7;
+drop table exim_department_n7;
drop database importer;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/exim_02_00_part_empty.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/exim_02_00_part_empty.q b/ql/src/test/queries/clientpositive/exim_02_00_part_empty.q
index 495306b..4eac16e 100644
--- a/ql/src/test/queries/clientpositive/exim_02_00_part_empty.q
+++ b/ql/src/test/queries/clientpositive/exim_02_00_part_empty.q
@@ -1,26 +1,26 @@
set hive.mapred.mode=nonstrict;
set hive.test.mode=true;
set hive.test.mode.prefix=;
-set hive.test.mode.nosamplelist=exim_department,exim_employee;
+set hive.test.mode.nosamplelist=exim_department,exim_employee_n9;
-create table exim_employee ( emp_id int comment "employee id")
+create table exim_employee_n9 ( emp_id int comment "employee id")
comment "employee table"
partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
stored as textfile
tblproperties("creator"="krishna");
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/exports/exim_employee/temp;
dfs -rmr target/tmp/ql/test/data/exports/exim_employee;
-export table exim_employee to 'ql/test/data/exports/exim_employee';
-drop table exim_employee;
+export table exim_employee_n9 to 'ql/test/data/exports/exim_employee';
+drop table exim_employee_n9;
create database importer;
use importer;
import from 'ql/test/data/exports/exim_employee';
-describe extended exim_employee;
-show table extended like exim_employee;
+describe extended exim_employee_n9;
+show table extended like exim_employee_n9;
dfs -rmr target/tmp/ql/test/data/exports/exim_employee;
-select * from exim_employee;
-drop table exim_employee;
+select * from exim_employee_n9;
+drop table exim_employee_n9;
drop database importer;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/exim_03_nonpart_over_compat.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/exim_03_nonpart_over_compat.q b/ql/src/test/queries/clientpositive/exim_03_nonpart_over_compat.q
index 47d949a..90e7b1f 100644
--- a/ql/src/test/queries/clientpositive/exim_03_nonpart_over_compat.q
+++ b/ql/src/test/queries/clientpositive/exim_03_nonpart_over_compat.q
@@ -1,26 +1,26 @@
set hive.test.mode=true;
set hive.test.mode.prefix=;
-set hive.test.mode.nosamplelist=exim_department,exim_employee;
+set hive.test.mode.nosamplelist=exim_department_n5,exim_employee;
-create table exim_department ( dep_id int comment "department id")
+create table exim_department_n5 ( dep_id int comment "department id")
stored as textfile
tblproperties("creator"="krishna");
-load data local inpath "../../data/files/test.dat" into table exim_department;
+load data local inpath "../../data/files/test.dat" into table exim_department_n5;
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/exports/exim_department/temp;
dfs -rmr target/tmp/ql/test/data/exports/exim_department;
-export table exim_department to 'ql/test/data/exports/exim_department';
-drop table exim_department;
+export table exim_department_n5 to 'ql/test/data/exports/exim_department';
+drop table exim_department_n5;
create database importer;
use importer;
-create table exim_department ( dep_id int comment "department identifier")
+create table exim_department_n5 ( dep_id int comment "department identifier")
stored as textfile
tblproperties("maker"="krishna");
import from 'ql/test/data/exports/exim_department';
-describe extended exim_department;
-select * from exim_department;
-drop table exim_department;
+describe extended exim_department_n5;
+select * from exim_department_n5;
+drop table exim_department_n5;
dfs -rmr target/tmp/ql/test/data/exports/exim_department;
drop database importer;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/exim_04_all_part.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/exim_04_all_part.q b/ql/src/test/queries/clientpositive/exim_04_all_part.q
index 8fb7aa0..a46c712a 100644
--- a/ql/src/test/queries/clientpositive/exim_04_all_part.q
+++ b/ql/src/test/queries/clientpositive/exim_04_all_part.q
@@ -1,34 +1,34 @@
set hive.mapred.mode=nonstrict;
set hive.test.mode=true;
set hive.test.mode.prefix=;
-set hive.test.mode.nosamplelist=exim_department,exim_employee;
+set hive.test.mode.nosamplelist=exim_department,exim_employee_n5;
-create table exim_employee ( emp_id int comment "employee id")
+create table exim_employee_n5 ( emp_id int comment "employee id")
comment "employee table"
partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
stored as textfile
tblproperties("creator"="krishna");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="in", emp_state="tn");
+ into table exim_employee_n5 partition (emp_country="in", emp_state="tn");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="in", emp_state="ka");
+ into table exim_employee_n5 partition (emp_country="in", emp_state="ka");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="us", emp_state="tn");
+ into table exim_employee_n5 partition (emp_country="us", emp_state="tn");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="us", emp_state="ka");
+ into table exim_employee_n5 partition (emp_country="us", emp_state="ka");
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/exports/exim_employee/temp;
dfs -rmr target/tmp/ql/test/data/exports/exim_employee;
-export table exim_employee to 'ql/test/data/exports/exim_employee';
-drop table exim_employee;
+export table exim_employee_n5 to 'ql/test/data/exports/exim_employee';
+drop table exim_employee_n5;
create database importer;
use importer;
import from 'ql/test/data/exports/exim_employee';
-describe extended exim_employee;
-show table extended like exim_employee;
+describe extended exim_employee_n5;
+show table extended like exim_employee_n5;
dfs -rmr target/tmp/ql/test/data/exports/exim_employee;
-select * from exim_employee;
-drop table exim_employee;
+select * from exim_employee_n5;
+drop table exim_employee_n5;
drop database importer;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/exim_04_evolved_parts.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/exim_04_evolved_parts.q b/ql/src/test/queries/clientpositive/exim_04_evolved_parts.q
index 6acac7b..aa989c7 100644
--- a/ql/src/test/queries/clientpositive/exim_04_evolved_parts.q
+++ b/ql/src/test/queries/clientpositive/exim_04_evolved_parts.q
@@ -1,43 +1,43 @@
set hive.mapred.mode=nonstrict;
set hive.test.mode=true;
set hive.test.mode.prefix=;
-set hive.test.mode.nosamplelist=exim_department,exim_employee;
+set hive.test.mode.nosamplelist=exim_department,exim_employee_n12;
-create table exim_employee (emp_id int comment 'employee id', emp_name string, emp_dob string comment 'employee date of birth', emp_sex string comment 'M/F')
+create table exim_employee_n12 (emp_id int comment 'employee id', emp_name string, emp_dob string comment 'employee date of birth', emp_sex string comment 'M/F')
comment 'employee table'
partitioned by (emp_country string comment '2-char code', emp_state string comment '2-char code')
clustered by (emp_sex) sorted by (emp_id ASC) into 10 buckets
row format serde "org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe" with serdeproperties ('serialization.format'='1')
stored as rcfile;
-alter table exim_employee add columns (emp_dept int);
-alter table exim_employee clustered by (emp_sex, emp_dept) sorted by (emp_id desc) into 5 buckets;
-alter table exim_employee add partition (emp_country='in', emp_state='tn');
+alter table exim_employee_n12 add columns (emp_dept int);
+alter table exim_employee_n12 clustered by (emp_sex, emp_dept) sorted by (emp_id desc) into 5 buckets;
+alter table exim_employee_n12 add partition (emp_country='in', emp_state='tn');
-alter table exim_employee set fileformat
+alter table exim_employee_n12 set fileformat
inputformat "org.apache.hadoop.hive.ql.io.BucketizedHiveInputFormat"
outputformat "org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat"
serde "org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe";
;
-alter table exim_employee set serde "org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe" with serdeproperties ('serialization.format'='2');
+alter table exim_employee_n12 set serde "org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe" with serdeproperties ('serialization.format'='2');
-alter table exim_employee add partition (emp_country='in', emp_state='ka');
+alter table exim_employee_n12 add partition (emp_country='in', emp_state='ka');
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/exports/exim_employee/temp;
dfs -rmr target/tmp/ql/test/data/exports/exim_employee;
-export table exim_employee to 'ql/test/data/exports/exim_employee';
-drop table exim_employee;
+export table exim_employee_n12 to 'ql/test/data/exports/exim_employee';
+drop table exim_employee_n12;
create database importer;
use importer;
import from 'ql/test/data/exports/exim_employee';
-describe extended exim_employee;
-describe extended exim_employee partition (emp_country='in', emp_state='tn');
-describe extended exim_employee partition (emp_country='in', emp_state='ka');
-show table extended like exim_employee;
+describe extended exim_employee_n12;
+describe extended exim_employee_n12 partition (emp_country='in', emp_state='tn');
+describe extended exim_employee_n12 partition (emp_country='in', emp_state='ka');
+show table extended like exim_employee_n12;
dfs -rmr target/tmp/ql/test/data/exports/exim_employee;
-select * from exim_employee;
-drop table exim_employee;
+select * from exim_employee_n12;
+drop table exim_employee_n12;
drop database importer;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/exim_05_some_part.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/exim_05_some_part.q b/ql/src/test/queries/clientpositive/exim_05_some_part.q
index 9e07a9e..235ab81 100644
--- a/ql/src/test/queries/clientpositive/exim_05_some_part.q
+++ b/ql/src/test/queries/clientpositive/exim_05_some_part.q
@@ -1,34 +1,34 @@
set hive.mapred.mode=nonstrict;
set hive.test.mode=true;
set hive.test.mode.prefix=;
-set hive.test.mode.nosamplelist=exim_department,exim_employee;
+set hive.test.mode.nosamplelist=exim_department,exim_employee_n15;
-create table exim_employee ( emp_id int comment "employee id")
+create table exim_employee_n15 ( emp_id int comment "employee id")
comment "employee table"
partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
stored as textfile
tblproperties("creator"="krishna");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="in", emp_state="tn");
+ into table exim_employee_n15 partition (emp_country="in", emp_state="tn");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="in", emp_state="ka");
+ into table exim_employee_n15 partition (emp_country="in", emp_state="ka");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="us", emp_state="tn");
+ into table exim_employee_n15 partition (emp_country="us", emp_state="tn");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="us", emp_state="ka");
+ into table exim_employee_n15 partition (emp_country="us", emp_state="ka");
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/exports/exim_employee/temp;
dfs -rmr target/tmp/ql/test/data/exports/exim_employee;
-export table exim_employee partition (emp_state="ka") to 'ql/test/data/exports/exim_employee';
-drop table exim_employee;
+export table exim_employee_n15 partition (emp_state="ka") to 'ql/test/data/exports/exim_employee';
+drop table exim_employee_n15;
create database importer;
use importer;
import from 'ql/test/data/exports/exim_employee';
-describe extended exim_employee;
-show table extended like exim_employee;
+describe extended exim_employee_n15;
+show table extended like exim_employee_n15;
dfs -rmr target/tmp/ql/test/data/exports/exim_employee;
-select * from exim_employee;
-drop table exim_employee;
+select * from exim_employee_n15;
+drop table exim_employee_n15;
drop database importer;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/exim_06_one_part.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/exim_06_one_part.q b/ql/src/test/queries/clientpositive/exim_06_one_part.q
index 0dcdaa1..d83dfe8 100644
--- a/ql/src/test/queries/clientpositive/exim_06_one_part.q
+++ b/ql/src/test/queries/clientpositive/exim_06_one_part.q
@@ -1,34 +1,34 @@
set hive.mapred.mode=nonstrict;
set hive.test.mode=true;
set hive.test.mode.prefix=;
-set hive.test.mode.nosamplelist=exim_department,exim_employee;
+set hive.test.mode.nosamplelist=exim_department,exim_employee_n3;
-create table exim_employee ( emp_id int comment "employee id")
+create table exim_employee_n3 ( emp_id int comment "employee id")
comment "employee table"
partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
stored as textfile
tblproperties("creator"="krishna");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="in", emp_state="tn");
+ into table exim_employee_n3 partition (emp_country="in", emp_state="tn");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="in", emp_state="ka");
+ into table exim_employee_n3 partition (emp_country="in", emp_state="ka");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="us", emp_state="tn");
+ into table exim_employee_n3 partition (emp_country="us", emp_state="tn");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="us", emp_state="ka");
+ into table exim_employee_n3 partition (emp_country="us", emp_state="ka");
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/exports/exim_employee/temp;
dfs -rmr target/tmp/ql/test/data/exports/exim_employee;
-export table exim_employee partition (emp_country="in",emp_state="ka") to 'ql/test/data/exports/exim_employee';
-drop table exim_employee;
+export table exim_employee_n3 partition (emp_country="in",emp_state="ka") to 'ql/test/data/exports/exim_employee';
+drop table exim_employee_n3;
create database importer;
use importer;
import from 'ql/test/data/exports/exim_employee';
-describe extended exim_employee;
-show table extended like exim_employee;
+describe extended exim_employee_n3;
+show table extended like exim_employee_n3;
dfs -rmr target/tmp/ql/test/data/exports/exim_employee;
-select * from exim_employee;
-drop table exim_employee;
+select * from exim_employee_n3;
+drop table exim_employee_n3;
drop database importer;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/exim_07_all_part_over_nonoverlap.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/exim_07_all_part_over_nonoverlap.q b/ql/src/test/queries/clientpositive/exim_07_all_part_over_nonoverlap.q
index e897ee7..04f68d4 100644
--- a/ql/src/test/queries/clientpositive/exim_07_all_part_over_nonoverlap.q
+++ b/ql/src/test/queries/clientpositive/exim_07_all_part_over_nonoverlap.q
@@ -1,40 +1,40 @@
set hive.mapred.mode=nonstrict;
set hive.test.mode=true;
set hive.test.mode.prefix=;
-set hive.test.mode.nosamplelist=exim_department,exim_employee;
+set hive.test.mode.nosamplelist=exim_department,exim_employee_n8;
-create table exim_employee ( emp_id int comment "employee id")
+create table exim_employee_n8 ( emp_id int comment "employee id")
comment "employee table"
partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
stored as textfile
tblproperties("creator"="krishna");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="in", emp_state="tn");
+ into table exim_employee_n8 partition (emp_country="in", emp_state="tn");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="in", emp_state="ka");
+ into table exim_employee_n8 partition (emp_country="in", emp_state="ka");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="us", emp_state="tn");
+ into table exim_employee_n8 partition (emp_country="us", emp_state="tn");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="us", emp_state="ka");
+ into table exim_employee_n8 partition (emp_country="us", emp_state="ka");
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/exports/exim_employee/temp;
dfs -rmr target/tmp/ql/test/data/exports/exim_employee;
-export table exim_employee to 'ql/test/data/exports/exim_employee';
-drop table exim_employee;
+export table exim_employee_n8 to 'ql/test/data/exports/exim_employee';
+drop table exim_employee_n8;
create database importer;
use importer;
-create table exim_employee ( emp_id int comment "employee id")
+create table exim_employee_n8 ( emp_id int comment "employee id")
comment "table of employees"
partitioned by (emp_country string comment "iso code", emp_state string comment "free-form text")
stored as textfile
tblproperties("maker"="krishna");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="us", emp_state="al");
+ into table exim_employee_n8 partition (emp_country="us", emp_state="al");
import from 'ql/test/data/exports/exim_employee';
-describe extended exim_employee;
-select * from exim_employee;
-drop table exim_employee;
+describe extended exim_employee_n8;
+select * from exim_employee_n8;
+drop table exim_employee_n8;
dfs -rmr target/tmp/ql/test/data/exports/exim_employee;
drop database importer;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/exim_08_nonpart_rename.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/exim_08_nonpart_rename.q b/ql/src/test/queries/clientpositive/exim_08_nonpart_rename.q
index 8a1d945..c8e075d 100644
--- a/ql/src/test/queries/clientpositive/exim_08_nonpart_rename.q
+++ b/ql/src/test/queries/clientpositive/exim_08_nonpart_rename.q
@@ -1,28 +1,28 @@
set hive.test.mode=true;
set hive.test.mode.prefix=;
-set hive.test.mode.nosamplelist=exim_department,exim_employee,exim_imported_dept;
+set hive.test.mode.nosamplelist=exim_department_n9,exim_employee,exim_imported_dept;
-create table exim_department ( dep_id int comment "department id")
+create table exim_department_n9 ( dep_id int comment "department id")
stored as textfile
tblproperties("creator"="krishna");
-load data local inpath "../../data/files/test.dat" into table exim_department;
+load data local inpath "../../data/files/test.dat" into table exim_department_n9;
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/exports/exim_department/temp;
dfs -rmr target/tmp/ql/test/data/exports/exim_department;
-export table exim_department to 'ql/test/data/exports/exim_department';
-drop table exim_department;
+export table exim_department_n9 to 'ql/test/data/exports/exim_department';
+drop table exim_department_n9;
create database importer;
use importer;
-create table exim_department ( dep_id int comment "department id")
+create table exim_department_n9 ( dep_id int comment "department id")
partitioned by (emp_org string)
stored as textfile
tblproperties("creator"="krishna");
-load data local inpath "../../data/files/test.dat" into table exim_department partition (emp_org="hr");
+load data local inpath "../../data/files/test.dat" into table exim_department_n9 partition (emp_org="hr");
import table exim_imported_dept from 'ql/test/data/exports/exim_department';
describe extended exim_imported_dept;
select * from exim_imported_dept;
drop table exim_imported_dept;
-drop table exim_department;
+drop table exim_department_n9;
dfs -rmr target/tmp/ql/test/data/exports/exim_department;
drop database importer;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/exim_09_part_spec_nonoverlap.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/exim_09_part_spec_nonoverlap.q b/ql/src/test/queries/clientpositive/exim_09_part_spec_nonoverlap.q
index 4a94418..1f8cc34 100644
--- a/ql/src/test/queries/clientpositive/exim_09_part_spec_nonoverlap.q
+++ b/ql/src/test/queries/clientpositive/exim_09_part_spec_nonoverlap.q
@@ -1,41 +1,41 @@
set hive.mapred.mode=nonstrict;
set hive.test.mode=true;
set hive.test.mode.prefix=;
-set hive.test.mode.nosamplelist=exim_department,exim_employee;
+set hive.test.mode.nosamplelist=exim_department,exim_employee_n10;
-create table exim_employee ( emp_id int comment "employee id")
+create table exim_employee_n10 ( emp_id int comment "employee id")
comment "employee table"
partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
stored as textfile
tblproperties("creator"="krishna");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="in", emp_state="tn");
+ into table exim_employee_n10 partition (emp_country="in", emp_state="tn");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="in", emp_state="ka");
+ into table exim_employee_n10 partition (emp_country="in", emp_state="ka");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="us", emp_state="tn");
+ into table exim_employee_n10 partition (emp_country="us", emp_state="tn");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="us", emp_state="ka");
+ into table exim_employee_n10 partition (emp_country="us", emp_state="ka");
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/exports/exim_employee/temp;
dfs -rmr target/tmp/ql/test/data/exports/exim_employee;
-export table exim_employee to 'ql/test/data/exports/exim_employee';
-drop table exim_employee;
+export table exim_employee_n10 to 'ql/test/data/exports/exim_employee';
+drop table exim_employee_n10;
create database importer;
use importer;
-create table exim_employee ( emp_id int comment "employee id")
+create table exim_employee_n10 ( emp_id int comment "employee id")
comment "employee table"
partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
stored as textfile
tblproperties("creator"="krishna");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="in", emp_state="tn");
+ into table exim_employee_n10 partition (emp_country="in", emp_state="tn");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="in", emp_state="ka");
-import table exim_employee partition (emp_country="us", emp_state="tn") from 'ql/test/data/exports/exim_employee';
-describe extended exim_employee;
-select * from exim_employee;
-drop table exim_employee;
+ into table exim_employee_n10 partition (emp_country="in", emp_state="ka");
+import table exim_employee_n10 partition (emp_country="us", emp_state="tn") from 'ql/test/data/exports/exim_employee';
+describe extended exim_employee_n10;
+select * from exim_employee_n10;
+drop table exim_employee_n10;
dfs -rmr target/tmp/ql/test/data/exports/exim_employee;
drop database importer;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/exim_10_external_managed.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/exim_10_external_managed.q b/ql/src/test/queries/clientpositive/exim_10_external_managed.q
index 54859ee..5aadbb3 100644
--- a/ql/src/test/queries/clientpositive/exim_10_external_managed.q
+++ b/ql/src/test/queries/clientpositive/exim_10_external_managed.q
@@ -1,27 +1,27 @@
set hive.test.mode=true;
set hive.test.mode.prefix=;
-set hive.test.mode.nosamplelist=exim_department,exim_employee;
+set hive.test.mode.nosamplelist=exim_department_n4,exim_employee;
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/tablestore/exim_department/temp;
dfs -rmr target/tmp/ql/test/data/tablestore/exim_department;
-create external table exim_department ( dep_id int comment "department id")
+create external table exim_department_n4 ( dep_id int comment "department id")
stored as textfile
location 'ql/test/data/tablestore/exim_department'
tblproperties("creator"="krishna");
-load data local inpath "../../data/files/test.dat" into table exim_department;
+load data local inpath "../../data/files/test.dat" into table exim_department_n4;
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/exports/exim_department/temp;
dfs -rmr target/tmp/ql/test/data/exports/exim_department;
-export table exim_department to 'ql/test/data/exports/exim_department';
-drop table exim_department;
+export table exim_department_n4 to 'ql/test/data/exports/exim_department';
+drop table exim_department_n4;
dfs -rmr target/tmp/ql/test/data/tablestore/exim_department;
create database importer;
use importer;
import from 'ql/test/data/exports/exim_department';
-describe extended exim_department;
-select * from exim_department;
-drop table exim_department;
+describe extended exim_department_n4;
+select * from exim_department_n4;
+drop table exim_department_n4;
dfs -rmr target/tmp/ql/test/data/exports/exim_department;
drop database importer;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/exim_12_external_location.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/exim_12_external_location.q b/ql/src/test/queries/clientpositive/exim_12_external_location.q
index e4d50ff..5c6ed08 100644
--- a/ql/src/test/queries/clientpositive/exim_12_external_location.q
+++ b/ql/src/test/queries/clientpositive/exim_12_external_location.q
@@ -1,15 +1,15 @@
set hive.test.mode=true;
set hive.test.mode.prefix=;
-set hive.test.mode.nosamplelist=exim_department,exim_employee;
+set hive.test.mode.nosamplelist=exim_department_n8,exim_employee;
-create table exim_department ( dep_id int comment "department id")
+create table exim_department_n8 ( dep_id int comment "department id")
stored as textfile
tblproperties("creator"="krishna");
-load data local inpath "../../data/files/test.dat" into table exim_department;
+load data local inpath "../../data/files/test.dat" into table exim_department_n8;
dfs ${system:test.dfs.mkdir} ${system:test.tmp.dir}/ql/test/data/exports/exim_department/temp;
dfs -rmr ${system:test.tmp.dir}/ql/test/data/exports/exim_department;
-export table exim_department to 'ql/test/data/exports/exim_department';
-drop table exim_department;
+export table exim_department_n8 to 'ql/test/data/exports/exim_department';
+drop table exim_department_n8;
create database importer;
use importer;
@@ -17,13 +17,13 @@ use importer;
dfs ${system:test.dfs.mkdir} ${system:test.tmp.dir}/ql/test/data/tablestore/exim_department/temp;
dfs -rmr ${system:test.tmp.dir}/ql/test/data/tablestore/exim_department;
-import external table exim_department from 'ql/test/data/exports/exim_department'
+import external table exim_department_n8 from 'ql/test/data/exports/exim_department'
location 'ql/test/data/tablestore/exim_department';
-describe extended exim_department;
+describe extended exim_department_n8;
dfs -rmr ${system:test.tmp.dir}/ql/test/data/exports/exim_department;
-select * from exim_department;
+select * from exim_department_n8;
dfs -rmr ${system:test.tmp.dir}/ql/test/data/tablestore/exim_department;
-select * from exim_department;
-drop table exim_department;
+select * from exim_department_n8;
+drop table exim_department_n8;
drop database importer;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/exim_13_managed_location.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/exim_13_managed_location.q b/ql/src/test/queries/clientpositive/exim_13_managed_location.q
index 909d237..ae3e045 100644
--- a/ql/src/test/queries/clientpositive/exim_13_managed_location.q
+++ b/ql/src/test/queries/clientpositive/exim_13_managed_location.q
@@ -1,15 +1,15 @@
set hive.test.mode=true;
set hive.test.mode.prefix=;
-set hive.test.mode.nosamplelist=exim_department,exim_employee;
+set hive.test.mode.nosamplelist=exim_department_n2,exim_employee;
-create table exim_department ( dep_id int comment "department id")
+create table exim_department_n2 ( dep_id int comment "department id")
stored as textfile
tblproperties("creator"="krishna");
-load data local inpath "../../data/files/test.dat" into table exim_department;
+load data local inpath "../../data/files/test.dat" into table exim_department_n2;
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/exports/exim_department/temp;
dfs -rmr target/tmp/ql/test/data/exports/exim_department;
-export table exim_department to 'ql/test/data/exports/exim_department';
-drop table exim_department;
+export table exim_department_n2 to 'ql/test/data/exports/exim_department';
+drop table exim_department_n2;
create database importer;
use importer;
@@ -17,13 +17,13 @@ use importer;
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/tablestore/exim_department/temp;
dfs -rmr target/tmp/ql/test/data/tablestore/exim_department;
-import table exim_department from 'ql/test/data/exports/exim_department'
+import table exim_department_n2 from 'ql/test/data/exports/exim_department'
location 'ql/test/data/tablestore/exim_department';
-describe extended exim_department;
+describe extended exim_department_n2;
dfs -rmr target/tmp/ql/test/data/exports/exim_department;
-select * from exim_department;
+select * from exim_department_n2;
dfs -rmr target/tmp/ql/test/data/tablestore/exim_department;
-select * from exim_department;
-drop table exim_department;
+select * from exim_department_n2;
+drop table exim_department_n2;
drop database importer;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/exim_14_managed_location_over_existing.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/exim_14_managed_location_over_existing.q b/ql/src/test/queries/clientpositive/exim_14_managed_location_over_existing.q
index dbb5fd9..3d16880 100644
--- a/ql/src/test/queries/clientpositive/exim_14_managed_location_over_existing.q
+++ b/ql/src/test/queries/clientpositive/exim_14_managed_location_over_existing.q
@@ -1,15 +1,15 @@
set hive.test.mode=true;
set hive.test.mode.prefix=;
-set hive.test.mode.nosamplelist=exim_department,exim_employee;
+set hive.test.mode.nosamplelist=exim_department_n10,exim_employee;
-create table exim_department ( dep_id int comment "department id")
+create table exim_department_n10 ( dep_id int comment "department id")
stored as textfile
tblproperties("creator"="krishna");
-load data local inpath "../../data/files/test.dat" into table exim_department;
+load data local inpath "../../data/files/test.dat" into table exim_department_n10;
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/exports/exim_department/temp;
dfs -rmr target/tmp/ql/test/data/exports/exim_department;
-export table exim_department to 'ql/test/data/exports/exim_department';
-drop table exim_department;
+export table exim_department_n10 to 'ql/test/data/exports/exim_department';
+drop table exim_department_n10;
create database importer;
use importer;
@@ -17,17 +17,17 @@ use importer;
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/tablestore/exim_department/temp;
dfs -rmr target/tmp/ql/test/data/tablestore/exim_department;
-create table exim_department ( dep_id int comment "department id")
+create table exim_department_n10 ( dep_id int comment "department id")
stored as textfile
location 'ql/test/data/tablestore/exim_department'
tblproperties("creator"="krishna");
-import table exim_department from 'ql/test/data/exports/exim_department'
+import table exim_department_n10 from 'ql/test/data/exports/exim_department'
location 'ql/test/data/tablestore/exim_department';
-describe extended exim_department;
+describe extended exim_department_n10;
dfs -rmr target/tmp/ql/test/data/exports/exim_department;
-select * from exim_department;
+select * from exim_department_n10;
dfs -rmr target/tmp/ql/test/data/tablestore/exim_department;
-select * from exim_department;
-drop table exim_department;
+select * from exim_department_n10;
+drop table exim_department_n10;
drop database importer;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/exim_15_external_part.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/exim_15_external_part.q b/ql/src/test/queries/clientpositive/exim_15_external_part.q
index f1f2c38..a4fd56a 100644
--- a/ql/src/test/queries/clientpositive/exim_15_external_part.q
+++ b/ql/src/test/queries/clientpositive/exim_15_external_part.q
@@ -1,25 +1,25 @@
set hive.mapred.mode=nonstrict;
set hive.test.mode=true;
set hive.test.mode.prefix=;
-set hive.test.mode.nosamplelist=exim_department,exim_employee;
+set hive.test.mode.nosamplelist=exim_department,exim_employee_n0;
-create table exim_employee ( emp_id int comment "employee id")
+create table exim_employee_n0 ( emp_id int comment "employee id")
comment "employee table"
partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
stored as textfile
tblproperties("creator"="krishna");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="in", emp_state="tn");
+ into table exim_employee_n0 partition (emp_country="in", emp_state="tn");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="in", emp_state="ka");
+ into table exim_employee_n0 partition (emp_country="in", emp_state="ka");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="us", emp_state="tn");
+ into table exim_employee_n0 partition (emp_country="us", emp_state="tn");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="us", emp_state="ka");
+ into table exim_employee_n0 partition (emp_country="us", emp_state="ka");
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/exports/exim_employee/temp;
dfs -rmr target/tmp/ql/test/data/exports/exim_employee;
-export table exim_employee to 'ql/test/data/exports/exim_employee';
-drop table exim_employee;
+export table exim_employee_n0 to 'ql/test/data/exports/exim_employee';
+drop table exim_employee_n0;
create database importer;
use importer;
@@ -27,25 +27,25 @@ use importer;
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/tablestore/exim_employee/temp;
dfs -rmr target/tmp/ql/test/data/tablestore/exim_employee;
-create external table exim_employee ( emp_id int comment "employee id")
+create external table exim_employee_n0 ( emp_id int comment "employee id")
comment "employee table"
partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
stored as textfile
location 'ql/test/data/tablestore/exim_employee'
tblproperties("creator"="krishna");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="in", emp_state="tn");
+ into table exim_employee_n0 partition (emp_country="in", emp_state="tn");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="in", emp_state="ka");
-import external table exim_employee partition (emp_country="us", emp_state="tn")
+ into table exim_employee_n0 partition (emp_country="in", emp_state="ka");
+import external table exim_employee_n0 partition (emp_country="us", emp_state="tn")
from 'ql/test/data/exports/exim_employee';
-describe extended exim_employee;
-select * from exim_employee;
+describe extended exim_employee_n0;
+select * from exim_employee_n0;
dfs -rmr target/tmp/ql/test/data/exports/exim_employee;
-select * from exim_employee;
+select * from exim_employee_n0;
dfs -rmr target/tmp/ql/test/data/tablestore/exim_employee;
-select * from exim_employee;
-drop table exim_employee;
+select * from exim_employee_n0;
+drop table exim_employee_n0;
drop database importer;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/exim_16_part_external.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/exim_16_part_external.q b/ql/src/test/queries/clientpositive/exim_16_part_external.q
index 60dbe9e..b56832a 100644
--- a/ql/src/test/queries/clientpositive/exim_16_part_external.q
+++ b/ql/src/test/queries/clientpositive/exim_16_part_external.q
@@ -1,25 +1,25 @@
set hive.mapred.mode=nonstrict;
set hive.test.mode=true;
set hive.test.mode.prefix=;
-set hive.test.mode.nosamplelist=exim_department,exim_employee;
+set hive.test.mode.nosamplelist=exim_department,exim_employee_n11;
-create table exim_employee ( emp_id int comment "employee id")
+create table exim_employee_n11 ( emp_id int comment "employee id")
comment "employee table"
partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
stored as textfile
tblproperties("creator"="krishna");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="in", emp_state="tn");
+ into table exim_employee_n11 partition (emp_country="in", emp_state="tn");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="in", emp_state="ka");
+ into table exim_employee_n11 partition (emp_country="in", emp_state="ka");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="us", emp_state="tn");
+ into table exim_employee_n11 partition (emp_country="us", emp_state="tn");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="us", emp_state="ka");
+ into table exim_employee_n11 partition (emp_country="us", emp_state="ka");
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/exports/exim_employee/temp;
dfs -rmr target/tmp/ql/test/data/exports/exim_employee;
-export table exim_employee to 'ql/test/data/exports/exim_employee';
-drop table exim_employee;
+export table exim_employee_n11 to 'ql/test/data/exports/exim_employee';
+drop table exim_employee_n11;
create database importer;
use importer;
@@ -29,22 +29,22 @@ dfs -rmr target/tmp/ql/test/data/tablestore/exim_employee;
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/tablestore2/exim_employee/temp;
dfs -rmr target/tmp/ql/test/data/tablestore2/exim_employee;
-create external table exim_employee ( emp_id int comment "employee id")
+create external table exim_employee_n11 ( emp_id int comment "employee id")
comment "employee table"
partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
stored as textfile
location 'ql/test/data/tablestore2/exim_employee'
tblproperties("creator"="krishna");
-import table exim_employee partition (emp_country="us", emp_state="tn")
+import table exim_employee_n11 partition (emp_country="us", emp_state="tn")
from 'ql/test/data/exports/exim_employee'
location 'ql/test/data/tablestore/exim_employee';
-show table extended like exim_employee;
-show table extended like exim_employee partition (emp_country="us", emp_state="tn");
+show table extended like exim_employee_n11;
+show table extended like exim_employee_n11 partition (emp_country="us", emp_state="tn");
dfs -rmr target/tmp/ql/test/data/exports/exim_employee;
-select * from exim_employee;
+select * from exim_employee_n11;
dfs -rmr target/tmp/ql/test/data/tablestore/exim_employee;
-select * from exim_employee;
-drop table exim_employee;
+select * from exim_employee_n11;
+drop table exim_employee_n11;
dfs -rmr target/tmp/ql/test/data/tablestore2/exim_employee;
drop database importer;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/exim_17_part_managed.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/exim_17_part_managed.q b/ql/src/test/queries/clientpositive/exim_17_part_managed.q
index 6cb912f..0c6036b 100644
--- a/ql/src/test/queries/clientpositive/exim_17_part_managed.q
+++ b/ql/src/test/queries/clientpositive/exim_17_part_managed.q
@@ -1,25 +1,25 @@
set hive.mapred.mode=nonstrict;
set hive.test.mode=true;
set hive.test.mode.prefix=;
-set hive.test.mode.nosamplelist=exim_department,exim_employee;
+set hive.test.mode.nosamplelist=exim_department,exim_employee_n4;
-create table exim_employee ( emp_id int comment "employee id")
+create table exim_employee_n4 ( emp_id int comment "employee id")
comment "employee table"
partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
stored as textfile
tblproperties("creator"="krishna");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="in", emp_state="tn");
+ into table exim_employee_n4 partition (emp_country="in", emp_state="tn");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="in", emp_state="ka");
+ into table exim_employee_n4 partition (emp_country="in", emp_state="ka");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="us", emp_state="tn");
+ into table exim_employee_n4 partition (emp_country="us", emp_state="tn");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="us", emp_state="ka");
+ into table exim_employee_n4 partition (emp_country="us", emp_state="ka");
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/exports/exim_employee/temp;
dfs -rmr target/tmp/ql/test/data/exports/exim_employee;
-export table exim_employee to 'ql/test/data/exports/exim_employee';
-drop table exim_employee;
+export table exim_employee_n4 to 'ql/test/data/exports/exim_employee';
+drop table exim_employee_n4;
create database importer;
use importer;
@@ -27,23 +27,23 @@ use importer;
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/tablestore/exim_employee/temp;
dfs -rmr target/tmp/ql/test/data/tablestore/exim_employee;
-create table exim_employee ( emp_id int comment "employee id")
+create table exim_employee_n4 ( emp_id int comment "employee id")
comment "employee table"
partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
stored as textfile
tblproperties("creator"="krishna");
-import table exim_employee partition (emp_country="us", emp_state="tn")
+import table exim_employee_n4 partition (emp_country="us", emp_state="tn")
from 'ql/test/data/exports/exim_employee'
location 'ql/test/data/tablestore/exim_employee';
-alter table exim_employee add partition (emp_country="us", emp_state="ap")
+alter table exim_employee_n4 add partition (emp_country="us", emp_state="ap")
location 'ql/test/data/tablestore2/exim_employee';
-show table extended like exim_employee;
-show table extended like exim_employee partition (emp_country="us", emp_state="tn");
-show table extended like exim_employee partition (emp_country="us", emp_state="ap");
+show table extended like exim_employee_n4;
+show table extended like exim_employee_n4 partition (emp_country="us", emp_state="tn");
+show table extended like exim_employee_n4 partition (emp_country="us", emp_state="ap");
dfs -rmr target/tmp/ql/test/data/exports/exim_employee;
-select * from exim_employee;
+select * from exim_employee_n4;
dfs -rmr target/tmp/ql/test/data/tablestore/exim_employee;
-select * from exim_employee;
-drop table exim_employee;
+select * from exim_employee_n4;
+drop table exim_employee_n4;
drop database importer;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/exim_18_part_external.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/exim_18_part_external.q b/ql/src/test/queries/clientpositive/exim_18_part_external.q
index 4e6974c..1a259da 100644
--- a/ql/src/test/queries/clientpositive/exim_18_part_external.q
+++ b/ql/src/test/queries/clientpositive/exim_18_part_external.q
@@ -1,37 +1,37 @@
set hive.mapred.mode=nonstrict;
set hive.test.mode=true;
set hive.test.mode.prefix=;
-set hive.test.mode.nosamplelist=exim_department,exim_employee;
+set hive.test.mode.nosamplelist=exim_department,exim_employee_n14;
-create table exim_employee ( emp_id int comment "employee id")
+create table exim_employee_n14 ( emp_id int comment "employee id")
comment "employee table"
partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
stored as textfile
tblproperties("creator"="krishna");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="in", emp_state="tn");
+ into table exim_employee_n14 partition (emp_country="in", emp_state="tn");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="in", emp_state="ka");
+ into table exim_employee_n14 partition (emp_country="in", emp_state="ka");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="us", emp_state="tn");
+ into table exim_employee_n14 partition (emp_country="us", emp_state="tn");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="us", emp_state="ka");
+ into table exim_employee_n14 partition (emp_country="us", emp_state="ka");
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/exports/exim_employee/temp;
dfs -rmr target/tmp/ql/test/data/exports/exim_employee;
-export table exim_employee to 'ql/test/data/exports/exim_employee';
-drop table exim_employee;
+export table exim_employee_n14 to 'ql/test/data/exports/exim_employee';
+drop table exim_employee_n14;
create database importer;
use importer;
-import external table exim_employee partition (emp_country="us", emp_state="tn")
+import external table exim_employee_n14 partition (emp_country="us", emp_state="tn")
from 'ql/test/data/exports/exim_employee';
-describe extended exim_employee;
-show table extended like exim_employee;
-show table extended like exim_employee partition (emp_country="us", emp_state="tn");
-select * from exim_employee;
+describe extended exim_employee_n14;
+show table extended like exim_employee_n14;
+show table extended like exim_employee_n14 partition (emp_country="us", emp_state="tn");
+select * from exim_employee_n14;
dfs -rmr target/tmp/ql/test/data/exports/exim_employee;
-select * from exim_employee;
-drop table exim_employee;
+select * from exim_employee_n14;
+drop table exim_employee_n14;
drop database importer;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/exim_19_00_part_external_location.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/exim_19_00_part_external_location.q b/ql/src/test/queries/clientpositive/exim_19_00_part_external_location.q
index e7bfdcf..eecfd70 100644
--- a/ql/src/test/queries/clientpositive/exim_19_00_part_external_location.q
+++ b/ql/src/test/queries/clientpositive/exim_19_00_part_external_location.q
@@ -1,21 +1,21 @@
set hive.mapred.mode=nonstrict;
set hive.test.mode=true;
set hive.test.mode.prefix=;
-set hive.test.mode.nosamplelist=exim_department,exim_employee;
+set hive.test.mode.nosamplelist=exim_department,exim_employee_n2;
-create table exim_employee ( emp_id int comment "employee id")
+create table exim_employee_n2 ( emp_id int comment "employee id")
comment "employee table"
partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
stored as textfile
tblproperties("creator"="krishna");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="in", emp_state="tn");
+ into table exim_employee_n2 partition (emp_country="in", emp_state="tn");
load data local inpath "../../data/files/test2.dat"
- into table exim_employee partition (emp_country="in", emp_state="ka");
+ into table exim_employee_n2 partition (emp_country="in", emp_state="ka");
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/exports/exim_employee/temp;
dfs -rmr target/tmp/ql/test/data/exports/exim_employee;
-export table exim_employee to 'ql/test/data/exports/exim_employee';
-drop table exim_employee;
+export table exim_employee_n2 to 'ql/test/data/exports/exim_employee';
+drop table exim_employee_n2;
create database importer;
use importer;
@@ -23,17 +23,17 @@ use importer;
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/tablestore/exim_employee/temp;
dfs -rmr target/tmp/ql/test/data/tablestore/exim_employee;
-import external table exim_employee
+import external table exim_employee_n2
from 'ql/test/data/exports/exim_employee'
location 'ql/test/data/tablestore/exim_employee';
-describe extended exim_employee;
-show table extended like exim_employee;
-show table extended like exim_employee partition (emp_country="in", emp_state="tn");
-show table extended like exim_employee partition (emp_country="in", emp_state="ka");
+describe extended exim_employee_n2;
+show table extended like exim_employee_n2;
+show table extended like exim_employee_n2 partition (emp_country="in", emp_state="tn");
+show table extended like exim_employee_n2 partition (emp_country="in", emp_state="ka");
dfs -rmr target/tmp/ql/test/data/exports/exim_employee;
-select * from exim_employee;
+select * from exim_employee_n2;
dfs -rmr target/tmp/ql/test/data/tablestore/exim_employee;
-select * from exim_employee;
-drop table exim_employee;
+select * from exim_employee_n2;
+drop table exim_employee_n2;
drop database importer;
http://git-wip-us.apache.org/repos/asf/hive/blob/9bf28a3c/ql/src/test/queries/clientpositive/exim_19_part_external_location.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/exim_19_part_external_location.q b/ql/src/test/queries/clientpositive/exim_19_part_external_location.q
index 389b983..8f8d7eb 100644
--- a/ql/src/test/queries/clientpositive/exim_19_part_external_location.q
+++ b/ql/src/test/queries/clientpositive/exim_19_part_external_location.q
@@ -1,25 +1,25 @@
set hive.mapred.mode=nonstrict;
set hive.test.mode=true;
set hive.test.mode.prefix=;
-set hive.test.mode.nosamplelist=exim_department,exim_employee;
+set hive.test.mode.nosamplelist=exim_department,exim_employee_n13;
-create table exim_employee ( emp_id int comment "employee id")
+create table exim_employee_n13 ( emp_id int comment "employee id")
comment "employee table"
partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
stored as textfile
tblproperties("creator"="krishna");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="in", emp_state="tn");
+ into table exim_employee_n13 partition (emp_country="in", emp_state="tn");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="in", emp_state="ka");
+ into table exim_employee_n13 partition (emp_country="in", emp_state="ka");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="us", emp_state="tn");
+ into table exim_employee_n13 partition (emp_country="us", emp_state="tn");
load data local inpath "../../data/files/test.dat"
- into table exim_employee partition (emp_country="us", emp_state="ka");
+ into table exim_employee_n13 partition (emp_country="us", emp_state="ka");
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/exports/exim_employee/temp;
dfs -rmr target/tmp/ql/test/data/exports/exim_employee;
-export table exim_employee to 'ql/test/data/exports/exim_employee';
-drop table exim_employee;
+export table exim_employee_n13 to 'ql/test/data/exports/exim_employee';
+drop table exim_employee_n13;
create database importer;
use importer;
@@ -27,16 +27,16 @@ use importer;
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/tablestore/exim_employee/temp;
dfs -rmr target/tmp/ql/test/data/tablestore/exim_employee;
-import external table exim_employee partition (emp_country="us", emp_state="tn")
+import external table exim_employee_n13 partition (emp_country="us", emp_state="tn")
from 'ql/test/data/exports/exim_employee'
location 'ql/test/data/tablestore/exim_employee';
-describe extended exim_employee;
-show table extended like exim_employee;
-show table extended like exim_employee partition (emp_country="us", emp_state="tn");
+describe extended exim_employee_n13;
+show table extended like exim_employee_n13;
+show table extended like exim_employee_n13 partition (emp_country="us", emp_state="tn");
dfs -rmr target/tmp/ql/test/data/exports/exim_employee;
-select * from exim_employee;
+select * from exim_employee_n13;
dfs -rmr target/tmp/ql/test/data/tablestore/exim_employee;
-select * from exim_employee;
-drop table exim_employee;
+select * from exim_employee_n13;
+drop table exim_employee_n13;
drop database importer;