Hive connection? Follow Answered Dar Malovani Created February 02, 2016 22:27 Is There a way to connect to hive? If so, what is the way do it? Thanks!
With DataGrip you can connect to any database which provides jdbc driver. Based on the user feedback in this issue: https://youtrack.jetbrains.com/issue/IDEA-131179 such driver exists for Hive. You can build it, following the instructions at https://github.com/timveil/hive-jdbc-uber-jar/wiki .
May be there is Hive jdbc driver available for download from the internet somewhere already.
The Hive JDBC driver is available at Maven: http://www.mvnrepository.com/artifact/org.apache.hive/hive-jdbc
Also, Hadoop vendors offers the driver as well:
I'm unable to connect to Hive as i'm getting a java.lang.class error - see below error. Any possible reasons for this?
Exception in thread "main" java.lang.InstantiationException: java.sql.Driver
Caused by: java.lang.NoSuchMethodException: java.sql.Driver.<init>()
... 1 more.
Could you please e-mail full IDE log to firstname.lastname@example.org ?
Also, can you specify jdbc driver you use for connection and screenshots of your data source and driver settings?