You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by cw...@apache.org on 2011/02/17 08:44:50 UTC
svn commit: r1071529 - in /hive/trunk/ql/src:
java/org/apache/hadoop/hive/ql/exec/ java/org/apache/hadoop/hive/ql/parse/
java/org/apache/hadoop/hive/ql/security/authorization/
test/queries/clientnegative/ test/queries/clientpositive/
test/results/clien...
Author: cws
Date: Thu Feb 17 07:44:49 2011
New Revision: 1071529
URL: http://svn.apache.org/viewvc?rev=1071529&view=rev
Log:
HIVE-1928 GRANT/REVOKE should handle privileges as tokens, not identifiers (Jonathan Natkins via cws)
Modified:
hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java
hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java
hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g
hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/security/authorization/DefaultHiveAuthorizationProvider.java
hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/security/authorization/Privilege.java
hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/security/authorization/PrivilegeRegistry.java
hive/trunk/ql/src/test/queries/clientnegative/authorization_fail_1.q
hive/trunk/ql/src/test/queries/clientnegative/authorization_fail_3.q
hive/trunk/ql/src/test/queries/clientnegative/authorization_fail_4.q
hive/trunk/ql/src/test/queries/clientnegative/authorization_fail_5.q
hive/trunk/ql/src/test/queries/clientnegative/authorization_fail_7.q
hive/trunk/ql/src/test/queries/clientnegative/authorization_part.q
hive/trunk/ql/src/test/queries/clientpositive/authorization_1.q
hive/trunk/ql/src/test/queries/clientpositive/authorization_2.q
hive/trunk/ql/src/test/queries/clientpositive/authorization_3.q
hive/trunk/ql/src/test/queries/clientpositive/authorization_4.q
hive/trunk/ql/src/test/queries/clientpositive/authorization_5.q
hive/trunk/ql/src/test/queries/clientpositive/keyword_1.q
hive/trunk/ql/src/test/results/clientnegative/authorization_fail_1.q.out
hive/trunk/ql/src/test/results/clientnegative/authorization_fail_3.q.out
hive/trunk/ql/src/test/results/clientnegative/authorization_fail_4.q.out
hive/trunk/ql/src/test/results/clientnegative/authorization_fail_5.q.out
hive/trunk/ql/src/test/results/clientnegative/authorization_fail_7.q.out
hive/trunk/ql/src/test/results/clientnegative/authorization_part.q.out
hive/trunk/ql/src/test/results/clientpositive/authorization_1.q.out
hive/trunk/ql/src/test/results/clientpositive/authorization_2.q.out
hive/trunk/ql/src/test/results/clientpositive/authorization_3.q.out
hive/trunk/ql/src/test/results/clientpositive/authorization_4.q.out
hive/trunk/ql/src/test/results/clientpositive/authorization_5.q.out
hive/trunk/ql/src/test/results/clientpositive/keyword_1.q.out
Modified: hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java (original)
+++ hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java Thu Feb 17 07:44:49 2011
@@ -611,7 +611,7 @@ public class DDLTask extends Task<DDLWor
privBag.addToPrivileges(new HiveObjectPrivilege(new HiveObjectRef(
HiveObjectType.GLOBAL, null, null, null, null), null, null,
- new PrivilegeGrantInfo(priv.getPriv(), 0, grantor, grantorType,
+ new PrivilegeGrantInfo(priv.toString(), 0, grantor, grantorType,
grantOption)));
}
} else {
@@ -637,7 +637,7 @@ public class DDLTask extends Task<DDLWor
Privilege priv = privDesc.getPrivilege();
if (columns != null && columns.size() > 0) {
if (!priv.supportColumnLevel()) {
- throw new HiveException(priv.getPriv()
+ throw new HiveException(priv.toString()
+ " does not support column level.");
}
if (privSubjectDesc == null || tableName == null) {
@@ -648,24 +648,24 @@ public class DDLTask extends Task<DDLWor
for (int i = 0; i < columns.size(); i++) {
privBag.addToPrivileges(new HiveObjectPrivilege(
new HiveObjectRef(HiveObjectType.COLUMN, dbName, tableName,
- partValues, columns.get(i)), null, null, new PrivilegeGrantInfo(priv.getPriv(), 0, grantor, grantorType, grantOption)));
+ partValues, columns.get(i)), null, null, new PrivilegeGrantInfo(priv.toString(), 0, grantor, grantorType, grantOption)));
}
} else {
if (privSubjectDesc.getTable()) {
if (privSubjectDesc.getPartSpec() != null) {
privBag.addToPrivileges(new HiveObjectPrivilege(
new HiveObjectRef(HiveObjectType.PARTITION, dbName,
- tableName, partValues, null), null, null, new PrivilegeGrantInfo(priv.getPriv(), 0, grantor, grantorType, grantOption)));
+ tableName, partValues, null), null, null, new PrivilegeGrantInfo(priv.toString(), 0, grantor, grantorType, grantOption)));
} else {
privBag
.addToPrivileges(new HiveObjectPrivilege(
new HiveObjectRef(HiveObjectType.TABLE, dbName,
- tableName, null, null), null, null, new PrivilegeGrantInfo(priv.getPriv(), 0, grantor, grantorType, grantOption)));
+ tableName, null, null), null, null, new PrivilegeGrantInfo(priv.toString(), 0, grantor, grantorType, grantOption)));
}
} else {
privBag.addToPrivileges(new HiveObjectPrivilege(
new HiveObjectRef(HiveObjectType.DATABASE, dbName, null,
- null, null), null, null, new PrivilegeGrantInfo(priv.getPriv(), 0, grantor, grantorType, grantOption)));
+ null, null), null, null, new PrivilegeGrantInfo(priv.toString(), 0, grantor, grantorType, grantOption)));
}
}
}
Modified: hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java (original)
+++ hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java Thu Feb 17 07:44:49 2011
@@ -501,12 +501,10 @@ public class DDLSemanticAnalyzer extends
List<PrivilegeDesc> ret = new ArrayList<PrivilegeDesc>();
for (int i = 0; i < node.getChildCount(); i++) {
ASTNode privilegeDef = (ASTNode) node.getChild(i);
-
- String privilegeStr = unescapeIdentifier(privilegeDef.getChild(0)
- .getText());
- Privilege privObj = PrivilegeRegistry.getPrivilege(privilegeStr);
+ ASTNode privilegeType = (ASTNode) privilegeDef.getChild(0);
+ Privilege privObj = PrivilegeRegistry.getPrivilege(privilegeType.getType());
if (privObj == null) {
- throw new SemanticException("undefined privilege " + privilegeStr);
+ throw new SemanticException("undefined privilege " + privObj.toString());
}
List<String> cols = null;
if (privilegeDef.getChildCount() > 1) {
Modified: hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g (original)
+++ hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g Thu Feb 17 07:44:49 2011
@@ -202,6 +202,15 @@ TOK_USER;
TOK_GROUP;
TOK_ROLE;
TOK_GRANT_WITH_OPTION;
+TOK_PRIV_ALL;
+TOK_PRIV_ALTER_METADATA;
+TOK_PRIV_ALTER_DATA;
+TOK_PRIV_DROP;
+TOK_PRIV_INDEX;
+TOK_PRIV_LOCK;
+TOK_PRIV_SELECT;
+TOK_PRIV_SHOW_DATABASE;
+TOK_PRIV_CREATE;
TOK_PRIV_OBJECT;
TOK_PRIV_OBJECT_COL;
TOK_GRANT_ROLE;
@@ -846,8 +855,22 @@ privilegeList
privlegeDef
@init {msgs.push("grant privilege");}
@after {msgs.pop();}
- : Identifier (LPAREN cols=columnNameList RPAREN)?
- -> ^(TOK_PRIVILEGE Identifier $cols?)
+ : privilegeType (LPAREN cols=columnNameList RPAREN)?
+ -> ^(TOK_PRIVILEGE privilegeType $cols?)
+ ;
+
+privilegeType
+@init {msgs.push("privilege type");}
+@after {msgs.pop();}
+ : KW_ALL -> ^(TOK_PRIV_ALL)
+ | KW_ALTER -> ^(TOK_PRIV_ALTER_METADATA)
+ | KW_UPDATE -> ^(TOK_PRIV_ALTER_DATA)
+ | KW_CREATE -> ^(TOK_PRIV_CREATE)
+ | KW_DROP -> ^(TOK_PRIV_DROP)
+ | KW_INDEX -> ^(TOK_PRIV_INDEX)
+ | KW_LOCK -> ^(TOK_PRIV_LOCK)
+ | KW_SELECT -> ^(TOK_PRIV_SELECT)
+ | KW_SHOW_DATABASE -> ^(TOK_PRIV_SHOW_DATABASE)
;
principalSpecification
@@ -2143,6 +2166,8 @@ KW_COMPUTE: 'COMPUTE';
KW_STATISTICS: 'STATISTICS';
KW_USE: 'USE';
KW_OPTION: 'OPTION';
+KW_SHOW_DATABASE: 'SHOW_DATABASE';
+KW_UPDATE: 'UPDATE';
// Operators
Modified: hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/security/authorization/DefaultHiveAuthorizationProvider.java
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/security/authorization/DefaultHiveAuthorizationProvider.java?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/security/authorization/DefaultHiveAuthorizationProvider.java (original)
+++ hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/security/authorization/DefaultHiveAuthorizationProvider.java Thu Feb 17 07:44:49 2011
@@ -405,7 +405,7 @@ public class DefaultHiveAuthorizationPro
}
for (int i = 0; i < inputPriv.length; i++) {
- String toMatch = inputPriv[i].getPriv();
+ String toMatch = inputPriv[i].toString();
if (!check[i]) {
check[i] = privSet.contains(toMatch.toLowerCase());
}
@@ -467,7 +467,7 @@ public class DefaultHiveAuthorizationPro
int input = this.firstFalseIndex(inputCheck);
if (input >= 0) {
throw new AuthorizationException("No privilege '"
- + inputRequiredPriv[input].getPriv() + "' found for inputs "
+ + inputRequiredPriv[input].toString() + "' found for inputs "
+ hiveObject);
}
}
@@ -476,7 +476,7 @@ public class DefaultHiveAuthorizationPro
int output = this.firstFalseIndex(outputCheck);
if (output >= 0) {
throw new AuthorizationException("No privilege '"
- + outputRequiredPriv[output].getPriv() + "' found for outputs "
+ + outputRequiredPriv[output].toString() + "' found for outputs "
+ hiveObject);
}
}
Modified: hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/security/authorization/Privilege.java
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/security/authorization/Privilege.java?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/security/authorization/Privilege.java (original)
+++ hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/security/authorization/Privilege.java Thu Feb 17 07:44:49 2011
@@ -19,6 +19,7 @@
package org.apache.hadoop.hive.ql.security.authorization;
import java.util.EnumSet;
+import org.apache.hadoop.hive.ql.parse.HiveParser;
/**
* Privilege defines a privilege in Hive. Each privilege has a name and scope associated with it.
@@ -26,27 +27,91 @@ import java.util.EnumSet;
*/
public class Privilege {
- private String priv;
+ public enum PrivilegeType {
+ ALL,
+ ALTER_DATA,
+ ALTER_METADATA,
+ CREATE,
+ DROP,
+ INDEX,
+ LOCK,
+ SELECT,
+ SHOW_DATABASE,
+ UNKNOWN
+ }
+
+
+ public static PrivilegeType getPrivTypeByToken(int token) {
+ switch (token) {
+ case HiveParser.TOK_PRIV_ALL:
+ return PrivilegeType.ALL;
+ case HiveParser.TOK_PRIV_ALTER_DATA:
+ return PrivilegeType.ALTER_DATA;
+ case HiveParser.TOK_PRIV_ALTER_METADATA:
+ return PrivilegeType.ALTER_METADATA;
+ case HiveParser.TOK_PRIV_CREATE:
+ return PrivilegeType.CREATE;
+ case HiveParser.TOK_PRIV_DROP:
+ return PrivilegeType.DROP;
+ case HiveParser.TOK_PRIV_INDEX:
+ return PrivilegeType.INDEX;
+ case HiveParser.TOK_PRIV_LOCK:
+ return PrivilegeType.LOCK;
+ case HiveParser.TOK_PRIV_SELECT:
+ return PrivilegeType.SELECT;
+ case HiveParser.TOK_PRIV_SHOW_DATABASE:
+ return PrivilegeType.SHOW_DATABASE;
+ default:
+ return PrivilegeType.UNKNOWN;
+ }
+ }
+
+ public static PrivilegeType getPrivTypeByName(String privilegeName) {
+ String canonicalizedName = privilegeName.toLowerCase();
+ if (canonicalizedName.equals("all")) {
+ return PrivilegeType.ALL;
+ } else if (canonicalizedName.equals("update")) {
+ return PrivilegeType.ALTER_DATA;
+ } else if (canonicalizedName.equals("alter")) {
+ return PrivilegeType.ALTER_METADATA;
+ } else if (canonicalizedName.equals("create")) {
+ return PrivilegeType.CREATE;
+ } else if (canonicalizedName.equals("drop")) {
+ return PrivilegeType.DROP;
+ } else if (canonicalizedName.equals("index")) {
+ return PrivilegeType.INDEX;
+ } else if (canonicalizedName.equals("lock")) {
+ return PrivilegeType.LOCK;
+ } else if (canonicalizedName.equals("select")) {
+ return PrivilegeType.SELECT;
+ } else if (canonicalizedName.equals("show_database")) {
+ return PrivilegeType.SHOW_DATABASE;
+ }
+
+ return PrivilegeType.UNKNOWN;
+ }
+
+ private PrivilegeType priv;
private EnumSet<PrivilegeScope> supportedScopeSet;
- private Privilege(String priv, EnumSet<PrivilegeScope> scopeSet) {
+ private Privilege(PrivilegeType priv, EnumSet<PrivilegeScope> scopeSet) {
super();
this.priv = priv;
this.supportedScopeSet = scopeSet;
}
- public Privilege(String priv) {
+ public Privilege(PrivilegeType priv) {
super();
this.priv = priv;
}
- public String getPriv() {
+ public PrivilegeType getPriv() {
return priv;
}
- public void setPriv(String priv) {
+ public void setPriv(PrivilegeType priv) {
this.priv = priv;
}
@@ -65,38 +130,60 @@ public class Privilege {
&& supportedScopeSet.contains(PrivilegeScope.TABLE_LEVEL_SCOPE);
}
+ @Override
public String toString() {
- return this.priv;
+ switch (this.priv) {
+ case ALL:
+ return "All";
+ case ALTER_DATA:
+ return "Update";
+ case ALTER_METADATA:
+ return "Alter";
+ case CREATE:
+ return "Create";
+ case DROP:
+ return "Drop";
+ case INDEX:
+ return "Index";
+ case LOCK:
+ return "Lock";
+ case SELECT:
+ return "Select";
+ case SHOW_DATABASE:
+ return "Show_Database";
+ default:
+ return "Unknown";
+ }
}
public Privilege() {
}
- public static Privilege ALL = new Privilege("All",
+ public static Privilege ALL = new Privilege(PrivilegeType.ALL,
PrivilegeScope.ALLSCOPE_EXCEPT_COLUMN);
- public static Privilege ALTER_METADATA = new Privilege("Alter",
+ public static Privilege ALTER_METADATA = new Privilege(PrivilegeType.ALTER_METADATA,
PrivilegeScope.ALLSCOPE_EXCEPT_COLUMN);
- public static Privilege ALTER_DATA = new Privilege("Update",
+ public static Privilege ALTER_DATA = new Privilege(PrivilegeType.ALTER_DATA,
PrivilegeScope.ALLSCOPE_EXCEPT_COLUMN);
- public static Privilege CREATE = new Privilege("Create",
+ public static Privilege CREATE = new Privilege(PrivilegeType.CREATE,
PrivilegeScope.ALLSCOPE_EXCEPT_COLUMN);
- public static Privilege DROP = new Privilege("Drop",
+ public static Privilege DROP = new Privilege(PrivilegeType.DROP,
PrivilegeScope.ALLSCOPE_EXCEPT_COLUMN);
- public static Privilege INDEX = new Privilege("Index",
+ public static Privilege INDEX = new Privilege(PrivilegeType.INDEX,
PrivilegeScope.ALLSCOPE);
- public static Privilege LOCK = new Privilege("Lock",
+ public static Privilege LOCK = new Privilege(PrivilegeType.LOCK,
PrivilegeScope.ALLSCOPE_EXCEPT_COLUMN);
- public static Privilege SELECT = new Privilege("Select",
+ public static Privilege SELECT = new Privilege(PrivilegeType.SELECT,
PrivilegeScope.ALLSCOPE);
- public static Privilege SHOW_DATABASE = new Privilege("Show_Database",
+ public static Privilege SHOW_DATABASE = new Privilege(PrivilegeType.SHOW_DATABASE,
EnumSet.of(PrivilegeScope.USER_LEVEL_SCOPE));
}
Modified: hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/security/authorization/PrivilegeRegistry.java
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/security/authorization/PrivilegeRegistry.java?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/security/authorization/PrivilegeRegistry.java (original)
+++ hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/security/authorization/PrivilegeRegistry.java Thu Feb 17 07:44:49 2011
@@ -19,7 +19,8 @@
package org.apache.hadoop.hive.ql.security.authorization;
import java.util.HashMap;
-import java.util.Map;
+
+import org.apache.hadoop.hive.ql.security.authorization.Privilege.PrivilegeType;
/**
* PrivilegeRegistry is used to do privilege lookups. Given a privilege name, it
@@ -27,25 +28,31 @@ import java.util.Map;
*/
public class PrivilegeRegistry {
- protected static Map<String, Privilege> Registry = new HashMap<String, Privilege>();
+ protected static HashMap<PrivilegeType, Privilege> Registry = new HashMap<PrivilegeType, Privilege>();
static {
- Registry.put(Privilege.ALL.getPriv().toLowerCase(), Privilege.ALL);
- Registry.put(Privilege.ALTER_DATA.getPriv().toLowerCase(),
- Privilege.ALTER_DATA);
- Registry.put(Privilege.ALTER_METADATA.getPriv().toLowerCase(),
- Privilege.ALTER_METADATA);
- Registry.put(Privilege.CREATE.getPriv().toLowerCase(), Privilege.CREATE);
- Registry.put(Privilege.DROP.getPriv().toLowerCase(), Privilege.DROP);
- Registry.put(Privilege.INDEX.getPriv().toLowerCase(), Privilege.INDEX);
- Registry.put(Privilege.LOCK.getPriv().toLowerCase(), Privilege.LOCK);
- Registry.put(Privilege.SELECT.getPriv().toLowerCase(), Privilege.SELECT);
- Registry.put(Privilege.SHOW_DATABASE.getPriv().toLowerCase(),
+ Registry.put(Privilege.ALL.getPriv(), Privilege.ALL);
+ Registry.put(Privilege.ALTER_DATA.getPriv(), Privilege.ALTER_DATA);
+ Registry.put(Privilege.ALTER_METADATA.getPriv(), Privilege.ALTER_METADATA);
+ Registry.put(Privilege.CREATE.getPriv(), Privilege.CREATE);
+ Registry.put(Privilege.DROP.getPriv(), Privilege.DROP);
+ Registry.put(Privilege.INDEX.getPriv(), Privilege.INDEX);
+ Registry.put(Privilege.LOCK.getPriv(), Privilege.LOCK);
+ Registry.put(Privilege.SELECT.getPriv(), Privilege.SELECT);
+ Registry.put(Privilege.SHOW_DATABASE.getPriv(),
Privilege.SHOW_DATABASE);
}
+ public static Privilege getPrivilege(PrivilegeType privilegeType) {
+ return Registry.get(privilegeType);
+ }
+
+ public static Privilege getPrivilege(int privilegeToken) {
+ return Registry.get(Privilege.getPrivTypeByToken(privilegeToken));
+ }
+
public static Privilege getPrivilege(String privilegeName) {
- return Registry.get(privilegeName.toLowerCase());
+ return Registry.get(Privilege.getPrivTypeByName(privilegeName));
}
}
Modified: hive/trunk/ql/src/test/queries/clientnegative/authorization_fail_1.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/authorization_fail_1.q?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/authorization_fail_1.q (original)
+++ hive/trunk/ql/src/test/queries/clientnegative/authorization_fail_1.q Thu Feb 17 07:44:49 2011
@@ -1,7 +1,7 @@
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;
+grant Create on table authorization_fail_1 to user hive_test_user;
+grant Create on table authorization_fail_1 to user hive_test_user;
Modified: hive/trunk/ql/src/test/queries/clientnegative/authorization_fail_3.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/authorization_fail_3.q?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/authorization_fail_3.q (original)
+++ hive/trunk/ql/src/test/queries/clientnegative/authorization_fail_3.q Thu Feb 17 07:44:49 2011
@@ -1,7 +1,7 @@
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;
+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;
Modified: hive/trunk/ql/src/test/queries/clientnegative/authorization_fail_4.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/authorization_fail_4.q?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/authorization_fail_4.q (original)
+++ hive/trunk/ql/src/test/queries/clientnegative/authorization_fail_4.q Thu Feb 17 07:44:49 2011
@@ -1,10 +1,10 @@
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;
+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;
+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;
Modified: hive/trunk/ql/src/test/queries/clientnegative/authorization_fail_5.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/authorization_fail_5.q?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/authorization_fail_5.q (original)
+++ hive/trunk/ql/src/test/queries/clientnegative/authorization_fail_5.q Thu Feb 17 07:44:49 2011
@@ -1,17 +1,17 @@
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;
+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;
+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;
+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');
Modified: hive/trunk/ql/src/test/queries/clientnegative/authorization_fail_7.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/authorization_fail_7.q?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/authorization_fail_7.q (original)
+++ hive/trunk/ql/src/test/queries/clientnegative/authorization_fail_7.q Thu Feb 17 07:44:49 2011
@@ -5,7 +5,7 @@ set hive.security.authorization.enabled=
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;
+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;
Modified: hive/trunk/ql/src/test/queries/clientnegative/authorization_part.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/authorization_part.q?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/authorization_part.q (original)
+++ hive/trunk/ql/src/test/queries/clientnegative/authorization_part.q Thu Feb 17 07:44:49 2011
@@ -2,15 +2,15 @@ create table authorization_part_fail (ke
ALTER TABLE authorization_part_fail SET TBLPROPERTIES ("PARTITION_LEVEL_PRIVILEGE"="TRUE");
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 to user hive_test_user;
+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 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;
+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;
@@ -26,7 +26,7 @@ select key, value from authorization_par
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;
+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;
Modified: hive/trunk/ql/src/test/queries/clientpositive/authorization_1.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/authorization_1.q?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/authorization_1.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/authorization_1.q Thu Feb 17 07:44:49 2011
@@ -4,53 +4,53 @@ set hive.security.authorization.enabled=
--table grant to user
-grant `select` on table src_autho_test to user hive_test_user;
+grant select on table src_autho_test to user hive_test_user;
show grant user hive_test_user on table src_autho_test;
show grant user hive_test_user on table src_autho_test(key);
select key from src_autho_test order by key limit 20;
-revoke `select` on table src_autho_test from user hive_test_user;
+revoke select on table src_autho_test from user hive_test_user;
show grant user hive_test_user on table src_autho_test;
show grant user hive_test_user on table src_autho_test(key);
--column grant to user
-grant `select`(key) on table src_autho_test to user hive_test_user;
+grant select(key) on table src_autho_test to user hive_test_user;
show grant user hive_test_user on table src_autho_test;
show grant user hive_test_user on table src_autho_test(key);
select key from src_autho_test order by key limit 20;
-revoke `select`(key) on table src_autho_test from user hive_test_user;
+revoke select(key) on table src_autho_test from user hive_test_user;
show grant user hive_test_user on table src_autho_test;
show grant user hive_test_user on table src_autho_test(key);
--table grant to group
-grant `select` on table src_autho_test to group hive_test_group1;
+grant select on table src_autho_test to group hive_test_group1;
show grant group hive_test_group1 on table src_autho_test;
show grant group hive_test_group1 on table src_autho_test(key);
select key from src_autho_test order by key limit 20;
-revoke `select` on table src_autho_test from group hive_test_group1;
+revoke select on table src_autho_test from group hive_test_group1;
show grant group hive_test_group1 on table src_autho_test;
show grant group hive_test_group1 on table src_autho_test(key);
--column grant to group
-grant `select`(key) on table src_autho_test to group hive_test_group1;
+grant select(key) on table src_autho_test to group hive_test_group1;
show grant group hive_test_group1 on table src_autho_test;
show grant group hive_test_group1 on table src_autho_test(key);
select key from src_autho_test order by key limit 20;
-revoke `select`(key) on table src_autho_test from group hive_test_group1;
+revoke select(key) on table src_autho_test from group hive_test_group1;
show grant group hive_test_group1 on table src_autho_test;
show grant group hive_test_group1 on table src_autho_test(key);
@@ -61,24 +61,24 @@ show role grant user hive_test_user;
--column grant to role
-grant `select`(key) on table src_autho_test to role src_role;
+grant select(key) on table src_autho_test to role src_role;
show grant role src_role on table src_autho_test;
show grant role src_role on table src_autho_test(key);
select key from src_autho_test order by key limit 20;
-revoke `select`(key) on table src_autho_test from role src_role;
+revoke select(key) on table src_autho_test from role src_role;
--table grant to role
-grant `select` on table src_autho_test to role src_role;
+grant select on table src_autho_test to role src_role;
select key from src_autho_test order by key limit 20;
show grant role src_role on table src_autho_test;
show grant role src_role on table src_autho_test(key);
-revoke `select` on table src_autho_test from role src_role;
+revoke select on table src_autho_test from role src_role;
-- drop role
drop role src_role;
Modified: hive/trunk/ql/src/test/queries/clientpositive/authorization_2.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/authorization_2.q?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/authorization_2.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/authorization_2.q Thu Feb 17 07:44:49 2011
@@ -4,30 +4,30 @@ ALTER TABLE authorization_part SET TBLPR
set hive.security.authorization.enabled=true;
-- column grant to user
-grant `Create` on table authorization_part to user hive_test_user;
-grant `Update` on table authorization_part to user hive_test_user;
-grant `Drop` on table authorization_part to user hive_test_user;
-grant `select` on table src to user hive_test_user;
+grant Create on table authorization_part to user hive_test_user;
+grant Update on table authorization_part to user hive_test_user;
+grant Drop on table authorization_part to user hive_test_user;
+grant select on table src to user hive_test_user;
show grant user hive_test_user on table authorization_part;
alter table authorization_part add partition (ds='2010');
show grant user hive_test_user on table authorization_part partition (ds='2010');
-grant `select`(key) on table authorization_part to user hive_test_user;
+grant select(key) on table authorization_part to user hive_test_user;
alter table authorization_part drop partition (ds='2010');
insert overwrite table authorization_part partition (ds='2010') select key, value from src;
show grant user hive_test_user on table authorization_part(key) partition (ds='2010');
show grant user hive_test_user on table authorization_part(key);
select key from authorization_part where ds='2010' order by key limit 20;
-revoke `select`(key) on table authorization_part from user hive_test_user;
+revoke select(key) on table authorization_part from user hive_test_user;
show grant user hive_test_user on table authorization_part(key);
show grant user hive_test_user on table authorization_part(key) partition (ds='2010');
select key from authorization_part where ds='2010' order by key limit 20;
-revoke `select`(key) on table authorization_part partition (ds='2010') from user hive_test_user;
+revoke select(key) on table authorization_part partition (ds='2010') from user hive_test_user;
show grant user hive_test_user on table authorization_part(key) partition (ds='2010');
alter table authorization_part drop partition (ds='2010');
@@ -38,20 +38,20 @@ show grant user hive_test_user on table
alter table authorization_part add partition (ds='2010');
show grant user hive_test_user on table authorization_part partition (ds='2010');
-grant `select` on table authorization_part to user hive_test_user;
+grant select on table authorization_part to user hive_test_user;
alter table authorization_part drop partition (ds='2010');
insert overwrite table authorization_part partition (ds='2010') select key, value from src;
show grant user hive_test_user on table authorization_part partition (ds='2010');
show grant user hive_test_user on table authorization_part;
select key from authorization_part where ds='2010' order by key limit 20;
-revoke `select` on table authorization_part from user hive_test_user;
+revoke select on table authorization_part from user hive_test_user;
show grant user hive_test_user on table authorization_part;
show grant user hive_test_user on table authorization_part partition (ds='2010');
select key from authorization_part where ds='2010' order by key limit 20;
-revoke `select` on table authorization_part partition (ds='2010') from user hive_test_user;
+revoke select on table authorization_part partition (ds='2010') from user hive_test_user;
show grant user hive_test_user on table authorization_part partition (ds='2010');
alter table authorization_part drop partition (ds='2010');
@@ -63,20 +63,20 @@ show grant group hive_test_group1 on tab
alter table authorization_part add partition (ds='2010');
show grant group hive_test_group1 on table authorization_part partition (ds='2010');
-grant `select`(key) on table authorization_part to group hive_test_group1;
+grant select(key) on table authorization_part to group hive_test_group1;
alter table authorization_part drop partition (ds='2010');
insert overwrite table authorization_part partition (ds='2010') select key, value from src;
show grant group hive_test_group1 on table authorization_part(key) partition (ds='2010');
show grant group hive_test_group1 on table authorization_part(key);
select key from authorization_part where ds='2010' order by key limit 20;
-revoke `select`(key) on table authorization_part from group hive_test_group1;
+revoke select(key) on table authorization_part from group hive_test_group1;
show grant group hive_test_group1 on table authorization_part(key);
show grant group hive_test_group1 on table authorization_part(key) partition (ds='2010');
select key from authorization_part where ds='2010' order by key limit 20;
-revoke `select`(key) on table authorization_part partition (ds='2010') from group hive_test_group1;
+revoke select(key) on table authorization_part partition (ds='2010') from group hive_test_group1;
show grant group hive_test_group1 on table authorization_part(key) partition (ds='2010');
alter table authorization_part drop partition (ds='2010');
@@ -87,23 +87,23 @@ show grant group hive_test_group1 on tab
alter table authorization_part add partition (ds='2010');
show grant group hive_test_group1 on table authorization_part partition (ds='2010');
-grant `select` on table authorization_part to group hive_test_group1;
+grant select on table authorization_part to group hive_test_group1;
alter table authorization_part drop partition (ds='2010');
insert overwrite table authorization_part partition (ds='2010') select key, value from src;
show grant group hive_test_group1 on table authorization_part partition (ds='2010');
show grant group hive_test_group1 on table authorization_part;
select key from authorization_part where ds='2010' order by key limit 20;
-revoke `select` on table authorization_part from group hive_test_group1;
+revoke select on table authorization_part from group hive_test_group1;
show grant group hive_test_group1 on table authorization_part;
show grant group hive_test_group1 on table authorization_part partition (ds='2010');
select key from authorization_part where ds='2010' order by key limit 20;
-revoke `select` on table authorization_part partition (ds='2010') from group hive_test_group1;
+revoke select on table authorization_part partition (ds='2010') from group hive_test_group1;
show grant group hive_test_group1 on table authorization_part partition (ds='2010');
-revoke `select` on table src from user hive_test_user;
+revoke select on table src from user hive_test_user;
set hive.security.authorization.enabled=false;
drop table authorization_part;
\ No newline at end of file
Modified: hive/trunk/ql/src/test/queries/clientpositive/authorization_3.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/authorization_3.q?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/authorization_3.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/authorization_3.q Thu Feb 17 07:44:49 2011
@@ -1,17 +1,17 @@
create table src_autho_test as select * from src;
-grant `drop` on table src_autho_test to user hive_test_user;
-grant `select` on table src_autho_test to user hive_test_user;
+grant drop on table src_autho_test to user hive_test_user;
+grant select on table src_autho_test to user hive_test_user;
show grant user hive_test_user on table src_autho_test;
-revoke `select` on table src_autho_test from user hive_test_user;
-revoke `drop` on table src_autho_test from user hive_test_user;
+revoke select on table src_autho_test from user hive_test_user;
+revoke drop on table src_autho_test from user hive_test_user;
-grant `drop`,`select` on table src_autho_test to user hive_test_user;
+grant drop,select on table src_autho_test to user hive_test_user;
show grant user hive_test_user on table src_autho_test;
-revoke `drop`,`select` on table src_autho_test from user hive_test_user;
+revoke drop,select on table src_autho_test from user hive_test_user;
-grant `drop`,`select`(key), `select`(value) on table src to user hive_test_user;
+grant drop,select(key), select(value) on table src to user hive_test_user;
show grant user hive_test_user on table src_autho_test;
-revoke `drop`,`select`(key), `select`(value) on table src from user hive_test_user;
\ No newline at end of file
+revoke drop,select(key), select(value) on table src from user hive_test_user;
Modified: hive/trunk/ql/src/test/queries/clientpositive/authorization_4.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/authorization_4.q?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/authorization_4.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/authorization_4.q Thu Feb 17 07:44:49 2011
@@ -1,6 +1,6 @@
create table src_autho_test as select * from src;
-grant `All` on table src_autho_test to user hive_test_user;
+grant All on table src_autho_test to user hive_test_user;
set hive.security.authorization.enabled=true;
Modified: hive/trunk/ql/src/test/queries/clientpositive/authorization_5.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/authorization_5.q?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/authorization_5.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/authorization_5.q Thu Feb 17 07:44:49 2011
@@ -1,8 +1,8 @@
CREATE DATABASE IF NOT EXISTS test_db COMMENT 'Hive test database';
SHOW DATABASES;
-GRANT `drop` ON DATABASE test_db TO USER hive_test_user;
-GRANT `select` ON DATABASE test_db TO USER hive_test_user;
+GRANT drop ON DATABASE test_db TO USER hive_test_user;
+GRANT select ON DATABASE test_db TO USER hive_test_user;
SHOW GRANT USER hive_test_user ON DATABASE test_db;
@@ -10,8 +10,8 @@ CREATE ROLE db_test_role;
GRANT ROLE db_test_role TO USER hive_test_user;
SHOW ROLE GRANT USER hive_test_user;
-GRANT `drop` ON DATABASE test_db TO ROLE db_test_role;
-GRANT `select` ON DATABASE test_db TO ROLE db_test_role;
+GRANT drop ON DATABASE test_db TO ROLE db_test_role;
+GRANT select ON DATABASE test_db TO ROLE db_test_role;
SHOW GRANT ROLE db_test_role ON DATABASE test_db;
Modified: hive/trunk/ql/src/test/queries/clientpositive/keyword_1.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/keyword_1.q?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/keyword_1.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/keyword_1.q Thu Feb 17 07:44:49 2011
@@ -1,5 +1,5 @@
create table test_user (user string, `group` string);
-grant `select` on table test_user to user hive_test;
+grant select on table test_user to user hive_test;
explain select user from test_user;
@@ -8,7 +8,7 @@ show grant user hive_test on table test_
drop table test_user;
create table test_user (role string, `group` string);
-grant `select` on table test_user to user hive_test;
+grant select on table test_user to user hive_test;
explain select role from test_user;
Modified: hive/trunk/ql/src/test/results/clientnegative/authorization_fail_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/authorization_fail_1.q.out?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/authorization_fail_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientnegative/authorization_fail_1.q.out Thu Feb 17 07:44:49 2011
@@ -3,11 +3,11 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table authorization_fail_1 (key int, value string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@authorization_fail_1
-PREHOOK: query: grant `Create` on table authorization_fail_1 to user hive_test_user
+PREHOOK: query: grant Create on table authorization_fail_1 to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `Create` on table authorization_fail_1 to user hive_test_user
+POSTHOOK: query: grant Create on table authorization_fail_1 to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
-PREHOOK: query: grant `Create` on table authorization_fail_1 to user hive_test_user
+PREHOOK: query: grant Create on table authorization_fail_1 to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
Error: java.lang.RuntimeException: InvalidObjectException(message:Create is already granted on table [default,authorization_fail_1] by hive_test_user)
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
Modified: hive/trunk/ql/src/test/results/clientnegative/authorization_fail_3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/authorization_fail_3.q.out?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/authorization_fail_3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientnegative/authorization_fail_3.q.out Thu Feb 17 07:44:49 2011
@@ -3,9 +3,9 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table authorization_fail_3 (key int, value string) partitioned by (ds string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@authorization_fail_3
-PREHOOK: query: grant `Create` on table authorization_fail_3 to user hive_test_user
+PREHOOK: query: grant Create on table authorization_fail_3 to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `Create` on table authorization_fail_3 to user hive_test_user
+POSTHOOK: query: grant Create on table authorization_fail_3 to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: alter table authorization_fail_3 add partition (ds='2010')
PREHOOK: type: ALTERTABLE_ADDPARTS
Modified: hive/trunk/ql/src/test/results/clientnegative/authorization_fail_4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/authorization_fail_4.q.out?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/authorization_fail_4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientnegative/authorization_fail_4.q.out Thu Feb 17 07:44:49 2011
@@ -3,9 +3,9 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table authorization_fail_4 (key int, value string) partitioned by (ds string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@authorization_fail_4
-PREHOOK: query: grant `Alter` on table authorization_fail_4 to user hive_test_user
+PREHOOK: query: grant Alter on table authorization_fail_4 to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `Alter` on table authorization_fail_4 to user hive_test_user
+POSTHOOK: query: grant Alter on table authorization_fail_4 to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: ALTER TABLE authorization_fail_4 SET TBLPROPERTIES ("PARTITION_LEVEL_PRIVILEGE"="TRUE")
PREHOOK: type: ALTERTABLE_PROPERTIES
@@ -15,9 +15,9 @@ POSTHOOK: query: ALTER TABLE authorizati
POSTHOOK: type: ALTERTABLE_PROPERTIES
POSTHOOK: Input: default@authorization_fail_4
POSTHOOK: Output: default@authorization_fail_4
-PREHOOK: query: grant `Create` on table authorization_fail_4 to user hive_test_user
+PREHOOK: query: grant Create on table authorization_fail_4 to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `Create` on table authorization_fail_4 to user hive_test_user
+POSTHOOK: query: grant Create on table authorization_fail_4 to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: alter table authorization_fail_4 add partition (ds='2010')
PREHOOK: type: ALTERTABLE_ADDPARTS
Modified: hive/trunk/ql/src/test/results/clientnegative/authorization_fail_5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/authorization_fail_5.q.out?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/authorization_fail_5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientnegative/authorization_fail_5.q.out Thu Feb 17 07:44:49 2011
@@ -3,9 +3,9 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table authorization_fail (key int, value string) partitioned by (ds string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@authorization_fail
-PREHOOK: query: grant `Alter` on table authorization_fail to user hive_test_user
+PREHOOK: query: grant Alter on table authorization_fail to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `Alter` on table authorization_fail to user hive_test_user
+POSTHOOK: query: grant Alter on table authorization_fail to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: ALTER TABLE authorization_fail SET TBLPROPERTIES ("PARTITION_LEVEL_PRIVILEGE"="TRUE")
PREHOOK: type: ALTERTABLE_PROPERTIES
@@ -15,13 +15,13 @@ POSTHOOK: query: ALTER TABLE authorizati
POSTHOOK: type: ALTERTABLE_PROPERTIES
POSTHOOK: Input: default@authorization_fail
POSTHOOK: Output: default@authorization_fail
-PREHOOK: query: grant `Create` on table authorization_fail to user hive_test_user
+PREHOOK: query: grant Create on table authorization_fail to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `Create` on table authorization_fail to user hive_test_user
+POSTHOOK: query: grant Create on table authorization_fail to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
-PREHOOK: query: grant `Select` on table authorization_fail to user hive_test_user
+PREHOOK: query: grant Select on table authorization_fail to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `Select` on table authorization_fail to user hive_test_user
+POSTHOOK: query: grant Select on table authorization_fail to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: alter table authorization_fail add partition (ds='2010')
PREHOOK: type: ALTERTABLE_ADDPARTS
@@ -89,9 +89,9 @@ principalType USER
privilege Select
grantTime 1296259811
grantor hive_test_user
-PREHOOK: query: revoke `Select` on table authorization_fail partition (ds='2010') from user hive_test_user
+PREHOOK: query: revoke Select on table authorization_fail partition (ds='2010') from user hive_test_user
PREHOOK: type: REVOKE_PRIVILEGE
-POSTHOOK: query: revoke `Select` on table authorization_fail partition (ds='2010') from user hive_test_user
+POSTHOOK: query: revoke Select on table authorization_fail partition (ds='2010') from user hive_test_user
POSTHOOK: type: REVOKE_PRIVILEGE
PREHOOK: query: show grant user hive_test_user on table authorization_fail partition (ds='2010')
PREHOOK: type: SHOW_GRANT
Modified: hive/trunk/ql/src/test/results/clientnegative/authorization_fail_7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/authorization_fail_7.q.out?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/authorization_fail_7.q.out (original)
+++ hive/trunk/ql/src/test/results/clientnegative/authorization_fail_7.q.out Thu Feb 17 07:44:49 2011
@@ -11,9 +11,9 @@ PREHOOK: query: grant role hive_test_rol
PREHOOK: type: GRANT_ROLE
POSTHOOK: query: grant role hive_test_role_fail to user hive_test_user
POSTHOOK: type: GRANT_ROLE
-PREHOOK: query: grant `select` on table authorization_fail to role hive_test_role_fail
+PREHOOK: query: grant select on table authorization_fail to role hive_test_role_fail
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `select` on table authorization_fail to role hive_test_role_fail
+POSTHOOK: query: grant select on table authorization_fail to role hive_test_role_fail
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: show role grant user hive_test_user
PREHOOK: type: SHOW_ROLE_GRANT
Modified: hive/trunk/ql/src/test/results/clientnegative/authorization_part.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/authorization_part.q.out?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/authorization_part.q.out (original)
+++ hive/trunk/ql/src/test/results/clientnegative/authorization_part.q.out Thu Feb 17 07:44:49 2011
@@ -11,33 +11,33 @@ POSTHOOK: query: ALTER TABLE authorizati
POSTHOOK: type: ALTERTABLE_PROPERTIES
POSTHOOK: Input: default@authorization_part_fail
POSTHOOK: Output: default@authorization_part_fail
-PREHOOK: query: grant `Create` on table authorization_part_fail to user hive_test_user
+PREHOOK: query: grant Create on table authorization_part_fail to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `Create` on table authorization_part_fail to user hive_test_user
+POSTHOOK: query: grant Create on table authorization_part_fail to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
-PREHOOK: query: grant `Update` on table authorization_part_fail to user hive_test_user
+PREHOOK: query: grant Update on table authorization_part_fail to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `Update` on table authorization_part_fail to user hive_test_user
+POSTHOOK: query: grant Update on table authorization_part_fail to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
-PREHOOK: query: grant `Drop` on table authorization_part_fail to user hive_test_user
+PREHOOK: query: grant Drop on table authorization_part_fail to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `Drop` on table authorization_part_fail to user hive_test_user
+POSTHOOK: query: grant Drop on table authorization_part_fail to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
-PREHOOK: query: grant `select` on table src to user hive_test_user
+PREHOOK: query: grant select on table src to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `select` on table src to user hive_test_user
+POSTHOOK: query: grant select on table src to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: -- column grant to group
-grant `select`(key) on table authorization_part_fail to group hive_test_group1
+grant select(key) on table authorization_part_fail to group hive_test_group1
PREHOOK: type: GRANT_PRIVILEGE
POSTHOOK: query: -- column grant to group
-grant `select`(key) on table authorization_part_fail to group hive_test_group1
+grant select(key) on table authorization_part_fail to group hive_test_group1
POSTHOOK: type: GRANT_PRIVILEGE
-PREHOOK: query: grant `select` on table authorization_part_fail to group hive_test_group1
+PREHOOK: query: grant select on table authorization_part_fail to group hive_test_group1
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `select` on table authorization_part_fail to group hive_test_group1
+POSTHOOK: query: grant select on table authorization_part_fail to group hive_test_group1
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: show grant group hive_test_group1 on table authorization_part_fail
PREHOOK: type: SHOW_GRANT
@@ -235,9 +235,9 @@ POSTHOOK: Lineage: authorization_part_fa
8 val_8 2011
9 val_9 2010
9 val_9 2011
-PREHOOK: query: revoke `select` on table authorization_part_fail partition (ds='2010') from group hive_test_group1
+PREHOOK: query: revoke select on table authorization_part_fail partition (ds='2010') from group hive_test_group1
PREHOOK: type: REVOKE_PRIVILEGE
-POSTHOOK: query: revoke `select` on table authorization_part_fail partition (ds='2010') from group hive_test_group1
+POSTHOOK: query: revoke select on table authorization_part_fail partition (ds='2010') from group hive_test_group1
POSTHOOK: type: REVOKE_PRIVILEGE
POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2010).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2010).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_1.q.out?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_1.q.out Thu Feb 17 07:44:49 2011
@@ -7,11 +7,11 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@src_autho_test
PREHOOK: query: --table grant to user
-grant `select` on table src_autho_test to user hive_test_user
+grant select on table src_autho_test to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
POSTHOOK: query: --table grant to user
-grant `select` on table src_autho_test to user hive_test_user
+grant select on table src_autho_test to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: show grant user hive_test_user on table src_autho_test
PREHOOK: type: SHOW_GRANT
@@ -57,9 +57,9 @@ POSTHOOK: Output: file:/var/folders/6g/6
118
118
119
-PREHOOK: query: revoke `select` on table src_autho_test from user hive_test_user
+PREHOOK: query: revoke select on table src_autho_test from user hive_test_user
PREHOOK: type: REVOKE_PRIVILEGE
-POSTHOOK: query: revoke `select` on table src_autho_test from user hive_test_user
+POSTHOOK: query: revoke select on table src_autho_test from user hive_test_user
POSTHOOK: type: REVOKE_PRIVILEGE
PREHOOK: query: show grant user hive_test_user on table src_autho_test
PREHOOK: type: SHOW_GRANT
@@ -71,11 +71,11 @@ POSTHOOK: query: show grant user hive_te
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: --column grant to user
-grant `select`(key) on table src_autho_test to user hive_test_user
+grant select(key) on table src_autho_test to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
POSTHOOK: query: --column grant to user
-grant `select`(key) on table src_autho_test to user hive_test_user
+grant select(key) on table src_autho_test to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: show grant user hive_test_user on table src_autho_test
PREHOOK: type: SHOW_GRANT
@@ -122,9 +122,9 @@ POSTHOOK: Output: file:/var/folders/6g/6
118
118
119
-PREHOOK: query: revoke `select`(key) on table src_autho_test from user hive_test_user
+PREHOOK: query: revoke select(key) on table src_autho_test from user hive_test_user
PREHOOK: type: REVOKE_PRIVILEGE
-POSTHOOK: query: revoke `select`(key) on table src_autho_test from user hive_test_user
+POSTHOOK: query: revoke select(key) on table src_autho_test from user hive_test_user
POSTHOOK: type: REVOKE_PRIVILEGE
PREHOOK: query: show grant user hive_test_user on table src_autho_test
PREHOOK: type: SHOW_GRANT
@@ -136,11 +136,11 @@ POSTHOOK: query: show grant user hive_te
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: --table grant to group
-grant `select` on table src_autho_test to group hive_test_group1
+grant select on table src_autho_test to group hive_test_group1
PREHOOK: type: GRANT_PRIVILEGE
POSTHOOK: query: --table grant to group
-grant `select` on table src_autho_test to group hive_test_group1
+grant select on table src_autho_test to group hive_test_group1
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: show grant group hive_test_group1 on table src_autho_test
PREHOOK: type: SHOW_GRANT
@@ -186,9 +186,9 @@ POSTHOOK: Output: file:/var/folders/6g/6
118
118
119
-PREHOOK: query: revoke `select` on table src_autho_test from group hive_test_group1
+PREHOOK: query: revoke select on table src_autho_test from group hive_test_group1
PREHOOK: type: REVOKE_PRIVILEGE
-POSTHOOK: query: revoke `select` on table src_autho_test from group hive_test_group1
+POSTHOOK: query: revoke select on table src_autho_test from group hive_test_group1
POSTHOOK: type: REVOKE_PRIVILEGE
PREHOOK: query: show grant group hive_test_group1 on table src_autho_test
PREHOOK: type: SHOW_GRANT
@@ -200,11 +200,11 @@ POSTHOOK: query: show grant group hive_t
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: --column grant to group
-grant `select`(key) on table src_autho_test to group hive_test_group1
+grant select(key) on table src_autho_test to group hive_test_group1
PREHOOK: type: GRANT_PRIVILEGE
POSTHOOK: query: --column grant to group
-grant `select`(key) on table src_autho_test to group hive_test_group1
+grant select(key) on table src_autho_test to group hive_test_group1
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: show grant group hive_test_group1 on table src_autho_test
PREHOOK: type: SHOW_GRANT
@@ -251,9 +251,9 @@ POSTHOOK: Output: file:/var/folders/6g/6
118
118
119
-PREHOOK: query: revoke `select`(key) on table src_autho_test from group hive_test_group1
+PREHOOK: query: revoke select(key) on table src_autho_test from group hive_test_group1
PREHOOK: type: REVOKE_PRIVILEGE
-POSTHOOK: query: revoke `select`(key) on table src_autho_test from group hive_test_group1
+POSTHOOK: query: revoke select(key) on table src_autho_test from group hive_test_group1
POSTHOOK: type: REVOKE_PRIVILEGE
PREHOOK: query: show grant group hive_test_group1 on table src_autho_test
PREHOOK: type: SHOW_GRANT
@@ -281,11 +281,11 @@ role name:src_role
role name:src_role
PREHOOK: query: --column grant to role
-grant `select`(key) on table src_autho_test to role src_role
+grant select(key) on table src_autho_test to role src_role
PREHOOK: type: GRANT_PRIVILEGE
POSTHOOK: query: --column grant to role
-grant `select`(key) on table src_autho_test to role src_role
+grant select(key) on table src_autho_test to role src_role
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: show grant role src_role on table src_autho_test
PREHOOK: type: SHOW_GRANT
@@ -332,17 +332,17 @@ POSTHOOK: Output: file:/var/folders/6g/6
118
118
119
-PREHOOK: query: revoke `select`(key) on table src_autho_test from role src_role
+PREHOOK: query: revoke select(key) on table src_autho_test from role src_role
PREHOOK: type: REVOKE_PRIVILEGE
-POSTHOOK: query: revoke `select`(key) on table src_autho_test from role src_role
+POSTHOOK: query: revoke select(key) on table src_autho_test from role src_role
POSTHOOK: type: REVOKE_PRIVILEGE
PREHOOK: query: --table grant to role
-grant `select` on table src_autho_test to role src_role
+grant select on table src_autho_test to role src_role
PREHOOK: type: GRANT_PRIVILEGE
POSTHOOK: query: --table grant to role
-grant `select` on table src_autho_test to role src_role
+grant select on table src_autho_test to role src_role
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: select key from src_autho_test order by key limit 20
PREHOOK: type: QUERY
@@ -388,9 +388,9 @@ PREHOOK: query: show grant role src_role
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant role src_role on table src_autho_test(key)
POSTHOOK: type: SHOW_GRANT
-PREHOOK: query: revoke `select` on table src_autho_test from role src_role
+PREHOOK: query: revoke select on table src_autho_test from role src_role
PREHOOK: type: REVOKE_PRIVILEGE
-POSTHOOK: query: revoke `select` on table src_autho_test from role src_role
+POSTHOOK: query: revoke select on table src_autho_test from role src_role
POSTHOOK: type: REVOKE_PRIVILEGE
PREHOOK: query: -- drop role
drop role src_role
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_2.q.out?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_2.q.out Thu Feb 17 07:44:49 2011
@@ -12,22 +12,22 @@ POSTHOOK: type: ALTERTABLE_PROPERTIES
POSTHOOK: Input: default@authorization_part
POSTHOOK: Output: default@authorization_part
PREHOOK: query: -- column grant to user
-grant `Create` on table authorization_part to user hive_test_user
+grant Create on table authorization_part to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
POSTHOOK: query: -- column grant to user
-grant `Create` on table authorization_part to user hive_test_user
+grant Create on table authorization_part to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
-PREHOOK: query: grant `Update` on table authorization_part to user hive_test_user
+PREHOOK: query: grant Update on table authorization_part to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `Update` on table authorization_part to user hive_test_user
+POSTHOOK: query: grant Update on table authorization_part to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
-PREHOOK: query: grant `Drop` on table authorization_part to user hive_test_user
+PREHOOK: query: grant Drop on table authorization_part to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `Drop` on table authorization_part to user hive_test_user
+POSTHOOK: query: grant Drop on table authorization_part to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
-PREHOOK: query: grant `select` on table src to user hive_test_user
+PREHOOK: query: grant select on table src to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `select` on table src to user hive_test_user
+POSTHOOK: query: grant select on table src to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: show grant user hive_test_user on table authorization_part
PREHOOK: type: SHOW_GRANT
@@ -95,9 +95,9 @@ principalType USER
privilege Drop
grantTime 1296259217
grantor hive_test_user
-PREHOOK: query: grant `select`(key) on table authorization_part to user hive_test_user
+PREHOOK: query: grant select(key) on table authorization_part to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `select`(key) on table authorization_part to user hive_test_user
+POSTHOOK: query: grant select(key) on table authorization_part to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: alter table authorization_part drop partition (ds='2010')
PREHOOK: type: ALTERTABLE_DROPPARTS
@@ -178,9 +178,9 @@ POSTHOOK: Lineage: authorization_part PA
18
18
19
-PREHOOK: query: revoke `select`(key) on table authorization_part from user hive_test_user
+PREHOOK: query: revoke select(key) on table authorization_part from user hive_test_user
PREHOOK: type: REVOKE_PRIVILEGE
-POSTHOOK: query: revoke `select`(key) on table authorization_part from user hive_test_user
+POSTHOOK: query: revoke select(key) on table authorization_part from user hive_test_user
POSTHOOK: type: REVOKE_PRIVILEGE
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -236,9 +236,9 @@ POSTHOOK: Lineage: authorization_part PA
18
18
19
-PREHOOK: query: revoke `select`(key) on table authorization_part partition (ds='2010') from user hive_test_user
+PREHOOK: query: revoke select(key) on table authorization_part partition (ds='2010') from user hive_test_user
PREHOOK: type: REVOKE_PRIVILEGE
-POSTHOOK: query: revoke `select`(key) on table authorization_part partition (ds='2010') from user hive_test_user
+POSTHOOK: query: revoke select(key) on table authorization_part partition (ds='2010') from user hive_test_user
POSTHOOK: type: REVOKE_PRIVILEGE
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -332,9 +332,9 @@ principalType USER
privilege Drop
grantTime 1296259240
grantor hive_test_user
-PREHOOK: query: grant `select` on table authorization_part to user hive_test_user
+PREHOOK: query: grant select on table authorization_part to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `select` on table authorization_part to user hive_test_user
+POSTHOOK: query: grant select on table authorization_part to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -476,9 +476,9 @@ POSTHOOK: Lineage: authorization_part PA
18
18
19
-PREHOOK: query: revoke `select` on table authorization_part from user hive_test_user
+PREHOOK: query: revoke select on table authorization_part from user hive_test_user
PREHOOK: type: REVOKE_PRIVILEGE
-POSTHOOK: query: revoke `select` on table authorization_part from user hive_test_user
+POSTHOOK: query: revoke select on table authorization_part from user hive_test_user
POSTHOOK: type: REVOKE_PRIVILEGE
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -592,9 +592,9 @@ POSTHOOK: Lineage: authorization_part PA
18
18
19
-PREHOOK: query: revoke `select` on table authorization_part partition (ds='2010') from user hive_test_user
+PREHOOK: query: revoke select on table authorization_part partition (ds='2010') from user hive_test_user
PREHOOK: type: REVOKE_PRIVILEGE
-POSTHOOK: query: revoke `select` on table authorization_part partition (ds='2010') from user hive_test_user
+POSTHOOK: query: revoke select on table authorization_part partition (ds='2010') from user hive_test_user
POSTHOOK: type: REVOKE_PRIVILEGE
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -678,9 +678,9 @@ POSTHOOK: Lineage: authorization_part PA
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: grant `select`(key) on table authorization_part to group hive_test_group1
+PREHOOK: query: grant select(key) on table authorization_part to group hive_test_group1
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `select`(key) on table authorization_part to group hive_test_group1
+POSTHOOK: query: grant select(key) on table authorization_part to group hive_test_group1
POSTHOOK: type: GRANT_PRIVILEGE
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -785,9 +785,9 @@ POSTHOOK: Lineage: authorization_part PA
18
18
19
-PREHOOK: query: revoke `select`(key) on table authorization_part from group hive_test_group1
+PREHOOK: query: revoke select(key) on table authorization_part from group hive_test_group1
PREHOOK: type: REVOKE_PRIVILEGE
-POSTHOOK: query: revoke `select`(key) on table authorization_part from group hive_test_group1
+POSTHOOK: query: revoke select(key) on table authorization_part from group hive_test_group1
POSTHOOK: type: REVOKE_PRIVILEGE
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -859,9 +859,9 @@ POSTHOOK: Lineage: authorization_part PA
18
18
19
-PREHOOK: query: revoke `select`(key) on table authorization_part partition (ds='2010') from group hive_test_group1
+PREHOOK: query: revoke select(key) on table authorization_part partition (ds='2010') from group hive_test_group1
PREHOOK: type: REVOKE_PRIVILEGE
-POSTHOOK: query: revoke `select`(key) on table authorization_part partition (ds='2010') from group hive_test_group1
+POSTHOOK: query: revoke select(key) on table authorization_part partition (ds='2010') from group hive_test_group1
POSTHOOK: type: REVOKE_PRIVILEGE
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -928,9 +928,9 @@ POSTHOOK: Lineage: authorization_part PA
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: grant `select` on table authorization_part to group hive_test_group1
+PREHOOK: query: grant select on table authorization_part to group hive_test_group1
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `select` on table authorization_part to group hive_test_group1
+POSTHOOK: query: grant select on table authorization_part to group hive_test_group1
POSTHOOK: type: GRANT_PRIVILEGE
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -1045,9 +1045,9 @@ POSTHOOK: Lineage: authorization_part PA
18
18
19
-PREHOOK: query: revoke `select` on table authorization_part from group hive_test_group1
+PREHOOK: query: revoke select on table authorization_part from group hive_test_group1
PREHOOK: type: REVOKE_PRIVILEGE
-POSTHOOK: query: revoke `select` on table authorization_part from group hive_test_group1
+POSTHOOK: query: revoke select on table authorization_part from group hive_test_group1
POSTHOOK: type: REVOKE_PRIVILEGE
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -1126,9 +1126,9 @@ POSTHOOK: Lineage: authorization_part PA
18
18
19
-PREHOOK: query: revoke `select` on table authorization_part partition (ds='2010') from group hive_test_group1
+PREHOOK: query: revoke select on table authorization_part partition (ds='2010') from group hive_test_group1
PREHOOK: type: REVOKE_PRIVILEGE
-POSTHOOK: query: revoke `select` on table authorization_part partition (ds='2010') from group hive_test_group1
+POSTHOOK: query: revoke select on table authorization_part partition (ds='2010') from group hive_test_group1
POSTHOOK: type: REVOKE_PRIVILEGE
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -1150,9 +1150,9 @@ POSTHOOK: Lineage: authorization_part PA
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: revoke `select` on table src from user hive_test_user
+PREHOOK: query: revoke select on table src from user hive_test_user
PREHOOK: type: REVOKE_PRIVILEGE
-POSTHOOK: query: revoke `select` on table src from user hive_test_user
+POSTHOOK: query: revoke select on table src from user hive_test_user
POSTHOOK: type: REVOKE_PRIVILEGE
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_3.q.out?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_3.q.out Thu Feb 17 07:44:49 2011
@@ -5,13 +5,13 @@ POSTHOOK: query: create table src_autho_
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
POSTHOOK: Output: default@src_autho_test
-PREHOOK: query: grant `drop` on table src_autho_test to user hive_test_user
+PREHOOK: query: grant drop on table src_autho_test to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `drop` on table src_autho_test to user hive_test_user
+POSTHOOK: query: grant drop on table src_autho_test to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
-PREHOOK: query: grant `select` on table src_autho_test to user hive_test_user
+PREHOOK: query: grant select on table src_autho_test to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `select` on table src_autho_test to user hive_test_user
+POSTHOOK: query: grant select on table src_autho_test to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: show grant user hive_test_user on table src_autho_test
PREHOOK: type: SHOW_GRANT
@@ -33,17 +33,17 @@ principalType USER
privilege Select
grantTime 1296259321
grantor hive_test_user
-PREHOOK: query: revoke `select` on table src_autho_test from user hive_test_user
+PREHOOK: query: revoke select on table src_autho_test from user hive_test_user
PREHOOK: type: REVOKE_PRIVILEGE
-POSTHOOK: query: revoke `select` on table src_autho_test from user hive_test_user
+POSTHOOK: query: revoke select on table src_autho_test from user hive_test_user
POSTHOOK: type: REVOKE_PRIVILEGE
-PREHOOK: query: revoke `drop` on table src_autho_test from user hive_test_user
+PREHOOK: query: revoke drop on table src_autho_test from user hive_test_user
PREHOOK: type: REVOKE_PRIVILEGE
-POSTHOOK: query: revoke `drop` on table src_autho_test from user hive_test_user
+POSTHOOK: query: revoke drop on table src_autho_test from user hive_test_user
POSTHOOK: type: REVOKE_PRIVILEGE
-PREHOOK: query: grant `drop`,`select` on table src_autho_test to user hive_test_user
+PREHOOK: query: grant drop,select on table src_autho_test to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `drop`,`select` on table src_autho_test to user hive_test_user
+POSTHOOK: query: grant drop,select on table src_autho_test to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: show grant user hive_test_user on table src_autho_test
PREHOOK: type: SHOW_GRANT
@@ -65,19 +65,19 @@ principalType USER
privilege Select
grantTime 1296259321
grantor hive_test_user
-PREHOOK: query: revoke `drop`,`select` on table src_autho_test from user hive_test_user
+PREHOOK: query: revoke drop,select on table src_autho_test from user hive_test_user
PREHOOK: type: REVOKE_PRIVILEGE
-POSTHOOK: query: revoke `drop`,`select` on table src_autho_test from user hive_test_user
+POSTHOOK: query: revoke drop,select on table src_autho_test from user hive_test_user
POSTHOOK: type: REVOKE_PRIVILEGE
-PREHOOK: query: grant `drop`,`select`(key), `select`(value) on table src to user hive_test_user
+PREHOOK: query: grant drop,select(key), select(value) on table src to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `drop`,`select`(key), `select`(value) on table src to user hive_test_user
+POSTHOOK: query: grant drop,select(key), select(value) on table src to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: show grant user hive_test_user on table src_autho_test
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant user hive_test_user on table src_autho_test
POSTHOOK: type: SHOW_GRANT
-PREHOOK: query: revoke `drop`,`select`(key), `select`(value) on table src from user hive_test_user
+PREHOOK: query: revoke drop,select(key), select(value) on table src from user hive_test_user
PREHOOK: type: REVOKE_PRIVILEGE
-POSTHOOK: query: revoke `drop`,`select`(key), `select`(value) on table src from user hive_test_user
+POSTHOOK: query: revoke drop,select(key), select(value) on table src from user hive_test_user
POSTHOOK: type: REVOKE_PRIVILEGE
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_4.q.out?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_4.q.out Thu Feb 17 07:44:49 2011
@@ -5,9 +5,9 @@ POSTHOOK: query: create table src_autho_
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
POSTHOOK: Output: default@src_autho_test
-PREHOOK: query: grant `All` on table src_autho_test to user hive_test_user
+PREHOOK: query: grant All on table src_autho_test to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `All` on table src_autho_test to user hive_test_user
+POSTHOOK: query: grant All on table src_autho_test to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: show grant user hive_test_user on table src_autho_test
PREHOOK: type: SHOW_GRANT
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_5.q.out?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_5.q.out Thu Feb 17 07:44:49 2011
@@ -8,13 +8,13 @@ POSTHOOK: query: SHOW DATABASES
POSTHOOK: type: SHOWDATABASES
default
test_db
-PREHOOK: query: GRANT `drop` ON DATABASE test_db TO USER hive_test_user
+PREHOOK: query: GRANT drop ON DATABASE test_db TO USER hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: GRANT `drop` ON DATABASE test_db TO USER hive_test_user
+POSTHOOK: query: GRANT drop ON DATABASE test_db TO USER hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
-PREHOOK: query: GRANT `select` ON DATABASE test_db TO USER hive_test_user
+PREHOOK: query: GRANT select ON DATABASE test_db TO USER hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: GRANT `select` ON DATABASE test_db TO USER hive_test_user
+POSTHOOK: query: GRANT select ON DATABASE test_db TO USER hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: SHOW GRANT USER hive_test_user ON DATABASE test_db
PREHOOK: type: SHOW_GRANT
@@ -48,13 +48,13 @@ POSTHOOK: query: SHOW ROLE GRANT USER hi
POSTHOOK: type: SHOW_ROLE_GRANT
role name:db_test_role
role name:db_test_role
-PREHOOK: query: GRANT `drop` ON DATABASE test_db TO ROLE db_test_role
+PREHOOK: query: GRANT drop ON DATABASE test_db TO ROLE db_test_role
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: GRANT `drop` ON DATABASE test_db TO ROLE db_test_role
+POSTHOOK: query: GRANT drop ON DATABASE test_db TO ROLE db_test_role
POSTHOOK: type: GRANT_PRIVILEGE
-PREHOOK: query: GRANT `select` ON DATABASE test_db TO ROLE db_test_role
+PREHOOK: query: GRANT select ON DATABASE test_db TO ROLE db_test_role
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: GRANT `select` ON DATABASE test_db TO ROLE db_test_role
+POSTHOOK: query: GRANT select ON DATABASE test_db TO ROLE db_test_role
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: SHOW GRANT ROLE db_test_role ON DATABASE test_db
PREHOOK: type: SHOW_GRANT
Modified: hive/trunk/ql/src/test/results/clientpositive/keyword_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/keyword_1.q.out?rev=1071529&r1=1071528&r2=1071529&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/keyword_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/keyword_1.q.out Thu Feb 17 07:44:49 2011
@@ -3,9 +3,9 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table test_user (user string, `group` string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@test_user
-PREHOOK: query: grant `select` on table test_user to user hive_test
+PREHOOK: query: grant select on table test_user to user hive_test
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `select` on table test_user to user hive_test
+POSTHOOK: query: grant select on table test_user to user hive_test
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: explain select user from test_user
PREHOOK: type: QUERY
@@ -67,9 +67,9 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table test_user (role string, `group` string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@test_user
-PREHOOK: query: grant `select` on table test_user to user hive_test
+PREHOOK: query: grant select on table test_user to user hive_test
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant `select` on table test_user to user hive_test
+POSTHOOK: query: grant select on table test_user to user hive_test
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: explain select role from test_user
PREHOOK: type: QUERY