Premchandra Preetham Kukillaya created SPARK-8659:
-----------------------------------------------------
Summary: SQL Standard Based Hive Authorisation of Hive.13 does not
work while pointing JDBC Application to Spark Thrift Server.
Key: SPARK-8659
URL: https://issues.apache.org/jira/browse/SPARK-8659
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 1.3.1
Environment: Linux
Reporter: Premchandra Preetham Kukillaya
It seems like while pointing JDBC/ODBC Driver to Spark SQL Thrift Service
Hive's feature SQL based authorization is not working whereas SQL based
Authorization works when i am pointing the JDBC Driver to ThriftCLIService
provided by HiveServer2.
The problem is user X can do select on table belonging to user Y.
I am using Hive .13.1 and Spark 1.3.1
./start-thriftserver.sh --hiveconf hive.server2.thrift.port=10001 --hiveconf
xxxxhostname.compute.amazonaws.com --hiveconf
hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateUserAuthenticator
--hiveconf
hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactory
--hiveconf hive.server2.enable.doAs=false --hiveconf
hive.security.authorization.enabled=true --hiveconf mapred.reduce.tasks=-1
--hiveconf mapred.max.split.size=256000000 --hiveconf
hive.downloaded.resources.dir=/mnt/var/lib/hive/downloaded_resources --hiveconf
javax.jdo.option.ConnectionURL=jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true
--hiveconf javax.jdo.option.ConnectionDriverName=com.mysql.jdbc.Driver
--hiveconf javax.jdo.option.ConnectionUserName=hive --hiveconf
javax.jdo.option.ConnectionPassword=hive --hiveconf
hive.metastore.warehouse.dir=/user/hive/warehouse --hiveconf
hive.metastore.connect.retries=5 --hiveconf datanucleus.fixedDatastore=true
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
