7、Hive数据仓库——Hive JDBC

Hive JDBC

启动hiveserver2

这里 & 是设置后台运行

hive --service hiveserver2 &

或者
hiveserver2 &

---

新建maven项目并添加两个依赖

<dependency>
	<groupId>org.apache.hadoop</groupId>
	<artifactId>hadoop-common</artifactId>
	<version>2.7.6</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.hive/hive-jdbc -->
<dependency>
	<groupId>org.apache.hive</groupId>
	<artifactId>hive-jdbc</artifactId>
	<version>1.2.1</version>
</dependency>

---

编写JDBC代码

import java.sql.*;

public class HiveJDBCOp {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        // 1、加载驱动
        Class.forName("org.apache.hive.jdbc.HiveDriver");

        // 2、创建连接
        Connection conn = DriverManager.getConnection("jdbc:hive2://master:10000/test1", "root", "");

        // 3、创建Statement
//        Statement st = conn.createStatement();
        // 4、执行SQL语句 select * from students limit 10
//        ResultSet rs = st.executeQuery("select * from students limit 10");
        // 使用prepareStatement 防止SQL注入的问题
        PreparedStatement pSt = conn.prepareStatement("select * from students where clazz=?");
//         设置参数
        pSt.setString(1, "文科一班");

//        PreparedStatement pSt = conn.prepareStatement("select clazz,count(*) as cnt from students group by clazz");

        ResultSet rs = pSt.executeQuery();

        // 5、遍历ResultSet获取数据
        while (rs.next()) {
            int id = rs.getInt("id");
            String name = rs.getString("name");
            int age = rs.getInt("age");
            String gender = rs.getString("gender");
            String clazz = rs.getString("clazz");

            System.out.println(id + "," + name + "," + age + "," + gender + "," + clazz);
        }

        // 关闭连接
        rs.close();
        pSt.close();
        conn.close();
    }
}

运行结果：
1500100016,潘访烟,23,女,文科一班
1500100037,顾向松,22,女,文科一班
1500100055,卫鸿熙,24,男,文科一班
1500100069,束采波,22,女,文科一班
1500100082,凌思菱,22,女,文科一班
1500100091,蔺水风,22,女,文科一班
1500100094,韩醉柳,22,女,文科一班
1500100101,计又琴,23,女,文科一班
1500100118,蔺昆宇,21,男,文科一班
1500100121,张雪卉,22,女,文科一班
1500100125,蒙涵衍,23,男,文科一班
1500100128,巫鸿哲,24,男,文科一班
1500100142,闵华晖,21,男,文科一班
1500100165,姜昆皓,22,男,文科一班
1500100178,杜芷天,21,女,文科一班
1500100217,弘寄南,21,女,文科一班
1500100232,石寄琴,21,女,文科一班
1500100273,相寒安,22,女,文科一班
1500100276,庾运鹏,24,男,文科一班
1500100308,黄初夏,23,女,文科一班
1500100314,符南莲,24,女,文科一班
1500100315,慕绮彤,23,女,文科一班
1500100333,乐绮烟,22,女,文科一班
1500100338,白之玉,23,女,文科一班
1500100339,终胤运,23,男,文科一班
1500100342,米昊明,21,男,文科一班
1500100370,翟笑天,21,女,文科一班
1500100376,庾胤运,21,男,文科一班
1500100385,潘忆之,23,女,文科一班
1500100407,束昊磊,21,男,文科一班
1500100442,郎泽洋,23,男,文科一班
1500100456,鄂运凯,24,男,文科一班
1500100458,邵凡白,24,女,文科一班
1500100463,苏若芹,22,女,文科一班
1500100478,邰迎荷,22,女,文科一班
1500100509,柏又槐,23,女,文科一班
1500100536,栾昊苍,23,男,文科一班
1500100537,茹高旻,22,男,文科一班
1500100578,殷泽洋,24,男,文科一班
1500100585,穆海超,21,男,文科一班
1500100587,钭恨山,23,女,文科一班
1500100593,景越泽,24,男,文科一班
1500100602,殳昌黎,23,男,文科一班
1500100640,纪昌黎,23,男,文科一班
1500100646,窦海阳,24,男,文科一班
1500100652,农鸿晖,21,男,文科一班
1500100668,侯从寒,23,女,文科一班
1500100685,施昆颉,23,男,文科一班
1500100709,俞昂杰,23,男,文科一班
1500100724,路星腾,21,男,文科一班
1500100744,池若松,22,女,文科一班
1500100763,鄂笑容,21,女,文科一班
1500100766,荀傲薇,23,女,文科一班
1500100770,屠迎梅,23,女,文科一班
1500100778,寇怀寒,24,女,文科一班
1500100779,於安珊,23,女,文科一班
1500100835,柯晨朗,22,男,文科一班
1500100849,寿昊英,22,男,文科一班
1500100863,曹念蕾,22,女,文科一班
1500100867,禹静枫,24,女,文科一班
1500100871,贝惜梦,24,女,文科一班
1500100875,马向南,21,女,文科一班
1500100879,钮怀曼,24,女,文科一班
1500100921,林智阳,21,男,文科一班
1500100928,戚昌盛,22,男,文科一班
1500100943,许昌黎,21,男,文科一班
1500100946,秋海白,23,女,文科一班
1500100951,平彭泽,22,男,文科一班
1500100957,杜易云,21,女,文科一班
1500100973,钮幼南,23,女,文科一班
1500100985,申飞珍,21,女,文科一班
1500100986,左天曼,22,女,文科一班

---

当然还有增删改等操作，以后靓仔将会一一呈现给大家！