Jdbc连接Hive

来源：互联网发布：张善政知乎编辑：程序博客网时间：2024/05/01 14:17

1.启动hive 服务

./hive --service hiveserver &

2.创建hive程序

package hive;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class TestHive02 {private static String driverName = "org.apache.hadoop.hive.jdbc.HiveDriver";/** * @param args * @throws SQLException */public static void main(String[] args) throws SQLException {try {Class.forName(driverName);} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();System.exit(1);}Connection con = DriverManager.getConnection("jdbc:hive://192.168.213.5:10000/defalt", "", "");Statement stmt = con.createStatement();// delstmt.executeQuery("drop table test");// createstmt.executeQuery("create table if not exists test(amount DOUBLE, st_name string) "+ "ROW FORMAT DELIMITED "+ "FIELDS TERMINATED BY ' ' "+ "STORED AS TEXTFILE");// loadstmt.executeQuery("load data local inpath '/home/test.txt' into table test");// start timelong st = System.currentTimeMillis();// runResultSet res = stmt.executeQuery("select st_name,sum(amount) c from test group by st_name  sort by c");// countint i = 0;// forwhile (res.next()) {i++;// data out print}// end timelong en = System.currentTimeMillis();// start - end = runtimeSystem.out.println("总耗时：" + (en - st) + "，记录总数：" + i);}}

3.此连接需要导入的jar包

0 0