Java 下Hive编程

首先假定你的Hive已经部署完毕。

导入hive 下所有包

linux 下启动您的Hive:

[root@xxx bin]# hive --service hiveserver 50031
Starting Hive Thrift Server

package hadoop.demo.hive;

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

public class getConnect {
    private static Connection conn = null;
    private static Connection connToMysql = null;

    private getConnect() {
    }

    // 获得hive连接
    public static Connection GetHiveConn() throws SQLException {
        if (conn == null) {
            try {
                Class.forName("org.apache.hadoop.hive.jdbc.HiveDriver");
            } catch (ClassNotFoundException e) {

                e.printStackTrace();
                System.exit(1);
            }
            conn = DriverManager.getConnection(
                    "jdbc:hive://Ip:50031/default", "", "");
        }
        return conn;
    }

    // 获得sql连接
    public static Connection getMySqlConn() throws SQLException {
        if (connToMysql == null) {
            try {
                Class.forName("com.mysql.jdbc.Driver");
            } catch (ClassNotFoundException e) {

                e.printStackTrace();
                System.exit(1);
            }
            connToMysql = DriverManager.getConnection(
                    "jdbc:mysql://ip:3306/hive", "junjun", "123456");
        }
        return connToMysql;
    }

    public static void closeHive() throws SQLException {
        if (conn != null) {
            conn.close();
        }
    }

    public static void closeMysql() throws SQLException {
        if (connToMysql != null) {
            connToMysql.close();
        }
    }
}

package hadoop.demo.hive;

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

/**
 * Hive工具类
 * 
 * @author xiaoyun.zhao
 * 
 */
public class HiveUtil {
    public static void createTable() {
    }

    public static ResultSet queryHive(String hql) throws SQLException {
        Connection conn = getConnect.GetHiveConn();
        Statement stmt = conn.createStatement();
        ResultSet rs = stmt.executeQuery(hql);
        return rs;
    }
}

package hadoop.demo.hive;

import java.sql.ResultSet;

public class HiveMain {

    public static void main(String[] args) throws Exception {

        ResultSet res = HiveUtil.queryHive("select * from pokes");

        while (res.next()) {
            System.out.println("Result: key:" + res.getString(1)
                    + "  –>  value:" + res.getString(1));
        }
    }
}