PREHOOK: query: create table authorization_part_fail (key int, value string) partitioned by (ds string) PREHOOK: type: CREATETABLE POSTHOOK: query: create table authorization_part_fail (key int, value string) partitioned by (ds string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@authorization_part_fail PREHOOK: query: ALTER TABLE authorization_part_fail SET TBLPROPERTIES ("PARTITION_LEVEL_PRIVILEGE"="TRUE") PREHOOK: type: ALTERTABLE_PROPERTIES PREHOOK: Input: default@authorization_part_fail PREHOOK: Output: default@authorization_part_fail POSTHOOK: query: ALTER TABLE authorization_part_fail SET TBLPROPERTIES ("PARTITION_LEVEL_PRIVILEGE"="TRUE") 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 POSTHOOK: Output: default@authorization_part_fail PREHOOK: query: grant select on table src_auth to user hive_test_user PREHOOK: type: GRANT_PRIVILEGE 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 POSTHOOK: type: SHOW_GRANT database default table authorization_part_fail principalName hive_test_group1 principalType GROUP privilege Select #### A masked pattern was here #### grantor hive_test_user PREHOOK: query: insert overwrite table authorization_part_fail partition (ds='2010') select key, value from src_auth PREHOOK: type: QUERY 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_auth POSTHOOK: type: QUERY POSTHOOK: Input: default@src_auth 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), ] 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_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 partition ds=2010 columnName key principalName hive_test_group1 principalType GROUP privilege Select #### A masked pattern was here #### 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_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 partition ds=2010 principalName hive_test_group1 principalType GROUP privilege Select #### A masked pattern was here #### 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 #### A masked pattern was here #### 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 #### A masked pattern was here #### 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 2 val_2 4 val_4 5 val_5 5 val_5 5 val_5 8 val_8 9 val_9 10 val_10 11 val_11 12 val_12 12 val_12 15 val_15 15 val_15 17 val_17 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_auth PREHOOK: type: QUERY 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_auth POSTHOOK: type: QUERY POSTHOOK: Input: default@src_auth POSTHOOK: Output: default@authorization_part_fail@ds=2011 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_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 partition ds=2011 columnName key principalName hive_test_group1 principalType GROUP privilege Select #### A masked pattern was here #### 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_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 partition ds=2011 principalName hive_test_group1 principalType GROUP privilege Select #### A masked pattern was here #### 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 #### A masked pattern was here #### 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 #### A masked pattern was here #### 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 2 val_2 4 val_4 5 val_5 5 val_5 5 val_5 8 val_8 9 val_9 10 val_10 11 val_11 12 val_12 12 val_12 15 val_15 15 val_15 17 val_17 18 val_18 18 val_18 19 val_19 PREHOOK: query: select key,value, ds from authorization_part_fail where ds>='2010' order by key, ds limit 20 PREHOOK: type: QUERY PREHOOK: Input: default@authorization_part_fail@ds=2010 PREHOOK: Input: default@authorization_part_fail@ds=2011 #### A masked pattern was here #### 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 #### A masked pattern was here #### 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 0 val_0 2011 0 val_0 2011 0 val_0 2011 2 val_2 2010 2 val_2 2011 4 val_4 2010 4 val_4 2011 5 val_5 2010 5 val_5 2010 5 val_5 2010 5 val_5 2011 5 val_5 2011 5 val_5 2011 8 val_8 2010 8 val_8 2011 9 val_9 2010 9 val_9 2011 PREHOOK: query: revoke select on table authorization_part_fail partition (ds='2010') from group hive_test_group1 PREHOOK: 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: 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.