天天看点

java JDBC hiveREF:https://www.cnblogs.com/liupuLearning/p/6347539.htmljava.sql.SQLException: No suitable driver found for jdbc:hive://localhost:10000/default

REF:https://www.cnblogs.com/liupuLearning/p/6347539.html

java.sql.SQLException: No suitable driver found for jdbc:hive://localhost:10000/default

error:

java.sql.SQLException: No suitable driver found for jdbc:hive://localhost:10000/default
    at java.sql.DriverManager.getConnection(DriverManager.java:596)
    at java.sql.DriverManager.getConnection(DriverManager.java:233)
    at demo.utils.JDBCUtils.getConnection(JDBCUtils.java:25)
    at demo.hive.HiveJDBCDemo.main(HiveJDBCDemo.java:16)
Exception in thread "main" java.lang.NullPointerException
    at demo.hive.HiveJDBCDemo.main(HiveJDBCDemo.java:18)      

resolve:

url->change hive to hive2

before: 

private static String driverString = "org.apache.hive.jdbc.HiveDriver";
private static String urlString = "jdbc:hive://localhost:10000/default";      

after:

private static String driverString = "org.apache.hive.jdbc.HiveDriver";
private static String urlString = "jdbc:hive2://localhost:10000/default";