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:33 UTC
[7/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/archive_multi4.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_multi4.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_multi4.q
deleted file mode 100644
index abe0647..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_multi4.q
+++ /dev/null
@@ -1,13 +0,0 @@
-set hive.archive.enabled = true;
--- Tests trying to archive inner partition contained in archived partition group.
--- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19)
-
-CREATE TABLE tstsrcpart LIKE srcpart;
-
-INSERT OVERWRITE TABLE tstsrcpart PARTITION (ds='2008-04-08', hr='11')
-SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='11';
-INSERT OVERWRITE TABLE tstsrcpart PARTITION (ds='2008-04-08', hr='12')
-SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='12';
-
-ALTER TABLE tstsrcpart ARCHIVE PARTITION (ds='2008-04-08');
-ALTER TABLE tstsrcpart ARCHIVE 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/archive_multi5.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_multi5.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_multi5.q
deleted file mode 100644
index 71635e0..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_multi5.q
+++ /dev/null
@@ -1,13 +0,0 @@
-set hive.archive.enabled = true;
--- Tests trying to unarchive outer partition group containing other partition inside.
--- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19)
-
-CREATE TABLE tstsrcpart LIKE srcpart;
-
-INSERT OVERWRITE TABLE tstsrcpart PARTITION (ds='2008-04-08', hr='11')
-SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='11';
-INSERT OVERWRITE TABLE tstsrcpart PARTITION (ds='2008-04-08', hr='12')
-SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='12';
-
-ALTER TABLE tstsrcpart ARCHIVE PARTITION (ds='2008-04-08', hr='12');
-ALTER TABLE tstsrcpart UNARCHIVE PARTITION (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/archive_multi6.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_multi6.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_multi6.q
deleted file mode 100644
index 5bb1474..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_multi6.q
+++ /dev/null
@@ -1,13 +0,0 @@
-set hive.archive.enabled = true;
--- Tests trying to unarchive inner partition contained in archived partition group.
--- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19)
-
-CREATE TABLE tstsrcpart LIKE srcpart;
-
-INSERT OVERWRITE TABLE tstsrcpart PARTITION (ds='2008-04-08', hr='11')
-SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='11';
-INSERT OVERWRITE TABLE tstsrcpart PARTITION (ds='2008-04-08', hr='12')
-SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='12';
-
-ALTER TABLE tstsrcpart ARCHIVE PARTITION (ds='2008-04-08');
-ALTER TABLE tstsrcpart UNARCHIVE 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/archive_multi7.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_multi7.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_multi7.q
deleted file mode 100644
index db7f392..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_multi7.q
+++ /dev/null
@@ -1,12 +0,0 @@
-set hive.archive.enabled = true;
--- Tests trying to archive a partition group with custom locations.
--- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19)
-
-CREATE TABLE tstsrcpart LIKE srcpart;
-
-INSERT OVERWRITE TABLE tstsrcpart PARTITION (ds='2008-04-08', hr='11')
-SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='11';
-ALTER TABLE tstsrcpart ADD PARTITION (ds='2008-04-08', hr='12')
-LOCATION "${system:test.tmp.dir}/tstsrc";
-
-ALTER TABLE tstsrcpart ARCHIVE PARTITION (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/archive_partspec1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_partspec1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_partspec1.q
deleted file mode 100644
index d83b19d..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_partspec1.q
+++ /dev/null
@@ -1,10 +0,0 @@
-set hive.archive.enabled = true;
--- Tests trying to archive a partition twice.
--- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19)
-
-CREATE TABLE srcpart_archived LIKE srcpart;
-
-INSERT OVERWRITE TABLE srcpart_archived PARTITION (ds='2008-04-08', hr='12')
-SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='12';
-
-ALTER TABLE srcpart_archived ARCHIVE PARTITION (ds='2008-04-08', nonexistingpart='12');
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_partspec2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_partspec2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_partspec2.q
deleted file mode 100644
index ed14bbf..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_partspec2.q
+++ /dev/null
@@ -1,10 +0,0 @@
-set hive.archive.enabled = true;
--- Tests trying to archive a partition twice.
--- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19)
-
-CREATE TABLE srcpart_archived LIKE srcpart;
-
-INSERT OVERWRITE TABLE srcpart_archived PARTITION (ds='2008-04-08', hr='12')
-SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='12';
-
-ALTER TABLE srcpart_archived ARCHIVE PARTITION (hr='12');
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_partspec3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_partspec3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_partspec3.q
deleted file mode 100644
index f27ad6d..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_partspec3.q
+++ /dev/null
@@ -1,10 +0,0 @@
-set hive.archive.enabled = true;
--- Tests trying to archive a partition twice.
--- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19)
-
-CREATE TABLE srcpart_archived LIKE srcpart;
-
-INSERT OVERWRITE TABLE srcpart_archived PARTITION (ds='2008-04-08', hr='12')
-SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='12';
-
-ALTER TABLE srcpart_archived ARCHIVE PARTITION ();
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_partspec4.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_partspec4.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_partspec4.q
deleted file mode 100644
index 491c2ac..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_partspec4.q
+++ /dev/null
@@ -1,10 +0,0 @@
-set hive.archive.enabled = true;
--- Tests trying to archive a partition twice.
--- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19)
-
-CREATE TABLE srcpart_archived LIKE srcpart;
-
-INSERT OVERWRITE TABLE srcpart_archived PARTITION (ds='2008-04-08', hr='12')
-SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='12';
-
-ALTER TABLE srcpart_archived ARCHIVE PARTITION (hr='12', ds='2008-04-08');
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_partspec5.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_partspec5.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_partspec5.q
deleted file mode 100644
index bb25ef2..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_partspec5.q
+++ /dev/null
@@ -1,10 +0,0 @@
-set hive.archive.enabled = true;
--- Tests trying to archive a partition twice.
--- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19)
-
-CREATE TABLE srcpart_archived (key string, value string) partitioned by (ds string, hr int, min int);
-
-INSERT OVERWRITE TABLE srcpart_archived PARTITION (ds='2008-04-08', hr='12', min='00')
-SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='12';
-
-ALTER TABLE srcpart_archived ARCHIVE PARTITION (ds='2008-04-08', min='00');
\ 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/authorization_addjar.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_addjar.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_addjar.q
deleted file mode 100644
index a1709da..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_addjar.q
+++ /dev/null
@@ -1,7 +0,0 @@
-set hive.security.authorization.enabled=true;
-set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactory;
-
--- running a sql query to initialize the authorization - not needed in real HS2 mode
-show tables;
-
-add jar ${system:maven.local.repository}/org/apache/hive/hcatalog/hive-hcatalog-core/${system:hive.version}/hive-hcatalog-core-${system:hive.version}.jar;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_addpartition.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_addpartition.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_addpartition.q
deleted file mode 100644
index 8abdd2b..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_addpartition.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=user1;
--- check add partition without insert privilege
-create table tpart(i int, j int) partitioned by (k string);
-
-set user.name=user2;
-alter table tpart add partition (k = 'abc');
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_alter_db_owner.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_alter_db_owner.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_alter_db_owner.q
deleted file mode 100644
index f716262..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_alter_db_owner.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;
-set user.name=user1;
-
--- check if alter table owner fails
--- for now, alter db owner is allowed only for admin
-
-create database dbao;
-alter database dbao set owner user user2;
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_alter_db_owner_default.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_alter_db_owner_default.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_alter_db_owner_default.q
deleted file mode 100644
index f904935..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_alter_db_owner_default.q
+++ /dev/null
@@ -1,8 +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=user1;
-
--- check if alter table owner fails
-alter database default set owner user user1;
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_cannot_create_all_role.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_cannot_create_all_role.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_cannot_create_all_role.q
deleted file mode 100644
index de91e91..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_cannot_create_all_role.q
+++ /dev/null
@@ -1,6 +0,0 @@
-set hive.users.in.admin.role=hive_admin_user;
-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 user.name=hive_admin_user;
-set role ADMIN;
-create role all;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_cannot_create_default_role.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_cannot_create_default_role.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_cannot_create_default_role.q
deleted file mode 100644
index 42a42f6..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_cannot_create_default_role.q
+++ /dev/null
@@ -1,6 +0,0 @@
-set hive.users.in.admin.role=hive_admin_user;
-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 user.name=hive_admin_user;
-set role ADMIN;
-create role default;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_cannot_create_none_role.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_cannot_create_none_role.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_cannot_create_none_role.q
deleted file mode 100644
index 0d14cde..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_cannot_create_none_role.q
+++ /dev/null
@@ -1,6 +0,0 @@
-set hive.users.in.admin.role=hive_admin_user;
-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 user.name=hive_admin_user;
-set role ADMIN;
-create role None;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_caseinsensitivity.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_caseinsensitivity.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_caseinsensitivity.q
deleted file mode 100644
index d5ea284..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_caseinsensitivity.q
+++ /dev/null
@@ -1,17 +0,0 @@
-set hive.users.in.admin.role=hive_admin_user;
-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 user.name=hive_admin_user;
-set role ADMIN;
-
-create role testrole;
-show roles;
-drop role TESTROLE;
-show roles;
-create role TESTROLE;
-show roles;
-grant role testROLE to user hive_admin_user;
-set role testrolE;
-set role adMin;
-show roles;
-create role TESTRoLE;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_create_func1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_create_func1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_create_func1.q
deleted file mode 100644
index 02bbe09..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_create_func1.q
+++ /dev/null
@@ -1,7 +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=hive_test_user;
-
--- permanent function creation should fail for non-admin roles
-create function perm_fn as 'org.apache.hadoop.hive.ql.udf.UDFAscii';
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_create_func2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_create_func2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_create_func2.q
deleted file mode 100644
index 8760fa8..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_create_func2.q
+++ /dev/null
@@ -1,8 +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=hive_test_user;
-
--- temp function creation should fail for non-admin roles
-create temporary function temp_fn as 'org.apache.hadoop.hive.ql.udf.UDFAscii';
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_create_macro1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_create_macro1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_create_macro1.q
deleted file mode 100644
index c904a10..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_create_macro1.q
+++ /dev/null
@@ -1,8 +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=hive_test_user;
-
--- temp macro creation should fail for non-admin roles
-create temporary macro mymacro1(x double) x * x;
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_create_role_no_admin.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_create_role_no_admin.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_create_role_no_admin.q
deleted file mode 100644
index a84fe64..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_create_role_no_admin.q
+++ /dev/null
@@ -1,3 +0,0 @@
-set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest;
--- this test will fail because hive_test_user is not in admin role.
-create role r1;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_createview.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_createview.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_createview.q
deleted file mode 100644
index 9b1f2ea..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_createview.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;
-
--- check create view without select privileges
-create table t1(i int);
-set user.name=user1;
-create view v1 as select * from t1;
-
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_ctas.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_ctas.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_ctas.q
deleted file mode 100644
index 1cf74a3..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_ctas.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;
-
--- check query without select privilege fails
-create table t1(i int);
-
-set user.name=user1;
-create table t2 as select * from t1;
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_desc_table_nosel.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_desc_table_nosel.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_desc_table_nosel.q
deleted file mode 100644
index 47663c9..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_desc_table_nosel.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;
-set user.name=user1;
-
--- check if alter table fails as different user
-create table t1(i int);
-desc t1;
-
-grant all on table t1 to user user2;
-revoke select on table t1 from user user2;
-
-set user.name=user2;
-desc t1;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_dfs.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_dfs.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_dfs.q
deleted file mode 100644
index 7d47a7b..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_dfs.q
+++ /dev/null
@@ -1,7 +0,0 @@
-set hive.security.authorization.enabled=true;
-set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactory;
-
--- running a sql query to initialize the authorization - not needed in real HS2 mode
-show tables;
-dfs -ls ${system:test.tmp.dir}/
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_disallow_transform.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_disallow_transform.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_disallow_transform.q
deleted file mode 100644
index 64b300c..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_disallow_transform.q
+++ /dev/null
@@ -1,3 +0,0 @@
-set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest;
-set role ALL;
-SELECT TRANSFORM (*) USING 'cat' AS (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/authorization_drop_db_cascade.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_drop_db_cascade.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_drop_db_cascade.q
deleted file mode 100644
index edeae9b..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_drop_db_cascade.q
+++ /dev/null
@@ -1,22 +0,0 @@
-set hive.users.in.admin.role=hive_admin_user;
-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=user1;
-
--- ensure that drop database cascade works
-create database dba1;
-create table dba1.tab1(i int);
-drop database dba1 cascade;
-
--- check if drop database fails if the db has a table for which user does not have permission
-create database dba2;
-create table dba2.tab2(i int);
-
-set user.name=hive_admin_user;
-set role ADMIN;
-alter database dba2 set owner user user2;
-
-set user.name=user2;
-show current roles;
-drop database dba2 cascade ;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_drop_db_empty.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_drop_db_empty.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_drop_db_empty.q
deleted file mode 100644
index 46d4d0f..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_drop_db_empty.q
+++ /dev/null
@@ -1,27 +0,0 @@
-set hive.users.in.admin.role=hive_admin_user;
-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=user1;
-
--- check if changing owner and dropping as other user works
-create database dba1;
-
-set user.name=hive_admin_user;
-set role ADMIN;
-alter database dba1 set owner user user2;
-
-set user.name=user2;
-show current roles;
-drop database dba1;
-
-
-set user.name=user1;
--- check if dropping db as another user fails
-show current roles;
-create database dba2;
-
-set user.name=user2;
-show current roles;
-
-drop database dba2;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_drop_role_no_admin.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_drop_role_no_admin.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_drop_role_no_admin.q
deleted file mode 100644
index a7aa17f..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_drop_role_no_admin.q
+++ /dev/null
@@ -1,10 +0,0 @@
-set hive.users.in.admin.role=hive_admin_user;
-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 user.name=hive_admin_user;
-set role ADMIN;
-show current roles;
-create role r1;
-set role ALL;
-show current roles;
-drop role r1;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_droppartition.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_droppartition.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_droppartition.q
deleted file mode 100644
index f05e945..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_droppartition.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_drop_part_1;
-
--- check drop partition without delete privilege
-create table tpart(i int, j int) partitioned by (k string);
-alter table tpart add partition (k = 'abc') location 'file:${system:test.tmp.dir}/authz_drop_part_1' ;
-set user.name=user1;
-alter table tpart drop partition (k = 'abc');
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_1.q
deleted file mode 100644
index c38dab5..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_1.q
+++ /dev/null
@@ -1,7 +0,0 @@
-create table authorization_fail_1 (key int, value string);
-set hive.security.authorization.enabled=true;
-
-grant Create on table authorization_fail_1 to user hive_test_user;
-grant Create on table authorization_fail_1 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/authorization_fail_2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_2.q
deleted file mode 100644
index 341e447..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_2.q
+++ /dev/null
@@ -1,7 +0,0 @@
-create table authorization_fail_2 (key int, value string) partitioned by (ds string);
-
-set hive.security.authorization.enabled=true;
-
-alter table authorization_fail_2 add partition (ds='2010');
-
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_3.q
deleted file mode 100644
index 6a56daa..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_3.q
+++ /dev/null
@@ -1,12 +0,0 @@
--- SORT_BEFORE_DIFF
-
-create table authorization_fail_3 (key int, value string) partitioned by (ds string);
-set hive.security.authorization.enabled=true;
-
-grant Create on table authorization_fail_3 to user hive_test_user;
-alter table authorization_fail_3 add partition (ds='2010');
-
-show grant user hive_test_user on table authorization_fail_3;
-show grant user hive_test_user on table authorization_fail_3 partition (ds='2010');
-
-select key from authorization_fail_3 where ds='2010';
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_4.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_4.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_4.q
deleted file mode 100644
index f0cb645..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_4.q
+++ /dev/null
@@ -1,15 +0,0 @@
--- SORT_BEFORE_DIFF
-
-create table authorization_fail_4 (key int, value string) partitioned by (ds string);
-
-set hive.security.authorization.enabled=true;
-grant Alter on table authorization_fail_4 to user hive_test_user;
-ALTER TABLE authorization_fail_4 SET TBLPROPERTIES ("PARTITION_LEVEL_PRIVILEGE"="TRUE");
-
-grant Create on table authorization_fail_4 to user hive_test_user;
-alter table authorization_fail_4 add partition (ds='2010');
-
-show grant user hive_test_user on table authorization_fail_4;
-show grant user hive_test_user on table authorization_fail_4 partition (ds='2010');
-
-select key from authorization_fail_4 where ds='2010';
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_5.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_5.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_5.q
deleted file mode 100644
index b4efab5..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_5.q
+++ /dev/null
@@ -1,20 +0,0 @@
--- SORT_BEFORE_DIFF
-
-create table authorization_fail (key int, value string) partitioned by (ds string);
-set hive.security.authorization.enabled=true;
-
-grant Alter on table authorization_fail to user hive_test_user;
-ALTER TABLE authorization_fail SET TBLPROPERTIES ("PARTITION_LEVEL_PRIVILEGE"="TRUE");
-
-grant Create on table authorization_fail to user hive_test_user;
-grant Select on table authorization_fail to user hive_test_user;
-alter table authorization_fail add partition (ds='2010');
-
-show grant user hive_test_user on table authorization_fail;
-show grant user hive_test_user on table authorization_fail partition (ds='2010');
-
-revoke Select on table authorization_fail partition (ds='2010') from user hive_test_user;
-
-show grant user hive_test_user on table authorization_fail partition (ds='2010');
-
-select key from authorization_fail where ds='2010';
\ 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/authorization_fail_6.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_6.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_6.q
deleted file mode 100644
index 9772469..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_6.q
+++ /dev/null
@@ -1,6 +0,0 @@
--- SORT_BEFORE_DIFF
-
-create table authorization_part_fail (key int, value string) partitioned by (ds string);
-set hive.security.authorization.enabled=true;
-
-ALTER TABLE authorization_part_fail SET TBLPROPERTIES ("PARTITION_LEVEL_PRIVILEGE"="TRUE");
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_7.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_7.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_7.q
deleted file mode 100644
index 492deed..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_7.q
+++ /dev/null
@@ -1,17 +0,0 @@
--- SORT_BEFORE_DIFF
-
-create table authorization_fail (key int, value string);
-
-set hive.security.authorization.enabled=true;
-
-create role hive_test_role_fail;
-
-grant role hive_test_role_fail to user hive_test_user;
-grant select on table authorization_fail to role hive_test_role_fail;
-show role grant user hive_test_user;
-
-show grant role hive_test_role_fail on table authorization_fail;
-
-drop role hive_test_role_fail;
-
-select key from authorization_fail;
\ 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/authorization_fail_create_db.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_create_db.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_create_db.q
deleted file mode 100644
index d969e39..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_create_db.q
+++ /dev/null
@@ -1,5 +0,0 @@
-set hive.security.authorization.enabled=true;
-
-create database db_to_fail;
-
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_drop_db.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_drop_db.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_drop_db.q
deleted file mode 100644
index 87719b0..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_fail_drop_db.q
+++ /dev/null
@@ -1,5 +0,0 @@
-set hive.security.authorization.enabled=false;
-create database db_fail_to_drop;
-set hive.security.authorization.enabled=true;
-
-drop database db_fail_to_drop;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_grant_table_allpriv.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_grant_table_allpriv.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_grant_table_allpriv.q
deleted file mode 100644
index f3c86b9..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_grant_table_allpriv.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 user.name=user1;
--- current user has been set (comment line before the set cmd is resulting in parse error!!)
-
-CREATE TABLE table_priv_allf(i int);
-
--- grant insert to user2 WITH grant option
-GRANT INSERT ON table_priv_allf TO USER user2 with grant option;
-
-set user.name=user2;
--- try grant all to user3, without having all privileges
-GRANT ALL ON table_priv_allf TO USER user3;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_grant_table_dup.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_grant_table_dup.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_grant_table_dup.q
deleted file mode 100644
index 7808cb3..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_grant_table_dup.q
+++ /dev/null
@@ -1,16 +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 user.name=user1;
--- current user has been set (comment line before the set cmd is resulting in parse error!!)
-
-CREATE TABLE tauth_gdup(i int);
-
--- It should be possible to revert owners privileges
-revoke SELECT ON tauth_gdup from user user1;
-
-show grant user user1 on table tauth_gdup;
-
--- Owner already has all privileges granted, another grant would become duplicate
--- and result in error
-GRANT INSERT ON tauth_gdup TO USER user1;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_grant_table_fail1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_grant_table_fail1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_grant_table_fail1.q
deleted file mode 100644
index 8dc8e45..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_grant_table_fail1.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 user.name=user1;
--- current user has been set (comment line before the set cmd is resulting in parse error!!)
-
-CREATE TABLE table_priv_gfail1(i int);
-
-set user.name=user2;
--- try grant insert to user3 as user2
-GRANT INSERT ON table_priv_gfail1 TO USER user3;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_grant_table_fail_nogrant.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_grant_table_fail_nogrant.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_grant_table_fail_nogrant.q
deleted file mode 100644
index d51c1c3..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_grant_table_fail_nogrant.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 user.name=user1;
--- current user has been set (comment line before the set cmd is resulting in parse error!!)
-
-CREATE TABLE table_priv_gfail1(i int);
-
--- grant insert to user2 WITHOUT grant option
-GRANT INSERT ON table_priv_gfail1 TO USER user2;
-
-set user.name=user2;
--- try grant insert to user3
-GRANT INSERT ON table_priv_gfail1 TO USER user3;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_insert_noinspriv.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_insert_noinspriv.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_insert_noinspriv.q
deleted file mode 100644
index 2fa3cb2..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_insert_noinspriv.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;
-
--- check insert without select priv
-create table t1(i int);
-
-set user.name=user1;
-create table user2tab(i int);
-insert into table t1 select * from user2tab;
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_insert_noselectpriv.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_insert_noselectpriv.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_insert_noselectpriv.q
deleted file mode 100644
index b9bee4e..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_insert_noselectpriv.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;
-
--- check insert without select priv
-create table t1(i int);
-
-set user.name=user1;
-create table t2(i int);
-insert into table t2 select * from t1;
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_invalid_priv_v1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_invalid_priv_v1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_invalid_priv_v1.q
deleted file mode 100644
index 2a1da23..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_invalid_priv_v1.q
+++ /dev/null
@@ -1,6 +0,0 @@
-create table if not exists authorization_invalid_v1 (key int, value string);
-grant delete on table authorization_invalid_v1 to user hive_test_user;
-drop table authorization_invalid_v1;
-
-
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_invalid_priv_v2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_invalid_priv_v2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_invalid_priv_v2.q
deleted file mode 100644
index 9c72408..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_invalid_priv_v2.q
+++ /dev/null
@@ -1,5 +0,0 @@
-set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest;
-
-create table if not exists authorization_invalid_v2 (key int, value string);
-grant index on table authorization_invalid_v2 to user hive_test_user;
-drop table authorization_invalid_v2;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_not_owner_alter_tab_rename.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_not_owner_alter_tab_rename.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_not_owner_alter_tab_rename.q
deleted file mode 100644
index 8a3300c..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_not_owner_alter_tab_rename.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=user1;
-
--- check if alter table fails as different user
-create table t1(i int);
-
-set user.name=user2;
-alter table t1 rename to tnew1;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_not_owner_alter_tab_serdeprop.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_not_owner_alter_tab_serdeprop.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_not_owner_alter_tab_serdeprop.q
deleted file mode 100644
index 0172c4c..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_not_owner_alter_tab_serdeprop.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=user1;
-
--- check if alter table fails as different user
-create table t1(i int);
-
-set user.name=user2;
-ALTER TABLE t1 SET SERDEPROPERTIES ('field.delim' = ',');
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_not_owner_drop_tab.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_not_owner_drop_tab.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_not_owner_drop_tab.q
deleted file mode 100644
index 2d0e52d..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_not_owner_drop_tab.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;
-set user.name=user1;
-
--- check if create table fails as different user
-create table t1(i int);
-
-set user.name=user2;
-drop table t1;
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_not_owner_drop_view.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_not_owner_drop_view.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_not_owner_drop_view.q
deleted file mode 100644
index 76bbab4..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_not_owner_drop_view.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;
-set user.name=user1;
-
--- check if create table fails as different user
-create table t1(i int);
-create view vt1 as select * from t1;
-
-set user.name=user2;
-drop view vt1;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_part.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_part.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_part.q
deleted file mode 100644
index a654a23..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_part.q
+++ /dev/null
@@ -1,37 +0,0 @@
--- SORT_BEFORE_DIFF
-
-create table authorization_part_fail (key int, value string) partitioned by (ds string);
-ALTER TABLE authorization_part_fail SET TBLPROPERTIES ("PARTITION_LEVEL_PRIVILEGE"="TRUE");
-create table src_auth as select * from src;
-set hive.security.authorization.enabled=true;
-
-grant Create on table authorization_part_fail to user hive_test_user;
-grant Update on table authorization_part_fail to user hive_test_user;
-grant Drop on table authorization_part_fail to user hive_test_user;
-grant select on table src_auth to user hive_test_user;
-
--- column grant to group
-
-grant select(key) on table authorization_part_fail to group hive_test_group1;
-grant select on table authorization_part_fail to group hive_test_group1;
-
-show grant group hive_test_group1 on table authorization_part_fail;
-
-insert overwrite table authorization_part_fail partition (ds='2010') select key, value from src_auth;
-show grant group hive_test_group1 on table authorization_part_fail(key) partition (ds='2010');
-show grant group hive_test_group1 on table authorization_part_fail partition (ds='2010');
-select key, value from authorization_part_fail where ds='2010' order by key limit 20;
-
-insert overwrite table authorization_part_fail partition (ds='2011') select key, value from src_auth;
-show grant group hive_test_group1 on table authorization_part_fail(key) partition (ds='2011');
-show grant group hive_test_group1 on table authorization_part_fail partition (ds='2011');
-select key, value from authorization_part_fail where ds='2011' order by key limit 20;
-
-select key,value, ds from authorization_part_fail where ds>='2010' order by key, ds limit 20;
-
-revoke select on table authorization_part_fail partition (ds='2010') from group hive_test_group1;
-
-select key,value, ds from authorization_part_fail where ds>='2010' order by key, ds limit 20;
-
-drop table authorization_part_fail;
-drop table src_auth;
\ 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/authorization_priv_current_role_neg.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_priv_current_role_neg.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_priv_current_role_neg.q
deleted file mode 100644
index bbf3b66..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_priv_current_role_neg.q
+++ /dev/null
@@ -1,29 +0,0 @@
-set hive.users.in.admin.role=hive_admin_user;
-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 user.name=hive_admin_user;
-set role ADMIN;
-
--- the test verifies that authorization is happening with privileges of the current roles
-
--- grant privileges with grant option for table to role2
-create role role2;
-grant role role2 to user user2;
-create table tpriv_current_role(i int);
-grant all on table tpriv_current_role to role role2 with grant option;
-
-set user.name=user2;
--- switch to user2
-
--- by default all roles should be in current roles, and grant to new user should work
-show current roles;
-grant all on table tpriv_current_role to user user3;
-
-set role role2;
--- switch to role2, grant should work
-grant all on table tpriv_current_role to user user4;
-show grant user user4 on table tpriv_current_role;
-
-set role PUBLIC;
--- set role to public, should fail as role2 is not one of the current roles
-grant all on table tpriv_current_role to user user5;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_public_create.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_public_create.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_public_create.q
deleted file mode 100644
index 002389f..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_public_create.q
+++ /dev/null
@@ -1 +0,0 @@
-create role PUBLIC;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_public_drop.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_public_drop.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_public_drop.q
deleted file mode 100644
index 69c5a8d..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_public_drop.q
+++ /dev/null
@@ -1 +0,0 @@
-drop role PUBLIC;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_revoke_table_fail1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_revoke_table_fail1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_revoke_table_fail1.q
deleted file mode 100644
index e19bf37..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_revoke_table_fail1.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 user.name=user1;
--- current user has been set (comment line before the set cmd is resulting in parse error!!)
-
-CREATE TABLE table_priv_rfail1(i int);
-
--- grant insert to user2
-GRANT INSERT ON table_priv_rfail1 TO USER user2;
-
-set user.name=user3;
--- try dropping the privilege as user3
-REVOKE INSERT ON TABLE table_priv_rfail1 FROM USER user2;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_revoke_table_fail2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_revoke_table_fail2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_revoke_table_fail2.q
deleted file mode 100644
index 4b0cf32..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_revoke_table_fail2.q
+++ /dev/null
@@ -1,18 +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 user.name=user1;
--- current user has been set (comment line before the set cmd is resulting in parse error!!)
-
-CREATE TABLE table_priv_rfai2(i int);
-
--- grant insert to user2
-GRANT INSERT ON table_priv_rfai2 TO USER user2;
-GRANT SELECT ON table_priv_rfai2 TO USER user3 WITH GRANT OPTION;
-
-set user.name=user3;
--- grant select as user3 to user 2
-GRANT SELECT ON table_priv_rfai2 TO USER user2;
-
--- try dropping the privilege as user3
-REVOKE INSERT ON TABLE table_priv_rfai2 FROM USER user2;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_role_cycles1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_role_cycles1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_role_cycles1.q
deleted file mode 100644
index a819d20..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_role_cycles1.q
+++ /dev/null
@@ -1,12 +0,0 @@
-set hive.users.in.admin.role=hive_admin_user;
-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 user.name=hive_admin_user;
-set role ADMIN;
--- this is applicable to any security mode as check is in metastore
-create role role1;
-create role role2;
-grant role role1 to role role2;
-
--- this will create a cycle
-grant role role2 to role role1;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_role_cycles2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_role_cycles2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_role_cycles2.q
deleted file mode 100644
index 423f030..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_role_cycles2.q
+++ /dev/null
@@ -1,24 +0,0 @@
-set hive.users.in.admin.role=hive_admin_user;
-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 user.name=hive_admin_user;
-set role ADMIN;
--- this is applicable to any security mode as check is in metastore
-
-create role role1;
-
-create role role2;
-grant role role2 to role role1;
-
-create role role3;
-grant role role3 to role role2;
-
-create role role4;
-grant role role4 to role role3;
-
-create role role5;
-grant role role5 to role role4;
-
--- this will create a cycle in middle of the hierarchy
-grant role role2 to role role4;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_role_grant.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_role_grant.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_role_grant.q
deleted file mode 100644
index c5c500a..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_role_grant.q
+++ /dev/null
@@ -1,22 +0,0 @@
-set hive.users.in.admin.role=hive_admin_user;
-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 user.name=hive_admin_user;
-
-set role ADMIN;
-
-----------------------------------------
--- role granting with admin option
--- since user2 doesn't have admin option for role_noadmin, last grant should fail
-----------------------------------------
-
-create role role_noadmin;
-create role src_role_wadmin;
-grant src_role_wadmin to user user2 with admin option;
-grant role_noadmin to user user2;
-show role grant user user2;
-
-
-set user.name=user2;
-set role role_noadmin;
-grant src_role_wadmin to user user3;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_rolehierarchy_privs.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_rolehierarchy_privs.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_rolehierarchy_privs.q
deleted file mode 100644
index d9f4c7c..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_rolehierarchy_privs.q
+++ /dev/null
@@ -1,74 +0,0 @@
-set hive.users.in.admin.role=hive_admin_user;
-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=hive_admin_user;
-show current roles;
-set role ADMIN;
-
-----------
--- create the following user, role mapping
--- user1 -> role1 -> role2 -> role3
-----------
-
-create role role1;
-grant role1 to user user1;
-
-create role role2;
-grant role2 to role role1;
-
-create role role3;
-grant role3 to role role2;
-
-
-create table t1(i int);
-grant select on t1 to role role3;
-
-set user.name=user1;
-show current roles;
-select * from t1;
-
-set user.name=hive_admin_user;
-show current roles;
-grant select on t1 to role role2;
-
-
-set user.name=user1;
-show current roles;
-select * from t1;
-
-set user.name=hive_admin_user;
-set role ADMIN;
-show current roles;
-revoke select on table t1 from role role2;
-
-
-create role role4;
-grant role4 to user user1;
-grant role3 to role role4;;
-
-set user.name=user1;
-show current roles;
-select * from t1;
-
-set user.name=hive_admin_user;
-show current roles;
-set role ADMIN;
-
--- Revoke role3 from hierarchy one at a time and check permissions
--- after revoking from both, select should fail
-revoke role3 from role role2;
-
-set user.name=user1;
-show current roles;
-select * from t1;
-
-set user.name=hive_admin_user;
-show current roles;
-set role ADMIN;
-revoke role3 from role role4;
-
-set user.name=user1;
-show current roles;
-select * from t1;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_select.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_select.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_select.q
deleted file mode 100644
index 3987179..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_select.q
+++ /dev/null
@@ -1,9 +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;
-
--- check query without select privilege fails
-create table t1(i int);
-
-set user.name=user1;
-select * from t1;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_select_view.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_select_view.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_select_view.q
deleted file mode 100644
index a4071cd..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_select_view.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;
-
--- check create view without select privileges
-create table t1(i int);
-create view v1 as select * from t1;
-set user.name=user1;
-select * from v1;
-
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_set_role_neg1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_set_role_neg1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_set_role_neg1.q
deleted file mode 100644
index 9ba3a82..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_set_role_neg1.q
+++ /dev/null
@@ -1,6 +0,0 @@
-set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest;
-
--- an error should be thrown if 'set role ' is done for role that does not exist
-
-set role nosuchroleexists;
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_set_role_neg2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_set_role_neg2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_set_role_neg2.q
deleted file mode 100644
index 03f748f..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_set_role_neg2.q
+++ /dev/null
@@ -1,16 +0,0 @@
-set hive.users.in.admin.role=hive_admin_user;
-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 user.name=hive_admin_user;
-set role ADMIN;
-
--- an error should be thrown if 'set role ' is done for role that does not exist
-
-create role rset_role_neg;
-grant role rset_role_neg to user user2;
-
-set user.name=user2;
-set role rset_role_neg;
-set role public;
-set role nosuchroleexists;;
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_show_parts_nosel.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_show_parts_nosel.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_show_parts_nosel.q
deleted file mode 100644
index d8190de..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_show_parts_nosel.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=user1;
-
--- check if alter table fails as different user
-create table t_show_parts(i int) partitioned by (j string);
-
-set user.name=user2;
-show partitions t_show_parts;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_show_role_principals_no_admin.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_show_role_principals_no_admin.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_show_role_principals_no_admin.q
deleted file mode 100644
index 2afe87f..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_show_role_principals_no_admin.q
+++ /dev/null
@@ -1,3 +0,0 @@
-set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest;
--- This test will fail because hive_test_user is not in admin role
-show principals role1;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_show_role_principals_v1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_show_role_principals_v1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_show_role_principals_v1.q
deleted file mode 100644
index 69cea2f..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_show_role_principals_v1.q
+++ /dev/null
@@ -1,2 +0,0 @@
--- This test will fail because the command is not currently supported in auth mode v1
-show principals role1;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_show_roles_no_admin.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_show_roles_no_admin.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_show_roles_no_admin.q
deleted file mode 100644
index 0fc9fca..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_show_roles_no_admin.q
+++ /dev/null
@@ -1,3 +0,0 @@
-set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest;
--- This test will fail because hive_test_user is not in admin role
-show roles;
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_truncate.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_truncate.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_truncate.q
deleted file mode 100644
index 285600b..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_truncate.q
+++ /dev/null
@@ -1,9 +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;
-
--- check add partition without insert privilege
-create table t1(i int, j int);
-set user.name=user1;
-truncate table t1;
-
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_add_partition.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_add_partition.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_add_partition.q
deleted file mode 100644
index d82ac71..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_add_partition.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;
-
-dfs ${system:test.dfs.mkdir} ${system:test.tmp.dir}/a_uri_add_part;
-dfs -touchz ${system:test.tmp.dir}/a_uri_add_part/1.txt;
-dfs -chmod 555 ${system:test.tmp.dir}/a_uri_add_part/1.txt;
-
-create table tpart(i int, j int) partitioned by (k string);
-alter table tpart add partition (k = 'abc') location '${system:test.tmp.dir}/a_uri_add_part/';
http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_alterpart_loc.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_alterpart_loc.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_alterpart_loc.q
deleted file mode 100644
index d38ba74..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_alterpart_loc.q
+++ /dev/null
@@ -1,16 +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_alterpart_loc_perm;
-dfs ${system:test.dfs.mkdir} ${system:test.tmp.dir}/az_uri_alterpart_loc;
-dfs -touchz ${system:test.tmp.dir}/az_uri_alterpart_loc/1.txt;
-dfs -chmod 555 ${system:test.tmp.dir}/az_uri_alterpart_loc/1.txt;
-
-create table tpart(i int, j int) partitioned by (k string);
-alter table tpart add partition (k = 'abc') location '${system:test.tmp.dir}/az_uri_alterpart_loc_perm/';
-
-alter table tpart partition (k = 'abc') set location '${system:test.tmp.dir}/az_uri_alterpart_loc/';
-
-
--- Attempt to set partition to location 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_altertab_setloc.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_altertab_setloc.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_altertab_setloc.q
deleted file mode 100644
index c446b86..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_altertab_setloc.q
+++ /dev/null
@@ -1,13 +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_altertab_setloc;
-dfs -touchz ${system:test.tmp.dir}/az_uri_altertab_setloc/1.txt;
-dfs -chmod 555 ${system:test.tmp.dir}/az_uri_altertab_setloc/1.txt;
-
-create table t1(i int);
-
-alter table t1 set location '${system:test.tmp.dir}/az_uri_altertab_setloc/1.txt'
-
--- Attempt to set location of table to a location 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_create_table1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_create_table1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_create_table1.q
deleted file mode 100644
index c8e1fb4..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_create_table1.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}/a_uri_crtab1;
-dfs -touchz ${system:test.tmp.dir}/a_uri_crtab1/1.txt;
-dfs -chmod 555 ${system:test.tmp.dir}/a_uri_crtab1/1.txt;
-
-create table t1(i int) location '${system:test.tmp.dir}/a_uri_crtab_ext';
-
--- Attempt to create table with dir that does not have write permission 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_create_table_ext.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_create_table_ext.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_create_table_ext.q
deleted file mode 100644
index c8549b4..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_create_table_ext.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}/a_uri_crtab_ext;
-dfs -touchz ${system:test.tmp.dir}/a_uri_crtab_ext/1.txt;
-dfs -chmod 555 ${system:test.tmp.dir}/a_uri_crtab_ext/1.txt;
-
-create external table t1(i int) location '${system:test.tmp.dir}/a_uri_crtab_ext';
-
--- Attempt to create table with dir that does not have write permission 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_createdb.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_createdb.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_createdb.q
deleted file mode 100644
index edfdf5a..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_createdb.q
+++ /dev/null
@@ -1,12 +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_createdb;
-dfs -touchz ${system:test.tmp.dir}/az_uri_createdb/1.txt;
-dfs -chmod 300 ${system:test.tmp.dir}/az_uri_createdb/1.txt;
-
-create database az_test_db location '${system:test.tmp.dir}/az_uri_createdb/';
-
--- Attempt to create db for dir without sufficient 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_export.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_export.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_export.q
deleted file mode 100644
index 8176391..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_export.q
+++ /dev/null
@@ -1,22 +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 hive.test.mode=true;
-set hive.test.mode.prefix=;
-set hive.test.mode.nosamplelist=export_auth_uri;
-
-
-create table export_auth_uri ( dep_id int comment "department id")
- stored as textfile;
-
-dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/exports/export_auth_uri/temp;
-dfs -rmr target/tmp/ql/test/data/exports/export_auth_uri;
-
-
-dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/exports/export_auth_uri/;
-dfs -chmod 555 target/tmp/ql/test/data/exports/export_auth_uri;
-
-export table export_auth_uri to 'ql/test/data/exports/export_auth_uri';
-
--- Attempt to export to location without sufficient 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_import.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_import.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_import.q
deleted file mode 100644
index 4ea4dc0..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_import.q
+++ /dev/null
@@ -1,25 +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 hive.test.mode=true;
-set hive.test.mode.prefix=;
-set hive.test.mode.nosamplelist=import_auth_uri;
-
-
-create table import_auth_uri ( dep_id int comment "department id")
- stored as textfile;
-dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/exports/import_auth_uri/temp;
-dfs -rmr target/tmp/ql/test/data/exports/import_auth_uri;
-export table import_auth_uri to 'ql/test/data/exports/import_auth_uri';
-drop table import_auth_uri;
-
-dfs -touchz target/tmp/ql/test/data/exports/import_auth_uri/1.txt;
-dfs -chmod 555 target/tmp/ql/test/data/exports/import_auth_uri/1.txt;
-
-create database importer;
-use importer;
-
-import from 'ql/test/data/exports/import_auth_uri';
-
--- Attempt to import from location without sufficient 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_index.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_index.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_index.q
deleted file mode 100644
index 1a8f9cb..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/authorization_uri_index.q
+++ /dev/null
@@ -1,13 +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_index;
-dfs -touchz ${system:test.tmp.dir}/az_uri_index/1.txt;
-dfs -chmod 555 ${system:test.tmp.dir}/az_uri_index/1.txt;
-
-
-create table t1(i int);
-create index idt1 on table t1 (i) as 'COMPACT' WITH DEFERRED REBUILD LOCATION '${system:test.tmp.dir}/az_uri_index/';
-
--- Attempt to use location for index that does not have permissions should fail
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@spark.apache.org
For additional commands, e-mail: commits-help@spark.apache.org