下载依赖包:https://downloads.cloudera.com/impala-jdbc/impala-jdbc-0.5-2.zip
将解压后的jar包拷贝到提供JDBC服务的Impalad node上,/usr/lib/impala/lib/
package impala; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class ImpalaJDBC { private static final String SQL_STATEMENT = "SELECT key,bucketname FROM ddd limit 10"; private static final String IMPALAD_HOST = "dasp06"; private static final String IMPALAD_JDBC_PORT = "21050"; private static final String CONNECTION_URL = "jdbc:hive2://" + IMPALAD_HOST + ':' + IMPALAD_JDBC_PORT + "/;auth=noSasl"; private static final String JDBC_DRIVER_NAME = "org.apache.hive.jdbc.HiveDriver"; public static void main(String[] args) { System.out.println("\n============================================="); System.out.println("Cloudera Impala JDBC Example"); System.out.println("Using Connection URL: " + CONNECTION_URL); System.out.println("Running Query: " + SQL_STATEMENT); Connection con = null; try { Class.forName(JDBC_DRIVER_NAME); con = DriverManager.getConnection(CONNECTION_URL); Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery(SQL_STATEMENT); System.out.println("\n== Begin Query Results ======================"); // print the results to the console while (rs.next()) { System.out.println(rs.getString(1)); } System.out.println("== End Query Results =======================\n\n"); } catch (SQLException e) { e.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } finally { try { con.close(); } catch (Exception e) { } } } }
=============================================
Cloudera Impala JDBC Example
Using Connection URL: jdbc:hive2://dasp06:21050/;auth=noSasl
Running Query: SELECT key,bucketname FROM ddd limit 10
== Begin Query Results ======================
13400000064_1388056783_460095106148962
13400000144_1387531071_460606566970889
13400000176_1387214311_460437075415459
13400000384_1387015021_460869851976295
13400000471_1388065887_460594566346749
13400000592_1387018632_460687636760504
13400000838_1387181839_460737051018638
13400000878_1387741971_460459270379452
13400000883_1387740711_460129445054201
13400000895_1387244628_460053319101762
== End Query Results =======================
相关推荐
jdbc 连接impala或者jdbc连接hive所需的jar包。
简单的代码,采用JDBC连接Impala。内容有需要的lib包和一个TestImpala.java的类。需要自己创建一个java工程,并导入包运行。
博客中所需jar包,提供下载。java通过jdbc连接impala的方式之一
一直在网上找不到impalajdbc的pom依赖,项目是maven的,所以整理了所用的pom
使用JDBC连接impala数据库所用jar包,jdbc驱动版本4.0 com.cloudera.impala.jdbc4.Driver。内含JDBC连接impala数据库dome
使用JDBC连接Impala数据库所用的jar包,JDBC41驱动,Impala 2.5.43版本,亲测可正常连接impala数据库
dbeaver中连接impala所需jdbc包,适用于CDH5.16.2,impala2.12
用于JDBC连接Impala的工具包
ImpalaJDBC驱动包,用于Impala数据库连接,Maven配置所需的jar包
简单的代码,采用JDBC连接Impala。内容有需要的lib包。需要自己创建一个java工程,并导入包运行。
Cloudera JDBC Driver for Impala ,jdbc连接cdh impala 官方驱动
连接impala的两种jdbc方式:hive jdbc\impala jdbc ,所需的jar包,包括ImpalaJDBC41.jar、hive-jdbc-1.1.0.jar
Impala 驱动包 Cloudera_ImpalaJDBC4_2.5.41.zip Cloudera_ImpalaJDBC41_2.5.41.zip Cloudera-JDBC-Driver-for-Impala-Install-Guide.pdf Cloudera-JDBC-Driver-for-Impala-Release-Notes.pdf
包括 ImpalaJDBC3 ImpalaJDBC4 ImpalaJDBC41 三个版本的ImpalaJDBC连接所需Jar
impala 的jdbc 驱动,可以使用写java的方式连接impala.
impala jdbc driver 2.6.3.1004 - 2018.07.06 java利用jdbc方式连接impala所需要的驱动jar包。
Hadoop Impala connect hive2 jdbc related Hadoop Impala connect hive2 jdbc related
impala的驱动包,可支持impala组件通过jdbc连接hadoop
impala连接,可用于impala JDBC的driver,可用上传到本地maven私服,直接使用
Java_通过_JDBC_分别采用混合验证模式和_Windows_身份验证模式连接_SQL_Server_2008_或_2005_的连接实例