IDEA使用JDBC连接Hive数据库代码

一、导包

详细步骤：http://t.csdn.cn/1768C

打开idea，创建maven项目，点击pom.xml

1.导入mysql包

打开链接：https://mvnrepository.com/artifact/mysql/mysql-connector-java/5.1.46

进入时会比较缓慢，稍等一下就好，进入下面页面

 2.导入hadoop-common包

打开链接：https://mvnrepository.com/artifact/org.apache.hadoop/hadoop-common/2.7.3

 

3.导入hadoop-core

打开链接： https://mvnrepository.com/artifact/org.apache.hadoop/hadoop-core/1.2.1

4.导入hive-jdbc包

打开链接：https://mvnrepository.com/artifact/org.apache.hive/hive-jdbc/2.1.0 

 

 

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>org.example</groupId>
    <artifactId>0409</artifactId>
    <version>1.0-SNAPSHOT</version>

    <properties>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
    </properties>

<!--    把刚才代码放在这里-->
    <dependencies>
        <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.46</version>
        </dependency>

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

    </dependencies>


</project>

导入一下，导入成功是有显示的

 

二、连接hive数据库

• 创建一个类，连接hive

package ch1;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

//Java调用Hive
public class HiveDemo {
    public static void main(String[] args) {
        getConnection();
    }

    //获取连接
    public static Connection getConnection(){
        //第一步 加载驱动
        try {
            Class.forName("org.apache.hive.jdbc.HiveDriver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        //第二步 获取连接
        try {
            DriverManager.getConnection("jdbc:hive2://192.168.171.151:10000","root","123456");
            //输出连接
            System.out.println("连接成功");
        } catch (SQLException e) {
            e.printStackTrace();
            System.out.println("连接失败");
        }
        return null;

    }

}

运行结果：