[SENTRY-679] Sentry support for Hive 0.14 Insert into table table_name values (...)

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 1.5.0
• Assignee: Prasad Suresh Mujumdar
• Reporter: Anne Yu
• Created: 24/Mar/15 19:05
• Updated: 13/Sep/18 18:15
• Resolved: 13/Sep/18 18:15

Description

++ sudo -u hive beeline --color --silent=true -u 'jdbc:hive2://anneyu-sentry-ha-10-4.ent.cloudera.com:10000/default;principal=hive/[e-mail]' -n hive -p hive -e 'drop role insert_table'
++ sudo -u hive beeline --color --silent=true -u 'jdbc:hive2://anneyu-sentry-ha-10-4.ent.cloudera.com:10000/default;principal=hive/[e-mail]' -n hive -p hive -e 'CREATE ROLE insert_table'
++ sudo -u hive beeline --color --silent=true -u 'jdbc:hive2://anneyu-sentry-ha-10-4.ent.cloudera.com:10000/default;principal=hive/[e-mail]' -n hive -p hive -e 'GRANT INSERT ON TABLE test2 to ROLE insert_table'
++ sudo -u hive beeline --color --silent=true -u 'jdbc:hive2://anneyu-sentry-ha-10-4.ent.cloudera.com:10000/default;principal=hive/[e-mail]' -n hive -p hive -e 'GRANT ROLE insert_table TO GROUP hive'
++ sudo -u hive beeline --color --silent=true -u 'jdbc:hive2://anneyu-sentry-ha-10-4.ent.cloudera.com:10000/default;principal=hive/[e-mail]' -n hive -p hive -e 'GRANT SELECT ON TABLE t1 to role insert_table'
++ sudo -u hive beeline --color --silent=true -u 'jdbc:hive2://anneyu-sentry-ha-10-4.ent.cloudera.com:10000/default;principal=hive/[e-mail]' -n hive -p hive -e 'SET ROLE insert_table' -e 'insert into table test2 select * from t1'
++ sudo -u hive beeline --color --silent=true -u 'jdbc:hive2://anneyu-sentry-ha-10-4.ent.cloudera.com:10000/default;principal=hive/[e-mail]' -n hive -p hive -e 'SET ROLE insert_table' -e 'insert into table test2 values ('\''test'\'')'
Error: Error while compiling statement: FAILED: SemanticException No valid privileges
 Required privileges for this query: Server=server1->Db=default->Table=values__tmp__table__1->action=select; (state=42000,code=40000)