java jdbc连接hive2

--java 连接hive2

导入jar包（hive和hadoop的）
D:\download\download\apache-hive-1.2.1-bin\apache-hive-1.2.1-bin\lib
D:\download\download\hadoop-2.7.1\share\hadoop\common
D:\download\download\hadoop-2.7.1\share\hadoop\common\lib

本机要配置node1的映射


package com.lhj.hive;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class HiveText {
        public static void main(String[] args) throws Exception {
                Class.forName("org.apache.hive.jdbc.HiveDriver");
                Connection conn=DriverManager.getConnection("jdbc:hive2://node1:10000/default", "root", "");
               
                try {
                        String sql="select count(*) from t_emp";
                        PreparedStatement pstmt=conn.prepareStatement(sql);
                        ResultSet rs=pstmt.executeQuery();
                        while (rs.next()) {
                                System.out.println(rs.getInt(1));
                        }
                } catch (Exception e) {
                        e.printStackTrace();
                } finally{
                        conn.close();
                }
        }
}