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!
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.
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:
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?