Java を使用して Hive ベースのデータ ウェアハウス アプリケーションを開発する方法

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

public class HiveConnection {
    private static String driverName = "org.apache.hive.jdbc.HiveDriver";
    private static String connectionUrl = "jdbc:hive2://localhost:10000/default";

    public static void main(String[] args) {
        try {
            Class.forName(driverName);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
            System.exit(1);
        }

        try {
            Connection con = DriverManager.getConnection(connectionUrl, "", "");
            Statement stmt = con.createStatement();
            // 执行Hive查询等操作
            stmt.close();
            con.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

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

public class HiveTable {
    private static String driverName = "org.apache.hive.jdbc.HiveDriver";
    private static String connectionUrl = "jdbc:hive2://localhost:10000/default";

    public static void main(String[] args) {
        try {
            Class.forName(driverName);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
            System.exit(1);
        }

        try {
            Connection con = DriverManager.getConnection(connectionUrl, "", "");
            Statement stmt = con.createStatement();
            // 创建表
            String createTableQuery = "CREATE TABLE IF NOT EXISTS employee (id INT, name STRING, age INT) ROW FORMAT DELIMITED FIELDS TERMINATED BY ','";
            stmt.executeUpdate(createTableQuery);
            System.out.println("Table created.");
            
            // 插入数据
            String insertDataQuery = "INSERT INTO TABLE employee VALUES (1, 'John', 25), (2, 'Jane', 30)";
            stmt.executeUpdate(insertDataQuery);
            System.out.println("Data inserted.");

            stmt.close();
            con.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

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

public class HiveQuery {
    private static String driverName = "org.apache.hive.jdbc.HiveDriver";
    private static String connectionUrl = "jdbc:hive2://localhost:10000/default";

    public static void main(String[] args) {
        try {
            Class.forName(driverName);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
            System.exit(1);
        }

        try {
            Connection con = DriverManager.getConnection(connectionUrl, "", "");
            Statement stmt = con.createStatement();
            // 查询数据
            String query = "SELECT * FROM employee";
            ResultSet result = stmt.executeQuery(query);
            System.out.println("Query result:");

            while (result.next()) {
                System.out.println("ID: " + result.getInt("id") + ", Name: " + result.getString("name") + ", Age: " + result.getInt("age"));
            }

            result.close();
            stmt.close();
            con.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}