Java通过JDBC操作Hive指南-优快云博客

本文链接：https://blog.youkuaiyun.com/flysun3344/article/details/62217390

这篇博客详细介绍了如何在Java程序中使用JDBC连接并访问Hive数据库，包括了引入必要的JAR依赖和具体的代码实现步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一：首先引入所需要的JAR包

<hive-jdbc.version>0.11.0</hive-jdbc.version>
<hadoop-common.version>2.2.0</hadoop-common.version>

<!-- Hive -->
		<dependency>
			<groupId>org.apache.hive</groupId>
			<artifactId>hive-jdbc</artifactId>
			<version>${hive-jdbc.version}</version>
		</dependency>
		<dependency>
			<groupId>org.apache.hadoop</groupId>
			<artifactId>hadoop-common</artifactId>
			<version>${hadoop-common.version}</version>
		</dependency>

二：程序访问：

public class HiveJDBCUtil {

    private static String driverName = "org.apache.hive.jdbc.HiveDriver";
    private static String url = "jdbc:hive2://ip地址:10000/tandem;?mapreduce.job.queuename=default";
    private static String name = "";
    private static String password = "";
    private static final Logger Log = Logger.getLogger(HiveJDBCUtil.class);

    public static void main(String[] args) {
        try {
            Class.forName(driverName);
            Connection conn = DriverManager.getConnection(url, name, password);
            Statement statement = conn.createStatement();
            String sql = "show tables";
            ResultSet rs = statement.executeQuery(sql);
            while(rs.next()) {
                System.out.println(rs.getString(1));
            }
        } catch (ClassNotFoundException e) {
            
            e.printStackTrace();
        }
        catch (SQLException e) {
            e.printStackTrace();
        }

    }