spark-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From r...@apache.org
Subject [4/8] spark git commit: [SPARK-14770][SQL] Remove unused queries in hive module test resources
Date Wed, 20 Apr 2016 23:30:30 GMT
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/groupby_grouping_sets7.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/groupby_grouping_sets7.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/groupby_grouping_sets7.q
deleted file mode 100644
index 6c9d513..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/groupby_grouping_sets7.q
+++ /dev/null
@@ -1,10 +0,0 @@
-set hive.new.job.grouping.set.cardinality=2;
-set hive.map.aggr=true;
-set hive.groupby.skewindata=true;
-
-CREATE TABLE T1(a STRING, b STRING, c STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY ' ' STORED AS TEXTFILE; 
-
--- Since 4 grouping sets would be generated for the query below, an additional MR job should be created
--- This is not allowed with map-side aggregation and skew
-SELECT a, b, count(1) from T1 group by a, b with cube;
-

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/groupby_invalid_position.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/groupby_invalid_position.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/groupby_invalid_position.q
deleted file mode 100644
index 173a752..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/groupby_invalid_position.q
+++ /dev/null
@@ -1,4 +0,0 @@
-set hive.groupby.orderby.position.alias=true;
-
--- invalid position alias in group by
-SELECT src.key, sum(substr(src.value,5)) FROM src GROUP BY 3;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/groupby_key.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/groupby_key.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/groupby_key.q
deleted file mode 100644
index 2097015..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/groupby_key.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT concat(value, concat(value)) FROM src GROUP BY concat(value);

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/groupby_rollup1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/groupby_rollup1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/groupby_rollup1.q
deleted file mode 100644
index 6366744..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/groupby_rollup1.q
+++ /dev/null
@@ -1,4 +0,0 @@
-set hive.map.aggr=false;
-
-SELECT key, value, count(1) FROM src GROUP BY key, value with rollup;
-

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/groupby_rollup2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/groupby_rollup2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/groupby_rollup2.q
deleted file mode 100644
index aa19b52..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/groupby_rollup2.q
+++ /dev/null
@@ -1,4 +0,0 @@
-set hive.map.aggr=true;
-
-SELECT key, value, count(key) FROM src GROUP BY key, value with rollup;
-

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/having1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/having1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/having1.q
deleted file mode 100644
index 71f4fd1..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/having1.q
+++ /dev/null
@@ -1,2 +0,0 @@
-EXPLAIN SELECT * FROM src HAVING key > 300;
-SELECT * FROM src HAVING key > 300;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/illegal_partition_type.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/illegal_partition_type.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/illegal_partition_type.q
deleted file mode 100644
index 1ab828c..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/illegal_partition_type.q
+++ /dev/null
@@ -1,7 +0,0 @@
--- begin part(string, int) pass(string, string)
-CREATE TABLE tab1 (id1 int,id2 string) PARTITIONED BY(month string,day int) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' ;
-LOAD DATA LOCAL INPATH '../../data/files/T1.txt' overwrite into table tab1 PARTITION(month='June', day='second');
-
-select * from tab1;
-drop table tab1;
-

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/illegal_partition_type2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/illegal_partition_type2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/illegal_partition_type2.q
deleted file mode 100644
index 2438288..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/illegal_partition_type2.q
+++ /dev/null
@@ -1,3 +0,0 @@
-create table tab1 (id1 int, id2 string) PARTITIONED BY(month string,day int) row format delimited fields terminated by ',';
-alter table tab1 add partition (month='June', day='second');
-drop table tab1;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/illegal_partition_type3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/illegal_partition_type3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/illegal_partition_type3.q
deleted file mode 100644
index 49e6a09..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/illegal_partition_type3.q
+++ /dev/null
@@ -1,4 +0,0 @@
-create table tab1(c int) partitioned by (i int);
-alter table tab1 add partition(i = "some name");
-
-drop table tab1;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/illegal_partition_type4.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/illegal_partition_type4.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/illegal_partition_type4.q
deleted file mode 100644
index 50f486e..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/illegal_partition_type4.q
+++ /dev/null
@@ -1,3 +0,0 @@
-create table tab1(s string) PARTITIONED BY(dt date, st string);
-alter table tab1 add partition (dt=date 'foo', st='foo');
-drop table tab1;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/index_bitmap_no_map_aggr.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/index_bitmap_no_map_aggr.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/index_bitmap_no_map_aggr.q
deleted file mode 100644
index a17cd1f..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/index_bitmap_no_map_aggr.q
+++ /dev/null
@@ -1,7 +0,0 @@
-EXPLAIN
-CREATE INDEX src1_index ON TABLE src(key) as 'BITMAP' WITH DEFERRED REBUILD;
-
-SET hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
-SET hive.map.aggr=false;
-CREATE INDEX src1_index ON TABLE src(key) as 'BITMAP' WITH DEFERRED REBUILD;
-ALTER INDEX src1_index ON src REBUILD;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/index_compact_entry_limit.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/index_compact_entry_limit.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/index_compact_entry_limit.q
deleted file mode 100644
index 5bb889c..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/index_compact_entry_limit.q
+++ /dev/null
@@ -1,12 +0,0 @@
-set hive.stats.dbclass=fs;
-drop index src_index on src;
-
-CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD;
-ALTER INDEX src_index ON src REBUILD;
-
-SET hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
-INSERT OVERWRITE DIRECTORY "${system:test.tmp.dir}/index_result" SELECT `_bucketname` ,  `_offsets` FROM default__src_src_index__ WHERE key<1000;
-SET hive.index.compact.file=${system:test.tmp.dir}/index_result;
-SET hive.input.format=org.apache.hadoop.hive.ql.index.compact.HiveCompactIndexInputFormat;
-SET hive.index.compact.query.max.entries=5;
-SELECT key, value FROM src WHERE key=100 ORDER BY key;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/index_compact_size_limit.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/index_compact_size_limit.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/index_compact_size_limit.q
deleted file mode 100644
index c6600e6..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/index_compact_size_limit.q
+++ /dev/null
@@ -1,13 +0,0 @@
-set hive.stats.dbclass=fs;
-drop index src_index on src;
-
-CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD;
-ALTER INDEX src_index ON src REBUILD;
-
-SET hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
-INSERT OVERWRITE DIRECTORY "${system:test.tmp.dir}/index_result" SELECT `_bucketname` ,  `_offsets` FROM default__src_src_index__ WHERE key<1000;
-SET hive.index.compact.file=${system:test.tmp.dir}/index_result;
-SET hive.input.format=org.apache.hadoop.hive.ql.index.compact.HiveCompactIndexInputFormat;
-SET hive.index.compact.query.max.size=1024;
-SELECT key, value FROM src WHERE key=100 ORDER BY key;
-

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/input1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/input1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/input1.q
deleted file mode 100644
index 92a6791..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/input1.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT a.* FROM src; 

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/input2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/input2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/input2.q
deleted file mode 100644
index 0fe907d..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/input2.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT a.key FROM src; 

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/input4.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/input4.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/input4.q
deleted file mode 100644
index 60aea32..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/input4.q
+++ /dev/null
@@ -1,5 +0,0 @@
-set hive.mapred.mode=strict;
-
-select * from srcpart a join
-  (select b.key, count(1) as count from srcpart b where b.ds = '2008-04-08' and b.hr = '14' group by b.key) subq
-  where a.ds = '2008-04-08' and a.hr = '11' limit 10;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/input41.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/input41.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/input41.q
deleted file mode 100644
index 872ab10..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/input41.q
+++ /dev/null
@@ -1,5 +0,0 @@
-select * from 
-  (select * from src 
-    union all
-   select * from srcpart where ds = '2009-08-09'
-  )x;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/input_part0_neg.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/input_part0_neg.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/input_part0_neg.q
deleted file mode 100644
index 4656693..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/input_part0_neg.q
+++ /dev/null
@@ -1,3 +0,0 @@
-set hive.mapred.mode=strict;
-
-SELECT x.* FROM SRCPART x WHERE key = '2008-04-08';

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_into1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_into1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_into1.q
deleted file mode 100644
index 8c19767..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_into1.q
+++ /dev/null
@@ -1,11 +0,0 @@
-set hive.lock.numretries=5;
-set hive.lock.sleep.between.retries=5;
-
-DROP TABLE insert_into1_neg;
-
-CREATE TABLE insert_into1_neg (key int, value string);
-
-LOCK TABLE insert_into1_neg SHARED;
-INSERT INTO TABLE insert_into1_neg SELECT * FROM src LIMIT 100;
-
-DROP TABLE insert_into1_neg;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_into2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_into2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_into2.q
deleted file mode 100644
index 73a3b6f..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_into2.q
+++ /dev/null
@@ -1,10 +0,0 @@
-set hive.lock.numretries=5;
-set hive.lock.sleep.between.retries=5;
-
-DROP TABLE insert_into1_neg;
-CREATE TABLE insert_into1_neg (key int, value string);
-
-LOCK TABLE insert_into1_neg EXCLUSIVE;
-INSERT INTO TABLE insert_into1_neg SELECT * FROM src LIMIT 100;
-
-DROP TABLE insert_into1_neg;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_into3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_into3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_into3.q
deleted file mode 100644
index 4d048b3..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_into3.q
+++ /dev/null
@@ -1,16 +0,0 @@
-set hive.lock.numretries=5;
-set hive.lock.sleep.between.retries=5;
-
-DROP TABLE insert_into3_neg;
-
-CREATE TABLE insert_into3_neg (key int, value string) 
-  PARTITIONED BY (ds string);
-
-INSERT INTO TABLE insert_into3_neg PARTITION (ds='1') 
-  SELECT * FROM src LIMIT 100;
-
-LOCK TABLE insert_into3_neg PARTITION (ds='1') SHARED;
-INSERT INTO TABLE insert_into3_neg PARTITION (ds='1') 
-  SELECT * FROM src LIMIT 100;
-
-DROP TABLE insert_into3_neg;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_into4.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_into4.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_into4.q
deleted file mode 100644
index b8944e7..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_into4.q
+++ /dev/null
@@ -1,16 +0,0 @@
-set hive.lock.numretries=5;
-set hive.lock.sleep.between.retries=5;
-
-DROP TABLE insert_into3_neg;
-
-CREATE TABLE insert_into3_neg (key int, value string) 
-  PARTITIONED BY (ds string);
-
-INSERT INTO TABLE insert_into3_neg PARTITION (ds='1') 
-  SELECT * FROM src LIMIT 100;
-
-LOCK TABLE insert_into3_neg PARTITION (ds='1') EXCLUSIVE;
-INSERT INTO TABLE insert_into3_neg PARTITION (ds='1') 
-  SELECT * FROM src LIMIT 100;
-
-DROP TABLE insert_into3_neg;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_into5.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_into5.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_into5.q
deleted file mode 100644
index c20c168..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_into5.q
+++ /dev/null
@@ -1,9 +0,0 @@
-DROP TABLE if exists insert_into5_neg;
-
-CREATE TABLE insert_into5_neg (key int, value string) TBLPROPERTIES ("immutable"="true");
-
-INSERT INTO TABLE insert_into5_neg SELECT * FROM src LIMIT 100;
-
-INSERT INTO TABLE insert_into5_neg SELECT * FROM src LIMIT 100;
-
-DROP TABLE insert_into5_neg;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_into6.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_into6.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_into6.q
deleted file mode 100644
index a92ee5c..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_into6.q
+++ /dev/null
@@ -1,17 +0,0 @@
-DROP TABLE IF EXISTS insert_into6_neg;
-
-CREATE TABLE insert_into6_neg (key int, value string)
-  PARTITIONED BY (ds string) TBLPROPERTIES("immutable"="true") ;
-
-INSERT INTO TABLE insert_into6_neg PARTITION (ds='1')
-  SELECT * FROM src LIMIT 100;
-
-INSERT INTO TABLE insert_into6_neg PARTITION (ds='2')
-  SELECT * FROM src LIMIT 100;
-
-SELECT COUNT(*) from insert_into6_neg;
-
-INSERT INTO TABLE insert_into6_neg PARTITION (ds='1')
-  SELECT * FROM src LIMIT 100;
-
-DROP TABLE insert_into6_neg;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_view_failure.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_view_failure.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_view_failure.q
deleted file mode 100644
index 1f5e139..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insert_view_failure.q
+++ /dev/null
@@ -1,5 +0,0 @@
-DROP VIEW xxx2;
-CREATE VIEW xxx2 AS SELECT * FROM src;
-INSERT OVERWRITE TABLE xxx2
-SELECT key, value
-FROM src;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insertexternal1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insertexternal1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insertexternal1.q
deleted file mode 100644
index 01ebae1..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insertexternal1.q
+++ /dev/null
@@ -1,8 +0,0 @@
-set hive.insert.into.external.tables=false;
-
-
-create external table texternal(key string, val string) partitioned by (insertdate string);
-
-alter table texternal add partition (insertdate='2008-01-01') location 'pfile://${system:test.tmp.dir}/texternal/2008-01-01';
-from src insert overwrite table texternal partition (insertdate='2008-01-01') select *;
-

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insertover_dynapart_ifnotexists.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insertover_dynapart_ifnotexists.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insertover_dynapart_ifnotexists.q
deleted file mode 100644
index a8f77c2..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/insertover_dynapart_ifnotexists.q
+++ /dev/null
@@ -1,9 +0,0 @@
-set hive.exec.dynamic.partition=true;
-
-create table srcpart_dp like srcpart;
-
-create table destpart_dp like srcpart;
-
-load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcpart_dp partition(ds='2008-04-08', hr=11);
-
-insert overwrite table destpart_dp partition (ds='2008-04-08', hr) if not exists select key, value, hr from srcpart_dp where ds='2008-04-08';
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_arithmetic_type.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_arithmetic_type.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_arithmetic_type.q
deleted file mode 100644
index ad37cff..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_arithmetic_type.q
+++ /dev/null
@@ -1,3 +0,0 @@
-
-select timestamp('2001-01-01 00:00:01') - timestamp('2000-01-01 00:00:01') from src;
-

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_avg_syntax.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_avg_syntax.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_avg_syntax.q
deleted file mode 100644
index d5b58e0..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_avg_syntax.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT avg(*) FROM src;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_from_binary_1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_from_binary_1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_from_binary_1.q
deleted file mode 100644
index 73e4729..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_from_binary_1.q
+++ /dev/null
@@ -1,2 +0,0 @@
-create table tbl (a binary);
-select cast (a as int) from tbl limit 1;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_from_binary_2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_from_binary_2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_from_binary_2.q
deleted file mode 100644
index 50ec481..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_from_binary_2.q
+++ /dev/null
@@ -1,2 +0,0 @@
-create table tbl (a binary);
-select cast (a as tinyint) from tbl limit 1;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_from_binary_3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_from_binary_3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_from_binary_3.q
deleted file mode 100644
index 16f56ec..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_from_binary_3.q
+++ /dev/null
@@ -1,2 +0,0 @@
-create table tbl (a binary);
-select cast (a as smallint) from tbl limit 1;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_from_binary_4.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_from_binary_4.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_from_binary_4.q
deleted file mode 100644
index bd222f1..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_from_binary_4.q
+++ /dev/null
@@ -1,2 +0,0 @@
-create table tbl (a binary);
-select cast (a as bigint) from tbl limit 1;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_from_binary_5.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_from_binary_5.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_from_binary_5.q
deleted file mode 100644
index 594fd2b..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_from_binary_5.q
+++ /dev/null
@@ -1,2 +0,0 @@
-create table tbl (a binary);
-select cast (a as float) from tbl limit 1;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_from_binary_6.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_from_binary_6.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_from_binary_6.q
deleted file mode 100644
index 40ff801..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_from_binary_6.q
+++ /dev/null
@@ -1,2 +0,0 @@
-create table tbl (a binary);
-select cast (a as double) from tbl limit 1;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_to_binary_1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_to_binary_1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_to_binary_1.q
deleted file mode 100644
index 00cd98e..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_to_binary_1.q
+++ /dev/null
@@ -1 +0,0 @@
-select cast (2 as binary) from src limit 1;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_to_binary_2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_to_binary_2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_to_binary_2.q
deleted file mode 100644
index f31344f..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_to_binary_2.q
+++ /dev/null
@@ -1 +0,0 @@
-select cast(cast (2 as smallint) as binary) from src limit 1;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_to_binary_3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_to_binary_3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_to_binary_3.q
deleted file mode 100644
index af23d29..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_to_binary_3.q
+++ /dev/null
@@ -1 +0,0 @@
-select cast(cast (2 as tinyint) as binary)  from src limit 1;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_to_binary_4.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_to_binary_4.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_to_binary_4.q
deleted file mode 100644
index 91abe1e..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_to_binary_4.q
+++ /dev/null
@@ -1 +0,0 @@
-select cast(cast (2 as bigint) as binary) from src limit 1;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_to_binary_5.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_to_binary_5.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_to_binary_5.q
deleted file mode 100644
index afd99be..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_to_binary_5.q
+++ /dev/null
@@ -1 +0,0 @@
-select cast(cast (2 as float) as binary)  from src limit 1;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_to_binary_6.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_to_binary_6.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_to_binary_6.q
deleted file mode 100644
index c2143c5..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_cast_to_binary_6.q
+++ /dev/null
@@ -1 +0,0 @@
-select cast(cast (2 as double) as binary)  from src limit 1;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_char_length_1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_char_length_1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_char_length_1.q
deleted file mode 100644
index ba7d164..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_char_length_1.q
+++ /dev/null
@@ -1,2 +0,0 @@
-drop table invalid_char_length_1;
-create table invalid_char_length_1 (c1 char(1000000));

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_char_length_2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_char_length_2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_char_length_2.q
deleted file mode 100644
index 866b43d..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_char_length_2.q
+++ /dev/null
@@ -1 +0,0 @@
-select cast(value as char(100000)) from src limit 1;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_char_length_3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_char_length_3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_char_length_3.q
deleted file mode 100644
index 481b630..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_char_length_3.q
+++ /dev/null
@@ -1,3 +0,0 @@
-drop table invalid_char_length_3;
-create table invalid_char_length_3 (c1 char(0));
-

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_config1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_config1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_config1.q
deleted file mode 100644
index c49ac8a..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_config1.q
+++ /dev/null
@@ -1,3 +0,0 @@
-set mapred.input.dir.recursive=true;
-
-CREATE TABLE skewedtable (key STRING, value STRING) SKEWED BY (key) ON (1,5,6);

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_config2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_config2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_config2.q
deleted file mode 100644
index fa023c8..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_config2.q
+++ /dev/null
@@ -1,4 +0,0 @@
-set hive.mapred.supports.subdirectories=false;
-set hive.optimize.union.remove=true;
-
-select count(1) from src;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_create_tbl1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_create_tbl1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_create_tbl1.q
deleted file mode 100644
index 2e1ea6b..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_create_tbl1.q
+++ /dev/null
@@ -1,9 +0,0 @@
-
-CREATE TABLE inv_valid_tbl1 COMMENT 'This is a thrift based table'
-    PARTITIONED BY(aint DATETIME, country STRING)
-    CLUSTERED BY(aint) SORTED BY(lint) INTO 32 BUCKETS
-    ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.thrift.ThriftDeserializer'
-    WITH SERDEPROPERTIES ('serialization.class' = 'org.apache.hadoop.hive.serde2.thrift.test.Complex',
-                          'serialization.format' = 'org.apache.thrift.protocol.TBinaryProtocol')
-    STORED AS SEQUENCEFILE;
-DESCRIBE EXTENDED inv_valid_tbl1;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_create_tbl2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_create_tbl2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_create_tbl2.q
deleted file mode 100644
index 408919e..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_create_tbl2.q
+++ /dev/null
@@ -1 +0,0 @@
-create tabl tmp_zshao_22 (id int, name strin;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_mapjoin1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_mapjoin1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_mapjoin1.q
deleted file mode 100644
index 56d9211..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_mapjoin1.q
+++ /dev/null
@@ -1 +0,0 @@
-select /*+ MAPJOIN(a) ,MAPJOIN(b)*/ * from src a join src b on (a.key=b.key and a.value=b.value);

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_max_syntax.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_max_syntax.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_max_syntax.q
deleted file mode 100644
index 2003373..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_max_syntax.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT max(*) FROM src;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_min_syntax.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_min_syntax.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_min_syntax.q
deleted file mode 100644
index 584283a..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_min_syntax.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT min(*) FROM src;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_select_column.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_select_column.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_select_column.q
deleted file mode 100644
index 106ba42..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_select_column.q
+++ /dev/null
@@ -1,4 +0,0 @@
--- Create table
-create table if not exists test_invalid_column(key string, value string ) partitioned by (year string, month string) stored as textfile ;
-
-select * from test_invalid_column  where column1=123;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_select_column_with_subquery.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_select_column_with_subquery.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_select_column_with_subquery.q
deleted file mode 100644
index bc70dbc..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_select_column_with_subquery.q
+++ /dev/null
@@ -1,4 +0,0 @@
--- Create table
-create table if not exists test_invalid_column(key string, value string ) partitioned by (year string, month string) stored as textfile ;
-
-select * from (select * from test_invalid_column) subq where subq = 123;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_select_column_with_tablename.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_select_column_with_tablename.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_select_column_with_tablename.q
deleted file mode 100644
index b821e61..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_select_column_with_tablename.q
+++ /dev/null
@@ -1,4 +0,0 @@
--- Create table
-create table if not exists test_invalid_column(key string, value string ) partitioned by (year string, month string) stored as textfile ;
-
-select * from test_invalid_column  where test_invalid_column=123;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_select_expression.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_select_expression.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_select_expression.q
deleted file mode 100644
index 01617f9..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_select_expression.q
+++ /dev/null
@@ -1 +0,0 @@
-select foo from a a where foo > .foo;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_std_syntax.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_std_syntax.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_std_syntax.q
deleted file mode 100644
index 1310419..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_std_syntax.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT std(*) FROM src;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_stddev_samp_syntax.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_stddev_samp_syntax.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_stddev_samp_syntax.q
deleted file mode 100644
index c6a1252..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_stddev_samp_syntax.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT stddev_samp(*) FROM src;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_sum_syntax.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_sum_syntax.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_sum_syntax.q
deleted file mode 100644
index 2d591ba..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_sum_syntax.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT sum(*) FROM src;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_t_alter1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_t_alter1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_t_alter1.q
deleted file mode 100644
index bb19cff..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_t_alter1.q
+++ /dev/null
@@ -1,2 +0,0 @@
-CREATE TABLE alter_test (d STRING);
-ALTER TABLE alter_test CHANGE d d DATETIME;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_t_alter2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_t_alter2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_t_alter2.q
deleted file mode 100644
index aa01b35..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_t_alter2.q
+++ /dev/null
@@ -1,2 +0,0 @@
-CREATE TABLE alter_test (d STRING);
-ALTER TABLE alter_test ADD COLUMNS (ds DATETIME);

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_t_create2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_t_create2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_t_create2.q
deleted file mode 100644
index 978f424..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_t_create2.q
+++ /dev/null
@@ -1 +0,0 @@
-CREATE TABLE datetime_test (d DATETIME);

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_t_transform.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_t_transform.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_t_transform.q
deleted file mode 100644
index dfc4864..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_t_transform.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT TRANSFORM(*) USING 'cat' AS (key DATETIME) FROM src;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_tbl_name.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_tbl_name.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_tbl_name.q
deleted file mode 100644
index 09394e7..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_tbl_name.q
+++ /dev/null
@@ -1 +0,0 @@
-create table invalid-name(a int, b string);

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_var_samp_syntax.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_var_samp_syntax.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_var_samp_syntax.q
deleted file mode 100644
index ce2a8c4..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_var_samp_syntax.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT var_samp(*) FROM src;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_varchar_length_1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_varchar_length_1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_varchar_length_1.q
deleted file mode 100644
index 43de018..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_varchar_length_1.q
+++ /dev/null
@@ -1,2 +0,0 @@
-drop table if exists invalid_varchar_length_1;
-create table invalid_varchar_length_1 (c1 varchar(1000000));

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_varchar_length_2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_varchar_length_2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_varchar_length_2.q
deleted file mode 100644
index 3c199d3..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_varchar_length_2.q
+++ /dev/null
@@ -1 +0,0 @@
-select cast(value as varchar(100000)) from src limit 1;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_varchar_length_3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_varchar_length_3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_varchar_length_3.q
deleted file mode 100644
index fed0476..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_varchar_length_3.q
+++ /dev/null
@@ -1,3 +0,0 @@
-drop table if exists invalid_varchar_length_3;
-create table invalid_varchar_length_3 (c1 varchar(0));
-

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_variance_syntax.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_variance_syntax.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_variance_syntax.q
deleted file mode 100644
index 5b47829..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalid_variance_syntax.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT variance(*) FROM src;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalidate_view1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalidate_view1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalidate_view1.q
deleted file mode 100644
index dd39c5e..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/invalidate_view1.q
+++ /dev/null
@@ -1,11 +0,0 @@
-DROP VIEW xxx8;
-DROP VIEW xxx9;
-
--- create two levels of view reference, then invalidate intermediate view
--- by dropping a column from underlying table, and verify that
--- querying outermost view results in full error context
-CREATE TABLE xxx10 (key int, value int);
-CREATE VIEW xxx9 AS SELECT * FROM xxx10;
-CREATE VIEW xxx8 AS SELECT * FROM xxx9 xxx;
-ALTER TABLE xxx10 REPLACE COLUMNS (key int);
-SELECT * FROM xxx8 yyy;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join2.q
deleted file mode 100644
index 98a5f1e..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join2.q
+++ /dev/null
@@ -1,5 +0,0 @@
-SELECT /*+ MAPJOIN(x) */ x.key, x.value, y.value
-FROM src1 x LEFT OUTER JOIN src y ON (x.key = y.key);
-
-
-

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join28.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join28.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join28.q
deleted file mode 100644
index 32ff105..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join28.q
+++ /dev/null
@@ -1,15 +0,0 @@
-CREATE TABLE dest_j1(key STRING, value STRING) STORED AS TEXTFILE;
-
--- Mapjoin followed by mapjoin is not supported.
--- The same query would work fine without the hint.
--- Note that there is a positive test with the same name in clientpositive
-EXPLAIN
-INSERT OVERWRITE TABLE dest_j1 
-SELECT /*+ MAPJOIN(z) */ subq.key1, z.value
-FROM
-(SELECT /*+ MAPJOIN(x) */ x.key as key1, x.value as value1, y.key as key2, y.value as value2 
- FROM src1 x JOIN src y ON (x.key = y.key)) subq
- JOIN srcpart z ON (subq.key1 = z.key and z.ds='2008-04-08' and z.hr=11);
-
-
-

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join29.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join29.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join29.q
deleted file mode 100644
index 53a1652..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join29.q
+++ /dev/null
@@ -1,10 +0,0 @@
-CREATE TABLE dest_j1(key STRING, cnt1 INT, cnt2 INT);
-
--- Mapjoin followed by group by is not supported.
--- The same query would work without the hint
--- Note that there is a positive test with the same name in clientpositive
-EXPLAIN 
-INSERT OVERWRITE TABLE dest_j1 
-SELECT /*+ MAPJOIN(subq1) */ subq1.key, subq1.cnt, subq2.cnt
-FROM (select x.key, count(1) as cnt from src1 x group by x.key) subq1 JOIN 
-     (select y.key, count(1) as cnt from src y group by y.key) subq2 ON (subq1.key = subq2.key);

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join32.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join32.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join32.q
deleted file mode 100644
index 54a4dcd..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join32.q
+++ /dev/null
@@ -1,14 +0,0 @@
-CREATE TABLE dest_j1(key STRING, value STRING, val2 STRING) STORED AS TEXTFILE;
-
--- Mapjoin followed by Mapjoin is not supported.
--- The same query would work without the hint
--- Note that there is a positive test with the same name in clientpositive
-EXPLAIN EXTENDED
-INSERT OVERWRITE TABLE dest_j1
-SELECT /*+ MAPJOIN(x,z) */ x.key, z.value, y.value
-FROM src1 x JOIN src y ON (x.key = y.key) 
-JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11);
-
-
-
-

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join35.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join35.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join35.q
deleted file mode 100644
index fc8f77c..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join35.q
+++ /dev/null
@@ -1,18 +0,0 @@
-CREATE TABLE dest_j1(key STRING, value STRING, val2 INT) STORED AS TEXTFILE;
-
--- Mapjoin followed by union is not supported.
--- The same query would work without the hint
--- Note that there is a positive test with the same name in clientpositive
-EXPLAIN EXTENDED
-INSERT OVERWRITE TABLE dest_j1
-SELECT /*+ MAPJOIN(x) */ x.key, x.value, subq1.cnt
-FROM 
-( SELECT x.key as key, count(1) as cnt from src x where x.key < 20 group by x.key
-     UNION ALL
-  SELECT x1.key as key, count(1) as cnt from src x1 where x1.key > 100 group by x1.key
-) subq1
-JOIN src1 x ON (x.key = subq1.key);
-
-
-
-

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join_alt_syntax_comma_on.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join_alt_syntax_comma_on.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join_alt_syntax_comma_on.q
deleted file mode 100644
index e39a38e..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join_alt_syntax_comma_on.q
+++ /dev/null
@@ -1,3 +0,0 @@
-explain select *
-from src s1 , 
-src s2 on s1.key = s2.key;
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join_cond_unqual_ambiguous.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join_cond_unqual_ambiguous.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join_cond_unqual_ambiguous.q
deleted file mode 100644
index c0da913..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join_cond_unqual_ambiguous.q
+++ /dev/null
@@ -1,6 +0,0 @@
-
-
-explain select s1.key, s2.key
-from src s1, src s2
-where key = s2.key
-;
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join_cond_unqual_ambiguous_vc.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join_cond_unqual_ambiguous_vc.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join_cond_unqual_ambiguous_vc.q
deleted file mode 100644
index 8e21963..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join_cond_unqual_ambiguous_vc.q
+++ /dev/null
@@ -1,5 +0,0 @@
-
-explain select s1.key, s2.key
-from src s1, src s2
-where INPUT__FILE__NAME = s2.INPUT__FILE__NAME
-;
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join_nonexistent_part.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join_nonexistent_part.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join_nonexistent_part.q
deleted file mode 100644
index b4a4757..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/join_nonexistent_part.q
+++ /dev/null
@@ -1,4 +0,0 @@
-SET hive.security.authorization.enabled = true;
-SELECT *
-FROM srcpart s1 join src s2 on s1.key == s2.key
-WHERE s1.ds='non-existent';
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/joinneg.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/joinneg.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/joinneg.q
deleted file mode 100644
index a4967fd..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/joinneg.q
+++ /dev/null
@@ -1,6 +0,0 @@
-EXPLAIN FROM 
-(SELECT src.* FROM src) x
-JOIN 
-(SELECT src.* FROM src) Y
-ON (x.key = b.key)
-SELECT Y.*;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lateral_view_alias.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lateral_view_alias.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lateral_view_alias.q
deleted file mode 100644
index 50d535e..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lateral_view_alias.q
+++ /dev/null
@@ -1,3 +0,0 @@
--- Check alias count for LATERAL VIEW syntax:
--- explode returns a table with only 1 col - should be an error if query specifies >1 col aliases
-SELECT * FROM src LATERAL VIEW explode(array(1,2,3)) myTable AS myCol1, myCol2 LIMIT 3;
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lateral_view_join.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lateral_view_join.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lateral_view_join.q
deleted file mode 100644
index 818754e..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lateral_view_join.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT src.key FROM src LATERAL VIEW explode(array(1,2,3)) AS myTable JOIN src b ON src.key;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/limit_partition.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/limit_partition.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/limit_partition.q
deleted file mode 100644
index d593945..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/limit_partition.q
+++ /dev/null
@@ -1,7 +0,0 @@
-set hive.limit.query.max.table.partition=1;
-
-explain select * from srcpart limit 1;
-select * from srcpart limit 1;
-
-explain select * from srcpart;
-select * from srcpart;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/limit_partition_stats.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/limit_partition_stats.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/limit_partition_stats.q
deleted file mode 100644
index 0afd4a9..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/limit_partition_stats.q
+++ /dev/null
@@ -1,18 +0,0 @@
-set hive.exec.dynamic.partition=true;
-set hive.exec.dynamic.partition.mode=nonstrict;
-set hive.stats.autogather=true;
-set hive.compute.query.using.stats=true;
-
-create table part (c int) partitioned by (d string);
-insert into table part partition (d)
-select hr,ds from srcpart;
-
-set hive.limit.query.max.table.partition=1;
-
-explain select count(*) from part;
-select count(*) from part;
-
-set hive.compute.query.using.stats=false;
-
-explain select count(*) from part;
-select count(*) from part;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/line_terminator.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/line_terminator.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/line_terminator.q
deleted file mode 100644
index ad3542c..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/line_terminator.q
+++ /dev/null
@@ -1,3 +0,0 @@
-CREATE TABLE mytable (col1 STRING, col2 INT)
-ROW FORMAT DELIMITED
-LINES TERMINATED BY ',';

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_exist_part_authfail.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_exist_part_authfail.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_exist_part_authfail.q
deleted file mode 100644
index eb72d94..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_exist_part_authfail.q
+++ /dev/null
@@ -1,4 +0,0 @@
-create table hive_test_src ( col1 string ) partitioned by (pcol1 string) stored as textfile;
-alter table hive_test_src add partition (pcol1 = 'test_part');
-set hive.security.authorization.enabled=true;
-load data local inpath '../../data/files/test.dat' overwrite into table hive_test_src partition (pcol1 = 'test_part');

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_non_native.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_non_native.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_non_native.q
deleted file mode 100644
index 75a5216..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_non_native.q
+++ /dev/null
@@ -1,5 +0,0 @@
-
-CREATE TABLE non_native2(key int, value string) 
-STORED BY 'org.apache.hadoop.hive.ql.metadata.DefaultStorageHandler';
-
-LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE non_native2;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_nonpart_authfail.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_nonpart_authfail.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_nonpart_authfail.q
deleted file mode 100644
index 3265363..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_nonpart_authfail.q
+++ /dev/null
@@ -1,3 +0,0 @@
-create table hive_test_src ( col1 string ) stored as textfile;
-set hive.security.authorization.enabled=true;
-load data local inpath '../../data/files/test.dat' overwrite into table hive_test_src ;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_part_authfail.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_part_authfail.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_part_authfail.q
deleted file mode 100644
index 315988d..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_part_authfail.q
+++ /dev/null
@@ -1,3 +0,0 @@
-create table hive_test_src ( col1 string ) partitioned by (pcol1 string) stored as textfile;
-set hive.security.authorization.enabled=true;
-load data local inpath '../../data/files/test.dat' overwrite into table hive_test_src partition (pcol1 = 'test_part');

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_part_nospec.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_part_nospec.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_part_nospec.q
deleted file mode 100644
index 8151799..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_part_nospec.q
+++ /dev/null
@@ -1,2 +0,0 @@
-create table hive_test_src ( col1 string ) partitioned by (pcol1 string) stored as textfile;
-load data local inpath '../../data/files/test.dat' into table hive_test_src;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_stored_as_dirs.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_stored_as_dirs.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_stored_as_dirs.q
deleted file mode 100644
index c56f0d4..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_stored_as_dirs.q
+++ /dev/null
@@ -1,7 +0,0 @@
-set hive.mapred.supports.subdirectories=true;
-
--- Load data can't work with table with stored as directories
-CREATE TABLE  if not exists stored_as_dirs_multiple (col1 STRING, col2 int, col3 STRING) 
-SKEWED BY (col1, col2) ON (('s1',1), ('s3',3), ('s13',13), ('s78',78))  stored as DIRECTORIES;
-
-LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE stored_as_dirs_multiple;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_view_failure.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_view_failure.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_view_failure.q
deleted file mode 100644
index 64182ea..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_view_failure.q
+++ /dev/null
@@ -1,3 +0,0 @@
-DROP VIEW xxx11;
-CREATE VIEW xxx11 AS SELECT * FROM src;
-LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE xxx11;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_wrong_fileformat.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_wrong_fileformat.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_wrong_fileformat.q
deleted file mode 100644
index f0c3b59..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_wrong_fileformat.q
+++ /dev/null
@@ -1,6 +0,0 @@
--- test for loading into tables with the correct file format
--- test for loading into partitions with the correct file format
-
-
-CREATE TABLE load_wrong_fileformat_T1(name STRING) STORED AS SEQUENCEFILE;
-LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE load_wrong_fileformat_T1;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_wrong_fileformat_rc_seq.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_wrong_fileformat_rc_seq.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_wrong_fileformat_rc_seq.q
deleted file mode 100644
index 4d79bbe..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_wrong_fileformat_rc_seq.q
+++ /dev/null
@@ -1,6 +0,0 @@
--- test for loading into tables with the correct file format
--- test for loading into partitions with the correct file format
-
-
-CREATE TABLE T1(name STRING) STORED AS RCFILE;
-LOAD DATA LOCAL INPATH '../../data/files/kv1.seq' INTO TABLE T1;
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_wrong_fileformat_txt_seq.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_wrong_fileformat_txt_seq.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_wrong_fileformat_txt_seq.q
deleted file mode 100644
index 050c819..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_wrong_fileformat_txt_seq.q
+++ /dev/null
@@ -1,6 +0,0 @@
--- test for loading into tables with the correct file format
--- test for loading into partitions with the correct file format
-
-
-CREATE TABLE T1(name STRING) STORED AS TEXTFILE;
-LOAD DATA LOCAL INPATH '../../data/files/kv1.seq' INTO TABLE T1;
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_wrong_noof_part.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_wrong_noof_part.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_wrong_noof_part.q
deleted file mode 100644
index 7f5ad75..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/load_wrong_noof_part.q
+++ /dev/null
@@ -1,3 +0,0 @@
-
-CREATE TABLE loadpart1(a STRING, b STRING) PARTITIONED BY (ds STRING,ds1 STRING);
-LOAD DATA LOCAL INPATH '../../data1/files/kv1.txt' INTO TABLE loadpart1 PARTITION(ds='2009-05-05');

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/local_mapred_error_cache.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/local_mapred_error_cache.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/local_mapred_error_cache.q
deleted file mode 100644
index ed9e21d..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/local_mapred_error_cache.q
+++ /dev/null
@@ -1,4 +0,0 @@
-set hive.exec.mode.local.auto=true;
-set hive.exec.failure.hooks=org.apache.hadoop.hive.ql.hooks.VerifySessionStateLocalErrorsHook;
-
-FROM src SELECT TRANSFORM(key, value) USING 'python ../../data/scripts/cat_error.py' AS (key, value);

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg1.q
deleted file mode 100644
index e1b58fc..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg1.q
+++ /dev/null
@@ -1,10 +0,0 @@
-drop table tstsrc;
-create table tstsrc like src;
-insert overwrite table tstsrc select key, value from src;
-
-set hive.lock.numretries=0;
-set hive.unlock.numretries=0;
-
-LOCK TABLE tstsrc SHARED;
-LOCK TABLE tstsrc SHARED;
-LOCK TABLE tstsrc EXCLUSIVE;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg2.q
deleted file mode 100644
index a4604cd..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg2.q
+++ /dev/null
@@ -1,6 +0,0 @@
-drop table tstsrc;
-create table tstsrc like src;
-insert overwrite table tstsrc select key, value from src;
-
-set hive.unlock.numretries=0;
-UNLOCK TABLE tstsrc;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg3.q
deleted file mode 100644
index f2252f7..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg3.q
+++ /dev/null
@@ -1,9 +0,0 @@
-drop table tstsrcpart;
-create table tstsrcpart like srcpart;
-
-insert overwrite table tstsrcpart partition (ds='2008-04-08', hr='11')
-select key, value from srcpart where ds='2008-04-08' and hr='11';
-
-set hive.lock.numretries=0;
-set hive.unlock.numretries=0;
-UNLOCK TABLE tstsrcpart PARTITION(ds='2008-04-08', hr='11');

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg4.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg4.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg4.q
deleted file mode 100644
index b47644c..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg4.q
+++ /dev/null
@@ -1,12 +0,0 @@
-drop table tstsrcpart;
-create table tstsrcpart like srcpart;
-
-insert overwrite table tstsrcpart partition (ds='2008-04-08', hr='11')
-select key, value from srcpart where ds='2008-04-08' and hr='11';
-
-set hive.lock.numretries=0;
-set hive.unlock.numretries=0;
-
-LOCK TABLE tstsrcpart PARTITION(ds='2008-04-08', hr='11') EXCLUSIVE;
-SHOW LOCKS tstsrcpart PARTITION(ds='2008-04-08', hr='12');
-

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg5.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg5.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg5.q
deleted file mode 100644
index 19c1ce2..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg5.q
+++ /dev/null
@@ -1,2 +0,0 @@
-drop table tstsrcpart;
-show locks tstsrcpart extended;
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg_query_tbl_in_locked_db.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg_query_tbl_in_locked_db.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg_query_tbl_in_locked_db.q
deleted file mode 100644
index 4966f2b..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg_query_tbl_in_locked_db.q
+++ /dev/null
@@ -1,17 +0,0 @@
-create database lockneg1;
-use lockneg1;
-
-create table tstsrcpart like default.srcpart;
-
-insert overwrite table tstsrcpart partition (ds='2008-04-08', hr='11')
-select key, value from default.srcpart where ds='2008-04-08' and hr='11';
-
-lock database lockneg1 shared;
-show locks database lockneg1;
-select count(1) from tstsrcpart where ds='2008-04-08' and hr='11';
-
-unlock database lockneg1;
-show locks database lockneg1;
-lock database lockneg1 exclusive;
-show locks database lockneg1;
-select count(1) from tstsrcpart where ds='2008-04-08' and hr='11';

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg_try_db_lock_conflict.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg_try_db_lock_conflict.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg_try_db_lock_conflict.q
deleted file mode 100644
index 1f9ad90..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg_try_db_lock_conflict.q
+++ /dev/null
@@ -1,6 +0,0 @@
-set hive.lock.numretries=0;
-
-create database lockneg4;
-
-lock database lockneg4 exclusive;
-lock database lockneg4 shared;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg_try_drop_locked_db.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg_try_drop_locked_db.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg_try_drop_locked_db.q
deleted file mode 100644
index 8cbe310..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg_try_drop_locked_db.q
+++ /dev/null
@@ -1,8 +0,0 @@
-set hive.lock.numretries=0;
-
-create database lockneg9;
-
-lock database lockneg9 shared;
-show locks database lockneg9;
-
-drop database lockneg9;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg_try_lock_db_in_use.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg_try_lock_db_in_use.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg_try_lock_db_in_use.q
deleted file mode 100644
index 4127a6f..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/lockneg_try_lock_db_in_use.q
+++ /dev/null
@@ -1,15 +0,0 @@
-set hive.lock.numretries=0;
-
-create database lockneg2;
-use lockneg2;
-
-create table tstsrcpart like default.srcpart;
-
-insert overwrite table tstsrcpart partition (ds='2008-04-08', hr='11')
-select key, value from default.srcpart where ds='2008-04-08' and hr='11';
-
-lock table tstsrcpart shared;
-show locks;
-
-lock database lockneg2 exclusive;
-show locks;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/macro_unused_parameter.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/macro_unused_parameter.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/macro_unused_parameter.q
deleted file mode 100644
index 523710d..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/macro_unused_parameter.q
+++ /dev/null
@@ -1 +0,0 @@
-CREATE TEMPORARY MACRO BAD_MACRO (x INT, y INT) x;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/mapreduce_stack_trace.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/mapreduce_stack_trace.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/mapreduce_stack_trace.q
deleted file mode 100644
index 76c7ae9..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/mapreduce_stack_trace.q
+++ /dev/null
@@ -1,13 +0,0 @@
-set hive.exec.mode.local.auto=false;
-set hive.exec.job.debug.capture.stacktraces=true;
-set hive.exec.failure.hooks=org.apache.hadoop.hive.ql.hooks.VerifySessionStateStackTracesHook;
-
-FROM src SELECT TRANSFORM(key, value) USING 'script_does_not_exist' AS (key, value);
-
--- INCLUDE_HADOOP_MAJOR_VERSIONS(0.23)
--- Hadoop 0.23 changes the getTaskDiagnostics behavior
--- The Error Code of hive failure MapReduce job changes
--- In Hadoop 0.20
--- Hive failure MapReduce job gets 20000 as Error Code
--- In Hadoop 0.23
--- Hive failure MapReduce job gets 2 as Error Code

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/mapreduce_stack_trace_hadoop20.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/mapreduce_stack_trace_hadoop20.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/mapreduce_stack_trace_hadoop20.q
deleted file mode 100644
index 9d0548c..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/mapreduce_stack_trace_hadoop20.q
+++ /dev/null
@@ -1,13 +0,0 @@
-set hive.exec.mode.local.auto=false;
-set hive.exec.job.debug.capture.stacktraces=true;
-set hive.exec.failure.hooks=org.apache.hadoop.hive.ql.hooks.VerifySessionStateStackTracesHook;
-
-FROM src SELECT TRANSFORM(key, value) USING 'script_does_not_exist' AS (key, value);
-
--- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.23)
--- Hadoop 0.23 changes the getTaskDiagnostics behavior
--- The Error Code of hive failure MapReduce job changes
--- In Hadoop 0.20
--- Hive failure MapReduce job gets 20000 as Error Code
--- In Hadoop 0.23
--- Hive failure MapReduce job gets 2 as Error Code

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/mapreduce_stack_trace_turnoff.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/mapreduce_stack_trace_turnoff.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/mapreduce_stack_trace_turnoff.q
deleted file mode 100644
index c93aedb..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/mapreduce_stack_trace_turnoff.q
+++ /dev/null
@@ -1,13 +0,0 @@
-set hive.exec.mode.local.auto=false;
-set hive.exec.job.debug.capture.stacktraces=false;
-set hive.exec.failure.hooks=org.apache.hadoop.hive.ql.hooks.VerifySessionStateStackTracesHook;
-
-FROM src SELECT TRANSFORM(key, value) USING 'script_does_not_exist' AS (key, value);
-
--- INCLUDE_HADOOP_MAJOR_VERSIONS(0.23)
--- Hadoop 0.23 changes the getTaskDiagnostics behavior
--- The Error Code of hive failure MapReduce job changes
--- In Hadoop 0.20
--- Hive failure MapReduce job gets 20000 as Error Code
--- In Hadoop 0.23
--- Hive failure MapReduce job gets 2 as Error Code

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/mapreduce_stack_trace_turnoff_hadoop20.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/mapreduce_stack_trace_turnoff_hadoop20.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/mapreduce_stack_trace_turnoff_hadoop20.q
deleted file mode 100644
index e319944..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/mapreduce_stack_trace_turnoff_hadoop20.q
+++ /dev/null
@@ -1,13 +0,0 @@
-set hive.exec.mode.local.auto=false;
-set hive.exec.job.debug.capture.stacktraces=false;
-set hive.exec.failure.hooks=org.apache.hadoop.hive.ql.hooks.VerifySessionStateStackTracesHook;
-
-FROM src SELECT TRANSFORM(key, value) USING 'script_does_not_exist' AS (key, value);
-
--- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.23)
--- Hadoop 0.23 changes the getTaskDiagnostics behavior
--- The Error Code of hive failure MapReduce job changes
--- In Hadoop 0.20
--- Hive failure MapReduce job gets 20000 as Error Code
--- In Hadoop 0.23
--- Hive failure MapReduce job gets 2 as Error Code

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/merge_negative_1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/merge_negative_1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/merge_negative_1.q
deleted file mode 100644
index 0a48c01..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/merge_negative_1.q
+++ /dev/null
@@ -1,3 +0,0 @@
-create table src2 like src;
-CREATE INDEX src_index_merge_test ON TABLE src2(key) as 'COMPACT' WITH DEFERRED REBUILD;
-alter table src2 concatenate;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/merge_negative_2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/merge_negative_2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/merge_negative_2.q
deleted file mode 100644
index a4fab1c..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/merge_negative_2.q
+++ /dev/null
@@ -1,3 +0,0 @@
-create table srcpart2 (key int, value string) partitioned by (ds string);
-insert overwrite table srcpart2 partition (ds='2011') select * from src;
-alter table srcpart2 concatenate;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/merge_negative_3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/merge_negative_3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/merge_negative_3.q
deleted file mode 100644
index 6bc645e..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/merge_negative_3.q
+++ /dev/null
@@ -1,6 +0,0 @@
-set hive.enforce.bucketing=true;
-set hive.enforce.sorting=true;
-
-create table srcpart2 (key int, value string) partitioned by (ds string) clustered by (key) sorted by (key) into 2 buckets stored as RCFILE;
-insert overwrite table srcpart2 partition (ds='2011') select * from src;
-alter table srcpart2 partition (ds = '2011') concatenate;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/minimr_broken_pipe.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/minimr_broken_pipe.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/minimr_broken_pipe.q
deleted file mode 100644
index 8dda9cd..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/minimr_broken_pipe.q
+++ /dev/null
@@ -1,4 +0,0 @@
-set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
-set hive.exec.script.allow.partial.consumption = false;
--- Tests exception in ScriptOperator.close() by passing to the operator a small amount of data
-SELECT TRANSFORM(*) USING 'true' AS a, b FROM (SELECT TRANSFORM(*) USING 'echo' AS a, b FROM src LIMIT 1) tmp;
\ No newline at end of file


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@spark.apache.org
For additional commands, e-mail: commits-help@spark.apache.org


Mime
View raw message