jdbc连接hive（hiveserver2，spark thriftserver）

hiveserver2，spark thriftserver两者连接的代码是一样的，区别在于启动的服务不一样

import java.sql.*;

/**
 * Created by zheng on 2020/4/9.
 */
public class HiveClient {
    public static void main(String[] args) throws SQLException {
        try {
            Class.forName("org.apache.hive.jdbc.HiveDriver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
            System.exit(1);
        }
        Connection con = DriverManager.getConnection("jdbc:hive2://localhost:10000/default", "zheng", "");
        Statement stmt = con.createStatement();
        ResultSet resultSet = stmt.executeQuery("show databases" );
        System.out.println(resultSet.toString());
    }
}

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

发现连接不上，原因是没有启动hiveserver2（spark thriftserver）服务

#启动hivever2
$ /hive-3.1.2/bin
$ hiveserver2

#启动spark thriftserver
$ cd /spark-3.0.0/sbin/
$ ./start-thriftserver.sh

另开一个窗口执行：beeline

启动后访问http://localhost:10002/

启动如果还是报错，参考：https://blog.csdn.net/zheng911209/article/details/105422908