做项目中需要连接第三方公司的hive数据库,由于我们是在内网做的项目,没有使用maven来进行项目管理,jar包需要一个一个的导入,看了网上博友们给的例子都很简单,可是自己亲子实战后,各种报找不到类的异常。只能根据缺少的jar包一个一个的去网上下载,一个一个的解决。费心呢!现在就给大家分享下用到的jar包java连接hive需要的所有jar包,我也把代码发一下吧!
import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class HiveUtil {public static void main(String[] args) {String connectionURL = "jdbc:hive2://5.2.25.25:10000/hai";String drivername = "org.apache.hive.jdbc.HiveDriver";String username = "";String password = "";try {Class.forName(drivername);} catch (ClassNotFoundException e) {e.printStackTrace();System.exit(1);}try {Connection con = DriverManager.getConnection(connectionURL, username, password);if (con != null) {System.out.println("Connected");} else {System.out.println("Not Connected");}Statement stmt = con.createStatement();String sql;ResultSet res;sql = "select * from v_zdry_idx_jxxx limit 10";System.out.println("Running: " + sql);res = stmt.executeQuery(sql);while (res.next()) {System.out.println(String.valueOf(res.getString(1)) + "t" + res.getString(2));}} catch (SQLException se) {se.printStackTrace();}}}