blob: 22b66d12c9885b3a28f089f995164876a226d9e9 [file] [log] [blame]
PREHOOK: query: -- create a table owned by user1
create table exchange_partition_test_1(a int) partitioned by (b int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@exchange_partition_test_1
POSTHOOK: query: -- create a table owned by user1
create table exchange_partition_test_1(a int) partitioned by (b int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@exchange_partition_test_1
PREHOOK: query: show grant user user1 on table exchange_partition_test_1
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant user user1 on table exchange_partition_test_1
POSTHOOK: type: SHOW_GRANT
default exchange_partition_test_1 user1 USER DELETE true -1 user1
default exchange_partition_test_1 user1 USER INSERT true -1 user1
default exchange_partition_test_1 user1 USER SELECT true -1 user1
default exchange_partition_test_1 user1 USER UPDATE true -1 user1
PREHOOK: query: set role admin
PREHOOK: type: SHOW_ROLES
POSTHOOK: query: set role admin
POSTHOOK: type: SHOW_ROLES
PREHOOK: query: -- add data to exchange_partition_test_1
insert overwrite table exchange_partition_test_1 partition (b=1) select key from src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@exchange_partition_test_1@b=1
POSTHOOK: query: -- add data to exchange_partition_test_1
insert overwrite table exchange_partition_test_1 partition (b=1) select key from src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@exchange_partition_test_1@b=1
POSTHOOK: Lineage: exchange_partition_test_1 PARTITION(b=1).a EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: -- grant select, delete privileges to user2 on exchange_partition_test_1
grant select, delete on exchange_partition_test_1 to user user2
PREHOOK: type: GRANT_PRIVILEGE
PREHOOK: Output: default@exchange_partition_test_1
POSTHOOK: query: -- grant select, delete privileges to user2 on exchange_partition_test_1
grant select, delete on exchange_partition_test_1 to user user2
POSTHOOK: type: GRANT_PRIVILEGE
POSTHOOK: Output: default@exchange_partition_test_1
PREHOOK: query: set role all
PREHOOK: type: SHOW_ROLES
POSTHOOK: query: set role all
POSTHOOK: type: SHOW_ROLES
PREHOOK: query: show grant user user2 on table exchange_partition_test_1
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant user user2 on table exchange_partition_test_1
POSTHOOK: type: SHOW_GRANT
default exchange_partition_test_1 user2 USER DELETE false -1 hive_admin_user
default exchange_partition_test_1 user2 USER SELECT false -1 hive_admin_user
PREHOOK: query: -- switch user
-- create a table owned by user2 (as a result user2 will have insert privilege)
create table exchange_partition_test_2(a int) partitioned by (b int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@exchange_partition_test_2
POSTHOOK: query: -- switch user
-- create a table owned by user2 (as a result user2 will have insert privilege)
create table exchange_partition_test_2(a int) partitioned by (b int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@exchange_partition_test_2
PREHOOK: query: show grant user user2 on table exchange_partition_test_2
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant user user2 on table exchange_partition_test_2
POSTHOOK: type: SHOW_GRANT
default exchange_partition_test_2 user2 USER DELETE true -1 user1
default exchange_partition_test_2 user2 USER INSERT true -1 user1
default exchange_partition_test_2 user2 USER SELECT true -1 user1
default exchange_partition_test_2 user2 USER UPDATE true -1 user1
PREHOOK: query: -- execute alter table exchange partition to add data to exchange_partition_test_2
explain authorization alter table exchange_partition_test_2 exchange partition (b=1) with table exchange_partition_test_1
PREHOOK: type: ALTERTABLE_EXCHANGEPARTITION
POSTHOOK: query: -- execute alter table exchange partition to add data to exchange_partition_test_2
explain authorization alter table exchange_partition_test_2 exchange partition (b=1) with table exchange_partition_test_1
POSTHOOK: type: ALTERTABLE_EXCHANGEPARTITION
INPUTS:
default@exchange_partition_test_1
OUTPUTS:
default@exchange_partition_test_2
CURRENT_USER:
user2
OPERATION:
ALTERTABLE_EXCHANGEPARTITION
PREHOOK: query: alter table exchange_partition_test_2 exchange partition (b=1) with table exchange_partition_test_1
PREHOOK: type: ALTERTABLE_EXCHANGEPARTITION
PREHOOK: Input: default@exchange_partition_test_1
PREHOOK: Output: default@exchange_partition_test_2
POSTHOOK: query: alter table exchange_partition_test_2 exchange partition (b=1) with table exchange_partition_test_1
POSTHOOK: type: ALTERTABLE_EXCHANGEPARTITION
POSTHOOK: Input: default@exchange_partition_test_1
POSTHOOK: Input: default@exchange_partition_test_1@b=1
POSTHOOK: Output: default@exchange_partition_test_1@b=1
POSTHOOK: Output: default@exchange_partition_test_2
POSTHOOK: Output: default@exchange_partition_test_2@b=1