如何用jdbc连接hive

首先要启动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.