Re: SQL Standard Based Hive Authorization with CDH 5.X

2017-05-11 Thread Thejas Nair
You can also set them via hiveserver2-site.xml instead of passing them as commandline params. Let me make that more clear in the doc. On Thu, May 11, 2017 at 9:36 AM, Rob Anderson wrote: > You add the options to HiveServer2 Environment Advanced Configuration >

Re: SQL Standard Based Hive Authorization with CDH 5.X

2017-05-11 Thread Rob Anderson
You add the options to HiveServer2 Environment Advanced Configuration Snippet (Safety Valve) via: HIVE_OPTS=--hiveconf hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactory --hiveconf hive.security.authorization.enabled=true

SQL Standard Based Hive Authorization with CDH 5.X

2017-05-09 Thread Rob Anderson
Has anyone implemented SQL Standard Based Hive Authorization with CDH 5.5.2 (hive1.1.0)? Cloudera has confirmed that it's not supported, but I have a need that requires the implementation. I've followed: https://cwiki.apache.org/confluence/display/Hive/SQL+ Standard+Based+Hive+Authorization