直接上干货---------------
1.由于impala的jar包可能无法直接maven下载,所以需要提前准备好jar 我是把jar直接放到nexus上方便pom文件引入
<!-- 驱动包 -->
<dependency>
<groupId>org.apache.impala</groupId>
<artifactId>ImpalaJDBC</artifactId>
<version>2.6.23</version>
</dependency>
<!-- 连接池 -->
<dependency>
<groupId>com.zaxxer</groupId>
<artifactId>HikariCP</artifactId>
</dependency>
2.驱动--- com.cloudera.impala.jdbc41.Driver
3. 进入com.cloudera.impala.jdbc41.Driver类中 确保maven正常识别到jar
4.实际测试
Connection conResult = null;
Connection conCount = null;
@NacosValue(value = "${supplier.impala.jdbc.url}",autoRefreshed = true)
private String jdbcUrl;
@NacosValue(value = "${supplier.impala.jdbc.driver.name}",autoRefreshed = true)
private String jdbcDriver;
public String getStatisData() {
try {
String connectionUrl = jdbcUrl;
String jdbcDriverName = jdbcDriver;
//查询语句
String sqlResult = "select * from 库名.表名";
conResult = DriverManager.getConnection(connectionUrl);
//加载驱动
Class.forName(jdbcDriverName);
Statement stmtResult = conResult.createStatement();
ResultSet rsResult = stmtResult.executeQuery(sqlResult);
while (rsResult.next()) {
//取出每列值
Integer pvCnt = rsResult.getInt("pv_cnt");
}
if(conResult != null){
conResult.close();
}
if(conCount != null){
conCount.close();
}
} catch (Exception e) {
e.printStackTrace();
return null;
}
return "";
}