impala jdbc怎么配置

本篇内容主要讲解"impala jdbc怎么配置"，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习"impala jdbc怎么配置"吧!

1 看官网jdbc 配置

需要的包，可以从CDH中组件拷贝

commons-logging-X.X.X.jarhadoop-common.jarhive-common-X.XX.X-cdhX.X.X.jarhive-jdbc-X.XX.X-cdhX.X.X.jarhive-metastore-X.XX.X-cdhX.X.X.jarhive-service-X.XX.X-cdhX.X.X.jarhttpclient-X.X.X.jarhttpcore-X.X.X.jarlibfb303-X.X.X.jarlibthrift-X.X.X.jarlog4j-X.X.XX.jarslf4j-api-X.X.X.jarslf4j-logXjXX-X.X.X.jar

3 例子

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement; public class ClouderaImpalaJdbcExample {     // here is an example query based on one of the Hue Beeswax sample tables     private static final String SQL_STATEMENT = "SELECT a FROM test limit 10";     // set the impalad host    private static final String IMPALAD_HOST = "192.168.1.106";     // port 21050 is the default impalad JDBC port     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()) {                // the example query returns one String column                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) {                // swallow            }        }    }}

到此，相信大家对"impala jdbc怎么配置"有了更深的了解，不妨来实际操作一番吧！这里是网站，更多相关内容可以进入相关频道进行查询，关注我们，继续学习！