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:28 UTC
[2/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/subquery_subquery_chain.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/subquery_subquery_chain.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/subquery_subquery_chain.q
deleted file mode 100644
index 8ea94c5..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/subquery_subquery_chain.q
+++ /dev/null
@@ -1,6 +0,0 @@
-
-explain
-select *
-from src
-where src.key in (select key from src) in (select key from src)
-;
\ 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/subquery_unqual_corr_expr.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/subquery_unqual_corr_expr.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/subquery_unqual_corr_expr.q
deleted file mode 100644
index 99ff9ca..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/subquery_unqual_corr_expr.q
+++ /dev/null
@@ -1,6 +0,0 @@
-
-
-select *
-from src
-where key in (select key from src)
-;
\ 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/subquery_windowing_corr.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/subquery_windowing_corr.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/subquery_windowing_corr.q
deleted file mode 100644
index 105d3d2..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/subquery_windowing_corr.q
+++ /dev/null
@@ -1,26 +0,0 @@
-DROP TABLE part;
-
--- data setup
-CREATE TABLE part(
- p_partkey INT,
- p_name STRING,
- p_mfgr STRING,
- p_brand STRING,
- p_type STRING,
- p_size INT,
- p_container STRING,
- p_retailprice DOUBLE,
- p_comment STRING
-);
-
-LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part;
-
-
--- corr and windowing
-select p_mfgr, p_name, p_size
-from part a
-where a.p_size in
- (select first_value(p_size) over(partition by p_mfgr order by p_size)
- from part b
- where a.p_brand = b.p_brand)
-;
\ 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/subquery_with_or_cond.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/subquery_with_or_cond.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/subquery_with_or_cond.q
deleted file mode 100644
index c2c3221..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/subquery_with_or_cond.q
+++ /dev/null
@@ -1,5 +0,0 @@
-
-select count(*)
-from src
-where src.key in (select key from src s1 where s1.key > '9') or src.value is not null
-;
\ 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/touch1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/touch1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/touch1.q
deleted file mode 100644
index 9efbba0..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/touch1.q
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE srcpart TOUCH PARTITION (ds='2008-04-08', hr='13');
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/touch2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/touch2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/touch2.q
deleted file mode 100644
index 923a171..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/touch2.q
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE src TOUCH 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/truncate_bucketed_column.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_bucketed_column.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_bucketed_column.q
deleted file mode 100644
index e536656..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_bucketed_column.q
+++ /dev/null
@@ -1,7 +0,0 @@
--- Tests truncating a bucketed column
-
-CREATE TABLE test_tab (key STRING, value STRING) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS RCFILE;
-
-INSERT OVERWRITE TABLE test_tab SELECT * FROM src;
-
-TRUNCATE TABLE test_tab COLUMNS (key);
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_column_indexed_table.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_column_indexed_table.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_column_indexed_table.q
deleted file mode 100644
index 13f32c8..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_column_indexed_table.q
+++ /dev/null
@@ -1,9 +0,0 @@
--- Tests truncating a column from an indexed table
-
-CREATE TABLE test_tab (key STRING, value STRING) STORED AS RCFILE;
-
-INSERT OVERWRITE TABLE test_tab SELECT * FROM src;
-
-CREATE INDEX test_tab_index ON TABLE test_tab (key) as 'COMPACT' WITH DEFERRED REBUILD;
-
-TRUNCATE TABLE test_tab COLUMNS (value);
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_column_list_bucketing.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_column_list_bucketing.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_column_list_bucketing.q
deleted file mode 100644
index 0ece600..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_column_list_bucketing.q
+++ /dev/null
@@ -1,14 +0,0 @@
-set hive.mapred.supports.subdirectories=true;
-set mapred.input.dir.recursive=true;
-
--- Tests truncating a column on which a table is list bucketed
-
-CREATE TABLE test_tab (key STRING, value STRING) STORED AS RCFILE;
-
-ALTER TABLE test_tab
-SKEWED BY (key) ON ("484")
-STORED AS DIRECTORIES;
-
-INSERT OVERWRITE TABLE test_tab SELECT * FROM src;
-
-TRUNCATE TABLE test_tab COLUMNS (key);
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_column_seqfile.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_column_seqfile.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_column_seqfile.q
deleted file mode 100644
index 903540d..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_column_seqfile.q
+++ /dev/null
@@ -1,7 +0,0 @@
--- Tests truncating a column from a table stored as a sequence file
-
-CREATE TABLE test_tab (key STRING, value STRING) STORED AS SEQUENCEFILE;
-
-INSERT OVERWRITE TABLE test_tab SELECT * FROM src;
-
-TRUNCATE TABLE test_tab COLUMNS (key);
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_nonexistant_column.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_nonexistant_column.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_nonexistant_column.q
deleted file mode 100644
index 5509552..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_nonexistant_column.q
+++ /dev/null
@@ -1,7 +0,0 @@
--- Tests attempting to truncate a column in a table that doesn't exist
-
-CREATE TABLE test_tab (key STRING, value STRING) STORED AS RCFILE;
-
-INSERT OVERWRITE TABLE test_tab SELECT * FROM src;
-
-TRUNCATE TABLE test_tab COLUMNS (doesnt_exist);
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_partition_column.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_partition_column.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_partition_column.q
deleted file mode 100644
index 134743a..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_partition_column.q
+++ /dev/null
@@ -1,7 +0,0 @@
--- Tests truncating a partition column
-
-CREATE TABLE test_tab (key STRING, value STRING) PARTITIONED BY (part STRING) STORED AS RCFILE;
-
-INSERT OVERWRITE TABLE test_tab PARTITION (part = '1') SELECT * FROM src;
-
-TRUNCATE TABLE test_tab COLUMNS (part);
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_partition_column2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_partition_column2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_partition_column2.q
deleted file mode 100644
index 4763520..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_partition_column2.q
+++ /dev/null
@@ -1,7 +0,0 @@
--- Tests truncating a partition column
-
-CREATE TABLE test_tab (key STRING, value STRING) PARTITIONED BY (part STRING) STORED AS RCFILE;
-
-INSERT OVERWRITE TABLE test_tab PARTITION (part = '1') SELECT * FROM src;
-
-TRUNCATE TABLE test_tab PARTITION (part = '1') COLUMNS (part);
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_table_failure1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_table_failure1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_table_failure1.q
deleted file mode 100644
index f6cfa44..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_table_failure1.q
+++ /dev/null
@@ -1,2 +0,0 @@
--- partition spec for non-partitioned table
-TRUNCATE TABLE src 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/truncate_table_failure2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_table_failure2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_table_failure2.q
deleted file mode 100644
index 1137d89..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_table_failure2.q
+++ /dev/null
@@ -1,2 +0,0 @@
--- full partition spec for not existing partition
-TRUNCATE TABLE srcpart partition (ds='2012-12-17', hr='15');
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_table_failure3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_table_failure3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_table_failure3.q
deleted file mode 100644
index c5cf587..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_table_failure3.q
+++ /dev/null
@@ -1,4 +0,0 @@
-create external table external1 (a int, b int) partitioned by (ds string);
-
--- trucate for non-managed table
-TRUNCATE TABLE external1;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_table_failure4.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_table_failure4.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_table_failure4.q
deleted file mode 100644
index a7f1e92..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/truncate_table_failure4.q
+++ /dev/null
@@ -1,5 +0,0 @@
-CREATE TABLE non_native(key int, value string)
-STORED BY 'org.apache.hadoop.hive.ql.metadata.DefaultStorageHandler';
-
--- trucate for non-native table
-TRUNCATE TABLE non_native;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udaf_invalid_place.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udaf_invalid_place.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udaf_invalid_place.q
deleted file mode 100644
index f37ce72..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udaf_invalid_place.q
+++ /dev/null
@@ -1 +0,0 @@
-select distinct key, sum(key) from src;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_array_contains_wrong1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_array_contains_wrong1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_array_contains_wrong1.q
deleted file mode 100644
index c2a132d..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_array_contains_wrong1.q
+++ /dev/null
@@ -1,2 +0,0 @@
--- invalid first argument
-SELECT array_contains(1, 2) 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/udf_array_contains_wrong2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_array_contains_wrong2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_array_contains_wrong2.q
deleted file mode 100644
index 36f85d3..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_array_contains_wrong2.q
+++ /dev/null
@@ -1,2 +0,0 @@
--- invalid second argument
-SELECT array_contains(array(1, 2, 3), '2') 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/udf_assert_true.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_assert_true.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_assert_true.q
deleted file mode 100644
index 73b3f96..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_assert_true.q
+++ /dev/null
@@ -1,7 +0,0 @@
-DESCRIBE FUNCTION ASSERT_TRUE;
-
-EXPLAIN SELECT ASSERT_TRUE(x > 0) FROM src LATERAL VIEW EXPLODE(ARRAY(1, 2)) a AS x LIMIT 2;
-SELECT ASSERT_TRUE(x > 0) FROM src LATERAL VIEW EXPLODE(ARRAY(1, 2)) a AS x LIMIT 2;
-
-EXPLAIN SELECT ASSERT_TRUE(x < 2) FROM src LATERAL VIEW EXPLODE(ARRAY(1, 2)) a AS x LIMIT 2;
-SELECT ASSERT_TRUE(x < 2) FROM src LATERAL VIEW EXPLODE(ARRAY(1, 2)) a AS x LIMIT 2;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_assert_true2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_assert_true2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_assert_true2.q
deleted file mode 100644
index 4b62220..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_assert_true2.q
+++ /dev/null
@@ -1,2 +0,0 @@
-EXPLAIN SELECT 1 + ASSERT_TRUE(x < 2) FROM src LATERAL VIEW EXPLODE(ARRAY(1, 2)) a AS x LIMIT 2;
-SELECT 1 + ASSERT_TRUE(x < 2) FROM src LATERAL VIEW EXPLODE(ARRAY(1, 2)) a AS x LIMIT 2;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_coalesce.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_coalesce.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_coalesce.q
deleted file mode 100644
index 7405e38..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_coalesce.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT COALESCE(array('a', 'b'), '2.0') 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/udf_concat_ws_wrong1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_concat_ws_wrong1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_concat_ws_wrong1.q
deleted file mode 100644
index 8c2017b..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_concat_ws_wrong1.q
+++ /dev/null
@@ -1,2 +0,0 @@
--- invalid argument number
-SELECT concat_ws('-') 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/udf_concat_ws_wrong2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_concat_ws_wrong2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_concat_ws_wrong2.q
deleted file mode 100644
index c49e786..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_concat_ws_wrong2.q
+++ /dev/null
@@ -1,2 +0,0 @@
--- invalid argument type
-SELECT concat_ws('[]', array(100, 200, 50)) 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/udf_concat_ws_wrong3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_concat_ws_wrong3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_concat_ws_wrong3.q
deleted file mode 100644
index 72b8627..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_concat_ws_wrong3.q
+++ /dev/null
@@ -1,2 +0,0 @@
--- invalid argument type
-SELECT concat_ws(1234, array('www', 'facebook', 'com')) 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/udf_elt_wrong_args_len.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_elt_wrong_args_len.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_elt_wrong_args_len.q
deleted file mode 100644
index fbe4902..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_elt_wrong_args_len.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT elt(3) FROM src;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_elt_wrong_type.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_elt_wrong_type.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_elt_wrong_type.q
deleted file mode 100644
index bb1fdbf..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_elt_wrong_type.q
+++ /dev/null
@@ -1,3 +0,0 @@
-FROM src_thrift
-SELECT elt(1, src_thrift.lintstring)
-WHERE src_thrift.lintstring IS NOT NULL;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_field_wrong_args_len.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_field_wrong_args_len.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_field_wrong_args_len.q
deleted file mode 100644
index 9703c82..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_field_wrong_args_len.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT field(3) FROM src;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_field_wrong_type.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_field_wrong_type.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_field_wrong_type.q
deleted file mode 100644
index 61b2cd0..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_field_wrong_type.q
+++ /dev/null
@@ -1,3 +0,0 @@
-FROM src_thrift
-SELECT field(1, src_thrift.lintstring)
-WHERE src_thrift.lintstring IS NOT NULL;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_format_number_wrong1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_format_number_wrong1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_format_number_wrong1.q
deleted file mode 100644
index 18c985c..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_format_number_wrong1.q
+++ /dev/null
@@ -1,2 +0,0 @@
--- invalid argument length
-SELECT format_number(12332.123456) 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/udf_format_number_wrong2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_format_number_wrong2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_format_number_wrong2.q
deleted file mode 100644
index 7959c20..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_format_number_wrong2.q
+++ /dev/null
@@ -1,2 +0,0 @@
--- invalid argument length
-SELECT format_number(12332.123456, 2, 3) 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/udf_format_number_wrong3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_format_number_wrong3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_format_number_wrong3.q
deleted file mode 100644
index 7d90ef8..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_format_number_wrong3.q
+++ /dev/null
@@ -1,2 +0,0 @@
--- invalid argument(second argument should be >= 0)
-SELECT format_number(12332.123456, -4) 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/udf_format_number_wrong4.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_format_number_wrong4.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_format_number_wrong4.q
deleted file mode 100644
index e545f4a..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_format_number_wrong4.q
+++ /dev/null
@@ -1,2 +0,0 @@
--- invalid argument type
-SELECT format_number(12332.123456, 4.01) 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/udf_format_number_wrong5.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_format_number_wrong5.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_format_number_wrong5.q
deleted file mode 100644
index a6f7177..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_format_number_wrong5.q
+++ /dev/null
@@ -1,2 +0,0 @@
--- invalid argument type
-SELECT format_number(array(12332.123456, 321.23), 5) 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/udf_format_number_wrong6.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_format_number_wrong6.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_format_number_wrong6.q
deleted file mode 100644
index e5b11b9..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_format_number_wrong6.q
+++ /dev/null
@@ -1,2 +0,0 @@
--- invalid argument type
-SELECT format_number(12332.123456, "4") 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/udf_format_number_wrong7.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_format_number_wrong7.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_format_number_wrong7.q
deleted file mode 100644
index aa4a3a4..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_format_number_wrong7.q
+++ /dev/null
@@ -1,2 +0,0 @@
--- invalid argument type(format_number returns the result as a string)
-SELECT format_number(format_number(12332.123456, 4), 2) 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/udf_function_does_not_implement_udf.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_function_does_not_implement_udf.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_function_does_not_implement_udf.q
deleted file mode 100644
index 21ca6e7..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_function_does_not_implement_udf.q
+++ /dev/null
@@ -1 +0,0 @@
-CREATE TEMPORARY FUNCTION moo AS 'org.apache.hadoop.hive.ql.Driver';
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_if_not_bool.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_if_not_bool.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_if_not_bool.q
deleted file mode 100644
index 74458d0..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_if_not_bool.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT IF('STRING', 1, 1) FROM src;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_if_wrong_args_len.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_if_wrong_args_len.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_if_wrong_args_len.q
deleted file mode 100644
index ad19364..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_if_wrong_args_len.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT IF(TRUE, 1) FROM src;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_in.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_in.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_in.q
deleted file mode 100644
index ce9ce54..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_in.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT 3 IN (array(1,2,3)) FROM src;
\ 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/udf_instr_wrong_args_len.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_instr_wrong_args_len.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_instr_wrong_args_len.q
deleted file mode 100644
index ac8253f..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_instr_wrong_args_len.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT instr('abcd') FROM src;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_instr_wrong_type.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_instr_wrong_type.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_instr_wrong_type.q
deleted file mode 100644
index 9ac3ed6..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_instr_wrong_type.q
+++ /dev/null
@@ -1,3 +0,0 @@
-FROM src_thrift
-SELECT instr('abcd', src_thrift.lintstring)
-WHERE src_thrift.lintstring IS NOT NULL;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_invalid.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_invalid.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_invalid.q
deleted file mode 100644
index 68050fd..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_invalid.q
+++ /dev/null
@@ -1 +0,0 @@
-select default.nonexistfunc() from src;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_local_resource.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_local_resource.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_local_resource.q
deleted file mode 100644
index bcfa217..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_local_resource.q
+++ /dev/null
@@ -1 +0,0 @@
-create function lookup as 'org.apache.hadoop.hive.ql.udf.UDFFileLookup' using file '../../data/files/sales.txt';
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_locate_wrong_args_len.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_locate_wrong_args_len.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_locate_wrong_args_len.q
deleted file mode 100644
index ca7caad..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_locate_wrong_args_len.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT locate('a', 'b', 1, 2) FROM src;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_locate_wrong_type.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_locate_wrong_type.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_locate_wrong_type.q
deleted file mode 100644
index 4bbf79a..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_locate_wrong_type.q
+++ /dev/null
@@ -1,3 +0,0 @@
-FROM src_thrift
-SELECT locate('abcd', src_thrift.lintstring)
-WHERE src_thrift.lintstring IS NOT NULL;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_map_keys_arg_num.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_map_keys_arg_num.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_map_keys_arg_num.q
deleted file mode 100644
index ebb6c2a..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_map_keys_arg_num.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT map_keys(map("a", "1"), map("b", "2")) 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/udf_map_keys_arg_type.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_map_keys_arg_type.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_map_keys_arg_type.q
deleted file mode 100644
index 0757d14..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_map_keys_arg_type.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT map_keys(array(1, 2, 3)) 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/udf_map_values_arg_num.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_map_values_arg_num.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_map_values_arg_num.q
deleted file mode 100644
index c97476a..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_map_values_arg_num.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT map_values(map("a", "1"), map("b", "2")) 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/udf_map_values_arg_type.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_map_values_arg_type.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_map_values_arg_type.q
deleted file mode 100644
index cc060ea..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_map_values_arg_type.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT map_values(array(1, 2, 3, 4)) 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/udf_max.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_max.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_max.q
deleted file mode 100644
index 7282e07..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_max.q
+++ /dev/null
@@ -1,2 +0,0 @@
-SELECT max(map("key", key, "value", value))
-FROM src;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_min.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_min.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_min.q
deleted file mode 100644
index b9528fa..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_min.q
+++ /dev/null
@@ -1,2 +0,0 @@
-SELECT min(map("key", key, "value", value))
-FROM src;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_nonexistent_resource.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_nonexistent_resource.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_nonexistent_resource.q
deleted file mode 100644
index d37665d..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_nonexistent_resource.q
+++ /dev/null
@@ -1 +0,0 @@
-create function lookup as 'org.apache.hadoop.hive.ql.udf.UDFFileLookup' using file 'nonexistent_file.txt';
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_printf_wrong1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_printf_wrong1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_printf_wrong1.q
deleted file mode 100644
index 88ca4fe..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_printf_wrong1.q
+++ /dev/null
@@ -1,2 +0,0 @@
--- invalid argument length
-SELECT printf() 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/udf_printf_wrong2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_printf_wrong2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_printf_wrong2.q
deleted file mode 100644
index 01ed2ff..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_printf_wrong2.q
+++ /dev/null
@@ -1,2 +0,0 @@
--- invalid argument type
-SELECT printf(100) 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/udf_printf_wrong3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_printf_wrong3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_printf_wrong3.q
deleted file mode 100644
index 71f118b..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_printf_wrong3.q
+++ /dev/null
@@ -1,2 +0,0 @@
--- invalid argument type
-SELECT printf("Hello World %s", array("invalid", "argument")) 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/udf_printf_wrong4.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_printf_wrong4.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_printf_wrong4.q
deleted file mode 100644
index 71f118b..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_printf_wrong4.q
+++ /dev/null
@@ -1,2 +0,0 @@
--- invalid argument type
-SELECT printf("Hello World %s", array("invalid", "argument")) 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/udf_qualified_name.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_qualified_name.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_qualified_name.q
deleted file mode 100644
index 476dfa2..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_qualified_name.q
+++ /dev/null
@@ -1 +0,0 @@
-create temporary function default.myfunc as 'org.apache.hadoop.hive.ql.udf.generic.GenericUDAFSum';
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_reflect_neg.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_reflect_neg.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_reflect_neg.q
deleted file mode 100644
index 67efb64..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_reflect_neg.q
+++ /dev/null
@@ -1,9 +0,0 @@
-SELECT reflect("java.lang.StringClassThatDoesNotExist", "valueOf", 1),
- reflect("java.lang.String", "methodThatDoesNotExist"),
- reflect("java.lang.Math", "max", "overloadthatdoesnotexist", 3),
- reflect("java.lang.Math", "min", 2, 3),
- reflect("java.lang.Math", "round", 2.5),
- reflect("java.lang.Math", "exp", 1.0),
- reflect("java.lang.Math", "floor", 1.9)
-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/udf_size_wrong_args_len.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_size_wrong_args_len.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_size_wrong_args_len.q
deleted file mode 100644
index c628ff8..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_size_wrong_args_len.q
+++ /dev/null
@@ -1,5 +0,0 @@
-FROM src_thrift
-SELECT size(src_thrift.lint, src_thrift.lintstring),
- size()
-WHERE src_thrift.lint IS NOT NULL
- AND NOT (src_thrift.mstringstring IS NULL) LIMIT 1;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_size_wrong_type.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_size_wrong_type.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_size_wrong_type.q
deleted file mode 100644
index 16695f6..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_size_wrong_type.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT SIZE('wrong type: string') FROM src;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_sort_array_wrong1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_sort_array_wrong1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_sort_array_wrong1.q
deleted file mode 100644
index 9954f4a..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_sort_array_wrong1.q
+++ /dev/null
@@ -1,2 +0,0 @@
--- invalid argument number
-SELECT sort_array(array(2, 5, 4), 3) 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/udf_sort_array_wrong2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_sort_array_wrong2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_sort_array_wrong2.q
deleted file mode 100644
index 32c2645..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_sort_array_wrong2.q
+++ /dev/null
@@ -1,2 +0,0 @@
--- invalid argument type
-SELECT sort_array("Invalid") 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/udf_sort_array_wrong3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_sort_array_wrong3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_sort_array_wrong3.q
deleted file mode 100644
index 034de06..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_sort_array_wrong3.q
+++ /dev/null
@@ -1,2 +0,0 @@
--- invalid argument type
-SELECT sort_array(array(array(10, 20), array(5, 15), array(3, 13))) 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/udf_test_error.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_test_error.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_test_error.q
deleted file mode 100644
index 846f87c..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_test_error.q
+++ /dev/null
@@ -1,3 +0,0 @@
-CREATE TEMPORARY FUNCTION test_error AS 'org.apache.hadoop.hive.ql.udf.UDFTestErrorOnFalse';
-
-SELECT test_error(key < 125 OR key > 130) FROM src;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_test_error_reduce.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_test_error_reduce.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_test_error_reduce.q
deleted file mode 100644
index b1a06f2..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_test_error_reduce.q
+++ /dev/null
@@ -1,11 +0,0 @@
-CREATE TEMPORARY FUNCTION test_error AS 'org.apache.hadoop.hive.ql.udf.UDFTestErrorOnFalse';
-
-
-SELECT test_error(key < 125 OR key > 130)
-FROM (
- SELECT *
- FROM src
- DISTRIBUTE BY rand()
-) map_output;
-
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_when_type_wrong.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_when_type_wrong.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_when_type_wrong.q
deleted file mode 100644
index d4d2d2e..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udf_when_type_wrong.q
+++ /dev/null
@@ -1,6 +0,0 @@
-SELECT CASE
- WHEN TRUE THEN 2
- WHEN '1' THEN 4
- ELSE 5
- END
-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/udtf_explode_not_supported1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udtf_explode_not_supported1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udtf_explode_not_supported1.q
deleted file mode 100644
index 942ae5d..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udtf_explode_not_supported1.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT explode(map(1,'one',2,'two',3,'three')) as (myKey,myVal) FROM src GROUP BY key;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udtf_explode_not_supported2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udtf_explode_not_supported2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udtf_explode_not_supported2.q
deleted file mode 100644
index 00d359a..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udtf_explode_not_supported2.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT explode(map(1,'one',2,'two',3,'three')) as (myKey,myVal,myVal2) FROM src;
\ 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/udtf_explode_not_supported3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udtf_explode_not_supported3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udtf_explode_not_supported3.q
deleted file mode 100644
index 51df8fa..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udtf_explode_not_supported3.q
+++ /dev/null
@@ -1 +0,0 @@
-select explode(array(1),array(2)) as myCol from src;
\ 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/udtf_explode_not_supported4.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udtf_explode_not_supported4.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udtf_explode_not_supported4.q
deleted file mode 100644
index ae8dff7..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udtf_explode_not_supported4.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT explode(null) as myNull FROM src GROUP BY 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/udtf_invalid_place.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udtf_invalid_place.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udtf_invalid_place.q
deleted file mode 100644
index ab84a80..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udtf_invalid_place.q
+++ /dev/null
@@ -1 +0,0 @@
-select distinct key, explode(key) from src;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udtf_not_supported1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udtf_not_supported1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udtf_not_supported1.q
deleted file mode 100644
index 04e98d5..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udtf_not_supported1.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT explode(array(1,2,3)) as myCol, key FROM src;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udtf_not_supported3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udtf_not_supported3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udtf_not_supported3.q
deleted file mode 100644
index f4fe0dd..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/udtf_not_supported3.q
+++ /dev/null
@@ -1 +0,0 @@
-SELECT explode(array(1,2,3)) as myCol FROM src GROUP BY key;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/union2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/union2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/union2.q
deleted file mode 100644
index 38db488..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/union2.q
+++ /dev/null
@@ -1,13 +0,0 @@
-
-
-create table if not exists union2_t1(r string, c string, v array<string>);
-create table if not exists union2_t2(s string, c string, v string);
-
-explain
-SELECT s.r, s.c, sum(s.v)
-FROM (
- SELECT a.r AS r, a.c AS c, a.v AS v FROM union2_t1 a
- UNION ALL
- SELECT b.s AS r, b.c AS c, 0 + b.v AS v FROM union2_t2 b
-) s
-GROUP BY s.r, s.c;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/union22.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/union22.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/union22.q
deleted file mode 100644
index 72f3314..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/union22.q
+++ /dev/null
@@ -1,26 +0,0 @@
-create table dst_union22(k1 string, k2 string, k3 string, k4 string) partitioned by (ds string);
-create table dst_union22_delta(k0 string, k1 string, k2 string, k3 string, k4 string, k5 string) partitioned by (ds string);
-
-insert overwrite table dst_union22 partition (ds='1')
-select key, value, key , value from src;
-
-insert overwrite table dst_union22_delta partition (ds='1')
-select key, key, value, key, value, value from src;
-
-set hive.merge.mapfiles=false;
-
--- Union 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 dst_union22 partition (ds='2')
-select * from
-(
-select k1 as k1, k2 as k2, k3 as k3, k4 as k4 from dst_union22_delta where ds = '1' and k0 <= 50
-union all
-select /*+ MAPJOIN(b) */ a.k1 as k1, a.k2 as k2, b.k3 as k3, b.k4 as k4
-from dst_union22 a left outer join (select * from dst_union22_delta where ds = '1' and k0 > 50) b on
-a.k1 = b.k1 and a.ds='1'
-where a.k1 > 20
-)
-subq;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/union3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/union3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/union3.q
deleted file mode 100644
index ce65747..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/union3.q
+++ /dev/null
@@ -1,5 +0,0 @@
--- Ensure that UNION ALL columns are in the correct order on both sides
--- Ensure that the appropriate error message is propagated
-CREATE TABLE IF NOT EXISTS union3 (bar int, baz int);
-SELECT * FROM ( SELECT f.bar, f.baz FROM union3 f UNION ALL SELECT b.baz, b.bar FROM union3 b ) c;
-DROP TABLE union3;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/uniquejoin.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/uniquejoin.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/uniquejoin.q
deleted file mode 100644
index d6a19c3..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/uniquejoin.q
+++ /dev/null
@@ -1,3 +0,0 @@
-FROM UNIQUEJOIN (SELECT src.key from src WHERE src.key<4) a (a.key), PRESERVE src b(b.key)
-SELECT a.key, b.key;
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/uniquejoin2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/uniquejoin2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/uniquejoin2.q
deleted file mode 100644
index 6e9a082..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/uniquejoin2.q
+++ /dev/null
@@ -1,3 +0,0 @@
-FROM UNIQUEJOIN src a (a.key), PRESERVE src b (b.key, b.val)
-SELECT a.key, b.key;
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/uniquejoin3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/uniquejoin3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/uniquejoin3.q
deleted file mode 100644
index 89a8f1b..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/uniquejoin3.q
+++ /dev/null
@@ -1,3 +0,0 @@
-FROM UNIQUEJOIN src a (a.key), PRESERVE src b (b.key) JOIN src c ON c.key
-SELECT a.key;
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/unset_table_property.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/unset_table_property.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/unset_table_property.q
deleted file mode 100644
index 7a24e65..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/unset_table_property.q
+++ /dev/null
@@ -1,6 +0,0 @@
-CREATE TABLE testTable(col1 INT, col2 INT);
-ALTER TABLE testTable SET TBLPROPERTIES ('a'='1', 'c'='3');
-SHOW TBLPROPERTIES testTable;
-
--- unset a subset of the properties and some non-existed properties without if exists
-ALTER TABLE testTable UNSET TBLPROPERTIES ('c', 'x', 'y', 'z');
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/unset_view_property.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/unset_view_property.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/unset_view_property.q
deleted file mode 100644
index 1113100..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/unset_view_property.q
+++ /dev/null
@@ -1,6 +0,0 @@
-CREATE VIEW testView AS SELECT value FROM src WHERE key=86;
-ALTER VIEW testView SET TBLPROPERTIES ('propA'='100', 'propB'='200');
-SHOW TBLPROPERTIES testView;
-
--- unset a subset of the properties and some non-existed properties without if exists
-ALTER VIEW testView UNSET TBLPROPERTIES ('propB', 'propX', 'propY', 'propZ');
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/windowing_invalid_udaf.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/windowing_invalid_udaf.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/windowing_invalid_udaf.q
deleted file mode 100644
index c5b593e..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/windowing_invalid_udaf.q
+++ /dev/null
@@ -1 +0,0 @@
-select nonexistfunc(key) over () 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/windowing_leadlag_in_udaf.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/windowing_leadlag_in_udaf.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/windowing_leadlag_in_udaf.q
deleted file mode 100644
index b54b7a5..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/windowing_leadlag_in_udaf.q
+++ /dev/null
@@ -1,15 +0,0 @@
-DROP TABLE part;
-
-CREATE TABLE part(
- p_partkey INT,
- p_name STRING,
- p_mfgr STRING,
- p_brand STRING,
- p_type STRING,
- p_size INT,
- p_container STRING,
- p_retailprice DOUBLE,
- p_comment STRING
-);
-
-select sum(lead(p_retailprice,1)) as s1 from part;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/windowing_ll_no_neg.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/windowing_ll_no_neg.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/windowing_ll_no_neg.q
deleted file mode 100644
index 15f8fae..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/windowing_ll_no_neg.q
+++ /dev/null
@@ -1,26 +0,0 @@
-DROP TABLE IF EXISTS part;
-
--- data setup
-CREATE TABLE part(
- p_partkey INT,
- p_name STRING,
- p_mfgr STRING,
- p_brand STRING,
- p_type STRING,
- p_size INT,
- p_container STRING,
- p_retailprice DOUBLE,
- p_comment STRING
-);
-
-LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part;
-
-
-select p_mfgr, p_name, p_size,
-min(p_retailprice),
-rank() over(distribute by p_mfgr sort by p_name)as r,
-dense_rank() over(distribute by p_mfgr sort by p_name) as dr,
-p_size, p_size - lag(p_size,-1,p_size) over(distribute by p_mfgr sort by p_name) as deltaSz
-from part
-group by p_mfgr, p_name, p_size
-;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/windowing_ll_no_over.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/windowing_ll_no_over.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/windowing_ll_no_over.q
deleted file mode 100644
index 3ca1104..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/windowing_ll_no_over.q
+++ /dev/null
@@ -1,17 +0,0 @@
-DROP TABLE part;
-
-CREATE TABLE part(
- p_partkey INT,
- p_name STRING,
- p_mfgr STRING,
- p_brand STRING,
- p_type STRING,
- p_size INT,
- p_container STRING,
- p_retailprice DOUBLE,
- p_comment STRING
-);
-
-select p_mfgr,
-lead(p_retailprice,1) as s1
-from part;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/wrong_column_type.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/wrong_column_type.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/wrong_column_type.q
deleted file mode 100644
index 490f0c3..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/wrong_column_type.q
+++ /dev/null
@@ -1,4 +0,0 @@
-CREATE TABLE dest1(a float);
-
-INSERT OVERWRITE TABLE dest1
-SELECT array(1.0,2.0) FROM src;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/ambiguous_join_col.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/ambiguous_join_col.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/ambiguous_join_col.q
deleted file mode 100644
index e70aae4..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/ambiguous_join_col.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src src1 JOIN src src2 ON src1.key = src2.key
-INSERT OVERWRITE TABLE dest1 SELECT key
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/duplicate_alias.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/duplicate_alias.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/duplicate_alias.q
deleted file mode 100644
index 5fd2246..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/duplicate_alias.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src a JOIN src a ON (a.key = a.key)
-INSERT OVERWRITE TABLE dest1 SELECT a.key, a.value
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/garbage.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/garbage.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/garbage.q
deleted file mode 100644
index 6c8c751..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/garbage.q
+++ /dev/null
@@ -1 +0,0 @@
-this is totally garbage SELECT src.key WHERE a lot of garbage
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/insert_wrong_number_columns.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/insert_wrong_number_columns.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/insert_wrong_number_columns.q
deleted file mode 100644
index aadfbde..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/insert_wrong_number_columns.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value, 1 WHERE src.key < 100
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_create_table.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_create_table.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_create_table.q
deleted file mode 100644
index 899bbd3..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_create_table.q
+++ /dev/null
@@ -1,4 +0,0 @@
-CREATE TABLE mytable (
- a INT
- b STRING
-);
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_dot.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_dot.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_dot.q
deleted file mode 100644
index 36b9bd2..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_dot.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-INSERT OVERWRITE TABLE dest1 SELECT src.value.member WHERE src.key < 100
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_function_param2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_function_param2.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_function_param2.q
deleted file mode 100644
index 3543449..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_function_param2.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-INSERT OVERWRITE TABLE dest1 SELECT substr('1234', 'abc'), src.value WHERE src.key < 100
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_index.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_index.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_index.q
deleted file mode 100644
index 146bc5d..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_index.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-INSERT OVERWRITE TABLE dest1 SELECT src.key[0], src.value
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_list_index.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_list_index.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_list_index.q
deleted file mode 100644
index c40f079..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_list_index.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src_thrift
-INSERT OVERWRITE TABLE dest1 SELECT src_thrift.lint[0], src_thrift.lstring['abc']
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_list_index2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_list_index2.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_list_index2.q
deleted file mode 100644
index 99d0b3d..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_list_index2.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src_thrift
-INSERT OVERWRITE TABLE dest1 SELECT src_thrift.lint[0], src_thrift.lstring[1 + 2]
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_map_index.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_map_index.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_map_index.q
deleted file mode 100644
index c2b9eab..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_map_index.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src_thrift
-INSERT OVERWRITE TABLE dest1 SELECT src_thrift.lint[0], src_thrift.mstringstring[0]
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_map_index2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_map_index2.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_map_index2.q
deleted file mode 100644
index 5828f07..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_map_index2.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src_thrift
-INSERT OVERWRITE TABLE dest1 SELECT src_thrift.lint[0], src_thrift.mstringstring[concat('abc', 'abc')]
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_select.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_select.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_select.q
deleted file mode 100644
index fd12985..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/invalid_select.q
+++ /dev/null
@@ -1,4 +0,0 @@
-SELECT
- trim(trim(a))
- trim(b)
-FROM src;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/macro_reserved_word.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/macro_reserved_word.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/macro_reserved_word.q
deleted file mode 100644
index 359eb9d..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/macro_reserved_word.q
+++ /dev/null
@@ -1 +0,0 @@
-CREATE TEMPORARY MACRO DOUBLE (x DOUBLE) 1.0 / (1.0 + EXP(-x));
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/missing_overwrite.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/missing_overwrite.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/missing_overwrite.q
deleted file mode 100644
index 1bfeee3..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/missing_overwrite.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-INSERT TABLE dest1 SELECT '1234', src.value WHERE src.key < 100
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/nonkey_groupby.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/nonkey_groupby.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/nonkey_groupby.q
deleted file mode 100644
index ad0f441..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/nonkey_groupby.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-INSERT OVERWRITE TABLE dest1 SELECT '1234', src.value WHERE src.key < 100 group by src.key
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/quoted_string.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/quoted_string.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/quoted_string.q
deleted file mode 100644
index 0252a9e..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/quoted_string.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-INSERT OVERWRITE TABLE dest1 SELECT '1234", src.value WHERE src.key < 100
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_column1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_column1.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_column1.q
deleted file mode 100644
index 429cead..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_column1.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-INSERT OVERWRITE TABLE dest1 SELECT '1234', src.dummycol WHERE src.key < 100
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_column2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_column2.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_column2.q
deleted file mode 100644
index 3767dc4..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_column2.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-INSERT OVERWRITE TABLE dest1 SELECT '1234', src.value WHERE src.dummykey < 100
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_column3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_column3.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_column3.q
deleted file mode 100644
index 2fc5f49..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_column3.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-INSERT OVERWRITE TABLE dest1 SELECT '1234', src.value WHERE src.key < 100 group by src.dummycol
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_column4.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_column4.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_column4.q
deleted file mode 100644
index 8ad8dd1..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_column4.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-INSERT OVERWRITE TABLE dest1 SELECT '1234', src.value WHERE src.key < 100 group by dummysrc.key
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_column5.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_column5.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_column5.q
deleted file mode 100644
index 766b0e5..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_column5.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-INSERT OVERWRITE TABLE dest1 SELECT '1234', src.value WHERE dummysrc.key < 100 group by src.key
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_column6.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_column6.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_column6.q
deleted file mode 100644
index bb76c28..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_column6.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-INSERT OVERWRITE TABLE dest1 SELECT '1234', dummysrc.value WHERE src.key < 100 group by src.key
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_function1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_function1.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_function1.q
deleted file mode 100644
index d8ff632..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_function1.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-INSERT OVERWRITE TABLE dest1 SELECT '1234', dummyfn(src.value, 10) WHERE src.key < 100
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_function2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_function2.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_function2.q
deleted file mode 100644
index f7d2559..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_function2.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-INSERT OVERWRITE TABLE dest1 SELECT '1234', src.value WHERE anotherdummyfn('abc', src.key) + 10 < 100
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_function3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_function3.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_function3.q
deleted file mode 100644
index 87d4edc..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_function3.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-INSERT OVERWRITE TABLE dest1 SELECT '1234', src.value WHERE anotherdummyfn('abc', src.key) + 10 < 100 group by src.key
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_function4.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_function4.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_function4.q
deleted file mode 100644
index cfe70e4..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_function4.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-INSERT OVERWRITE TABLE dest1 SELECT '1234', dummyfn(src.key) WHERE src.key < 100 group by src.key
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_table1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_table1.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_table1.q
deleted file mode 100644
index 585ef6d..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_table1.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM dummySrc
-INSERT OVERWRITE TABLE dest1 SELECT '1234', src.value WHERE src.key < 100
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_table2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_table2.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_table2.q
deleted file mode 100644
index 2c69c16..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/unknown_table2.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-INSERT OVERWRITE TABLE dummyDest SELECT '1234', src.value WHERE src.key < 100
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/wrong_distinct1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/wrong_distinct1.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/wrong_distinct1.q
deleted file mode 100755
index d92c3bb..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/wrong_distinct1.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-INSERT OVERWRITE TABLE dest1 SELECT DISTINCT src.key, substr(src.value,4,1) GROUP BY src.key
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/negative/wrong_distinct2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/negative/wrong_distinct2.q b/sql/hive/src/test/resources/ql/src/test/queries/negative/wrong_distinct2.q
deleted file mode 100755
index 53fb550..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/negative/wrong_distinct2.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-INSERT OVERWRITE TABLE dest1 SELECT src.key, DISTINCT substr(src.value,4,1) GROUP BY src.key
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/positive/case_sensitivity.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/positive/case_sensitivity.q b/sql/hive/src/test/resources/ql/src/test/queries/positive/case_sensitivity.q
deleted file mode 100644
index d7f7371..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/positive/case_sensitivity.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM SRC_THRIFT
-INSERT OVERWRITE TABLE dest1 SELECT src_Thrift.LINT[1], src_thrift.lintstring[0].MYSTRING where src_thrift.liNT[0] > 0
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/positive/cast1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/positive/cast1.q b/sql/hive/src/test/resources/ql/src/test/queries/positive/cast1.q
deleted file mode 100644
index 6269c6a..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/positive/cast1.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-SELECT 3 + 2, 3.0 + 2, 3 + 2.0, 3.0 + 2.0, 3 + CAST(2.0 AS INT), CAST(1 AS BOOLEAN), CAST(TRUE AS INT) WHERE src.key = 86
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/positive/groupby1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/positive/groupby1.q b/sql/hive/src/test/resources/ql/src/test/queries/positive/groupby1.q
deleted file mode 100755
index 96b29b0..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/positive/groupby1.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-INSERT OVERWRITE TABLE dest1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/positive/groupby2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/positive/groupby2.q b/sql/hive/src/test/resources/ql/src/test/queries/positive/groupby2.q
deleted file mode 100755
index d741eb6..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/positive/groupby2.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(src.key,1,1),sum(substr(src.value,5))) GROUP BY substr(src.key,1,1)
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/positive/groupby3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/positive/groupby3.q b/sql/hive/src/test/resources/ql/src/test/queries/positive/groupby3.q
deleted file mode 100755
index 03b1248..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/positive/groupby3.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-SELECT sum(substr(src.value,5)), avg(substr(src.value,5)), avg(DISTINCT substr(src.value,5)), max(substr(src.value,5)), min(substr(src.value,5))
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/positive/groupby4.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/positive/groupby4.q b/sql/hive/src/test/resources/ql/src/test/queries/positive/groupby4.q
deleted file mode 100755
index 85271a9..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/positive/groupby4.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-SELECT substr(src.key,1,1) GROUP BY substr(src.key,1,1)
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/positive/groupby5.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/positive/groupby5.q b/sql/hive/src/test/resources/ql/src/test/queries/positive/groupby5.q
deleted file mode 100755
index ebd65b3..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/positive/groupby5.q
+++ /dev/null
@@ -1,4 +0,0 @@
-
-SELECT src.key, sum(substr(src.value,5))
-FROM src
-GROUP BY src.key
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/positive/groupby6.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/positive/groupby6.q b/sql/hive/src/test/resources/ql/src/test/queries/positive/groupby6.q
deleted file mode 100755
index 80654f2..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/positive/groupby6.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-SELECT DISTINCT substr(src.value,5,1)
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/positive/input1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/positive/input1.q b/sql/hive/src/test/resources/ql/src/test/queries/positive/input1.q
deleted file mode 100644
index fdd290d..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/positive/input1.q
+++ /dev/null
@@ -1,2 +0,0 @@
-FROM src
-INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 100
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/positive/input2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/positive/input2.q b/sql/hive/src/test/resources/ql/src/test/queries/positive/input2.q
deleted file mode 100644
index 4e1612e..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/positive/input2.q
+++ /dev/null
@@ -1,4 +0,0 @@
-FROM src
-INSERT OVERWRITE TABLE dest1 SELECT src.* WHERE src.key < 100
-INSERT OVERWRITE TABLE dest2 SELECT src.key, src.value WHERE src.key >= 100 and src.key < 200
-INSERT OVERWRITE TABLE dest3 PARTITION(ds='2008-04-08', hr='12') SELECT src.key, 2 WHERE src.key >= 200
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/positive/input20.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/positive/input20.q b/sql/hive/src/test/resources/ql/src/test/queries/positive/input20.q
deleted file mode 100644
index f30cf27..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/positive/input20.q
+++ /dev/null
@@ -1,9 +0,0 @@
-FROM (
- FROM src
- MAP src.key % 2, src.key % 5
- USING 'cat'
- CLUSTER BY key
-) tmap
-REDUCE tmap.key, tmap.value
-USING 'uniq -c | sed "s@^ *@@" | sed "s@\t@_@" | sed "s@ @\t@"'
-AS key, value
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@spark.apache.org
For additional commands, e-mail: commits-help@spark.apache.org