用hive连接mysql是

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

public class HiveMySQLConnector {
    public static void main(String[] args) {
        try {
            // 加载 Hive JDBC 驱动
            Class.forName("org.apache.hive.jdbc.HiveDriver");
            // 连接 Hive 数据库
            Connection hiveConn = DriverManager.getConnection("jdbc:hive2://localhost:10000/default", "hiveuser", "hivepassword");

            // 加载 MySQL JDBC 驱动
            Class.forName("com.mysql.jdbc.Driver");
            // 连接 MySQL 数据库
            Connection mysqlConn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "mysqluser", "mysqlpassword");

            // 创建 Hive 语句
            Statement hiveStmt = hiveConn.createStatement();
            // 创建 MySQL 语句
            Statement mysqlStmt = mysqlConn.createStatement();

            // 执行 Hive 查询
            ResultSet hiveRs = hiveStmt.executeQuery("SELECT * FROM mytable");
            while (hiveRs.next()) {
                System.out.println(hiveRs.getString(1));
            }

            // 执行 MySQL 查询
            ResultSet mysqlRs = mysqlStmt.executeQuery("SELECT * FROM mytable");
            while (mysqlRs.next()) {
                System.out.println(mysqlRs.getString(1));
            }

            // 关闭连接
            hiveRs.close();
            mysqlRs.close();
            hiveStmt.close();
            mysqlStmt.close();
            hiveConn.close();
            mysqlConn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}