PREHOOK: query: -- current user has been set (comment line before the set cmd is resulting in parse error!!) CREATE TABLE t_auth_up(i int) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@t_auth_up POSTHOOK: query: -- current user has been set (comment line before the set cmd is resulting in parse error!!) CREATE TABLE t_auth_up(i int) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@t_auth_up PREHOOK: query: CREATE TABLE t_select(i int) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@t_select POSTHOOK: query: CREATE TABLE t_select(i int) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@t_select PREHOOK: query: GRANT ALL ON TABLE t_select TO ROLE public PREHOOK: type: GRANT_PRIVILEGE PREHOOK: Output: default@t_select POSTHOOK: query: GRANT ALL ON TABLE t_select TO ROLE public POSTHOOK: type: GRANT_PRIVILEGE POSTHOOK: Output: default@t_select PREHOOK: query: -- grant update privilege to another user GRANT UPDATE ON t_auth_up TO USER userWIns PREHOOK: type: GRANT_PRIVILEGE PREHOOK: Output: default@t_auth_up POSTHOOK: query: -- grant update privilege to another user GRANT UPDATE ON t_auth_up TO USER userWIns POSTHOOK: type: GRANT_PRIVILEGE POSTHOOK: Output: default@t_auth_up PREHOOK: query: GRANT SELECT ON t_auth_up TO USER userWIns PREHOOK: type: GRANT_PRIVILEGE PREHOOK: Output: default@t_auth_up POSTHOOK: query: GRANT SELECT ON t_auth_up TO USER userWIns POSTHOOK: type: GRANT_PRIVILEGE POSTHOOK: Output: default@t_auth_up PREHOOK: query: set role admin PREHOOK: type: SHOW_ROLES POSTHOOK: query: set role admin POSTHOOK: type: SHOW_ROLES PREHOOK: query: SHOW GRANT ON TABLE t_auth_up PREHOOK: type: SHOW_GRANT POSTHOOK: query: SHOW GRANT ON TABLE t_auth_up POSTHOOK: type: SHOW_GRANT default t_auth_up user1 USER DELETE true -1 user1 default t_auth_up user1 USER INSERT true -1 user1 default t_auth_up user1 USER SELECT true -1 user1 default t_auth_up user1 USER UPDATE true -1 user1 default t_auth_up userWIns USER SELECT false -1 user1 default t_auth_up userWIns USER UPDATE false -1 user1 PREHOOK: query: update t_auth_up set i = 0 where i > 0 PREHOOK: type: QUERY PREHOOK: Input: default@t_auth_up PREHOOK: Output: default@t_auth_up POSTHOOK: query: update t_auth_up set i = 0 where i > 0 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_auth_up POSTHOOK: Output: default@t_auth_up