hive java 的demo

来源：互联网发布：企业资本净额知乎编辑：程序博客网时间：2024/06/11 07:48

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

导入hive 下所有包

linux 下启动您的Hive:

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

Hive 连接

 1 package hadoop.demo.hive; 2  3 import java.sql.Connection; 4 import java.sql.DriverManager; 5 import java.sql.SQLException; 6  7 public class getConnect { 8     private static Connection conn = null; 9     private static Connection connToMysql = null;10 11     private getConnect() {12     }13 14     // 获得hive连接15     public static Connection GetHiveConn() throws SQLException {16         if (conn == null) {17             try {18                 Class.forName("org.apache.hadoop.hive.jdbc.HiveDriver");19             } catch (ClassNotFoundException e) {20 21                 e.printStackTrace();22                 System.exit(1);23             }24             conn = DriverManager.getConnection(25                     "jdbc:hive://Ip:50031/default", "", "");26         }27         return conn;28     }29 30     // 获得sql连接31     public static Connection getMySqlConn() throws SQLException {32         if (connToMysql == null) {33             try {34                 Class.forName("com.mysql.jdbc.Driver");35             } catch (ClassNotFoundException e) {36 37                 e.printStackTrace();38                 System.exit(1);39             }40             connToMysql = DriverManager.getConnection(41                     "jdbc:mysql://ip:3306/hive", "junjun", "123456");42         }43         return connToMysql;44     }45 46     public static void closeHive() throws SQLException {47         if (conn != null) {48             conn.close();49         }50     }51 52     public static void closeMysql() throws SQLException {53         if (connToMysql != null) {54             connToMysql.close();55         }56     }57 }

Hive工具类

 1 package hadoop.demo.hive; 2  3 import java.sql.Connection; 4 import java.sql.ResultSet; 5 import java.sql.SQLException; 6 import java.sql.Statement; 7  8 /** 9  * Hive工具类10  * 11  * @author xiaoyun.zhao12  * 13  */14 public class HiveUtil {15     public static void createTable() {16     }17 18     public static ResultSet queryHive(String hql) throws SQLException {19         Connection conn = getConnect.GetHiveConn();20         Statement stmt = conn.createStatement();21         ResultSet rs = stmt.executeQuery(hql);22         return rs;23     }24 }

测试函数

 1 package hadoop.demo.hive; 2  3 import java.sql.ResultSet; 4  5 public class HiveMain { 6  7     public static void main(String[] args) throws Exception { 8  9         ResultSet res = HiveUtil.queryHive("select * from pokes");10 11         while (res.next()) {12             System.out.println("Result: key:" + res.getString(1)13                     + "  –>  value:" + res.getString(1));14         }15     }16 }

0 0