ql/src/test/results/clientpositive/authorization_1.q.out

PREHOOK: query: create table src_autho_test_n11 as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
PREHOOK: Output: database:default
PREHOOK: Output: default@src_autho_test_n11
POSTHOOK: query: create table src_autho_test_n11 as select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_autho_test_n11
POSTHOOK: Lineage: src_autho_test_n11.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src_autho_test_n11.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: grant select on table src_autho_test_n11 to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
PREHOOK: Output: default@src_autho_test_n11
POSTHOOK: query: grant select on table src_autho_test_n11 to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
POSTHOOK: Output: default@src_autho_test_n11
PREHOOK: query: show grant user hive_test_user on table src_autho_test_n11
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant user hive_test_user on table src_autho_test_n11
POSTHOOK: type: SHOW_GRANT
default	src_autho_test_n11			hive_test_user	USER	SELECT	false	-1	hive_test_user
PREHOOK: query: show grant user hive_test_user on table src_autho_test_n11(key)
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant user hive_test_user on table src_autho_test_n11(key)
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: select key from src_autho_test_n11 order by key limit 20
PREHOOK: type: QUERY
PREHOOK: Input: default@src_autho_test_n11
#### A masked pattern was here ####
POSTHOOK: query: select key from src_autho_test_n11 order by key limit 20
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_autho_test_n11
#### 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_n11 from user hive_test_user
PREHOOK: type: REVOKE_PRIVILEGE
PREHOOK: Output: default@src_autho_test_n11
POSTHOOK: query: revoke select on table src_autho_test_n11 from user hive_test_user
POSTHOOK: type: REVOKE_PRIVILEGE
POSTHOOK: Output: default@src_autho_test_n11
PREHOOK: query: show grant user hive_test_user on table src_autho_test_n11
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant user hive_test_user on table src_autho_test_n11
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: show grant user hive_test_user on table src_autho_test_n11(key)
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant user hive_test_user on table src_autho_test_n11(key)
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: grant select(key) on table src_autho_test_n11 to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
PREHOOK: Output: default@src_autho_test_n11
POSTHOOK: query: grant select(key) on table src_autho_test_n11 to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
POSTHOOK: Output: default@src_autho_test_n11
PREHOOK: query: show grant user hive_test_user on table src_autho_test_n11
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant user hive_test_user on table src_autho_test_n11
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: show grant user hive_test_user on table src_autho_test_n11(key)
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant user hive_test_user on table src_autho_test_n11(key)
POSTHOOK: type: SHOW_GRANT
default	src_autho_test_n11		[key]	hive_test_user	USER	SELECT	false	-1	hive_test_user
PREHOOK: query: select key from src_autho_test_n11 order by key limit 20
PREHOOK: type: QUERY
PREHOOK: Input: default@src_autho_test_n11
#### A masked pattern was here ####
POSTHOOK: query: select key from src_autho_test_n11 order by key limit 20
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_autho_test_n11
#### 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_n11 from user hive_test_user
PREHOOK: type: REVOKE_PRIVILEGE
PREHOOK: Output: default@src_autho_test_n11
POSTHOOK: query: revoke select(key) on table src_autho_test_n11 from user hive_test_user
POSTHOOK: type: REVOKE_PRIVILEGE
POSTHOOK: Output: default@src_autho_test_n11
PREHOOK: query: show grant user hive_test_user on table src_autho_test_n11
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant user hive_test_user on table src_autho_test_n11
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: show grant user hive_test_user on table src_autho_test_n11(key)
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant user hive_test_user on table src_autho_test_n11(key)
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: grant select on table src_autho_test_n11 to group hive_test_group1
PREHOOK: type: GRANT_PRIVILEGE
PREHOOK: Output: default@src_autho_test_n11
POSTHOOK: query: grant select on table src_autho_test_n11 to group hive_test_group1
POSTHOOK: type: GRANT_PRIVILEGE
POSTHOOK: Output: default@src_autho_test_n11
PREHOOK: query: show grant group hive_test_group1 on table src_autho_test_n11
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant group hive_test_group1 on table src_autho_test_n11
POSTHOOK: type: SHOW_GRANT
default	src_autho_test_n11			hive_test_group1	GROUP	SELECT	false	-1	hive_test_user
PREHOOK: query: show grant group hive_test_group1 on table src_autho_test_n11(key)
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant group hive_test_group1 on table src_autho_test_n11(key)
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: select key from src_autho_test_n11 order by key limit 20
PREHOOK: type: QUERY
PREHOOK: Input: default@src_autho_test_n11
#### A masked pattern was here ####
POSTHOOK: query: select key from src_autho_test_n11 order by key limit 20
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_autho_test_n11
#### 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_n11 from group hive_test_group1
PREHOOK: type: REVOKE_PRIVILEGE
PREHOOK: Output: default@src_autho_test_n11
POSTHOOK: query: revoke select on table src_autho_test_n11 from group hive_test_group1
POSTHOOK: type: REVOKE_PRIVILEGE
POSTHOOK: Output: default@src_autho_test_n11
PREHOOK: query: show grant group hive_test_group1 on table src_autho_test_n11
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant group hive_test_group1 on table src_autho_test_n11
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: show grant group hive_test_group1 on table src_autho_test_n11(key)
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant group hive_test_group1 on table src_autho_test_n11(key)
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: grant select(key) on table src_autho_test_n11 to group hive_test_group1
PREHOOK: type: GRANT_PRIVILEGE
PREHOOK: Output: default@src_autho_test_n11
POSTHOOK: query: grant select(key) on table src_autho_test_n11 to group hive_test_group1
POSTHOOK: type: GRANT_PRIVILEGE
POSTHOOK: Output: default@src_autho_test_n11
PREHOOK: query: show grant group hive_test_group1 on table src_autho_test_n11
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant group hive_test_group1 on table src_autho_test_n11
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: show grant group hive_test_group1 on table src_autho_test_n11(key)
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant group hive_test_group1 on table src_autho_test_n11(key)
POSTHOOK: type: SHOW_GRANT
default	src_autho_test_n11		[key]	hive_test_group1	GROUP	SELECT	false	-1	hive_test_user
PREHOOK: query: select key from src_autho_test_n11 order by key limit 20
PREHOOK: type: QUERY
PREHOOK: Input: default@src_autho_test_n11
#### A masked pattern was here ####
POSTHOOK: query: select key from src_autho_test_n11 order by key limit 20
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_autho_test_n11
#### 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_n11 from group hive_test_group1
PREHOOK: type: REVOKE_PRIVILEGE
PREHOOK: Output: default@src_autho_test_n11
POSTHOOK: query: revoke select(key) on table src_autho_test_n11 from group hive_test_group1
POSTHOOK: type: REVOKE_PRIVILEGE
POSTHOOK: Output: default@src_autho_test_n11
PREHOOK: query: show grant group hive_test_group1 on table src_autho_test_n11
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant group hive_test_group1 on table src_autho_test_n11
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: show grant group hive_test_group1 on table src_autho_test_n11(key)
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant group hive_test_group1 on table src_autho_test_n11(key)
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: create role sRc_roLE
PREHOOK: type: CREATEROLE
POSTHOOK: query: 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: grant select(key) on table src_autho_test_n11 to role sRc_roLE
PREHOOK: type: GRANT_PRIVILEGE
PREHOOK: Output: default@src_autho_test_n11
POSTHOOK: query: grant select(key) on table src_autho_test_n11 to role sRc_roLE
POSTHOOK: type: GRANT_PRIVILEGE
POSTHOOK: Output: default@src_autho_test_n11
PREHOOK: query: show grant role sRc_roLE on table src_autho_test_n11
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant role sRc_roLE on table src_autho_test_n11
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: show grant role sRc_roLE on table src_autho_test_n11(key)
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant role sRc_roLE on table src_autho_test_n11(key)
POSTHOOK: type: SHOW_GRANT
default	src_autho_test_n11		[key]	sRc_roLE	ROLE	SELECT	false	-1	hive_test_user
PREHOOK: query: select key from src_autho_test_n11 order by key limit 20
PREHOOK: type: QUERY
PREHOOK: Input: default@src_autho_test_n11
#### A masked pattern was here ####
POSTHOOK: query: select key from src_autho_test_n11 order by key limit 20
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_autho_test_n11
#### 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_n11 from role sRc_roLE
PREHOOK: type: REVOKE_PRIVILEGE
PREHOOK: Output: default@src_autho_test_n11
POSTHOOK: query: revoke select(key) on table src_autho_test_n11 from role sRc_roLE
POSTHOOK: type: REVOKE_PRIVILEGE
POSTHOOK: Output: default@src_autho_test_n11
PREHOOK: query: grant select on table src_autho_test_n11 to role sRc_roLE
PREHOOK: type: GRANT_PRIVILEGE
PREHOOK: Output: default@src_autho_test_n11
POSTHOOK: query: grant select on table src_autho_test_n11 to role sRc_roLE
POSTHOOK: type: GRANT_PRIVILEGE
POSTHOOK: Output: default@src_autho_test_n11
PREHOOK: query: select key from src_autho_test_n11 order by key limit 20
PREHOOK: type: QUERY
PREHOOK: Input: default@src_autho_test_n11
#### A masked pattern was here ####
POSTHOOK: query: select key from src_autho_test_n11 order by key limit 20
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_autho_test_n11
#### 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_n11
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant role sRc_roLE on table src_autho_test_n11
POSTHOOK: type: SHOW_GRANT
default	src_autho_test_n11			sRc_roLE	ROLE	SELECT	false	-1	hive_test_user
PREHOOK: query: show grant role sRc_roLE on table src_autho_test_n11(key)
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant role sRc_roLE on table src_autho_test_n11(key)
POSTHOOK: type: SHOW_GRANT
PREHOOK: query: revoke select on table src_autho_test_n11 from role sRc_roLE
PREHOOK: type: REVOKE_PRIVILEGE
PREHOOK: Output: default@src_autho_test_n11
POSTHOOK: query: revoke select on table src_autho_test_n11 from role sRc_roLE
POSTHOOK: type: REVOKE_PRIVILEGE
POSTHOOK: Output: default@src_autho_test_n11
PREHOOK: query: drop role sRc_roLE
PREHOOK: type: DROPROLE
POSTHOOK: query: drop role sRc_roLE
POSTHOOK: type: DROPROLE
PREHOOK: query: drop table src_autho_test_n11
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@src_autho_test_n11
PREHOOK: Output: default@src_autho_test_n11
POSTHOOK: query: drop table src_autho_test_n11
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@src_autho_test_n11
POSTHOOK: Output: default@src_autho_test_n11