1。首先要启动hive的服务器:
hive --service hiveserver &
hive默认的端口为:10000
2.程序源代码为:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class HiveTest {
public static void main(String[] args) throws Exception {
Class.forName("org.apache.hadoop.hive.jdbc.HiveDriver");
Connection conn = DriverManager.getConnection("jdbc:hive://hadoop0:10000/default","","");
Statement stmt = conn.createStatement();
String querySql = "select * from stu";
ResultSet rs = stmt.executeQuery(querySql);
while(rs.next()) {
System.out.println(rs.getInt(1));
}
rs.close();
stmt.close();
conn.close();
}
}