Hive driver class not found

What is your OS and login name?

Have you tried to click on 'Class' drop-down and switch values?

Well right now i am working on a Windows 10.

I explain you what i am trying to do if it is more clear to you.

Right now i am using Pycharm on a remote server via ssh, where i execute .py with PySpark.

This morning looking for costumize my Pycharm IDE i found that there is a possibility to connect with Database and work as a SQL editor.

So i try to connect with Hive similir like i do with Beeline in Putty from the remote server(

beeline -u "jdbc:hive2://hive2A:10000/BBDD;principal=hive/hive2KERBEROS" -n USER -p PASS

)

So the setup I have is the one I have sent in the pictures in the previous message.

I need to install jdbc Hive driver in my own OS or with the tunnel SSH is not necessary?

Thanks for your time

What is your Windows login name? If it contains some non-Unicode characters it may be a problem.

Yes you need JDBC driver in IDE to  connect to database. Let's try to put it into another folder. Download [this one], unzip somewhere in c:\temp, go to Driver in IDE, remove current entry in Dravers file pane with (-) button, then click (+)-> Custom JARs -> select unpacked file and check connection.

Also what is your IDE version?

My windows user is x273062

Thank you very much, that driver seems to work.

But right now i have another error message (TTransportException:Peer indicated failure: Unsupported mechanism type PLAIN.)

Must i indicate Kerberos y the URL Template?

Yes, try to do so please.

I have added the hadoop jars to the driver and i get the next error of Kerberos.

@...

are there any possibility of set up Kerberos from the ssh tunnel instead of getting from my own computer?

I saw the Apache Hive driver VM options and set as follows:

Please send me an email and if its neccesary i will send you my logs.

Thank you very much.

I B Urquijo,

For DataGrip to work properly from your local machine you need:

• Hive JDBC driver (hive-jdbc-***-standalone.jar)

• Additional compatible jar files for hadoop-common-***.jar, hadoop-auth-***.jar, commons-configuration-X.X.jar, xercesImpl-X.X.X.jar, xml-apis-X.X.X.jar

• Working SSH tunnel

• krb5.ini, gss-jaas.conf, *.keytab(for your principal) files

• Run kinit in terminal for desired principal

• In DataGrip set Authentication to No Auth

• In DataGrip on data source's advanced tab set the following VM Options:

                            -Djavax.security.auth.useSubjectCredsOnly=false
                            -Djava.security.krb5.conf=PATH\TO\krb5.ini
                            -Djava.security.auth.login.config=PATH\TO\gss-jaas.conf

• To debug put also the following to VM Options:

                            -Dsun.security.krb5.debug=true
                            -Djava.security.debug=gssloginconfig,configfile,configparser,logincontext

A great step by step set up guide described for another Java based tool

I case you experience any further issues e-mail me directly Vasily.Chernov@jetbrains.com and don't forget to attach debug logs