Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

error when connecting to hive via jdbc

Highlighted

error when connecting to hive via jdbc

New Contributor

Hi,

I am new in Hortonworks HDP Sandbox, I am trying to connect to sandbox Hive via the jdbc driver, this is my code:


private static String driverName = "org.apache.hadoop.hive.jdbc.HiveDriver";   
 public static void main(String[] args) throws SQLException {
        try {
            Class.forName(driverName);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
            System.out.println(e.getMessage());
        }
        Connection con = DriverManager.getConnection(
            "jdbc:hive2://sandbox-hdp.hortonworks.com:2181/default;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2");
    

I am using the hive url given by ambari, however, I got this error:

Exception in thread "main" java.sql.SQLException: Invalid URL: jdbc:hive2://sandbox-hdp.hortonworks.com:2181/default;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2
    at org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:86)
    at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:106)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at Hive2.main(Hive2.java:21)

please if anyone know how to solve this issue let me know, I have trying since long time