-
Notifications
You must be signed in to change notification settings - Fork 63
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
RHive kerberos issue on CDH #94
Comments
Hi @bayroot22, i think in two options: 1.- See if you has a Kerberos ticket created with 'klist' (In Shell, not in R), if not, create one with 'kinit' command. 2.- See if HiveServer2 has the correct configuration with the RHive UDF File included, i only has this info for do that: In hive-site.xml add this property and restart HiveServer2:
If you use Cloudera CDH they has one tutorial for include UDF files to be use by HiveServer http://www.cloudera.com/content/www/en-us/documentation/enterprise/latest/topics/cm_mc_hive_udf.html Good luck |
thanks for the response...
|
I added the following property hive.keytab=/home/bayroot/hive.keytab to the connection string now I get the following: Exception in thread "Thread-6" java.lang.RuntimeException: java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://hive.server.com:10001/default: Peer indicated failure: Unsupported mechanism type PLAIN A couple thoughts/questions? 1 - I manage a multi-tenant environment so exposing the hive keytab is a serious security concern so even if this worked it wouldn't be a solution I could implement... |
As I have understood if you created the ticket in R you not should put the flags username and password, there may come the message of 'plaintext password' when trying to use these parameters to log, If you have a Kerberos ticket created in the R environment R is responsible for trying to use it automatically, creating the connection / set necessary, soo should use only:
It is also true that with this format i can't connect, I used the following format for the connection (Example):
|
Hi Team, could you please confirm Rhive supports kerberos or not.,if its support pls tell the me the correct format for rhive.connect. |
any ideas? |
I am using the following version of Hive 1.1.0-cdh5.4.3 with R 3.2.2. My typical jdbc string would look something like below if I were connecting via SQL Squirrel for instance:
jdbc:hive2://hive.server.com:10000/default;AuthMech=1;principal=hive/[email protected]
See the following error after the connect, note I have a valid credential prior to invoking R repl:
Please note this code was working fine in CDH 5.3.2 which was hive .13 I believe:
Package: RHive
Type: Package
Title: R and Hive
Version: 2.0-1.0
The text was updated successfully, but these errors were encountered: