Hive connection?

Hi,

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
at java.lang.Class.newInstance(Class.java:427)
at com.intellij.database.remote.RemoteJdbcServer.main(RemoteJdbcServer.java:14)
Caused by: java.lang.NoSuchMethodException: java.sql.Driver.<init>()
at java.lang.Class.getConstructor0(Class.java:3082)
at java.lang.Class.newInstance(Class.java:412)
... 1 more.

Hello Dar,

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:

• HortonWorks: http://repo.hortonworks.com/content/repositories/releases/org/apache/hive/hive-jdbc/
• Cloudera: http://www.cloudera.com/downloads/connectors/hive/jdbc/2-5-4.html

@Thanu76 
Could you please e-mail full IDE log to vasily.chernov@jetbrains.com ?

Also, can you specify jdbc driver you use for connection and screenshots of your data source and driver settings?