Hive jdbc运行方式

1.在服务器端启动hiveserver2，metastore服务所在的服务器

hive --service hiveserver2

2.代码和访问mysql数据库的一样

package com.bjsxt.hive;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class HiveJdbcClient {

	//hive的驱动
	private static String driverName = "org.apache.hive.jdbc.HiveDriver";
	
	public static void main(String[] args) {
		try {
			Class.forName(driverName);
			Connection conn = DriverManager.getConnection("jdbc:hive2://node3:10000/default", "", "");
			
			Statement stmt = conn.createStatement();
			String sql = "select * from student";
			ResultSet rs = stmt.executeQuery(sql);
			
			while(rs.next()) {
				System.out.println(rs.getInt(1) + " : " + rs.getString(2));
			}
			
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}

	}

}