Hadoop学习笔记（十九）---Hive Java Api

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();    }}