1.驱动包
https://download.csdn.net/download/u012448904/10663555 也可以在这里下。
<!--可以去官网下载-->
<dependency>
<groupId>owinfo</groupId>
<artifactId>impalajdbc41</artifactId>
<version>1.0.0</version>
</dependency>
<!--驱动-->
<dependency>
<groupId>org.apache.hive</groupId>
<artifactId>hive-jdbc</artifactId>
<version>1.2.1</version>
</dependency>
2.jdbc
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class testmain {
static String JDBC_DRIVER = "org.apache.hive.jdbc.HiveDriver";
static String CONNECTION_URL = "jdbc:impala://192.168.6.173:21050/bjs_db";//bjs_db为数据库名
public static void main(String[] args)
{
Connection con = null;
ResultSet rs = null;
PreparedStatement ps = null;
try
{
Class.forName(JDBC_DRIVER);
con = DriverManager.getConnection(CONNECTION_URL);
ps = con.prepareStatement("SELECT * FROM arrival_head");
rs = ps.executeQuery();
while (rs.next())
{
//kudu数据库的字段
System.out.println(rs.getString("i_e_flag")+","+rs.getString("arrival_no"));
}
} catch (Exception e)
{
e.printStackTrace();
} finally
{
//关闭rs、ps和con
}
}
}
3.测试