如何在Eclipse中通过Java JDBC连接MapR Sandbox Hive？

Great to hear you've got your MapR Sandbox up and running smoothly! Connecting to Hive via JDBC in Eclipse is totally doable with a few simple steps. Let's walk through this together:

Before diving into code, you'll need one key component:

• The Hive JDBC driver jar from your MapR Sandbox. This is already present on the sandbox itself—no need to download anything external.

1. Log into your MapR Sandbox (either via SSH or the VM console).
2. Navigate to the Hive lib directory—this will look something like /opt/mapr/hive/hive-<your-hive-version>/lib/ (replace <your-hive-version> with the actual version in your sandbox, e.g., hive-2.3.3).
3. Locate the jar file named hive-jdbc-<version>-standalone.jar (the "standalone" version includes all dependencies, which makes things easier).
4. Copy this jar file to your Windows machine (you can use SCP, a shared folder, or just download it via the sandbox's file explorer if you have GUI access).

1. Open Eclipse and create a new Java project (or use an existing one).
2. Right-click on your project → Build Path → Add External Archives.
3. Select the hive-jdbc-<version>-standalone.jar you copied over. This adds the driver to your project's classpath.

Here's a complete, tested code snippet to connect to your Hive instance and run a sample query:

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

public class HiveJdbcConnector {
    public static void main(String[] args) {
        // Hive JDBC driver class name
        String driverName = "org.apache.hive.jdbc.HiveDriver";
        // Connection URL: jdbc:hive2://<sandbox-ip>:<port>/<database-name>
        // Default HiveServer2 port is 10000, default database is 'default'
        String connectionUrl = "jdbc:hive2://192.168.206.130:10000/default";
        // MapR Sandbox typically uses 'mapr' as the default user (no password needed for sandbox)
        String user = "mapr";
        String password = "";

        try {
            // Load the Hive JDBC driver
            Class.forName(driverName);
            // Establish the connection
            Connection conn = DriverManager.getConnection(connectionUrl, user, password);
            // Create a statement to execute queries
            Statement stmt = conn.createStatement();

            // Example query: Show all databases
            String query = "SHOW DATABASES";
            System.out.println("Running query: " + query);
            ResultSet rs = stmt.executeQuery(query);

            // Print the results
            while (rs.next()) {
                System.out.println(rs.getString(1));
            }

            // Clean up resources
            rs.close();
            stmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

• Network Connectivity: Make sure your Windows machine can ping 192.168.206.130. If not, check your VM's network settings (it should be in bridged or NAT mode that allows communication with your host).
• HiveServer2 Status: On the MapR Sandbox, run ps aux | grep HiveServer2 to confirm that HiveServer2 is running. If it's not, start it with maprcli node services -name hiveserver2 -action start -nodes <sandbox-hostname>.
• Port Access: Ensure port 10000 (the default HiveServer2 port) isn't blocked by your Windows firewall or the sandbox's firewall. You can test this with telnet 192.168.206.130 10000 from Windows—if it connects, the port is open.

内容的提问来源于stack exchange，提问作者Hussein Hazimeh