You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by pa...@apache.org on 2011/02/25 01:24:18 UTC
svn commit: r1074361 [1/3] - in /hive/trunk/ql/src:
java/org/apache/hadoop/hive/ql/parse/ test/queries/clientnegative/
test/queries/clientpositive/ test/results/clientnegative/
test/results/clientpositive/
Author: pauly
Date: Fri Feb 25 00:24:18 2011
New Revision: 1074361
URL: http://svn.apache.org/viewvc?rev=1074361&view=rev
Log:
HIVE-2001 Add inputs and outputs to authorization DDL commands (He Yongqiang)
by pauly
Modified:
hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java
hive/trunk/ql/src/test/queries/clientnegative/authorization_part.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/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
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=1074361&r1=1074360&r2=1074361&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 Fri Feb 25 00:24:18 2011
@@ -428,7 +428,7 @@ public class DDLSemanticAnalyzer extends
if (astChild.getType() == HiveParser.TOK_GRANT_WITH_OPTION) {
grantOption = true;
} else if (astChild.getType() == HiveParser.TOK_PRIV_OBJECT) {
- privilegeObj = analyzePrivilegeObject(astChild);
+ privilegeObj = analyzePrivilegeObject(astChild, getOutputs());
}
}
}
@@ -453,7 +453,7 @@ public class DDLSemanticAnalyzer extends
PrivilegeObjectDesc hiveObj = null;
if (ast.getChildCount() > 2) {
ASTNode astChild = (ASTNode) ast.getChild(2);
- hiveObj = analyzePrivilegeObject(astChild);
+ hiveObj = analyzePrivilegeObject(astChild, getOutputs());
}
RevokeDesc revokeDesc = new RevokeDesc(privilegeDesc, principalDesc, hiveObj);
@@ -462,7 +462,8 @@ public class DDLSemanticAnalyzer extends
}
- private PrivilegeObjectDesc analyzePrivilegeObject(ASTNode ast)
+ private PrivilegeObjectDesc analyzePrivilegeObject(ASTNode ast,
+ HashSet<WriteEntity> outputs)
throws SemanticException {
PrivilegeObjectDesc subject = new PrivilegeObjectDesc();
subject.setObject(unescapeIdentifier(ast.getChild(0).getText()));
@@ -476,6 +477,21 @@ public class DDLSemanticAnalyzer extends
}
}
}
+
+ try {
+ if (subject.getTable()) {
+ Table tbl = db.getTable(subject.getObject());
+ if (subject.getPartSpec() != null) {
+ Partition part = db.getPartition(tbl, subject.getPartSpec(), false);
+ outputs.add(new WriteEntity(part));
+ } else {
+ outputs.add(new WriteEntity(tbl));
+ }
+ }
+ } catch (HiveException e) {
+ throw new SemanticException(e);
+ }
+
return subject;
}
@@ -513,7 +529,7 @@ public class DDLSemanticAnalyzer extends
Privilege privObj = PrivilegeRegistry.getPrivilege(privilegeType.getType());
if (privObj == null) {
- throw new SemanticException("undefined privilege " + privObj.toString());
+ throw new SemanticException("undefined privilege " + privilegeType.getType());
}
List<String> cols = null;
if (privilegeDef.getChildCount() > 1) {
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=1074361&r1=1074360&r2=1074361&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/authorization_part.q (original)
+++ hive/trunk/ql/src/test/queries/clientnegative/authorization_part.q Fri Feb 25 00:24:18 2011
@@ -1,11 +1,12 @@
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 to user hive_test_user;
+grant select on table src_auth to user hive_test_user;
-- column grant to group
@@ -14,12 +15,12 @@ grant select on table authorization_part
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;
+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;
+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;
@@ -30,4 +31,5 @@ revoke select on table authorization_par
select key,value, ds from authorization_part_fail where ds>='2010' order by key, ds limit 20;
-drop table authorization_part_fail;
\ No newline at end of file
+drop table authorization_part_fail;
+drop table src_auth;
\ No newline at end of file
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=1074361&r1=1074360&r2=1074361&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/authorization_2.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/authorization_2.q Fri Feb 25 00:24:18 2011
@@ -1,5 +1,5 @@
create table authorization_part (key int, value string) partitioned by (ds string);
-
+create table src_auth_tmp as select * from src;
ALTER TABLE authorization_part SET TBLPROPERTIES ("PARTITION_LEVEL_PRIVILEGE"="TRUE");
set hive.security.authorization.enabled=true;
@@ -7,7 +7,7 @@ set hive.security.authorization.enabled=
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 select on table src_auth_tmp to user hive_test_user;
show grant user hive_test_user on table authorization_part;
@@ -16,7 +16,7 @@ show grant user hive_test_user on table
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;
+insert overwrite table authorization_part partition (ds='2010') select key, value from src_auth_tmp;
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;
@@ -40,7 +40,7 @@ show grant user hive_test_user on table
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;
+insert overwrite table authorization_part partition (ds='2010') select key, value from src_auth_tmp;
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;
@@ -65,7 +65,7 @@ show grant group hive_test_group1 on tab
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;
+insert overwrite table authorization_part partition (ds='2010') select key, value from src_auth_tmp;
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;
@@ -89,7 +89,7 @@ show grant group hive_test_group1 on tab
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;
+insert overwrite table authorization_part partition (ds='2010') select key, value from src_auth_tmp;
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;
@@ -104,6 +104,6 @@ revoke select on table authorization_par
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_auth_tmp 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=1074361&r1=1074360&r2=1074361&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/authorization_3.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/authorization_3.q Fri Feb 25 00:24:18 2011
@@ -12,6 +12,6 @@ grant drop,select on table src_autho_tes
show grant user hive_test_user on table src_autho_test;
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_autho_test 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;
+revoke drop,select(key), select(value) on table src_autho_test from user hive_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=1074361&r1=1074360&r2=1074361&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 Fri Feb 25 00:24:18 2011
@@ -5,9 +5,12 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@authorization_fail_1
PREHOOK: query: grant Create on table authorization_fail_1 to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: default@authorization_fail_1
POSTHOOK: query: grant Create on table authorization_fail_1 to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: default@authorization_fail_1
PREHOOK: query: grant Create on table authorization_fail_1 to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: default@authorization_fail_1
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=1074361&r1=1074360&r2=1074361&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 Fri Feb 25 00:24:18 2011
@@ -5,8 +5,10 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@authorization_fail_3
PREHOOK: query: grant Create on table authorization_fail_3 to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: default@authorization_fail_3
POSTHOOK: query: grant Create on table authorization_fail_3 to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: default@authorization_fail_3
PREHOOK: query: alter table authorization_fail_3 add partition (ds='2010')
PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: default@authorization_fail_3
@@ -24,7 +26,7 @@ table authorization_fail_3
principalName hive_test_user
principalType USER
privilege Create
-grantTime 1296259808
+grantTime 1298430475
grantor hive_test_user
PREHOOK: query: show grant user hive_test_user on table authorization_fail_3 partition (ds='2010')
PREHOOK: type: SHOW_GRANT
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=1074361&r1=1074360&r2=1074361&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 Fri Feb 25 00:24:18 2011
@@ -5,8 +5,10 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@authorization_fail_4
PREHOOK: query: grant Alter on table authorization_fail_4 to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: default@authorization_fail_4
POSTHOOK: query: grant Alter on table authorization_fail_4 to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: default@authorization_fail_4
PREHOOK: query: ALTER TABLE authorization_fail_4 SET TBLPROPERTIES ("PARTITION_LEVEL_PRIVILEGE"="TRUE")
PREHOOK: type: ALTERTABLE_PROPERTIES
PREHOOK: Input: default@authorization_fail_4
@@ -17,8 +19,10 @@ POSTHOOK: Input: default@authorization_f
POSTHOOK: Output: default@authorization_fail_4
PREHOOK: query: grant Create on table authorization_fail_4 to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: default@authorization_fail_4
POSTHOOK: query: grant Create on table authorization_fail_4 to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: default@authorization_fail_4
PREHOOK: query: alter table authorization_fail_4 add partition (ds='2010')
PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: default@authorization_fail_4
@@ -36,7 +40,7 @@ table authorization_fail_4
principalName hive_test_user
principalType USER
privilege Alter
-grantTime 1296259809
+grantTime 1298430477
grantor hive_test_user
database default
@@ -44,7 +48,7 @@ table authorization_fail_4
principalName hive_test_user
principalType USER
privilege Create
-grantTime 1296259810
+grantTime 1298430477
grantor hive_test_user
PREHOOK: query: show grant user hive_test_user on table authorization_fail_4 partition (ds='2010')
PREHOOK: type: SHOW_GRANT
@@ -57,7 +61,7 @@ partition ds=2010
principalName hive_test_user
principalType USER
privilege Alter
-grantTime 1296259810
+grantTime 1298430477
grantor hive_test_user
database default
@@ -66,6 +70,6 @@ partition ds=2010
principalName hive_test_user
principalType USER
privilege Create
-grantTime 1296259810
+grantTime 1298430477
grantor hive_test_user
Authorization failed:No privilege 'Select' found for inputs { database:default, table:authorization_fail_4, partitionName:ds=2010, columnName:key}. Use show grant to get more details.
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=1074361&r1=1074360&r2=1074361&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 Fri Feb 25 00:24:18 2011
@@ -5,8 +5,10 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@authorization_fail
PREHOOK: query: grant Alter on table authorization_fail to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: default@authorization_fail
POSTHOOK: query: grant Alter on table authorization_fail to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: default@authorization_fail
PREHOOK: query: ALTER TABLE authorization_fail SET TBLPROPERTIES ("PARTITION_LEVEL_PRIVILEGE"="TRUE")
PREHOOK: type: ALTERTABLE_PROPERTIES
PREHOOK: Input: default@authorization_fail
@@ -17,12 +19,16 @@ POSTHOOK: Input: default@authorization_f
POSTHOOK: Output: default@authorization_fail
PREHOOK: query: grant Create on table authorization_fail to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: default@authorization_fail
POSTHOOK: query: grant Create on table authorization_fail to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: default@authorization_fail
PREHOOK: query: grant Select on table authorization_fail to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: default@authorization_fail
POSTHOOK: query: grant Select on table authorization_fail to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: default@authorization_fail
PREHOOK: query: alter table authorization_fail add partition (ds='2010')
PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: default@authorization_fail
@@ -40,7 +46,7 @@ table authorization_fail
principalName hive_test_user
principalType USER
privilege Alter
-grantTime 1296259811
+grantTime 1298430478
grantor hive_test_user
database default
@@ -48,7 +54,7 @@ table authorization_fail
principalName hive_test_user
principalType USER
privilege Create
-grantTime 1296259811
+grantTime 1298430478
grantor hive_test_user
database default
@@ -56,7 +62,7 @@ table authorization_fail
principalName hive_test_user
principalType USER
privilege Select
-grantTime 1296259811
+grantTime 1298430478
grantor hive_test_user
PREHOOK: query: show grant user hive_test_user on table authorization_fail partition (ds='2010')
PREHOOK: type: SHOW_GRANT
@@ -69,7 +75,7 @@ partition ds=2010
principalName hive_test_user
principalType USER
privilege Alter
-grantTime 1296259811
+grantTime 1298430478
grantor hive_test_user
database default
@@ -78,7 +84,7 @@ partition ds=2010
principalName hive_test_user
principalType USER
privilege Create
-grantTime 1296259811
+grantTime 1298430478
grantor hive_test_user
database default
@@ -87,12 +93,14 @@ partition ds=2010
principalName hive_test_user
principalType USER
privilege Select
-grantTime 1296259811
+grantTime 1298430478
grantor hive_test_user
PREHOOK: query: revoke Select on table authorization_fail partition (ds='2010') from user hive_test_user
PREHOOK: type: REVOKE_PRIVILEGE
+PREHOOK: Output: default@authorization_fail@ds=2010
POSTHOOK: query: revoke Select on table authorization_fail partition (ds='2010') from user hive_test_user
POSTHOOK: type: REVOKE_PRIVILEGE
+POSTHOOK: Output: default@authorization_fail@ds=2010
PREHOOK: query: show grant user hive_test_user on table authorization_fail partition (ds='2010')
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant user hive_test_user on table authorization_fail partition (ds='2010')
@@ -104,7 +112,7 @@ partition ds=2010
principalName hive_test_user
principalType USER
privilege Alter
-grantTime 1296259811
+grantTime 1298430478
grantor hive_test_user
database default
@@ -113,6 +121,6 @@ partition ds=2010
principalName hive_test_user
principalType USER
privilege Create
-grantTime 1296259811
+grantTime 1298430478
grantor hive_test_user
Authorization failed:No privilege 'Select' found for inputs { database:default, table:authorization_fail, partitionName:ds=2010, columnName:key}. Use show grant to get more details.
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=1074361&r1=1074360&r2=1074361&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 Fri Feb 25 00:24:18 2011
@@ -13,8 +13,10 @@ POSTHOOK: query: grant role hive_test_ro
POSTHOOK: type: GRANT_ROLE
PREHOOK: query: grant select on table authorization_fail to role hive_test_role_fail
PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: default@authorization_fail
POSTHOOK: query: grant select on table authorization_fail to role hive_test_role_fail
POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: default@authorization_fail
PREHOOK: query: show role grant user hive_test_user
PREHOOK: type: SHOW_ROLE_GRANT
POSTHOOK: query: show role grant user hive_test_user
@@ -31,7 +33,7 @@ table authorization_fail
principalName hive_test_role_fail
principalType ROLE
privilege Select
-grantTime 1296259812
+grantTime 1298430480
grantor hive_test_user
PREHOOK: query: drop role hive_test_role_fail
PREHOOK: type: DROPROLE
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=1074361&r1=1074360&r2=1074361&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 Fri Feb 25 00:24:18 2011
@@ -11,34 +11,53 @@ POSTHOOK: query: ALTER TABLE authorizati
POSTHOOK: type: ALTERTABLE_PROPERTIES
POSTHOOK: Input: default@authorization_part_fail
POSTHOOK: Output: default@authorization_part_fail
+PREHOOK: query: create table src_auth as select * from src
+PREHOOK: type: CREATETABLE_AS_SELECT
+PREHOOK: Input: default@src
+POSTHOOK: query: create table src_auth as select * from src
+POSTHOOK: type: CREATETABLE_AS_SELECT
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@src_auth
PREHOOK: query: grant Create on table authorization_part_fail to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: default@authorization_part_fail
POSTHOOK: query: grant Create on table authorization_part_fail to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: default@authorization_part_fail
PREHOOK: query: grant Update on table authorization_part_fail to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: default@authorization_part_fail
POSTHOOK: query: grant Update on table authorization_part_fail to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: default@authorization_part_fail
PREHOOK: query: grant Drop on table authorization_part_fail to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: default@authorization_part_fail
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
+POSTHOOK: Output: default@authorization_part_fail
+PREHOOK: query: grant select on table src_auth to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
-POSTHOOK: query: grant select on table src to user hive_test_user
+PREHOOK: Output: default@src_auth
+POSTHOOK: query: grant select on table src_auth to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: default@src_auth
PREHOOK: query: -- column grant to group
grant select(key) on table authorization_part_fail to group hive_test_group1
PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: default@authorization_part_fail
POSTHOOK: query: -- column grant to group
grant select(key) on table authorization_part_fail to group hive_test_group1
POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: default@authorization_part_fail
PREHOOK: query: grant select on table authorization_part_fail to group hive_test_group1
PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: default@authorization_part_fail
POSTHOOK: query: grant select on table authorization_part_fail to group hive_test_group1
POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: default@authorization_part_fail
PREHOOK: query: show grant group hive_test_group1 on table authorization_part_fail
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant group hive_test_group1 on table authorization_part_fail
@@ -49,24 +68,24 @@ table authorization_part_fail
principalName hive_test_group1
principalType GROUP
privilege Select
-grantTime 1296259813
+grantTime 1298431059
grantor hive_test_user
-PREHOOK: query: insert overwrite table authorization_part_fail partition (ds='2010') select key, value from src
+PREHOOK: query: insert overwrite table authorization_part_fail partition (ds='2010') select key, value from src_auth
PREHOOK: type: QUERY
-PREHOOK: Input: default@src
+PREHOOK: Input: default@src_auth
PREHOOK: Output: default@authorization_part_fail@ds=2010
-POSTHOOK: query: insert overwrite table authorization_part_fail partition (ds='2010') select key, value from src
+POSTHOOK: query: insert overwrite table authorization_part_fail partition (ds='2010') select key, value from src_auth
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
+POSTHOOK: Input: default@src_auth
POSTHOOK: Output: default@authorization_part_fail@ds=2010
-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), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2010).key EXPRESSION [(src_auth)src_auth.FieldSchema(name:key, type:string, comment:null), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2010).value SIMPLE [(src_auth)src_auth.FieldSchema(name:value, type:string, comment:null), ]
PREHOOK: query: show grant group hive_test_group1 on table authorization_part_fail(key) partition (ds='2010')
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant group hive_test_group1 on table authorization_part_fail(key) partition (ds='2010')
POSTHOOK: type: SHOW_GRANT
-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), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2010).key EXPRESSION [(src_auth)src_auth.FieldSchema(name:key, type:string, comment:null), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2010).value SIMPLE [(src_auth)src_auth.FieldSchema(name:value, type:string, comment:null), ]
database default
table authorization_part_fail
@@ -75,14 +94,14 @@ columnName key
principalName hive_test_group1
principalType GROUP
privilege Select
-grantTime 1296259822
+grantTime 1298431068
grantor hive_test_user
PREHOOK: query: show grant group hive_test_group1 on table authorization_part_fail partition (ds='2010')
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant group hive_test_group1 on table authorization_part_fail partition (ds='2010')
POSTHOOK: type: SHOW_GRANT
-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), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2010).key EXPRESSION [(src_auth)src_auth.FieldSchema(name:key, type:string, comment:null), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2010).value SIMPLE [(src_auth)src_auth.FieldSchema(name:value, type:string, comment:null), ]
database default
table authorization_part_fail
@@ -90,18 +109,18 @@ partition ds=2010
principalName hive_test_group1
principalType GROUP
privilege Select
-grantTime 1296259822
+grantTime 1298431068
grantor hive_test_user
PREHOOK: query: select key, value from authorization_part_fail where ds='2010' order by key limit 20
PREHOOK: type: QUERY
PREHOOK: Input: default@authorization_part_fail@ds=2010
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-01-28_16-10-22_949_2212884189255830110/-mr-10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-02-22_19-17-49_290_3714806944623689015/-mr-10000
POSTHOOK: query: select key, value from authorization_part_fail where ds='2010' order by key limit 20
POSTHOOK: type: QUERY
POSTHOOK: Input: default@authorization_part_fail@ds=2010
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-01-28_16-10-22_949_2212884189255830110/-mr-10000
-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), ]
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-02-22_19-17-49_290_3714806944623689015/-mr-10000
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2010).key EXPRESSION [(src_auth)src_auth.FieldSchema(name:key, type:string, comment:null), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2010).value SIMPLE [(src_auth)src_auth.FieldSchema(name:value, type:string, comment:null), ]
0 val_0
0 val_0
0 val_0
@@ -122,26 +141,26 @@ POSTHOOK: Lineage: authorization_part_fa
18 val_18
18 val_18
19 val_19
-PREHOOK: query: insert overwrite table authorization_part_fail partition (ds='2011') select key, value from src
+PREHOOK: query: insert overwrite table authorization_part_fail partition (ds='2011') select key, value from src_auth
PREHOOK: type: QUERY
-PREHOOK: Input: default@src
+PREHOOK: Input: default@src_auth
PREHOOK: Output: default@authorization_part_fail@ds=2011
-POSTHOOK: query: insert overwrite table authorization_part_fail partition (ds='2011') select key, value from src
+POSTHOOK: query: insert overwrite table authorization_part_fail partition (ds='2011') select key, value from src_auth
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
+POSTHOOK: Input: default@src_auth
POSTHOOK: Output: default@authorization_part_fail@ds=2011
-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), ]
-POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2011).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2011).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2010).key EXPRESSION [(src_auth)src_auth.FieldSchema(name:key, type:string, comment:null), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2010).value SIMPLE [(src_auth)src_auth.FieldSchema(name:value, type:string, comment:null), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2011).key EXPRESSION [(src_auth)src_auth.FieldSchema(name:key, type:string, comment:null), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2011).value SIMPLE [(src_auth)src_auth.FieldSchema(name:value, type:string, comment:null), ]
PREHOOK: query: show grant group hive_test_group1 on table authorization_part_fail(key) partition (ds='2011')
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant group hive_test_group1 on table authorization_part_fail(key) partition (ds='2011')
POSTHOOK: type: SHOW_GRANT
-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), ]
-POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2011).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2011).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2010).key EXPRESSION [(src_auth)src_auth.FieldSchema(name:key, type:string, comment:null), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2010).value SIMPLE [(src_auth)src_auth.FieldSchema(name:value, type:string, comment:null), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2011).key EXPRESSION [(src_auth)src_auth.FieldSchema(name:key, type:string, comment:null), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2011).value SIMPLE [(src_auth)src_auth.FieldSchema(name:value, type:string, comment:null), ]
database default
table authorization_part_fail
@@ -150,16 +169,16 @@ columnName key
principalName hive_test_group1
principalType GROUP
privilege Select
-grantTime 1296259838
+grantTime 1298431084
grantor hive_test_user
PREHOOK: query: show grant group hive_test_group1 on table authorization_part_fail partition (ds='2011')
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant group hive_test_group1 on table authorization_part_fail partition (ds='2011')
POSTHOOK: type: SHOW_GRANT
-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), ]
-POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2011).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2011).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2010).key EXPRESSION [(src_auth)src_auth.FieldSchema(name:key, type:string, comment:null), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2010).value SIMPLE [(src_auth)src_auth.FieldSchema(name:value, type:string, comment:null), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2011).key EXPRESSION [(src_auth)src_auth.FieldSchema(name:key, type:string, comment:null), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2011).value SIMPLE [(src_auth)src_auth.FieldSchema(name:value, type:string, comment:null), ]
database default
table authorization_part_fail
@@ -167,20 +186,20 @@ partition ds=2011
principalName hive_test_group1
principalType GROUP
privilege Select
-grantTime 1296259838
+grantTime 1298431084
grantor hive_test_user
PREHOOK: query: select key, value from authorization_part_fail where ds='2011' order by key limit 20
PREHOOK: type: QUERY
PREHOOK: Input: default@authorization_part_fail@ds=2011
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-01-28_16-10-38_699_6026645486493533704/-mr-10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-02-22_19-18-05_062_5324729077581832101/-mr-10000
POSTHOOK: query: select key, value from authorization_part_fail where ds='2011' order by key limit 20
POSTHOOK: type: QUERY
POSTHOOK: Input: default@authorization_part_fail@ds=2011
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-01-28_16-10-38_699_6026645486493533704/-mr-10000
-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), ]
-POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2011).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2011).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-02-22_19-18-05_062_5324729077581832101/-mr-10000
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2010).key EXPRESSION [(src_auth)src_auth.FieldSchema(name:key, type:string, comment:null), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2010).value SIMPLE [(src_auth)src_auth.FieldSchema(name:value, type:string, comment:null), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2011).key EXPRESSION [(src_auth)src_auth.FieldSchema(name:key, type:string, comment:null), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2011).value SIMPLE [(src_auth)src_auth.FieldSchema(name:value, type:string, comment:null), ]
0 val_0
0 val_0
0 val_0
@@ -205,16 +224,16 @@ PREHOOK: query: select key,value, ds fro
PREHOOK: type: QUERY
PREHOOK: Input: default@authorization_part_fail@ds=2010
PREHOOK: Input: default@authorization_part_fail@ds=2011
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-01-28_16-10-45_161_786348139842725610/-mr-10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-02-22_19-18-12_026_4943385475572886900/-mr-10000
POSTHOOK: query: select key,value, ds from authorization_part_fail where ds>='2010' order by key, ds limit 20
POSTHOOK: type: QUERY
POSTHOOK: Input: default@authorization_part_fail@ds=2010
POSTHOOK: Input: default@authorization_part_fail@ds=2011
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-01-28_16-10-45_161_786348139842725610/-mr-10000
-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), ]
-POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2011).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2011).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-02-22_19-18-12_026_4943385475572886900/-mr-10000
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2010).key EXPRESSION [(src_auth)src_auth.FieldSchema(name:key, type:string, comment:null), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2010).value SIMPLE [(src_auth)src_auth.FieldSchema(name:value, type:string, comment:null), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2011).key EXPRESSION [(src_auth)src_auth.FieldSchema(name:key, type:string, comment:null), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2011).value SIMPLE [(src_auth)src_auth.FieldSchema(name:value, type:string, comment:null), ]
0 val_0 2010
0 val_0 2010
0 val_0 2010
@@ -237,10 +256,12 @@ POSTHOOK: Lineage: authorization_part_fa
9 val_9 2011
PREHOOK: query: revoke select on table authorization_part_fail partition (ds='2010') from group hive_test_group1
PREHOOK: type: REVOKE_PRIVILEGE
+PREHOOK: Output: default@authorization_part_fail@ds=2010
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), ]
-POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2011).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2011).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Output: default@authorization_part_fail@ds=2010
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2010).key EXPRESSION [(src_auth)src_auth.FieldSchema(name:key, type:string, comment:null), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2010).value SIMPLE [(src_auth)src_auth.FieldSchema(name:value, type:string, comment:null), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2011).key EXPRESSION [(src_auth)src_auth.FieldSchema(name:key, type:string, comment:null), ]
+POSTHOOK: Lineage: authorization_part_fail PARTITION(ds=2011).value SIMPLE [(src_auth)src_auth.FieldSchema(name:value, type:string, comment:null), ]
Authorization failed:No privilege 'Select' found for inputs { database:default, table:authorization_part_fail, partitionName:ds=2010, columnName:value}. Use show grant to get more details.
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=1074361&r1=1074360&r2=1074361&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 Fri Feb 25 00:24:18 2011
@@ -9,10 +9,12 @@ PREHOOK: query: --table grant to user
grant select on table src_autho_test to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: default@src_autho_test
POSTHOOK: query: --table grant to user
grant select on table src_autho_test to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: default@src_autho_test
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
@@ -23,7 +25,7 @@ table src_autho_test
principalName hive_test_user
principalType USER
privilege Select
-grantTime 1296259172
+grantTime 1298420358
grantor hive_test_user
PREHOOK: query: show grant user hive_test_user on table src_autho_test(key)
PREHOOK: type: SHOW_GRANT
@@ -32,11 +34,11 @@ POSTHOOK: type: SHOW_GRANT
PREHOOK: query: select key from src_autho_test order by key limit 20
PREHOOK: type: QUERY
PREHOOK: Input: default@src_autho_test
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-01-28_15-59-33_264_8834761941134366874/-mr-10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-02-22_16-19-19_140_1092784940021767167/-mr-10000
POSTHOOK: query: select key from src_autho_test order by key limit 20
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_autho_test
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-01-28_15-59-33_264_8834761941134366874/-mr-10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-02-22_16-19-19_140_1092784940021767167/-mr-10000
0
0
0
@@ -59,8 +61,10 @@ POSTHOOK: Output: file:/var/folders/6g/6
119
PREHOOK: query: revoke select on table src_autho_test from user hive_test_user
PREHOOK: type: REVOKE_PRIVILEGE
+PREHOOK: Output: default@src_autho_test
POSTHOOK: query: revoke select on table src_autho_test from user hive_test_user
POSTHOOK: type: REVOKE_PRIVILEGE
+POSTHOOK: Output: default@src_autho_test
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
@@ -73,10 +77,12 @@ PREHOOK: query: --column grant to user
grant select(key) on table src_autho_test to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: default@src_autho_test
POSTHOOK: query: --column grant to user
grant select(key) on table src_autho_test to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: default@src_autho_test
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
@@ -92,16 +98,16 @@ columnName key
principalName hive_test_user
principalType USER
privilege Select
-grantTime 1296259180
+grantTime 1298420368
grantor hive_test_user
PREHOOK: query: select key from src_autho_test order by key limit 20
PREHOOK: type: QUERY
PREHOOK: Input: default@src_autho_test
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-01-28_15-59-40_968_7073262457974858333/-mr-10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-02-22_16-19-28_915_5983909727594214023/-mr-10000
POSTHOOK: query: select key from src_autho_test order by key limit 20
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_autho_test
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-01-28_15-59-40_968_7073262457974858333/-mr-10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-02-22_16-19-28_915_5983909727594214023/-mr-10000
0
0
0
@@ -124,8 +130,10 @@ POSTHOOK: Output: file:/var/folders/6g/6
119
PREHOOK: query: revoke select(key) on table src_autho_test from user hive_test_user
PREHOOK: type: REVOKE_PRIVILEGE
+PREHOOK: Output: default@src_autho_test
POSTHOOK: query: revoke select(key) on table src_autho_test from user hive_test_user
POSTHOOK: type: REVOKE_PRIVILEGE
+POSTHOOK: Output: default@src_autho_test
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
@@ -138,10 +146,12 @@ PREHOOK: query: --table grant to group
grant select on table src_autho_test to group hive_test_group1
PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: default@src_autho_test
POSTHOOK: query: --table grant to group
grant select on table src_autho_test to group hive_test_group1
POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: default@src_autho_test
PREHOOK: query: show grant group hive_test_group1 on table src_autho_test
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant group hive_test_group1 on table src_autho_test
@@ -152,7 +162,7 @@ table src_autho_test
principalName hive_test_group1
principalType GROUP
privilege Select
-grantTime 1296259187
+grantTime 1298420376
grantor hive_test_user
PREHOOK: query: show grant group hive_test_group1 on table src_autho_test(key)
PREHOOK: type: SHOW_GRANT
@@ -161,11 +171,11 @@ POSTHOOK: type: SHOW_GRANT
PREHOOK: query: select key from src_autho_test order by key limit 20
PREHOOK: type: QUERY
PREHOOK: Input: default@src_autho_test
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-01-28_15-59-47_794_8573266154905521425/-mr-10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-02-22_16-19-37_107_8315738520621308755/-mr-10000
POSTHOOK: query: select key from src_autho_test order by key limit 20
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_autho_test
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-01-28_15-59-47_794_8573266154905521425/-mr-10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-02-22_16-19-37_107_8315738520621308755/-mr-10000
0
0
0
@@ -188,8 +198,10 @@ POSTHOOK: Output: file:/var/folders/6g/6
119
PREHOOK: query: revoke select on table src_autho_test from group hive_test_group1
PREHOOK: type: REVOKE_PRIVILEGE
+PREHOOK: Output: default@src_autho_test
POSTHOOK: query: revoke select on table src_autho_test from group hive_test_group1
POSTHOOK: type: REVOKE_PRIVILEGE
+POSTHOOK: Output: default@src_autho_test
PREHOOK: query: show grant group hive_test_group1 on table src_autho_test
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant group hive_test_group1 on table src_autho_test
@@ -202,10 +214,12 @@ PREHOOK: query: --column grant to group
grant select(key) on table src_autho_test to group hive_test_group1
PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: default@src_autho_test
POSTHOOK: query: --column grant to group
grant select(key) on table src_autho_test to group hive_test_group1
POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: default@src_autho_test
PREHOOK: query: show grant group hive_test_group1 on table src_autho_test
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant group hive_test_group1 on table src_autho_test
@@ -221,16 +235,16 @@ columnName key
principalName hive_test_group1
principalType GROUP
privilege Select
-grantTime 1296259194
+grantTime 1298420384
grantor hive_test_user
PREHOOK: query: select key from src_autho_test order by key limit 20
PREHOOK: type: QUERY
PREHOOK: Input: default@src_autho_test
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-01-28_15-59-54_784_7241258065625779986/-mr-10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-02-22_16-19-44_873_1380430443686566573/-mr-10000
POSTHOOK: query: select key from src_autho_test order by key limit 20
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_autho_test
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-01-28_15-59-54_784_7241258065625779986/-mr-10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-02-22_16-19-44_873_1380430443686566573/-mr-10000
0
0
0
@@ -253,8 +267,10 @@ POSTHOOK: Output: file:/var/folders/6g/6
119
PREHOOK: query: revoke select(key) on table src_autho_test from group hive_test_group1
PREHOOK: type: REVOKE_PRIVILEGE
+PREHOOK: Output: default@src_autho_test
POSTHOOK: query: revoke select(key) on table src_autho_test from group hive_test_group1
POSTHOOK: type: REVOKE_PRIVILEGE
+POSTHOOK: Output: default@src_autho_test
PREHOOK: query: show grant group hive_test_group1 on table src_autho_test
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant group hive_test_group1 on table src_autho_test
@@ -283,10 +299,12 @@ PREHOOK: query: --column grant to role
grant select(key) on table src_autho_test to role src_role
PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: default@src_autho_test
POSTHOOK: query: --column grant to role
grant select(key) on table src_autho_test to role src_role
POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: default@src_autho_test
PREHOOK: query: show grant role src_role on table src_autho_test
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant role src_role on table src_autho_test
@@ -302,16 +320,16 @@ columnName key
principalName src_role
principalType ROLE
privilege Select
-grantTime 1296259201
+grantTime 1298420392
grantor hive_test_user
PREHOOK: query: select key from src_autho_test order by key limit 20
PREHOOK: type: QUERY
PREHOOK: Input: default@src_autho_test
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-01-28_16-00-01_462_3130685448172300807/-mr-10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-02-22_16-19-52_300_4610085368597981247/-mr-10000
POSTHOOK: query: select key from src_autho_test order by key limit 20
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_autho_test
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-01-28_16-00-01_462_3130685448172300807/-mr-10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-02-22_16-19-52_300_4610085368597981247/-mr-10000
0
0
0
@@ -334,24 +352,28 @@ POSTHOOK: Output: file:/var/folders/6g/6
119
PREHOOK: query: revoke select(key) on table src_autho_test from role src_role
PREHOOK: type: REVOKE_PRIVILEGE
+PREHOOK: Output: default@src_autho_test
POSTHOOK: query: revoke select(key) on table src_autho_test from role src_role
POSTHOOK: type: REVOKE_PRIVILEGE
+POSTHOOK: Output: default@src_autho_test
PREHOOK: query: --table grant to role
grant select on table src_autho_test to role src_role
PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: default@src_autho_test
POSTHOOK: query: --table grant to role
grant select on table src_autho_test to role src_role
POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: default@src_autho_test
PREHOOK: query: select key from src_autho_test order by key limit 20
PREHOOK: type: QUERY
PREHOOK: Input: default@src_autho_test
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-01-28_16-00-08_098_7774521136560080938/-mr-10000
+PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-02-22_16-19-59_202_5938148548979249829/-mr-10000
POSTHOOK: query: select key from src_autho_test order by key limit 20
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_autho_test
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-01-28_16-00-08_098_7774521136560080938/-mr-10000
+POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-02-22_16-19-59_202_5938148548979249829/-mr-10000
0
0
0
@@ -382,7 +404,7 @@ table src_autho_test
principalName src_role
principalType ROLE
privilege Select
-grantTime 1296259208
+grantTime 1298420399
grantor hive_test_user
PREHOOK: query: show grant role src_role on table src_autho_test(key)
PREHOOK: type: SHOW_GRANT
@@ -390,8 +412,10 @@ POSTHOOK: query: show grant role src_rol
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: revoke select on table src_autho_test from role src_role
PREHOOK: type: REVOKE_PRIVILEGE
+PREHOOK: Output: default@src_autho_test
POSTHOOK: query: revoke select on table src_autho_test from role src_role
POSTHOOK: type: REVOKE_PRIVILEGE
+POSTHOOK: Output: default@src_autho_test
PREHOOK: query: -- drop role
drop role src_role
PREHOOK: type: DROPROLE