a) No SASL (plain, insecure – test only) jdbc:hive2://host:10000/default;auth=noSasl Use empty user/pass. b) Kerberos (production, secure) jdbc:hive2://host:10000/default;principal=hive/_HOST@REALM.COM Java side:
Always match hive-jdbc version with your server’s Hive version, and test first with beeline . hive server address java
Here’s a full, step‑by‑step guide to working with – covering connection URLs, configuration, authentication, and code examples. 1. Hive Server Address Formats a) Hive Server 2 (HS2) – Default since Hive 0.11 HS2 supports multiple clients, including JDBC (Java). a) No SASL (plain, insecure – test only)
// No username/password required with auth=noSasl try (Connection conn = DriverManager.getConnection(jdbcUrl, "", ""); Statement stmt = conn.createStatement()) String sql = "SHOW TABLES"; ResultSet rs = stmt.executeQuery(sql); while (rs.next()) System.out.println(rs.getString(1)); ResultSet rs = stmt.executeQuery(sql)
<dependency> <groupId>org.apache.hive</groupId> <artifactId>hive-jdbc</artifactId> <version>3.1.3</version> <!-- Use your Hive version --> </dependency>
import java.sql.*; public class HiveJdbcClient public static void main(String[] args) throws Exception // Hive server address (HS2) String jdbcUrl = "jdbc:hive2://192.168.1.100:10000/default;auth=noSasl";
implementation 'org.apache.hive:hive-jdbc:3.1.3' hive-jdbc pulls Hadoop & Hive dependencies – make sure versions match your server. 4. Full Java Connection Example (No Authentication) For development clusters without Kerberos/LDAP: