java链接hive

最新推荐文章于 2024-08-05 20:59:55 发布

@进行中

最新推荐文章于 2024-08-05 20:59:55 发布

阅读量1.1k

点赞数

分类专栏： hive 文章标签： hive

本文链接：https://blog.csdn.net/lu1171901273/article/details/89363005

版权

hive 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

首先引入jar文件，最好是使用idea开发工具，因为他写dependency有提示

<dependency>
        <groupId>org.apache.hive</groupId>
        <artifactId>hive-jdbc</artifactId>
        <version>1.2.1</version>
</dependency>

编写程序

package com.bonc.audit.home.action;

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

public class test {
	private static String driverName = "org.apache.hive.jdbc.HiveDriver";
	public static void main(String[] args) throws Exception {
		try{
			Class.forName(driverName);
		}catch(Exception e){
			e.printStackTrace();
		}
		String url = "jdbc:hive2://192.168.124.140:10000/default";
		String user = "root";
		String password = "luxing";
		Connection con = DriverManager.getConnection(url, user, password);
		Statement stmt = con.createStatement();
		String sql = "select * from student";
		ResultSet res = stmt.executeQuery(sql);
		if(res.next()){
			System.out.println(res.getString(1));
		}
	}
}

首先要启动hdfs和hive

再运行报错

Exception in thread "main" java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://192.168.124.140:10000/default: java.net.ConnectException: Connection refused: connect

这个是因为hive中的hiveServer2没有启动起来,启动的命令是: hive --service hiveserver2

再执行会报错