Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to configure impala jdbc". Friends who are interested might as well take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to configure impala jdbc.

1 see the jdbc configuration on the official website

The required package can be copied from the components in 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 exampl

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 ("\ nneighbor = 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} at this point, I believe you have a deeper understanding of "how to configure impala jdbc". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.