如何使用Java更快地将1200万行从hive表中提取到CSV中？

import java.io.FileWriter;
import java.sql.*;

public class HiveToCSV {
    public static void main(String[] args) {
        String jdbcURL = "jdbc:hive2://localhost:10000/default";
        String username = "your-username";
        String password = "your-password";
        String query = "SELECT * FROM your-table";

        try {
            // 连接到Hive数据库
            Connection connection = DriverManager.getConnection(jdbcURL, username, password);
            Statement statement = connection.createStatement();

            // 执行Hive查询
            ResultSet resultSet = statement.executeQuery(query);

            // 创建CSV文件
            FileWriter csvWriter = new FileWriter("output.csv");

            // 写入CSV文件的标题行
            ResultSetMetaData metaData = resultSet.getMetaData();
            int columnCount = metaData.getColumnCount();
            for (int i = 1; i <= columnCount; i++) {
                csvWriter.append(metaData.getColumnName(i));
                if (i < columnCount) {
                    csvWriter.append(",");
                }
            }
            csvWriter.append("\n");

            // 写入CSV文件的数据行
            while (resultSet.next()) {
                for (int i = 1; i <= columnCount; i++) {
                    csvWriter.append(resultSet.getString(i));
                    if (i < columnCount) {
                        csvWriter.append(",");
                    }
                }
                csvWriter.append("\n");
            }

            // 关闭结果集、数据库连接和CSV文件
            resultSet.close();
            statement.close();
            connection.close();
            csvWriter.close();

            System.out.println("数据提取完成，已保存为CSV文件。");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}