You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@spark.apache.org by rx...@apache.org on 2016/04/21 01:30:32 UTC
[6/8] spark git commit: [SPARK-14770][SQL] Remove unused queries in
hive module test resources
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_insert.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_insert.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_insert.q
deleted file mode 100644
index 81b6e52..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_insert.q
+++ /dev/null
@@ -1,14 +0,0 @@
-set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest;
-set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator;
-set hive.security.authorization.enabled=true;
-
-dfs ${system:test.dfs.mkdir} ${system:test.tmp.dir}/az_uri_insert;
-dfs -touchz ${system:test.tmp.dir}/az_uri_insert/1.txt;
-dfs -chmod 555 ${system:test.tmp.dir}/az_uri_insert/1.txt;
-
-create table t1(i int, j int);
-
-insert overwrite directory '${system:test.tmp.dir}/az_uri_insert/' select * from t1;
-
--- Attempt to insert into uri without permissions should fail
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_insert_local.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_insert_local.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_insert_local.q
deleted file mode 100644
index 0a2fd89..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_insert_local.q
+++ /dev/null
@@ -1,14 +0,0 @@
-set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest;
-set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator;
-set hive.security.authorization.enabled=true;
-
-dfs ${system:test.dfs.mkdir} ${system:test.tmp.dir}/az_uri_insert_local;
-dfs -touchz ${system:test.tmp.dir}/az_uri_insert_local/1.txt;
-dfs -chmod 555 ${system:test.tmp.dir}/az_uri_insert_local/1.txt;
-
-create table t1(i int, j int);
-
-insert overwrite local directory '${system:test.tmp.dir}/az_uri_insert_local/' select * from t1;
-
--- Attempt to insert into uri without permissions should fail
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_load_data.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_load_data.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_load_data.q
deleted file mode 100644
index 6af41f0..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_load_data.q
+++ /dev/null
@@ -1,11 +0,0 @@
-set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest;
-set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator;
-set hive.security.authorization.enabled=true;
-
-dfs ${system:test.dfs.mkdir} ${system:test.tmp.dir}/authz_uri_load_data;
-dfs -touchz ${system:test.tmp.dir}/authz_uri_load_data/1.txt;
-dfs -chmod 555 ${system:test.tmp.dir}/authz_uri_load_data/1.txt;
-
-create table t1(i int);
-load data inpath 'pfile:${system:test.tmp.dir}/authz_uri_load_data/' overwrite into table t1;
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorize_create_tbl.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorize_create_tbl.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorize_create_tbl.q
deleted file mode 100644
index d8beac3..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorize_create_tbl.q
+++ /dev/null
@@ -1,10 +0,0 @@
-set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest;
-set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator;
-
-set hive.security.authorization.enabled=true;
-set user.name=user33;
-create database db23221;
-use db23221;
-
-set user.name=user44;
-create table twew221(a string);
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorize_grant_public.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorize_grant_public.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorize_grant_public.q
deleted file mode 100644
index bfd3165..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorize_grant_public.q
+++ /dev/null
@@ -1 +0,0 @@
-grant role PUBLIC to user hive_test_user;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorize_revoke_public.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorize_revoke_public.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorize_revoke_public.q
deleted file mode 100644
index 2b29822..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorize_revoke_public.q
+++ /dev/null
@@ -1 +0,0 @@
-revoke role PUBLIC from user hive_test_user;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/autolocal1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/autolocal1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/autolocal1.q
deleted file mode 100644
index bd1c9d6..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/autolocal1.q
+++ /dev/null
@@ -1,15 +0,0 @@
-set mapred.job.tracker=abracadabra;
-set hive.exec.mode.local.auto.inputbytes.max=1;
-set hive.exec.mode.local.auto=true;
-
--- INCLUDE_HADOOP_MAJOR_VERSIONS(0.20)
--- hadoop0.23 changes the behavior of JobClient initialization
--- in hadoop0.20, JobClient initialization tries to get JobTracker's address
--- this throws the expected IllegalArgumentException
--- in hadoop0.23, JobClient initialization only initializes cluster
--- and get user group information
--- not attempts to get JobTracker's address
--- no IllegalArgumentException thrown in JobClient Initialization
--- an exception is thrown when JobClient submitJob
-
-SELECT key FROM src;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/bad_exec_hooks.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/bad_exec_hooks.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/bad_exec_hooks.q
deleted file mode 100644
index 709d8d9..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/bad_exec_hooks.q
+++ /dev/null
@@ -1,6 +0,0 @@
-set hive.exec.pre.hooks="org.this.is.a.bad.class";
-
-EXPLAIN
-SELECT x.* FROM SRC x LIMIT 20;
-
-SELECT x.* FROM SRC x LIMIT 20;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/bad_indextype.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/bad_indextype.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/bad_indextype.q
deleted file mode 100644
index 8f5bf42..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/bad_indextype.q
+++ /dev/null
@@ -1 +0,0 @@
-CREATE INDEX srcpart_index_proj ON TABLE srcpart(key) AS 'UNKNOWN' WITH DEFERRED REBUILD;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/bad_sample_clause.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/bad_sample_clause.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/bad_sample_clause.q
deleted file mode 100644
index fd67698..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/bad_sample_clause.q
+++ /dev/null
@@ -1,6 +0,0 @@
-CREATE TABLE dest1(key INT, value STRING, dt STRING, hr STRING) STORED AS TEXTFILE;
-
-INSERT OVERWRITE TABLE dest1 SELECT s.*
-FROM srcpart TABLESAMPLE (BUCKET 1 OUT OF 2) s
-WHERE s.ds='2008-04-08' and s.hr='11';
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/bucket_mapjoin_mismatch1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/bucket_mapjoin_mismatch1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/bucket_mapjoin_mismatch1.q
deleted file mode 100644
index 6bebb89..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/bucket_mapjoin_mismatch1.q
+++ /dev/null
@@ -1,42 +0,0 @@
-CREATE TABLE srcbucket_mapjoin_part (key int, value string)
- partitioned by (ds string) CLUSTERED BY (key) INTO 3 BUCKETS
- STORED AS TEXTFILE;
-load data local inpath '../../data/files/srcbucket20.txt'
- INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08');
-load data local inpath '../../data/files/srcbucket21.txt'
- INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08');
-load data local inpath '../../data/files/srcbucket22.txt'
- INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08');
-
-CREATE TABLE srcbucket_mapjoin_part_2 (key int, value string)
- partitioned by (ds string) CLUSTERED BY (key) INTO 2 BUCKETS
- STORED AS TEXTFILE;
-load data local inpath '../../data/files/srcbucket22.txt'
- INTO TABLE srcbucket_mapjoin_part_2 partition(ds='2008-04-08');
-load data local inpath '../../data/files/srcbucket23.txt'
- INTO TABLE srcbucket_mapjoin_part_2 partition(ds='2008-04-08');
-
--- The number of buckets in the 2 tables above (being joined later) dont match.
--- Throw an error if the user requested a bucketed mapjoin to be enforced.
--- In the default case (hive.enforce.bucketmapjoin=false), the query succeeds
--- even though mapjoin is not being performed
-
-explain
-select a.key, a.value, b.value
-from srcbucket_mapjoin_part a join srcbucket_mapjoin_part_2 b
-on a.key=b.key and a.ds="2008-04-08" and b.ds="2008-04-08";
-
-set hive.optimize.bucketmapjoin = true;
-
-explain
-select /*+mapjoin(b)*/ a.key, a.value, b.value
-from srcbucket_mapjoin_part a join srcbucket_mapjoin_part_2 b
-on a.key=b.key and a.ds="2008-04-08" and b.ds="2008-04-08";
-
-set hive.enforce.bucketmapjoin=true;
-
-explain
-select /*+mapjoin(b)*/ a.key, a.value, b.value
-from srcbucket_mapjoin_part a join srcbucket_mapjoin_part_2 b
-on a.key=b.key and a.ds="2008-04-08" and b.ds="2008-04-08";
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/bucket_mapjoin_wrong_table_metadata_1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/bucket_mapjoin_wrong_table_metadata_1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/bucket_mapjoin_wrong_table_metadata_1.q
deleted file mode 100644
index 802fcd9..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/bucket_mapjoin_wrong_table_metadata_1.q
+++ /dev/null
@@ -1,20 +0,0 @@
--- Although the user has specified a bucketed map-join, the number of buckets in the table
--- do not match the number of files
-drop table table1;
-drop table table2;
-
-create table table1(key string, value string) clustered by (key, value)
-into 2 BUCKETS stored as textfile;
-create table table2(key string, value string) clustered by (value, key)
-into 2 BUCKETS stored as textfile;
-
-load data local inpath '../../data/files/T1.txt' overwrite into table table1;
-
-load data local inpath '../../data/files/T1.txt' overwrite into table table2;
-load data local inpath '../../data/files/T2.txt' overwrite into table table2;
-
-set hive.optimize.bucketmapjoin = true;
-set hive.input.format = org.apache.hadoop.hive.ql.io.BucketizedHiveInputFormat;
-
-select /*+ mapjoin(b) */ count(*) from table1 a join table2 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/bucket_mapjoin_wrong_table_metadata_2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/bucket_mapjoin_wrong_table_metadata_2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/bucket_mapjoin_wrong_table_metadata_2.q
deleted file mode 100644
index ac5abeb..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/bucket_mapjoin_wrong_table_metadata_2.q
+++ /dev/null
@@ -1,24 +0,0 @@
--- Although the user has specified a bucketed map-join, the number of buckets in the table
--- do not match the number of files
-drop table table1;
-drop table table2;
-
-create table table1(key string, value string) partitioned by (ds string) clustered by (key, value)
-into 2 BUCKETS stored as textfile;
-create table table2(key string, value string) clustered by (value, key)
-into 2 BUCKETS stored as textfile;
-
-load data local inpath '../../data/files/T1.txt' overwrite into table table1 partition (ds='1');
-load data local inpath '../../data/files/T2.txt' overwrite into table table1 partition (ds='1');
-
-load data local inpath '../../data/files/T1.txt' overwrite into table table1 partition (ds='2');
-
-load data local inpath '../../data/files/T1.txt' overwrite into table table2;
-load data local inpath '../../data/files/T2.txt' overwrite into table table2;
-
-set hive.optimize.bucketmapjoin = true;
-set hive.input.format = org.apache.hadoop.hive.ql.io.BucketizedHiveInputFormat;
-
-select /*+ mapjoin(b) */ count(*) from table1 a join table2 b
-on a.key=b.key and a.value=b.value and a.ds is not null;
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/cachingprintstream.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/cachingprintstream.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/cachingprintstream.q
deleted file mode 100644
index d57a451..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/cachingprintstream.q
+++ /dev/null
@@ -1,8 +0,0 @@
-set hive.exec.failure.hooks=org.apache.hadoop.hive.ql.hooks.VerifyCachingPrintStreamHook;
-set hive.exec.post.hooks=org.apache.hadoop.hive.ql.hooks.VerifyCachingPrintStreamHook;
-
-SELECT count(*) FROM src;
-FROM src SELECT TRANSFORM (key, value) USING 'FAKE_SCRIPT_SHOULD_NOT_EXIST' AS key, value;
-
-set hive.exec.failure.hooks=;
-set hive.exec.post.hooks=;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/cluster_tasklog_retrieval.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/cluster_tasklog_retrieval.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/cluster_tasklog_retrieval.q
deleted file mode 100644
index bc98044..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/cluster_tasklog_retrieval.q
+++ /dev/null
@@ -1,6 +0,0 @@
--- TaskLog retrieval upon Null Pointer Exception in Cluster
-
-CREATE TEMPORARY FUNCTION evaluate_npe AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFEvaluateNPE';
-
-FROM src
-SELECT evaluate_npe(src.key) LIMIT 1;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/clusterbydistributeby.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/clusterbydistributeby.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/clusterbydistributeby.q
deleted file mode 100644
index 4c6a9b3..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/clusterbydistributeby.q
+++ /dev/null
@@ -1,8 +0,0 @@
-CREATE TABLE dest1(key INT, ten INT, one INT, value STRING) STORED AS TEXTFILE;
-
-FROM src
-INSERT OVERWRITE TABLE dest1
-MAP src.key, CAST(src.key / 10 AS INT), CAST(src.key % 10 AS INT), src.value
-USING 'cat' AS (tkey, ten, one, tvalue)
-CLUSTER BY tvalue, tkey
-DISTRIBUTE BY tvalue, tkey;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/clusterbyorderby.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/clusterbyorderby.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/clusterbyorderby.q
deleted file mode 100644
index d9ee9b9..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/clusterbyorderby.q
+++ /dev/null
@@ -1,5 +0,0 @@
-FROM src
-MAP src.key, CAST(src.key / 10 AS INT), CAST(src.key % 10 AS INT), src.value
-USING 'cat' AS (tkey, ten, one, tvalue)
-CLUSTER BY tvalue, tkey
-ORDER BY ten, one;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/clusterbysortby.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/clusterbysortby.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/clusterbysortby.q
deleted file mode 100644
index 7b4e744..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/clusterbysortby.q
+++ /dev/null
@@ -1,8 +0,0 @@
-CREATE TABLE dest1(key INT, ten INT, one INT, value STRING) STORED AS TEXTFILE;
-
-FROM src
-INSERT OVERWRITE TABLE dest1
-MAP src.key, CAST(src.key / 10 AS INT), CAST(src.key % 10 AS INT), src.value
-USING 'cat' AS (tkey, ten, one, tvalue)
-CLUSTER BY tvalue, tkey
-SORT BY ten, one;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/clustern2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/clustern2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/clustern2.q
deleted file mode 100644
index 9ed8944..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/clustern2.q
+++ /dev/null
@@ -1,3 +0,0 @@
-EXPLAIN
-SELECT x.key, x.value as v1, y.* FROM SRC x JOIN SRC y ON (x.key = y.key) CLUSTER BY key;
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/clustern3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/clustern3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/clustern3.q
deleted file mode 100644
index 23f7366..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/clustern3.q
+++ /dev/null
@@ -1,2 +0,0 @@
-EXPLAIN
-SELECT x.key as k1, x.value FROM SRC x CLUSTER BY x.key;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/clustern4.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/clustern4.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/clustern4.q
deleted file mode 100644
index 3a9b45c..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/clustern4.q
+++ /dev/null
@@ -1,2 +0,0 @@
-EXPLAIN
-SELECT x.key as k1, x.value FROM SRC x CLUSTER BY key;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/column_change_skewedcol_type1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/column_change_skewedcol_type1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/column_change_skewedcol_type1.q
deleted file mode 100644
index 9a3e0b2..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/column_change_skewedcol_type1.q
+++ /dev/null
@@ -1,5 +0,0 @@
-set hive.mapred.supports.subdirectories=true;
-
-CREATE TABLE skewedtable (key STRING, value STRING) SKEWED BY (key) ON (1,5,6);
-
-ALTER TABLE skewedtable CHANGE key key INT;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/column_rename1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/column_rename1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/column_rename1.q
deleted file mode 100644
index d99b821..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/column_rename1.q
+++ /dev/null
@@ -1,6 +0,0 @@
-drop table tstsrc;
-create table tstsrc like src;
-insert overwrite table tstsrc
-select key, value from src;
-
-alter table tstsrc change src_not_exist key_value string;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/column_rename2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/column_rename2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/column_rename2.q
deleted file mode 100644
index cccc8ad..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/column_rename2.q
+++ /dev/null
@@ -1,6 +0,0 @@
-drop table tstsrc;
-create table tstsrc like src;
-insert overwrite table tstsrc
-select key, value from src;
-
-alter table tstsrc change key value string;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/column_rename3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/column_rename3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/column_rename3.q
deleted file mode 100644
index 91c9537..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/column_rename3.q
+++ /dev/null
@@ -1 +0,0 @@
-alter table src change key 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/column_rename4.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/column_rename4.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/column_rename4.q
deleted file mode 100644
index dd89a5a..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/column_rename4.q
+++ /dev/null
@@ -1,6 +0,0 @@
-drop table tstsrc;
-create table tstsrc like src;
-insert overwrite table tstsrc
-select key, value from src;
-
-alter table tstsrc change key key2 string after key_value;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/column_rename5.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/column_rename5.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/column_rename5.q
deleted file mode 100644
index 3827b83..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/column_rename5.q
+++ /dev/null
@@ -1,6 +0,0 @@
-set hive.mapred.supports.subdirectories=true;
-
-CREATE TABLE skewedtable (key STRING, value STRING) SKEWED BY (key) ON (1,5,6);
-
-ALTER TABLE skewedtable CHANGE key key_new STRING;
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_partlvl_dp.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_partlvl_dp.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_partlvl_dp.q
deleted file mode 100644
index b4887c4..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_partlvl_dp.q
+++ /dev/null
@@ -1,16 +0,0 @@
-DROP TABLE Employee_Part;
-
-CREATE TABLE Employee_Part(employeeID int, employeeName String) partitioned by (employeeSalary double, country string)
-row format delimited fields terminated by '|' stored as textfile;
-
-LOAD DATA LOCAL INPATH "../../data/files/employee2.dat" INTO TABLE Employee_Part partition(employeeSalary='2000.0', country='USA');
-LOAD DATA LOCAL INPATH "../../data/files/employee2.dat" INTO TABLE Employee_Part partition(employeeSalary='2000.0', country='UK');
-LOAD DATA LOCAL INPATH "../../data/files/employee2.dat" INTO TABLE Employee_Part partition(employeeSalary='3000.0', country='USA');
-LOAD DATA LOCAL INPATH "../../data/files/employee2.dat" INTO TABLE Employee_Part partition(employeeSalary='4000.0', country='USA');
-LOAD DATA LOCAL INPATH "../../data/files/employee2.dat" INTO TABLE Employee_Part partition(employeeSalary='3500.0', country='UK');
-LOAD DATA LOCAL INPATH "../../data/files/employee2.dat" INTO TABLE Employee_Part partition(employeeSalary='3000.0', country='UK');
-
--- dynamic partitioning syntax
-explain
-analyze table Employee_Part partition (employeeSalary='4000.0', country) compute statistics for columns employeeName, employeeID;
-analyze table Employee_Part partition (employeeSalary='4000.0', country) compute statistics for columns employeeName, employeeID;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_partlvl_incorrect_num_keys.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_partlvl_incorrect_num_keys.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_partlvl_incorrect_num_keys.q
deleted file mode 100644
index 2f8e927..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_partlvl_incorrect_num_keys.q
+++ /dev/null
@@ -1,16 +0,0 @@
-DROP TABLE Employee_Part;
-
-CREATE TABLE Employee_Part(employeeID int, employeeName String) partitioned by (employeeSalary double, country string)
-row format delimited fields terminated by '|' stored as textfile;
-
-LOAD DATA LOCAL INPATH "../../data/files/employee2.dat" INTO TABLE Employee_Part partition(employeeSalary='2000.0', country='USA');
-LOAD DATA LOCAL INPATH "../../data/files/employee2.dat" INTO TABLE Employee_Part partition(employeeSalary='2000.0', country='UK');
-LOAD DATA LOCAL INPATH "../../data/files/employee2.dat" INTO TABLE Employee_Part partition(employeeSalary='3000.0', country='USA');
-LOAD DATA LOCAL INPATH "../../data/files/employee2.dat" INTO TABLE Employee_Part partition(employeeSalary='4000.0', country='USA');
-LOAD DATA LOCAL INPATH "../../data/files/employee2.dat" INTO TABLE Employee_Part partition(employeeSalary='3500.0', country='UK');
-LOAD DATA LOCAL INPATH "../../data/files/employee2.dat" INTO TABLE Employee_Part partition(employeeSalary='3000.0', country='UK');
-
--- don't specify all partitioning keys
-explain
-analyze table Employee_Part partition (employeeSalary='2000.0') compute statistics for columns employeeID;
-analyze table Employee_Part partition (employeeSalary='2000.0') compute statistics for columns employeeID;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_partlvl_invalid_values.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_partlvl_invalid_values.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_partlvl_invalid_values.q
deleted file mode 100644
index 34f91fc..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_partlvl_invalid_values.q
+++ /dev/null
@@ -1,16 +0,0 @@
-DROP TABLE Employee_Part;
-
-CREATE TABLE Employee_Part(employeeID int, employeeName String) partitioned by (employeeSalary double, country string)
-row format delimited fields terminated by '|' stored as textfile;
-
-LOAD DATA LOCAL INPATH "../../data/files/employee2.dat" INTO TABLE Employee_Part partition(employeeSalary='2000.0', country='USA');
-LOAD DATA LOCAL INPATH "../../data/files/employee2.dat" INTO TABLE Employee_Part partition(employeeSalary='2000.0', country='UK');
-LOAD DATA LOCAL INPATH "../../data/files/employee2.dat" INTO TABLE Employee_Part partition(employeeSalary='3000.0', country='USA');
-LOAD DATA LOCAL INPATH "../../data/files/employee2.dat" INTO TABLE Employee_Part partition(employeeSalary='4000.0', country='USA');
-LOAD DATA LOCAL INPATH "../../data/files/employee2.dat" INTO TABLE Employee_Part partition(employeeSalary='3500.0', country='UK');
-LOAD DATA LOCAL INPATH "../../data/files/employee2.dat" INTO TABLE Employee_Part partition(employeeSalary='3000.0', country='UK');
-
--- specify invalid values for the partitioning keys
-explain
-analyze table Employee_Part partition (employeeSalary='4000.0', country='Canada') compute statistics for columns employeeName, employeeID;
-analyze table Employee_Part partition (employeeSalary='4000.0', country='Canada') compute statistics for columns employeeName, employeeID;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_partlvl_multiple_part_clause.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_partlvl_multiple_part_clause.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_partlvl_multiple_part_clause.q
deleted file mode 100644
index 49d89dd..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_partlvl_multiple_part_clause.q
+++ /dev/null
@@ -1,16 +0,0 @@
-DROP TABLE Employee_Part;
-
-CREATE TABLE Employee_Part(employeeID int, employeeName String) partitioned by (employeeSalary double, country string)
-row format delimited fields terminated by '|' stored as textfile;
-
-LOAD DATA LOCAL INPATH "../../data/files/employee2.dat" INTO TABLE Employee_Part partition(employeeSalary='2000.0', country='USA');
-LOAD DATA LOCAL INPATH "../../data/files/employee2.dat" INTO TABLE Employee_Part partition(employeeSalary='2000.0', country='UK');
-LOAD DATA LOCAL INPATH "../../data/files/employee2.dat" INTO TABLE Employee_Part partition(employeeSalary='3000.0', country='USA');
-LOAD DATA LOCAL INPATH "../../data/files/employee2.dat" INTO TABLE Employee_Part partition(employeeSalary='4000.0', country='USA');
-LOAD DATA LOCAL INPATH "../../data/files/employee2.dat" INTO TABLE Employee_Part partition(employeeSalary='3500.0', country='UK');
-LOAD DATA LOCAL INPATH "../../data/files/employee2.dat" INTO TABLE Employee_Part partition(employeeSalary='3000.0', country='UK');
-
--- specify partitioning clause multiple times
-explain
-analyze table Employee_Part partition (employeeSalary='4000.0', country='USA') partition(employeeSalary='2000.0', country='USA') compute statistics for columns employeeName, employeeID;
-analyze table Employee_Part partition (employeeSalary='4000.0', country='USA') partition(employeeSalary='2000.0', country='USA') compute statistics for columns employeeName, employeeID;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_tbllvl.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_tbllvl.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_tbllvl.q
deleted file mode 100644
index a4e0056..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_tbllvl.q
+++ /dev/null
@@ -1,22 +0,0 @@
-
-DROP TABLE IF EXISTS UserVisits_web_text_none;
-
-CREATE TABLE UserVisits_web_text_none (
- sourceIP string,
- destURL string,
- visitDate string,
- adRevenue float,
- userAgent string,
- cCode string,
- lCode string,
- sKeyword string,
- avgTimeOnSite int)
-row format delimited fields terminated by '|' stored as textfile;
-
-LOAD DATA LOCAL INPATH "../../data/files/UserVisits.dat" INTO TABLE UserVisits_web_text_none;
-
-explain
-analyze table UserVisits_web_text_none compute statistics for columns destIP;
-
-analyze table UserVisits_web_text_none compute statistics for columns destIP;
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_tbllvl_complex_type.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_tbllvl_complex_type.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_tbllvl_complex_type.q
deleted file mode 100644
index 85a5f0a..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_tbllvl_complex_type.q
+++ /dev/null
@@ -1,17 +0,0 @@
-
-DROP TABLE IF EXISTS table_complex_type;
-
-CREATE TABLE table_complex_type (
- a STRING,
- b ARRAY<STRING>,
- c ARRAY<MAP<STRING,STRING>>,
- d MAP<STRING,ARRAY<STRING>>
- ) STORED AS TEXTFILE;
-
-LOAD DATA LOCAL INPATH '../../data/files/create_nested_type.txt' OVERWRITE INTO TABLE table_complex_type;
-
-
-explain
-analyze table table_complex_type compute statistics for columns d;
-
-analyze table table_complex_type compute statistics for columns d;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_tbllvl_incorrect_column.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_tbllvl_incorrect_column.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_tbllvl_incorrect_column.q
deleted file mode 100644
index a4e0056..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/columnstats_tbllvl_incorrect_column.q
+++ /dev/null
@@ -1,22 +0,0 @@
-
-DROP TABLE IF EXISTS UserVisits_web_text_none;
-
-CREATE TABLE UserVisits_web_text_none (
- sourceIP string,
- destURL string,
- visitDate string,
- adRevenue float,
- userAgent string,
- cCode string,
- lCode string,
- sKeyword string,
- avgTimeOnSite int)
-row format delimited fields terminated by '|' stored as textfile;
-
-LOAD DATA LOCAL INPATH "../../data/files/UserVisits.dat" INTO TABLE UserVisits_web_text_none;
-
-explain
-analyze table UserVisits_web_text_none compute statistics for columns destIP;
-
-analyze table UserVisits_web_text_none compute statistics for columns destIP;
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/compare_double_bigint.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/compare_double_bigint.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/compare_double_bigint.q
deleted file mode 100644
index 8ee4b27..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/compare_double_bigint.q
+++ /dev/null
@@ -1,5 +0,0 @@
-set hive.mapred.mode=strict;
-
--- This should fail until we fix the issue with precision when casting a bigint to a double
-
-select * from src where cast(1 as bigint) = 1.0 limit 10;
\ 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/compare_string_bigint.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/compare_string_bigint.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/compare_string_bigint.q
deleted file mode 100644
index 810f65d..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/compare_string_bigint.q
+++ /dev/null
@@ -1,5 +0,0 @@
-set hive.mapred.mode=strict;
-
---This should fail until we fix the issue with precision when casting a bigint to a double
-
-select * from src where cast(1 as bigint) = '1' limit 10;
\ 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/compile_processor.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/compile_processor.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/compile_processor.q
deleted file mode 100644
index c314a94..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/compile_processor.q
+++ /dev/null
@@ -1,8 +0,0 @@
-
-compile `import org.apache.hadoop.hive.ql.exec.UDF \;
-public class Pyth extsfgsfgfsends UDF {
- public double evaluate(double a, double b){
- return Math.sqrt((a*a) + (b*b)) \;
- }
-} ` AS GROOVY NAMED Pyth.groovy;
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/compute_stats_long.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/compute_stats_long.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/compute_stats_long.q
deleted file mode 100644
index 5974811..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/compute_stats_long.q
+++ /dev/null
@@ -1,7 +0,0 @@
-create table tab_int(a int);
-
--- insert some data
-LOAD DATA LOCAL INPATH "../../data/files/int.txt" INTO TABLE tab_int;
-
--- compute stats should raise an error since the number of bit vectors > 1024
-select compute_stats(a, 10000) from tab_int;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_function_nonexistent_class.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_function_nonexistent_class.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_function_nonexistent_class.q
deleted file mode 100644
index 3b71e00..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_function_nonexistent_class.q
+++ /dev/null
@@ -1 +0,0 @@
-create function default.badfunc as 'my.nonexistent.class';
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_function_nonexistent_db.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_function_nonexistent_db.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_function_nonexistent_db.q
deleted file mode 100644
index ae95391..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_function_nonexistent_db.q
+++ /dev/null
@@ -1 +0,0 @@
-create function nonexistentdb.badfunc as 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFUpper';
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_function_nonudf_class.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_function_nonudf_class.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_function_nonudf_class.q
deleted file mode 100644
index 2083064..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_function_nonudf_class.q
+++ /dev/null
@@ -1 +0,0 @@
-create function default.badfunc as 'java.lang.String';
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_insert_outputformat.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_insert_outputformat.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_insert_outputformat.q
deleted file mode 100644
index a052663..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_insert_outputformat.q
+++ /dev/null
@@ -1,11 +0,0 @@
-
-
-CREATE TABLE table_test_output_format(key INT, value STRING) STORED AS
- INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat'
- OUTPUTFORMAT 'org.apache.hadoop.mapred.MapFileOutputFormat';
-
-FROM src
-INSERT OVERWRITE TABLE table_test_output_format SELECT src.key, src.value LIMIT 10;
-
-describe table_test_output_format;
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_or_replace_view1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_or_replace_view1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_or_replace_view1.q
deleted file mode 100644
index c332278..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_or_replace_view1.q
+++ /dev/null
@@ -1,6 +0,0 @@
--- Cannot add or drop partition columns with CREATE OR REPLACE VIEW if partitions currently exist (must specify partition columns)
-
-drop view v;
-create view v partitioned on (ds, hr) as select * from srcpart;
-alter view v add partition (ds='1',hr='2');
-create or replace view v as select * from srcpart;
\ 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/create_or_replace_view2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_or_replace_view2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_or_replace_view2.q
deleted file mode 100644
index b53dd07..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_or_replace_view2.q
+++ /dev/null
@@ -1,6 +0,0 @@
--- Cannot add or drop partition columns with CREATE OR REPLACE VIEW if partitions currently exist
-
-drop view v;
-create view v partitioned on (ds, hr) as select * from srcpart;
-alter view v add partition (ds='1',hr='2');
-create or replace view v partitioned on (hr) as select * from srcpart;
\ 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/create_or_replace_view3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_or_replace_view3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_or_replace_view3.q
deleted file mode 100644
index d6fa778..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_or_replace_view3.q
+++ /dev/null
@@ -1,3 +0,0 @@
--- Existing table is not a view
-
-create or replace view src as select ds, hr from srcpart;
\ 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/create_or_replace_view4.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_or_replace_view4.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_or_replace_view4.q
deleted file mode 100644
index 12b6059..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_or_replace_view4.q
+++ /dev/null
@@ -1,5 +0,0 @@
--- View must have at least one non-partition column.
-
-drop view v;
-create view v partitioned on (ds, hr) as select * from srcpart;
-create or replace view v partitioned on (ds, hr) as select ds, hr from srcpart;
\ 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/create_or_replace_view5.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_or_replace_view5.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_or_replace_view5.q
deleted file mode 100644
index 4eb9c94..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_or_replace_view5.q
+++ /dev/null
@@ -1,5 +0,0 @@
--- Can't combine IF NOT EXISTS and OR REPLACE.
-
-drop view v;
-create view v partitioned on (ds, hr) as select * from srcpart;
-create or replace view if not exists v as select * from srcpart;
\ 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/create_or_replace_view6.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_or_replace_view6.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_or_replace_view6.q
deleted file mode 100644
index a2f916f..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_or_replace_view6.q
+++ /dev/null
@@ -1,5 +0,0 @@
--- Can't update view to have an invalid definition
-
-drop view v;
-create view v partitioned on (ds, hr) as select * from srcpart;
-create or replace view v partitioned on (ds, hr) as blah;
\ 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/create_or_replace_view7.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_or_replace_view7.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_or_replace_view7.q
deleted file mode 100644
index 765a965..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_or_replace_view7.q
+++ /dev/null
@@ -1,7 +0,0 @@
--- Can't update view to have a view cycle (1)
-
-drop view v;
-create view v1 partitioned on (ds, hr) as select * from srcpart;
-create view v2 partitioned on (ds, hr) as select * from v1;
-create view v3 partitioned on (ds, hr) as select * from v2;
-create or replace view v1 partitioned on (ds, hr) as select * from v3;
\ 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/create_or_replace_view8.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_or_replace_view8.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_or_replace_view8.q
deleted file mode 100644
index f3a59b1..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_or_replace_view8.q
+++ /dev/null
@@ -1,5 +0,0 @@
--- Can't update view to have a view cycle (2)
-
-drop view v;
-create view v1 partitioned on (ds, hr) as select * from srcpart;
-create or replace view v1 partitioned on (ds, hr) as select * from v1;
\ 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/create_skewed_table_col_name_value_no_mismatch.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_skewed_table_col_name_value_no_mismatch.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_skewed_table_col_name_value_no_mismatch.q
deleted file mode 100644
index 1d6574e..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_skewed_table_col_name_value_no_mismatch.q
+++ /dev/null
@@ -1,3 +0,0 @@
-set hive.mapred.supports.subdirectories=true;
-
-CREATE TABLE skewed_table (key STRING, value STRING) SKEWED BY (key) ON ((1),(5,8),(6));
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_skewed_table_dup_col_name.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_skewed_table_dup_col_name.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_skewed_table_dup_col_name.q
deleted file mode 100644
index 726f6dd..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_skewed_table_dup_col_name.q
+++ /dev/null
@@ -1,3 +0,0 @@
-set hive.mapred.supports.subdirectories=true;
-
-CREATE TABLE skewed_table (key STRING, value STRING) SKEWED BY (key,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/create_skewed_table_failure_invalid_col_name.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_skewed_table_failure_invalid_col_name.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_skewed_table_failure_invalid_col_name.q
deleted file mode 100644
index 30dd418..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_skewed_table_failure_invalid_col_name.q
+++ /dev/null
@@ -1,4 +0,0 @@
-set hive.mapred.supports.subdirectories=true;
-
-CREATE TABLE skewed_table (key STRING, value STRING) SKEWED BY (key_non) ON ((1),(5),(6));
-
\ 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/create_table_failure1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_table_failure1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_table_failure1.q
deleted file mode 100644
index e87c12b..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_table_failure1.q
+++ /dev/null
@@ -1 +0,0 @@
-create table table_in_database_creation_not_exist.test as select * from src limit 1;
\ 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/create_table_failure2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_table_failure2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_table_failure2.q
deleted file mode 100644
index 0bddae0..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_table_failure2.q
+++ /dev/null
@@ -1 +0,0 @@
-create table `table_in_database_creation_not_exist.test` as select * from src limit 1;
\ 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/create_table_failure3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_table_failure3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_table_failure3.q
deleted file mode 100644
index 9f9f5f6..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_table_failure3.q
+++ /dev/null
@@ -1 +0,0 @@
-create table table_in_database_creation_not_exist.test (a string);
\ 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/create_table_failure4.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_table_failure4.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_table_failure4.q
deleted file mode 100644
index 67745e0..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_table_failure4.q
+++ /dev/null
@@ -1 +0,0 @@
-create table `table_in_database_creation_not_exist.test` (a string);
\ 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/create_table_wrong_regex.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_table_wrong_regex.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_table_wrong_regex.q
deleted file mode 100644
index dc91c9c..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_table_wrong_regex.q
+++ /dev/null
@@ -1,4 +0,0 @@
-drop table aa;
-create table aa ( test STRING )
- ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'
- WITH SERDEPROPERTIES ("input.regex" = "[^\\](.*)", "output.format.string" = "$1s");
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_udaf_failure.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_udaf_failure.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_udaf_failure.q
deleted file mode 100644
index e0bb408..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_udaf_failure.q
+++ /dev/null
@@ -1,6 +0,0 @@
-CREATE TEMPORARY FUNCTION test_udaf AS 'org.apache.hadoop.hive.ql.udf.UDAFWrongArgLengthForTestCase';
-
-EXPLAIN
-SELECT test_udaf(length(src.value)) FROM src;
-
-SELECT test_udaf(length(src.value)) FROM src;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_unknown_genericudf.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_unknown_genericudf.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_unknown_genericudf.q
deleted file mode 100644
index 07010c1..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_unknown_genericudf.q
+++ /dev/null
@@ -1 +0,0 @@
-CREATE TEMPORARY FUNCTION dummy_genericudf AS 'org.apache.hadoop.hive.ql.udf.generic.DummyGenericUDF';
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_unknown_udf_udaf.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_unknown_udf_udaf.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_unknown_udf_udaf.q
deleted file mode 100644
index a243fff..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_unknown_udf_udaf.q
+++ /dev/null
@@ -1 +0,0 @@
-CREATE TEMPORARY FUNCTION dummy_function AS 'org.apache.hadoop.hive.ql.udf.DummyFunction';
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure1.q
deleted file mode 100644
index c9060c6..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure1.q
+++ /dev/null
@@ -1,6 +0,0 @@
-
-DROP VIEW xxx12;
-
--- views and tables share the same namespace
-CREATE TABLE xxx12(key int);
-CREATE VIEW xxx12 AS SELECT key FROM src;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure2.q
deleted file mode 100644
index 6fdcd4a..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure2.q
+++ /dev/null
@@ -1,6 +0,0 @@
-
-DROP VIEW xxx4;
-
--- views and tables share the same namespace
-CREATE VIEW xxx4 AS SELECT key FROM src;
-CREATE TABLE xxx4(key int);
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure3.q
deleted file mode 100644
index ad5fc49..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure3.q
+++ /dev/null
@@ -1,5 +0,0 @@
-DROP VIEW xxx13;
-
--- number of explicit view column defs must match underlying SELECT
-CREATE VIEW xxx13(x,y,z) AS
-SELECT key FROM src;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure4.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure4.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure4.q
deleted file mode 100644
index eecde65..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure4.q
+++ /dev/null
@@ -1,5 +0,0 @@
-DROP VIEW xxx5;
-
--- duplicate column names are illegal
-CREATE VIEW xxx5(x,x) AS
-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/create_view_failure5.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure5.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure5.q
deleted file mode 100644
index f720899..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure5.q
+++ /dev/null
@@ -1,9 +0,0 @@
-DROP VIEW xxx14;
-
--- Ideally (and according to SQL:200n), this should actually be legal,
--- but since internally we impose the new column descriptors by
--- reference to underlying name rather than position, we have to make
--- it illegal. There's an easy workaround (provide the unique names
--- via direct column aliases, e.g. SELECT key AS x, key AS y)
-CREATE VIEW xxx14(x,y) AS
-SELECT key,key FROM src;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure6.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure6.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure6.q
deleted file mode 100644
index 57f52a8..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure6.q
+++ /dev/null
@@ -1,6 +0,0 @@
-DROP VIEW xxx15;
-
--- should fail: baz is not a column
-CREATE VIEW xxx15
-PARTITIONED ON (baz)
-AS SELECT key FROM src;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure7.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure7.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure7.q
deleted file mode 100644
index 00d7f9f..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure7.q
+++ /dev/null
@@ -1,6 +0,0 @@
-DROP VIEW xxx16;
-
--- should fail: must have at least one non-partitioning column
-CREATE VIEW xxx16
-PARTITIONED ON (key)
-AS SELECT key FROM src;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure8.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure8.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure8.q
deleted file mode 100644
index 0829182..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure8.q
+++ /dev/null
@@ -1,6 +0,0 @@
-DROP VIEW xxx17;
-
--- should fail: partitioning key must be at end
-CREATE VIEW xxx17
-PARTITIONED ON (key)
-AS 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/create_view_failure9.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure9.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure9.q
deleted file mode 100644
index d7d44a4..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/create_view_failure9.q
+++ /dev/null
@@ -1,6 +0,0 @@
-DROP VIEW xxx18;
-
--- should fail: partitioning columns out of order
-CREATE VIEW xxx18
-PARTITIONED ON (value,key)
-AS SELECT key+1 as k2,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/ctas.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/ctas.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/ctas.q
deleted file mode 100644
index 507a7a7..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/ctas.q
+++ /dev/null
@@ -1,5 +0,0 @@
-
-
-create external table nzhang_ctas4 as 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/cte_recursion.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/cte_recursion.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/cte_recursion.q
deleted file mode 100644
index 2160b47..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/cte_recursion.q
+++ /dev/null
@@ -1,4 +0,0 @@
-explain
-with q1 as ( select key from q2 where key = '5'),
-q2 as ( select key from q1 where key = '5')
-select * from (select key from q1) a;
\ 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/cte_with_in_subquery.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/cte_with_in_subquery.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/cte_with_in_subquery.q
deleted file mode 100644
index e52a1d9..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/cte_with_in_subquery.q
+++ /dev/null
@@ -1 +0,0 @@
-select * from (with q1 as ( select key from q2 where key = '5') select * from q1) a;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/database_create_already_exists.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/database_create_already_exists.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/database_create_already_exists.q
deleted file mode 100644
index 3af7607..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/database_create_already_exists.q
+++ /dev/null
@@ -1,5 +0,0 @@
-SHOW DATABASES;
-
--- Try to create a database that already exists
-CREATE DATABASE test_db;
-CREATE DATABASE test_db;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/database_create_invalid_name.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/database_create_invalid_name.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/database_create_invalid_name.q
deleted file mode 100644
index 5d67495..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/database_create_invalid_name.q
+++ /dev/null
@@ -1,4 +0,0 @@
-SHOW DATABASES;
-
--- Try to create a database with an invalid name
-CREATE DATABASE `test.db`;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/database_drop_does_not_exist.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/database_drop_does_not_exist.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/database_drop_does_not_exist.q
deleted file mode 100644
index 66a940e..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/database_drop_does_not_exist.q
+++ /dev/null
@@ -1,4 +0,0 @@
-SHOW DATABASES;
-
--- Try to drop a database that does not exist
-DROP DATABASE does_not_exist;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/database_drop_not_empty.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/database_drop_not_empty.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/database_drop_not_empty.q
deleted file mode 100644
index ae5a443..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/database_drop_not_empty.q
+++ /dev/null
@@ -1,8 +0,0 @@
-SHOW DATABASES;
-
--- Try to drop a non-empty database
-CREATE DATABASE test_db;
-USE test_db;
-CREATE TABLE t(a INT);
-USE default;
-DROP DATABASE test_db;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/database_drop_not_empty_restrict.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/database_drop_not_empty_restrict.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/database_drop_not_empty_restrict.q
deleted file mode 100644
index e1cb81c..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/database_drop_not_empty_restrict.q
+++ /dev/null
@@ -1,8 +0,0 @@
-SHOW DATABASES;
-
--- Try to drop a non-empty database in restrict mode
-CREATE DATABASE db_drop_non_empty_restrict;
-USE db_drop_non_empty_restrict;
-CREATE TABLE t(a INT);
-USE default;
-DROP DATABASE db_drop_non_empty_restrict;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/database_switch_does_not_exist.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/database_switch_does_not_exist.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/database_switch_does_not_exist.q
deleted file mode 100644
index 5cd4697..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/database_switch_does_not_exist.q
+++ /dev/null
@@ -1,4 +0,0 @@
-SHOW DATABASES;
-
--- Try to switch to a database that does not exist
-USE does_not_exist;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/date_literal2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/date_literal2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/date_literal2.q
deleted file mode 100644
index 711dc9e..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/date_literal2.q
+++ /dev/null
@@ -1,2 +0,0 @@
--- Not in YYYY-MM-DD format
-SELECT DATE '2001/01/01' FROM src LIMIT 2;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/date_literal3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/date_literal3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/date_literal3.q
deleted file mode 100644
index 9483509..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/date_literal3.q
+++ /dev/null
@@ -1,2 +0,0 @@
--- Invalid date value
-SELECT DATE '2001-01-32' FROM src;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/dbtxnmgr_nodblock.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/dbtxnmgr_nodblock.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/dbtxnmgr_nodblock.q
deleted file mode 100644
index 1c658c7..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/dbtxnmgr_nodblock.q
+++ /dev/null
@@ -1,6 +0,0 @@
-set hive.support.concurrency=true;
-set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
-
-drop database if exists drop_nodblock;
-create database drop_nodblock;
-lock database drop_nodblock shared;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/dbtxnmgr_nodbunlock.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/dbtxnmgr_nodbunlock.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/dbtxnmgr_nodbunlock.q
deleted file mode 100644
index ef4b323..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/dbtxnmgr_nodbunlock.q
+++ /dev/null
@@ -1,6 +0,0 @@
-set hive.support.concurrency=true;
-set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
-
-drop database if exists drop_nodbunlock;
-create database drop_nodbunlock;
-unlock database drop_nodbunlock;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/dbtxnmgr_notablelock.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/dbtxnmgr_notablelock.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/dbtxnmgr_notablelock.q
deleted file mode 100644
index 4a0c6c2..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/dbtxnmgr_notablelock.q
+++ /dev/null
@@ -1,6 +0,0 @@
-set hive.support.concurrency=true;
-set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
-
-drop table if exists drop_notablelock;
-create table drop_notablelock (c int);
-lock table drop_notablelock shared;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/dbtxnmgr_notableunlock.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/dbtxnmgr_notableunlock.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/dbtxnmgr_notableunlock.q
deleted file mode 100644
index 0b00046..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/dbtxnmgr_notableunlock.q
+++ /dev/null
@@ -1,6 +0,0 @@
-set hive.support.concurrency=true;
-set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
-
-drop table if exists drop_notableunlock;
-create table drop_notableunlock (c int);
-unlock table drop_notableunlock;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/ddltime.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/ddltime.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/ddltime.q
deleted file mode 100644
index 3517a60..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/ddltime.q
+++ /dev/null
@@ -1,6 +0,0 @@
-
-create table T2 like srcpart;
-
-insert overwrite table T2 partition (ds = '2010-06-21', hr='1') select /*+ HOLD_DDLTIME */ key, value from src where key > 10;
-
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/decimal_precision.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/decimal_precision.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/decimal_precision.q
deleted file mode 100644
index f496498..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/decimal_precision.q
+++ /dev/null
@@ -1,10 +0,0 @@
-DROP TABLE IF EXISTS DECIMAL_PRECISION;
-
-CREATE TABLE DECIMAL_PRECISION(dec decimal)
-ROW FORMAT DELIMITED
- FIELDS TERMINATED BY ' '
-STORED AS TEXTFILE;
-
-SELECT dec * 123456789012345678901234567890.123456789bd FROM DECIMAL_PRECISION;
-
-DROP TABLE DECIMAL_PRECISION;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/decimal_precision_1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/decimal_precision_1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/decimal_precision_1.q
deleted file mode 100644
index 036ff1f..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/decimal_precision_1.q
+++ /dev/null
@@ -1,10 +0,0 @@
-DROP TABLE IF EXISTS DECIMAL_PRECISION;
-
-CREATE TABLE DECIMAL_PRECISION(dec decimal)
-ROW FORMAT DELIMITED
- FIELDS TERMINATED BY ' '
-STORED AS TEXTFILE;
-
-SELECT * from DECIMAL_PRECISION WHERE dec > 1234567890123456789.0123456789bd;
-
-DROP TABLE DECIMAL_PRECISION;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/default_partition_name.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/default_partition_name.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/default_partition_name.q
deleted file mode 100644
index 816b6cb..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/default_partition_name.q
+++ /dev/null
@@ -1,3 +0,0 @@
-create table default_partition_name (key int, value string) partitioned by (ds string);
-
-alter table default_partition_name add partition(ds='__HIVE_DEFAULT_PARTITION__');
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/deletejar.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/deletejar.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/deletejar.q
deleted file mode 100644
index 0bd6985..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/deletejar.q
+++ /dev/null
@@ -1,4 +0,0 @@
-
-ADD JAR ${system:maven.local.repository}/org/apache/hive/hive-it-test-serde/${system:hive.version}/hive-it-test-serde-${system:hive.version}.jar;
-DELETE JAR ${system:maven.local.repository}/org/apache/hive/hive-it-test-serde/${system:hive.version}/hive-it-test-serde-${system:hive.version}.jar;
-CREATE TABLE DELETEJAR(KEY STRING, VALUE STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.TestSerDe' STORED AS TEXTFILE;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/desc_failure1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/desc_failure1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/desc_failure1.q
deleted file mode 100644
index f7304b1..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/desc_failure1.q
+++ /dev/null
@@ -1 +0,0 @@
-DESC NonExistentTable;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/desc_failure2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/desc_failure2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/desc_failure2.q
deleted file mode 100644
index f28b610..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/desc_failure2.q
+++ /dev/null
@@ -1,2 +0,0 @@
-DESC srcpart;
-DESC srcpart PARTITION(ds='2012-04-08', hr='15');
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/desc_failure3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/desc_failure3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/desc_failure3.q
deleted file mode 100644
index bee0ea5..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/desc_failure3.q
+++ /dev/null
@@ -1,5 +0,0 @@
-CREATE DATABASE db1;
-CREATE TABLE db1.t1(key1 INT, value1 STRING) PARTITIONED BY (ds STRING, part STRING);
-
--- describe database.table.column
-DESCRIBE db1.t1.key1;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/describe_xpath1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/describe_xpath1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/describe_xpath1.q
deleted file mode 100644
index ea72f83..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/describe_xpath1.q
+++ /dev/null
@@ -1 +0,0 @@
-describe src_thrift.$elem$;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/describe_xpath2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/describe_xpath2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/describe_xpath2.q
deleted file mode 100644
index f1fee1a..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/describe_xpath2.q
+++ /dev/null
@@ -1 +0,0 @@
-describe src_thrift.$key$;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/describe_xpath3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/describe_xpath3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/describe_xpath3.q
deleted file mode 100644
index 4a11f68..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/describe_xpath3.q
+++ /dev/null
@@ -1 +0,0 @@
-describe src_thrift.lint.abc;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/describe_xpath4.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/describe_xpath4.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/describe_xpath4.q
deleted file mode 100644
index 0912bf1..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/describe_xpath4.q
+++ /dev/null
@@ -1 +0,0 @@
-describe src_thrift.mStringString.abc;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/disallow_incompatible_type_change_on1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/disallow_incompatible_type_change_on1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/disallow_incompatible_type_change_on1.q
deleted file mode 100644
index d0d748c..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/disallow_incompatible_type_change_on1.q
+++ /dev/null
@@ -1,17 +0,0 @@
-SET hive.metastore.disallow.incompatible.col.type.changes=true;
-SELECT * FROM src LIMIT 1;
-CREATE TABLE test_table123 (a INT, b MAP<STRING, STRING>) PARTITIONED BY (ds STRING) STORED AS SEQUENCEFILE;
-INSERT OVERWRITE TABLE test_table123 PARTITION(ds="foo1") SELECT 1, MAP("a1", "b1") FROM src LIMIT 1;
-SELECT * from test_table123 WHERE ds="foo1";
-ALTER TABLE test_table123 REPLACE COLUMNS (a INT, b MAP<STRING, STRING>);
-ALTER TABLE test_table123 REPLACE COLUMNS (a BIGINT, b MAP<STRING, STRING>);
-ALTER TABLE test_table123 REPLACE COLUMNS (a INT, b MAP<STRING, STRING>);
-ALTER TABLE test_table123 REPLACE COLUMNS (a DOUBLE, b MAP<STRING, STRING>);
-ALTER TABLE test_table123 REPLACE COLUMNS (a TINYINT, b MAP<STRING, STRING>);
-ALTER TABLE test_table123 REPLACE COLUMNS (a BOOLEAN, b MAP<STRING, STRING>);
-ALTER TABLE test_table123 REPLACE COLUMNS (a TINYINT, b MAP<STRING, STRING>);
-ALTER TABLE test_table123 CHANGE COLUMN a a_new BOOLEAN;
--- All the above ALTERs will succeed since they are between compatible types.
--- The following ALTER will fail as MAP<STRING, STRING> and STRING are not
--- compatible.
-ALTER TABLE test_table123 REPLACE COLUMNS (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/disallow_incompatible_type_change_on2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/disallow_incompatible_type_change_on2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/disallow_incompatible_type_change_on2.q
deleted file mode 100644
index 4460c3e..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/disallow_incompatible_type_change_on2.q
+++ /dev/null
@@ -1,6 +0,0 @@
-SET hive.metastore.disallow.incompatible.col.type.changes=true;
-SELECT * FROM src LIMIT 1;
-CREATE TABLE test_table123 (a INT, b STRING) PARTITIONED BY (ds STRING) STORED AS SEQUENCEFILE;
-INSERT OVERWRITE TABLE test_table123 PARTITION(ds="foo1") SELECT 1, "one" FROM src LIMIT 1;
-SELECT * from test_table123 WHERE ds="foo1";
-ALTER TABLE test_table123 CHANGE COLUMN b b MAP<STRING, STRING>;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/drop_func_nonexistent.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/drop_func_nonexistent.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/drop_func_nonexistent.q
deleted file mode 100644
index 892ef00..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/drop_func_nonexistent.q
+++ /dev/null
@@ -1,3 +0,0 @@
-set hive.exec.drop.ignorenonexistent=false;
--- Can't use DROP FUNCTION if the function doesn't exist and IF EXISTS isn't specified
-drop function nonexistent_function;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/drop_function_failure.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/drop_function_failure.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/drop_function_failure.q
deleted file mode 100644
index 51dc5e9..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/drop_function_failure.q
+++ /dev/null
@@ -1,3 +0,0 @@
-set hive.exec.drop.ignorenonexistent=false;
--- Can't use DROP TEMPORARY FUNCTION if the function doesn't exist and IF EXISTS isn't specified
-DROP TEMPORARY FUNCTION UnknownFunction;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/drop_index_failure.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/drop_index_failure.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/drop_index_failure.q
deleted file mode 100644
index 6e907df..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/drop_index_failure.q
+++ /dev/null
@@ -1,3 +0,0 @@
-set hive.exec.drop.ignorenonexistent=false;
--- Can't use DROP INDEX if the index doesn't exist and IF EXISTS isn't specified
-DROP INDEX UnknownIndex ON src;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/drop_native_udf.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/drop_native_udf.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/drop_native_udf.q
deleted file mode 100644
index ae047bb..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/drop_native_udf.q
+++ /dev/null
@@ -1 +0,0 @@
-DROP TEMPORARY FUNCTION max;
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@spark.apache.org
For additional commands, e-mail: commits-help@spark.apache.org