PREHOOK: query: -- SORT_BEFORE_DIFF

create table src_autho_test as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
PREHOOK: Output: database:default
PREHOOK: Output: default@src_autho_test
POSTHOOK: query: -- SORT_BEFORE_DIFF

create table src_autho_test as select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_autho_test
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
POSTHOOK: type: SHOW_GRANT
default	src_autho_test			hive_test_user	USER	SELECT	false	-1	hive_test_user
PREHOOK: query: show grant user hive_test_user on table src_autho_test(key)
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant user hive_test_user on table src_autho_test(key)
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
#### A masked pattern was here ####
POSTHOOK: query: select key from src_autho_test order by key limit 20
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_autho_test
#### A masked pattern was here ####
0
0
0
10
100
100
103
103
104
104
105
11
111
113
113
114
116
118
118
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
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: show grant user hive_test_user on table src_autho_test(key)
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant user hive_test_user on table src_autho_test(key)
POSTHOOK: type: SHOW_GRANT
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
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: show grant user hive_test_user on table src_autho_test(key)
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant user hive_test_user on table src_autho_test(key)
POSTHOOK: type: SHOW_GRANT
default	src_autho_test		[key]	hive_test_user	USER	SELECT	false	-1	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
#### A masked pattern was here ####
POSTHOOK: query: select key from src_autho_test order by key limit 20
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_autho_test
#### A masked pattern was here ####
0
0
0
10
100
100
103
103
104
104
105
11
111
113
113
114
116
118
118
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
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: show grant user hive_test_user on table src_autho_test(key)
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant user hive_test_user on table src_autho_test(key)
POSTHOOK: type: SHOW_GRANT
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
POSTHOOK: type: SHOW_GRANT
default	src_autho_test			hive_test_group1	GROUP	SELECT	false	-1	hive_test_user
PREHOOK: query: show grant group hive_test_group1 on table src_autho_test(key)
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant group hive_test_group1 on table src_autho_test(key)
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
#### A masked pattern was here ####
POSTHOOK: query: select key from src_autho_test order by key limit 20
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_autho_test
#### A masked pattern was here ####
0
0
0
10
100
100
103
103
104
104
105
11
111
113
113
114
116
118
118
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
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: show grant group hive_test_group1 on table src_autho_test(key)
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant group hive_test_group1 on table src_autho_test(key)
POSTHOOK: type: SHOW_GRANT
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
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: show grant group hive_test_group1 on table src_autho_test(key)
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant group hive_test_group1 on table src_autho_test(key)
POSTHOOK: type: SHOW_GRANT
default	src_autho_test		[key]	hive_test_group1	GROUP	SELECT	false	-1	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
#### A masked pattern was here ####
POSTHOOK: query: select key from src_autho_test order by key limit 20
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_autho_test
#### A masked pattern was here ####
0
0
0
10
100
100
103
103
104
104
105
11
111
113
113
114
116
118
118
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
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: show grant group hive_test_group1 on table src_autho_test(key)
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant group hive_test_group1 on table src_autho_test(key)
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: --role
create role sRc_roLE
PREHOOK: type: CREATEROLE
POSTHOOK: query: --role
create role sRc_roLE
POSTHOOK: type: CREATEROLE
PREHOOK: query: grant role sRc_roLE to user hive_test_user
PREHOOK: type: GRANT_ROLE
POSTHOOK: query: grant role sRc_roLE to user hive_test_user
POSTHOOK: type: GRANT_ROLE
PREHOOK: query: show role grant user hive_test_user
PREHOOK: type: SHOW_ROLE_GRANT
POSTHOOK: query: show role grant user hive_test_user
POSTHOOK: type: SHOW_ROLE_GRANT
public	false	-1	
sRc_roLE	false	-1	hive_test_user
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
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: show grant role sRc_roLE on table src_autho_test(key)
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant role sRc_roLE on table src_autho_test(key)
POSTHOOK: type: SHOW_GRANT
default	src_autho_test		[key]	sRc_roLE	ROLE	SELECT	false	-1	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
#### A masked pattern was here ####
POSTHOOK: query: select key from src_autho_test order by key limit 20
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_autho_test
#### A masked pattern was here ####
0
0
0
10
100
100
103
103
104
104
105
11
111
113
113
114
116
118
118
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
#### A masked pattern was here ####
POSTHOOK: query: select key from src_autho_test order by key limit 20
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_autho_test
#### A masked pattern was here ####
0
0
0
10
100
100
103
103
104
104
105
11
111
113
113
114
116
118
118
119
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
POSTHOOK: type: SHOW_GRANT
default	src_autho_test			sRc_roLE	ROLE	SELECT	false	-1	hive_test_user
PREHOOK: query: show grant role sRc_roLE on table src_autho_test(key)
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant role sRc_roLE on table src_autho_test(key)
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: revoke select on table src_autho_test from role sRc_roLE
PREHOOK: 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
POSTHOOK: query: -- drop role
drop role sRc_roLE
POSTHOOK: type: DROPROLE
PREHOOK: query: drop table src_autho_test
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@src_autho_test
PREHOOK: Output: default@src_autho_test
POSTHOOK: query: drop table src_autho_test
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@src_autho_test
POSTHOOK: Output: default@src_autho_test