impala 连接mysql_impala连接kudu数据库（jdbc）

1.驱动包

https://download.csdn.net/download/u012448904/10663555  也可以在这里下。

owinfo

impalajdbc41

1.0.0

org.apache.hive

hive-jdbc

1.2.1

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.测试