没有kerberos认证的hive链接比较方便,但是有kerberos认证就需要多做一些事情。
1、pom.xml 依赖:
org.apache.hive
hive-jdbc
0.12.0
org.apache.hadoop
hadoop-client
2.7.2
2、示例代码:(标黄的需要认真修改)
import org.apache.hadoop.conf.Configuration;
import org.apache.hadoop.security.UserGroupInformation;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class App {
private static String JDBC_DRIVER = "org.apache.hive.jdbc.HiveDriver";
private static String CONNECTION_URL ="jdbc:hive2://10.23.13.196:10000/ods;principal=hive/tw-manager@TDH";
static {
try {
Class.forName(JDBC_DRIVER);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}