首先要启动hiveserver
执行命令 nohup hive --service hiveserver &
jdbc访问hive与访问普通关系型数据库的流程基本一致
代码如下:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class DBConn {
private String driver="org.apache.hadoop.hive.jdbc.HiveDriver";
private String user="";
private String pass="";
private String url="jdbc:hive://hiveserver:10000";
// nohup hive --service hiveserver &
// nohup hive --service hiveserver -p 10001 &
public static void main(String[] args) {
try {
new DBConn().test();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void test() throws Exception{
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, user, pass);
Statement stat = conn.createStatement();
ResultSet rs=stat.