进入下面目录

cd /root/soft/hive-1.2.1/bin
[root@zjj101 bin]# hiveserver2

运行完了就卡在这里了, 因为hiveserver2是一个前台进程.

jdbc客户端连接

pom 依赖

<dependencies>
        <dependency>
            <groupId>org.apache.logging.log4j</groupId>
            <artifactId>log4j-core</artifactId>
            <version>2.8.2</version>
        </dependency>
        <dependency>
            <groupId>org.apache.hadoop</groupId>
            <artifactId>hadoop-common</artifactId>
            <version>2.7.2</version>
        </dependency>
        <dependency>
            <groupId>org.apache.hadoop</groupId>
            <artifactId>hadoop-client</artifactId>
            <version>2.7.2</version>
        </dependency>
        <dependency>
            <groupId>org.apache.hadoop</groupId>
            <artifactId>hadoop-hdfs</artifactId>
            <version>2.7.2</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/org.apache.hive/hive-jdbc -->
        <dependency>
            <groupId>org.apache.hive</groupId>
            <artifactId>hive-jdbc</artifactId>
            <version>1.2.1</version>
        </dependency>
        <!-- <dependency> <groupId>jdk.tools</groupId> <artifactId>jdk.tools</artifactId> 
            <version>1.8</version> <scope>system</scope> <systemPath>C:\Program Files\Java\jdk1.8.0_121\lib\tools.jar</systemPath> 
            </dependency> -->
    </dependencies>

Java代码

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
/**
 * hive  的 jdbc驱动
 */
public class HiveJdbc {
    public static void main(String[] args) throws Exception {
        //①加载驱动
        //Class.forName("org.apache.hive.jdbc.HiveDriver");
        //②创建连接  ,端口号固定是10000
        //用户名 密码
        Connection connection = DriverManager.getConnection("jdbc:hive2://ip:10000", "root", "root");
        // ③准备SQL , 访问default数据库的student,前提是有这个表,不然的话会报错
        String sql = "select * from default.student";
        // ④预编译sql
        PreparedStatement ps = connection.prepareStatement(sql);
        // ⑤执行sql
        ResultSet resultSet = ps.executeQuery();
        while (resultSet.next()) {
            System.out.println("name:" + resultSet.getString("name") + "---->age:" +
                    resultSet.getInt("age"));
        }
    }
}

控制台结果

你代码每连接一次,控制台就会出现这个东西.