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

["Anne Yu (JIRA)" <ji...@apache.org>]

Anne Yu created SENTRY-679:
------------------------------

             Summary: Sentry support for Hive 0.14 Insert into table table_name values (...)
                 Key: SENTRY-679
                 URL: https://issues.apache.org/jira/browse/SENTRY-679
             Project: Sentry
          Issue Type: New Feature
    Affects Versions: 1.5.0
            Reporter: Anne Yu
            Assignee: Prasad Mujumdar
             Fix For: 1.5.0


{code}
++ sudo -u hive beeline --color --silent=true -u 'jdbc:hive2://anneyu-sentry-ha-10-4.ent.cloudera.com:10000/default;principal=hive/anneyu-sentry-ha-10-4.ent.cloudera.com@ENT.CLOUDERA.COM' -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/anneyu-sentry-ha-10-4.ent.cloudera.com@ENT.CLOUDERA.COM' -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/anneyu-sentry-ha-10-4.ent.cloudera.com@ENT.CLOUDERA.COM' -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/anneyu-sentry-ha-10-4.ent.cloudera.com@ENT.CLOUDERA.COM' -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/anneyu-sentry-ha-10-4.ent.cloudera.com@ENT.CLOUDERA.COM' -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/anneyu-sentry-ha-10-4.ent.cloudera.com@ENT.CLOUDERA.COM' -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/anneyu-sentry-ha-10-4.ent.cloudera.com@ENT.CLOUDERA.COM' -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)
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)