使用jdbc方式连接星环科技云平台TDC中的inceptor数据库
大数据数据库inceptor开启Kerberos安全认证方式;
登陆时使用token令牌方式登录
token串写在这里
import java.sql.*;
public class test2 {
private static String driverName = "io.transwarp.jdbc.InceptorDriver";
public static void main(String[] args) throws SQLException {
try {
Class.forName(driverName);
} catch (ClassNotFoundException e) {
e.printStackTrace();
System.exit(1);
}
Connection conn = DriverManager.getConnection("jdbc:hive2://172.17.148.189:31326/;guardianToken=1Mmc34AY4Kav3fYHyq5Z-M8IUIMT.TDH");
System.out.println("连接成功");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("show databases");
ResultSetMetaData rsmd = rs.getMetaData();
int size = rsmd.getColumnCount();
while (rs.next()) {
StringBuffer value = new StringBuffer();
for (int i = 0; i < size; i++) {
value.append(rs.getString(i + 1)).append("\t");
}
System.out.println(value.toString());
}
rs.close();
stmt.close();
conn.close();
}
}
使用的驱动包,直接import 导入jar包即可