1。首先要启动hive的服务器:
--
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()
}
}