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";
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: hive server address java
<dependency> <groupId>org.apache.hive</groupId> <artifactId>hive-jdbc</artifactId> <version>3.1.3</version> <!-- Use your Hive version --> </dependency> import java
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: a) No SASL (plain
Use beeline (Hive’s JDBC client) to validate your address: