hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From pa...@apache.org
Subject 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/
Date Fri, 25 Feb 2011 00:24:18 GMT
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



Mime
View raw message